How to Import Bank Statements into Quicken

Quick Answer

To import bank statements into Quicken: download a QFX or OFX file from your bank's website (most US banks support this), and go to File → Import → Bank or Brokerage File (OFX/QFX). If only PDF is offered, convert it to CSV with QuickBankConvert and use File → Import → Transactions from a CSV File. QFX works best; CSV is the universal fallback.

Quicken File Formats Explained

Quicken is one of the oldest personal finance applications, and it has historically driven the development of financial data formats. Understanding the options helps you choose the right path:

Which to use:

1. QFX first — if your bank offers it
2. OFX second — widely supported, nearly identical to QFX in Quicken
3. CSV — when QFX/OFX is unavailable (bank only offers PDF or raw CSV)

Callout: Many banks label their QFX/OFX download as "Quicken format" or "Microsoft Money format." Look for these labels in your bank's download or export menu. If you only see PDF, QuickBankConvert converts it to a clean CSV ready for Quicken's CSV import workflow.

How Do I Import QFX or OFX Files into Quicken?

Step 1 – Download from Your Bank

Log in to your bank's online portal. Navigate to your account's transaction history. Look for a Download, Export, or Activity button. Select:

• Quicken or QFX for the native format
• OFX or Microsoft Money as the alternative

Choose a date range (start date to end date) and download the file.

Step 2 – Open Quicken and Import

In Quicken Classic (Mac or Windows):

1. Go to File → Import → Bank or Brokerage File (OFX/QFX)
2. Browse to your downloaded file
3. Select the target account in Quicken
4. Click Import

Quicken will display a list of transactions about to be imported and flag any potential duplicates.

Step 3 – Review the Transaction List

Before confirming, review:

• Are dates correct?
• Are amounts with the right sign (negative = withdrawal, positive = deposit)?
• Are any transactions flagged as duplicates accurate?

Click Accept All to import, or review flagged duplicates individually.

Step 4 – Verify Your Balance

After import, check that Quicken's account balance matches your bank statement's closing balance. If not, a transaction may be missing or a duplicate may have slipped through.

How Do I Import CSV Files into Quicken?

When your bank does not offer QFX or OFX, CSV import is the reliable fallback.

Prepare Your CSV

Quicken's CSV import expects these columns (column names must match exactly or be mapped):

QuickBankConvert turns a PDF statement into a CSV with date, description, and amount columns that map onto these fields. It takes PDF statements, not CSV files, so if your bank's own CSV has different column names or date formats, adjust them on Quicken's column mapping screen.

Step-by-Step CSV Import in Quicken Classic

1. Open Quicken and navigate to the account you want to import into
2. Go to File → Import → Transactions from a CSV File
3. Browse to your CSV file
4. Quicken displays a column mapping screen—match your columns to Quicken's fields
5. Set the date format that matches your file
6. Preview the first several rows to check for errors
7. Click Import

CSV Import in Quicken for Mac

On Mac, the path is:

File → Import → CSV

The column mapping interface is similar to Windows, but the file browser uses the macOS file picker.

How Do I Fix Quicken Import Errors?

Importing into Quicken Simplifi

Quicken Simplifi is the modern web-based version of Quicken, designed as a Mint replacement. It prioritizes automatic bank sync but also supports manual CSV import.

CSV Import in Simplifi

1. Log in to Simplifi at simplifimoney.com
2. Navigate to the account you want to import into
3. Click the three-dot menu (⋯) in the account header
4. Select Import Transactions
5. Upload your CSV file
6. Map columns (Date, Description, Amount minimum)
7. Review and confirm

Format requirements for Simplifi:

Simplifi accepts the same basic CSV structure as Quicken Classic. Dates should be in MM/DD/YYYY format and amounts should be plain numbers without currency symbols.

Callout: Simplifi's automatic bank sync covers most major US banks, but credit unions, regional banks, and international accounts often fall back to manual import. Keep a monthly habit of downloading statements and converting them with QuickBankConvert to fill any gaps left by the auto-sync.

After Import: Reconciling in Quicken

Reconciliation confirms that Quicken's records match your official bank statement.

Quicken Classic Reconciliation

1. Open the account register
2. Go to Actions → Reconcile
3. Enter the Opening Balance and Closing Balance from your bank statement
4. Check off each transaction that appears on the statement
5. The difference should reach zero
6. Click Done

If the difference is not zero after checking all transactions:

• Look for a transaction in Quicken that does not appear on the statement (may be a duplicate)
• Look for a transaction on the statement that does not appear in Quicken (missing transaction)
• Check whether the opening balance in Quicken matches the prior period's closing balance

Monthly reconciliation habit: reconcile once per month, right after importing that month's statement. Catching discrepancies monthly is far easier than untangling six months of drift in one sitting.

For the most reliable import workflow, combine your bank's QFX/OFX download (when available) with QuickBankConvert for PDF conversion. Visit the QuickBankConvert home page to preview your first statement for free; a free Google sign-in unlocks the CSV download, and QIF export for Quicken is available on the Plus plan.

Sources and Further Reading

• Quicken support — official help for QFX, OFX and CSV imports.
• Financial Data Exchange — the standards body that now maintains the OFX specification.
• Quicken Interchange Format — the QIF file format and its field codes.