End-of-day reconciliation proves that the cash position in treasury or accounting records agrees to the bank statement after known timing items are identified. This guide explains the mechanics, evidence, risks and controls a UK business should understand before relying on the process.
What end-of-day bank reconciliation means in practice
End-of-day reconciliation proves that the cash position in treasury or accounting records agrees to the bank statement after known timing items are identified. The practical question is whether the business can prove the condition was met at the moment money or authority was needed.
A difference is not resolved simply because it is labelled 'timing': the item should have an owner, expected clearing date and evidence explaining why it remains open. That wording should be translated into a short internal test showing the trigger, deadline, decision owner and evidence required for the business to proceed.
How end-of-day bank reconciliation works from start to finish
The minimum decision pack is book balance, bank closing balance, uncleared payments, in-transit receipts, bank fees, interest, returned items, value dates and unresolved reconciling items. If any of those fields is uncertain, the transaction should remain open rather than being treated as complete.
Operational ownership should follow the transaction through to its final state. The person who initiates an action does not need to perform every later step, but the business must know who owns unresolved exceptions.
The data and evidence that matter
Records should be proportionate to the exposure. A routine low-value item may need a simple system trail, while a material end-of-day bank reconciliation decision should preserve the underlying calculation, approvals and any exception accepted by management.
An effective record should also make the exception path visible. If the normal rule cannot be met, the team should capture who approved the deviation, how long it applies and what evidence will close it. For end-of-day bank reconciliation, that distinction prevents a temporary workaround from becoming an undocumented permanent practice. The control owner should also state which exact external record will prove completion for end-of-day bank reconciliation, because an internal status alone is not enough.
Where the process can fail
Treasury can invest cash that appears surplus in the ledger even though an unrecorded bank debit or returned customer receipt has already reduced the real balance. The financial exposure can grow quickly when the issue is discovered close to settlement, drawdown or payment day.
Deadline pressure can also weaken controls. If the process depends on an emergency override every month, the underlying timetable is wrong and should be redesigned rather than normalising exceptions.
Worked example: test the mechanics
The ledger shows £8.4 million while the bank statement shows £7.9 million. A £450,000 supplier payment is booked in the ledger for tomorrow's value date, while a £50,000 bank charge is missing from the ledger. The two items explain the difference differently and should not be netted into one unexplained £500,000 variance.
This example is a method rather than a universal rule. The business should replace every illustrative figure with its own contractual terms, bank data and dates, then test the result before assuming that cash or authority is available.
Governance and controls for end-of-day bank reconciliation
Use daily automated matching where practical, but require manual investigation of material unmatched items and aged exceptions. The procedure should identify the primary owner, reviewer and escalation contact so an absence does not suspend a material payment or funding decision.
Changes to systems, bank services or finance documents require retesting from source instruction through reconciliation. A migration is not complete merely because the file transmits or the new document has been signed.
Senior review is most valuable where judgement remains. Automated controls can check limits and formats, but unusual legal, liquidity or counterparty issues still need an accountable person to decide whether the business should proceed.
Closing cash should be signed off only after material reconciling items have an explanation and owner. A large unmatched debit is a liquidity fact even if accounting has not classified it yet, while an uncleared book entry may not have reduced bank cash at all. Reconciliation should preserve that distinction for the next day's funding decisions.
This makes the control decision-focused: staff know what evidence is sufficient, what is still unresolved and which person can accept an exception. The resulting record should be short enough to use during a live deadline but detailed enough for finance, audit or a replacement treasury colleague to reconstruct the reasoning later. Before approving a material end-of-day bank reconciliation action, the reviewer should challenge the assumption most likely to change the cash outcome rather than merely confirm that every box has been ticked.
Editorial Verdict
BanksGB's editorial view is that end-of-day bank reconciliation should be managed as a practical cash-and-control issue. End-of-day reconciliation proves that the cash position in treasury or accounting records agrees to the bank statement after known timing items are identified. The strongest process connects the governing rule to the amount, timing, legal entity and external status instead of relying on the product label.
The final test is whether a second person could explain the transaction from the retained record: what triggered the action, which data was used, who approved it, what the bank or lender did and what remains outstanding. If that cannot be answered, the control around end-of-day bank reconciliation is weaker than it appears. Any exception should identify the affected legal entity and the cash consequence, not merely describe the issue as an operational error.
Sources
- Swift, bank-to-corporate reporting best practices: https://www.swift.com/sites/default/files/files/swift_cgi-mp-wg2-iso-20022-camt.05x.001.08-best-practices-version1.1-2023-08.pdf
- Association of Corporate Treasurers, treasury resources: https://www.treasurers.org/