Thred

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.

Book a demo

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?

  1. 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.
  2. Bring the ledger up to date. Book every sales invoice, supplier bill and expense for the period before you start matching.
  3. 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.
  4. Book what only the bank knows. Bank charges, interest, direct debits nobody entered and refunds.
  5. 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.
  6. Check the result. The ledger balance, adjusted for timing differences, must equal the statement balance to the penny.
  7. 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?

Worked example: bank reconciliation at 31 October 2026
ItemAmount
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.

What to automate, and how
TaskRules in your softwareAn agent
Import bank linesBank feedSame feed, checked for duplicates
Match exact amount and referenceYesYes
Match part and combined paymentsRarelyYes, from remittance and history
Split payment provider payoutsOnly with an integrationYes, from the provider's report
Book bank charges and interestWith bank rulesYes, coded like last month
Chase unknown receiptsNoAsks 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

  1. Xero UK, Bank reconciliation
  2. Exact Online, bank reconciliation (help centre)
  3. GOV.UK, Making Tax Digital for VAT
  4. Thred Layer, AI agents on your existing accounting software

Read next

Where Thred comes in

Thred Layer

Finance agents running on top of your existing ledger. You set the rules, approve the work and handle the exceptions. No migration.

Finance, handled.

Book a demo, or request a callback and we will call you.

Book a demo