From PDF to QuickBooks & Xero: the complete import guide

Why the import is where the afternoon disappears

Converting a bank statement to Excel is half the job. The other half — the one no guide talks about — is getting that data into QuickBooks or Xero without the software rejecting it, duplicating it or flipping the signs. If you keep the books for ten clients, you know it already: the problem is not reading the PDF, it is producing the file QuickBooks accepts on the first try.

This guide covers the three decisions that matter: which format to use (CSV or OFX), how to map the columns, and how to avoid the seven errors we see most often.

CSV or OFX? The 30-second decision

CSV is a plain text sheet: readable, editable, universal. It is also ambiguous — dates like "03/04" and amounts like "1.234,56" change meaning depending on the country, and every import needs column mapping.

OFX (Open Financial Exchange) is the banking standard: unambiguous dates and amounts, and every transaction carries an ID (FITID) that lets the software recognise duplicates if you import the same period twice.

The practical rule:

• Xero → OFX, almost always. Direct import, no mapping, duplicate protection.
• QuickBooks Online → 3- or 4-column CSV (QBO is pickier with generic OFX files; its official CSV layout goes in clean).
• Need to review or correct the data before importing (categories, descriptions)? CSV, which you open in Excel.

The CSV QuickBooks accepts on the first try

QuickBooks Online recognises two layouts. The 3-column one — Date, Description, Amount (negative = money out):

Date,Description,Amount
01/08/2026,ACME SUPPLIES LTD,-1250.00
02/08/2026,CLIENT PAYMENT INV 2041,3800.00

And the 4-column one — Date, Description, Credit, Debit (two separate columns, positive values).

The rules that keep the file from being rejected:

1. One date format only, matching your QuickBooks company settings (US: MM/DD/YYYY, UK/EU: DD/MM/YYYY). Never mix them.
2. No currency symbols, no thousands separators: 1250.00, not € 1.250,00.
3. Decimal point, even if your Excel is set to another locale.
4. One header row, no empty rows, no totals at the bottom.

The CSV for Xero (if you skip OFX)

Xero needs at least Date and Amount, plus Payee or Description. Same rules on dates and amounts. But when the source is a bank statement, OFX remains the shortest path: Xero ingests it natively and the FITID protects you from re-imports.

The 7 errors that ruin the import (and how to avoid them)

1. Ambiguous dates — is "03/04" March or April? If half the transactions land in the wrong month, reconciliation collapses. Check the company date format BEFORE exporting.
2. European amounts read wrong — "1.234,56" parsed as 1.23456: the classic when pasting from a European PDF into a US template.
3. Flipped signs — statements that show debits as positive: after the import, money in and money out are swapped. Use the right convention (outflows negative in the 3-column layout).
4. Duplicates — import August twice and the balances explode. OFX with FITID blocks them; with CSV you must check the date ranges by hand.
5. Broken descriptions — multi-line PDF descriptions become orphan rows that shift every column. (This is why copy-pasting from a PDF never works.)
6. A balance that does not add up — the worst error, because you discover it AFTER, at reconciliation. The golden rule: verify that opening + credits − debits = closing BEFORE importing, not after.
7. Encoding and accents — "Ó" turning into garbage: save as UTF-8.

The workflow without lost afternoons

With an OCR built for banking documents, the path shrinks to three steps:

1. Upload the PDF (scans included) → the engine extracts the transactions and rebuilds the table: date, description, amount, balance.
2. The balance check verifies the maths: opening + movements = closing, to the cent. If it does not add up, you see it immediately — not after a failed reconciliation.
3. Download the ready-made format: QuickBooks CSV (3 columns, dates and signs already compliant), Xero CSV, or OFX with FITID. Import, done.

myocr.app does exactly this, with every statement verified by the automatic balance check. Try it on a real statement — the first page is free, no sign-up.