How to Import Bank Statements into Zoho Books via CSV

Zoho Books is a fantastic, fully-featured accounting platform, but like all accounting software, its bank feed connections can sometimes break. When they do, or when you are onboarding a new client with months of historical data locked in PDF bank statements, you must manually import a CSV.

This guide walks you through the steps to get your statements converted and properly imported into Zoho Books.

Step 1: Getting Your Data out of a PDF

Before you can import into Zoho Books, you need a structured spreadsheet (CSV or TSV). If you are looking at a PDF document, you cannot directly import it.

If the statement is a high-quality download, you might try highlighting the text and pasting it into Excel. However, if that results in broken columns, or if you are dealing with a scanned document, use a dedicated bank statement extraction tool like SmartBankStatement.

These specialized tools can take a 20-page bank statement and instantly spit out a perfectly structured CSV, keeping descriptions merged and balancing the math.

Step 2: Preparing the CSV Format for Zoho Books

Zoho Books is relatively flexible because it provides a visual “Mapping” screen. This means your CSV does not need to follow a rigid, undocumented column order like some older desktop software.

However, your CSV must adhere to basic data cleanliness rules:

• Date: Zoho allows you to tell it what format your date is in during the import screen (e.g., DD/MM/YYYY). Ensure your entire file uses the same date format.
• Amount: No currency symbols ($, £, ₹).
  • You can use a single Amount column (with negative numbers for money out, and positive for money in).
  • Or, you can use two separate columns: Deposits (Credits) and Withdrawals (Debits). Both formats work.
• Description/Payee: Try to keep the narrative in a single column so you have context when matching the transaction to a bill later.

Step 3: The Import Process in Zoho Books

Once your CSV is clean, you are ready to import.

1. Log into your Zoho Books dashboard.
2. Navigate to the Banking module on the left-hand sidebar.
3. Select the specific bank account or credit card you wish to import data into. (If you haven’t created the account yet, do so now).
4. Click the gear icon (⚙️) next to the bank account and select Import Statement.
5. Upload your prepared CSV file.
6. Configure the Import Rules:
   • Amount Columns: Tell Zoho if your file uses a single Amount column (with +/- signs) or Two Columns (Withdrawals & Deposits).
   • Date Format: Explicitly select the format that matches your CSV (e.g., MM-dd-yyyy).
   • Character Encoding: Choose UTF-8 (this is the standard and handles special characters best).
7. Map Fields: On the subsequent screen, match you CSV column headers to the required Zoho Fields (Date, Description, Amount).
8. Review and Import: Zoho will show you a preview of the first few rows. If everything looks correct, click Import.

Step 4: Reconcile

Immediately after importing, your transactions will sit in the “Uncategorized Transactions” tab. Your ultimate goal is to categorize these, match them against sales invoices or purchase bills, and ensure the closing balance in Zoho matches the closing balance on your physical paper bank statement.

If you skip reconciliation, you risk importing duplicate transactions during next month’s import without noticing.

Export Ready-to-Upload CSVs Automatically

Building the CSV manually in Excel is time-consuming, especially when dealing with dozens of pages.

SmartBankStatement allows you to upload any global bank statement format and directly export it in an import-ready format, automatically splitting credits and debits or handling the negative signs exactly how Zoho Books prefers.