How to Convert a Bank Statement to QIF (Quicken Format)

What a QIF file is, which tools still use it, and how to convert a PDF bank statement into QIF without retyping transactions.

QIF (Quicken Interchange Format) is one of the oldest ways to move bank transactions between programs, and a surprising number of tools still require it. If your software asks for a .qif file and all you have is a PDF statement, here is how to bridge the gap.

What is a QIF file?

QIF stands for Quicken Interchange Format. It is a plain-text format that describes financial transactions — dates, amounts, payees, and categories — in a structure that Quicken and many older personal-finance programs can import. It predates OFX and QBO, which is why it survives mainly in older software.

Who still uses QIF?

  • Quicken Classic — the desktop versions read QIF imports.
  • Older personal-finance apps — tools that were built before OFX became common.
  • Custom scripts and spreadsheets — QIF's simple text structure makes it easy to process.

How to convert a PDF bank statement to QIF

A PDF statement cannot be imported directly — the transactions need to be extracted into a structured format first. The fastest path:

  1. Upload the PDF to our bank statement to QIF converter. Digital and scanned statements both work.
  2. AI reads the layout and extracts every transaction — date, description, and amount.
  3. Download the QIF file and import it into your software.

The whole process takes a minute or two, versus an hour of retyping a multi-page statement.

QIF vs OFX vs QBO

All three are import formats, but they are aimed at different software:

  • QIF — the legacy Quicken format. Use it when your tool specifically asks for .qif.
  • OFX — the open standard used by Xero, Sage, GnuCash, MYOB, and Wave. The modern default outside QuickBooks.
  • QBO — QuickBooks' own wrapper around OFX. The direct path into QuickBooks Desktop and Online.

If you are unsure which one your software accepts, check its import menu — it will name the format explicitly. Our converter produces all three from the same upload, so you can generate whichever you need.

Common pitfalls when importing QIF files

  • Sign conventions — debits should be negative and credits positive. Our converter normalizes this so your balances add up.
  • Date formats — QIF expects a specific date style; the converter writes dates in the format Quicken expects.
  • Duplicate imports — importing the same file twice can double your transactions. Our converter derives a deterministic identifier per transaction so re-imports deduplicate cleanly.

Frequently asked questions

Is QIF the same as OFX?

No. QIF is the older Quicken text format; OFX is the newer open standard. They are not interchangeable, so use the one your software asks for.

Can I convert a scanned statement to QIF?

Yes. The converter reads scanned and image-based statements with AI vision, so paper statements work the same as digital PDFs.

Which banks can I convert to QIF?

The converter works with statements from 30+ banks — see the supported banks list. If your bank is not listed, the AI extraction still handles the layout.

← All guides