Import a Bank Statement Into Quicken (QFX)

Why Quicken won't read your PDF statement

Quicken has no way to pull transactions out of a PDF. It imports Web Connect (.qfx) files, QIF files, and CSV, and all three expect structured rows rather than a printed statement. When a bank only gives you a PDF, or an old account no longer connects for automatic download, the data is stranded on the page. Landlords tracking a property account, the self-employed separating business from personal, and anyone reconstructing a closed account all hit this. Converting the PDF to a QFX solves it: the file follows the Web Connect standard Quicken already understands, so the transactions land in the register ready to categorize.

The QFX Web Connect import path in Quicken

The menu is straightforward once you know it. In Quicken for Windows choose File, then File Import, then Web Connect File, and browse to the .qfx you exported. Quicken reads the file and asks whether to create a new account or link to an existing one; pick Link and choose the matching account so the transactions post to the right register. Quicken then imports every dated transaction. Open the account register, review the new entries, assign or confirm categories, and delete any duplicates that overlap what was already there. Because a QFX carries no categories of its own, Quicken applies your renaming and memorized-payee rules as it imports.

Disconnect online download before a QFX import

A common snag is an account still set up for direct online download. Quicken needs that account disconnected from automatic downloads before it will accept a Web Connect file, then you reconnect it afterward if you still want the live feed. QFX import also needs an internet connection, because Quicken verifies the bank's label online as it reads the file. If an import stalls or is refused, check that the account is deactivated for online services and that you are connected, then run File, File Import, Web Connect File again. This is the same pattern that lets a converted statement fill a month the automatic feed missed.

QFX vs QIF: which format for Quicken?

Both import into Quicken for Windows, and the trade-off is categories versus coverage. A QFX Web Connect file is required for the download-style account types, checking, savings, credit card, brokerage, and retirement, but it carries no categories, so Quicken assigns them with rules after import. A QIF file does include categories and imports fully offline with no bank-label check, which makes it handy for older or manual accounts, but QIF will not work through the Web Connect path. For a statement you are converting, QFX is the closest match to how Quicken expects bank data to arrive.

Duplicates, review, and privacy

After a QFX import, scan the register for duplicates where the converted month overlaps transactions already present, and delete the extras. Every transaction is reviewable in the converter before export too, so a mis-read payee or amount is fixed once, up front, rather than in the register later. Because bank statements hold sensitive financial detail, files are processed to build the QFX and then deleted automatically, with nothing retained on a server afterward. For anyone converting statements for a client or a rental, that automatic deletion keeps account data from lingering in a third-party tool.

Frequently Asked Questions