This is a full week of cash book entries for a small stationery shop, with the opening and closing balance for each day and a Sunday count against the till. All figures are made up for practice, so change them to match your own shop and copy only the method.
The starting point
The shop opens on Monday with ₹6,000 in the till. It is open Monday to Saturday, and the owner counts the drawer on Sunday. Entries are made as they happen: cash sales as a day total, and each payment as its own line.
The week, day by day
| Day | Opening (₹) | Receipts (₹) | Payments (₹) | Closing (₹) | What happened |
|---|---|---|---|---|---|
| Mon | 6,000 | 4,200 | 1,500 | 8,700 | Cash sales; paid a paper supplier ₹1,500 |
| Tue | 8,700 | 3,600 | 250 | 12,050 | Cash sales; tea and courier ₹250 |
| Wed | 12,050 | 5,100 | 10,000 | 7,150 | Cash sales; ₹10,000 deposited in bank |
| Thu | 7,150 | 3,900 | 1,000 | 10,050 | Cash sales; ₹1,000 advance to the helper |
| Fri | 10,050 | 4,800 | 4,500 | 10,350 | Supplier ₹2,500; owner withdrawal ₹2,000 |
| Sat | 10,350 | 7,300 | 12,000 | 5,650 | Busy day; ₹12,000 deposited in bank |
Check any row by hand: Wednesday is ₹12,050 + ₹5,100 - ₹10,000 = ₹7,150. Because each closing figure becomes the next opening figure, one slip early in the week spoils every row below it.
What do the weekly totals prove?
Receipts for the week are ₹4,200 + ₹3,600 + ₹5,100 + ₹3,900 + ₹4,800 + ₹7,300 = ₹28,900. Payments are ₹1,500 + ₹250 + ₹10,000 + ₹1,000 + ₹4,500 + ₹12,000 = ₹29,250. Opening ₹6,000 plus ₹28,900 minus ₹29,250 gives ₹5,650, matching Saturday's closing. This second route to the same number is the cheapest way to catch addition mistakes.
Notice that the ₹10,000 and ₹12,000 deposits are payments in this book but are not expenses. They are cash moving to the bank, and the bank statement will show them as credits. Likewise the ₹2,000 on Friday is the owner taking money out, not a shop cost. Keep both out of your profit working.
What should the Sunday till check look like?
On Sunday, the shop is shut, so count the drawer with nobody interrupting. Say the notes and coins add up to ₹5,600. The book says ₹5,650, so the till is ₹50 short.
- Recount the cash once more, note by note.
- Check Saturday's entries first, since it was the busiest day.
- Look for a small payment that was made but not written, such as a ₹50 chai or photocopy change.
- If nothing turns up, write a line showing the ₹50 difference and tick the week closed. Do not force the figure.
Which entries need a second look?
Three kinds of line cause most weekly confusion. Deposits and owner withdrawals are not shop costs, so keep them out of your expense total. Advances to staff, like the ₹1,000 on Thursday, are money you expect to get back or adjust against wages, so write the helper's name next to the line and note how it will be settled. Lastly, round sales totals such as ₹7,300 should come from your bill book or counter slips, not from a guess at closing time.
How would you reuse this for your own week?
Copy the six column headings, enter your own opening cash, and fill one line per day. If you sell a lot through UPI, keep that in a bank sheet, because it never touches the drawer. If you want the bank rows without typing them in, SpendixAI accepts statement uploads in PDF, CSV or Excel and shows the rows for your review before anything is saved.
End-of-week checklist
- Opening plus receipts minus payments equals the last closing balance.
- Every deposit slip is stuck behind the day it belongs to.
- The Sunday count is written at the bottom of the page with the date.
- Any difference is noted, not buried.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

