Reconciling Your Credit Card in QuickBooks: The Basic Process

Credit card reconciliation in QuickBooks matches the transactions you recorded in the software against the statement your card issuer sends you each month. The goal is to confirm that every charge, payment, and fee on your statement appears in QuickBooks, and that your account balance in the software matches your statement balance. If they do not match, reconciliation helps you find where the difference is.

The reconciliation process works the same way whether you use QuickBooks Online or QuickBooks Desktop, though the exact menu paths differ slightly. You will need your credit card statement in front of you — the one from your card issuer, not your internal records — and you will need to know the statement closing date and the statement balance.

Key Takeaways

  • Reconciliation compares your QuickBooks balance to your credit card statement balance and marks off transactions that match.
  • You need your actual credit card statement from the issuer, including the closing date and ending balance, to start the process.
  • Uncleared transactions — charges or payments that appear in QuickBooks but not yet on the statement — are normal and do not mean reconciliation has failed.
  • If balances do not match after you have marked off all statement transactions, the difference is usually a missing transaction, a wrong amount, or a transaction recorded on the wrong date.
  • Reconciliation locks the transactions you mark as cleared, so you cannot accidentally edit them later without unlocking the reconciliation first.

Gathering Your Statement and Setting Up the Reconciliation

Before you open QuickBooks, collect your credit card statement from your card issuer. You need the statement closing date (the last day covered by the statement) and the statement balance (the total you owe or are owed at the end of that period). Some issuers call this the "ending balance" or "new balance." Do not use an online balance you see today — use the balance printed on the official statement.

In QuickBooks Online, go to the Accounting menu, select Reconcile, and choose the credit card account you want to reconcile. In QuickBooks Desktop, go to Banking, then Reconcile, and select the account. Either way, you will enter the statement closing date and the statement balance into the reconciliation window. QuickBooks will then show you all transactions in that account and let you mark which ones appear on your statement.

Marking Transactions as Cleared

Once the reconciliation window is open, you will see a list of transactions — charges, payments, fees, and credits — that QuickBooks has recorded in that credit card account. Your job is to go through your statement line by line and mark each transaction as cleared (or "reconciled") if it appears on the statement. In QuickBooks Online, you click a checkbox next to each transaction. In Desktop, you click in the checkmark column.

Work through your statement methodically. Check off charges in the order they appear on the statement, then check off payments and credits. As you mark transactions, QuickBooks updates a running total at the bottom of the window. When you have marked off all the transactions that appear on your statement, the difference between your QuickBooks balance and your statement balance should be zero (or very close to it, depending on uncleared items).

Do not mark a transaction as cleared if it does not appear on the statement, even if you think it should. Transactions you recorded in QuickBooks but that have not yet posted to your statement are normal — credit card companies process charges at different speeds, and payments take a day or two to clear. Leave those unmarked for now.

Understanding Uncleared Transactions and Timing Differences

After you mark off all the transactions on your statement, you may have transactions left in QuickBooks that are not checked off. These are uncleared transactions — they exist in your records but have not appeared on the statement yet. Common examples are charges you made near the end of the statement period (which may post after the closing date) or a payment you sent that has not cleared yet.

Uncleared transactions are not a problem. They will appear on next month's statement, and you will mark them off then. The key is that your QuickBooks balance minus the uncleared transactions should equal your statement balance. If it does, reconciliation is working correctly.

For example: your statement balance is $2,500. You have $300 in uncleared charges in QuickBooks. Your QuickBooks account balance is $2,800. That is correct — $2,800 minus $300 equals $2,500. You can proceed with reconciliation.

What to Do If Balances Do Not Match

If after marking off all statement transactions your QuickBooks balance does not match your statement balance (accounting for uncleared items), something is missing or wrong. The most common causes are a transaction you forgot to enter into QuickBooks, a transaction you entered with the wrong amount, or a transaction recorded on the wrong date.

Start by reviewing your statement again and checking that every line item appears in QuickBooks. Look for small charges you might have missed — annual fees, interest charges, or small purchases. Then check that amounts match exactly. A charge for $49.99 recorded as $49.95 in QuickBooks will throw off your reconciliation by $0.04.

If you find a missing transaction, add it to QuickBooks before you finish reconciliation. If you find a transaction with the wrong amount, edit it. Then go back to the reconciliation window and mark it off. If you cannot find the problem, you can save the reconciliation as incomplete and come back to it later — QuickBooks will hold your progress.

Completing the Reconciliation and Locking the Account

Once your QuickBooks balance matches your statement balance (or the difference equals only uncleared transactions), you are ready to finish. In QuickBooks Online, click the Reconcile button. In Desktop, click Reconcile Now. QuickBooks will confirm the reconciliation and lock those marked transactions in place.

After reconciliation is complete, you cannot edit a transaction you marked as cleared without first unlocking the reconciliation. This is a safety feature — it prevents accidental changes to transactions that have already been verified against your statement. If you need to edit a cleared transaction later, you will have to go back into the reconciliation, uncheck the transaction, make your edit, and then re-reconcile.

QuickBooks keeps a record of every reconciliation you complete, including the date, the statement balance, and which transactions were cleared. You can view this history if you need to audit your work or investigate a past discrepancy.

Common Mistakes and How to Avoid Them

The most frequent error is reconciling to the wrong balance. Make sure you are using the statement balance from your credit card statement, not the current online balance you see when you log into your card's website. The online balance may include transactions that posted after your statement closed, and using it will throw off your reconciliation.

Another common mistake is entering transactions in QuickBooks on the wrong date. If you charge something on the 15th but it does not post to your statement until the 18th, record it on the 15th (the date you made the charge), not the 18th. The statement will show the 18th, but you mark it off based on the amount and description, not the date.

Do not try to force a reconciliation by creating a fake transaction to make the numbers match. If there is a $5 difference and you cannot find it, leave the reconciliation incomplete and investigate further. A hidden $5 error is easier to find later than a fake $5 transaction is to undo.

Frequently Asked Questions

Can I reconcile a credit card account that is already closed?

Yes. Even after you close a credit card account, you may need to reconcile it one final time to account for any pending charges or credits. Create a final statement from your card issuer (or use the last statement you received) and reconcile as normal. After that, you can archive or delete the account in QuickBooks if you no longer need it.

What does it mean if QuickBooks shows a different balance than my card issuer's website?

The difference is usually timing. Your card issuer's website updates in real time, so it includes charges and payments that posted today. Your statement is a snapshot from a specific date (the closing date), so it does not include transactions that posted after that date. Reconcile to the statement, not the website balance.

Do I have to reconcile every month?

You should reconcile at least once a month, when you receive your statement. Monthly reconciliation catches errors early and keeps your records accurate. If you reconcile less often, errors can pile up and become harder to track down. If you reconcile more often (for example, weekly), you will be working with partial statements, which is more complicated.

What happens if I mark a transaction as cleared by mistake?

You can uncheck it before you finish the reconciliation. If you have already completed the reconciliation, you will need to unlock it, uncheck the transaction, and re-reconcile. In QuickBooks Online, go to the Accounting menu, select Reconcile, find the account, and look for an option to edit or undo the reconciliation. In Desktop, go to Banking, Reconcile, and select the account to view past reconciliations.

Can I reconcile a credit card that has a zero balance?

Yes. If you paid off your card completely and the statement balance is zero, reconciliation works the same way. Mark off all the charges and payments on the statement, and your QuickBooks balance should also be zero. This confirms that every transaction on the statement is recorded in your books.