Import bank statements into Quicken

Why not a QFX file?

Because Quicken rules it out. Its Web Connect troubleshooting article says Quicken does not support QFX files created by third-party conversion software, and gives PDF-to-QFX conversion as the example.

The same article explains the mechanism. Quicken validates a Web Connect file through its online services before importing it, a file from a financial institution that no longer supports Web Connect in Quicken cannot be authorized, and with an expired subscription or an unsupported version of Quicken a Web Connect file cannot be downloaded at all. Web Connect is built around a file that comes from the bank itself.

So for Quicken, take the QIF or the CSV. Every conversion still offers a QFX download, for other software that reads Quicken's dialect.

Quicken Classic for Windows: QIF into an existing account

1. Convert the PDF. Upload the statement and download the review workbook. Fix any row marked for review against the PDF, check the Opening balance and the Account type on the Statement details sheet, upload the workbook and download the QIF. Pages are free every day and no account is needed. Convert a statement.
2. Back up your Quicken data file. Quicken lists this as the first step of any QIF import.
3. Make sure the account exists. A QIF import goes into an account already in your data file, so create it first if it is missing.
4. Import. Choose File, then File Import, then QIF File. Browse to the .qif file, pick the account under Quicken account to import into, select Transactions under Include in import, then Next, and follow the prompts.
5. Check the register. Open the account and find a transaction dated after the 12th of its month. If its month is right, every date in the file is.

Which accounts take a QIF import. Quicken's documentation gives two answers. Its Windows help pages say a QIF import can go into any account type, checking, savings and credit card included, as long as the account already exists. Its support article on importing data, updated June 5, 2026, says QIF import is for asset, liability and cash accounts, and not for checking, savings or credit card accounts. The import dialog settles it for your copy of Quicken: the Quicken account to import into list shows only accounts that can take a QIF import. If the account you want is not in that list, take the CSV route below.

• The file names no account, so the rows go into the account you pick in the dialog.
• Card statements. Set Account type to Credit card before you upload the workbook, so the file starts with !Type:CCard, and import it into a credit card account. Credit card statements.
• Dates. The QIF puts the month first for a statement in US dollars and the day first for every other currency. If Quicken reads the dates the other way round, set Date order in QIF and CSV files on the Statement details sheet, upload the workbook again and download a new QIF. Uploading again uses no pages.
• Import each statement once. A QIF file carries no transaction identifier, so importing it twice adds every row twice. To bring in a corrected file, delete the earlier import first.

Quicken Classic for Mac

On a Mac, a converted statement arrives somewhere new either way. Quicken for Mac imports a QIF file only as the start of a new data file, through File, New and Start from a .QIF file exported from another application; its help says incremental QIF import into an existing file is not supported. Its CSV import, listed as Mint.com File (CSV) under File, Import, reads any CSV in the layout its help page shows, and always creates a new account named after the file.

• For history in the data file you already use, take the CSV. Name the file after the account you want to see in Quicken before you import it; the account can be renamed or given another type afterwards in its Account Settings.
• Build it in the Mac layout. Quicken's Mac help page shows the columns. Date, Amount and Account must be filled in on every row, the FI Payee column must be present though it is not imported, amounts can carry a sign but no dollar signs or commas, and Debit/Credit holds debit or credit in lower case. The CSV for import from the same workbook supplies the date, the description and the signed amount as plain decimals.
• For a new data file that holds the old history, take the QIF.

Why the balance check matters more in Quicken

Neither file Quicken accepts from a converter can tell it what the register already holds. A QIF carries no transaction identifier and a CSV import is not matched against existing transactions, so whatever goes in stays in until someone finds it by hand. A misread amount is one cell in the workbook, and an afternoon in a register three months later.

So every conversion is checked before you download anything: the opening balance plus each row has to reach the running balance the bank printed beside it. A row that does not is marked in the workbook's Check column with the difference, which is usually enough to spot the digit, and the files you download carry the rows exactly as you confirmed them. How the check works.