GST & COMPLIANCE

Bookkeeping for small shops: a 15-minute daily routine that makes GST and your CA easier

A simple daily, weekly and monthly bookkeeping routine for shop owners and traders in India: recording sales by payment mode, capturing bills, tracking dues and stock, and keeping your accountant informed.

Most small shop owners do not dislike accounting. They dislike the month-end scramble: searching for bills, reconstructing sales from memory, and answering the same questions from their accountant every month. The fix is not more accounting. It is a little accounting, done every day, so that month-end takes care of itself.

This guide sets out a routine that takes about fifteen minutes a day and makes GST filing, loans, and conversations with your CA far easier.

Why daily beats monthly

Information is freshest on the day it happens. You remember which customer took goods on credit, why the cash drawer was ₹200 short, and which supplier's bill arrived with the delivery. A month later, these become guesses. Small daily records also show problems early: a supplier overcharging, a slow-moving item, a customer who keeps delaying payment.

The daily routine (about 15 minutes)

1. Record every sale with its payment mode

At the end of the day, your sales total should be split into cash, UPI and cards, and credit (pay later). This one habit solves most month-end problems:

  • UPI and card sales can be matched with your bank statement.
  • Cash sales can be matched with the cash in the drawer.
  • Credit sales become a list of who owes you money.

If you use a billing app or machine, this split is usually available automatically. If not, a simple notebook with three columns works.

2. Count the cash

Count the drawer at closing and compare it with expected cash: opening cash plus cash sales minus cash paid out. Write down any difference and the reason if you know it. Small differences found the same day are easy to explain; a month of them is not.

3. Capture today's purchase bills

Every bill that arrived today should be photographed or filed the same day. Purchase bills are where most GST input tax credit comes from, and a missing bill is lost credit. Check that each bill shows your correct GSTIN and the supplier's GSTIN before you put it away.

4. Note money going out

Record cash and UPI payments for expenses: rent, salaries, electricity, transport, repairs. Keep a receipt or a photo for each.

The weekly routine (about 30 minutes)

  • Review who owes you. Look at the credit sales list and follow up on anything older than your normal terms.
  • Review what you owe. Note supplier payments due. For GST, purchases must generally be paid within 180 days for the credit to stand.
  • Check stock of your top items. You do not need a full count every week, but the 20 items that make most of your sales deserve a quick look so you neither run out nor overstock.
  • Send the week's bills to your accountant, rather than saving them up for the month.

The monthly routine (about one hour)

  • Match your bank statement with UPI and card sales and with payments made.
  • Confirm all sales and purchase bills are with your accountant by the date they ask for. For monthly GST filers, the earlier in the month the better; GSTR-1 is due on the 11th and GSTR-3B on the 20th.
  • Look at the month's numbers: total sales, gross profit, main expenses, and the trend against previous months.
  • Pay GST on time once your accountant shares the challan, and keep the payment receipt.
  • Ask your accountant about anything new: notices, changes in rules, or anything in your numbers that looks unusual.

For more detail on the GST calendar, see our guide to GST return due dates.

What to keep, and for how long

Keep sales invoices, purchase bills, credit and debit notes, bank statements, expense receipts and GST payment receipts, organised by month. Under GST, accounts and records generally need to be kept for at least 72 months (six years) from the due date of the annual return for the year they relate to, and longer if there is an ongoing case. Digital copies, clearly organised, are acceptable and far easier to search than a cupboard of files.

Signs your books need attention

  • You often do not know your profit until your accountant tells you, months later.
  • Your accountant regularly asks for the same documents twice.
  • You have received a GST notice about a mismatch.
  • You cannot easily list who owes you money.
  • Cash in hand rarely matches what you expect.

Any one of these is a sign that a small daily routine would pay for itself.

Making it easier with an app

Paper works if it is done every day. An app makes the daily steps faster: sales are split by payment mode automatically, bills are photographed as they arrive, dues and stock are always visible, and your accountant can see what they need without asking.

We designed the SquareBooks business app around exactly this routine. Today's sales by UPI, cash and pay later sit on the home screen; adding a bill is one tap; and the GST & CA tab shows what your accountant needs from you and what to pay, with dates.

Key takeaways

  • Fifteen minutes a day prevents most month-end problems.
  • Split sales by cash, UPI and credit; count cash daily; capture bills the day they arrive.
  • Review dues and send bills to your accountant weekly.
  • Match the bank, check the numbers and pay GST on time monthly.

This guide is general information for small business owners, not accounting or tax advice. Your chartered accountant can tailor the routine to your business.