What to do when your business credit card balance and QuickBooks don't agree

A credit card account off by $3,400 is almost never a math error. Here is where the difference goes and how to close it in QuickBooks.

A marketing agency owner we work with has managed their own QuickBooks for three years. In March, they sat down to close the quarter and found a problem they could not account for. Their American Express business card statement showed a balance of $14,200. QuickBooks showed $10,800 for the same account. The gap was $3,400 and none of it came from charges they did not recognize.

When we reviewed the account, the $3,400 traced to four sources: seven duplicate bank feed entries ($1,247), three vendor refunds posted to income instead of the card account ($890), the card’s annual fee that the bank feed had not imported ($450), and two charges from an international vendor the feed had never picked up ($813). Nothing was fraudulent. All of it was a bookkeeping workflow problem.

Why credit card accounts drift in QuickBooks

Credit card accounts are the most error-prone accounts in most small business QuickBooks files. Not because credit card charges are complicated, but because of how QuickBooks imports them. The automatic bank feed handles most transactions correctly. It does not handle duplicates, refunds, missed imports, or statement fees reliably. A business owner who reviews the bank feed regularly may assume the books are current. The account can be off by thousands without a visible signal until reconciliation is attempted.

Four problems cause most of the drift.

Duplicate entries from the bank feed. If a charge is entered manually before the bank feed imports it, QuickBooks can create two entries for the same transaction. The duplicate may sit in the For Review queue or be added directly to the register. Either way, the QuickBooks balance reads lower than the actual statement. Seven of the eight duplicates in the agency’s account appeared in months where charges were entered manually before the feed caught up.

Vendor refunds and credits posted to income. When a vendor reverses a charge or a disputed transaction is resolved, the credit returns to the card. QuickBooks sometimes categorizes these credits as income if it does not recognize the payee name. The result is that the refund appears in the Profit and Loss report (P&L) as revenue instead of reducing the card balance. The statement accounts for the credit. The books do not.

Charges the bank feed never imports. Not every charge comes through the automatic bank feed. International vendors, certain payment processors, and some subscription platforms are not consistently recognized. The card is charged. The charge clears the statement. QuickBooks never sees it.

Interest and fees not categorized at close. Credit card interest, annual fees, and foreign transaction fees appear on the statement each month. They are not always present in the bank feed with a recognizable payee. When they do not auto-populate, they are skipped during the monthly review. Over twelve months, the annual fee alone adds up to a real discrepancy.

What the gap looked like in the books

Here is how the $3,400 difference broke down for the marketing agency:

Source of gap	Amount
Duplicate bank feed entries (7 transactions)	$1,247
Vendor refunds posted to income instead of card account	$890
Annual card fee not imported by the bank feed	$450
International charges the feed never picked up	$813
Total difference	$3,400

None of the charges were unauthorized. The card had been spent correctly. The books were simply not recording the same transactions the statement was.

Why this matters

The P&L report was wrong. Duplicate entries had inflated expenses by $1,247. Refunds posted to income had added $890 to revenue that did not belong there. A P&L with those errors overstates revenue, misrepresents gross margin, and gives the owner incorrect net income. If those numbers are being used to decide whether to hire, how much to spend on advertising, or when to take an owner distribution, the decisions are based on incorrect data.

The balance sheet was also wrong. A credit card account is a liability. If the liability shows $10,800 when the actual balance owed is $14,200, the business appears $3,400 more solvent than it is. For an owner who monitors working capital, that gap matters at the end of every month.

What a clean credit card reconciliation looks like

For clients we work with, credit card accounts are reconciled once per month against the official card statement. Every charge on the statement is matched to an entry in QuickBooks. Every refund is verified to be posted as a credit against the card liability account rather than to income. The ending balance in QuickBooks matches the statement ending balance to the dollar before the month closes.

The QuickBooks reconciliation tool shows a running difference as entries are matched. When the difference reaches zero, the reconciliation is complete. The finished record is saved with the statement attached as a PDF. That documentation is what a bookkeeper, accountant, or auditor expects to find if they ever review the account.

Best practices for business credit card accounts

Practices that prevent the drift from accumulating:

Reconcile the credit card account every month against the official card statement, not just against what the bank feed imports. The bank feed is a starting point, not a reconciliation.
Before adding any bank feed import, check the For Review tab against the existing register. Exclude any entry already recorded rather than adding it again.
Create a dedicated expense account for card fees, annual fees, and foreign transaction fees so they can be added manually when the feed does not import them.
Record vendor credits and disputed-charge reversals as credits against the credit card liability account, not as income.
Attach the PDF statement to each completed reconciliation in QuickBooks. A saved reconciliation without source documentation is difficult to verify and difficult to audit.

Three questions worth asking

If you are not sure whether your credit card reconciliation is current, three questions to ask whoever manages your books:

When was the last time the credit card account in QuickBooks was reconciled against the actual card statement, and does the ending balance match the statement to the dollar?
Are there any entries in the For Review tab older than 30 days that have not been categorized or excluded?
Where do vendor credits and disputed-charge reversals appear in the books, and have any of them been posted to income accounts where they do not belong?

If those answers are uncertain, the account likely has a gap that has been accumulating for months. The reconciliation process described here clears it. For most accounts unreconciled for a full quarter, one to two hours brings the balance current.

If you would like a second set of eyes, send us a recent statement. We will identify where the difference is coming from and what it takes to bring the account current.