Blog

Bank reconciliation in Zoho Books: what auto-match misses, and how to fix it

How Zoho Books matches bank lines today, the five places reconciliation still slows down (PDF statements, one payment for many bills, fees, vague references, bills not yet entered), and what to do about each.

2026-10-10 · Invoreg · 4 min read

Zoho Books does a good job on the easy lines. A direct debit for the exact amount of an open bill gets a "Match found" tag, and one click clears it. Month-end still drags because of the lines that don't get the tag.

This guide covers how matching works in Zoho Books today, the five places it slows down, and what you can do about each one. Feature details come from Zoho's help pages on 10 October 2026. Zoho updates the product often, so check the current page before you quote a client.

How Zoho Books matches bank lines

  1. Transactions come in through a bank feed or a statement import. Imports accept CSV, TSV, OFX, QIF, CAMT.053, CAMT.054 and MT940 files.
  2. Easy lines are flagged. An uncategorised line that meets Zoho's criteria gets a "Match found" tag.
  3. Everything else goes to Possible Matches. You open the line and filter candidates by amount range, date range, contact, transaction type and reference number.
  4. Rules categorise the repeats. Transaction rules route lines by payee, description, reference or amount, such as bank fees to an expense account.
  5. You reconcile the account against the statement once the lines are matched or categorised.

This works well for a business with a feed, few suppliers and payments that mirror single bills. It slows down as soon as one of those conditions breaks.

1. The statement is a PDF

Zoho Books imports PDF statements only from a named list of banks and card providers, mostly in the United States. Most European banks are not on that list, and many small business accounts have no feed into Zoho at all.

Fix inside Zoho: ask the bank for a CAMT.053 or MT940 export, which Zoho imports cleanly. Banks often label it as an XML or ISO 20022 statement.

When there is no export: someone types the lines in, which adds errors before matching has even started. This is the gap Invoreg was built to fill. It reads the PDF or scan line by line, so nothing is typed.

2. One payment settles several bills

A client pays three courier bills with one transfer of €1,742.80. Zoho Books lets you select several possible matches for one line and match once they add up to the bank amount. Finding which three of the twelve open bills add up to €1,742.80 is still your job.

Fix inside Zoho: filter Possible Matches by the contact first, then by a date range around the payment. It narrows the list, but you still have to try combinations.

3. Fees and small differences

A €1,000 payment arrives as €996.50 after a gateway fee, or a foreign transfer loses €12 to charges. Zoho handles this with "+ Create New Transaction" in the matching pane: you record the difference to an account and match the total.

Fix inside Zoho: create transaction rules for the fees that repeat every month, such as bank charges, card terminal fees and account maintenance. Rules cover those lines. One-off differences still need a decision from a person.

4. References that say nothing

Rules and filters rely on payee, description and reference. When the line reads "TRF 88213" with no supplier name or invoice number, a rule has nothing to work with. Zoho's help pages describe rules as categorising lines, not matching them to open bills, so a vague payment to a supplier still ends up in manual matching.

Fix inside Zoho: ask regular payers to quote the invoice number. It helps with your own customers, but you can't control what other people's banks print.

5. The bill isn't in Zoho yet

This is the most common cause, and the easiest to miss. You can't match a payment to a bill that hasn't been entered. If supplier invoices are two weeks behind, the bank lines for those suppliers sit unmatched until the data entry catches up. Reconciliation is only as current as the bills.

Fix: get bills in before the statement is reconciled, not after. That is a data entry problem, not a banking one.

What to set up this month

  • Feeds or structured exports for every account: feeds where available, CAMT.053 or MT940 where not.
  • Rules for the repeat lines: bank fees, subscriptions, rent, payroll transfers.
  • A weekly matching slot, so month-end isn't four weeks of lines at once.
  • Bills entered within days of arriving, so payments have something to match.

Where Invoreg fits

Invoreg covers the two jobs that sit around Zoho's matching screen: getting supplier invoices into Zoho Books, and reading the bank statement when there is no feed or export.

It reads each supplier invoice line by line and posts the bill to Zoho Books. It then reads the bank statement, including a PDF or a scan, and matches each payment to the bills it settles. That includes one transfer for three bills, with the combination already worked out. Anything it isn't sure about is flagged with the likely candidates, and nothing is reconciled until a person approves. A bank statement uses the same credits as an invoice.

For accounting firms running Zoho Books for many clients, this means one queue per client company instead of a stack of PDFs and a calculator. See the bank reconciliation page, or bring last month's statement to a demo and we'll run it live.

Questions accountants ask

Does Zoho Books match bank transactions automatically?

Partly. Zoho Books tags an uncategorised bank line with 'Match found' when it meets its matching criteria, and you confirm it with one click. For other lines you open the transaction and pick from 'Possible Matches', which you can filter by amount range, date range, contact, transaction type and reference number.

Can one bank payment be matched to several bills in Zoho Books?

Yes. In the matching pane you can select several possible matches for one bank line, and Zoho Books lets you match once the selected amounts add up to the bank amount. Finding which bills make up the total is still done by hand.

Can I import a PDF bank statement into Zoho Books?

Only from certain institutions. As of October 2026 Zoho's help page lists PDF import for a named set of banks and card providers, mostly in the United States. For other banks you import CSV, TSV, OFX, QIF, CAMT.053, CAMT.054 or MT940 files, or connect a bank feed.

Do Zoho Books bank rules match payments to open bills?

Zoho's help page describes transaction rules as a way to categorise bank lines by payee, description, reference and amount, for example routing a monthly bank fee to an expense account. It does not describe rules that match a payment to an open bill or invoice.