TL;DR - Quick Summary
- Who it is for: Zoho Books users importing statements when a direct bank feed is not available or for historical months.
- CSV format: Zoho Books takes Date, Description or Payee, separate Withdrawals and Deposits columns, and an optional Balance.
- Import path: Go to Banking, select the account, choose Import Statement, then accept suggested matches before categorizing the rest.
- Watch out for: Set the day-first or month-first date option to match the file, and check a row dated after the 12th before confirming.
- Start: Convert your statement at /pdf-to-csv.
Zoho Books Bank Import
Zoho Books integrates with the Zoho ecosystem. Import bank statements via CSV when direct bank feeds aren't available or for historical data.
Zoho Integration
Works with Zoho's ecosystem
Global Support
Multi-currency capabilities
Fast Reconciliation
Quick bank matching
Zoho Books CSV Format
Zoho Books requires:
- Date: DD/MM/YYYY or MM/DD/YYYY
- Description/Payee: Transaction details
- Withdrawals: Money out (expenses)
- Deposits: Money in (income)
- Balance (optional): Running balance
Import Process
Convert Your Statement
Convert for Zoho BooksUpload to Zoho Books
In Zoho Books: Banking → Import Statement → Upload CSV
What do I do with the transactions once they are imported into Zoho Books?
Imported lines start out as uncategorized in the bank account. For each one, Zoho Books will suggest a match if it finds an existing invoice payment, bill payment, or expense with the same amount and a nearby date. Accept the match where it is right, and categorize the rest to an account or a contact. Matching first matters, because categorizing a customer payment as fresh income would count that sale twice.
Can Zoho Books categorize imported statement lines automatically?
Yes, through bank rules set up on each bank account. A rule looks at fields such as the description or amount and assigns the account, contact, and tax treatment you choose. Rules apply to statement imports as well as bank feeds, so recurring items like rent, software subscriptions, and payroll transfers can be handled before you open the list. Write rules on stable text in the description, not on reference numbers that change every month.
Why are some dates wrong after the import?
Zoho Books has to be told whether the file uses day-first or month-first dates, and if that choice does not match the file, 04/05 can land as 5 April instead of 4 May. Dates after the 12th usually fail outright, which is the quickest way to spot the problem. Check the date format setting on the import screen against a row dated the 13th or later before confirming.