Convert a bank statement to QFX
Upload the PDF statement, check the rows, and download a .qfx file, the version of OFX that Quicken imports. Use it for months your bank no longer lets you download, or for a bank that only gives you PDF statements.
How to convert a PDF bank statement to QFX
- 1.Download the statement as a PDF from your online banking.
- 2.Drop the PDF into the converter on this page. Enter the password if the PDF asks for one.
- 3.Check the rows in the preview against the PDF. The first 5 pages are free.
- 4.Choose QFX, download the file and import it into Quicken.
What the QFX file looks like
The same sample statement in each format. Switch to compare.
Excel
A standard .xlsx workbook with one row per transaction.
Best for: Analysis, pivot tables, loan and tax paperwork.
Bank statement to Excelharbor-pine-sep-2026.xlsx
Sample
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Date | Description | Amount | Balance |
| 2 | 2026-09-01 | Card purchase · Adobe Creative Cloud | −59.99 | 8,352.38 |
| 3 | 2026-09-02 | Stripe transfer · ST-7Q2KX | 2,486.50 | 10,838.88 |
| 4 | 2026-09-03 | ACH debit · Gusto payroll | −4,120.00 | 6,718.88 |
| 5 | 2026-09-05 | Check 1043 | −1,850.00 | 4,868.88 |
| 6 | 2026-09-09 | Card purchase · AWS EMEA | −218.77 | 4,650.11 |
| 7 | 2026-09-12 | Deposit · Mobile check | 1,200.00 | 5,850.11 |
CSV
Plain comma-separated rows any tool can import.
Best for: Importing into accounting software, budgeting apps and databases.
Bank statement to CSVharbor-pine-sep-2026.csv
Sample
Date,Description,Amount,Balance
2026-09-01,Card purchase · Adobe Creative Cloud,-59.99,8352.38
2026-09-02,Stripe transfer · ST-7Q2KX,2486.50,10838.88
2026-09-03,ACH debit · Gusto payroll,-4120.00,6718.88
2026-09-05,Check 1043,-1850.00,4868.88
2026-09-09,Card purchase · AWS EMEA,-218.77,4650.11
2026-09-12,Deposit · Mobile check,1200.00,5850.11Google Sheets
Sent straight to a sheet in your Google Drive.
Best for: Sharing with a bookkeeper or working from any browser.
Bank statement to Google SheetsHarbor & Pine · Sep 2026 (Google Sheets)
Sample
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Date | Description | Amount | Balance |
| 2 | 2026-09-01 | Card purchase · Adobe Creative Cloud | −59.99 | 8,352.38 |
| 3 | 2026-09-02 | Stripe transfer · ST-7Q2KX | 2,486.50 | 10,838.88 |
| 4 | 2026-09-03 | ACH debit · Gusto payroll | −4,120.00 | 6,718.88 |
| 5 | 2026-09-05 | Check 1043 | −1,850.00 | 4,868.88 |
| 6 | 2026-09-09 | Card purchase · AWS EMEA | −218.77 | 4,650.11 |
| 7 | 2026-09-12 | Deposit · Mobile check | 1,200.00 | 5,850.11 |
OFX
Open Financial Exchange, the bank-feed format.
Best for: QuickBooks, Xero, Sage and most accounting software.
Bank statement to OFXharbor-pine-sep-2026.ofx
Sample
OFXHEADER:100
DATA:OFXSGML
VERSION:102
…
<OFX>
<BANKTRANLIST>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260901
<TRNAMT>-59.99
<FITID>02d4e626…
<NAME>Card purchase · Adobe Creative C
</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20260902
<TRNAMT>2486.50
<FITID>755d799c…
<NAME>Stripe transfer · ST-7Q2KX
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260903
<TRNAMT>-4120.00
<FITID>c277c427…
<NAME>ACH debit · Gusto payroll
</STMTTRN>
</BANKTRANLIST>
<LEDGERBAL><BALAMT>5850.11
</OFX>harbor-pine-sep-2026.qfx
Sample
OFXHEADER:100
DATA:OFXSGML
VERSION:102
…
<OFX>
<SIGNONMSGSRSV1> … <INTU.BID>3000 …
<BANKTRANLIST>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260901
<TRNAMT>-59.99
<FITID>02d4e626…
<NAME>Card purchase · Adobe Creative C
</STMTTRN>
<STMTTRN>
<TRNTYPE>CREDIT
<DTPOSTED>20260902
<TRNAMT>2486.50
<FITID>755d799c…
<NAME>Stripe transfer · ST-7Q2KX
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT
<DTPOSTED>20260903
<TRNAMT>-4120.00
<FITID>c277c427…
<NAME>ACH debit · Gusto payroll
</STMTTRN>
</BANKTRANLIST>
<LEDGERBAL><BALAMT>5850.11
</OFX>Why convert to QFX
- Made for Quicken
- QFX is OFX with the Intuit sign-on field Quicken looks for. The transactions inside are the same as in the OFX file.
- Older months too
- Banks offer QFX downloads for recent activity only. BankConv works from the monthly PDF statements, so older periods are covered.
- Same IDs every time
- Each transaction carries an ID that stays the same if you export the same statement again, which helps Quicken spot rows it already has.
Before you import a QFX file into Quicken
A few checks save you from cleaning up a Quicken register afterwards.
- 1Back up your Quicken data file first, so you can undo the import if it lands in the wrong account.
- 2Import into the account the statement belongs to, and only the dates that are not already in the register.
- 3In Quicken for Windows, the import is under File → File Import → Web Connect (.QFX) File. On a Mac, use File → Import → Bank or Brokerage File.
- 4Accept or match the downloaded transactions in the review list, then compare the register balance with the closing balance on the PDF.
- 5If your software is not Quicken, download OFX instead: it is the same data without the Intuit field.
Popular banks
All banksOther formats
- Bank statement to Excel · Analysis, pivot tables, loan and tax paperwork.
- Bank statement to CSV · Importing into accounting software, budgeting apps and databases.
- Bank statement to Google Sheets · Sharing with a bookkeeper or working from any browser.
- Bank statement to OFX · QuickBooks, Xero, Sage and most accounting software.
QFX questions
What is the difference between QFX and OFX?
A QFX file is an OFX file with an extra Intuit field in the sign-on block that Quicken reads. The account and transaction data are identical, so pick QFX for Quicken and OFX for everything else.
Is it free to convert a bank statement to QFX?
Yes, for short statements. The first 5 pages convert free with no signup, and a free account lets you download the file and adds 5 free pages a day. Longer statements cost from $2.99 each ($2.99 for up to 10 pages, then $0.20 a page), or from $19.00 a month on a yearly plan.
Can QuickBooks import a QFX file?
QuickBooks Online accepts QFX through Upload from file, as it does OFX and CSV. QuickBooks Desktop needs a .QBO Web Connect file, which BankConv does not produce.
What if BankConv says it cannot make a QFX file?
That happens when it cannot tell which column holds the dates or the amounts, or which currency the statement uses. The message says which. Download CSV instead, which always works.
Your statement's data
Deleted after 24 hours
Your PDF and its converted files are deleted automatically. Account owners can choose 48 or 72 hours instead.
Read only to extract transactions
Your statement is read (with OCR for scans) to pull out the transaction rows you download.
Encrypted in transit
Uploads and downloads use HTTPS (TLS).
Passwords never stored
The password of a protected PDF is used once to open the file.
No bank login
BankConv works from the PDF you download, never from a connection to your bank.