India: import a bank statement into Zoho Books
Zoho Books India’s help on importing a statement: the file types, the single signed amount column, the steps, and the ExtractPro options that write that shape.
The article takes a statement through the Import Statement button and the Configure, Map Fields and Preview sections. The ExtractPro options below write a CSV for them.
Writing the file in ExtractPro
- 1In the Output format section, open See more formats or customise and pick Custom.
- 2Set File type to CSV.
- 3Set Date format to DD/MM/YYYY (15/01/2026).
- 4Under Amounts choose Single column (signed), so that withdrawals are negative and deposits positive.
- 5Under Include balance leave Add Balance column unticked, and leave Categories unticked too.
- 6For CSV separator pick Comma (,) and for Number format pick Decimal point, no separator (1234.56).
- 7Choose Apply format and download the CSV.
Import Statement
“Go to Banking on the left sidebar and select the bank account.” Then “Click Import Statement on the top right corner of a bank’s Details page”. Source: How to import a bank statement, www.zoho.com/in/books/kb/banking/how-to-import-a-bank-statement.html, accessed 14 October 2026.
Configure
“On the Configure section, click Choose File in the Upload File field and select the file you want to upload. You can upload the file in CSV, TSV, XLS, OFX, QIF, CAMT.053, and CAMT.054 file formats.” For the amounts, the layout for this file is “Single Column with Negative Values if your statement has just one column where positive values indicate deposits and negative values indicate withdrawals.” The text settings are “Select the Character Encoding and File Delimiter”. ExtractPro writes UTF-8 text with a comma between fields. Source: How to import a bank statement, www.zoho.com/in/books/kb/banking/how-to-import-a-bank-statement.html, accessed 14 October 2026.
Map Fields
“On the Map Fields section, match the Imported File Headers with the fields in Zoho Books”. The file has three columns, the date, the description and an amount that carries both signs. Source: How to import a bank statement, www.zoho.com/in/books/kb/banking/how-to-import-a-bank-statement.html, accessed 14 October 2026.
Preview
“On the Preview page, check the preview and click Import”. Afterwards, “The transactions in your bank statement will be added as uncategorised transactions.” Source: How to import a bank statement, www.zoho.com/in/books/kb/banking/how-to-import-a-bank-statement.html, accessed 14 October 2026.
Frequently asked questions
The questions that come up most:
Frequently asked questions
Which amount layout in Zoho Books fits the ExtractPro CSV?
Single Column with Negative Values, which the article gives for a statement with “just one column where positive values indicate deposits and negative values indicate withdrawals”. The Single column (signed) option writes one amount column with that sign.
Which file types can Zoho Books take at the Configure step?
The article lists “CSV, TSV, XLS, OFX, QIF, CAMT.053, and CAMT.054 file formats”. ExtractPro’s custom format has CSV among its file types.
How do the imported transactions show up in Zoho Books?
The article says “The transactions in your bank statement will be added as uncategorised transactions.” Read them against the statement before they are categorised.
Convert your first statement, free
Nothing to install, no card. Upload the PDF and download an Excel file with one transaction per row.
Try for free