OFX and QFX · nothing uploaded
PDF to OFX and QFX converter
Drop a PDF bank or credit card statement and download an OFX file for Xero, Sage, GnuCash and Moneydance, or a QFX file for Quicken. The statement is read in your browser and checked against its own balances.
Exports to Excel · CSV · QBO · OFX · QFX · Xero · Tally
How it works
Three steps. No upload.
The whole conversion runs in your browser tab, so your statement never reaches a server.
- 01
Drop the PDF
Bank or credit card statement. Card statements are written as card statements, not as a bank account.
- 02
Check it, pick OFX or QFX
OFX for most software, QFX for Quicken. Both hold the same transactions, so you can download each from one review.
- 03
Import the file
Look for “import a bank statement” in your software. The IDs stop duplicates if you import the same file twice.
The balance check
Open standard, checked before it’s written
OFX describes transactions and a closing balance, not whether the transactions are complete. Software that imports it takes the rows at face value.
So we compare first. All rows are added up and checked against the opening and closing balances printed on the statement, and the review screen shows Off by an amount if they differ. The statement’s closing balance goes into the file as its ledger balance.
example-bank_2026-09.pdf
- Opening balance
- 5,210.00
- + Credits
- 4,820.15
- − Debits
- 2,457.43
- = We calculated
- 7,572.72
- Statement says
- 7,572.72
If the last row had been missed:
Off by 12.40 possible missed line on page 2
The file
OFX 1.02, with or without Intuit’s ID
OFX is the plain-text version 1.02, which every importer we know of reads. QFX is the same file with the Intuit bank ID that Quicken looks for. This is a real export of a made-up statement.
OFX and QFX side by side
| Format | File | Intuit bank ID block | Opens in |
|---|---|---|---|
| OFX | .ofx | No | Xero, Sage, GnuCash, Moneydance, Quicken |
| QFX | .qfx | Yes, INTU.BID 3000 | Quicken |
Sign-on block
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20261001120000
<LANGUAGE>ENG
</SONRS>
</SIGNONMSGSRSV1>First two transactions
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20260902120000
<TRNAMT>2400.00
<FITID>202609021iq8gg3rdjecw
<NAME>Payroll deposit
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260903120000
<TRNAMT>-1850.00
<FITID>20260903s39g5xng5mec
<NAME>Rent Oak Street LLC
</STMTTRN>- Version
- OFX 1.02 (SGML), ASCII text with Windows-1252 as the character set.
- Bank or card
- Bank accounts use a bank statement section, credit cards a card statement section, so software files them in the right kind of account.
- Stable IDs
- Each FITID is the same every time the same row is exported, so a second import skips what is already there.
- Account number
- Optional. Software like Quicken remembers which account a file maps to by this number.
Import
Import the file
Xero
- 1.Open Accounting, then Bank accounts.
- 2.On the account, choose Manage account, then Import a statement.
- 3.Pick the .ofx file and import, then reconcile as usual.
Quicken for Windows
- 1.Choose File, File Import, Web Connect (.QFX) File.
- 2.Pick the .qfx file.
- 3.Link it to an existing account or create one, then accept the transactions.
Quicken for Mac
- 1.Choose File, Import, Bank or Brokerage File (OFX, QFX).
- 2.Pick the file and the account it belongs to.
GnuCash, Sage, Moneydance
- 1.GnuCash: File, Import, Import OFX/QFX.
- 2.Sage and Moneydance: look for importing a bank statement or OFX file.
FAQ