What a bank reconciliation actually proves
A bank reconciliation explains how the bank statement and the accounting ledger arrive at the same balance for the same account and date. It separates transactions that need a bookkeeping correction from genuine timing differences. The useful output is not simply a green tick in an application: it is a schedule another person can follow, with evidence for every outstanding item.
For a Cyprus company, this supports reliable records throughout the year. The Registrar of Companies explains directors’ responsibility for accounting books and records that explain transactions and support financial statements. The monthly workflow below is a recommended business control, not a claim that every private company must use a particular reconciliation form or software product.
This guide focuses on investigating cash differences. Use the month-end close checklist for the wider reporting timetable and management accounts guide for interpreting the finished figures. A reconciled bank balance alone does not prove that income, VAT or every other balance-sheet account is correct.
Start with the complete account population
List every place where the business holds or owes money through a financial provider. Include operating and deposit accounts, foreign-currency accounts, corporate cards, payment wallets and processor clearing balances. A second account with little activity still needs attention: bank fees, interest or a single owner transfer can create an unexplained difference.
Record the legal owner, account identifier, currency, ledger code and person responsible for each reconciliation. Keep accounts belonging to different companies separate, even where the same director controls them. A transfer from one group company to another is not simply a transfer between two bank accounts of the same entity; the corresponding intercompany balances also need recording.
| Account type | Evidence to obtain | Particular risk |
|---|---|---|
| Current or deposit account | Complete statement and ledger export | Missing charges, duplicates or incorrect cut-off |
| Corporate credit card | Card statement, expense documents and settlement | Recording the expense again when the card is paid |
| Payment processor | Transaction, fee, refund, reserve and payout reports | Confusing net payouts with gross sales |
| Foreign-currency account | Statement in original currency and valuation records | Mixing transaction mismatches with exchange differences |
Do not substitute the online “available balance” for the statement balance without understanding the difference. Card authorisations, pending payments and overdraft availability can affect what the banking screen displays. Your reconciliation must identify the exact balance being compared, rather than choosing whichever number happens to match the ledger.
Collect the evidence before matching transactions
Download the statement covering the entire period and retain the previous approved reconciliation. Check that the new opening balance agrees with the previous closing balance. Export the ledger through the same closing date, including transactions entered after month end but posted into the month being reviewed.
For an automated bank feed, compare its date coverage and opening and closing balances with the provider’s statement. A feed can disconnect, omit a period or overlap with a manually imported file. Before importing missing transactions, check whether a colleague has already entered them manually. Otherwise a completeness correction can create duplicates.
Keep invoices, receipts, supplier statements and remittance notices accessible. A bank debit proves money moved; it does not by itself establish the business purpose, supplier identity or entitlement to recover VAT. The business expense records checklist explains what to keep alongside payment evidence.
A practical monthly reconciliation workflow
- Confirm scope and cut-off. Select one entity, account, currency and closing date. Bring forward each unresolved item from the previous reconciliation with its original reference.
- Check the opening position. If it changed after the previous review, identify the backdated entries before working on the current month. Do not hide an opening error in a current-month adjustment.
- Match the straightforward movements. Compare amount, date, counterparty and reference. Match customer receipts against their invoices and supplier payments against the bills they settle.
- Investigate grouped and split payments. A single deposit can settle several invoices; one invoice can be paid in instalments. Save the allocation rather than forcing a one-to-one match.
- Post supported omissions or corrections. Record missing charges and approved corrections with document references. Confirm whether an imported line should match an existing entry or create a new one.
- List genuine timing differences. Identify the transaction, expected settlement and later evidence. Retain the original date rather than repeatedly resetting its age.
- Review and close. Recalculate the reconciliation, approve the final version and assign unresolved questions to a named person with a follow-up date.
Monthly review is a sensible baseline for many small businesses. High transaction volumes, tight liquidity or elevated payment risk may justify weekly or daily work. The frequency is a management decision based on risk; reconciling once a year makes it harder to retrieve evidence and distinguish an old error from an ordinary delay.
Worked example: correcting a €220 difference
Assume a single euro account at month end. Its statement balance is €12,480, while the ledger shows €12,700. Investigation identifies a €20 bank charge not entered in the books and a €200 receipt already recorded in the period but credited by the bank the following day. Assume the accounting cut-off for that receipt is appropriate and later settlement is evidenced.
| Book side | Amount | Bank side | Amount |
|---|---|---|---|
| Ledger closing balance | €12,700 | Statement closing balance | €12,480 |
| Missing bank charge | −€20 | Evidenced receipt in transit | +€200 |
| Corrected ledger balance | €12,680 | Adjusted statement balance | €12,680 |
The €20 changes the books: debit the appropriate bank-charge expense and credit the bank ledger, subject to the correct classification of the actual charge. The €200 does not require another receipt if it is already correctly recorded. When the bank feed imports its settlement, match it to the existing transaction. Creating a fresh receipt would overstate the bank ledger or duplicate the customer settlement.
If the supposed €200 receipt cannot be traced to an actual payment, it is not an acceptable balancing item. Revisit the original entry and the period in which it should be recognised. The arithmetic can balance while the explanation is wrong. This is why the schedule should contain references and later clearance evidence, not just amounts.
Which differences require a journal?
A missing or incorrect ledger transaction needs an accounting correction. A valid timing difference normally stays on the reconciliation until settlement. A bank error requires investigation with the provider; changing your books simply to copy an incorrect bank movement can obscure the underlying issue.
| Difference | Suggested investigation | Possible treatment |
|---|---|---|
| Bank fee absent from the ledger | Obtain the charge advice and check classification | Post the supported charge |
| Same receipt imported twice | Compare unique references and matching history | Reverse or remove the duplicate through the proper audit trail |
| Recorded payment not yet presented | Check authorisation, issue date and subsequent settlement | Retain a supported outstanding item if recording is appropriate |
| Customer pays an unexpected amount | Check remittance, deductions, credit notes and currency | Allocate the receipt and investigate the residual balance |
| Provider records an unauthorised payment | Escalate promptly and retain the dispute evidence | Assess the accounting separately from recovery expectations |
A temporary suspense classification should identify what is unknown, who will resolve it and when. It is not a permanent substitute for knowing the transaction. Do not clear a difference to sales, miscellaneous expense or a director account solely because that makes the reconciliation balance.
Worked example: a payment-provider clearing account
Suppose a processor starts the month owing the business €400. During the month it collects €10,000 from customers, processes €600 of refunds, deducts €300 in fees and pays €9,000 into the company’s bank. The expected closing provider balance is €500: €400 + €10,000 − €600 − €300 − €9,000.
Reconcile that €500 to the provider’s closing report. If part of it is a rolling reserve, document the restriction and expected release separately. The €9,000 payout is a transfer from the processor balance to the bank account; it is not another €9,000 of revenue. The original customer transactions must be analysed using the relevant invoices, sales and tax records.
These are illustrative cash movements, not a VAT calculation. Whether amounts include VAT and how refunds affect the VAT return depend on the underlying supply and documentation. The VAT invoice checklist and credit-note guide address those separate questions. Chargebacks should also be distinguished from ordinary refunds because the dispute and recovery position may differ.
Foreign currencies and transfers between accounts
First reconcile a dollar account in dollars, or a sterling account in sterling. If statement and ledger currency units agree but their euro equivalents differ, investigate exchange rates and valuation rather than inserting a fictitious cash movement. If the currency units disagree, solve the underlying transaction mismatch first.
For a transfer between two company accounts, trace both sides. The sending bank may debit funds before the receiving bank credits them. Record the reference, dates and any intermediary fee. Where currencies differ, retain the conversion advice so the received amount, charges and exchange effect can be explained.
IAS 21 addresses foreign-currency accounting; reconciliation does not determine a company’s functional currency or replace the applicable valuation policy. Our multi-currency bookkeeping guide treats invoice recognition, settlement and reporting-date revaluation as distinct stages.
Investigate old items without destroying the audit trail
Maintain an exception log with the original date, amount, explanation, supporting document, responsible person and next action. Review age as well as value. A small unexplained item repeated every month may expose a broken import rule, while a large outstanding payment may indicate that a supplier was never actually paid.
For an old unpresented payment, confirm whether it remains valid, was cancelled or was replaced. If a replacement has been issued, check both entries before reversing anything. For an unidentified receipt, examine remittance emails, invoice balances and payer details without assuming the payer’s name must match the customer’s trading name.
Preserve the original import and correction history where the system permits. If the month has already been reviewed, record why it was reopened and whether the change affects issued reports or a submitted return. An accounting correction and an amendment to a tax return are separate decisions; do not assume one automatically completes the other.
Review controls for a small finance team
Ideally, the reviewer is different from the person who prepared payments and performed the reconciliation. Where staffing makes that impossible, the owner can independently inspect the statement, unusual payees, manual journals and unresolved items. A second check should challenge the explanation, not merely confirm that the final difference is zero.
Consider read-only banking access for staff who only need statements, appropriate payment-approval limits and a clear process for supplier bank-detail changes. Never send banking passwords through an ordinary enquiry form. Automated matching rules also need review: a rule that codes every payment to a familiar name as the same expense can misclassify loans, reimbursements or refunds.
The reconciliation can reveal warning signs, but it is not proof that fraud cannot occur. Nor does it replace an independent audit or review. For the year-end evidence requested by an auditor, see the audit preparation checklist.
What to hand to your accountant
Provide the complete statement, ledger export, final reconciliation, adjustment references and exception log for each account. Include payment-provider reports, foreign-exchange evidence and the next period’s transactions needed to demonstrate clearance. State the period covered and whether any transactions were posted after the pack was prepared.
- Does every account appear on the account register?
- Do opening balances agree with the preceding approved month?
- Are corrections posted once, with supporting evidence?
- Can each timing difference be traced to a real transaction?
- Are old items assigned for action rather than silently carried forward?
- Has the reviewer recorded outstanding questions and the approval date?
The reconciled cash position also feeds the 13-week cash-flow forecast, but it should not be confused with cash available to spend after upcoming liabilities. If you need help with a backlog, start by identifying the accounts, missing periods and transaction volume. Our accounting and bookkeeping service can assess the work and propose a scope before adjustments are made.