Month End and the Books Don't Match? Why It Happens and How to Fix It

Your books don't match at month end because the same money gets recorded in more than one place, by different people, at different times. Sales has one number, the bank shows another and stock shows a third. It's rarely an accounting problem. It's a systems problem: every time a number is retyped, it can be wrong. The lasting fix is to enter each sale once and let stock and accounts update from that single entry.

I've worked on accounting software, hospital accounting (patient billing, insurance claims and reporting) and billing and POS systems for retail and healthcare. The businesses were different, but month end looked the same everywhere: a few tired people with three reports open, trying to work out why the totals don't agree. This post explains where the gaps come from, how to find them faster this month, and how to stop them for good.

Why sales, bank and stock never agree

Each report is "right" from its own point of view. The problem is that they were built from different copies of the same events. Here are the usual causes.

1. The same sale is typed into three places

A sale is rung up at the till. Later someone copies the day's sales into a spreadsheet. Then someone else adjusts the stock sheet, and at month end the accountant enters totals into the books. That's three or four copies of one sale. Each copy is a chance to type the wrong amount, skip a line or enter something twice.

2. Money doesn't arrive when the sale happens

Card payments often reach your bank a day or more after the sale, and usually with the provider's fee already taken off. A sale on the last day of the month may only show up in next month's bank statement. Cheques clear late, and customers on credit pay whenever they pay. None of this is a mistake, but if nobody records it, it looks like one.

3. Returns, discounts and write-offs skip a step

A customer returns an item. The refund goes out, but the stock sheet is never updated. A manager gives a discount at the counter and the sales report still shows full price. Broken or expired stock gets thrown away without being written off. Each of these is small. Over a month, they add up to a gap nobody can explain.

4. Quick fixes nobody wrote down

Last month's totals didn't match, so someone "adjusted" a cell to make them agree. Now that adjustment is hiding inside this month's opening balance. Without a record of who changed what and why, every month starts slightly wrong.

How to find the gaps faster this month

Before talking about software, here is a calmer way to get through the next month end with the tools you already have.

Pick one period and lock it. Agree on the exact dates (for example, the 1st to the last day of the month) and stop editing that month while you check it.

Start with the bank. The bank statement is the one record you didn't type yourself, so treat it as the anchor. Match each deposit to the sales or payments it came from.

Compare lists, not just totals. Totals only tell you there's a gap. Lists tell you where it is. Export the sales list and the bank deposits, sort them by date and amount, and put them side by side. The free diff checker highlights lines that are in one list but not the other, which makes missing or doubled entries easy to spot.

Write down the reason for every difference. "Card fee", "paid next month", "refund not recorded". After two or three months, you'll see which causes keep coming back. Those are the ones worth fixing at the source.

Never hide a gap with a plug figure. If something can't be explained yet, record it as unexplained and carry it forward. A visible gap gets fixed. A hidden one grows.

The real fix: enter it once

Checking faster helps, but it still means someone spends days every month matching numbers. The lasting fix is to stop creating the copies in the first place. In a connected system it works like this:

The sale is entered once, at the till or when the order is created.

Stock goes down automatically from that same sale. Returns put stock back automatically too.

The books are updated automatically, with the sale, discount, tax and payment method already attached.

Payments are recorded against invoices, so you can see at a glance which money has arrived and which is still owed.

Every change is logged with the person and the time, so a "quick fix" can't quietly disappear.

When sales, stock and accounts all read from the same record, they can't disagree about what was sold. Month end stops being a hunt for missing numbers and becomes a short check of the few things that are genuinely different, like bank fees and payments still on their way.

What this looks like in a real system

Here are a few systems I've built where this single-entry idea sits at the centre:

A POS, sales, purchase and ledger management system for small and medium businesses, where sales, stock, accounts and team access live in one dashboard.

A warehouse inventory management system that brings sales, purchasing, stock movement and reporting into one place, replacing spreadsheets and disconnected tools.

A transport management system for a fleet business that tracks vehicles, drivers, investor installments and income and expense reporting in one place.

If your team still runs month end across several spreadsheets, my post on the signs your business has outgrown spreadsheets is a good next read. It covers how to tell whether it's time to move, and how to switch without losing a week of work.

Do you need custom software to fix this?

Not always. Be honest about where the problem actually is:

If you have one or two causes, like card fees nobody records, a simple checklist and a shared file may be enough for now.

If your business works like most in your industry, a ready-made POS or accounting tool that connects sales, stock and books can be quick and affordable.

If your process is unusual, or you need several parts of the business to post into the books in a specific way, a custom system built around how you already work can fit better. It costs more up front, so it should save real hours or stop real losses.

If you're weighing that last option, read the 7 questions to answer before you build custom software first.

Next step

If you spend days every month matching sales, bank and stock, tell me which reports you compare and where they usually disagree. I'll tell you honestly whether you need a new system, a ready-made tool or just a better routine. You can see the business systems I build on the services page, or reach me through the contact page or on WhatsApp at +92 312 7973331.

→ Talk to me about fixing month end

FAQ