Import a bank statement PDF into Quicken: CSV layout, Web Connect and tie-out

You have bank or card statements as PDFs and the records are in Quicken. Maybe the bank only offers downloads for recent months, or the account was never connected. This guide covers what Quicken can take, how to shape the file, and how to check every month before it goes in. Most of it is about Quicken Classic for Windows; the Mac import works differently and has its own section.

Can Quicken import a PDF statement directly?

No. Quicken's own import pages say it "cannot import Excel (.xls), QuickBooks, PDF, or OFX files" (Quicken: how do I import data into Quicken for Windows?; the Mac page says the same: Quicken: import a CSV file into Quicken for Mac). The routes Quicken documents for bank transactions are:

• Web Connect (.QFX): a file you download from your bank's website and import with File → File Import → Web Connect File (Quicken). It only works for the dates your bank still offers.
• CSV: a fixed-layout file you build yourself, imported with File → File Import → Banking Transactions → From (.CSV) File (Quicken: import transactions from .CSV file). Quicken says this is meant for historical data, manual accounts and institutions that don't support download. For months that only exist as PDFs, this is the practical route: see how to convert a bank statement PDF to CSV.
• QIF: not for bank accounts. Quicken says QIF import "isn't available for checking, savings, or credit card accounts" (Quicken).

Two of Quicken's pages disagree with each other here. The same Windows import page that links to the CSV instructions also says, in its security-prices section, that "CSV files can only be imported to update security prices" (Quicken), while the CSV page describes a full banking import (Quicken). And the Mac page says Quicken can't import OFX files, while Quicken's Mac help on downloading transactions shows File → Import → Bank or Brokerage File (OFX, QFX) (Quicken: downloading transactions). If your version's File Import menu differs from what's below, trust the menu.

Before you start

• Back up your Quicken data file. Quicken's import steps start with a backup for QIF, QXF and QFX imports (Quicken; Quicken), and a CSV import can't be undone line by line.
• Know where your downloads stop. Quicken's Mac help says online accounts usually show only the last 90 days of transactions, a limit set by banks, and anything older has to be exported from the bank's website (Quicken). Months older than your bank's download window are the ones you'll need from PDFs.

Shape a CSV for Quicken Classic for Windows

Quicken's layout is strict. The first seven columns are required, in this exact order, even if some are empty; the last three are optional but must keep their order if used (Quicken: import transactions from .CSV file):

1. Date (must have data)
2. Payee (must have data)
3. FI Payee (ignored, but the column must be there)
4. Amount (must have data)
5. Debit/Credit
6. Category
7. Account (must have data)
8. Tag
9. Memo
10. Chknum

• Dates: mm/dd/yyyy, for example 5/31/2025; leading zeros are optional.
• Amounts: Quicken recommends leaving Debit/Credit blank and using a signed Amount. A positive amount increases net worth and a negative one decreases it; with no sign, Quicken assumes positive. Commas in amounts are allowed. On a credit card account that means purchases are negative and payments positive.
• Text: put any field that contains a comma in double quotes. Quicken suggests a UTF-8 editor or spreadsheet.
• Header row: optional, but if you include one it must follow the same order. Don't add, remove or reorder columns.
• Categories: use Category:Subcategory for subcategories. A bracketed account name such as [Checking] won't create a transfer; Quicken says CSV import doesn't detect or create transfers, so fix those by hand afterwards.
• Account: every row needs the account name. If it doesn't match an account in your file, Quicken asks whether to ignore those rows, add them to an existing account or create a new account.
• The import window has a Create Sample File option. Comparing your file with it is the quickest check of the layout.

We didn't find a file-size or row limit on the pages we read, so one statement-month per file is the safe choice: it's easier to check and easier to remove if something goes wrong.

1. Tie out each month before you import

A clean import doesn't show that every transaction on the statement made it into the file. Check each statement-month first:

1. Opening balance + deposits − withdrawals = closing balance, using the figures printed on the statement, to the cent.
2. Compare your totals with the statement's summary box (total deposits, total withdrawals) so you know which side is short if it misses.
3. Chain the months: each closing balance equals the next statement's opening balance.
4. Spot-check the first and last days of the period and the largest few items against the PDF.

The full method, with a worked example, is in check a bank statement PDF is complete before you import it. Our free tie-out checker runs in your browser and shows the row where a CSV stops balancing.

2. Avoid duplicates

• Quicken says CSV imports don't check for or match existing transactions, unlike Web Connect: every row is added, even if an identical one is already in the register, and importing the same file twice creates duplicates (Quicken).
• So import only the months the register doesn't have. If downloads start on March 4, the last file ends March 3. Look at a few days either side of that boundary, since a bank can date the same transaction differently in a download and on the statement.
• Quicken's Mac help gives the same advice for QFX downloads: don't overlap dates you already have, or you'll get duplicates (Quicken).

3. Import the file (Windows)

1. Open your Quicken data file and choose File → File Import → Banking Transactions → From (.CSV) File (Quicken).
2. Review the format requirements in the window, select Choose .CSV File to Import…, pick the file and select OK. If the file doesn't fit the layout, Quicken shows an error explaining what to fix.
3. When it's done, Quicken shows a summary with the number of transactions imported, any new accounts and any tags added. Compare that count with the number of lines on the statement.

Import months oldest first, one month per file, and check the register before the next one. Quicken's CSV page also mentions Update Balance (gear icon in the register) for setting a manual account's balance (Quicken). Reconciling to the statement, below, is the better check, because it shows a difference instead of adjusting it away.

Quicken for Mac: how the CSV import differs

• The menu is File → Import → Mint.com File (CSV)…. Quicken says any CSV in its format can be imported this way, not only Mint files (Quicken: import a CSV file into Quicken for Mac).
• The import always creates a new account named after the file. Quicken says it's not possible to link imported transactions to an existing account.
• Date, Amount and Account must have values; the other columns must be present but can be blank. FI Payee isn't imported. The column order is shown as an example on Quicken's page; match it exactly.
• Amounts can be signed but shouldn't include dollar signs or commas, which is stricter than the Windows rule.
• Quicken says the Debit/Credit column needs debit or credit in lower case for each transaction to show correctly as income or expense. That sits oddly with "signed numbers allowed", and the page doesn't say what happens when the two disagree. Fill in Debit/Credit for every row, import one month and check the signs.
• Quicken's Mac page gives the date format as D/M/YY or DD/MM/YYYY, which is day first, unlike the Windows mm/dd/yyyy. We can't tell from the page whether that's intended. After the first import, check a date with a day of 12 or less (such as 3/7) against the statement.
• Investment transactions can't be imported by CSV on the Mac. Categories that don't exist yet are created during the import.

4. Reconcile each month to its statement

1. Open the account, choose Reconcile from the Account Actions icon and, if asked, select Paper Statement (Quicken: how do I reconcile a spending account?).
2. Check the opening balance against the statement's beginning or previous balance and enter the statement's ending balance. If you've never reconciled, Quicken says the opening balances may differ and you change Quicken's to match the statement.
3. Check off each transaction that's on the statement, then click Done when the difference in the lower-right corner is zero.

• If the account has already been reconciled to its online balance, Quicken says not to switch back to paper statements: earlier reconciled transactions won't appear and the opening balance won't agree (Quicken).
• If the difference isn't zero after a month you tied out, a line is missing, doubled or has the wrong sign. With CSV imports the usual causes are a file imported twice or a card month with the signs flipped.

Using LedgerReady files in Quicken

• Plain CSV: it has five columns: Date (YYYY-MM-DD), Description, Amount (one signed column), Running Balance and Category. That isn't Quicken's layout as delivered, so rebuild it in a spreadsheet: change Date to mm/dd/yyyy; use Description as Payee; add an empty FI Payee column after it; keep Amount; add an empty Debit/Credit column (on the Mac, fill it with debit or credit); then Category; then an Account column with your Quicken account name on every row. Delete Running Balance. Our Category values are suggestions, not your Quicken categories, so replace them with your own or leave the column empty. We haven't tested this file in Quicken.
• Signs: our Amount is money in positive and money out negative, which matches Quicken's net-worth rule for a bank account. For a card month, check that purchases are negative and payments positive before importing. See credit card statement PDF to CSV for the sign rules.
• Xero CSV: its columns are *Date (DD/MM/YYYY), *Amount, Payee, Description, Reference, which isn't Quicken's order or date format. Use the plain CSV instead.
• QBO file: Quicken says it can't import QuickBooks files, and our .qbo isn't a Quicken Web Connect (.QFX) file. We haven't tested it in Quicken, so use the plain CSV.

Other formats compared: QBO vs CSV vs OFX. Using QuickBooks Desktop instead? See can QuickBooks Desktop import a PDF bank statement.

Where LedgerReady fits

If you'd rather not convert and check each month yourself, LedgerReady turns digital statement PDFs into a QBO file, a Xero CSV, a plain CSV and a tie-out sheet showing every month matches its opening and closing balance. It costs $15 per statement-month, and we aim to deliver within 12 hours. Tie-out guarantee: if the output doesn't reconcile to the statement's opening and closing balances and we can't fix it, you don't pay for that statement.

Bank menus change; labels here were accurate to our knowledge in Oct 2026, so check your bank's help pages if something differs.