Troubleshooting Discrepancies: Common Bookkeeping Errors

Few things cause UK small business owners more headaches than unexplained gaps between the books and the bank statements. Discrepancies don’t just create stress—they can lead to cash flow crises, tax penalties, and even HMRC investigations if left unresolved. In this guide, you’ll learn exactly how to spot, diagnose, and fix the most frequent bookkeeping errors affecting small UK businesses, as well as how to prevent them in the first place. Whether you handle your own books or work with a bookkeeper, this is your definitive manual for getting your accounts back in line.

A bookkeeping discrepancy is any situation where the numbers in your accounting records don’t match up with reality—usually your bank statement, supplier balances, VAT returns, or payroll records. In the UK, this isn’t just a theoretical issue: discrepancies are red flags for HMRC, can disrupt your VAT submissions, and can even lead to over- or underpayment of tax. Common examples include your cashbook not matching the bank statement, creditors or debtors showing the wrong balances, or differences in reported turnover between your records and what’s reported on your tax return.

Bookkeeping discrepancies matter because they undermine the reliability of your financial data. If you can’t trust your profit and loss figures, you’re at risk of making bad decisions—like overcommitting on stock or paying yourself more than you can afford. Worse, unresolved errors can trigger HMRC compliance checks, VAT inspections, or even fines for late or inaccurate submissions. For businesses registered as limited companies, the Companies Act 2006 requires accurate record-keeping, and the penalties for non-compliance can be severe.

Discrepancies also disrupt cash flow management, payroll accuracy, and your ability to plan for corporation tax, PAYE, and VAT bills. In short, ignoring them isn’t an option—especially given HMRC’s growing use of data-matching technology to spot inconsistencies between tax returns and third-party records.

Some bookkeeping errors crop up again and again in UK small businesses, regardless of sector. Understanding these common pitfalls is the first step to preventing and correcting them. The most frequent issues include misposted transactions, duplicated or omitted entries, incorrect VAT treatment, misallocated receipts and payments, and forgetting to reconcile accounts regularly. Each type of error introduces its own risks and can have knock-on effects for your financial statements and tax position.

Misposting is when a transaction is recorded in the wrong account—such as coding a personal expense as a business cost, or posting a supplier payment to the wrong supplier ledger. Duplicated entries often happen when both manual and automated feeds are used, or when invoices or receipts are entered more than once. Omitted entries usually result from lost paperwork, failing to record direct debits, or not capturing cash sales. Incorrect VAT treatment—such as missing VAT on expenses, applying the wrong rate, or failing to reverse charge for overseas services—can create both compliance headaches and cashflow issues.

Another common error is failing to clear suspense or control accounts, leaving balances hanging that should have been matched off. Payroll errors, such as misposting gross pay, employer’s National Insurance, or forgetting to account for statutory payments, are also widespread. These mistakes often snowball, making them harder to untangle the longer they’re left.

• Misposting transactions to the wrong ledgers or accounts
• Duplicating entries due to manual and automated data overlap
• Omitting transactions, especially cash or direct debit payments
• Incorrect VAT coding or treatment on sales or purchases
• Unreconciled control accounts, including petty cash and payroll
• Forgetting to adjust for refunds, credit notes, or bounced payments

Spotting bookkeeping discrepancies early is all about vigilance and routine checks. The most reliable method is regular reconciliation—comparing your accounting records to external statements, such as bank, credit card, and supplier statements. In the UK, this should be done at least monthly, and more often if you process large volumes of transactions. If your bank statement balance doesn’t match your accounting software’s bank account, you have a discrepancy that needs investigating. See our guide on How to Reconcile Your Bank Accounts Monthly for detailed steps.

Other red flags include aged debtor or creditor reports that show unrealistic balances, unexplained amounts in suspense accounts, or differences between your VAT control account and what’s actually due to or from HMRC. Payroll discrepancies often show up as mismatches between your payroll summary and what’s paid over to HMRC for PAYE and National Insurance. Unexpected swings in profit and loss reports, or cashflow that doesn’t tally with your accounting records, are also clues that something is wrong.

Don’t underestimate the value of a ‘sanity check’. If your reported sales or costs look out of line with previous months, or you can’t explain why profit has suddenly jumped or plummeted, that’s a signal to dig deeper. Always trust your instincts—if something looks odd, it probably is.

• Bank statement balance doesn’t match accounting bank ledger
• Unusual or old balances in suspense, payroll, or VAT control accounts
• Aged debtor/creditor reports showing long-overdue items with no explanation
• VAT return figures that don’t match underlying sales/purchases
• Payroll summaries that differ from HMRC payment confirmations

When you spot a discrepancy, it’s tempting to panic or just make a ‘balancing entry’ to force the books to match. Don’t! The right approach is structured and methodical. Here’s a practical process designed for UK small businesses, whether you use spreadsheets or accounting software. Take your time and document all adjustments—you’ll need an audit trail if HMRC comes calling.

Remember, some discrepancies are simple oversights, but others can reveal deeper issues like fraud, staff error, or systemic process failures. Always get to the root cause, and never just ‘plug the gap’.

Some types of bookkeeping discrepancies cause outsized problems for UK small businesses—especially VAT, payroll, and control accounts (like PAYE, VAT, or suspense). VAT errors are particularly risky because they can trigger HMRC penalties and time-consuming VAT inspections. Common VAT mistakes include recording sales or purchases with the wrong VAT code, failing to account for reverse charge or EC acquisitions, or mistiming VAT on cash accounting. Always check that your VAT control account matches what’s actually due or reclaimable for each period.

Payroll discrepancies often stem from incorrect posting of gross pay, employer’s National Insurance, or mishandling statutory payments (SSP, SMP, etc.). If your payroll control account doesn’t clear to zero after each HMRC payment, you need to investigate. Mistakes here can result in underpaying or overpaying PAYE and National Insurance, risking fines or late payment interest. Use your payroll reports to cross-check all postings, and always reconcile with HMRC’s online account.

Control account discrepancies, such as unexplained balances in suspense, VAT, or payroll accounts, are a sign that transactions haven’t been fully matched off or coded correctly. These accounts should clear to zero regularly—if not, you may have duplicated or missing entries elsewhere. Always drill down into the detail, and never leave unexplained balances hanging over from one period to the next.

• VAT control account should always match your actual VAT return totals
• Payroll control account should reconcile to zero after each HMRC payment
• Uncleared suspense accounts suggest unresolved or misposted transactions
• Foreign currency transactions need careful treatment to avoid exchange gains/losses errors

Resolving discrepancies is vital, but prevention is even better. The most effective way to avoid repeated errors is to implement robust processes and regular checks. This starts with setting up your accounting software correctly—use the correct chart of accounts for your business type, and ensure VAT codes and control accounts are properly configured from the outset. Always keep your software up to date, and avoid mixing personal and business transactions.

Regular reconciliation is non-negotiable. At a minimum, reconcile all bank, credit card, and control accounts monthly—weekly if your business is high-volume or cash-based. Retain all supporting documents (receipts, invoices, bank statements) for at least six years, as HMRC can request them at any time. Train staff in basic bookkeeping principles, especially VAT and payroll handling, and ensure only authorised people make adjustments to the accounts.

Finally, review your financial reports monthly. Look for unexplained movements in cash, profit, or control accounts. If you use a bookkeeper or accountant, ask them to explain any odd-looking items. Don’t accept ‘that’s just how it is’—every number should have a clear explanation.

• Set up accounting software with the correct UK-specific chart of accounts and VAT codes
• Reconcile all bank and control accounts at least monthly, more often for high-volume businesses
• Maintain a clear audit trail for every adjustment, with supporting paperwork
• Train all staff handling finance in basic bookkeeping and VAT rules
• Review financial reports monthly and question unexplained figures

Many UK small business owners fall into the same traps when dealing with bookkeeping discrepancies. The most damaging mistake is to ‘plug the gap’—making a balancing entry without finding the real cause, just to make reconciliations work. This might make your accounts look tidy in the short term, but it creates serious headaches later, especially if HMRC ever reviews your books.

Another misconception is that accounting software will prevent all errors. While tools like Xero, QuickBooks, and Sage reduce manual mistakes, they’re not foolproof. Automated bank feeds can miss or duplicate transactions, and software can’t spot if you’ve picked the wrong nominal code, VAT rate, or entered the wrong amount. Human oversight is always required.

Some business owners ignore small discrepancies, reasoning that ‘a few quid won’t matter’. Unfortunately, small errors often point to bigger underlying issues—like poor processes or fraud—and can add up over time, distorting your accounts and tax returns. Always investigate every discrepancy, no matter how minor, until you’re satisfied you know the cause.

• Never make unexplained ‘balancing entries’ just to reconcile the books
• Don’t assume software eliminates all errors—manual checks are still essential
• Avoid ignoring small discrepancies—they often signal bigger problems
• Don’t leave control accounts uncleared from one period to the next

Some discrepancies can be resolved in-house, but others require professional expertise—especially if they involve VAT, payroll, or multiple years of errors. If you’re repeatedly finding mismatches you can’t explain, or if your books are out of balance at year-end, it’s time to call in a qualified bookkeeper or accountant. The cost of professional help is almost always less than the potential tax penalties or lost time from trying to fix things yourself.

When working with a bookkeeper or accountant, provide them with full access to your records—bank statements, invoices, receipts, and any reconciliation notes. Be honest about any ‘workarounds’ or gaps in your processes. Ask them to explain not just what they’re correcting, but why the error occurred and how to prevent it in future. A good bookkeeper will also help you set up proper processes and checklists to reduce future errors.

If you are VAT-registered, have employees on PAYE, or operate as a limited company, you should at least have an accountant review your books annually. This is especially important before submitting your company accounts to Companies House or your corporation tax return to HMRC.

• Engage a bookkeeper for regular reconciliation and process improvement
• Use a qualified accountant for year-end accounts and complex corrections
• Be transparent about your processes and provide all documentation
• Request regular updates and explanations for any adjustments made

The UK has clear legal requirements for business bookkeeping. Under the Companies Act 2006, all limited companies must keep accurate accounting records that show and explain all company transactions and enable the company’s financial position to be determined with reasonable accuracy at any time. Sole traders and partnerships are also required by HMRC to keep adequate records to support their tax returns.

For VAT-registered businesses, you must keep digital VAT records and submit VAT returns using ‘Making Tax Digital’ (MTD) compliant software. Payroll records must be kept for at least 3 years for RTI (Real Time Information) purposes. All business records should be retained for at least 6 years, or longer if they relate to equipment or property that’s still owned.

Failing to resolve discrepancies isn’t just bad practice—it’s a legal and financial risk. HMRC can issue penalties for inaccurate returns, failure to keep records, or careless/negligent errors. In serious cases, unresolved discrepancies can even be seen as evidence of tax evasion or fraud. Accurate books protect you from disputes with suppliers, customers, and HMRC, and are a cornerstone of running a trustworthy, successful business in the UK.