Skip to content
ANANTATECH HUB

A One-Day Month-End Close for Small Shops and Traders

Most small businesses never formally close the month, so errors pile up until the GST return or the year-end audit exposes them. This article gives a one-day checklist covering cash, bank, party balances, stock, expenses and GST that a shop owner can follow without an accountant in the room.

Big companies close their books every month. Most shops and small trading firms do not. Entries get made when someone has time, the bank statement sits in a drawer, and the real picture appears only when the GST return is due or the CA asks for year-end figures.

That is a costly way to find out what happened. A small mistake in March is easy to fix in April. The same mistake found in the following February means digging through eleven months of bills.

A month-end close is just a fixed routine, done on the same days every month, that checks your records against reality. For a small business it can take about a day once you have done it a couple of times. Here is a routine you can adapt.

Step zero: decide your cut-off

Pick a rule for what belongs to the month. The simplest one is the invoice date: a sale belongs to the month of the bill, a purchase belongs to the month of the supplier's bill, whatever the delivery or payment date.

Then tell your staff that all bills dated in the month must be entered by a set day, for example the 3rd of the next month. Bills that arrive late still get entered, but under their correct dates. Without a cut-off, every other step below becomes guesswork.

Step 1: Count the cash

Count the physical cash in the drawer and the safe on the last day of the month, and write down the number. Compare it with the cash balance in your books.

  • If they match, note the date and move on.
  • If they do not, look first at the last few days: unrecorded expenses, tea and transport money, staff advances, and customer receipts that went into the drawer but not into the register.
  • Do not adjust the books to match the drawer until you have looked. A difference is information.

If the gap is small and cannot be traced, record it openly as a cash difference. Burying it in sales or expenses hides the habit that caused it.

Step 2: Match the bank

Download or collect the bank statement for the month. Go line by line against your books. Every credit and debit should have a matching entry, and every entry should have a line in the statement.

The usual causes of mismatch are:

  • Cheques you issued that have not yet cleared
  • Customer payments received by UPI or transfer that nobody recorded
  • Bank charges, interest and EMIs that appear only on the statement
  • Payments recorded against the wrong party

List the cheques still pending and carry them forward. Everything else should be explained before you close.

Step 3: Review who owes you and whom you owe

Print or open the list of party balances. Customers first. Sort by amount and by age, and look at three things:

  1. Balances that are much larger than the party's usual credit
  2. Balances with no payment for a long time
  3. Small odd balances left behind by rounding or part-payments

Send reminders for the overdue ones the same week. Then do the supplier side: check that what you show as payable matches what the supplier believes. For your biggest suppliers, ask for a statement of account and compare. Differences usually come from a missing bill, a returned item or a payment booked to the wrong date.

Step 4: Do a small stock check

A full stock count every month is too much for most shops. A spot check is enough. Choose ten to twenty items: some fast movers, some expensive ones, and a few that have given trouble before. Count them on the shelf and compare with the stock figure in your records.

If the same items keep showing differences, the cause is usually in how they are billed, such as loose items sold by weight, packs opened and sold singly, or free samples. Fix the process rather than correcting the number each month. Do a full count at least once a year, and again if the spot checks keep failing.

Step 5: Catch what is not yet recorded

Some costs do not arrive as a bill on the day they occur. Before closing, ask yourself:

  • Has the rent, electricity, internet and phone bill for this month been booked?
  • Have salaries and advances been entered?
  • Are there transport or labour charges paid in cash with no bill?
  • Were there any returns, damaged goods or discounts given that need a credit note?

Going through this list is the quickest way to stop profit looking better than it really was.

Step 6: Check the GST position

Do this before the return, not while filing it. Compare your sales register with what you plan to report, and your purchase register with the input tax credit available to you on the GST portal. Look for:

  • Supplier bills you have recorded but that do not appear in your portal data
  • Bills that appear on the portal but are not in your books
  • Invoices with a wrong GSTIN, wrong tax rate or wrong place of supply
  • Credit notes issued or received that are not yet reflected

Return due dates depend on whether you file monthly or under the quarterly scheme, so check your own schedule on the portal and set reminders. The point of the month-end routine is that by the time the date approaches, the data is already clean.

Step 7: Look at the numbers and write two lines

With the checks done, look at the month: total sales, total purchases, major expenses, money received, money still to collect and cash in hand. Compare with the previous month, not with a target you invented.

Then write two lines in a notebook or a file: what changed this month, and what you will do about it. For example, a customer's dues keep growing, or one supplier's prices have crept up. These notes are very useful when you look back at the year.

Who should do what

If you are the owner, do steps 1 and 7 yourself, because they need your judgement. Staff or an accountant can prepare steps 2, 3 and 6, but you should read the results. Stock spot checks work best when done by someone who does not handle billing, since a fresh pair of eyes catches more.

Common mistakes

  • Closing only when the CA asks. By then nobody remembers the details.
  • Fixing differences silently. If you correct a figure without noting why, the same error returns next month.
  • Skipping the month after a busy one. Festival and season months are exactly when errors are most likely.
  • Making the routine too big. A routine that takes three days will be dropped. Keep it small enough to survive a bad week.

Start with the next month

You do not need to repair past months before you begin. Choose a day, say the 4th, block out the time, and work through the seven steps once. The first close will be slow because it will uncover old problems. The second will be faster, and by the third you will have a routine that tells you, within a day of the month ending, where the business actually stands.

Tags

  • Easy Khata

Talk to us about your requirement

If something here applies to your business, the next step is a conversation.