About Services Tools Blog Contact us

Bank Statement Reconciliation

Works through unreconciled bank lines in a live Xero session, checks the tax treatment against the supplier invoice, codes the line and attaches the file.

  • Accounting & Reconciliation
  • Professional services
  • Agent skill
  • Productised
  • Hybrid
  • 2026

The problem

Statement lines from card processors and bank feeds sit unmatched. Coding them in bulk, or accepting the previous payee's suggestion, puts the wrong account or the wrong tax on the line. The invoice never gets attached.

What it does

A helper works in one chosen Safari tab that is already signed in to Xero, so it never acts on whichever tab is in front. It checks the total, the amount before tax and the tax against the invoice, codes the line only after a practice run, and attaches the file once the attachment count has gone up. A posted line can have its tax rate or account changed without deleting or creating transactions. The helper stops if the page layout is not as expected.

Outcomes

  • The unreconciled list gets shorter, with the invoice attached on each cleared line.
  • A line is blocked when the invoice disagrees with the suggested tax.
  • A practice run fills the form and stops before saving.
  • Every change has a before-and-after record, and the helper stops if the page layout has changed.

Simplified mockup

Interactive preview with sample data. Nothing is sent to a server.

Unreconciled

Open lines
4
No invoice
1
Tax mismatch
1
ContactGrossCheckState
Harbour Print £486.00 Passes Selected
North Quay Hosting £144.00 Passes Ready
Field Survey £720.00 No invoice Blocked
Studio Electric £312.00 £12 out Blocked
Invoice INV-1044
Gross£486.00
Net£405.00
VAT£81.00
Suggested account461 Print and production
Tax20% on expenses
Variance£0.00
Attachments0
Dated28 Sep 2026
Dry run has not started
Confirm has not started

Posted spend

Lockside Storage · 3 Oct 2026 · £216.00
Account429 General expenses
TaxNo VAT
Gross stays£216.00
After tax splitNet £180.00 · VAT £36.00
Apply changes the account and the tax on this page only. The transaction is not deleted.
Not applied

Before and after

Layout OK
The helper stops if the reconciliation table is missing. This preview found the table, so the queue and the recode were allowed. Nothing here is written to a ledger.
What happenedRecord
Page structure checked before any coding. Passed

How it works

  1. List unreconciled lines on the signed-in tab, with the suggested contact, account and tax.
  2. Open the matching invoice and compare the total, the amount before tax and the tax before anything is confirmed.
  3. Do a practice run of the coding, then confirm the line so it leaves the list.
  4. Find the posted transaction and attach the invoice, checking the attachment count went up.
  5. Change the tax or account on a posted spend from a single line or a batch file, and keep a before-and-after record.

Pipeline

flowchart LR
  Queue[Unreconciled lines] --> Inv[Supplier invoice]
  Inv --> Tax[Tax and account check]
  Tax --> Code[Code the line]
  Code --> Attach[Attach file]
  Attach --> Left[Lines still open]
  Recode[Posted recode] --> Attach