Tax and GST

A weekly 10-minute records routine for a shopkeeper

A timed Sunday-evening checklist for shopkeepers: bills in order, cash book against bank, credit sales, untagged entries and the photo backlog.

Editorial illustration for A weekly 10-minute records routine for a shopkeeper

Ten minutes once a week is enough to keep a shop's records from piling up, if you do the same five jobs in the same order. Set a timer for two minutes per job on Sunday evening, after the shutter is down and before dinner, and stop when it rings.

The ten-minute pass, job by job

  1. Minutes 0 to 2: bills in order. Take the week's purchase bills and put them in date order in your folder or accordion file. Anything without a date, write the date on it now. Missing bills go on a small list for Monday.
  2. Minutes 2 to 4: cash book against the till. Count the cash you actually have, compare it with what the cash book says, and write the difference at the bottom even if it is zero. Note how much cash you took to the bank this week and which day.
  3. Minutes 4 to 6: credit sales list. Open the list of customers who owe you. Add new names, strike off anyone who paid, and mark the two oldest balances to ask about on Monday.
  4. Minutes 6 to 8: untagged entries. Look at your tracker or sheet for entries with no category or an obvious wrong one. Fix what you can; leave a question mark on the rest.
  5. Minutes 8 to 10: photo backlog. Move bill photos from the phone's camera roll into the dated folder, and delete duplicates and blurred shots.

The order is deliberate. Bills come first because they feed everything else, and photos come last because it is the job most easily skipped without harm for one week.

What should the cash book to bank step actually check?

Two things. First, that the cash you deposited matches the deposit entry in your bank statement. Second, that cash you took out for expenses has a slip behind it. Say your cash book shows 14,200 rupees opening, 31,600 rupees of cash sales, 9,800 rupees paid out in small expenses and 20,000 rupees taken to the bank. Closing should be 14,200 plus 31,600 minus 9,800 minus 20,000, which is 16,000 rupees. If the drawer holds 15,700, you have a 300 rupee gap to chase, and you found it within a week instead of a quarter.

What counts as a credit sales list?

It is simply a page with customer name, date given, amount and what was agreed, whether that is pay on Friday or pay after Diwali. A shop that sells on credit to a dozen regulars does not need software for this. It needs a weekly look. If you see the same name carried forward three Sundays running, that is the one to speak to.

Do I need an app for this routine?

No. A notebook, a folder and a phone camera are enough. If you already use a tracker, the weekly pass is the moment to open it. With SpendixAI, for example, you can upload the bank or card statement, review the rows, and add the week's cash expenses by hand in one go, which covers the untagged and cash steps in a couple of minutes. The routine works the same on paper.

When the week goes wrong

  • If you missed a Sunday, do the pass the next evening and do not try to catch up on two weeks of detail. Just make the bills and cash right.
  • If festival week made the shop too busy, do only the cash count and the bill ordering. Those two are the ones that become impossible to rebuild later.
  • If a helper runs the counter on Sundays, hand them the checklist and let them do jobs one and five while you do the rest.

Once a month, add five more minutes

On the last Sunday of the month, copy your cash book closing balance and your bank balance onto a single line in a notebook, with the date. Over a year you get twelve lines that show whether the shop is building up or running down, and your CA can see them too. Tax and GST dates differ by registration, so ask your accountant which monthly dates matter for your shop and write them on the inside of your folder cover.

SPENDIXAI JOURNAL

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

Explore your reports