QIF files

Solid Accounting doesn't import QIF files today. The Import Transactions… wizard reads CSV, tab-delimited, OFX, QFX, .qbo, IIF, and PDF statements — .qif isn't on that list, and there is no QIF export either.

QIF (Quicken Interchange Format) is a 1990s line-based format that Quicken itself stopped accepting for bank downloads years ago. Almost every bank that offers QIF also offers something better.

What to use instead

  1. Download OFX or QFX. On your bank's download page, look for "OFX", "QFX", "Quicken", "Microsoft Money", or "QuickBooks® Web Connect". These carry a unique ID per transaction, so re-imports are safe. See OFX / QFX format.

  2. Download CSV. Nearly every bank offers "CSV" or "Excel/spreadsheet". See CSV format.

  3. Import the PDF statement. Import Transactions… reads bank and credit-card PDF statements directly, and checks the opening and closing balances when it can read them.

  4. Convert the QIF file to CSV if it's all you have (for example, an old Quicken export). Each QIF transaction is a group of lines ending in ^; the ones you need are D (date), T (amount), P (payee), and M (memo):

    !Type:Bank
    D04/15/2026
    T-642.18
    PLinode
    MApril hosting
    ^
    

    Put those four values in the columns of a spreadsheet — one row per transaction — save it as CSV, and import that. QIF split lines (S, $) and investment sections (!Type:Invst) don't convert cleanly; enter those by hand.

Related: Import & Export overview · OFX / QFX format · CSV format

Updated October 31, 2026
Report a problem with this page
Was this helpful?

We use this to prioritize which docs to improve. No tracking, no email follow-up.