Home › Guides › Zoho Books bank statement CSV format

Zoho Books bank statement CSV format

Zoho Books imports a bank statement as CSV (or TSV, XLS, OFX, QIF or CAMT), not as a PDF or, in the documented list, a QuickBooks .qbo file. Choose an Amount Column Type: one signed Amount column (deposits positive, withdrawals negative), a type-plus-amount layout, or separate deposit and withdrawal columns. The US error article tells you to enter dates as DD-MM-YYYY. Download a sample file below, or convert a PDF to a three-column signed CSV in your browser and map it in Zoho Books.

Updated November 10, 2026

Download a sample Zoho Books CSV

The first file is the layout that matches Single Column with Negative Values: deposits positive, withdrawals negative. Dates are DD-MM-YYYY, the format stated in Zoho Books’ US error-help article. The rows are fictional.

Download the signed-amount sample (Date, Description, Amount) Download the double-column sample (Deposit, Withdrawal)

Date,Description,Amount
15-10-2026,Office supplies,-84.60
16-10-2026,Customer receipt,1200.00

If you use the double-column file, choose Double Column in Zoho Books and enter only positive amounts in the Deposit or Withdrawal column (leave the other cell blank). Do not put minus signs in a Double Column file.

Import steps

From Zoho Books’ US article “How to import a bank statement” (fetched November 10, 2026):

  1. Go to Banking, open the bank account, and click Import Statement.
  2. Upload a CSV, TSV, XLS, OFX, QIF, CAMT.053 or CAMT.054 file. Select the Amount Column Type that matches the file, plus character encoding and file delimiter, then continue.
  3. Map the imported headers to Zoho Books fields (Date, Description, and the amount field or fields for the type you chose).
  4. Preview the rows and click Import. The lines arrive as uncategorized transactions; you then match or categorise them.

If the bank offers a feed (Yodlee, Token or Plaid, depending on your Zoho Books edition), that is a separate path from a manual file import. Menu labels can change; follow the current official article if your screen differs.

Common import errors

The US error article lists: an unsupported file format; an incorrect date format (it tells you to use DD-MM-YYYY); the wrong character encoding; the wrong amount-column type; and negative values in the amount column when you selected Double Column or Single Column and Amount Type. Fix the file or the Amount Column Type, then try again.

Convert your PDF statement to a Zoho-ready CSV

Zoho Books’ documented import list does not include PDF or .qbo. If you only have a statement PDF, convert it in your browser, confirm the result is Reconciled, and download QuickBooks CSV — a three-column Date, Description, Amount file. In Zoho Books, choose Single Column with Negative Values and map those three columns. If you need DD-MM-YYYY dates, pick a date format in the converter that you can consistently convert, or adjust dates in a working copy before import. Do not upload CSVLedger’s general CSV until you remove the extra Balance and Check columns.

CSVLedger does not convert an existing CSV into .qbo, and it does not create a Zoho-specific file type.

Convert your PDF statement to a 3-column CSV

Create a free account See plans

Conversion runs in your browser; the statement is not uploaded to CSVLedger. Free: 10 pages per day per browser. A balance check helps spot extraction issues; it does not replace your review or Zoho Books categorisation. We have not completed a live Zoho Books import test of these sample files.

Related guides

Sources and scope

Based on Zoho Books’ US help articles fetched November 10, 2026. Those pages did not show a last-updated date in the retrieved text. Menu names, date pickers and accepted formats can differ by edition; follow the current official article if your screen differs. Examples are fictional. These instructions are documentation-based, not a claim of a completed live import into Zoho Books. CSVLedger is not affiliated with Zoho Corporation.

Frequently asked questions

What amount layouts does Zoho Books accept?

The official US article “How to import a bank statement” (fetched November 10, 2026) offers three Amount Column Type choices: Double Column (separate deposits and withdrawals); Single Column and Amount Type (a debit/credit type column plus an amount); and Single Column with Negative Values (one amount column, deposits positive and withdrawals negative). Choose the type that matches your file, then map the headers.

Which date format should I use?

Zoho Books’ US article “Error while importing bank statement” (fetched November 10, 2026) says: “Enter the date in the DD-MM-YYYY format.” The sample file uses that layout (15-10-2026). If the on-screen importer offers a date-format choice, select the one that matches the file. This page has not re-tested every Zoho Books edition’s date picker.

Can I import a QuickBooks .qbo file into Zoho Books?

The US import article lists CSV, TSV, XLS, OFX, QIF, CAMT.053 and CAMT.054. It does not list .qbo. Do not assume a QuickBooks Web Connect file will import. Prefer a bank OFX or QIF file, or a CSV in one of the layouts above.

What if I choose Double Column but my amounts are negative?

The same error article says: if you select Double Column, or Single Column and Amount Type, enter a positive value in the amount column. Use Single Column with Negative Values when the file itself uses minus signs for withdrawals.

Does CSVLedger convert CSV to .qbo or to a Zoho file?

No. CSVLedger converts PDF statements to Excel, a general CSV, a three-column QuickBooks CSV, a Xero CSV, or a .qbo file. It does not produce a Zoho-specific format and it does not convert an existing CSV into .qbo. For Zoho Books, use the three-column signed CSV (Single Column with Negative Values) and map Date, Description and Amount.