Quicken imports QIF, QFX and OFX, but banks often only give you PDF statements for anything older than a few months. If you are rebuilding a year of history, typing it in is not an option.
What a QIF file looks like
QIF is plain text, which makes it easy to generate:
!Type:Bank
D03/01/2026
T-54.20
PGrocery Mart
^
D03/02/2026
T2540.00
PPayroll ACME
^
-
Ddate (MM/DD/YYYY is the safest choice for Quicken) -
Tamount, negative for money out -
Ppayee -
^ends each transaction
Getting the rows out of the PDF
-
Copy-paste into a spreadsheet, fix the columns, then build the QIF lines with a formula like
="D"&TEXT(A2,"mm/dd/yyyy"). Fine for one short statement. - Script it with pdfplumber or pdf.js: group text by its y-position into rows, detect the date at the start of each row, assign amounts to the Debit/Credit/Balance column by x-position, and join wrapped description lines.
- Use a converter. Disclosure: I made Backfill, which does step 2 in your browser (nothing is uploaded) and exports QIF, OFX or CSV.
The step people skip: reconcile before importing
Once Quicken has 300 imported transactions, finding one misread amount is miserable. Check first:
opening balance + sum(transactions) == closing balance
previous row balance + amount == this row balance (for every row)
If both hold, the conversion is complete and correct to the cent. Backfill shows this as a green badge and highlights any row that breaks the chain.
Importing into Quicken
File → File Import → QIF File → pick the account. Import one statement first and compare the ending balance with the paper statement before doing the rest.
Questions about a specific bank layout? Leave the column headers (no personal data) in the comments.
Top comments (0)