Zoho Books extension

RefinePoint for Zoho Books

Reconcile what is in Zoho Books with the statement in your hand, without leaving Books: customer payments with the bank statement, bills with GSTR-2B or a vendor's statement, invoices with a payment gateway's settlement report. In minutes you see which records match, which partly match and which are missing on one side.

What it does

  • Reads invoices, bills, customer payments, vendor payments, credit notes, expenses or a bank account's transactions from Zoho Books, for the dates you choose.
  • Reconciles them with a CSV or Excel file (bank statement, GSTR-2B, vendor statement, payment gateway report) or with another Books module.
  • Pairs the columns for you (reference with UTR, amount with deposit, date with value date), or from a sentence you write, and lets you allow a difference in amounts and days.
  • Shows matched, partly matched (with the fields that differ), one-sided and duplicate records, exportable to CSV, and opens the full reconciliation in RefinePoint.
  • Never changes anything in Zoho Books: every permission it asks for is read-only.

Install

  1. Your Zoho Books organization needs a plan with widgets (Premium or above), and an admin installs extensions.
  2. In Zoho Marketplace, open RefinePoint Reconciliation and click Install, or in Zoho Books go to Settings, Marketplace.
  3. Choose the organization, accept the terms, and authorize the ZohoBooks-RefinePoint connection. It asks for read access to invoices, bills, payments, credit notes, expenses and banking. Each user authorizes it for themselves, so everyone sees only what their Zoho Books role allows.
  4. A RefinePoint tab appears in Zoho Books. The first time you open it, click Sign in with Zoho: RefinePoint checks with Zoho that you are a user of the organization and sets up your free RefinePoint workspace from your Zoho email.

Use

  1. Choose what to reconcile. Pick a common reconciliation (for example Customer payments ↔ bank statement), or set each side yourself: a Zoho Books module and a date range, or a file. Click Read for a Books side; a file is read as soon as you choose it.
  2. Pair the columns. Check the suggested pairs. The Key pairs records up, usually a reference, UTR, invoice or bill number. Amount pairs can allow a difference (± 1.00) and ignore the sign; date pairs can allow days apart. Or describe the match in a sentence and let AI pair the columns (only column names are sent, never values).
  3. Run. Results arrive in seconds for thousands of records: the match rate, each group, where partly matched records differ, and every record side by side. Export any group to CSV, or open the whole reconciliation in RefinePoint.

The free plan includes 5 reconciliations a day. Up to 50,000 records a side can be reconciled from Zoho Books; larger reconciliations, scheduled runs and review workflows are in the RefinePoint web app.

Files it reads

CSV, Excel (.xlsx, .xls, .xlsm) and OpenDocument (.ods) files up to 25 MB, read in your browser.

  • Header row: statements that start with the bank's name and the period are handled: the header row is found for you, and you can change it.
  • Dates: 31/03/2026, 31-03-26, 31-Mar-2026, 2026-03-31 and Mar 31, 2026 all read as the same date. Day-first or month-first is detected from the dates, or set by you.
  • Amounts: 1,23,456.00, ₹ and Rs. signs, (1,200.00) and 1,200.00 Dr as negatives are all read as numbers.
  • GSTR-2B: download the Excel from the GST portal, choose the B2B sheet and its header row, and pair Invoice number with Bill number.

Your data

  • Read-only in Zoho Books. The connection's scopes are all READ. RefinePoint never creates, changes or deletes anything in Books.
  • Read in your browser, sent once. Books records are read by the extension in your browser through Zoho's connection; your file is read in your browser. When you click Run, the two sides' records are sent over HTTPS to RefinePoint's API (api.refinepoint.com) to be reconciled.
  • Kept for 24 hours. The records and results of a reconciliation are deleted 24 hours after it runs. You can open them in RefinePoint until then.
  • No Zoho tokens kept. Signing in reads your Zoho user id and email and the organizations you belong to, once, and the Zoho token is then revoked. RefinePoint keeps your email, your Zoho user and organization ids, and a session token valid for 7 days.
  • Never used for anything else. Your data is not sold, not used for marketing and not used to train AI models. The AI column pairing sees column names only.

RefinePoint's servers are in the USA (Oracle Cloud), and data is encrypted in transit. The full details, including where data is processed, are in our privacy policy and terms of service. To remove the extension, uninstall it in Zoho Books (Settings, Marketplace, Installed Extensions); to delete your RefinePoint account and everything in it, write to support.

Questions

Zoho Books already reconciles bank accounts. Why this?
Books matches one bank feed with its own transactions. RefinePoint reconciles any two sets of records: payments with a statement you downloaded, bills with GSTR-2B or a vendor's ledger, invoices with a gateway's settlement, with tolerances, typo-tolerant keys and a report of every difference.
The sign-in window did not open.
Your browser blocked the popup. The extension then shows a link to open the Zoho sign-in in a new tab; it continues once you have signed in.
It says Zoho Books asked to slow down.
Zoho Books allows 100 API calls a minute per organization. Reading a large module may pause for a minute and then carry on by itself.
Does it work in every Zoho data centre?
Yes: India, US, EU, Australia, Japan, Canada, Saudi Arabia and UK organizations are read through their own data centre.

Support

Write to support@refinepoint.com or use the support page. Include your Zoho Books organization id (Settings, Organization Profile) and, for a failed reconciliation, the time it ran.