Income and work

A drawings register for family members who draw from the business

A drawings register for family members who take money from the business: the columns to keep, a monthly total per person using SUMIFS, and agreed rules.

Editorial illustration for A drawings register for family members who draw from the business

A drawings register records every time a family member takes money out of the business: the date, who took it, the amount and the purpose. A monthly total per member then shows who drew how much. It is a records sheet, and what the drawings mean for tax or partnership accounts is a question for your CA.

What columns does the register need?

ColumnHeaderWhat goes in it
ADateDay the money was taken
BWhoThe family member's name, spelt the same way every time
CAmountRupees, as a number
DPurposeHousehold, school fees, medical, personal, other
EModeCash, UPI or bank transfer

Use the same spelling for each name. SUMIFS will treat Ravi and Ravi K as two different people, and your totals will quietly be wrong.

A made-up month of entries

  • 3 March, Father, ₹10,000, household, cash.
  • 10 March, Ravi, ₹4,500, school fees, UPI.
  • 17 March, Father, ₹10,000, household, cash.
  • 24 March, Meena, ₹3,000, personal, UPI.
  • 28 March, Ravi, ₹6,000, scooter repair, UPI.

Father drew 10,000 + 10,000 = ₹20,000, Ravi drew 4,500 + 6,000 = ₹10,500 and Meena drew ₹3,000. The month's total is 20,000 + 10,500 + 3,000 = ₹33,500. These figures are invented.

How do I get the monthly total per member?

On a summary tab, put the first of the month in G2 as a real date, such as 1-Mar-2026, and the member's name in H1. Then in H2 enter =SUMIFS($C$2:$C$500,$B$2:$B$500,H$1,$A$2:$A$500,">="&$G2,$A$2:$A$500,"<"&EDATE($G2,1)). Copy it across for each member and down for each month. The dollar signs keep the ranges fixed while the month and name move. For the month's grand total, use =SUM(H2:J2). Both Excel and Google Sheets accept this.

MemberMarch total (₹)
Father20,000
Ravi10,500
Meena3,000
All members33,500

What rules should the family agree?

  1. A monthly amount or a ceiling for each person, written down.
  2. Who may take money, and who writes the entry.
  3. That every withdrawal is entered the same day.
  4. Where large or one-off needs, such as a wedding or a repair, are discussed first.
  5. When the register is reviewed together, such as the first Sunday of the month.

Add a yearly view once the monthly tab works. List the twelve months from April to March down the side and the members across the top, using the same formula with the month in column G. Summing each column gives a member-wise total for the financial year, and summing each row shows which months were heavy. Festival months and school-fee months usually stand out, and seeing that pattern helps the family agree on limits calmly before the next April rather than argue after the money has gone.

How does it connect to household tracking?

When the money reaches a personal account, SpendixAI can import that account's statement and you can label the credit as drawings or business income, then categorise what the household does with it. The register itself stays in your sheet, as the app does not do business accounting or partnership books.

Add a cap check. Put each member's agreed monthly limit in a cell, say ₹20,000 for Father in K2, and compare it with the month's total in H2 using =IF(H2>K2,"Over","OK"). In our example Father drew exactly ₹20,000, so the cell says OK, while a limit of ₹15,000 for Ravi against ₹10,500 also says OK. The check does not stop anyone; it simply makes the conversation factual instead of personal.

How do I keep the register honest?

  • Match the monthly total against the withdrawals on the bank statement.
  • Mark cash withdrawals clearly, since they leave the weakest trail.
  • Do not edit old rows; add a correcting row.
  • Keep a yearly copy, and let your CA see it once a year.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports