How to Reconcile a Credit Card in QuickBooks
Quick Answer: Open the Reconcile tool, pick the credit card account, and type the statement's closing date and its new balance (the amount owed on that date, not the minimum due). Tick each charge and payment that appears on the statement until the Difference reads 0.00, then finish. QuickBooks then offers to record a payment now or enter a bill for later; choose based on whether the payment already exists in your books.
Reconciling a credit card in QuickBooks means proving that the card account in your books owes exactly what the card issuer says you owed on the statement closing date. You enter the statement's closing date and new balance, clear every charge, refund and payment that the issuer printed, and resolve any gap before you finish. The step people get wrong is what comes after: paying the balance.
Drop your bank statement here
PDF or OFX ยท Max 4.4 MB
Uploaded over an encrypted connection. We never ask for your bank login. Privacy
Preview free with no account. Free account to download.
Why does a credit card reconcile differently from a bank account?
A checking account is an asset. Deposits push its balance up and checks pull it down. A credit card account in QuickBooks is a liability, so the logic runs the other way: every purchase increases what you owe, and every payment or refund reduces it. That flip explains most of the confusion people hit the first time.
Three statement figures matter, and only one of them belongs in the reconcile screen:
| Statement line | What it means | Use it in the reconcile window? |
|---|---|---|
| Closing date (statement date) | The last day of activity the statement covers | Yes, as the ending date |
| New balance | Total owed on the closing date | Yes, as the ending balance |
| Payment due date | When the issuer wants money, usually weeks later | No |
| Minimum payment due | The least you can pay without a late fee | No |
If you type the due date instead of the closing date, QuickBooks will show you charges from after the cycle closed and the cleared total will never land on the statement figure. If you type the minimum payment as the balance, you will chase a difference that equals the unpaid remainder.
A credit balance on the statement (the issuer owes you, often after a refund) is entered as a negative ending balance in most setups. Read the statement carefully: a figure printed with "CR" next to it is a credit.
How do you reconcile a credit card in QuickBooks Online?
Intuit's current help article on reconciling an account in QuickBooks Online lays out the path. The menu labels below come from that page:
- Go to All apps, then Accounting, then Reconcile. If this is the first time, the button reads Get started.
- In the Account dropdown, choose the credit card, not the bank account you pay it from.
- Check the Last statement ending date QuickBooks shows. It should be the closing date of the previous statement you reconciled. If a month was skipped, reconcile the older one first.
- Enter the Ending balance and Ending date from the new statement.
- Select Start reconciling.
- Tick each charge and each payment or credit that appears on the statement. Watch Cleared balance move toward the statement balance.
- When the Difference shows 0.00, select Finish now, then Done.
Intuit's page also mentions that you can attach the statement for AI-assisted matching. Whether or not you use that, the manual check is the same: every line on the statement should end up ticked, and nothing that isn't on the statement should be ticked.
Afterwards, QuickBooks stores a reconciliation report you can reopen from History by account on the Reconcile page. Save it with the statement PDF; it is the evidence an accountant or auditor will ask for.
For the broader bank-account version of this process, see the QuickBooks Online reconciliation guide.
How is QuickBooks Desktop different?
In QuickBooks Desktop, open the Banking menu and choose Reconcile, according to Intuit's Desktop reconciliation article. Select the card account, then fill in the Statement Date and Ending Balance. Desktop prefills the Beginning Balance; if it doesn't equal the previous statement's new balance, something already reconciled was changed, and you should fix that before going further.
The Desktop window splits a card account into two columns: Charges and Cash Advances on one side, Payments and Credits on the other. The Begin Reconciliation window also has fields for charges that aren't in your books yet, so interest or an annual fee can be posted as an expense before you start ticking. When the difference is zero, choose Reconcile Now.
What should you do after reconciling a credit card account?
This is the part that separates card reconciliation from bank reconciliation. Once the balance agrees, QuickBooks asks how you want to deal with the amount owed.
In QuickBooks Online you see two links plus a way out: Pay all or a portion of the bill now, Enter a bill to pay later, or Done. In Desktop, a Make Payment window offers to write a check now or enter a bill for later, and you can cancel it. Which option is right depends on one question: does the payment already exist somewhere in your books?
Scenario 1: autopay already came through the bank feed
You pay the card from checking, and the payment has already been downloaded into the checking account and categorized as a transfer to the card. In that case it is already recorded. Choose Done (or Cancel in Desktop). Creating another payment here would record the same money twice: checking would drop twice and the card would show a credit balance you don't have.
Scenario 2: you will pay the full balance next week by online transfer
Pick Done, then record the payment when it actually leaves the bank. Intuit's guide to recording credit card payments describes the + New > Pay down credit card form, where you name the card, the amount, the date and the bank account that paid. Recording it on the real date keeps the bank reconciliation clean next month.
Scenario 3: you track the card through Accounts Payable
Some businesses want the balance owed to the card issuer to sit in Accounts Payable so it appears on the bills list with a due date. That is what Enter a bill to pay later does: it moves the reconciled balance to A/P. Use it only if you consistently work this way, because the eventual payment must be recorded against the bill, not as a separate card payment.
Scenario 4: you are paying part of the balance
Pay all or a portion of the bill now accepts a partial amount. Use it when you are making the payment that day, and enter the actual amount that will leave the bank.
Refunds, credits and disputed charges
A refund from a merchant shows on the statement as a credit. In your books it should be recorded in the card account as a credit, usually back to the same expense category the purchase used. Don't net it against a later purchase; the statement lists it separately and your reconciliation should too.
A disputed charge the issuer has temporarily credited is trickier. If the statement shows a provisional credit, record it as printed. If the dispute is later reversed, the charge comes back on a later statement and you clear it then.
Annual fees, interest and foreign transaction fees are often missed because they don't come from a merchant. Look at the fee and interest section of the statement and make sure each one exists in QuickBooks before you start ticking.
When the difference won't reach zero
Work through these in order:
- The difference equals one transaction. A charge was entered as a payment, or the other way around. Open it and check the direction.
- The difference is twice a transaction. Same cause: a sign error doubles the gap.
- The difference is divisible by 9. Two digits were swapped when the amount was typed (54.10 entered as 45.10).
- The opening balance is off. A previously cleared transaction was edited or deleted. Desktop's reconciliation discrepancy report and Online's reconciliation history help you find it.
- A transaction is missing entirely. Compare the statement line by line with the card register for the period.
The last item is where most of the time goes. If the card's transactions never came in through the connection, or came in with gaps, you may be typing them from the PDF. QuickBooks can import a bank-format .QBO file into the card account instead. QuickBankConvert builds that file from the issuer's PDF statement on its paid plans, which turns the missing-transaction hunt into a review of a list. The sibling guide on importing credit card transactions into QuickBooks covers file uploads, sign conventions and duplicate payments in detail.
If you only need the statement as a spreadsheet for a side-by-side comparison, the credit card statement to Excel page shows what the output columns look like.
A monthly routine that keeps it short
- Wait for the statement to close, then download the PDF the same week.
- Categorize anything left in the For Review list for that card.
- Confirm interest and fees are recorded.
- Reconcile to the closing date and new balance.
- Choose Done unless you are recording a payment that has not been entered anywhere else.
- File the reconciliation report with the statement.
Doing this every month takes minutes. Letting six statements pile up turns it into an afternoon, mainly because one early error carries forward into every later attempt.
Related guides
Frequently Asked Questions
Should I use the statement closing date or the payment due date when reconciling a credit card?
Use the closing date. The due date is weeks later and would pull in charges that belong to the next statement.
Why is my credit card balance in QuickBooks showing a credit after I reconciled?
Usually the payment was recorded twice: once from the bank download and again from the pay-now link after reconciling. Delete the duplicate and the balance returns to what the issuer shows.
Do I have to pay the credit card bill in QuickBooks right after reconciling?
No. You can choose Done and record the payment later when it actually leaves the bank, which is usually the cleaner option.
What does Enter a bill to pay later do in QuickBooks Online?
It moves the reconciled card balance into Accounts Payable as a bill, so you pay it later from the bills list. Use it only if you manage card balances through A/P consistently.
Can I reconcile several months of credit card statements at once?
Reconcile them one statement at a time, oldest first. Each reconciliation needs that statement's own closing date and balance so the next one starts from the right figure.
Ready to convert your bank statement?
Free to preview. No bank login. Results in about a minute.
Convert a statement