How to Import Credit Card Statements into QuickBooks

Getting credit card transactions into QuickBooks shouldn't be hard — but if your issuer only provides PDF statements, it can feel like a real headache. QuickBooks can't read PDF files directly, so you need to get your transactions into a format it understands.

Here's how to do it, step by step. (If you first need to convert your PDF statement, start with our credit card statement to Excel guide.)

The Problem: QuickBooks Can't Read PDFs

QuickBooks Online and QuickBooks Desktop accept transaction imports in specific formats:

• CSV (comma-separated values)
• QBO (QuickBooks Web Connect)
• QFX (Quicken Financial Exchange)
• OFX (Open Financial Exchange)

Credit card companies provide statements as PDFs. Some issuers (like Amex) offer limited CSV export for recent transactions, but most — including Chase, Citi, Bank of America, and US Bank — only provide PDF statements for credit cards.

This mismatch means you need a conversion step in between. If you use Xero instead of QuickBooks, the same PDF-to-CSV workflow applies — see our guide to importing credit card statements into Xero for the Xero-specific steps.

Method 1: Convert PDF to CSV, Then Import (Recommended)

This is the fastest method for most people. It works with any credit card issuer and gets transactions into QuickBooks in about 2 minutes.

Step 1: Convert Your Statement to CSV

1. Go to CreditCardToExcel.com
2. Upload your credit card statement PDF
3. Wait a few seconds for the AI to extract transactions
4. Click "Download CSV"

The CSV file will contain four columns: Date, Description, Amount, and Category.

Step 2: Prepare the CSV for QuickBooks

QuickBooks Online expects a specific CSV format. The file from CreditCardToExcel is already structured correctly, but here's what QuickBooks needs:

• Date column (required)
• Description column (required)
• Amount column (required)

QuickBooks will ask you to map columns during import, so the exact column names don't matter — you just need the data to be present.

Step 3: Import into QuickBooks Online

1. Log in to QuickBooks Online
2. Go to Banking (or Transactions > Banking)
3. Click "Link account" then select "Upload from file"
4. Choose your credit card account (or create one)
5. Select the CSV file you downloaded
6. Map the columns: Date, Description, Amount
7. Click "Import"

QuickBooks will show you a preview of the transactions. Review them, then accept the import.

Step 3 (Alternative): Import into QuickBooks Desktop

1. Open QuickBooks Desktop
2. Go to File > Utilities > Import > Web Connect Files
3. Select your CSV file
4. Map to the correct credit card account
5. Review and accept the imported transactions

Method 2: Use Your Issuer's CSV Export (If Available)

Some credit card issuers offer direct CSV or QFX downloads:

If your issuer offers CSV and you only need recent transactions, this is the simplest path. But for historical data or issuers that don't support it, you'll need Method 1.

Method 3: Bank Feed Connection (Automatic)

QuickBooks can connect directly to many credit card accounts via bank feeds. This automatically imports new transactions.

To set up:

1. Go to Banking > Link account
2. Search for your credit card issuer
3. Enter your online banking credentials
4. Select the credit card account

Limitations:

• Only imports transactions going forward (plus a limited history window)
• Some issuers have intermittent connection issues
• Doesn't help with historical statements
• You're sharing banking credentials with a third party

Bank feeds are great for ongoing bookkeeping but don't solve the problem of importing historical PDF statements.

Tips for Clean QuickBooks Imports

Match the date format

QuickBooks expects dates in MM/DD/YYYY format. CreditCardToExcel outputs dates in this format by default, so no adjustment is needed.

Handle credits and payments correctly

Credits and payments should be negative amounts. CreditCardToExcel marks these correctly (negative values), which QuickBooks interprets as credits when importing to a credit card account.

Avoid duplicate transactions

If you're importing a statement for a period that overlaps with existing transactions in QuickBooks, you may get duplicates. QuickBooks will flag potential duplicates during import — review these carefully.

Use categories for classification

CreditCardToExcel auto-categorizes transactions, but QuickBooks uses its own chart of accounts. You'll need to map transactions to the correct QuickBooks categories after import. The auto-categories from CreditCardToExcel can help you batch-classify similar transactions.

Importing Multiple Months

If you need to import several months of credit card statements into QuickBooks, here's the efficient workflow:

1. Download all statement PDFs from your credit card issuer
2. Upload them to CreditCardToExcel using batch upload (Pro or Business plan)
3. Download as CSV (batch download creates a ZIP with one CSV per statement)
4. Import each CSV into QuickBooks one at a time, starting with the oldest

Importing in chronological order helps QuickBooks maintain accurate running balances.

Common Issues and Fixes

"The file format is not supported"

Make sure you're uploading the CSV file, not the original PDF. QuickBooks can't read PDFs directly.

"Some transactions were not imported"

This usually means QuickBooks found duplicate transactions or dates outside the expected range. Check the error log for specifics.

Transactions appear in the wrong account

During import, make sure you select the correct credit card account. If transactions ended up in the wrong account, you can delete the import and redo it.

Amounts are inverted

If charges appear as credits and vice versa, QuickBooks may have inverted the sign during import. Some versions of QuickBooks handle credit card amounts differently. Try importing again and check the "invert amounts" option if available.

Summary

The fastest path to get credit card statement transactions into QuickBooks:

1. Convert PDF to CSV using CreditCardToExcel (free, no signup)
2. Import CSV into QuickBooks via Banking > Upload from file
3. Map columns and review transactions
4. Accept the import

The whole process takes about 2 minutes per statement. For ongoing bookkeeping, pair this with QuickBooks' bank feed for new transactions and use statement conversion for historical imports.

If you're building a monthly routine around this workflow — especially if you manage multiple cards — our guide on how to track business credit card expenses covers a complete monthly system including how to consolidate multiple cards, what fields to capture, and how to share organized reports with your accountant or bookkeeper.

Related Guides

• Credit Card Statement to Excel: The Complete Guide
• How to Categorize Credit Card Expenses for Taxes
• How to Import Credit Card Statements into Xero
• How to Import Credit Card Statements Into Wave
• How to Convert Chase Statements to Excel
• How to Convert Amex Statements to Excel
• How to Convert US Bank Statements to Excel
• PDF to CSV: How to Convert Financial Documents
• Best Credit Card Statement Converters (2026)