Zoho Books Bank Statement Import Error

How to fix it

// try these in order, the most common fix is first

1. FIX 1Use a supported format

   Copy steps
   1. 01Export as CSV, TSV, OFX, QIF or CAMT.053 from your bank
   2. 02Try OFX or QIF if CSV keeps failing
   Did this fix it? Yes No

2. FIX 2Match the date format

   Copy steps
   1. 01Check how dates appear in the file
   2. 02Select the same date format in the import screen (Zoho's FAQ suggests DD-MM-YYYY)
   3. 03Remove text rows above the header
   Did this fix it? Yes No

3. FIX 3Fix encoding and mapping

   Copy steps
   1. 01Choose the correct character encoding (UTF-8 usually)
   2. 02Map date, description and amount (or withdrawal and deposit) columns
   3. 03Remove empty columns and totals rows
   Did this fix it? Yes No

4. FIX 4Send a sample to support

   1. 01If it still fails, email Zoho Books support with a sample file and the error
   Did this fix it? Yes No

Symptoms

'None of the rows can be imported', 'Invalid value passed for csv_column', or dates imported wrong.

Why it happens

• C-01Unsupported file type
• C-02Date format in the file differs from the one chosen at import
• C-03Wrong character encoding
• C-04Required fields missing or not mapped
• C-05Bank changed its export layout

// this guide also covers

• zoho books import bank statement error
• none of the rows can be imported zoho books
• zoho books csv import date

The same problem in other apps

All not loading, error messages & connection guides →

• QuickBooks Bank Error 102 and 105 (QuickBooks)
• Xero File Upload Not Working (Xero)
• FreshBooks Bank Connection Not Working (FreshBooks)
• Wave Bank Connection Not Working (Wave)

Other Zoho Books errors

• Zoho Books Bank Feeds Not Updating
• Zoho Books Balance Doesn't Match Bank
• Zoho Books Invoice Emails Going to Spam
• Zoho Books Online Payment Error (CP Codes)
• Zoho Books CRM Sync Not Working
• Zoho Books Sales Tax Not Calculating
• Zoho Books Free Plan Limits ($50K Revenue)
• How to Cancel Zoho Books Subscription