Zoho Books import

Bank statement PDF to Zoho Books import file

Turn a PDF, scan or photo of a bank statement into a CSV, OFX or QIF file that Zoho Books can import. Free preview, full export from £2.49.

Drop your statement PDFs here

Add several at once · PDFs, scans and photos accepted

Select documents

Never stored on disk
UK GDPR compliant
In-memory processing

Works withBarclaysHSBCNatWestLloydsMonzoStarlingSantanderRevolutMetro Bank+ scanned paper

Not ready to upload? Download a sample of the files you get

These are made from an example statement with made-up transactions, so you can check the layout in your own software first. Nothing is uploaded.

CSV Excel Xero QuickBooks FreeAgent Sage QIF OFX

Structured output preview

Showing the first 3 transactions from your statement.

Date	Description	Money out (£)	Money in (£)	Balance (£)
24/09/2026	B&Q CROYDON RETAIL	£142.50	–	£2310.45
25/09/2026	CLIENT INVOICE #1042	–	+£850.00	£3160.45
26/09/2026	SCREWFIX CROYDON	£38.90	–	£3121.55
27/09/2026	OCTOPUS ENERGY DD	£85.00	–	£3036.55
28/09/2026	TRAVIS PERKINS TIMBER	£215.30	–	£2821.25

11 more transactions ready to download

Unlock to see every row and export to CSV, Excel, Xero, QuickBooks or FreeAgent.

Built for UK bookkeeping

Fast, private and formatted for the tools you already use.

Zero-disk processing

Files are streamed into volatile memory and discarded after conversion. Statements and extracted transactions are never written to disk or a database.

Every export you need

Standard 5-column CSV, native .xlsx workbooks, and signed-amount formats ready for Xero, QuickBooks and FreeAgent bank feeds.

Made for sole traders

Built for self-assessment, landlord accounts and contractors working with a mix of digital statements and paper scans.

Converting statements every month?

Plans start at £9.99 a month for 30 documents, including receipts and the self-assessment helper.

View monthly plans

What the Zoho Books file looks like

Use the CSV download once your statement is converted. Here are the first lines of that file, made from a sample statement with made-up transactions (10 rows in the full sample):

Date,Description,Money Out,Money In,Balance "01/09/2026","CLIENT INVOICE 1038 - HARRIS LTD",,1200.00,2800.00 "03/09/2026","B&Q CROYDON RETAIL",142.50,,2657.50 "05/09/2026","SCREWFIX DIRECT 4412",38.90,,2618.60

Our standard CSV has separate Money Out and Money In columns

In Zoho Books, choose the Double Column amount layout for that file

Or use the Sage or QuickBooks CSV with Single Column with Negative Values

How to import it into Zoho Books

Menus change from time to time, so look for the option described rather than an exact button name.

1In Zoho Books, open Banking and choose the account.

2Open the settings (gear) menu and choose Import Statement.

3Select the file. For the standard CSV, choose Double Column as the amount layout, and check the delimiter and encoding.

4On the Map Fields screen, match each column to the right Zoho field, and choose the date format DD/MM/YYYY.

5Review the transactions and import them.

Questions about Zoho Books imports

Which formats does Zoho Books accept?

Zoho's help lists CSV, TSV, OFX, QIF, CAMT.053, CAMT.054, MT940 and PDF. We produce CSV, OFX and QIF.

Which amount layout should I pick?

Zoho offers Double Column for separate deposit and withdrawal columns, and Single Column with Negative Values where positives are deposits. Our standard CSV suits Double Column. The Sage and QuickBooks CSVs suit the single column option.

How much does it cost?

You can preview the first rows for free. A full export costs £2.49 for one statement, with a 24-hour pass and monthly plans if you have more. You do not need an account for a one-off export.

Is my statement stored?

We do not store it. Your file is held in memory only while it is converted, and it is sent securely to Google's Gemini API to read the transactions. The privacy policy explains exactly how this works.

What happens to your file

Bank statements are personal. Here is exactly how yours is handled.

Read, then forgotten

Your statement is held in memory only while it is converted. We don't write it, or what is read from it, to disk or to a database of ours.

Read by Google's paid AI service

The file is sent securely to the Google Gemini API to extract the figures. Google acts as our processor and does not use your documents to train its models.

You see a small preview first

Before you pay, your browser gets only a short preview and an encrypted copy that only our server can open. Everything else stays locked.

Your results stay with you

After unlocking, your results are kept in your browser, not on our servers. Use Start again, or clear your browser data, to remove them.

Google may keep a log of requests for up to 55 days to detect misuse. The privacy policy has the full detail.