Convert a PDF Bank Statement to a QIF File

What a QIF file is

QIF, the Quicken Interchange Format, is an open, plain-text specification for financial data, saved with a .qif extension. It is one of the oldest bank-file formats and predates the structured OFX standard that replaced it in most modern software. A QIF file lists each transaction's date, amount, payee, and, unusually, its category, in a simple text layout. When your bank hands you a PDF rather than a QIF download, the transactions are the same, they are just locked in a printed page rather than the text file your older or open-source finance app expects. Converting the PDF to a QIF turns those pages into an importable file.

Which software imports QIF

QIF remains the bridge into a specific set of programs. GnuCash imports it, and it is the standard way to move data into GnuCash from Quicken. Older versions of Quicken for Windows read QIF, as do MoneyDance, Money Manager Ex, Banktivity, YNAB, and AceMoney. If you keep your books in one of these, QIF is often the format that works when a bank feed is unavailable or the account is not supported. Note that QuickBooks is not on this list for transactions: it uses QBO Web Connect files, so a QIF is the wrong choice there.

QIF's one real advantage: categories

The reason to pick QIF over a more modern format is categories. QIF is the only common bank format that carries category and tag data, so when the goal is to bring in transactions already assigned to expense and income categories, rather than a bare list you have to categorize afterward, QIF is the format that preserves them. That matters most when you are migrating a categorized history between programs, or when your app relies on QIF categories to route transactions. For a plain statement with no categorization, the advantage disappears and a structured format is usually better.

QIF's limits: dates and duplicates

QIF is worth using with eyes open. It has no required date format, so different banks wrote dates differently and an ambiguous MM/DD versus DD/MM can post transactions to the wrong day or fail the import entirely; most importers ask you to confirm the date format for exactly this reason. QIF also carries no transaction identifiers, so unlike OFX or QFX it offers no way to detect and skip duplicates, and many importers cannot reconcile QIF transactions against the current account balance. Because of these gaps, a converter that outputs a consistent date format and clean fields removes the most common QIF import headaches.

How to convert a PDF to QIF, and privacy

Start by uploading the PDF, text or scanned; image-only pages are read with OCR. The parser extracts each transaction's date, description, and amount and keeps debits and credits aligned, and every field is reviewable so you can fix a misread before export. Export as QIF, then import it through your software, for example in GnuCash by choosing File, Import, and Import QIF, confirming the date format when prompted. Because bank statements are sensitive, files are processed to build the QIF and then deleted automatically, with nothing retained on a server afterward, which keeps account data from lingering when you convert a statement for yourself or a client.

Frequently Asked Questions