Implement automated bank reconciliation matching patterns

domain: developer.xero.com · 6 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗

Steps

  1. Pull unreconciled bank statement lines (imported bank feed entries) and unreconciled accounting transactions (invoices, bills, payments) from the accounting API using the appropriate endpoints.
  2. Apply exact-match rules first: match a bank statement line to an accounting transaction where amount, date (within a configurable tolerance), and reference/description match exactly.
  3. Apply fuzzy-match rules for near-matches: match on amount exactly with date within a configurable window (e.g., ±5 days), or match on a partial reference string using string similarity scoring.
  4. For transactions with no direct match, apply rule-based auto-coding: map known merchant names or bank reference patterns to specific GL accounts and create new accounting transactions accordingly.
  5. Present unmatched items to a human reviewer via your application UI; allow manual matching and rule creation to feed back into the matching engine.
  6. After confirming a match, call the accounting API's reconciliation endpoint to link the bank statement line to the accounting transaction and mark both as reconciled.

Known gotchas

Related routes

Match incoming bank transactions to internal payment records using a deterministic reconciliation algorithm
docs.moderntreasury.com · 6 steps · unrated
Create and match Modern Treasury expected payments to incoming bank transactions for automated reconciliation
docs.moderntreasury.com · 6 steps · unrated
Reconcile QuickBooks Online Payments and match them to bank deposit records
developer.intuit.com · 6 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans