Convert a bank statement to Zoho Books
Zoho Books imports bank statements from CSV, OFX, QIF, and CAMT files. Convert your statement PDF to a categorized CSV first, then import it under the bank or credit-card account you're reconciling.
Fictional sample output
Preview the CSV before importing into Zoho Books
Statently turns separate withdrawals and deposits into one signed Amount column, cleans descriptions, and adds a category. This preview uses a fictional statement.
| Date | Description | Amount | Category |
|---|---|---|---|
| 2026-06-03 | Northwind Payroll | +3,450.00 | Income |
| 2026-06-04 | Harbor Market | -84.21 | Groceries |
| 2026-06-06 | City Utilities | -126.40 | Utilities |
| 2026-06-08 | Cloudwork | -18.00 | Software |
Private by design. Your uploaded PDF is processed in memory to create the CSV and is not stored.
Always review before importing. Compare totals and a sample of transactions with the original statement before reconciliation, tax filing, or accounting import.
How to import a statement into Zoho Books
- 1. Convert the statement. Upload the statement PDF and download the CSV.
- 2. Open the account. In Zoho Books: Banking → select the account → Import Statement.
- 3. Map & import. Map Date, Amount, and Description to the CSV columns, then import.
Frequently asked questions
- Does Zoho Books read PDF statements?
- No — Zoho Books imports CSV, OFX, QIF, and CAMT. Convert the PDF to CSV first, then import it.
Export to other tools
Convert a statement from your bank
Related guides
- How to Convert a Bank Statement PDF to CSV
The fastest way to turn a bank statement PDF into a clean CSV — what a CSV needs to contain, why manual methods break, and how to do it in seconds.
- How to Convert a Scanned Bank Statement to CSV
Scanned or photographed bank statements have no selectable text, so most converters choke on them. Here's how to turn an image-only PDF into a clean CSV.
- How to Import Bank Statements into QuickBooks
How to get transactions from a PDF bank statement into QuickBooks Online using a CSV — the format QuickBooks expects, and how to prepare it in seconds.
- How to Import Bank Statements into Xero
How to get transactions from a PDF bank statement into Xero using a CSV — the exact column format Xero expects and how to prepare it in seconds.