Convert a PDF bank statement to OFX

When your bank feed is missing months, turn the PDF statements into OFX files your accounting software can import directly, with no column mapping.

Runs in your browser. Your file never leaves this device.

Loading the tool…

Importing the OFX file

OFX is the format bank feeds use. QuickBooks Online (Banking → Upload transactions), Xero (Bank account → Import a statement) and GnuCash (File → Import → OFX/QFX) all read it.

Each transaction gets a stable ID, so importing the same statement twice won't create duplicates in most accounting software.

Tips

  • Check the balance-match message before importing; a mismatch means a row needs a look.
  • Import one statement at a time, oldest first, so the running balance in your software lines up.

What this tool does

Bank feeds break. A connection lapses, a bank changes its login, or a new client hands over a year of PDF statements and nothing else. OFX (Open Financial Exchange) is the file format bank feeds use, so turning those PDFs into OFX lets you import them as if the feed had never stopped.

The converter reads the transactions from the PDF, checks them against the statement's opening and closing balance, and writes an OFX file with the dates, payees, signed amounts and the closing balance. Unlike a CSV, there are no columns to map: QuickBooks, Xero and GnuCash recognise the file straight away.

Each transaction gets an ID worked out from its date, amount and description, so importing the same statement again is recognised as a repeat by software that checks IDs. Everything happens in your browser; the statement is never uploaded.

People use it for

  • Back-filling months a broken bank feed missed in QuickBooks or Xero
  • Onboarding a new bookkeeping client who only has PDF statements
  • Importing an old or closed account that has no feed at all
  • Getting statements into GnuCash or other desktop accounting apps

How to use it

  1. Collect the missing statements

    Download each month you need as a PDF from online banking. Work oldest first.

  2. Convert and check the balance

    Drop one statement at a time. Only import files where the balance check is green, so the books stay in step with the bank.

  3. Import the OFX

    QuickBooks Online: Banking → Upload transactions. Xero: the bank account → Import a statement. GnuCash: File → Import → Import OFX/QFX.

What it works with

You give itYou get
Bank statement PDF (text)Excel (.xlsx)
Credit-card statement PDFCSV
Bank or card statement PDFOFX

Questions

Which accounting software accepts OFX?

QuickBooks Online, Xero, GnuCash and many other bookkeeping apps. Some desktop apps ask for QFX or QBO instead, which are close relatives of OFX; check your software's import menu.

Will importing the same statement twice create duplicates?

Each transaction carries a stable ID based on its date, amount and description. Software that checks IDs, which includes QuickBooks and Xero, skips ones it has already seen.

Why import OFX instead of CSV?

OFX needs no column mapping and carries the closing balance, so your software can confirm the account reconciles. CSV is better when you want to edit rows before importing.

Does it work for credit-card statements too?

Yes. Card statements become OFX with purchases as money out and payments and refunds as money in, which is how card accounts import into accounting software.

Is my client's statement uploaded?

No. The PDF is read and the OFX is created in your browser, on your device.

Guides