Skip to content
Toolspike

PDF statement to QIF

QIF, the Quicken Interchange Format, is a plain-text format older than OFX that many personal-finance and small-business programs still import. It is a good choice when a program lists QIF but not OFX, or when you want a file you can open and read as plain text.

No sign-up to read and check a statement, and 5 pages a day download free with a free account. A PDF with text is read in your browser and not uploaded; scans and photos go to AI only if you choose.

5 statement pages free every day with a free account, and every row and the balance check to see first. A Statement Pass covers bigger jobs, paid once.

  • Stays on your deviceA PDF with text is read in this browser and never uploaded. A scan is sent to our AI provider only if you choose.
  • Checked against the balanceEvery row has to land on the running balance the bank printed, so a misread figure shows up before it reaches your books.
  • Nothing keptNo statement or download is stored on our servers, and a password only opens the file.

See it before you upload

From PDF lines to rows your books accept

The first rows of the made-up sample statement, as printed and as you download them. Press “Try a sample statement” above to open all of it.

What the statement prints

  1. 08/01POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA5.45Withdrawals
  2. 08/02CHECK 10451,200.00Withdrawals
  3. 08/03ACH DEPOSIT NORTHWIND LLC PAYROLL2,500.00Deposits
  4. 08/05WIRELESS BILL AUTOPAY89.99Withdrawals
  5. 08/08POS PURCHASE BLUE DOOR COFFEE #12 SEATTLE WA6.10Withdrawals

What you download

  1. Blue Door Coffee SeattleRestaurants and takeaway−$5.45Aug 1
  2. Check 1045Uncategorized−$1,200.00Aug 2
  3. Northwind LLC PayrollPayroll and wages+$2,500.00Aug 3
  4. Wireless Bill AutopayPhone and internet−$89.99Aug 5
  5. Blue Door Coffee SeattleRestaurants and takeaway−$6.10Aug 8

Reconciled: every running balance matches

Opens in the software you use

  • QuickBooks OnlineQBO or CSV
  • QuickBooks DesktopQBO or IIF
  • XeroOFX or CSV
  • QuickenQFX
  • SageCSV
  • WaveCSV
  • FreeAgentCSV
  • MYOBOFX or QIF
  • Zoho BooksCSV, OFX or QIF
  • GnuCashOFX or QIF
  • Excel and Google SheetsXLSX or CSV
  • TallyXML

Product names belong to their owners; Toolspike is not connected with them. Each file is one that program’s own import reads.

Insights on every statement

Average daily balance
$7,103.26
Biggest spending category
Rent and mortgage, $2,000.00
Recurring payment found
Blue Door Coffee Seattle, weekly, about $5.45
Returned, NSF or overdraft rows
1

Figures from the made-up sample. Your own statements get the same panel, and the full lists in the Insights sheet of the Excel download.

In the QIF file

  • A Bank or CCard header, matching the account type
  • The date, signed amount and payee of every transaction
  • The full description as a memo when it is longer than the payee
  • The cheque or reference number, when the statement prints one
  • Dates in US style or as DD/MM/YYYY, whichever your program expects

Choosing the date style

QIF has no fixed date format, so each program guesses. US-style dates are written as month, day and year with an apostrophe before the year, the form Quicken used. If your program reads days first, choose DD/MM/YYYY instead; GnuCash asks which order to use while importing.

What QIF leaves out

QIF has no transaction IDs and no closing balance, so a program cannot tell whether it has seen a row before. Import each statement once, or use OFX, which carries IDs, when the program supports both.

Questions

Which programs import QIF?

GnuCash, Moneydance, Zoho Books and many other personal-finance and bookkeeping programs read QIF. Recent versions of Quicken limit QIF imports, so for Quicken itself the QFX download is the better choice.

Why does the QIF have no balance?

The format only lists transactions. The converter still checks every row against the statement’s running balance before you download, so the transactions in the file are the ones that add up.

Can I convert a credit card statement to QIF?

Yes. A card statement is written with the CCard header, and charges come out as negative amounts and payments as positive, which is how programs expect a card account to look.

Why are some characters replaced?

QIF files are read as plain ASCII by most programs, so accented letters lose their accents and the rupee sign is written as INR. Amounts, dates and references are never changed.