The rule that keeps shop money and house money apart is simple: take a fixed drawing at a fixed time, write it down, and take nothing else from the till. A daily till sheet then shows whether the cash in the drawer matches what should be there. Ad-hoc withdrawals are the thing that makes a shop look like it earns less than it does.
Why do ad-hoc withdrawals cause trouble?
A hundred here for vegetables, five hundred there for the school bus, and a sudden thousand for a relative: each feels small, and none is recorded. At the month's end the till is short, the shop seems unprofitable, and the household feels it has no money, even though both have the same cash. Pulling money out without a trace removes your ability to see either side.
How do I set the drawing?
- Look at what the household needed last month from its own records: rent, school fees, groceries, medicines.
- Decide a fixed amount to draw, for example ₹5,000 every Sunday evening.
- Pick one person to take it, and write it in the drawings page the same minute.
- Move it to the household account or wallet so it is no longer in the till.
- Review the amount each quarter against what the house actually spent.
What does a daily till sheet look like?
One line per day with these columns: opening cash, cash sales, cash paid to suppliers, small shop expenses, drawing, expected closing, counted closing and difference. Sales received by UPI go to the shop's bank account, so they are not in the drawer. The expected closing is opening plus cash sales minus the three outflows.
| Line | Amount (₹) |
|---|---|
| Opening cash | 5,000 |
| Cash sales | 18,400 |
| Cash paid to suppliers | 6,200 |
| Small shop expenses (tea, packing) | 450 |
| Drawing today | 0 |
| Expected closing | 16,750 |
| Counted closing | 16,700 |
| Difference | −50 |
The arithmetic is 5,000 + 18,400 − 6,200 − 450 − 0 = ₹16,750. Counting ₹16,700 leaves a ₹50 shortage. That is a normal small gap on a busy day, and writing it down is better than ignoring it. In a sheet, with the columns in B to F, expected closing is =B2+C2-D2-E2-F2 and the difference is =G2-H2 if counted closing is in H.
How do I keep the house side visible?
Treat the weekly drawing as the household's income from the shop. If the household tracks personal spending in SpendixAI, the drawing arrives in the household account as a credit you can label, and the groceries, fees and bills are categorised as usual. It is not a shop accounting tool, and it does not do invoicing or GST filing, so shop sales and purchases belong in your own books and with your CA.
Keep the household's money flow to a single transfer. On the fixed day, move the drawing from the shop's bank account to the household account in one transfer and note it in the drawings page. If the family uses the shop's UPI QR code for a personal purchase, that is a drawing too; enter it so the till and the account both tell the truth. One transfer a week is much easier to reconcile than twenty small ones.
What should we review each month?
- Total of drawings against what the household spent.
- Number of days with a till difference, and the size of the largest.
- Any cash taken without a written drawing.
- Whether the fixed amount still fits school fees, festivals and medical costs coming up.
Once the habit is built, both sides get a clearer answer to the question families dread: is the shop doing well, and is the house living within it?
Useful ideas start with a clearer picture of your own spending.
Explore your reports


