Skip to content
Workflow · Match two lists · Opening soon

Xero bank reconciliation from the bank statement

Export the bank statement as a CSV and export the Xero bank transactions for the same account and month. This workflow matches lines by amount and date within 3 days, then shows matched rows, amount differences, and rows missing from either side.

Early access opens shortly. Check back soon.

Someone typed

“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”

The agent read it as

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.

  1. File
    Bank statement CSV
    CSV export · 40 rows
  2. File
    Xero bank transactions for business checking account
    CSV export · 40 rows
  3. Step
    Number statement lines
    Step 1
  4. Step
    Number Xero checking lines
    Step 3
  5. Step
    Make statement match keys
    Step 2
  6. Step
    Make Xero match keys
    Step 4
  7. Join
    Bring in Xero candidates
    261 of 320 paired
  8. Step
    Match and flag bank lines
    Step 6
  9. Result
    Bank Reconciliation
    40 rows · 1 flagged
  10. Schedule
    Runs when you say
    Proposed

On the sample files, every step runs and the result has 40 rows.

What you get back

The result of that run, the rows to look at first.

Bank ReconciliationSample data40 rows
39 matched1 amount differs
DateDescriptionStatement amount ($)Xero amount ($)Difference ($)Status
2026-10-17Client receipt - Blue Harbor Creative3,6003,5928Amount differs
2026-10-01Square payout #SQP-104211,265.401,265.400Matched
2026-10-01ACH deposit - Blue Harbor Creative retainer4,8004,8000Matched
2026-10-02Check 1187 - Westside Print Co-412.50-412.500Matched
2026-10-02Stripe payout #po_10422,194.182,194.180Matched
2026-10-03ACH deposit - Northline Bistro campaign1,5501,5500Matched
2026-10-03Gusto payroll-6,825-6,8250Matched
2026-10-04Adobe Creative Cloud-84.99-84.990Matched
2026-10-04Slack subscription-79.20-79.200Matched
2026-10-05Stripe payout #po_10481,988.341,988.340Matched
2026-10-05Client receipt - Alder Design2,4002,4000Matched
2026-10-06ACH deposit - Green Finch Labs3,2503,2500Matched
40 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Bank Reconciliation workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and working on sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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?
Export the bank statement as a CSV and export the Xero bank transactions for the same account and month. This workflow matches lines by amount and date within 3 days, then shows matched rows, amount differences, and rows missing from either side.
What export should you use from Xero?
Use the exported bank transactions for the account you want to reconcile. The file should include the transaction date, description, and amount.
What happens to rows that do not match?
Rows that do not find a match are kept in the result and marked as Missing. If a row matches by date but the amount is different, it is marked as Amount differs.
How do you change the matching rules?
You change the rules in words, such as the date window, amount tolerance, and which fields to compare. Then the workflow reruns with the updated matching steps.

Get early access to this workflow

It opens already built and working on sample files. Swap in your own exports to see your result.

Early access opens shortly. Check back soon.