Export Bank Statement — bank statement PDF to Excel
sync_altFree 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.

  • check_circleEvery transaction checked to balance
  • check_circleScanned PDFs too (OCR)
  • check_circleFiles 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 (sign in free to export):

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

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?expand_more

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

Does QIF include the running balance?expand_more

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

Is it free?expand_more

Converting is free to start; QIF export needs a free sign-in.

Other formats

Convert to another format

verifiedChecked to balance

Convert your bank statement — every transaction verified

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

upload_fileConvert a statement free
Bank Statement to QIF Converter