Sheetfold

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.

or drop it here

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:

Example Bank · ••••6789 Example
DateDescriptionAmountBalance
Beginning balance4,210.00
Oct 14, 2026Oct 14, 2026RENT OCTOBER−1,450.002,760.00
Oct 15, 2026Oct 15, 2026ACME CORP PAYMENT+3,200.005,960.00
Oct 20, 2026Oct 20, 2026OFFICE DEPOT #1123−312.405,647.60
Ending balance5,647.60
becomes statement.qfx
OFXHEADER:100
DATA:OFXSGML
</FI>
1<INTU.BID>3000
</SONRS>
<DTPOSTED>20261014120000
2<TRNAMT>-1450.00
3<FITID>202610148da6619482b6e9a0
<NAME>RENT OCTOBER
<LEDGERBAL>
4<BALAMT>5647.60
<DTASOF>20261020120000
  1. The Intuit bank id: the line that makes this a QFX file rather than plain OFX. Quicken checks it before it imports.
  2. Money out is negative and money in positive.
  3. 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.
  4. The ending balance, as printed on the statement.
An invented statement and the .qfx file made from it by the same code as a real download. A credit card statement becomes a credit card file.

Why Quicken needs QFX, not PDF, QIF or CSV

Quicken lists other formats, but for bank and card accounts each one has a catch:

  • 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
As described on Quicken’s support pages on 21 October 2026.

Import a QFX file into Quicken for Windows

  1. Choose File, File Import, Web Connect (.QFX) File.
  2. Select the .qfx file.
  3. Link it to the account the statement belongs to, or create a new account. A card statement goes into a credit card account.
  4. Review the downloaded transactions in the register and accept them.

Import a QFX file into Quicken for Mac

  1. Choose File, Import, Bank or Brokerage File (OFX, QFX).
  2. Select the .qfx file.
  3. 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.

or drop it here

All guides