Perimattic
Free Tool

Bank Statement to Zoho Books

Convert a text-based bank statement PDF, or the CSV or Excel download, into a CSV for Zoho Books’ statement import, with Date, Description, Reference Number, Withdrawals and Deposits columns. Dates are written as dd/mm/yyyy, and every row is checked against the running balance before you download.
Woman working on a laptop that shows a table of spreadsheet data

Your statement stays on your device. The PDF or spreadsheet is read by your browser and is never uploaded to ERPPlugs or anyone else. No account is needed, and nothing is stored after you close the page.

1

Choose your statement

A text-based PDF downloaded from net banking, or the CSV / Excel (.xlsx) download. Password-protected PDFs are fine: you will be asked for the password, and it never leaves your browser.

How It Works with Zoho Books

Zoho Books imports bank statements from a file and asks you to map its columns and date format during the import. The converter writes a CSV whose headers are named after Zoho Books’ own statement fields (Date, Description, Reference Number, Withdrawals, Deposits), with dd/mm/yyyy dates and plain numeric amounts, so the mapping step is quick. It helps most for accounts that do not have an automatic bank feed in Zoho Books.

Need this every day?

The converter handles one-off files. For data that syncs into Zoho Books without downloading statements, see the related ERPPlugs connector.

View the Zoho Books connector

Step 1: Convert the Statement

The Zoho Books download is CSV with these columns: Date, Description, Reference Number, Withdrawals, Deposits.

  1. 1

    Choose the statement

    Pick a text-based bank statement PDF (enter the password if it is protected) or the CSV or Excel download. The file is read in your browser and never uploaded.

  2. 2

    Check the rows

    The converter finds the table from its column headers, then checks every row against the running balance and the totals against the closing balance. Flagged rows can be edited or deleted in the preview.

  3. 3

    Download

    Download the Zoho Books (CSV) file. Downloads use the rows exactly as they appear in the preview, including your edits.

Step 2: Import Into Zoho Books

  1. Convert the statement above, check the flagged rows, then download the Zoho Books CSV.
  2. In Zoho Books, open Banking and select the bank account.
  3. Choose the option to import a statement and upload the CSV.
  4. Pick the dd/MM/yyyy date format, confirm the column mapping, then categorise or match the imported transactions.

Menu names can differ between Zoho Booksversions; check your version's help if an option is labelled differently.

Checks Before You Import

A converted statement is only useful if it agrees with the bank's own balances. The converter runs the first two checks for you; do the last two by eye before you import the CSV file.

  • Running balance, row by row

    For every row, the previous balance minus the withdrawal plus the deposit must equal the balance printed on the bank statement, within one paisa. A row that fails usually means a misread amount, a missed row or a junk line.

  • Opening to closing balance

    The opening balance plus total deposits minus total withdrawals should equal the closing balance. For example, an opening balance of ₹1,00,000 with ₹2,50,000 of deposits and ₹1,80,000 of withdrawals should close at ₹1,70,000.

  • Date range

    The first and last dates shown should match the statement period you downloaded, with no pages missing in between.

  • References intact

    Spot-check a few UPI, NEFT and cheque rows to confirm the full narration came through, because that text is what you match against ledger entries.

If a check fails, fix or delete the row in the converter's preview table before downloading rather than editing the file afterwards, so the export and the statement stay in step.

Bank Statement Pages

Notes on common statement layouts. The converter is not limited to these banks: any text-based statement with a recognisable header row can be tried.

FAQ

Frequently Asked Questions

CSV with the columns Date, Description, Reference Number, Withdrawals, Deposits. Dates are written as dd/mm/yyyy (real Excel dates in .xlsx files), and amounts are plain numbers without thousands separators.

It has no per-bank templates. It reads text-based statements whose table has a recognisable header row, using common Indian bank column names such as Narration, Particulars, Withdrawal Amt., Deposit Amt., Debit, Credit and Closing Balance. Bank pages for HDFC Bank, SBI, ICICI Bank, Axis Bank and others are linked on this page; statements from other banks can be tried the same way.

Each row is checked against the running balance (previous balance minus withdrawal plus deposit must equal the printed balance), and the opening balance plus deposits minus withdrawals is compared with the closing balance. Failed rows are flagged in the preview, where you can edit or delete them before downloading.

No. The browser tool reads the text layer of a PDF and does not do OCR. If a PDF has no text layer, as with a scanned or photographed statement, the tool says so. Download the statement again from internet banking as a PDF, CSV or Excel file instead.

No. The converter runs entirely in your browser. The PDF or spreadsheet is read on your device, nothing is uploaded to ERPPlugs or anyone else, and nothing is kept after you close the page. A PDF password is used only to open the file in that browser tab.

Yes. The converter is for one-off files. For bank data that reaches Zoho Books without downloading and converting statements, ERPPlugs offers connectors; see the connector link on this page.

ERPPlugs

Bank statements, ready for Zoho Books

Convert a statement now: free, no account, and your statement never leaves your browser. Want bank entries posted to your ERP automatically? Talk to us.
  • Free consultation
  • No commitment
  • Tailored to your team