Sheetfold

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.

or drop it here

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:

Example Bank · ••••6789 Example
DateDescriptionAmountBalance
Beginning balance4,210.00
Oct 14, 2026Oct 14, 2026RENT OCTOBER−1,450.002,760.00
Oct 15, 2026Oct 15, 2026ACME CORP PAYMENT+3,200.005,960.00
Oct 20, 2026Oct 20, 2026OFFICE DEPOT #1123−312.405,647.60
Ending balance5,647.60
becomes statement.ofx
OFXHEADER:100
DATA:OFXSGML
<BANKID>000000000
1<ACCTID>000123456789
<ACCTTYPE>CHECKING
<STMTTRN>
2<TRNTYPE>DEBIT
<DTPOSTED>20261014120000
<TRNAMT>-1450.00
3<FITID>202610148da6619482b6e9a0
<NAME>RENT OCTOBER
<LEDGERBAL>
4<BALAMT>5647.60
<DTASOF>20261020120000
  1. The account number from the statement.
  2. Each transaction starts with its type: DEBIT for money out, with a negative amount, and CREDIT for money in.
  3. An id for each transaction, the same every time this statement is exported, which importers use to skip rows they already have.
  4. The balance at the end of the statement, as printed.
An invented statement and the .ofx file made from it by the same code as a real download. One statement per file: several accounts in one PDF become several files.

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.

  • 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
As listed on each vendor’s help pages, 21 October 2026.

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.

or drop it here

All guides