# Categorise bank lines and match payments to invoices and bills

> Categorise bank lines and match payments to invoices and bills: 2 companies fully do it, 4 with a limit, 19 carry the tag. Every listing in Accounting & invoicing with the reason and a source.

- Canonical: https://www.anchorterminal.com/niches/accounting.reconcile-bank/
- Markdown: https://www.anchorterminal.com/niches/accounting.reconcile-bank/index.md (~1,550 tokens)
- Slim: https://www.anchorterminal.com/niches/accounting.reconcile-bank/index.min.md (~280 tokens, same facts, less prose, for token-sensitive contexts)
- JSON: https://www.anchorterminal.com/niches/accounting.reconcile-bank/index.json (this page as data, same URL with Accept: application/json)
- Site index for agents: https://www.anchorterminal.com/llms.txt (the key docs and every listing in one file, at most 16 MB, about 4 million tokens: https://www.anchorterminal.com/llms-full.txt)
- API: https://www.anchorterminal.com/api/v1/index.json
- MCP: https://www.anchorterminal.com/mcp (the whole catalogue as tools, no key)
- DNS: dig +short TXT <slug>.grade.anchorterminal.com (the grade as a DNS TXT record, for a sandbox with no HTTP where names still resolve; also top., best.<category>. and <a>.vs.<b>. under the zone, and the same under grade.letme.dev)
- Licence: CC BY 4.0, credit Anchor Terminal and link this page (https://www.anchorterminal.com/terms/#data)
- Updated: 2026-11-15

Two or three companies' docs show a full fit.

| Companies, full fit | With a limit | Carry the tag | Share of the category's work | First-hand accounts |
| --- | --- | --- | --- | --- |
| 2 | 4 | 19 | 19 | 13 |

## What counts as done

Each bank line in the period is either matched to an invoice, bill or payment or coded to an account, a payment recorded against an invoice changes its status to paid, and the ledger bank balance equals the statement balance at period end, all through the API.

Measured, for our own tests: 100 transactions in under 30 calls.

How agents ask for it: categorise last month's transactions; reconcile the bank account; mark this invoice as paid; why does the bank balance not match the books

## Does the job

The docs show it meets the test above, and nothing we read says otherwise.

- **Pennylane (Pennylane SAS)**: Match and unmatch a transaction to a customer or supplier invoice, categorise a bank transaction, create transactions, mark invoices paid, and read the trial balance for the period, all by documented endpoints. The 100-line call bar is the suite's to measure.
- **Zoho Books (Zoho Corporation Private Limited)**: Bank transactions have Get matching transactions, Match, Unmatch, and Categorise as expense, customer payment, vendor payment, refunds or a new transaction, so each feed line is matched or coded and a customer payment marks the invoice paid. The 30-call bar is the suite's.

## Does the job, with a limit

It does the job, but something in the docs or a user's account will get in an agent's way. The limit is named in each row.

- **FreeAgent API (FreeAgent Central Limited)**: Statements upload as a transaction array or file, and bank_transaction_explanations take paid_invoice, paid_bill, category or a transfer, which marks the invoice paid. One explanation per call, so 100 lines need about 100 calls, past the 30-call bar.
- **Invoice Ninja API (Invoice Ninja LLC)**: bank_transactions/match links a line to invoice ids, a payment, an existing expense or a new vendor expense, in bulk, and rules auto-match. Bank sync is an Enterprise or self-host feature, and there is no ledger bank balance to check against a statement.
- **Odoo External API (Odoo SA)**: Bank statement lines and reconciliation are model methods, so reachable in principle, but no documented matching call exists, and acc-54 shows a bank statement created through JSON-2 losing its journal reference (open issue).
- **Puzzle API and MCP (Puzzle Financial Inc.)**: Transactions create up to 500 per request and update (categorise) under write:transaction, and categorisation metrics exist, but no endpoint matches a bank line to an invoice or bill; the MCP's reconciliation claim has no published tool behind it.

- not this job: Apideck Accounting API + MCP (Apideck Inc. and Apideck NV/BV): bank-feed-statements pushes a platform's own transactions into a ledger for the customer to reconcile there; there is no endpoint to match or categorise existing bank lines. Payments allocated to invoices do mark them paid.
- not this job: Codat (Codat Limited): bankTransactions can be created (pushed into a ledger) but not updated, matched or categorised; payments create against invoices. No route codes or matches existing feed lines.
- not this job: FreshBooks API (2NDSITE Inc.): Payments record against invoices and mark them paid, but the API has no bank transaction, feed or reconciliation endpoint; bank reconciliation stays in the web app.
- not this job: Merge Accounting API (Merge API, Inc.): bank-feed-transactions POST pushes lines into a platform's feed and payments can be applied to invoices, but nothing categorises or matches existing feed lines; transactions are read-only.
- not this job: QuickBooks Online API + MCP (Intuit Inc.): Intuit's maintainer closed the categorisation request (acc-42, issue 121) saying bank feed transactions are not exposed by the Accounting API. Payments against invoices work, but feed lines cannot be matched or coded.
- not this job: rotki MCP server (Rotki Solutions GmbH): No bank lines or matching; writes and DDL are rejected by query_sql.
- not this job: Rutter Accounting API (Rutter): bank_feeds/transactions pushes lines into a platform's feed and bank deposits can be created, but there is no endpoint to match or categorise existing feed lines.
- not this job: Xero API + MCP (Xero Limited): The Accounting API has BankTransactions (spend and receive money, with IsReconciled) and Payments that mark invoices paid, but no bank statement line or match endpoint, so feed lines cannot be matched or coded; MCP update-bank-transaction also fails every call (acc-27, open).

## What stops agents finishing

- no API route to categorise or match bank-feed lines, so the agent drives the web UI
- reconciled transactions cannot be edited through the API
- payment taken through a redirect method is never recorded against the invoice

## Around it

Before: banking-data.find-transactions, mailbox-access.find-and-read. After: accounting.read-reports, accounting.close-period.

## Where this comes from

Weight 19 of 100 in Accounting & invoicing: 13 of 69 use-case citations across 60 accounts, scaled to 100

As data: https://www.anchorterminal.com/api/v1/use-cases/accounting.reconcile-bank.json, or the MCP tool get_use_case with id accounting.reconcile-bank. Draft, read 2026-11-15 from public docs and first-hand accounts, not yet reviewed by a person.

---

Query this catalogue directly over MCP: https://www.anchorterminal.com/mcp (Streamable HTTP, no key). How: https://www.anchorterminal.com/agents/#mcp
