Import a PDF bank statement into Quicken
9 min read
Quick answer
A bank PDF is a document, not a transaction file, and Quicken does not import PDFs. QuickBankConvert turns the PDF into a CSV (free with a free account) or a QIF (on the Plus plan), and you check every row before it reaches Quicken. For a checking, savings or credit card account in Quicken for Windows, use the CSV: Quicken's own help says QIF import is not available for those accounts. Quicken for Mac imports a CSV only as a new account. On Plus there is also a QFX for Quicken's Web Connect import; it carries a placeholder bank ID, which Quicken checks, so it may be refused (see PDF to QFX).
Drop your bank statement here
PDF or OFX · Max 4.4 MB
Uploaded over an encrypted connection. We never ask for your bank login. Privacy
Preview free with no account. Free account to download.
Which file for which Quicken
| File | What it is | Quicken for Windows | Quicken for Mac | Our plan |
|---|---|---|---|---|
| CSV | A plain table. Quicken expects its own column order. | Imports into banking accounts through From (.CSV) File. | Imports through Mint.com File (CSV), always as a new account. | Free account |
| QIF | Quicken's older text format. No transaction IDs, no date-format marker. | Only into asset, liability and cash accounts. | No import into an existing account. | Plus ($29 a month) and the plans above it |
| QFX | Web Connect: Quicken's variant of OFX. | The file type Web Connect reads. | Read through the bank-file import. | Plus ($29 a month) and the plans above it; Quicken checks the bank ID, see PDF to QFX |
The QIF limits are Quicken's, from How do I import data into Quicken for Windows? (updated 5 June 2026): "QIF import is available only for asset and liability accounts (including house and vehicle) and cash accounts", and "QIF import isn't available for checking, savings, or credit card accounts, or for 401(k) or any other brokerage accounts." The same page says Quicken "cannot import Excel (.xls), QuickBooks, PDF, or OFX files." So the CSV is the route for most bank statements, and it is the free one.
The step-by-step guide to Quicken's own bank downloads (QFX and the rest) is in our article How to import bank statements into Quicken. This page covers the case where all you have is the PDF.
Step 1: turn the PDF into a file Quicken reads
- Download the statement PDF from your bank's website. Use the PDF the bank generates, not a scan or a photo of paper: a native PDF contains real text and converts more accurately.
- Upload it to the converter. The file goes to our servers over HTTPS and is parsed there. If the PDF is password-protected you are asked for the password.
- Check the preview. Compare the first and last transactions and the closing balance with the statement. A wrong row is far easier to fix before it is in Quicken.
- Download the file. CSV and Excel need a free account. QIF needs Plus.
Page limits per statement: 10 on Free, 50 on Plus, 100 on Pro and Business. Files up to 4.4 MB.
Prepare the CSV for Quicken for Windows
Quicken for Windows reads a CSV only in its own layout. From Quicken's Import transactions from .CSV file (read on 20 October 2026), the first seven columns must be in this order:
| Column | Quicken says | What to put there from our file |
|---|---|---|
| Date | Required, mm/dd/yyyy | Our Date, reformatted |
| Payee | Required | Our Description |
| FI Payee | Optional | Leave blank, or copy the Description |
| Amount | Required | Our Amount |
| Debit/Credit | Optional | Leave blank: our amounts are already signed |
| Category | Optional | Our Category, or blank to categorise in Quicken |
| Account | Required | The name of the Quicken account, on every row |
Tag, Memo and Chknum may follow as optional columns. Our CSV has five columns, Date, Description, Category, Amount, Balance, so in a spreadsheet before importing:
- Rename Description to Payee and move the columns into the order above.
- Insert FI Payee, Debit/Credit and Account columns. Fill Account with the exact name of the Quicken account on every row.
- Delete the Balance column. Quicken's layout has no place for it.
- Change the dates. Ours are written YYYY-MM-DD; Quicken asks for mm/dd/yyyy. Format the column as a date in that pattern, then save as CSV.
- Check the sign. Money out is negative and money in is positive in our file. For a credit card account, confirm on the first few rows that purchases arrive as spending.
Import into Quicken for Windows
Quicken's path, from the same article: File, then File Import, then Banking Transactions, then From (.CSV) File. Select the prepared file and follow the prompts.
Three limits Quicken states for this import, which matter for statement data:
- "CSV imports do not check for or match existing transactions."
- "The import process does not detect or create transfers automatically."
- "Reimporting the same file will create duplicates."
So import each statement period once, and after importing, compare the account balance in Quicken with the statement's closing balance. Back up your Quicken file before the first import.
Import into Quicken for Mac
From Quicken's How do I import a CSV file into Quicken for Mac? (updated 28 January 2026): choose File, then Import, then Mint.com File (CSV). The columns Quicken for Mac expects, in order, are Date, Payee, Category, Amount, Debit/Credit, Account, FI Payee, Notes; Date, Amount and Account must contain values, amounts are signed numbers without dollar signs or commas, and the Debit/Credit column takes the lowercase words debit or credit.
The same article is plain about the main limit: "Importing a .CSV file will always create a new account with the same name as the imported file. It is not possible to link imported transactions to an existing account." Name the CSV file after the account you want, import it, and work from the new account.
Quicken for Mac's QIF import, as described in Converting Your Data, is for starting a new data file from another program (File, New, "Start from a .QIF file exported from another application"), not for adding a month of transactions to an account you already have.
QIF: where it fits
QIF is offered on Plus for the accounts and programs that still take it. In Quicken for Windows that means the cash, asset and liability accounts Quicken names, through File, File Import, QIF file. Two things to know before relying on it:
- Our QIF header is always
!Type:Bank. We have not tested how Quicken treats a bank-type QIF imported into a cash account. Convert one statement and try it before converting a year, inside the 7-day window in the refund policy, and tell us what Quicken did. - QIF has no date-format marker. A QIF file does not say whether 03/04/2026 means 4 March or 3 April. The download has a date order option, MM/DD/YYYY or DD/MM/YYYY, which starts on your browser's regional order; pick the order your Quicken uses.
The record layout and the rest of the format's limits are on PDF to QIF. Quicken's Web Connect troubleshooting page adds that "QIF files will not work with Web Connect in Quicken": Web Connect takes only QFX.
Common import problems and how to fix them
| What you see | Why | What to do |
|---|---|---|
| A QIF will not import into a checking, savings or credit card account | Quicken for Windows does not import QIF into checking, savings or credit card accounts. | Use the CSV route above. |
| Dates rejected or a month off | The Date column is not mm/dd/yyyy. | Reformat the whole column in the spreadsheet and save as CSV again. |
| Columns land in the wrong fields | The columns are not in Quicken's order. | Rearrange them as in the table above; the first seven columns are fixed. |
| Transactions go to the wrong account or a new one | The Account column does not match the Quicken account name exactly. | Copy the account name from Quicken into every row. |
| Everything imports twice | The same period was imported twice; CSV imports do not match existing transactions. | Delete the second import in the register; keep a note of the periods you have imported. |
| Quicken for Mac made a new account | That is how its CSV import works. | Rename the new account, or name the file after the account before importing. |
To see what is inside a QIF before importing, drop it on the file checker: it runs in your browser and reports bad dates, bad amounts and whether the dates are day-first or month-first.
What it costs
- No account: preview the parsed transactions for one statement every 24 hours, up to 10 pages. No download.
- Free account: CSV and Excel downloads, 3 statements a month, 10 pages each.
- Plus, $29 a month: adds QFX, QIF, QBO, Xero CSV, TSV and JSON, 50 statements a month, 50 pages per statement.
- Pro, $59 a month: adds batch upload and client labels, 200 statements a month, 100 pages per statement.
- Business, $99 a month: everything in Pro, 600 statements a month, 100 pages per statement.
For Quicken checking, savings and credit card accounts the free CSV is the file to use, so most Quicken users do not need a paid plan for this. Current prices are on the pricing page.
Privacy
The statement is uploaded over an encrypted (HTTPS) connection and parsed on our servers, and a copy is stored. You can ask us to delete it through the contact page. We never ask for a bank login. The Privacy Policy says what is stored and who processes it.
This page describes file formats and import steps. It is not financial or tax advice, and Quicken's menus can change between releases: if yours differ, Quicken's linked help articles are the authority.
Related guides
- How to import bank statements into Quicken
- PDF bank statement to CSV
- PDF bank statement to QIF
- Import a PDF bank statement into QuickBooks
- QBO, OFX and QIF file checker
- Statement guides by bank
Frequently Asked Questions
Can Quicken import a PDF bank statement directly?
No. Quicken's help article "How do I import data into Quicken for Windows?" says Quicken cannot import Excel, QuickBooks, PDF or OFX files. Convert the PDF to CSV first, check the transactions, then import the CSV.
Can I import a QIF file into a Quicken checking account?
Not in Quicken for Windows. Quicken says QIF import is available only for asset, liability and cash accounts, and is not available for checking, savings or credit card accounts. Use the CSV import for those accounts.
Is there a free way to get a bank statement into Quicken?
Yes. Create a free account, convert the statement and download the CSV (3 statements a month, up to 10 pages each). Rearrange the columns into Quicken's order, write the dates as mm/dd/yyyy, and use File, File Import, Banking Transactions, From (.CSV) File in Quicken for Windows.
What column order does Quicken for Windows need in a CSV?
Quicken's help article lists the first seven columns in this order: Date, Payee, FI Payee, Amount, Debit/Credit, Category, Account. Date, Payee, Amount and Account are required, and dates must be mm/dd/yyyy. Tag, Memo and Chknum may follow.
Why did Quicken for Mac create a new account when I imported a CSV?
That is how Quicken for Mac's CSV import works. Quicken says importing a CSV always creates a new account named after the file, and that it is not possible to link imported transactions to an existing account.
Do you export QFX for Quicken?
Yes, on Plus ($29 a month) and the plans above it. The file is a Web Connect QFX, but it carries a placeholder bank ID because it is built from a PDF, and Quicken checks that ID, so it may refuse the import. Try one statement first; the free CSV route always works.
Why did Quicken import the same transactions twice?
Quicken says CSV imports do not check for or match existing transactions, and reimporting the same file creates duplicates. QIF has no transaction IDs either. Import each statement period once and compare the balance with the statement afterwards.
Ready to convert your statement?
Free to preview. No bank login. Results in about a minute.
Convert a statement