Bank reconciliation is where accounting errors hide. Transactions in your books do not always match what the bank shows. Zoho Books accounting features automates reconciliation so you catch discrepancies weekly instead of during an audit.

Last updated: July 12, 2026

Quick answer: Zoho Books bank reconciliation compares your book ledger against the actual bank statement using automatic bank feeds (via Yodlee, for ICICI, HDFC, SBI, Axis, Kotak, and other major Indian banks) or manual CSV/OFX import. Transactions are matched by amount, date, and reference, with rules available to auto-match recurring items like vendor payments and Razorpay settlements. Reconciling weekly, not monthly, catches errors like unrecorded bank charges or TDS on interest before they compound.

Bank feed reconciliation in Zoho Books India

What It Does

Compares your Zoho Books bank ledger with the actual bank statement. Every transaction should have a match. Unmatched entries are errors, omissions, or timing differences that need resolution.

Connecting Your Bank

Two methods: Bank feeds (automatic via Yodlee for ICICI, HDFC, SBI, Axis, Kotak, Yes Bank, and others) or Statement import (upload CSV/OFX manually).

Zoho Books supports direct bank feed connections with most major Indian banks. Once connected, transactions import automatically every day, which removes the need to manually enter bank entries or upload statements. Setting up the feed takes about 5 minutes per account.

To connect a bank account, go to Banking in the left menu, click Add Bank or Credit Card, and search for your bank. Enter your net banking credentials when prompted. Zoho Books uses a read-only connection to pull transactions. It cannot initiate transfers or view account numbers beyond what is needed for matching.

If your bank is not on the direct feed list, you can import statements manually. Zoho Books accepts OFX, QFX, CSV, and TSV formats. Most Indian banks allow you to export a CSV statement from net banking covering any date range.

Matching bank transactions with book entries

The Reconciliation Process

Go to Banking > Reconcile. Zoho Books shows bank vs book balance side by side and auto-matches transactions by amount, date, and reference. For each entry: Match (confirm), Create (new entry), or Exclude (irrelevant).

Automatic Matching Rules

Set rules for recurring transactions: “NEFT-VENDOR-ABC” auto-matches to purchase orders for that vendor. “RAZORPAY SETTLEMENT” auto-creates a sales receipt. Rules reduce manual work by 70% to 80%.

Matching Transactions: UPI, NEFT, RTGS, and Cheques

Indian business accounts typically see a mix of UPI credits, NEFT/RTGS transfers, cheque clearances, and auto-debit entries. Zoho Books handles all of these in the reconciliation screen, but each type has a slightly different matching approach.

UPI transactions: UPI credits often come in with minimal description text (for example, just a VPA like buyer@upi). To match these reliably, use the amount and date as primary identifiers. Zoho Books will suggest a match from your open invoices if the amount is exact. Accept the match and add a note if you want to record the payer’s name.

NEFT and RTGS: These usually carry a reference number in the bank statement description (for example, NEFTINB12345678). You can search your Zoho Books invoices by amount and then link the payment to the correct invoice. If the remittance advice was emailed to you, the reference number in the email usually matches the UTR on the bank statement.

Cheques: Cheque clearances appear in the bank feed 1 to 3 business days after deposit. When a cheque clears, Zoho Books will show it as an unmatched credit. Match it to the advance or payment entry you created when you deposited the cheque. If you did not create an entry at deposit time, create the payment record now and then match it to the bank feed line.

Auto-debits: Loan EMIs, insurance premiums, and SaaS subscriptions come in as auto-debits. Create recurring bills or journal entries for regular auto-debits so they match automatically each month.

Reading the Reconciliation Report

After matching transactions, go to Reports > Banking > Bank Reconciliation to view the summary. The report shows your closing bank balance, the balance per Zoho Books, and any uncleared items (cheques issued but not yet presented, deposits in transit). These differences are normal and resolve as transactions clear.

If your Zoho Books balance and bank balance do not match after accounting for uncleared items, look for duplicate entries, missed payments, or opening balance errors. The most common cause in Indian businesses is a bank charge or GST on bank charges that was not recorded in Zoho Books.

Common Issues for Indian Businesses

How Often to Reconcile

Weekly, not monthly. You remember why you made that Rs. 15,000 payment last Tuesday, but not next month. For high-volume businesses, daily reconciliation takes 10 to 15 minutes.

Frequently Asked Questions

Which Indian banks support automatic feeds?
ICICI, HDFC, SBI, Axis, Kotak, Yes Bank, and IndusInd through Yodlee. Use manual CSV/OFX import if your bank is not supported.
How often should I reconcile my bank account in Zoho Books?
Weekly is best practice, not monthly. It is easier to remember the purpose of a transaction from a few days ago than from a month ago. High-volume businesses often reconcile daily, which typically takes 10 to 15 minutes once bank feeds and matching rules are set up.
How far back does the bank feed import transactions?
When you first connect a bank account, Zoho Books typically imports the last 90 days of transactions. For older data, you need to download a statement from your bank’s net banking portal and import it manually in CSV or OFX format.
What happens if a transaction imports twice?
Duplicate imports can happen if you import a CSV statement that overlaps with the period already covered by the bank feed. Zoho Books flags potential duplicates. Review them before confirming and delete the duplicate entry. Going forward, avoid manual imports for periods already covered by the automatic feed.
Multi-currency reconciliation?
Create separate bank accounts per currency. Forex differences are posted to a gain/loss account automatically.
Balances still do not match?
Check for unrecorded bank charges, bounced cheques, payments in transit, or duplicate entries. Run a reconciliation report to find specific mismatches.
Can multiple users reconcile?
One user per bank account at a time. Different accounts can be reconciled simultaneously by different users.
Can I reconcile a GST payment made directly on the GST portal?
Yes. When you make a GST payment through the GST portal, the amount debits from your bank account. In Zoho Books, record this as a payment to the GST liability account (or use the GST Payment feature under Tax Payments). When the debit appears in your bank feed, match it to this entry to keep the reconciliation clean.