How to Import Bank Statements into Quicken

Quick Answer {#quick-answer}

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

Quicken File Formats Explained {#quicken-formats}

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.

Importing QFX or OFX Files into Quicken {#qfx-import}

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.

Importing CSV Files into Quicken {#csv-import}

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 produces a CSV in this structure automatically. If your bank's own CSV has different column names or date formats, QuickBankConvert normalizes them.

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.

Troubleshooting Quicken Import Errors {#troubleshooting}

Importing into Quicken Simplifi {#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 {#after-import}

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 and CSV normalization. Visit the QuickBankConvert home page to convert your first statement for free.