Bank reconciliation: how to do it step by step, and how to automate it
Manoj Tutika · Published 16 November 2026 · Last checked 16 November 2026
Working on this yourself? Talk to Mark, our co-founder. We’re here to solve it with you.
What is a bank reconciliation, and why does it matter?
A bank reconciliation proves that the cash in your books is the cash in the bank. You take the balance on the statement at a date, take the balance of the bank account in the ledger at the same date, and explain every difference. It is the first check in any month-end close because almost every other number depends on it. If cash is wrong, receivables, payables and VAT are probably wrong too.
In modern software, the reconciliation runs line by line. Each bank line is matched to a sales invoice, a supplier bill, a payroll run or a journal. What remains unmatched is either missing from the books or a timing difference.
How do you do a bank reconciliation step by step?
- Pick the date and get the statement balance. Usually the last day of the month. Use the closing balance on the statement or the bank feed, not the app on your phone.
- Bring the ledger up to date. Book every sales invoice, supplier bill and expense for the period before you start matching.
- Match each bank line. Receipts to open sales invoices, payments to open bills, transfers to the other bank account, card settlements to the card account.
- Book what only the bank knows. Bank charges, interest, direct debits nobody entered and refunds.
- List timing differences. Payments you sent that have not cleared and deposits that have not arrived. Each one should clear within days; if not, investigate.
- Check the result. The ledger balance, adjusted for timing differences, must equal the statement balance to the penny.
- Review what is old. An unmatched line older than 30 days is a problem, not a timing difference.
What does a bank reconciliation look like in numbers?
| Item | Amount |
|---|---|
| Balance per bank statement | £84,210.40 |
| Add: customer receipt in transit | £3,600.00 |
| Less: supplier payment sent, not yet cleared | £-5,940.00 |
| Adjusted bank balance | £81,870.40 |
| Balance per ledger before adjustments | £82,013.15 |
| Less: bank charges not yet booked | £-42.75 |
| Less: card fee on payout not yet booked | £-100.00 |
| Adjusted ledger balance | £81,870.40 |
| Difference | £0.00 |
Both sides end at £81,870.40, so the account reconciles. The bank charges and card fee are booked as journals; the two timing items should clear in the first days of November.
Where do differences usually come from?
- Payment provider payouts. Stripe, PayPal and similar providers pay out a net amount covering many sales, less fees and refunds. One bank line has to be split across dozens of invoices and a fee.
- Duplicated feed lines. A bank feed that reconnects can import the same line twice. Matching both creates a phantom receipt.
- Part payments and combined payments. A customer pays three invoices in one transfer, or pays an invoice less a disputed amount.
- Wrong matches. Two invoices for the same amount from the same customer, and the payment is matched to the wrong one.
- Foreign currency. A EUR receipt into a GBP account at a rate that differs from the invoice rate leaves a small exchange difference.
How do you automate bank reconciliation?
Automation has three layers. The first is a bank feed, so lines arrive every day without uploads. Xero, Exact Online and most cloud packages offer feeds through open banking. The second is matching: rules or machine learning that propose the invoice or bill each line belongs to, using amount, reference, counterparty and date. Xero suggests matches in its reconcile screen, and Exact Online has automatic matching on bank entries.
The third layer is where most teams stop short: handling the exceptions. Rules match the easy 70 or 80 lines. The rest, the payouts, part payments and unknown receipts, still land on someone's desk. That is where an agent earns its place, because it reads the remittance in the email, looks at the customer's history and proposes the split.
| Task | Rules in your software | An agent |
|---|---|---|
| Import bank lines | Bank feed | Same feed, checked for duplicates |
| Match exact amount and reference | Yes | Yes |
| Match part and combined payments | Rarely | Yes, from remittance and history |
| Split payment provider payouts | Only with an integration | Yes, from the provider's report |
| Book bank charges and interest | With bank rules | Yes, coded like last month |
| Chase unknown receipts | No | Asks the right person with the context |
How often should you reconcile?
Monthly is the minimum for the close and for VAT under Making Tax Digital, where your records have to be complete for each return period. Weekly is better for any business with more than a few hundred bank lines a month. Daily is what automation makes possible: when matching happens as lines arrive, the month-end reconciliation is a review of a handful of exceptions. See the UK month-end close checklist for where it fits in the close.
What do Thred's agents do with bank reconciliation?
Thred is a team of AI agents that takes the recurring finance work off your team, on the accounting software you already use. The Connector brings in bank lines and payouts from Stripe, Shopify, PayPal and Mollie, and finds the remittance in your inbox. The Bookkeeper keeps the record up to date: it matches each line to the invoice or bill it belongs to, splits payouts into sales, fees and refunds, books bank charges the way you booked them before and flags duplicates before they are matched.
On Exact Online the agent matches payments to invoices from the chat and writes the result back, with each write shown for your approval until you allow a type of match. The Analyst tells you what moved in cash this week. Read the Exact Online automatic bank reconciliation guide or see Thred Layer.
Frequently asked questions
What is a bank reconciliation?
It is the check that the cash balance in your accounting records agrees with the balance on the bank statement at a date, with every difference explained. In practice it also means every bank line is matched to an invoice, bill or journal in the ledger.
How often should you reconcile your bank account?
At least monthly as part of the close, and better weekly or daily. A reconciliation with 40 unmatched lines takes minutes; one with 900 lines from three months ago takes days.
What are the most common reconciling items?
Payments you made that have not cleared, deposits in transit, bank charges and interest not yet booked, card and payment provider payouts that combine many sales, duplicated bank feed lines and payments matched to the wrong invoice.
Can bank reconciliation be automated?
Most of it. Bank feeds bring in the lines, and rules or AI match them to open invoices and bills by amount, reference, date and counterparty. A person then reviews only the lines that do not match with confidence.
Do I need a bank reconciliation template in Excel?
Only if your accounting software cannot reconcile, or for a one-off check. Xero, Exact Online and most modern packages reconcile against a bank feed. A spreadsheet adds a copy of data that can drift from the ledger.
What is the difference between a bank reconciliation and matching?
Matching links a single bank line to an invoice or bill. The reconciliation is the overall proof that, after matching and booking, the ledger balance equals the statement balance.
Sources
- Xero UK, Bank reconciliation
- Exact Online, bank reconciliation (help centre)
- GOV.UK, Making Tax Digital for VAT
- Thred Layer, AI agents on your existing accounting software
Read next
- Automatic bank reconciliation in Exact Online: what matches and what you still do by hand
- Getting messy exports into your books: how to clean CSVs from banks, webshops and payroll reliably
- Duplicates, retries and idempotency: keeping the ledger right when data arrives twice
- Why a reconciled bank in Exact Online can still be wrong
- AI bookkeeping for UK SMEs: what it does today, and what still needs a person
- Suspense account in Xero: how to create, use, clear and reconcile it, with a worked example
Where Thred comes in
Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.
