QIF file: what it is, who still reads it, and how to make one from a PDF
QIF is the oldest bank statement file still in use: plain text, one line per field. Many programs still import it. If yours takes OFX too, that is usually the better choice; if QIF is what it asks for, convert the PDF to QIF below.
Updated Oct 21, 2026 · 6 min read
The short answer: a QIF file is a plain-text list of transactions in Quicken Interchange Format. GnuCash, Moneydance, Banktivity, MYOB, FreeAgent, Sage, Xero, YNAB and Zoho Books still import it. To make one from a PDF statement, drop the PDF in the converter below and download QIF (.qif). If your software also takes OFX, use that instead: it carries more.
Convert a statement PDF to QIF
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 .qif file first. 5 free pages a day with an account.
What is inside a QIF file
A QIF file starts with the account type, then lists transactions one field per line. Each line begins with a letter that says what it holds, and a caret ends the transaction. This is the real file Sheetfold writes for 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 type: Bank for a bank account, CCard for a credit card.
- D, the date, written month first (MM/DD/YYYY), the order QIF readers assume.
- T, the amount: negative for money out, positive for money in.
- P, the payee: the description from the statement.
- The caret ends the transaction.
Which programs import QIF
| QIF | Where to import | Better choice if offered | |
|---|---|---|---|
| GnuCash | Yes | File, Import, Import QIF | OFX |
| Moneydance | Yes | File, Import | OFX or QFX (its own advice) |
| Banktivity Mac | Yes | File, Import Transactions | OFX or QFX |
| MYOB Australia | Yes | Banking, the account’s menu, Import statement | OFX |
| FreeAgent UK | Yes, called “an older format” | Banking, Bank Accounts, the account, Upload Statement | OFX |
| Sage Accounting UK | Yes, asks you to confirm the date order | Banking, the account’s actions, Import statement | OFX |
| Xero | Yes | The bank account, Manage Account, Import a Statement | OFX |
| YNAB | Yes | Drag the file onto YNAB | CSV (its preferred format) or OFX |
| Zoho Books | Yes | Banking, the account, Import Statement | OFX |
| Quicken | Mac: only to start a new data file. Windows: depends on the version | File, File Import, QIF File (Windows) | QFX |
| Wave | No | OFX | |
| QuickBooks | No | QBO |
GnuCash
- QIF
- Yes
- Where to import
- File, Import, Import QIF
- Better choice if offered
- OFX
Moneydance
- QIF
- Yes
- Where to import
- File, Import
- Better choice if offered
- OFX or QFX (its own advice)
BanktivityMac
- QIF
- Yes
- Where to import
- File, Import Transactions
- Better choice if offered
- OFX or QFX
MYOBAustralia
- QIF
- Yes
- Where to import
- Banking, the account’s menu, Import statement
- Better choice if offered
- OFX
FreeAgentUK
- QIF
- Yes, called “an older format”
- Where to import
- Banking, Bank Accounts, the account, Upload Statement
- Better choice if offered
- OFX
Sage AccountingUK
- QIF
- Yes, asks you to confirm the date order
- Where to import
- Banking, the account’s actions, Import statement
- Better choice if offered
- OFX
Xero
- QIF
- Yes
- Where to import
- The bank account, Manage Account, Import a Statement
- Better choice if offered
- OFX
YNAB
- QIF
- Yes
- Where to import
- Drag the file onto YNAB
- Better choice if offered
- CSV (its preferred format) or OFX
Zoho Books
- QIF
- Yes
- Where to import
- Banking, the account, Import Statement
- Better choice if offered
- OFX
Quicken
- QIF
- Mac: only to start a new data file. Windows: depends on the version
- Where to import
- File, File Import, QIF File (Windows)
- Better choice if offered
- QFX
Wave
- QIF
- No
- Where to import
- Better choice if offered
- OFX
QuickBooks
- QIF
- No
- Where to import
- Better choice if offered
- QBO
QIF or OFX: why OFX is usually better
- No transaction ids. OFX gives every transaction an id, so importing an overlapping period skips rows you already have. QIF cannot, and some importers then add them twice.
- No account or balance. A QIF file does not say which account it belongs to or what the balance was at the end, so the importer cannot help you check it.
- Ambiguous dates. 03/04/2026 is March 4 to an American program and 3 April to a British one. Sage asks you to confirm the order for that reason. Sheetfold writes QIF dates month first, the convention QIF readers assume; if your software reads days first, choose OFX.
QIF is still the right file when it is the only one your program takes, or when you are moving history into a tool such as GnuCash that handles it well. Otherwise use OFX, or QFX for Quicken.
From PDF to QIF, checked first
Because a QIF file carries no balance, nothing in your software will notice a misread amount until the account stops matching the bank. That makes the check before the file is written more important, not less. Sheetfold reads each page, adds the rows between every two balances the bank printed and requires the sums to match to the cent (on card statements, the printed totals). Rows that do not add up are flagged with the page beside them, so the QIF you download matches the statement.
Sources, checked 21 October 2026: GnuCash, Moneydance, Banktivity, MYOB, FreeAgent, Sage, Xero, YNAB, Zoho Books, Quicken (Windows), Quicken import formats, Quicken for Mac, Wave.
Questions
- What is a QIF file?
- Quicken Interchange Format: a plain-text file where each transaction is a few lines (a date, an amount, a payee) ending with a caret (^). It was made for Quicken and is now read by many money and accounting programs.
- How do I open a QIF file?
- Import it into GnuCash, Moneydance, Banktivity, MYOB, FreeAgent, Sage, Xero, YNAB or Zoho Books. To just read it, open it in Notepad or any text editor.
- Can I convert a PDF to QIF for free?
- Sheetfold converts 5 pages a day free with an account (1 without one), with the QIF download included.
- QIF or OFX?
- OFX when your software takes both: each OFX transaction carries an id that lets the importer skip rows it already has, and the file names the account and its ending balance. QIF has none of that.
- Can Quicken still import QIF files?
- Quicken for Mac imports QIF only to start a new data file. For Quicken for Windows, Quicken’s own pages disagree on whether QIF can go into checking, savings and card accounts. For bank and card statements, use a QFX file instead.
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- OFX file: what it is, where it goes, and how to make one from a PDF What an OFX file is, which accounting and budgeting apps import it (Xero, Sage, FreeAgent, Wave, YNAB, MYOB...), and how to turn a PDF statement into one.
- 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.