Xero bank reconciliation from the bank statement
“reconcile the bank statement csv with our xero business checking lines within 3 days, exact amount first then within $10, and show date, description, statement amount, xero amount, difference = statement minus xero, and status: Matched, Amount differs, Missing”
reconcile the Bank statement CSV with our Xero bank transactions for business checking account within 3 days, exact amount first then within $10, and show date, description, statement amount, xero amount, difference = statement minus xero, and status: Matched, Amount differs, Missing
What the agent built
6 steps, each one an ordinary Mammoth step you can open and change.
- FileBank statement CSVCSV export · 40 rows
- FileXero bank transactions for business checking accountCSV export · 40 rows
- StepNumber statement linesStep 1
- StepNumber Xero checking linesStep 3
- StepMake statement match keysStep 2
- StepMake Xero match keysStep 4
- JoinBring in Xero candidates261 of 320 paired
- StepMatch and flag bank linesStep 6
- ResultBank Reconciliation40 rows · 1 flagged
- ScheduleRuns when you sayProposed
On the sample files, every step runs and the result has 40 rows.
- Download Bank statement CSV sample (40 rows)Xero: Bank accounts > business checking account > Statements > Export CSV
- Download Xero bank transactions for business checking account sample (40 rows)Xero: Accounting > Bank accounts > business checking account > Account transactions > Export CSV
What you get back
The result of that run, the rows to look at first.
| Date | Description | Statement amount ($) | Xero amount ($) | Difference ($) | Status |
|---|---|---|---|---|---|
| 2026-10-17 | Client receipt - Blue Harbor Creative | 3,600 | 3,592 | 8 | Amount differs |
| 2026-10-01 | Square payout #SQP-10421 | 1,265.40 | 1,265.40 | 0 | Matched |
| 2026-10-01 | ACH deposit - Blue Harbor Creative retainer | 4,800 | 4,800 | 0 | Matched |
| 2026-10-02 | Check 1187 - Westside Print Co | -412.50 | -412.50 | 0 | Matched |
| 2026-10-02 | Stripe payout #po_1042 | 2,194.18 | 2,194.18 | 0 | Matched |
| 2026-10-03 | ACH deposit - Northline Bistro campaign | 1,550 | 1,550 | 0 | Matched |
| 2026-10-03 | Gusto payroll | -6,825 | -6,825 | 0 | Matched |
| 2026-10-04 | Adobe Creative Cloud | -84.99 | -84.99 | 0 | Matched |
| 2026-10-04 | Slack subscription | -79.20 | -79.20 | 0 | Matched |
| 2026-10-05 | Stripe payout #po_1048 | 1,988.34 | 1,988.34 | 0 | Matched |
| 2026-10-05 | Client receipt - Alder Design | 2,400 | 2,400 | 0 | Matched |
| 2026-10-06 | ACH deposit - Green Finch Labs | 3,250 | 3,250 | 0 | Matched |
How it works
How to use the Bank Reconciliation workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Bank Reconciliation: questions
How do you reconcile a bank statement with Xero bank transactions?
What export should you use from Xero?
What happens to rows that do not match?
How do you change the matching rules?
Get early access to this workflow
It opens already built and working on sample files. Swap in your own exports to see your result.
Workflows like this
Bank to ledger, payouts to deposits, returns to books. Every row comes back matched, or flagged with the reason.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Match customer payments to open invoicesMatch bank payments to QuickBooks open invoices by customer and amount, and see what is still unapplied.See the workflow Built by the agent
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent