Convert PDF to QIF

Banks and card issuers commonly provide statements as PDFs, while Quicken and other personal-finance programs may require QIF for transaction import. Converting the statement avoids manually re-entering dates, payees, and amounts when the institution does not offer a QIF, OFX, or QFX download.

What the PDF format is

PDF, or Portable Document Format, preserves page layout, fonts, text, and graphics across operating systems. Banks, card issuers, brokers, employers, and accounting departments use it for downloadable statements and reports.

A PDF can contain selectable text, positioned text fragments, or scanned page images. Selectable text can usually be parsed directly; scanned pages require optical character recognition (OCR). PDF has no standard transaction fields for dates, payees, amounts, categories, transfers, or reconciliation status, so conversion software must infer those fields from page layout.

What the QIF format is

QIF, or Quicken Interchange Format, is a plain-text exchange format supported by Quicken and several other finance applications. A typical bank record uses !Type:Bank, D for date, T for amount, P for payee, M for memo, and ^ to end the transaction.

QIF is portable, human-readable, and useful when the destination supports QIF but the financial institution provides only a PDF. Its support is less consistent than OFX or QFX, and it may not preserve attachments, investment details, reconciliation state, institution-specific fields, or every type of split transaction.

How to convert a statement

For a bank or card statement, use a purpose-built desktop converter rather than a generic PDF-to-text utility. MoneyThumb PDF2QIF is designed to recognize statement columns and create QIF records; obtain the current Windows or macOS version from the official MoneyThumb website. Do not upload a statement to an unknown conversion site.

1. Download the original statement from the financial institution and save it as statement.pdf. Do not print and rescan it; the downloaded file normally provides better text extraction.
2. Open PDF2QIF, select the PDF, and unlock it first in Adobe Acrobat or the bank portal if it is password-protected.
3. Select the account type, such as Bank or Credit Card, and restrict the page range if the PDF includes advertisements, terms, notices, or summary pages.
4. Map the detected fields to transaction date, payee or description, memo, debit, credit, and balance. Confirm the date format and whether withdrawals are negative or are listed in a separate debit column.
5. Set the destination account and an output name such as checking-2026-01.qif, then export the file.
6. Open the QIF in a plain-text editor and check that it has a type header, transaction records, and a terminating ^ for each record. Avoid editing it in a word processor.
7. Import the file using the destination program's QIF command. In Quicken for Windows, use File → Import File → QIF File; other programs may label the command Import QIF or Import Quicken data. Select the intended account.
8. Compare the imported count, date range, amounts, and ending balance with the statement. Back up an existing finance file before importing, and test a short date range before processing a full year.

When direct conversion fails

If the PDF has selectable text but the converter cannot interpret its layout, extract a spreadsheet with Adobe Acrobat using Export a PDF → Spreadsheet or an equivalent local tool. Clean the resulting CSV or XLSX so each row has one transaction, then use a QIF-capable desktop converter such as ProperSoft Bank2QIF to map the columns and produce QIF. CSV has no universal financial schema, so map the date, payee, memo, amount, debit, credit, account, and category fields explicitly.

For a scanned PDF, run OCR before conversion or use software with built-in OCR. OCR can change decimal points, minus signs, dates, digits, and payee characters; inspect every amount and do not rely solely on the ending balance.

Compatibility and data checks

Wrapped descriptions, continuation pages, running balances, subtotal rows, fees, refunds, pending transactions, transfers, and opening or closing balance lines can produce missing or duplicate entries. Balance lines are not transactions and should not be imported as such.

Do not import the same period from both a PDF-derived QIF and an institution-provided QIF, QFX, or OFX unless duplicate handling has been verified. QIF date interpretation varies, so confirm month/day/year versus day/month/year. Categories, classes, check numbers, splits, cleared flags, and transfer destinations may require manual correction.

Online tools are suitable mainly for non-sensitive PDFs or for intermediate spreadsheet extraction. Adobe Acrobat online can export a PDF to Excel, but it does not create a financial QIF file by itself. Before uploading a statement, check encryption, retention, deletion, and data-use policies; a local converter keeps account data on the computer. Remove unrelated pages and redact account numbers only if the converter does not need them for recognition.