Bank reconciliation is the process of comparing transactions in the accounting records with the corresponding activity shown by the bank, credit card or payment-provider statement. It is one of the strongest checks available for determining whether financial records are complete and whether the balance shown in the bookkeeping system can be relied upon.
A reconciliation does more than make two closing balances agree. It can expose missing transactions, duplicated entries, incorrect dates, unrecorded charges, payments allocated to the wrong customer and transfers treated incorrectly as income or expenditure.
When reconciliation is completed regularly, these issues can usually be investigated while the transactions remain familiar. When it is postponed until year end, the business may need to reconstruct several months of activity before its reports or accounts can be trusted.
What bank reconciliation actually checks
Bank reconciliation compares the balance recorded in the accounting system with the balance confirmed by the financial institution. Each receipt, payment, fee, refund and transfer should either be matched to an accounting entry or identified as an outstanding item requiring explanation.
The process should be completed separately for every relevant account. This can include current accounts, savings accounts, business credit cards, loan accounts, merchant accounts and payment platforms used to receive or make business payments.
A bookkeeping system may contain hundreds of processed transactions and still show the wrong balance. The number of entries completed does not prove that the records are complete or correctly classified.
Reconciliation provides a controlled comparison with an independent source. Where the accounting balance differs from the statement, the cause must be identified rather than concealed through an unsupported adjustment.
Why the accounting balance can differ from the bank
Some differences arise because a transaction has been recorded in one system before it appears in the other. A cheque may have been issued but not yet presented, or a card payment may remain pending at the statement date.
Other differences indicate that something has been missed or entered incorrectly. The bank may have applied a charge or interest payment that has not yet been recorded. A receipt may have been entered twice, or a transfer between business accounts may have been posted as sales income.
The accounting records may also contain transactions that have been allocated to an incorrect bank account. This can happen when a business operates several accounts and the person processing the entry selects the wrong one.
Each difference should be classified as a genuine timing item, an error requiring correction or an unexplained transaction requiring further information. It should not be left indefinitely simply because the amount is small.
How bank reconciliation works in practice
The process begins with a complete bank statement or verified bank-feed balance for the period being reviewed. The transactions shown by the bank are compared with those recorded in the accounting system.
Receipts are matched to customer invoices, sales records or other sources of income. Payments are matched to supplier invoices, expenses, payroll liabilities, tax payments, transfers or other appropriate entries.
Where the corresponding transaction already exists, it should be matched rather than recreated. Entering a new expense for a supplier bill that has already been recorded can duplicate the cost and leave the original creditor balance unpaid.
Transactions that cannot be identified should be raised as queries. The business owner may need to provide an invoice, receipt, customer reference or explanation before the entry can be completed correctly.
When all statement activity has been accounted for, the closing accounting balance should agree with the verified bank balance after allowing for any genuine outstanding items.
Timing differences are not necessarily errors
A transaction can appear in the bookkeeping records and bank statement during different reporting periods without being wrong. The important point is that the difference is understood and documented.
A payment recorded on the final day of the month may not leave the bank until the following day. A card settlement may relate to sales made before the accounting period ended but arrive in the bank afterwards.
These items should clear during the next reconciliation. If they remain outstanding for several periods, the original entry may have been duplicated, cancelled, posted to the wrong account or recorded using an incorrect date.
Old outstanding items should therefore be reviewed rather than copied automatically from one reconciliation to the next. Their continued presence may indicate that the records need correction.
Bank feeds do not complete the reconciliation automatically
Cloud accounting systems can import bank transactions directly into the bookkeeping platform. This reduces manual entry, but it does not determine the correct purpose or treatment of every transaction.
A bank feed normally provides the date, amount and payment description. It may not identify what was purchased, whether VAT was charged, which customer paid or whether the transaction relates partly to personal activity.
Imported transactions still need to be matched, categorised and supported. Accepting every software suggestion without review can create errors that repeat through automated bank rules.
Businesses establishing a new cloud accounting file can review our guide to setting up a Xero account. Bank feeds, account structures and opening balances should be configured correctly before routine processing begins.
A bank feed can make reconciliation faster. It does not replace bookkeeping judgement or the need to compare the final accounting balance with the underlying statement.
Duplicate transactions and incorrect matches
Duplicate entries often arise when a supplier invoice is entered manually and the subsequent bank payment is recorded again as a new expense. The bookkeeping then contains both the original bill and a second cost created from the bank feed.
A similar problem can occur with customer receipts. A payment may be matched against the wrong invoice, leaving the correct invoice unpaid and clearing an unrelated balance.
Transfers between business accounts are another frequent source of duplication. If one side is recorded as income and the other as expenditure, both turnover and costs can be overstated even though the overall cash position has not changed.
Reconciliation can identify these problems because the bank activity cannot be matched cleanly to the accounting records. The correction should address the underlying duplicate or allocation error rather than forcing the balance to agree through a journal with no supporting explanation.
Card processors and payment platforms
Customer payments collected through card processors and online platforms often reach the bank after fees, refunds, commissions or other deductions. The amount deposited may therefore be lower than the amount paid by the customer.
If a customer pays £1,000 and the processor deposits £970 after retaining a £30 fee, recording only the £970 bank receipt understates both income and processing costs.
The reconciliation should use the processor’s settlement report to record the gross sale, separate deductions and resulting net deposit. The balance held by the processor should also be reviewed where money remains in transit at the reporting date.
Platforms may combine several days of activity into one settlement. The bookkeeping should retain enough detail to connect the deposit to the underlying transactions rather than using one unsupported sales entry.
Cash takings and cash paid into the bank
For businesses receiving cash, the bank deposit may not equal total cash sales. Some money may remain in the till as a float, be paid out for documented expenses or be deposited several days after it was received.
The bookkeeping should begin with the underlying sales record rather than treating the amount banked as total turnover. Cash counts, till reports and paying-in records should explain the movement from sales to the amount deposited.
Differences between expected and counted cash should be recorded and investigated. Reducing reported sales to make the cash balance agree can conceal errors, missing money or weak cash-handling procedures.
HMRC’s guidance on records self-employed businesses must keep includes bank statements and records of sales, income and expenses. The financial records should provide a clear route between the source transactions and the figures used in the tax return.
Credit-card reconciliation
A business credit card should be reconciled in the same way as a bank account. Each purchase, refund, interest charge, fee and repayment should be accounted for.
The payment from the current account to the card provider is normally a transfer or repayment of the card balance, not a new business expense. The underlying purchases should already have been recorded from the card transactions.
Posting both the individual purchases and the subsequent card repayment as expenses duplicates the costs. The credit-card balance may also remain incorrect because the repayment has not been allocated against the liability.
Receipts and supplier invoices should be collected for card purchases. The statement confirms that a payment occurred, but it may not contain enough information to support its business purpose or VAT treatment.
Loan and finance-account reconciliation
Loan repayments commonly contain both repayment of capital and an interest or fee element. Recording the complete payment as an expense can overstate costs and leave the loan balance wrong.
The bookkeeping should agree the liability shown in the accounts with statements or schedules supplied by the lender. Interest and charges should be separated from capital repayments according to the available documents.
Hire-purchase and asset-finance arrangements may also involve deposits, arrangement fees and final payments. The original agreement should be retained so that the bookkeeper and accountant can understand how each transaction affects the liability.
Differences between lender statements and the accounting balance should be investigated before year end rather than left for the accountant to reconstruct.
Why regular reconciliation improves financial reports
A profit and loss report can appear complete while containing duplicated expenses, omitted income or transfers recorded incorrectly. The balance sheet can show bank and credit-card balances that do not agree with the actual accounts.
Regular reconciliation reduces these risks by checking whether every movement has been reflected in the bookkeeping system. Reports produced after reconciliation have a stronger foundation than reports generated from unverified imported transactions.
This is particularly important when the owner uses current figures to make decisions about spending, recruitment, pricing or finance. An unexplained difference can affect profit, debtors, creditors, VAT or the amount of cash thought to be available.
Bank reconciliation does not prove that every accounting judgement is correct. A transaction can agree with the bank while still being allocated to the wrong expense category. It does, however, confirm that the financial movement has been captured and provides a basis for further review.
Bank reconciliation and VAT Returns
A VAT Return is produced from the transactions and VAT codes contained in the bookkeeping system. Missing purchases, duplicated expenses and net platform deposits can all affect the resulting figures.
Bank and payment-platform reconciliation should therefore form part of the VAT preparation process. Differences should be investigated before the return is submitted rather than carried forward without explanation.
Reconciliation does not establish automatically that the VAT treatment is correct. The business still needs suitable invoices and the correct tax code for each transaction.
Where an earlier VAT entry requires correction, the change should remain supported and visible. Our guide to VAT adjustments in Xero explains why corrections need an audit trail.
Bank reconciliation and year-end preparation
The accountant normally needs bank balances that agree with statements at the accounting date. Unreconciled differences can delay the preparation of annual accounts and create additional questions.
Before year end, each bank, credit-card, loan and payment account should be reviewed. Old outstanding items, unidentified receipts and unsupported payments should be resolved where possible.
The accountant may still need to make adjustments for depreciation, tax, accruals and other year-end matters. Reconciled records do not replace this work, but they provide a more dependable starting point.
Businesses using Xero can review our guide to preparing Xero records for year end. Completing reconciliations before the handover can reduce avoidable reconstruction and clarify which matters genuinely require the accountant’s attention.
HMRC records and reconciled accounts
Self-employed businesses must maintain records supporting the income and expenses reported through Self Assessment. Limited companies must keep records of money received and spent, assets, liabilities and other information needed to prepare their accounts and Company Tax Return.
The government’s guidance on company and accounting records confirms that limited companies must maintain records that show and explain their transactions and disclose the company’s financial position with reasonable accuracy.
Bank statements form part of the evidence available to support and verify the accounting records. A completed reconciliation can show how the statement balance connects to the balance used in the accounts.
The reconciliation itself does not correct weak source documentation. The business must still retain invoices, receipts, contracts and other evidence explaining the transactions recorded.
How often bank reconciliation should be completed
The suitable frequency depends on transaction volume, the number of accounts and how quickly the business needs dependable reports. A low-volume account may be reconciled monthly, while a busy trading account may benefit from weekly or more frequent attention.
Waiting until year end allows errors and unidentified entries to accumulate. The longer the delay, the harder it becomes to remember what each payment related to or locate missing documents.
A regular schedule also prevents bank-feed backlogs. Processing a manageable number of recent transactions is generally easier than resolving hundreds of entries shortly before a VAT or accounts deadline.
Our guide to good bookkeeping habits explains how regular processing, document collection and query resolution can keep the records from falling behind.
The cost of leaving accounts unreconciled
Unreconciled accounts can create costs beyond the time needed to process the outstanding transactions. The owner may make decisions using unreliable reports, miss unpaid customer invoices or fail to identify supplier liabilities.
The accountant may also need to reconstruct the records before annual accounts can be prepared. This can move routine bookkeeping correction into a more expensive year-end process.
Our examination of the true cost of DIY bookkeeping explains why delayed reconciliation, owner time and correction work should be considered alongside the absence of a monthly bookkeeping fee.
A business that has accumulated several months of unreconciled transactions may require a catch-up project before an ordinary monthly service can begin. Acting while the difference is still manageable can reduce the amount of historical work required.
How to review an old reconciliation difference
An old difference should be traced back to the period in which it first appeared. Reviewing only the current balance can make it difficult to identify which transaction created the problem.
The bank statement, accounting activity and earlier reconciliation reports should be compared. Search for duplicated amounts, entries with similar dates, deleted transactions and payments posted to a different account.
Opening balances also require attention when bookkeeping software has been introduced partway through the financial year. A wrong conversion balance can cause every later reconciliation to remain out by the same amount.
The correction should describe what was found and preserve the relevant evidence. A suspense entry made solely to force agreement does not resolve the bookkeeping problem unless the underlying transaction has been identified.
When outsourced reconciliation becomes useful
Some owners can maintain their own reconciliations successfully when transaction volumes remain modest and the work is completed consistently. External support becomes more useful when several accounts, payment platforms, VAT or credit cards are involved.
The scope should identify every account to be reconciled and how often the work will be completed. It should also explain how missing documents and unidentified transactions will be raised with the business.
Bookkeeping Packages Ltd provides bookkeeping services for UK businesses, including regular transaction processing and account reconciliation according to the agreed scope.
Where responsibility for the complete monthly process needs to be transferred, our outsourced bookkeeping service explains how ongoing support can be structured.
To discuss unreconciled accounts or a regular bookkeeping process, use the Bookkeeping Packages enquiry form.
About the Author
Stuart Kerr is Managing Director of Bookkeeping Packages Ltd, an outsourced bookkeeping service supporting UK small businesses and accountancy practices. With over 20 years of bookkeeping experience, Stuart specialises in helping businesses maintain reliable financial records and useful management information.
This article is provided for general information only. Stuart Kerr is a professional bookkeeper, not a tax, legal or regulated financial adviser. Nothing in this article constitutes tax, legal or financial advice. Advice specific to your circumstances should be obtained from an appropriately qualified professional.