Import a Credit Card Statement Into QuickBooks (3 Ways)

There are three reliable ways to get a credit card statement into QuickBooks: import a .qbo or .qfx file from your card issuer, upload a CSV of the transactions, or convert the PDF statement to .qbo when neither of those is an option. QuickBooks cannot read a raw PDF as data, so the route you pick depends on what your issuer gives you and whether you run QuickBooks Online or Desktop.

This guide covers all three, with the exact menu clicks for Online and Desktop, plus how to set up the credit card account correctly and reconcile to the statement balance afterward. If you just want the fastest accurate route, convert the statement with the tool at the top of this page and jump to the import steps.

Why QuickBooks won't read a PDF credit card statement

A PDF is a picture of a statement. Even when you can select the text, the charges are positioned text fragments, not the rows and columns a parser needs, so QuickBooks has nothing to read. The banking import accepts .qbo, .qfx, .ofx, and CSV files, and that is the whole list.

QuickBooks Online has added an AI tool that pulls transactions from an uploaded PDF or image, which helps in a pinch. It is online only, the file must be 350 KB or less and in English, and the extracted lines still need checking before you trust them. For a result that reconciles to the statement total and also works in Desktop, a converted .qbo file is the cleaner path.

Method 1: Convert the PDF statement to a .qbo file

This is the method to use when there is no live feed, when you keep books in QuickBooks Desktop, or when you need months of history the feed will not pull. It works for any issuer because it reads the statement itself rather than relying on a connection. Use the dedicated credit card statement to QuickBooks converter to turn the PDF into a .qbo in seconds.

1. Upload the statement. Drop the credit card PDF into the converter at the top of this page. Digital PDFs, scans, and phone photos all work, and you can upload several months at once.
2. Let the extraction run. Every charge, payment, refund, interest line, and fee is read, along with the statement's opening and closing balances.
3. Check the reconciliation. The extracted transactions are summed and compared against the statement totals, so a mismatch shows up now instead of during reconcile.
4. Download the .qbo file. You also get the same data as Excel and CSV for workpapers or for a client who wants a readable copy.

Method 2: Upload a CSV of credit card transactions

Some issuers let you download card activity as a CSV. QuickBooks Online can import it, but the file has to be shaped the way QuickBooks expects: three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit), in English, and 350 KB or less.

The catch is cleanup. Exported CSVs often arrive with extra columns, merged dates and descriptions, or a single amount column that does not separate charges from payments. A credit card CSV also carries no account type, so signs can flip if you import it to the wrong account. Budget time to fix the columns before you upload, or skip the cleanup by converting the PDF to .qbo instead.

Method 3: Import a .qbo or .qfx file from your card issuer

A handful of card issuers offer a direct download in Web Connect (.qbo) or Quicken (.qfx) format. If yours does, that file imports straight into QuickBooks with the dates, amounts, and descriptions already structured. Look for a download option labelled QuickBooks, Web Connect, or Quicken in the statements area of your online account.

Most credit cards, though, only offer PDF and sometimes CSV, with no .qbo option, and direct downloads usually reach back just a few months. When the file you need is not available, converting the PDF statement gives you the same .qbo result for any period you have a statement for.

How to set up the credit card account in QuickBooks

Before you import, create the card as a Credit Card account, not a bank account. QuickBooks treats a credit card as a liability, so charges increase the balance you owe and payments reduce it. Importing into a credit card account keeps those signs right, while a bank account would record them backward and throw the balance off.

How to import the file into QuickBooks Online

1. Go to Transactions, then Bank transactions.
2. Select the Link account dropdown, then Upload from file.
3. Choose your .qbo or CSV file and pick the credit card account it belongs to.
4. Confirm the import. The charges appear in the For review tab, where you categorize and match them.

How to import the file into QuickBooks Desktop

1. Open your company file in QuickBooks Desktop.
2. Go to File > Utilities > Import > Web Connect Files.
3. Select the .qbo file and choose the credit card account, or create one.
4. Review the transactions in the Bank Feeds Center and add them to the register.

How to reconcile the credit card statement

Once the charges are in, open Reconcile, select the credit card account, and enter the ending balance and statement date from the statement. Reconcile to the statement balance, the figure as of the closing date, not the current balance, which already includes newer charges. Match each line until the difference reads zero, then finish. Because the import brought in every transaction, this step is matching, not retyping.

Which method should you use?

If your issuer offers a direct .qbo or .qfx download for the period you need, use it. If you have a clean CSV and do not mind shaping the columns, that works for QuickBooks Online. For everything else, an older month, a card with no feed, a Desktop company file, or a year of catch-up before taxes, convert the PDF to .qbo. It is the one method that works for any issuer, any period, and both QuickBooks versions.

Convert a statement with the tool at the top of this page, or read the deeper guide to the credit card statement to QuickBooks converter. For checking accounts, follow the steps to import a bank statement into QuickBooks Online, see how the PDF to QBO converter works, and what a QBO file is. Before the first import, make sure you set up the credit card account in QuickBooks as a liability, then reconcile the credit card to the closing balance. Reconciling a specific card? There are dedicated pages for American Express and the Expensify Card, plus a workflow for accountants and bookkeepers handling many clients. Prefer a spreadsheet? Convert the same statement to Excel, and turn the card's receipts into spreadsheets to support each deduction.