Credit Card Statement Reconciliation From Source to Books

Worked control: close a card balance without a plug

Now imagine the issuer prints 2,094 instead. The 45 difference is an exception, not permission to post a 45 adjustment. Search for a row with that amount, a transposed digit, a credit entered as a debit, a payment returned elsewhere, or an installment balance presented outside the ordinary purchase summary. Check page continuations and statement notices before looking beyond the document.

A reconciliation schedule should show the printed opening amount, each movement class, calculated closing amount, issuer closing amount, variance, evidence reference, owner, status, and next action. Timing items need an expected clearing date and later proof. Errors need correction evidence. Unknown items remain open. Two unsupported errors that offset to zero do not become a valid reconciliation simply because the final column agrees.

Close the work only when each difference has its own supported explanation and the adjusted bridge agrees under a documented rule. Retain the source statement, workpaper version, reviewer, completion time, and any accounting entry created from the result. If the issuer later reissues the statement, preserve both versions and rerun the controls rather than overwriting the evidence that supported the earlier close.

Age open items from the date of the underlying event, not the latest review. A payment still outstanding after several cycles may be stale, cancelled, misrouted, or cleared elsewhere. The schedule should keep original amount, expected clearance, payee or source, last evidence, owner, next deadline, and final disposition. Rolling an unexplained item forward without that history turns a timing difference into permanent clutter.

Review reconciliation access and retention as well as arithmetic. The workpaper can expose merchant activity, account suffixes, internal codes, and staff notes that the recipient does not need. Protect the issuer original, share the minimum necessary schedule, and retain the version that supported any posted entry. Reconciliation is strongest when the numbers close, exceptions are evidenced, and the record can be retrieved without distributing an entire private card history.

If the ledger and issuer total still differ, work through why a credit card statement balance does not match before recording any adjustment.

Use the credit card statement CSV converter when the bookkeeping destination needs reviewed rows rather than workbook formulas.