Sheetfold

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.

or drop it here

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:

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.qif
1!Type:Bank
2D10/14/2026
3T-1450.00
4PRENT OCTOBER
5^
D10/15/2026
  1. The account type: Bank for a bank account, CCard for a credit card.
  2. D, the date, written month first (MM/DD/YYYY), the order QIF readers assume.
  3. T, the amount: negative for money out, positive for money in.
  4. P, the payee: the description from the statement.
  5. The caret ends the transaction.
An invented statement and the .qif file made from it by the same code as a real download. Note what is missing: no account number, no balance, no transaction ids.

Which programs import QIF

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

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.

or drop it here

All guides