Bank Statement PDF to OFX Converter (Free Preview)

1. Download your statement

Grab the PDF statement from online banking. Statements downloaded from your bank are text-based and convert cleanly; scans and photos aren't supported yet.

2. Upload and verify

Utilly reads every transaction, then checks that opening balance + transactions = closing balance. You'll see Balanced ✓ or exactly how far off it is, before you pay anything.

3. Import the OFX file

Download the .OFX file from your results page. One credit unlocks every format, so the .QBO, CSV and Xero CSV come with it.
Xero: Accounting → Bank accounts → the account's menu icon (⋮) → Import a Statement. FreeAgent: Banking → Bank Accounts → the account → Upload Statement. Sage Accounting: its bank statement import under Banking.
GnuCash: File → Import → Import OFX/QFX transactions, then pick the account (it's remembered next time). For QuickBooks, download the .QBO instead.

Why OFX?

OFX is the bank statement file that Xero, Sage Accounting, FreeAgent and GnuCash all import without any column mapping, and Xero and FreeAgent suggest it over CSV when your bank offers it. If your bank only gives you PDF statements (or only keeps a few months online), Utilly reads the PDF, checks it against the opening and closing balance, and writes the OFX for you.

How to convert a bank statement PDF to OFX

Download the PDF statement from online banking. Statements downloaded from your bank are text-based and convert cleanly; scans and phone photos aren't supported yet.
Upload it above. We read every transaction and check that the opening balance plus the transactions equals the closing balance. You see Balanced ✓, or exactly how far off it is, before you pay anything.
Unlock and download the OFX file. One credit covers every format of that statement.
Import it into the matching bank or credit card account (see the table below), then reconcile against the same statement.

What's in the OFX file

The first transaction on our sample bank statement (business checking ending 0427) comes out as:

<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260901120000<TRNAMT>-6420.18
<FITID>20260901E26D1A27070800<NAME>ACH DEBIT GUSTO PAYROLL 0912
<MEMO>ACH DEBIT GUSTO PAYROLL 0912</STMTTRN>

Every transaction on the statement, with one signed amount (money out negative) and the description (NAME up to 32 characters, the full text in MEMO).
The closing balance as the ending balance, dated on the last transaction. On a card statement it's the New Balance, written as an amount owed.
The account's last 4 digits as the account ID when the statement prints them, otherwise an ID that stays the same for that account every month.
A transaction ID for each line, made from the account, date, amount and description. Converting the same statement again gives the same IDs. Your bank's own IDs aren't on the PDF, so they can't carry over.
Bank ID 999999999, a placeholder: the statement doesn't give us the bank's routing number in a form we can rely on.

Want to see it before uploading anything? Download the sample statement's OFX file (fictional bank, 31 transactions, 12,418.36 → 13,440.52), or the credit card one. More test files are in free sample bank statement files.

Which programs import the OFX file

Program	Where to import it
Xero	Accounting → Bank accounts → the account's menu icon (⋮) → Import a Statement. Xero lists OFX with QBO, QFX, QIF and CSV, and suggests OFX over CSV when you have the choice (Xero Central).
Sage Accounting	The bank statement import under Banking. Sage says OFX files upload without editing, and only the first bank account in a file is imported (Sage help).
FreeAgent	Banking → Bank Accounts → the account → Upload Statement. FreeAgent takes OFX, QIF and CSV, and a CSV has to be reformatted first (FreeAgent help).
GnuCash	File → Import → Import OFX/QFX transactions. Pick the account the first time; GnuCash remembers it for the next file from the same account (GnuCash manual).
QuickBooks	QuickBooks Online's Upload from file takes OFX (Intuit), but choose the .QBO output for QuickBooks: Desktop's Web Connect only reads .qbo files. On Desktop without Web Connect, use the .IIF.
Quicken	Use the QIF output for Quicken for Windows (File → File Import → QIF File). Quicken validates Web Connect files with its online service and says it doesn't support files made by third-party conversion software (Quicken), so we don't promise an OFX or QFX will open there.

Import one file per account, into the matching bank or credit card account, and only for dates that aren't in the program yet.

Common problems

Problem	Fix
The statement doesn't balance	You see the difference before paying. Don't import a file that's off; email us the statement layout and we'll fix it or refund you.
"This PDF is password protected"	Save a copy without the password, or download the statement again from online banking, and upload that.
Transactions imported twice	The statement overlapped dates already brought in from a bank feed or the bank's own file. Delete the extra copies and import only new months. See duplicate transactions after importing.
Several months to import	Convert one statement per upload and import them in date order. See catch-up bookkeeping from bank statements.

Other formats from the same statement

Xero: the Xero CSV, in Xero's own template (PDF to Xero).
QuickBooks: a .QBO, a QuickBooks Online CSV and an .IIF for Desktop (PDF to QuickBooks).
Excel or Google Sheets: the CSV (PDF to Excel). Quicken for Windows: the QIF.
Already have a CSV or Excel export? The free CSV to OFX converter makes the OFX without a credit for files up to 100 transactions.

Pricing

Preview any statement free. A $9 pack unlocks 5 full statements in every format, with no expiry and no subscription. Bookkeepers with many clients can go unlimited for $19/month. See pricing.

FAQ

Questions

Can I convert a bank statement PDF to OFX for free?

You can preview every statement free: we show the balance check and the first 5 transactions with no sign-up. Unlocking the full file costs one credit ($9 for 5 statements).

Is my statement stored?

No. The PDF is read in memory and never written to disk, and extracted results are deleted after 1 hour. We never use your data for AI training.

Do scanned statements work?

Not yet. PDFs downloaded from online banking are text-based and work well. Scans and phone photos need OCR, which is on the roadmap.

What if it doesn't balance?

You'll see exactly how far off it is before paying. If a paid conversion is wrong and we can't fix it, email support@version1.io for a refund.

Which programs accept the OFX file?

Xero, Sage Accounting, FreeAgent and GnuCash import it as a bank statement. QuickBooks Online's Upload from file takes OFX too, but for QuickBooks the .QBO on the same results page is the better pick, and QuickBooks Desktop only reads .qbo files.

Does the OFX file work for credit card statements?

Yes. Card statements are written as an OFX credit card statement, with charges as money out and payments and credits as money in, and the New Balance as the ending balance. Import it into a credit card account.

Will importing two overlapping OFX files create duplicates?

Each transaction gets the same ID every time you convert it, made from the account, date, amount and description, so programs that skip known transaction IDs skip the repeats. Your bank's own IDs aren't printed on the PDF, so they can't carry over: don't import over dates you already brought in from a bank feed or the bank's own file.

Will the OFX file work in Quicken?

We don't promise that. Quicken validates Web Connect files with its online service, and its Web Connect help says it doesn't support files made by third-party conversion software (it names PDF-to-QFX). For Quicken for Windows, download the QIF from the same results page.

Bank statement PDF to OFX

1. Download your statement

2. Upload and verify

3. Import the OFX file

Why OFX?

How to convert a bank statement PDF to OFX

What's in the OFX file

Which programs import the OFX file

Common problems

Other formats from the same statement

Pricing

Questions

Related guides

Free sample bank statement files: PDF, CSV, QBO, IIF, QIF and Xero CSV

Xero bank statement import errors (and how to fix them)

Catch-up bookkeeping: getting 12 months of bank statements into QuickBooks or Xero and reconciled

QBO vs IIF vs QIF: which file QuickBooks and Quicken actually need

How to find a bank reconciliation discrepancy: 7 causes and a 15-minute method

Duplicate transactions in QuickBooks after an import: find them, remove them, and stop them coming back

More bookkeeping tools

Receipts & invoices to CSV

Bank reconciliation checker

QuickBooks reconciliation discrepancy finder