Gizmoop Document
PricingSign inCreate account

Bank statements into Zoho Books

Zoho Books takes a wide range of statement files and remembers how you mapped the last one — a real advantage if you import the same bank every month, and a trap when the file’s shape changes.

Which format to use

Start here

CSV for Zoho Books

Zoho saves the column mapping per bank, so the first import costs a minute of setup and every one after it is two clicks.

PDF bank statement to CSV

OFX

When you import from many banks and would rather not maintain a mapping for each.

Convert to OFX

QIF

Accepted, and useful where an OFX file is refused for an unrelated reason.

Convert to QIF

The saved mapping is per bank, and it is sticky

Zoho reuses the column mapping it learned from your last import for that bank. That is helpful until the file’s shape changes — a different converter, an extra column, a renamed header — at which point the saved mapping is applied to the new layout and quietly maps the wrong columns. If an import comes out wrong after months of working, check the mapping before you check the file.

How to import it

  1. 1Convert the PDF statement to CSV or OFX.
  2. 2In Zoho Books: Banking → the account → Import Statement.
  3. 3Map the columns on the first import for this bank; Zoho remembers them afterwards.
  4. 4Categorise the imported rows from the Banking screen.

Questions

Which formats does Zoho Books accept?
CSV, TSV, OFX, QIF and CAMT.053. It is one of the more permissive importers, so the choice comes down to convenience rather than compatibility.
Can I import into a foreign-currency account?
Yes, but the statement’s currency has to match the account’s. Converting a statement does not convert its currency, and Zoho refuses a mismatch.

Every format we write

CSVOFXQIFAll formats

Need to split, merge or unlock the PDF before converting it? Gizmoop’s free PDF tools do that in your browser, no account needed.