Zoho Books bank reconciliation won't reach zero? Work the difference down, with an AI agent

Short answer: A Zoho Books reconciliation that won't reach zero usually has one of a few causes: no opening balance for the account, a manually added payment that duplicates a cleared check, lines excluded by mistake, uncategorized feed lines, items that haven't cleared yet, or a line from last month picked by mistake. Work through them one at a time until the difference is zero. An AI agent can find them from the exports.

A reconciliation difference is rarely one big error. It is usually a handful of small ones, and some cancel each other out.

Here is the method from a recent Zoho Books tutorial, then an agent working a stuck October draft for a small HVAC contractor down to zero, with two follow-ups along the way.

The tutorial this is based on

How to Reconcile Bank Accounts in Zoho Books by Zenatta Consulting, published 20 July 2026 (in English). An 18-minute walk through a messy reconciliation that ends at zero.

How do you reconcile a bank account in Zoho Books?

  1. Make sure every bank line is either matched to a transaction already in Zoho Books or categorized, which creates one.
  2. Look out for manually added transactions and timing differences, such as a check written on the 28th and cashed next month.
  3. When matching or bulk-categorizing, check that each selected line belongs to this statement period. It is easy to pick last month's line when several charges have the same amount.
  4. Use the Excluded filter to restore lines excluded by mistake, such as interest earned or a bank fee, and categorize them.
  5. If the feed has gaps, import the bank statement file for the same dates.
  6. Open Reconcile, enter the statement dates and closing balance, tick the transactions that cleared, and work the difference down until it is zero.
  7. Attach the bank statement to the reconciliation as the audit trail, then reconcile.

Where it usually goes wrong

How an AI agent does it from Slack

We gave the agent three exports for a made-up HVAC contractor, Pelican Grove Mechanical: the October bank statement, Zoho Books' bank transactions with what was ticked in the saved draft, and the open invoices and bills. Every company, name, tax number and amount in these files is made up. The agent works in Slack, where it shows up as Mnemio AI, because Accountant AI is built on Mnemio AI.

The message in SlackReconcile Pelican Grove Mechanical's Zoho Books operating account for October 2026 against the bank statement. The saved draft won't get to zero: walk me through why and what to fix, but don't change anything in Zoho Books.
Slack request to reconcile a Zoho Books operating account for October 2026 with three export files attached, and the start of the agent's reply
The request with the three exports. The agent changed nothing in Zoho Books.

What the agent did

  1. Read the saved draft and worked out its $41,490.19 difference: the account had no opening balance, so it started at $0.00.
  2. Found the $37,418.62 opening balance from the bank statement, and told us to enter it as of 30 September, the day before Zoho Books went live.
  3. Separated the items that hadn't cleared (a $5,280.00 deposit and two checks) from the ones that had but were missing, and matched two uncategorized lines to an open invoice and an open bill.
  4. Found the duplicate check, the two excluded lines and the September RouteWise charge picked in place of an October one, which the difference alone doesn't show.
  5. Said at first to exclude the bank line for the duplicate check. Asked whether to match it to the vendor payment instead, it said match, so the bill stays paid.
  6. Gave the bank reconciliation statement ($30,152.70 at the bank, $31,048.95 in the books) and changed nothing in Zoho Books.
The agent's list of causes: missing opening balance of $37,418.62, a deposit in transit, two outstanding checks, a duplicate check, uncategorized and excluded lines, and a September RouteWise charge
Why the draft was $41,490.19 off, cause by cause.

What it found

What kept the draft from reaching zero
CauseAmount ($)Fix
No opening balance for the account37,418.62Enter it as of 09/30/2026
Deposit ticked but not yet cleared5,280.00Untick, carry to November
Two checks ticked but not yet cleared4,383.75Untick, carry to November
Check 2180 in twice: feed expense and vendor payment1,846.20Match the bank line to VP-2180
Customer deposit left uncategorized4,250.00Match to invoice INV-001187
Vendor autopay left uncategorized1,120.50Match to bill GCR-50817
Interest earned and bank fee excluded4.12 and 12.00Restore and categorize
September $49 charge ticked instead of an October one49.00Exclude September's, categorize October's
The agent's answer to a follow-up: match the cleared check to vendor payment VP-2180 rather than exclude it, a numbered list of seven fixes, and three items carried to November
Its first fix for the duplicate was to exclude the bank line. Asked whether to match it instead, it said match, so the bill stays paid, and gave the final list.
The agent's answer to a second follow-up: the Reconcile window will show an opening balance of $37,418.62, deposits of $66,247.77, withdrawals of $73,513.69 and a difference of $0.00
Its closing line mixed two figures. Asked what the Reconcile window will show, it set them out and confirmed a $0.00 difference.

What you still check

Questions accountants ask

Why is my Zoho Books reconciliation difference so large?

Often because the account has no opening balance, so the reconciliation starts at zero. Here that was $37,418.62 of a $41,490.19 difference.

Should I exclude or match a duplicate bank line?

Match it to the payment already recorded. Excluding the bank line leaves the payment unlinked to the bank, and deleting the payment instead would reopen the bill.

Can the agent reconcile inside Zoho Books?

Here it worked from exports and changed nothing. It can use a browser, where you sign in yourself, and it asks before it changes anything.

Hand this job to an agent

Bring one of your own files to a 30-minute call and watch an agent do it.

Book a 30-min demo