Your credit card’s opening balance won’t reconcile. Here’s why, and how to fix it.

You open the credit card reconciliation and the numbers are wrong before you have ticked a single charge. The opening balance QuickBooks shows doesn't match the statement, and nothing in this month will fix it, because the problem is in where the account started.

Credit cards go wrong at the start in more ways than bank accounts do. Here are the five usual causes, how to tell which one you have, and how to fix each without burying it.

Why credit cards are different

Three things make a card account trickier than a checking account:

• It is a balance you owe. The opening balance is a liability, so it can be entered in the wrong direction.
• The statement closes on a cycle date, often mid-month, not on the last day of the month.
• It is often fed twice. The payment that leaves your bank account and the payment that reaches the card can both arrive through bank feeds.

The five usual causes

1. The balance was entered for the wrong date

The opening balance has to be what you owed on the day before the first transaction you track. A figure from the end of the month, or from the latest statement you had to hand, won't match.

How to spot it: the difference equals the charges and payments between the date you used and the right one.

2. It was entered in the wrong direction

The balance was recorded as a payment or credit rather than an amount owed, so the card starts out looking like it owes you money.

How to spot it: the difference is exactly twice the opening balance.

3. The feed pulled in transactions from before the start date

When a card is connected, the bank feed can download history from before the opening balance date. Those charges are already inside the opening balance, so they are now counted twice.

How to spot it: card transactions in the register dated before the opening balance date.

4. The statement period doesn't match

The statement closed on the 17th; you compared it with a balance at the 31st, or the other way round.

How to spot it: the difference is the charges and payments between the two dates.

5. Card payments recorded twice

The payment came through the bank feed as a transfer to the card, and again through the card feed as a payment received. Both were accepted.

How to spot it: pairs of payments with the same amount, a day or two apart, in the card register.

Fix each one on its own terms

A wrong date or wrong direction is corrected at the source: edit the opening balance entry to the right amount, as a balance owed, on the right date, using the statement as the evidence.

Pre-start transactions are excluded or deleted from the card register, not the opening balance changed to absorb them.

A period mismatch fixes itself once you reconcile against the statement's own closing date.

Duplicate payments are reduced to one, recorded as a transfer between the bank account and the card, so both accounts are right.

Whatever the cause, don't change the opening balance to swallow a difference that came from somewhere else. The offset lands in Opening Balance Equity, where it misstates the balance sheet until someone goes looking. If the bank account's beginning balance is wrong too, the bank version of this problem has its own four causes.

When it's a bigger problem

Fix it yourself when one of the five causes clearly explains the difference. Get help when the difference is large, when it goes back several statements, or when the card has been reconciled before with adjusting entries, because then the opening balance is only where the problem shows.

A credit card reconciliation engagement reconciles the card statement by statement from a point that actually tied. Where several accounts and months are involved, it is usually scoped as a QuickBooks cleanup instead: one-time, fixed fee, quoted in writing before any work starts.

TechBrot does the operational bookkeeping and hands your CPA a file they can file from.