Bookkeeping & payrollCredit Card Reconciliation: Why the Card Balance Never Matches (and How to Fix It)

Your card company says you owe $4,812.33. QuickBooks says you owe $7,366.90. Your business partner asks, reasonably, "Can't we just pick one?"

Sadly, no. But the gap between those two numbers almost always comes from the same short list of mix-ups, and most of them are about dates rather than math.

Credit card reconciliation works like a bank reconciliation with a few extra traps: a closing date that isn't the due date, charges that sit in "pending" for days, and payments that keep getting recorded as expenses. Below you'll find each trap, a monthly routine, and a worked example with real-looking numbers.

What credit card reconciliation actually proves

When you reconcile a card, you're confirming that the liability account in your books (the amount you owe the card company) matches the statement as of the statement closing date. Every charge, refund, fee, interest charge and payment on that statement should appear in your books exactly once. Not zero times. Not twice because the bank feed and a human both had a go at it.

If you already reconcile checking, the mechanics will feel familiar. Our walkthrough of the bank reconciliation process covers the basics. The card version mostly adds new ways to confuse the calendar.

Closing date vs due date, and the pending charge problem

A card statement carries two dates that matter. The statement closing date is the last day of activity included on that statement (say, the 22nd). The payment due date is when the money is owed, often three or four weeks later.

You reconcile to the closing date. Always. The ending balance you type in is the "new balance" printed on that statement. If you use the due date, or whatever balance shows when you log in today, you'll be hunting for charges that belong to next month.

Pending charges cause the same headache from the other direction. A charge from the 21st might still be pending at closing and post on the 23rd, which puts it on the next statement. Your bank feed may have already pulled it in with the earlier date. Leave it unchecked. It's a timing item, like an outstanding check, and it'll clear next month.

Payments, refunds and the weird negative balance

Three kinds of entries cause most of the trouble when people reconcile a credit card in QuickBooks.

Card payments. Paying the card from checking is a transfer between two balance sheet accounts: checking goes down, and the card liability goes down. It isn't an expense. If the payment gets categorized as "Office expenses" or some invented "Credit card expense" account, your expenses are overstated and the card balance never drops. And if the bank feed brings the payment in on both the checking side and the card side, and each gets recorded separately, it counts twice. Match the two so it's one transfer.

Refunds and credits. A vendor refund reduces what you owe. Record it as a credit card credit, coded to the same expense category as the original purchase, so the expense nets down. Coding refunds to income is a popular way for revenue to grow without any actual sales.

A debit (negative) balance on the card. A liability normally carries a credit balance. If QuickBooks shows the card below zero, either you really overpaid (it happens, and the statement will show a credit balance too) or something got doubled, like a payment entered twice. Check the statement before you assume the card company owes you money.

One card account, five cardholders

Plenty of business cards have several employee cards under one account with one statement. Keep one account in your books per statement, because that's what you reconcile against. To see who spent what, put the cardholder's name in the memo or use a class or tag, instead of creating five accounts that each have no statement to match.

Receipts matter more here, since five people means five versions of "I'll send it later." A simple receipt management system (snap it, attach it, done) saves a lot of detective work at month end.

A worked example: the $2,554.57 gap

Imagine a hypothetical six-person design studio. The March statement closes on March 22.

• Statement new balance on March 22: $4,812.33
• Card balance in QuickBooks as of March 22: $7,366.90
• Difference: $2,554.57

Here's what the reconciliation turns up:

1. A February 28 payment of $2,180.00 (it appears on this statement) was coded as an expense in checking instead of a transfer to the card, so the card balance never went down. Fix it as a transfer. Book balance now $5,186.90.
2. A $149.00 software refund is on the statement but was excluded from the feed as a "duplicate." Record it as a card credit to Software. Balance now $5,037.90.
3. A $34.43 foreign transaction fee is on the statement but not in the books. Record it. Balance now $5,072.33.
4. A $260.00 hotel charge dated March 21 is in QuickBooks but posted on March 24, so it's on the April statement. It stays unchecked. $5,072.33 minus $260.00 is $4,812.33.

The difference shows $0.00 and you click Finish now. The hotel charge waits for April. (The partner who wanted to pick a number is now very curious about that foreign transaction fee.)

A monthly credit card statement reconciliation routine

1. Download the PDF statement as soon as it closes.
2. In QuickBooks Online, open Reconcile (Settings gear, then Reconcile) and choose the card account.
3. Enter the closing date and the new balance from the statement.
4. Check off every charge, credit, fee, interest charge and payment shown on the statement.
5. Record anything on the statement that's missing from the books.
6. Leave pending and later-posting items unchecked.
7. Finish only at a $0.00 difference, then save the report with the statement.

If you've skipped a few months, start with the oldest statement and work forward one at a time. Our article on books not reconciled for months describes what usually turns up along the way.