Convert bank statement PDF to Zoho Books CSV

Zoho Books imports bank transactions from a CSV, but a raw statement PDF has no columns Zoho can map. StmtSnap converts your bank statement PDF into a CSV laid out for the Zoho Books import wizard, so the Date, Description, Withdrawal and Deposit columns line up on the first pass.

The Zoho CSV comes out of the same upload as your Excel, Tally XML and QuickBooks files, on every plan including the free tier.

Columns in the Zoho Books CSV

• Date in a Zoho-importable format
• Description / payee from the statement narration
• Withdrawals (debits) in their own column
• Deposits (credits) in their own column
• Running balance where the statement provides one

How to import the CSV into Zoho Books

1. 1Upload your bank statement PDF to StmtSnap and download the generated Zoho CSV.
2. 2In Zoho Books go to Banking → the relevant bank account → Import Statement.
3. 3Upload the CSV and let Zoho auto-map Date, Description, Withdrawals and Deposits.
4. 4Review the field mapping once and save it as a template for next time.
5. 5Confirm the import; Zoho lists every transaction for categorisation and matching.

The first import is the only one you map by hand — save the mapping as a Zoho template and every future StmtSnap CSV for that bank imports without touching the wizard again.

StmtSnap keeps the full narration intact in the Description column, so Zoho's bank rules and the GST-ready vendor matching have the UPI handle and reference string to work with instead of a truncated label.

Frequently asked questions

Reference: Zoho Books — import bank statements