Why convert to OFX for Zoho Books
Zoho Books imports bank statements as CSV, TSV, XLS, OFX, QIF, CAMT.053 and CAMT.054 files (Zoho Books: How to import a bank statement, checked October 2026). With a CSV you choose an Amount Column Type (double column, single column with an amount type, or single column with negative values), set the encoding and delimiter, and map each header to a Zoho field. Get one wrong and money in becomes money out. An OFX file labels the date, amount, payee and a unique ID for every transaction, so the import has far less to go wrong.
How to import the file into Zoho Books
- Go to Banking in the left sidebar and select the bank account.
- Click Import Statement at the top right of the account page.
- Under Upload File, choose the .ofx file and continue through Zoho’s steps.
- Review the preview and click Import. The lines arrive as uncategorized transactions, ready to match or categorize.
Zoho’s screens differ a little between regional editions (US, UK, India and others), so follow the labels on your screen.
Before you import
- Pick the bank’s region in step 1 so dates are read the right way round: month-first for the US and Canada, day-first for the UK, Australia and New Zealand.
- Currency: set the currency in step 3 to the account’s currency.
- Cards and multiple accounts: convert each account separately and choose Credit card in step 3 for card statements.
- Check the totals in the preview against your statement before downloading.
How your data stays private
- Your browser reads the file. The converter is JavaScript that runs on this page and opens your file on your own device.
- Nothing is sent to a server. Your file and its contents are never uploaded, to us or to anyone else. The page also loads Google Analytics and Google ads; useme4’s code never passes your file to them.
- It works offline. Once this page has loaded, you can disconnect from the internet and the converter keeps working.
You can check this yourself in about a minute: how to verify that your file never leaves your browser.
What this converter can’t do
- PDF statements. This converter reads CSV, Excel and OFX/QFX/QBO files. For a PDF, use PDF bank statement to Excel.
- Old .xls files. Excel 97–2003 workbooks aren’t supported. Open the file in Excel or Google Sheets and save it as .xlsx or CSV first.
- Files over 25 MB. Download a shorter date range from your bank instead.
- Dates that could go either way. If every date in a file could be day-first or month-first (like 03/04/2026), the converter follows your region and warns you. Check the preview.
- Checking your bank’s file. It can only convert what the bank exported. Compare the transaction count and totals with your statement before you import.
Frequently asked questions
Which formats does Zoho Books import?
Zoho Books lists CSV, TSV, XLS, OFX, QIF, CAMT.053 and CAMT.054 for bank statement imports. This converter produces OFX.
Why use OFX instead of my bank’s CSV?
With a CSV you have to map every column and choose how amounts are signed. An OFX file already labels each field, so there is less to set up and less to go wrong.
Does it work for banks outside the US?
Yes. Choose the bank’s region in step 1 so dates are read correctly, and set the account’s currency in step 3.
Can I import a PDF bank statement into Zoho Books?
Convert it first with the PDF bank statement converter, choose OFX as the output, and import that file.
Is my bank file uploaded?
No. The conversion happens in your browser and the file never leaves your device.