Skip to main content

HomeAll guides

How to Reconcile a Credit Card in QuickBooks

Reconciling a credit card in QuickBooks means matching the transactions you recorded in the software against the statement your card issuer sends you each month

The goal is to find and fix any differences — missing charges, duplicate entries, or timing gaps — so your QuickBooks balance matches your actual card balance. Most reconciliations take 15 to 30 minutes if your records are reasonably current. The process works the same way whether you use QuickBooks Online or QuickBooks Desktop, though the menu paths differ slightly.

You will need your most recent credit card statement from your issuer, your QuickBooks login, and access to the credit card account you want to reconcile. If you have not recorded transactions in QuickBooks yet, reconciliation will show you which ones are missing.

Key Takeaways

  • Reconciliation compares your QuickBooks record of charges against your card issuer's statement to find missing or duplicate transactions.
  • In QuickBooks Online, you start reconciliation by clicking the credit card account, then selecting Reconcile; in Desktop, you use the Banking menu.
  • You mark off each transaction on your statement as you find it in QuickBooks, and QuickBooks calculates the difference at the end.
  • If the difference is zero, reconciliation is complete; if not, you either find the missing transaction or create a journal entry to account for the gap.
  • Reconciling monthly, as soon as your statement arrives, prevents small errors from compounding and makes future reconciliations faster.

How to start reconciliation in QuickBooks Online

Open QuickBooks Online and go to the Accounting menu on the left sidebar. Find and click the credit card account you want to reconcile — it will appear under the list of accounts. Click the account name to open it.

Once the account is open, look for the Reconcile button, usually located near the top right of the screen. Click it. QuickBooks will ask you to enter the statement date (the date on your credit card statement) and the ending balance (the total balance shown on that statement). Enter both and click Continue.

QuickBooks will now show you a list of all transactions it has recorded for that card since the last reconciliation. Your job is to mark each transaction as "cleared" — meaning you found it on your statement.

How to start reconciliation in QuickBooks Desktop

Open QuickBooks Desktop and click the Banking menu at the top. Select Reconcile. A window will open asking you to choose which account to reconcile. Click the dropdown and select your credit card account.

Enter the statement date and ending balance from your credit card statement, then click Continue. QuickBooks will display two lists: one showing charges and credits you recorded, and one showing the running balance. You will mark transactions as cleared as you match them to your statement.

Matching transactions to your statement

Lay your credit card statement next to your computer. Go through each charge and credit listed on the statement one by one. In QuickBooks, find that same transaction in the list and click the checkbox next to it to mark it cleared. The checkmark tells QuickBooks you have confirmed that transaction exists on both your statement and in the software.

Watch the dates and amounts carefully. A charge dated June 15 on your statement might not appear in QuickBooks until June 17 if there was a processing delay — this is normal and not a problem. Mark it cleared anyway, because it did eventually post to your card.

If you see a transaction in QuickBooks that is not on your statement, do not mark it cleared. It may be pending and will appear on next month's statement, or it may be an error. Leave it unmarked for now.

What to do when the reconciliation does not balance

At the bottom of the reconciliation window, QuickBooks shows a Difference amount. If this number is zero, your reconciliation is complete — click Finish or Done depending on which version you use.

If the difference is not zero, you have a mismatch to investigate. Start by checking whether you missed marking a transaction as cleared. Scroll through the list again and look for any charges or credits on your statement that you did not check off. This is the most common cause of a non-zero difference.

If you find a transaction in QuickBooks that is not on your statement, it may be pending. Leave it unmarked and reconcile again next month. If you find a transaction on your statement that is not in QuickBooks, you need to add it. Close the reconciliation window, create a new transaction in QuickBooks for that charge, and then start reconciliation again.

If the difference is a small amount and you cannot find the source after a thorough check, you can create a journal entry to account for it. This is not ideal, but it is better than leaving the reconciliation incomplete. Document why you made the entry in the memo field so you can review it later.

Recording transactions you missed

If your statement shows a charge that you did not record in QuickBooks, you need to add it before you can mark it cleared. Close the reconciliation window and create a new transaction. In QuickBooks Online, click the + button and select Expense or Check depending on how the charge appeared. In Desktop, use the Write Checks or Enter Bills window.

Enter the date, amount, and payee exactly as they appear on your statement. Assign the transaction to the correct expense account — for example, if it is an office supply purchase, assign it to Office Supplies Expense. Save the transaction and return to reconciliation. The new transaction should now appear in the list and you can mark it cleared.

Why timing differences happen and how to handle them

A charge you recorded in QuickBooks on June 10 might not appear on your statement until June 15. This lag is normal — it is the time between when you made the purchase and when your card issuer processed it. Do not create a duplicate entry. Mark the transaction cleared when you see it on your statement, even if the dates do not match exactly.

The reverse can also happen: a charge appears on your statement but you have not recorded it in QuickBooks yet. This usually means the charge posted to your card before you entered it into the software. Add the transaction to QuickBooks, then mark it cleared during reconciliation.

If a charge appears on your statement but you genuinely did not make it, contact your card issuer when ready. Do not record it in QuickBooks. Your issuer will investigate and either reverse it or confirm it was legitimate.

Reconciling multiple credit cards and staying current

If you have more than one credit card in QuickBooks, reconcile each one separately using the same process. Start with the card you use most frequently, since it will have the most transactions to track. Set a recurring reminder to reconcile each card as soon as its statement arrives — usually within a few days of the statement date.

Reconciling monthly takes only a few minutes if you have been recording transactions regularly. If you wait three or four months, the list becomes long and small errors are harder to spot. Monthly reconciliation also catches fraud or billing errors quickly, before they compound.

Frequently Asked Questions

What if I recorded a transaction twice by accident?

During reconciliation, you will see both copies in the list. Mark only one as cleared. After reconciliation is complete, delete the duplicate transaction. In QuickBooks Online, click the transaction and select Delete. In Desktop, right-click the transaction and choose Delete.

Can I reconcile a credit card if I have not recorded all the transactions yet?

Yes, but reconciliation will show you which transactions are missing. You can add them during the reconciliation process, or close reconciliation, add the missing transactions, and start again. Either way works.

What does it mean if my reconciliation difference is a negative number?

A negative difference means your QuickBooks balance is higher than your statement balance — you have recorded more charges than your card issuer shows. This usually means you recorded a transaction that has not posted yet, or you recorded a charge twice.

Do I have to reconcile every month?

You do not have to, but monthly reconciliation is the standard practice for good financial record-keeping. It catches errors early and makes tax time easier. If you reconcile less often, errors accumulate and become harder to track down.

What if my card issuer and QuickBooks disagree on the balance and I cannot find the error?

Contact your card issuer and ask them to walk you through the statement. They can confirm which charges posted and when. Once you have that information, you can either find the missing transaction in QuickBooks or add it if it was never recorded.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.