Bank Statement Convert

How to upload a credit card statement to QuickBooks Online

Checked against QuickBooks Online's own help pages in October 2026. Sources are at the end.

Upload a credit card statement into the credit card account in QuickBooks Online, not a bank account. Purchases should be negative and payments to the card positive. If they come out the wrong way round, select Reverse all values during the upload. A PDF card statement needs turning into a CSV first, unless QuickBooks' own PDF upload (US only) reads it correctly.

Why card signs trip people up

A card statement is written from the card issuer's side. A purchase adds to what you owe, so the statement prints it as a positive figure, and a payment as a credit. QuickBooks wants your side: a purchase is money out, so it's negative, and a payment to the card is money in, so it's positive. QuickBooks' own help warns that card CSVs may show these reversed, and says to choose the credit card account when you upload.

Turn a PDF card statement into a QuickBooks file

Our converter spots a card statement from wording such as the credit limit, minimum payment and payment due date. It then writes purchases, fees and interest as negative and payments and refunds as positive. It also checks the arithmetic: previous balance, plus purchases and charges, less payments and credits, must equal the new balance printed on the statement. If it doesn't, we list the rows to check. These are the first rows of a QuickBooks file from a sample US card statement:

Date,Description,Amount
09/20/2025,"Payment Thank You-Mobile",1532.40
09/28/2025,"AMAZON MKTPLACE PMTS REFUND",11.99
09/15/2025,"HOME DEPOT #4512 AUSTIN TX",-184.32
09/18/2025,"SHELL OIL 57442 AUSTIN TX",-52.10

Rows keep the statement's order (here payments and credits first, then purchases), so they aren't strictly in date order. Each row keeps its own date, so that doesn't affect the upload.

Upload it into the card account

  1. Go to All apps, then Accounting, then Bank transactions.
  2. Select the card's tile if it has one, then open Link account and select Upload from file.
  3. Select the file and Continue.
  4. Choose the credit card account. If the card isn't in QuickBooks yet, choose Add new and create it as a credit card account.
  5. Set the header row and date format, and match Date, Description and Amount.
  6. On the amounts screen, purchases should show as money out. If every row is the wrong way round, select Reverse all values. With our file they should already be right.
  7. Select the transactions, then Continue, Yes and Done.

After the upload

Common problems

Sources

Menus and button names change. If a step here no longer matches what you see, the program's own page is the one to follow, and tell us so we can update this guide.

More guides and converters