Export Bank Statement — bank statement PDF to Excel
Free converter

Convert a bank statement to QIF .qif

QIF (Quicken Interchange Format) is the long-standing plain-text format for moving transactions into Quicken and similar tools. This converts your statement PDF into a clean QIF bank register, with every transaction checked against the statement's running balance.

Upload the statement PDF at exportbankstatement.com/convert and choose QIF. You get a .qif file for Quicken and other personal-finance software, with dates written unambiguously so a 03/04 is never read as the wrong month. The reconciliation check runs first: opening plus credits minus debits must equal the stated closing balance.

  • Every transaction checked to balance
  • Scanned PDFs too (OCR)
  • Files deleted after processing

What a QIF file is

QIF is a simple text format: a !Type:Bank header followed by one block per transaction — date, signed amount and payee — ending with a ^ marker.

It carries no currency or running balance, so it's deliberately lightweight and widely accepted by older finance tools.

Why QIF

Quicken (older versions), GnuCash and various personal-finance tools import QIF directly.

It's a dependable fallback when a tool doesn't accept OFX or CSV.

How to import it

After converting (included with paid plans):

  1. Drop your statement PDF into the converter above, then sign in on a paid plan.
  2. Download the QIF file.
  3. In Quicken or GnuCash, choose File → Import → QIF and select the account.
  4. Review the imported register.

A note on QIF dates

QIF has no fixed date convention — different tools read MM/DD/YYYY or DD/MM/YYYY by their own setting. We export dates as MM/DD/YYYY; if your tool reads them the other way round, switch its QIF date setting on import. For richer, less ambiguous imports, OFX is the better choice where your tool supports it.

Checked before you download

Every conversion runs a reconciliation check — it ties the extracted transactions back to the statement's running balance, so credits and debits add up to the closing figure the bank printed. A statement that doesn't reconcile is flagged, not quietly exported — so your QIF file is correct before it reaches your books.

Frequently asked questions

Which tools import QIF?

Quicken (older versions), GnuCash and many legacy personal-finance tools. Newer Quicken often prefers QFX/OFX.

Does QIF include the running balance?

No — QIF is a lightweight format that carries date, amount and payee only. We still check the balance before export.

Is it free?

Converting, and Excel, CSV or JSON downloads, are free. QIF export is included with every paid plan, starting with Starter.

Other formats

Convert to another format

Related guides

Import into your accounting software

Checked to balance

Convert your bank statement — every transaction verified

Upload any PDF, get clean Excel or CSV ready for Xero & QuickBooks. Scanned statements too.

Convert a statement free