To import a QFX file into Quicken for Windows, open File, then File Import, then Web Connect File, and choose the download. Link it to the account you already keep instead of creating a new one. Then review the lines before accepting them. Most duplicates come from date ranges that overlap a previous download or hand-typed entries.
Where the QFX file import lives in Quicken for Windows
The QFX file import sits under the File menu in Quicken for Windows, as File Import and then Web Connect File. Quicken's article on importing data into Quicken for Windows gives that path and explains that a bank's Quicken download, the file ending in .QFX, is what Quicken calls a Web Connect file.
The name matters because the import menu lists several file types, and only one of them reads a QFX. Picking the QIF option or the CSV option for a QFX download gets you an error or an empty import. The same Quicken article also lists what this route will not take: Excel workbooks, QuickBooks files, PDFs and plain OFX files.
Step list for one QFX import
- Back up your Quicken data file. File, then Backup and Restore, does it in a minute.
- Log in to your bank and download the account activity in the Quicken format. Note the date range you chose.
- In Quicken, open File, then File Import, then Web Connect File.
- Browse to the .qfx file, usually in your Downloads folder, and select it.
- When Quicken asks which account the data belongs to, choose Link and pick the existing account.
- Open the account register and work through the downloaded lines before accepting them.
Double-clicking the downloaded file can also start the import, because Windows normally hands .qfx files to Quicken. If double-clicking opens a different program, the file association is wrong. Quicken's Web Connect troubleshooting page shows how to reset it under the default apps settings in Windows 10 and 11, and confirms the menu route works either way.
Linking a QFX download to an existing Quicken account
Linking tells Quicken that the transactions in a QFX download belong to an account you already track. At the account prompt, choose Link and select the account name instead of letting Quicken create a new one. The Quicken import article describes this exact choice: name a new account, or pick Link and the existing account.
Creating a new account by mistake is the most common first-import slip. The transactions land in a fresh account with an opening balance that does not match your books, and the real account carries on without them. You then have two half-accounts to merge by hand.
A few habits keep the link right:
- Match the account type. A checking download goes to a checking account, a card download to a credit card account. Quicken treats balances on the two types in opposite ways.
- Read the last four digits. The QFX carries an account number, often masked. Compare it with the account you are linking before you confirm.
- Expect the prompt only once. After the first import, Quicken remembers the link for that bank account, so later files from the same account go straight in.
If you hold two accounts at the same bank, download each one separately. A file that holds several accounts can be linked one account at a time, but separate files are easier to check.
How does Quicken tell a repeated QFX transaction from a new one?
Each line in a QFX file carries a transaction ID that the bank assigns. The OFX 2.2 specification from the Financial Data Exchange, the standard QFX is built on, says this ID, called FITID, exists mainly so the receiving program can detect duplicate downloads. It must be unique within one account.
In plain terms, the bank stamps every transaction with a code, and the code should be the same every time that transaction is downloaded. A program reading the file can then skip a line whose code it has already stored for that account. This is why two downloads covering the same week usually do not double up.
The ID does not help in three situations:
- Hand-typed entries. A transaction you typed into the register yourself has no bank ID. When the same payment arrives in a QFX, Quicken can only offer to match it by amount and date, and that match is yours to confirm.
- A changed bank system. If the bank moves to new software, it may issue new IDs for old transactions. A re-download of last month then looks entirely new.
- A different account link. The ID only needs to be unique inside one account. Linking a file to the wrong account defeats the check completely.
The FITID is also why you should never edit transaction lines inside a QFX by hand. Changing or deleting the ID turns a known transaction into a stranger.
Overlapping QFX date ranges and the duplicates they cause
Overlapping date ranges cause duplicates when the second QFX file repeats days that are already in Quicken and the repeat is not caught. The safest plan is to start each download the day after the last transaction already in the register, rather than at a round date like the first of the month.
A worked example with two downloads
The example below uses made-up dates and amounts for one checking account.
| Download | Date range chosen | Lines in file | What happens in Quicken |
|---|---|---|---|
| First QFX | March 1 to March 20 | 34 | All 34 are new and accepted |
| Hand entry | March 22 | 1 | You type a $65.00 check into the register |
| Second QFX, careless | March 15 to March 31 | 29 | 11 lines repeat March 15 to 20; the $65.00 check also arrives |
| Second QFX, planned | March 21 to March 31 | 18 | 18 new lines; the $65.00 check is offered as a match |
With the careless range, most of the 11 repeated lines should be recognised by their IDs, but any whose ID changed get through. The check you typed by hand needs a match either way. With the planned range, the only decision is the one match.
Picking the next start date
Before each download, open the register and sort by date. Find the newest transaction that came from the bank, not one you typed. Start the next download the day after it.
Pending card transactions complicate this. Some banks leave a purchase out of the download until it posts, and the posted date can fall a day or two before your new start date. If a purchase seems to be missing, widen the range by two or three days and let the ID check catch the overlap, then delete any true repeat by hand.
Reviewing QFX transactions before they reach the Quicken register
The review step is where you catch a wrong link, a missed match or a duplicate before it affects your balance. Depending on your download preferences, Quicken either adds QFX transactions to the register right away or holds them for you to review, as the Quicken import article notes. Holding them for review is the safer setting.
Turn on the review if you have it off. In the downloaded transactions list, check each line for one of these:
- New lines that should be new. Scan the dates against the range you downloaded.
- Matches against entries you typed. Confirm the payee and amount, not just the amount.
- Lines that look familiar. If a payment already shows in the register as cleared, a second copy is a duplicate. Delete it rather than accept it.
After accepting, compare the register's ending balance with the balance the bank shows for the last day of your download. If the two agree, the import is complete. If they differ by the amount of one transaction, look for a duplicate or a missing pending item first.
Undoing a large mistaken import is harder than preventing it. This is where the backup from the first step pays for itself: restore it and import again with the right account or dates.
When should you skip the QFX file and use another route?
Skip the QFX route when your bank offers no Quicken download, when the file came from conversion software rather than the bank, or when you need history older than the bank will export. Quicken's Web Connect troubleshooting page says Quicken does not support QFX files made by third-party converters, so those fail without help from Quicken support.
That leaves a few alternatives, each with its own guide:
- The bank gives only a spreadsheet. Quicken handles spreadsheet data through a separate import, covered in importing a CSV file into Quicken, including the columns to tidy first.
- The months you need exist only as PDF statements. Getting a PDF bank statement into Quicken compares retyping, CSV and other routes for older periods.
- The money moved through PayPal. A bank QFX only shows the PayPal transfers, not the sales and fees behind them. If your books live in QuickBooks Online rather than Quicken, importing PayPal transactions into QuickBooks Online shows how to bring in that side.
The same troubleshooting page lists two other dead ends. A QFX can no longer be authorised when the bank has stopped supporting Web Connect, and Quicken will not download a Web Connect file when your subscription has lapsed or your version is unsupported. In both cases, fixing the file does nothing; the bank or the subscription has to change.
If your next step is QuickBooks rather than Quicken, SimpleBankConvert is being built to turn PDF statements into CSV or QBO files for QuickBooks Online and CSV files for Xero. The homepage explains what it does and when accounts open.