Tax and GST

A cash book worked example: one week in a small stationery shop

Follow a small stationery shop through a full week of cash book entries, with each day's opening and closing balance and a Sunday check against the till.

Editorial illustration for A cash book worked example: one week in a small stationery shop

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

DayOpening (₹)Receipts (₹)Payments (₹)Closing (₹)What happened
Mon6,0004,2001,5008,700Cash sales; paid a paper supplier ₹1,500
Tue8,7003,60025012,050Cash sales; tea and courier ₹250
Wed12,0505,10010,0007,150Cash sales; ₹10,000 deposited in bank
Thu7,1503,9001,00010,050Cash sales; ₹1,000 advance to the helper
Fri10,0504,8004,50010,350Supplier ₹2,500; owner withdrawal ₹2,000
Sat10,3507,30012,0005,650Busy 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.

  1. Recount the cash once more, note by note.
  2. Check Saturday's entries first, since it was the busiest day.
  3. Look for a small payment that was made but not written, such as a ₹50 chai or photocopy change.
  4. 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.
SPENDIXAI JOURNAL

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

Explore your reports