QFX file: what it is, and how to make one from a PDF statement
A QFX file is how Quicken takes in bank transactions. Banks offer it as a download; when all you have is the PDF statement, convert the PDF to QFX and import it the same way.
Updated Oct 21, 2026 · 6 min read
The short answer: a QFX file is a bank statement in the format Quicken imports (OFX with an Intuit header). Quicken cannot read a PDF, so drop the statement in the converter below, download Quicken (.qfx), and in Quicken for Windows choose File, File Import, Web Connect (.QFX) File. On a Mac it is File, Import, Bank or Brokerage File (OFX, QFX).
Convert a statement PDF to QFX
Drop a bank or credit card statement, in any language, digital or scanned. Sheetfold reads every row, checks it against the balances your bank printed, and offers the .qfx file first. 5 free pages a day with an account.
What is inside a QFX file
QFX stands for Quicken Financial Exchange. It is OFX, the format banks use for transaction downloads, plus a few lines that tell Quicken which bank the file comes from. Quicken calls these Web Connect files. The file is plain text: an account, a list of transactions, and the balance at the end. Here is one, made from three rows of an example statement:
| Date | Description | Amount | Balance |
|---|---|---|---|
| Beginning balance | 4,210.00 | ||
| Oct 14, 2026 | Oct 14, 2026RENT OCTOBER | −1,450.00 | 2,760.00 |
| Oct 15, 2026 | Oct 15, 2026ACME CORP PAYMENT | +3,200.00 | 5,960.00 |
| Oct 20, 2026 | Oct 20, 2026OFFICE DEPOT #1123 | −312.40 | 5,647.60 |
| Ending balance | 5,647.60 |
- The Intuit bank id: the line that makes this a QFX file rather than plain OFX. Quicken checks it before it imports.
- Money out is negative and money in positive.
- An id for each transaction, built from the statement itself. Export the same statement again and the ids stay the same, so a second import does not add the rows twice.
- The ending balance, as printed on the statement.
Why Quicken needs QFX, not PDF, QIF or CSV
Quicken lists other formats, but for bank and card accounts each one has a catch:
| Quicken for Windows | Quicken for Mac | |
|---|---|---|
| PDF statement | Cannot be imported | Cannot be imported |
| QIF | Depends on the version: Quicken’s pages say both “not for checking, savings or credit cards” and “now any account type” | Only to start a new data file |
| CSV | Only in Quicken’s own column layout; never matched, so importing twice adds every row twice | Mint.com layout only, and only into a new account |
| QFX What Sheetfold makes | File Import, Web Connect: into an existing account | Import, Bank or Brokerage File: into an existing account |
PDF statement
- Quicken for Windows
- Cannot be imported
- Quicken for Mac
- Cannot be imported
QIF
- Quicken for Windows
- Depends on the version: Quicken’s pages say both “not for checking, savings or credit cards” and “now any account type”
- Quicken for Mac
- Only to start a new data file
CSV
- Quicken for Windows
- Only in Quicken’s own column layout; never matched, so importing twice adds every row twice
- Quicken for Mac
- Mint.com layout only, and only into a new account
QFXWhat Sheetfold makes
- Quicken for Windows
- File Import, Web Connect: into an existing account
- Quicken for Mac
- Import, Bank or Brokerage File: into an existing account
Import a QFX file into Quicken for Windows
- Choose File, File Import, Web Connect (.QFX) File.
- Select the .qfx file.
- Link it to the account the statement belongs to, or create a new account. A card statement goes into a credit card account.
- Review the downloaded transactions in the register and accept them.
Import a QFX file into Quicken for Mac
- Choose File, Import, Bank or Brokerage File (OFX, QFX).
- Select the .qfx file.
- On Choose Your Accounts, pick the account to import into.
Turning a PDF into a QFX file you can trust
A QFX file is only as good as the rows in it. Typing a statement by hand, or copying it out of the PDF, is where a digit goes missing or a refund turns into a charge, and Quicken will import whatever the file says. Sheetfold reads each page, then adds the rows between every two balances the bank printed; the file is ready when those sums match to the cent. Rows that do not add up are flagged with the page beside them before you download, so a mistake never reaches your register.
It works for statements from any bank in any language, scanned or digital, and for credit cards, which have no running balance: there the statement’s own totals (payments, purchases, new balance) are the check.
If Quicken will not import the QFX
- Expired subscription or old version: Quicken refuses Web Connect files when the subscription has lapsed or the version is no longer supported. Renew or update, then import again.
- “Unable to verify financial institution information”: Quicken found no bank it recognizes in the file. Sheetfold’s QFX files carry an Intuit bank id; files from other tools sometimes do not.
- Charges arrive as deposits: the file went into the wrong kind of account. Import a card statement into a credit card account.
- A bank that dropped QFX downloads: download the statement as a PDF instead and convert it; the result imports the same way.
Sources, checked 21 October 2026: How do I import data into Quicken for Windows, Web Connect troubleshooting, Import transactions from a CSV file (Windows), Importing data from a QIF file, Import a CSV file into Quicken for Mac, Converting your data to Quicken for Mac, Unable to verify financial institution information.
Questions
- What is a QFX file?
- A bank statement in OFX format with an Intuit header, called a Web Connect file. Quicken imports it; inside are the account, every transaction with its date, amount and description, and the ending balance.
- How do I open a QFX file without Quicken?
- It is plain text: Notepad or any text editor shows the transactions. GnuCash, Moneydance, Banktivity, YNAB, Xero and Wave also import QFX files, since the data inside is OFX.
- Can Quicken import a PDF bank statement?
- No. Quicken for Windows says it cannot import PDF, Excel or plain OFX files. Convert the PDF to a QFX file first, then import that.
- Can I convert a PDF to QFX for free?
- Sheetfold converts 5 pages a day free with an account (1 without one), with the QFX download included.
- Why does Quicken say it cannot verify the financial institution?
- Quicken checks the bank named inside a QFX file, and it also refuses Web Connect files when the subscription has expired or the Quicken version is no longer supported. Renew or update Quicken first; Sheetfold’s QFX files name a bank Intuit lists.
Try it on your own statement
Drop a PDF here and Sheetfold reads it, then checks every row against the balances your bank printed. A free account converts 5 pages a day.
Keep reading
All guides- OFX file: what it is, where it goes, and how to make one from a PDF What an OFX file is, which accounting and budgeting apps import it (Xero, Sage, FreeAgent, Wave, YNAB, MYOB...), and how to turn a PDF statement into one.
- QIF file: what it is, who still reads it, and how to make one from a PDF What a QIF file is, which programs still import it (GnuCash, Moneydance, Banktivity, MYOB, FreeAgent...), and how to turn a PDF bank statement into one.