A daily cash book has four numbers for every day: opening cash, money received, money paid out and closing cash. Closing cash is opening plus receipts minus payments, and tomorrow's opening is today's closing. Once a week, count the real notes and coins and compare them with the book. Any gap shows up early, while you can still remember what happened.
What does the layout look like?
Keep two parts: an entries list where you write every cash movement as it happens, and a daily summary that adds them up. For the entries list, use columns A Date, B Particulars, C Receipt, D Payment. For the summary, use A Date, B Opening, C Receipts, D Payments, E Closing.
Only cash goes in this book, whether it is a weekend stall, a tiffin service or a small repair job. A UPI payment goes to your bank, not your pocket, so track it separately. If you move cash to the bank, record it as a payment in the cash book, since the cash has left your hand.
What does a few days look like?
Say someone runs a weekend snack stall. These numbers are made up.
| Day | Opening | Receipts | Payments | Closing |
|---|---|---|---|---|
| Saturday | ₹2,000 | ₹3,450 | ₹1,280 | ₹4,170 |
| Sunday | ₹4,170 | ₹4,100 | ₹1,650 | ₹6,620 |
| Monday | ₹6,620 | ₹0 | ₹5,000 | ₹1,620 |
Saturday's closing is ₹2,000 plus ₹3,450 minus ₹1,280, which is ₹4,170. Sunday's is ₹4,170 plus ₹4,100 minus ₹1,650, which is ₹6,620. On Monday, ₹5,000 went to the bank, so closing is ₹6,620 minus ₹5,000, which is ₹1,620.
Which formulas keep the summary honest?
Let the summary calculate itself so you only type in the entries list. With the date in A2 of the summary:
- Receipts, in C2: =SUMIFS(Entries!$C$2:$C$1000,Entries!$A$2:$A$1000,$A2)
- Payments, in D2: =SUMIFS(Entries!$D$2:$D$1000,Entries!$A$2:$A$1000,$A2)
- Closing, in E2: =B2+C2-D2
- Next day's opening, in B3: =E2
Type the very first opening balance by hand. Everything after that flows from the entries. Use the same date format everywhere, because a date typed as text will not be picked up by SUMIFS, and the day will quietly show zero receipts. If a day has no entries, still keep its row, so the opening balance carries forward without a break.
How do I check the book against the actual cash?
Once a week, ideally at the same time, count the cash in hand and write it in a Counted column. Subtract the book's closing from the count. If the book says ₹4,170 and you count ₹4,100, the gap is -₹70.
Do not quietly adjust the book to match. Add a line called Cash difference for -₹70 in the payments column, so the book agrees with the cash, and the gap stays visible. If differences keep appearing, look for small unrecorded spends, wrong change handed out, or money taken for personal use and not written down.
What about big payments or advances?
- Advance from a customer: record it as a receipt with the customer's name, and note that the work is still owed.
- Loan from a family member for stock: record it as a receipt too, but mark it as a loan so it is not mistaken for sales.
- Supplier payment made partly in cash and partly by UPI: write only the cash part in this book.
When does a sheet stop being enough?
If your cash business also has regular bank spends for supplies or rent, you can upload the bank statement into SpendixAI, review the rows before saving, and keep categories alongside. Cash spends can be added by hand there as well. The daily cash book still has the job of showing opening and closing cash.
A habit that works
- Write each entry when it happens, or at the latest before you sleep.
- Close the day: add receipts, subtract payments, write closing cash.
- Keep bills and chits in an envelope for the week.
- On the same weekday every week, count the cash and compare.
- At month end, total receipts and payments and compare with your sales and purchase records.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


