Templates / Credit card reconciliation
Credit Card Reconciliation Template
The same row-per-transaction approach, adapted for a card statement and an expense ledger.
What it is
A credit card reconciliation template lines up every charge on a card statement against the expense entry recorded for it, the same way a bank reconciliation lines up a bank statement against a cash ledger. The wrinkle with cards is sign convention and cadence: charges usually post as positive numbers on the statement (money the cardholder owes), and the statement period often runs on its own cycle rather than the calendar month, so dates won't line up as neatly as they do with a checking account.
The other difference is what "unmatched" usually means. On a bank account, an unmatched line is often a timing difference. On a card statement, an unmatched charge is more often a missing receipt or an unclear business purpose, which is a bookkeeping and expense-policy problem as much as a reconciliation one. Building that into the template, with a notes column for "awaiting receipt" or "needs approval," keeps the review honest.
Use one sheet per card per statement period. If a business runs several cards, reconciling them separately makes it easier to trace a discrepancy back to a specific cardholder.
Columns
| Column | What it holds |
|---|---|
| Date | Transaction date as posted on the card statement. |
| Description | Merchant name or the statement's description text. |
| Reference | Authorization or transaction ID, if the statement provides one. |
| Amount | Charge amount, positive for spend, negative for refunds and credits. |
| Matched (Y/N) | Whether the charge has a corresponding expense entry. |
| Notes | Missing receipt, disputed charge, or which ledger entry it matches. |
How to use it
- 1.Download the statement CSV for the closing period from the card issuer's portal.
- 2.Load each charge into a row, keeping refunds and credits as negative amounts.
- 3.Match each charge against the expense recorded in your books, using amount and merchant name.
- 4.Flag anything without a receipt or clear business purpose in the notes column instead of marking it matched.
- 5.Reconcile the statement balance to the ledger's card liability account once every charge is accounted for.
- 6.Carry forward any charge that posts after your books close to next period's sheet.
Skip the spreadsheet
A spreadsheet works, but it doesn't match lines for you or remember what you did last month.