OFX file: what it is, where it goes, and how to make one from a PDF
OFX is the file most accounting and budgeting software takes for bank transactions. Banks offer it as a download; when you only have the PDF statement, convert it to OFX and import it the same way.
Updated Oct 21, 2026 · 7 min read
The short answer: an OFX file is a bank statement in Open Financial Exchange format, the plain-text file that Xero, Sage, FreeAgent, Wave, MYOB, YNAB, GnuCash and most other money software import. To make one from a PDF statement, drop the PDF in the converter below and download OFX (.ofx); then import it from the bank account in your software.
Convert a statement PDF to OFX
Drop a bank or credit card statement, in any language, digital or scanned. Sheetfold reads every row, checks it against the balances your bank printed, and offers the .ofx file first. 5 free pages a day with an account.
What is inside an OFX file
OFX is an open standard for exchanging bank data, now kept by the Financial Data Exchange (FDX), which says more than 7,000 banks and brokerages use it. A statement file is short and readable: the account, one block per transaction, and the balance at the end. This one was made from three rows of an example statement:
| Date | Description | Amount | Balance |
|---|---|---|---|
| Beginning balance | 4,210.00 | ||
| Oct 14, 2026 | Oct 14, 2026RENT OCTOBER | −1,450.00 | 2,760.00 |
| Oct 15, 2026 | Oct 15, 2026ACME CORP PAYMENT | +3,200.00 | 5,960.00 |
| Oct 20, 2026 | Oct 20, 2026OFFICE DEPOT #1123 | −312.40 | 5,647.60 |
| Ending balance | 5,647.60 |
- The account number from the statement.
- Each transaction starts with its type: DEBIT for money out, with a negative amount, and CREDIT for money in.
- An id for each transaction, the same every time this statement is exported, which importers use to skip rows they already have.
- The balance at the end of the statement, as printed.
Which software imports OFX, and where
From each program’s own help pages. The menu path is where the import lives; formats are what each one lists for bank statement files.
| Imports | Where to import | Good to know | |
|---|---|---|---|
| Xero | OFX, QFX, QBO, QIF, CSV | The bank account, Manage Account, Import a Statement | Leaves out duplicate transactions. In the US and Canada it also reads PDFs from supported banks |
| Sage Accounting UK | OFX, QIF, CSV, XLS | Banking, the account’s actions, Import statement | Imports only the first bank account in a file |
| FreeAgent UK | OFX, QIF, CSV | Banking, Bank Accounts, the account, Upload Statement | Ignores duplicates it spots; start the file the day after the last transaction you have |
| MYOB Australia | OFX, QIF (desktop also QFX) | Banking, the account’s menu, Import statement | Files under 10 MB |
| Wave | OFX, QFX, QBO, CSV; no QIF | Accounting, Transactions, More, Upload transactions | The statement must be in the account’s currency |
| Zoho Books | OFX, QIF, CSV, TSV, CAMT.053 | Banking, the account, Import Statement | The last import can be undone |
| YNAB | CSV, OFX, QFX, QIF | Drag the file onto YNAB | Not on phones; skips rows with the same date and amount |
| GnuCash | OFX, QFX, QIF, CSV | File, Import, Import OFX/QFX | Flags transactions it already has |
| Moneydance | OFX, QFX, QIF, CSV | File, Import | Recommends OFX or QFX over QIF |
| Banktivity Mac | OFX, QFX, QIF, CSV | File, Import Transactions | |
| Quicken | Mac: OFX, QFX. Windows: QFX only | Mac: File, Import, Bank or Brokerage File | Quicken for Windows does not import plain OFX: use QFX |
| QuickBooks | Online: QBO, QFX, OFX, CSV. Desktop: QBO | Online: Bank transactions, Link account, Upload from file | Intuit suggests QBO; Desktop takes only QBO |
Xero
- Imports
- OFX, QFX, QBO, QIF, CSV
- Where to import
- The bank account, Manage Account, Import a Statement
- Good to know
- Leaves out duplicate transactions. In the US and Canada it also reads PDFs from supported banks
Sage AccountingUK
- Imports
- OFX, QIF, CSV, XLS
- Where to import
- Banking, the account’s actions, Import statement
- Good to know
- Imports only the first bank account in a file
FreeAgentUK
- Imports
- OFX, QIF, CSV
- Where to import
- Banking, Bank Accounts, the account, Upload Statement
- Good to know
- Ignores duplicates it spots; start the file the day after the last transaction you have
MYOBAustralia
- Imports
- OFX, QIF (desktop also QFX)
- Where to import
- Banking, the account’s menu, Import statement
- Good to know
- Files under 10 MB
Wave
- Imports
- OFX, QFX, QBO, CSV; no QIF
- Where to import
- Accounting, Transactions, More, Upload transactions
- Good to know
- The statement must be in the account’s currency
Zoho Books
- Imports
- OFX, QIF, CSV, TSV, CAMT.053
- Where to import
- Banking, the account, Import Statement
- Good to know
- The last import can be undone
YNAB
- Imports
- CSV, OFX, QFX, QIF
- Where to import
- Drag the file onto YNAB
- Good to know
- Not on phones; skips rows with the same date and amount
GnuCash
- Imports
- OFX, QFX, QIF, CSV
- Where to import
- File, Import, Import OFX/QFX
- Good to know
- Flags transactions it already has
Moneydance
- Imports
- OFX, QFX, QIF, CSV
- Where to import
- File, Import
- Good to know
- Recommends OFX or QFX over QIF
BanktivityMac
- Imports
- OFX, QFX, QIF, CSV
- Where to import
- File, Import Transactions
- Good to know
Quicken
- Imports
- Mac: OFX, QFX. Windows: QFX only
- Where to import
- Mac: File, Import, Bank or Brokerage File
- Good to know
- Quicken for Windows does not import plain OFX: use QFX
QuickBooks
- Imports
- Online: QBO, QFX, OFX, CSV. Desktop: QBO
- Where to import
- Online: Bank transactions, Link account, Upload from file
- Good to know
- Intuit suggests QBO; Desktop takes only QBO
OFX, QFX or QBO?
The transactions inside are identical. QFX and QBO add an Intuit header that names the bank, because Quicken and QuickBooks Desktop require one. So: QFX for Quicken, QBO for QuickBooks, and plain OFX for everything else. Sheetfold exports all three from the same converted statement, plus QIF for older programs and CSV.
An OFX file made from a PDF, checked first
Banks offer OFX downloads only for recent months, if at all, and Xero’s PDF import works only in the US and Canada and only for supported banks. For everything else there is the PDF statement, and the question is whether the rows that come out of it are right. Accounting software imports whatever the file says; a misread amount surfaces weeks later as a reconciliation that will not balance.
Sheetfold checks before it writes the file: it adds the rows between every two balances the bank printed and requires the sums to match to the cent, and on card statements it uses the printed totals instead. Rows that do not add up are flagged with the page beside them, so the OFX you download matches the statement.
If the import goes wrong
- Only part of the statement arrived: some programs (Sage Accounting among them) read only the first account in a file. Sheetfold writes one file per account, so a PDF with a current account and a savings account gives you two files.
- Duplicates: most importers skip transactions they already have, by id or by date and amount. If you also have a bank feed, start the imported period where the feed ends.
- Wrong currency: Wave (and others) need the statement in the account’s currency. Multi-currency statements become one file per currency.
- Charges arrive as income: a credit card statement went into a bank account. Import it into the card account.
Sources, checked 21 October 2026: FDX OFX Work Group, Xero, Sage, FreeAgent, MYOB, Wave, Zoho Books, YNAB, GnuCash, Moneydance, Banktivity, Quicken, QuickBooks Online.
Questions
- What is an OFX file?
- Open Financial Exchange: a plain-text format for bank and card transactions. An OFX statement file holds the account, every transaction with its date, amount, description and an id, and the balance at the end.
- Can you convert a PDF to OFX?
- Yes. A bank statement converter reads the rows from the PDF and writes them as OFX. Sheetfold does it for any bank and language, and checks every row against the printed balances first; 5 pages a day are free with an account.
- What is the difference between OFX, QFX and QBO?
- The transactions inside are the same. QFX (for Quicken) and QBO (for QuickBooks) add an Intuit header naming the bank, which those two programs require. Everything else reads plain OFX, and most also read QFX and QBO.
- How do I open an OFX file?
- Import it into the account it belongs to in your accounting or budgeting software. To just look inside, open it in Notepad or any text editor: it is plain text.
- Does Quicken import OFX files?
- Quicken for Mac does (File, Import, Bank or Brokerage File). Quicken for Windows does not import plain OFX; it takes the QFX version, which Sheetfold also exports.
Try it on your own statement
Drop a PDF here and Sheetfold reads it, then checks every row against the balances your bank printed. A free account converts 5 pages a day.
Keep reading
All guides- QFX file: what it is, and how to make one from a PDF statement What a QFX file holds, which programs open it, and how to turn a PDF bank statement into a QFX that Quicken for Windows or Mac imports.
- PDF to CSV: convert a bank statement, every row checked Convert a PDF bank statement to CSV with every row checked against the printed balances, then open it in Excel, Google Sheets or accounting software.