How to convert a bank statement to QIF
- 1
Drop the PDF statement
Download it from online banking first. Checking, savings and credit card statements all work; password-protected PDFs too.
- 2
Check the balance
Every transaction is listed with the result of the balance check. Fix anything that’s off right in the table.
- 3
Download QIF
Pick the date format you need in Export settings. Any other format is one click away too.
QIF and current Quicken
Current Quicken for Windows only imports QIF into some account types, not straight into checking or credit card accounts. For those, a QFX (Web Connect) file is the usual route, and the converter can write QFX too.
Pick the date format
QIF has no fixed date format. Choose MM/DD/YYYY for US software, DD/MM/YYYY for UK and Australian setups, or Quicken’s own M/D’YY.
The formats
- PDF statement
- The statement your bank lets you download from online banking. It looks like a table but is really text placed at positions on a page, which is why copying it into a spreadsheet goes wrong. Scanned paper statements are pictures of text and need OCR, which BankToRows doesn’t do yet.
- QIF
- Quicken Interchange Format, an older plain-text format with one field per line (D date, T amount, P payee, M memo). GnuCash, Moneydance and many smaller apps still import it; current Quicken for Windows only takes QIF into some account types.