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
- Go to All apps, then Accounting, then Bank transactions.
- Select the card's tile if it has one, then open Link account and select Upload from file.
- Select the file and Continue.
- Choose the credit card account. If the card isn't in QuickBooks yet, choose Add new and create it as a credit card account.
- Set the header row and date format, and match Date, Description and Amount.
- 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.
- Select the transactions, then Continue, Yes and Done.
After the upload
- The payment to the card appears twice: as money out of your bank account and as money in on the card. Record it once, as a transfer between the two accounts, so it isn't counted as income or an expense.
- Refunds on the card are money in. They usually reduce the expense they came from, so categorise them against the original purchase's category rather than as income.
- Interest and fees are money out like purchases. Your accountant can tell you how they're treated for tax.
Common problems
- The card balance in QuickBooks goes the wrong way. The file went into a bank account, or the signs were reversed. Exclude those transactions on the Bank transactions page before you categorise them, then upload the file again into the credit card account.
- Day and month swapped. Choose the date format that matches the file. Our US files are MM/DD/YYYY and UK files DD/MM/YYYY.
- Duplicates. Start each upload the day after the last transaction already in the card account.
Sources
- QuickBooks: Format CSV files in Excel to get bank transactions into QuickBooks (tips for credit card accounts)
- QuickBooks (US): Manually upload transactions into QuickBooks Online
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.