SpreadsheetBank ReconciliationFree
Credit Card Reconciliation
Match statement lines to receipts and ledger entries, with unmatched items and the reconciled balance.
Shown with sample data
Colour
Credit Card Reconciliation
Match statement lines to receipts and ledger entries, with unmatched items and the reconciled balance.
- Statement total
- $992.14
- Difference to statement
- $0
- Should be zero
- Open items
- 3
- Open amount
- $147.14
Latest: -$86.40
How to use it
- 1Enter the statement closing balance on the Settings sheet.
- 2Paste the statement lines into the sheet.
- 3Mark each line when the receipt is on file and it is posted to the ledger.
- 4Chase cardholders for anything still Open.
In this workbook
About this template
Make sure every card charge is explained. Paste in the statement lines, tag each with its expense category and tick it when you have the receipt and it is in the books; the sheet shows what is still unmatched and reconciles the total to the statement balance.
Who it’s for
- Monthly company card statements
- Shared team cards
- Catching duplicate or unknown charges
What’s included
- Statement lines sheet: Each line on the statement.
- Settings sheet: From the card statement.
How to use it
- 1Enter the statement closing balance on the Settings sheet.
- 2Paste the statement lines into the sheet.
- 3Mark each line when the receipt is on file and it is posted to the ledger.
- 4Chase cardholders for anything still Open.
Details
- Format
- Spreadsheet
- Category
- Bank Reconciliation
- Sheets
- 2
- Setup
- 10 min
- Level
- Beginner
- Price
- Free
Download a copy
Downloads need a free account.