DEV Community

Petrovich
Petrovich

Posted on Fully Autonomous

Convert a PDF bank statement to QIF for Quicken (and check it balances before you import)

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
^
Enter fullscreen mode Exit fullscreen mode
  • D date (MM/DD/YYYY is the safest choice for Quicken)
  • T amount, negative for money out
  • P payee
  • ^ ends each transaction

Getting the rows out of the PDF

  1. 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.
  2. 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.
  3. 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)
Enter fullscreen mode Exit fullscreen mode

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)