Blog
NetSuite for SaaS Companies: Subscription Revenue, Metrics and Compliance
On this page At $1 million ARR, a SaaS company can run its finances on…
14 min read
Read article →
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.
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.
Two methods: Bank feeds (automatic via Yodlee for ICICI, HDFC, SBI, Axis, Kotak, and others) or Statement import (upload CSV/OFX manually).
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).
Set rules for recurring transactions: “NEFT-VENDOR-ABC” auto-matches to Zoho Books purchase order managements to that vendor. “RAZORPAY SETTLEMENT” auto-creates a sales receipt. Rules reduce manual work by 70% to 80%.
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.
Zoho Books supports direct bank feed connections with most major Indian banks, including HDFC, ICICI, Axis, SBI, Kotak, and Yes Bank. 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.
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.
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.
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.
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.
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.
On this page At $1 million ARR, a SaaS company can run its finances on…
On this page Choosing the right partner for your Zoho deployment is one of the…
A practical guide to Zoho CRM automation: how workflows, blueprints, macros, and scoring rules work…
Our team builds systems that actually work. No fluff, just honest architecture and clean implementation.