Work snippet
Xero bank reconciliation: before and after
Concept DesignIllustrative integration walkthrough. Business details, figures and records are worked examples.
A service business whose bank account had gone months without reconciliation. The backlog is cleared line by line, bank rules are set for repeating items, and the account closes at a difference of 0.00.
The problemThe bank account has not been reconciled for months.
What changesBacklog cleared, bank rules set, and the difference at 0.00.
- Area
- Bookkeeping
- Tools
- Xero
- Typical scope
- US$150-400
- Timeline
- About 2 weeks · fixed milestones
The problem
The feed was connected but nobody kept up with it. Receipts sat unmatched, paid bills still looked open, and the Xero balance no longer agreed with the bank.
- A balance in Xero that is tens of thousands out from the bank
- Invoices that look unpaid, so customers are chased for money already received
- Reports the accountant cannot rely on
- A month-end that starts with a week of catching up
Approach
- Look
Read-only review of the feed, the open invoices and bills, and the last reconciliation. The backlog is counted and sorted by type.
- Match
Receipts are matched to invoices and payments to bills. Duplicates and stale entries are listed, then removed with a reason.
- Set rules
Bank rules for fuel, software, bank fees and other repeat items, so most lines clear themselves next month.
- Hand over
Statement balance and Xero balance agreed at a set date, a one-page monthly routine, and a list of anything that needed a decision.
Exhibit
Before: Business Cheque Account
| Statement balance | 48,210.55 |
| Balance in Xero | 31,874.20 |
| Unreconciled bank lines | 143 |
| Duplicate or stale entries in Xero | 9 |
After: Business Cheque Account
| Statement balance | 48,210.55 |
| Balance in Xero | 48,210.55 |
| Unreconciled bank lines | 0 |
| Duplicate or stale entries in Xero | 0 |
| What the 143 lines were | Lines | How they were cleared |
|---|---|---|
| Customer receipts | 61 | Matched to the open invoice |
| Supplier payments | 38 | Matched to the bill, or a bill created |
| Repeat items (fuel, software, bank fees) | 27 | Cleared by new bank rules |
| One-off spend with no document | 11 | Coded, receipt requested |
| Transfers between accounts | 4 | Transfer entry created |
| Duplicates | 2 | Removed, reason noted |
| Total | 143 | Unreconciled lines at handover: 0 |
How the backlog built up (unreconciled lines at each month-end)
How to read it
- The same account, on the same date: a difference of $16,336.35 at the start and 0.00 at handover.
- The 143 lines are shown by type, so you can see where the time went and which part the bank rules now handle.
- The bar chart shows how the backlog built up, which is why a monthly routine matters more than a one-off clean-up.
Scope
| Area | Included |
|---|---|
| Review | Read-only look at the bank feed, open invoices and bills, and the last reconciliation, with a written findings list |
| Backlog | Every unreconciled line cleared for the agreed period, matched or coded, with a note on anything uncertain |
| Duplicates | Duplicate and stale entries listed and removed, with a reason for each |
| Bank rules | Rules created and tested for repeat items |
| Check | Statement balance agreed to the Xero balance at a named date, with a reconciliation report saved |
| Handover | A one-page monthly routine and a 30-minute walkthrough |
| Not included | Changing the chart of accounts, or moving to different accounting software |
Milestones and fee
| Milestone | Deliverable | Timing | Share of fee |
|---|---|---|---|
| M1 Review | Findings list, count of lines by type, fixed quote | Days 1 to 3 | 20% |
| M2 Backlog cleared | All lines for the period matched or coded | Week 1 to 2 | 40% |
| M3 Rules and check | Bank rules live, difference at 0.00 | Week 2 | 25% |
| M4 Handover | Monthly routine and walkthrough | Week 2 | 15% |
Typical scope for this kind of project: US$150-400
About 2 weeks · fixed milestones. The systems health check (US$150, fixed) comes first and confirms the scope. Extra hourly work is US$35 per hour, agreed before it starts.
Discuss an engagement.
Outline the operational problem through the contact form. I respond with a recommended starting point, including whether the US$150 systems health check is the appropriate first step.