How to import bank statements into Quicken (including PDF statements)

Quicken can't open a PDF bank statement. It imports the files your bank makes for it (QFX, also called Web Connect), plus QIF and CSV files in its own layouts. So “importing a bank statement” really means one of two things: download the same dates from your bank in Quicken's format, or turn the PDF's transactions into a QIF or CSV that your version of Quicken reads. This guide shows which route fits Quicken Classic for Windows, Quicken Classic for Mac and Quicken Simplifi, step by step.

1. Can Quicken import a PDF statement?

No. Quicken's support pages for both Windows and Mac say Quicken cannot import Excel (.xls), QuickBooks, PDF, or OFX files (the Mac's bank-download import does take OFX; see below). A statement PDF is a printed page, not a list of transactions Quicken can read. What Quicken does read:

• QFX (Web Connect) — the “Download to Quicken” file from your bank's website.
• QIF — Quicken's older plain-text format (every line explained on QIF file format).
• CSV — in the exact column layout of each Quicken product (how to import a CSV into Quicken).

So the PDF's transactions have to go into one of those files first — or be typed in by hand, which is quicker if there are only a handful.

2. Which route for your Quicken

Quicken Classic is the desktop program with a data file; Simplifi is the web and phone app. Quicken for Mac uses QIF only to start a brand-new data file, so it isn't a way to add statements to a file you already use.

3. Recent months: the bank's Quicken download

If the bank still has the dates online, this is the cleanest route: the file comes from the bank, carries transaction IDs, and Quicken matches it against what's already in the register.

1. Sign in to the bank's website, open the account and find Download, Export or Download to Quicken (often in the transaction history).
2. Choose the Quicken format (QFX or Web Connect) and the date range, and download the file.
3. Windows: File → File Import → Web Connect File, pick the file, then choose Link and your existing account (or name a new one). Mac: back up, then File → Import → Bank or Brokerage File (OFX, QFX), pick the file and choose the account on the Choose Your Accounts screen.
4. Open the account and accept or review the downloaded transactions.

Quicken checks a Web Connect file with its online services, so it needs a current Quicken subscription and a bank that still supports Web Connect. Banks usually keep only about 90 days of history for download — Quicken's Mac help calls this a limit set by banks. For anything older, use the statement route below.

4. PDF statements into Quicken for Windows (QIF)

1. Download the statement PDF from online banking (text PDFs convert cleanly; scanned statements are read with OCR).
2. Convert it to QIF. Upload it on bank statement to QIF. Utilly checks that the opening balance plus the transactions equals the closing balance and shows Balanced ✓ or the exact difference before you pay; the download is a !Type:Bank QIF (!Type:CCard for a card statement).
3. Back up your Quicken data file. Quicken lists this as the first step of any QIF import.
4. Make sure the account exists. A QIF import goes into an account that's already in your data file, so create it first if it's missing.
5. File → File Import → QIF File, browse to the .qif, pick the account under Quicken account to import into, tick Transactions under Include in import, click Next and follow the prompts.
6. Check the register against the statement (section 10), then categorize.

The first transaction of Utilly's fictional sample statement, as it comes out in the QIF:

!Type:Bank
D09/01/2026
T-6420.18
PACH DEBIT GUSTO PAYROLL 0912
MACH DEBIT GUSTO PAYROLL 0912
^

Date month-first, one signed amount (money out negative), the payee and the full description as the memo. There's no account name, opening balance or category in the file: the transactions go into the account you pick, and you categorize them in Quicken. Download the sample statement's QIF (31 transactions) to try an import into a test account first.

If your checking, savings or card account isn't in the import list: Quicken's own pages disagree on which account types take a QIF. Its Windows help says any account type, checking, savings and credit card included, as long as the account exists; its support article on importing data says QIF is only for cash, asset and liability accounts. The Quicken account to import into list in your copy of Quicken settles it. If the account isn't offered, use the CSV route instead: Quicken for Windows imports banking transactions from a CSV in a fixed 10-column layout (File → File Import → Banking Transactions → From (.CSV) File; layout and a free template on import CSV into Quicken).

5. PDF statements into Quicken for Mac (CSV)

Quicken for Mac doesn't import a QIF into an existing data file, and Quicken says it doesn't support converted QFX files, so the documented route for a PDF statement is a CSV in the Mint layout:

1. Convert the PDF to CSV on bank statement to CSV. The Clean CSV has Date, Description, Amount (already signed) and Balance, after the same balance check.
2. Move the rows into the Mac template. Download the free Quicken for Mac CSV template (columns Date, Description, Original Description, Amount, Transaction Type, Category, Account Name, Labels, Notes), paste in your dates, descriptions and amounts, set Transaction Type to lower-case debit or credit, fill Account Name, and drop the Balance column. Utilly's dates are 2026-09-01, so reformat them month/day/year.
3. Name the file after the account (for example Business Checking.csv) and save as CSV.
4. File → Import → Mint.com File (CSV)… and pick the file. Quicken always creates a new account named after the file.
5. Move the imported transactions into your real account and delete the temporary one, or keep the new account.

The Mac menu for bank downloads also lists OFX, and Utilly can write an OFX of the statement, but that menu is meant for files from your bank and we haven't tested a converted OFX in Quicken for Mac, so we point Mac users to the CSV route. Every column, plus a note on how the Mac reads dates, is on import CSV into Quicken.

6. PDF statements into Quicken Simplifi (CSV)

Simplifi's help says CSV is the only file format it imports, in the web app only, one account at a time, for banking and credit card accounts.

1. Convert the PDF on bank statement to CSV.
2. Put the rows into the free Simplifi template: Date, Payee, Amount, Category, Tags, Notes, Check_No. Date, Payee and Amount on every row; money out needs a minus sign. Simplifi's help asks for M/D/YY dates (1/1/22); its own template writes 3/13/2020.
3. In the web app: Transactions → select the account → the three-dot menu next to Filter → Import transactions → CSV → confirm the account → drop the file → Import.

Each set of transactions can only be imported once; if you delete imported rows, re-importing the same file won't bring them back.

7. Why not convert the PDF to QFX?

Because Quicken rules it out. Its Web Connect troubleshooting page says Web Connect files need Quicken's online services to validate the file, that a file from a bank that no longer supports Web Connect can't be authorized, and that Quicken does not support QFX files created by third-party conversion software, with PDF-to-QFX conversion as the example. A converted QFX may work one day and fail the next, and Quicken support won't help with it. That's why Utilly doesn't make QFX files: the QIF and CSV routes above are the ones Quicken documents for transactions that didn't come from the bank's download.

8. Transactions older than 90 days

This is the most common reason people end up with PDF statements: the account was added to Quicken recently and the bank download stops after about 90 days, or the bank changed and the old download is gone.

• Ask the bank's website first. Some banks export a longer range as QFX or CSV; a bank-made file is always the better start.
• Otherwise, one statement at a time. Convert each monthly PDF and import them oldest first, stopping before the first date already in the register, so nothing overlaps with downloaded transactions.
• Set the starting balance. Neither the QIF nor the CSV carries an opening balance; make the account's opening balance match the first statement's beginning balance (on Windows, the register's gear icon → Update Balance for a manual account).
• Check the balance at each month end against the statement's ending balance before moving on.

9. Credit card statements

The same routes work for card statements. Utilly's card QIF is !Type:CCard, with charges, fees and interest negative and payments and credits positive, so import it into a credit card account, not checking (sample card QIF). For CSV, convert on credit card statement to CSV and use the template for your Quicken. Investment and brokerage statements are a different import in Quicken, and Utilly doesn't read them.

10. Check the import against the statement

A file can import cleanly and still be wrong, so compare Quicken with the statement before you reconcile:

• The number of transactions and the date range match the statement period.
• Money in and money out match the statement's deposit and withdrawal totals.
• The register balance on the statement's last day equals the statement's ending balance.
• A date after the 12th landed in the right month (day and month weren't swapped).

With Utilly's sample statement, a correct import shows 31 transactions from 1 to 30 September 2026: 29,597.43 in, 28,575.27 out, and a beginning balance of 12,418.36 ending at 13,440.52. If a month is duplicated (QIF and CSV imports add every row, even ones already downloaded), delete the extra copies before you reconcile. Then use Quicken's reconcile with the statement's ending balance as usual.

Utilly isn't affiliated with Quicken. We haven't run these files through a live copy of Quicken; the menu paths and limits follow Quicken's help pages, which Quicken updates from time to time.

Sources, checked November 8, 2026: Quicken, How do I import data into Quicken for Windows?, How do I import a CSV file into Quicken for Mac? and Web Connect Troubleshooting; Quicken Windows help, What if all my accounts aren't listed in the QIF Import dialog?; Quicken Mac help, Downloading transactions; Quicken Simplifi help, How to manually import transactions.

FAQ

Related guides

• How to import a CSV file into Quicken (Windows, Mac and Simplifi)
• QIF file format explained: every field, with a real example
• QBO vs IIF vs QIF: which file QuickBooks and Quicken actually need
• Free sample bank statement files: PDF, CSV, QBO, IIF, QIF and Xero CSV
• Free sample bank statement PDF (fictional, with known totals)
• Convert a scanned bank statement PDF to Excel (OCR, checked to the balance)

Related tools

• Bank reconciliation checker: compare a bank statement to your books and list missing, duplicate and mismatched transactions.
• Receipt to CSV: turn PDF or photo receipts and invoices into CSV, Excel, or QuickBooks and Xero bill imports.