Your Zoho Books balance says Rs 4,32,000. Your bank statement says Rs 4,18,500. The difference is Rs 13,500 - but you have no idea where it went. It could be bank charges you forgot to record, a UPI payment that was entered twice, an NEFT receipt that was not matched to the correct customer, or a cheque that has not yet cleared.
Bank reconciliation is how you find out. This guide walks Indian businesses through the complete bank reconciliation process in Zoho Books - from connecting your bank account and importing statements, through categorising UPI/NEFT/RTGS transactions, setting up bank rules for automation, matching transactions, resolving differences, and completing reconciliation with a locked period. For the broader Zoho Books setup, see our complete Zoho Books guide.
What Is Bank Reconciliation in Zoho Books?
Bank reconciliation in Zoho Books is the process of comparing transactions recorded in your Zoho Books account with the transactions on your actual bank statement - and resolving any differences. The goal is to reach a state where the difference between your bank's closing balance and Zoho Books' cleared amount is zero.
Zoho Books offers two methods for getting bank data into the system: automated bank feeds (where transactions are imported daily from your bank via secure aggregators) and manual import (where you upload bank statements in CSV, XLS, OFX, or QIF format). Both methods lead to the same reconciliation process. For professional setup and ongoing reconciliation support, explore our Zoho Books accounting services.
Key Terms You Should Know
- Bank Feed: Automated daily import of transactions from your bank account into Zoho Books via Yodlee or Plaid aggregators. Available from the Standard plan (Rs 899/month).
- Uncategorised Transaction: A bank feed entry that has not yet been matched to an existing Zoho Books transaction or categorised into an account. These must be categorised before reconciliation.
- Best Match: Zoho Books' intelligent suggestion - a transaction with the same date and amount that is most likely the corresponding entry.
- Possible Match: All transactions within 90 days before the statement date that could potentially match - broader than best match.
- Bank Rule: A custom rule you create to auto-categorise recurring bank transactions - e.g., 'If description contains HDFC CHARGES, categorise as Bank Charges expense.'
- Cleared Amount: Total of all matched/categorised transactions during the reconciliation period. Must equal the Closing Balance for reconciliation to complete.
- Closing Balance: The ending balance on your bank statement for the reconciliation period. You enter this manually when initiating reconciliation.
Who Needs This Guide?
- Any Indian business using Zoho Books that has a bank account connected or wants to connect one
- Businesses currently reconciling manually in spreadsheets and wanting to automate
- CAs and bookkeepers managing client bank reconciliation in Zoho Books
- Businesses with high UPI/NEFT transaction volumes that need efficient matching
- Businesses that have never reconciled their bank account in Zoho Books and have months of backlog
The minimum plan for automated bank feeds is Standard (Rs 899/month). The Free plan supports only manual statement import. Use our pricing calculator to determine the right plan.
How to Set Up Bank Feeds in Zoho Books for Indian Banks
Navigation: Banking (left sidebar) → Add Bank or Credit Card
- Select 'Connect your bank account automatically' (or 'Enter your account manually' for banks without feed support).
- Search for your bank - HDFC Bank, ICICI Bank, SBI, Axis Bank, Kotak Mahindra, Yes Bank, IndusInd Bank, and others are supported via Yodlee aggregator.
- Enter your net banking credentials. Zoho Books connects via a read-only secure link - it can import transactions but cannot initiate any payments.
- Select the bank account(s) to connect. For current accounts, savings accounts, and credit cards.
- Transactions start importing within a few hours. Daily auto-import continues from this point.
Note: If your bank is not supported for auto-feeds (some cooperative banks, rural banks, or small finance banks), use manual import. Download your statement from net banking in CSV or XLS format, then go to Banking → Select Account → Import Statement → Upload file → Map columns.
8-Step Bank Reconciliation Process in Zoho Books
Step 1: Ensure All Transactions Are Recorded
Before starting reconciliation, verify that all invoices, bills, payments received, payments made, and expenses for the period are recorded in Zoho Books. Missing entries mean missing matches during reconciliation.
Step 2: Categorise Uncategorised Bank Feed Transactions
Navigation: Banking → Select Account → Uncategorised tab
For each uncategorised transaction, Zoho Books shows the bank description, amount, and date. You have three options:
- Match: Link to an existing Zoho Books transaction (best match or possible match). Use for payments/receipts already recorded.
- Categorise: Assign to an expense/income account if no matching transaction exists (e.g., bank charges, interest income). Creates a new transaction.
- Exclude: Skip transactions that should not be in your books (e.g., internal transfers between your own accounts that are already recorded).
Step 3: Set Up Bank Rules for Recurring Transactions
Navigation: Banking → Select Account → Gear icon → Bank Rules → + New Rule
Bank rules auto-categorise transactions that match specific criteria. Examples for Indian businesses:
| Rule Name | Condition | Action |
|---|---|---|
| HDFC Bank Charges | If description contains 'CHRG' or 'SERVICE CHARGE' | Categorise as 'Bank Charges' (expense) |
| Razorpay Settlements | If description contains 'RAZORPAY' | Categorise as 'Sales - Online' (income) |
| GST Payment | If description contains 'GSTN' or 'GST PMT' | Categorise as 'GST Payable' (liability) |
| Rent Payment | If amount = Rs XX,XXX and description contains 'RENT' | Categorise as 'Office Rent' (expense) |
| TDS Deducted | If description contains 'TDS' or 'TAX DEDUCTED' | Categorise as 'TDS Receivable' (asset) |
Bank rules save hours every month for businesses with repetitive transactions - once configured, they auto-categorise matching entries without manual intervention.
Step 4: Initiate Reconciliation
Navigation: Banking → Select Account → Gear icon → Reconcile Account → Initiate Reconciliation
- Enter the Start Date of the reconciliation period (typically 1st of the month)
- Enter the End Date (last day of the month)
- Enter the Closing Balance from your bank statement - this must match exactly what the bank shows
- Click Start Reconciliation
Step 5: Match Transactions
Zoho Books displays all categorised and matched transactions for the period. Select each transaction that appears on both your bank statement and Zoho Books records. The system shows:
- Best Matches - same date and amount (highest confidence)
- Possible Matches - within 90 days, similar amount (lower confidence)
- Unmatched - present in Zoho Books but not on the bank statement (may appear next period)
Step 6: Handle Unmatched Items
For items on the bank statement but not in Zoho Books: add them via '+Add Transaction' during reconciliation. Common examples include bank charges, interest credited, bounced cheque penalties, and direct debits. For items in Zoho Books but not on the bank statement: leave them unreconciled - they will appear in the next period (deposits in transit, uncleared cheques).
Step 7: Verify Difference = Zero
The reconciliation is complete when the Closing Balance (from your bank statement) minus the Cleared Amount (from matched transactions) equals zero. If the difference is not zero, investigate: check for duplicate entries, missing transactions, wrong amounts, or transactions assigned to the wrong bank account.
Step 8: Complete and Lock the Period
Click 'Reconcile' to lock the period. Once reconciled, Zoho Books prevents edits to transactions in that period - preserving the audit trail. A reconciliation report is auto-generated. You can attach supporting documents (bank statements, cheque copies) for audit readiness. For ongoing reconciliation as part of monthly bookkeeping, our Zoho Books accounting services include this as a standard deliverable.
India-Specific Bank Reconciliation Considerations
UPI Transactions: UPI payments appear with descriptions like 'UPI/CR/XXXX/PAYEE NAME' or 'UPI-CUSTOMER@BANK'. Create bank rules to auto-categorise common UPI patterns. For businesses receiving 100+ UPI payments daily (e.g., retail, food delivery), bank rules are essential - manual categorisation is not scalable.
NEFT/RTGS Receipts: NEFT and RTGS credits appear with the remitter's name and UTR number. Match these with 'Payments Received' entries in Zoho Books. The UTR number can be entered in the reference field for cross-verification.
GST on Bank Charges: Indian banks charge 18% GST on service charges, locker fees, and other banking services. When categorising bank charges, split the amount into the net charge (expense) and GST component (CGST + SGST or IGST input credit) if you want to claim ITC on banking services. This requires creating a split entry during categorisation.
Cheque Clearing Delays: Cheques deposited may take 2-3 business days to clear via CTS (Cheque Truncation System). These appear as 'deposits in transit' during reconciliation - present in Zoho Books but not yet on the bank statement. Leave them unreconciled for the current period. For GST return filing tied to bank-reconciled data, ensure all periods are reconciled before GSTR-3B filing.
Multiple Bank Accounts: Indian businesses often maintain separate current accounts for CGST and SGST payments, salary disbursement, and operations. Each account must be reconciled independently. Inter-account transfers must be recorded carefully to avoid double-counting.
Common Bank Reconciliation Mistakes in Zoho Books
Mistake 1: Not reconciling monthly. Businesses that reconcile quarterly or annually face hundreds of unmatched transactions. By then, identifying the source of a Rs 500 difference from 3 months ago is nearly impossible. Reconcile every month before the 5th - this also ensures your GST liability and ITC calculations are accurate before GSTR-3B filing.
Mistake 2: Entering the wrong closing balance. The closing balance you enter must match your bank statement exactly - to the paisa. Even a Re 1 difference means the reconciliation cannot complete. Always copy the closing balance directly from your bank statement PDF.
Mistake 3: Ignoring bank charges and interest income. Banks debit service charges, SMS fees, debit card fees, and credit interest income without your manual entry. These create permanent differences if not recorded. Use bank rules to auto-categorise them.
Mistake 4: Recording inter-account transfers as expenses. Moving money from your HDFC current account to your SBI savings account is not an expense - it is a transfer. Use Zoho Books' 'Transfer Funds' feature (Banking → Transfer Funds) to record inter-account movements without affecting your P&L.
Mistake 5: Editing transactions after reconciliation. Once a period is reconciled and locked, do not undo the reconciliation to edit old transactions. If you find an error, record a correcting entry in the current period instead. Undoing reconciliation cascades - you must undo all subsequent periods too.
Monthly Bank Reconciliation Workflow for Indian Businesses
- 1st-2nd of the month: Import or verify auto-feed bank data for the previous month. For manual import, download statement and upload.
- 2nd-3rd: Categorise all uncategorised transactions using bank rules and manual matching.
- 3rd-4th: Initiate reconciliation - enter start date, end date, and closing balance from bank statement.
- 4th-5th: Match transactions, handle unmatched items, add missing entries (bank charges, interest). Resolve difference to zero.
- 5th: Complete reconciliation and lock the period. Attach bank statement PDF to the reconciliation record.
- 5th-10th: Use the reconciled data for GSTR-1 preparation and push. Reconciled bank data ensures payment tracking is accurate.
- 15th-20th: GSTR-2B reconciliation and GSTR-3B filing - both depend on accurate bank-reconciled financials.
Note: For the complete GST filing workflow in Zoho Books, see our GST setup guide.
Key Takeaways
Bank reconciliation in Zoho Books follows an 8-step process - record all transactions, categorise bank feeds, set up bank rules, initiate reconciliation, match transactions, handle unmatched items, verify difference equals zero, and lock the period - with the goal of matching the bank statement closing balance exactly.
Automated bank feeds (Standard plan and above) save 5-10 hours per month for a typical Indian SMB by auto-importing daily transactions from HDFC, ICICI, SBI, Axis, and other major banks. The Free plan requires manual CSV/XLS import.
Bank rules are the single most powerful automation feature for Indian businesses with high UPI/NEFT volumes - they auto-categorise recurring transactions (bank charges, Razorpay settlements, GST payments, rent) without manual intervention.
India-specific considerations include UPI transaction categorisation, NEFT/RTGS UTR number matching, GST (18%) on bank service charges (with ITC claim potential), cheque clearing delays via CTS, and separate reconciliation for multiple current accounts.
Monthly reconciliation by the 5th is the recommended cadence - it provides clean, verified financial data before GSTR-1 filing (11th), GSTR-2B reconciliation (14th-15th), and GSTR-3B filing (20th), creating an integrated compliance workflow.
Need Help with Bank Reconciliation in Zoho Books?
Monthly bank reconciliation is the foundation of accurate financial reporting, GST compliance, and audit readiness. Setting up bank feeds, configuring bank rules for UPI/NEFT/bank charges, and establishing a monthly reconciliation workflow saves hours and eliminates errors.
Explore our Zoho Books implementation for CA-supervised bank account setup, reconciliation workflow configuration, and ongoing monthly bookkeeping.
For queries, reach out at +91 945 945 6700 or WhatsApp us directly.
