Few things are more frustrating for a small business owner than sitting down to reconcile the accounts and finding that the numbers simply will not match. The bank statement says one thing, your accounting software says another, and no amount of staring at the screen seems to make the discrepancy disappear. The good news is that unreconciled books almost always have a findable, logical explanation, and working through the problem methodically is far more effective than randomly adjusting figures until things appear to balance.
A discrepancy is also, in a strange way, a useful signal that your bookkeeping process is at least engaging properly with the bank data rather than being disconnected from it entirely. Businesses that never seem to have reconciliation issues are sometimes simply not checking closely enough to notice them, so finding a gap and working through it properly is a sign of a healthy, attentive process rather than something to be embarrassed about.
Resist the Urge to Force a Match
When a reconciliation will not balance, there is often a temptation to make a manual adjustment just to close the gap and move on. This is one of the most common mistakes in bookkeeping, because forcing a match without understanding the actual cause simply hides the discrepancy rather than resolving it, and often makes it harder to find later once the trail has gone cold. It is far better to accept a temporary imbalance and investigate properly than to paper over it with an adjustment that has no real explanation behind it. An unexplained adjustment sitting quietly in your records can also raise questions later, particularly if HMRC or a lender ever asks what it relates to and nobody can give a clear answer.
Start With the Most Common Causes
Before assuming something has gone seriously wrong, it is worth checking the handful of issues that cause the vast majority of reconciliation discrepancies. Timing differences are extremely common, where a transaction has been recorded in your books on one date but cleared the bank on another, particularly around month-end. Duplicated entries, where the same transaction has been recorded twice, either manually and through a bank feed, are another frequent culprit, as are missing transactions that were never entered at all. Bank fees, interest charges and card processing fees are also commonly overlooked, since they often appear on the bank statement without a corresponding entry ever being made in the accounting records. Foreign transaction fees and currency conversion charges are a particularly easy one to miss for any business that occasionally pays overseas suppliers or software subscriptions, since these often appear as a separate line item some days after the original transaction itself.
Work Through the Discrepancy Systematically
Rather than scanning randomly for the problem, work through both records side by side, matching transactions in date order and flagging anything on one side that does not have a clear counterpart on the other. Breaking the period down into smaller chunks, such as reconciling week by week rather than attempting the whole month at once, makes it far easier to isolate exactly where the discrepancy first appears. Once you have narrowed it down to a specific date range, the actual cause is usually easy to spot once you are looking at a manageable handful of transactions rather than an entire month's worth. This narrowing-down approach is also far less draining than staring at a full month of entries hoping the answer jumps out, since your attention stays focused on the small, defined window where the problem genuinely lies.
- Check for transactions recorded twice or entered under different dates
- Look for bank fees, interest or charges missing from your records
- Confirm every transaction on the bank statement has been entered
- Check for transposed figures, such as £450 entered as £540
Check for Transposition and Data Entry Errors
Simple data entry mistakes, such as transposed digits, a decimal point in the wrong place, or a payment entered against the wrong account, are surprisingly common causes of reconciliation problems and are often the quickest to fix once identified. A useful trick when the discrepancy is a suspiciously round or divisible number is to check whether it is divisible by nine, since transposition errors, such as entering 540 instead of 450, always produce a difference that divides evenly by nine, which can help narrow down exactly what kind of mistake you are looking for. It is a small trick, but one that experienced bookkeepers reach for often, since it turns a seemingly random discrepancy into a specific, targeted search rather than an open-ended one, and it is well worth keeping in mind next time a reconciliation refuses to balance by a suspiciously tidy amount.
Review Anything Recorded Outside the Normal Process
Discrepancies often trace back to transactions that fell outside your usual bookkeeping routine, such as a payment made directly from a personal account on behalf of the business, a refund processed manually rather than through the normal sales system, or a transfer between accounts that was recorded on one side but not the other. These irregular transactions are easy to miss precisely because they do not follow the pattern you are used to checking, so it is worth specifically reviewing anything unusual or one-off from the period in question when a standard review has not turned up the answer. Keeping a simple running note of any transaction handled outside the usual process, even a quick line in a notes app at the time it happens, makes this kind of review considerably faster the next time a discrepancy needs tracing.
When to Bring In Professional Support
If a discrepancy has been checked thoroughly and still will not resolve, or if reconciliation problems are becoming a regular occurrence rather than an occasional headache, it is a sensible point to bring in professional help. An experienced bookkeeper or accountant can often spot the cause quickly simply because they have seen the same type of error many times before, and can also advise on whether your current process needs adjusting to prevent it recurring. Our bookkeeping and accounting services include regular reconciliation as standard, which catches discrepancies while they are small and recent rather than letting them accumulate into a much larger, harder-to-trace problem.
Build Habits That Prevent Future Discrepancies
Once the current issue is resolved, a few simple habits significantly reduce the chances of it happening again: reconciling weekly rather than monthly, entering transactions promptly rather than in batches, and reviewing bank feed matches carefully rather than accepting suggested matches automatically. Getting professional bookkeeping support in place removes much of this burden entirely, giving you confidence that your books are accurate on an ongoing basis rather than something you only discover is wrong when a reconciliation refuses to balance.
The Bottom Line
Unreconciled books are a common, solvable problem, and the discrepancy almost always has a clear, findable cause once you work through it methodically rather than forcing a match. Checking for timing differences, duplicated entries, data entry errors and irregular transactions resolves the vast majority of cases. Building good reconciliation habits, and bringing in professional support when needed, keeps small discrepancies from ever growing into a genuine headache, leaving you with figures you can trust and rely on whenever you need to check exactly where the business stands.
Having Problems With Your Current Accounting Service?
Let's sort this out, calmly and properly
Fred Michael & Co Ltd helps London business owners fix accounting problems and switch providers smoothly, with clear, practical support.