Zoho Bank Reconciliation Guide

That last point is the one people skip. Reconciliation in Zoho Books compares what's in your ledger to a closing balance you type in. It can't tell you a transaction never made it into the ledger in the first place. So if the import was short a line, Zoho's difference will refuse to hit zero and you'll spend the evening hunting a gap that a check at conversion time would have caught in seconds.

What reconciliation in Zoho Books actually checks

Reconciliation is the act of proving your Zoho Books record of an account agrees with the bank's record of the same account over a fixed window. You give Zoho two anchors — the closing balance from the statement and the date range — and Zoho works out the difference between that figure and the sum of the transactions you've marked as cleared. Get that difference to zero and the two records agree.

What it does *not* do is verify that every transaction the bank recorded is present in Zoho. It only reconciles the lines that are already there. A missing transaction shows up as a stubborn non-zero difference, but Zoho can't tell you *which* line is absent — only that the totals don't line up. That distinction is the whole reason the convert-and-check step earns its place.

How to reconcile a bank account in Zoho Books

Here's the sequence, assuming the period's transactions are already in the account (imported or feed-fetched):

1. Go to Banking in the left sidebar and select the account you want to reconcile.
2. Click Reconcile (in the account's actions). Zoho opens the reconciliation screen.
3. Enter the statement start date and end date for the period you're closing — usually a calendar month matching the statement.
4. Type the closing balance exactly as the bank printed it for that end date. This is the figure everything is measured against, so copy it carefully.
5. Zoho lists every uncleared transaction in the window. Tick each one that appears on your paper or PDF statement. As you tick, the cleared balance climbs and the difference falls.
6. Keep matching until the difference reads zero. At zero, the cleared transactions sum exactly to the closing balance, and the period is reconciled.
7. Save. Reconciled transactions lock to that statement, and the next period starts from this verified closing point.

Work top to bottom against the statement rather than jumping around — it's easier to spot the one line that has no partner that way. A transaction on your statement with nothing to tick in Zoho is a missing import; a ticked line with nothing on the statement is a duplicate or a misdated entry.

When the difference won't go to zero

This is where reconciliation in Zoho Books turns into detective work, and it's almost always one of a handful of causes.

Notice how many of these trace back to the file you imported, not to anything you did inside Zoho Books. A misread amount, a dropped line at a page break, a date in the wrong format — all of them are baked in before reconciliation begins. That's why catching them at conversion is so much cheaper than chasing a non-zero difference after the fact.

Reconcile a converted statement, cleanly

If you're bringing in older months or a backlog as PDFs, the order that holds up is: convert the PDF to a CSV, confirm it reconciles against its *own* running balance, import it, then run Zoho's reconciliation. The first reconcile — the conversion check — proves the file is complete. The second — Zoho's — proves your ledger agrees with the bank. Do the first and the second rarely fights you.

To bring the file in, go to Banking, pick the account, open Import Statement, and map your Date, Description and amount columns. Zoho Books offers Double Column (separate withdrawals and deposits), Single Column with a debit/credit flag, or Single Column with negative values — match the mode to how your CSV states money in and out. The Zoho CSV import format guide covers those modes column by column, and importing PDF statements into Zoho Books walks the upload step in full.

One honest caveat, because it shapes the whole workflow. Export Bank Statement converts and verifies files; it does not push transactions into Zoho Books over a certified bank-feed API. The path is convert, then import the CSV yourself. Live feeds only fetch recent activity anyway, so anything more than a few months old has to come in as a file regardless — which is exactly the work this guide is about.

Why the running-balance check changes reconciliation

Reconciliation in Zoho Books is only as trustworthy as the lines you feed it. Hand it a statement that's quietly missing one transfer and the difference will never reach zero — but Zoho won't name the culprit, so you're left re-reading a month of entries against a PDF.

Export Bank Statement closes that gap before the file ever reaches Zoho. It converts the PDF — including scanned and photographed statements, through OCR — into clean CSV or Excel, then runs its own running-balance check: opening balance plus money in, minus money out, has to equal the bank's printed closing figure. If a line was dropped or a digit misread, the statement is flagged as not reconciling, so you fix it at conversion rather than during a quarter-end scramble. We've seen a tidy-looking export fail this check over a single payment lost at a page break — a minute to find then, an afternoon to find later. It exports in Zoho Books' native bank-import format, so the Withdrawals and Deposits columns arrive in the shape the importer expects, and the file you reconcile is one you already know is whole.