Import notes
- Outputs include Double Column, Amount and Type, and Signed Amount.
- Import one account and currency at a time.
- Keep the audit CSV for comparison.
Format Bank Transactions for Zoho Books CSV Import
Format bank transactions for Zoho Books CSV import, with selectable date formats and three supported layouts. Review the result before download.
Choose the source statement
Accepted: CSV, TSV, TXT and text-based PDF bank statements. Scanned or image-only PDFs are not supported.
Conversion result
Source data accounting
Every detected source row is classified as a transaction or a balance/summary marker.
Export — all three Zoho Books layouts
CSV, TSV, TXT and text-based PDF are supported. Scanned PDFs and statement images are not supported.
Verify dates, signs, row count and totals against the original statement before importing into Zoho Books.
Before you import
Choose the layout shown in Zoho Books, then verify dates, signs, totals and row count.
Limitations
- Scanned or image-only PDFs are not supported.
- Payee stays blank unless it exists as a source field.
- Zoho Books remains the final import check.
Zoho Books formatter questions
Which Zoho Books CSV layouts are available?
The tool produces Double Column, Amount and Type, and Signed Amount layouts, plus an All Data / Audit CSV.
Can I choose the Zoho Books date format?
Yes. Choose the output date format that matches the Zoho Books import screen, then use the same setting when mapping the file.
Why is Payee left blank?
The source statement does not reliably separate a payee from its description. The formatter leaves Payee blank rather than inventing a value.
Is this an official Zoho integration?
No. This is an independent file-formatting tool. Zoho does not certify or endorse it, and import behavior can vary by edition or region.