Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceAccounting & BookkeepingBank ReconciliationCredit Card Reconciliation

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
Amount over time
Oct 3, 2026Oct 26, 2026

Latest: -$86.40

How to use it

  1. 1Enter the statement closing balance on the Settings sheet.
  2. 2Paste the statement lines into the sheet.
  3. 3Mark each line when the receipt is on file and it is posted to the ledger.
  4. 4Chase cardholders for anything still Open.

In this workbook

  • About
  • What’s included
  • How to use

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

  1. 1Enter the statement closing balance on the Settings sheet.
  2. 2Paste the statement lines into the sheet.
  3. 3Mark each line when the receipt is on file and it is posted to the ledger.
  4. 4Chase cardholders for anything still Open.
Related searchescredit card reconciliationcard statementexpense matchingcorporate cardbookkeeping

Details

Format
Spreadsheet
Category
Bank Reconciliation
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBank ReconciliationFree

Credit Card Reconciliation

Match statement lines to receipts and ledger entries, with unmatched items and the reconciled balance.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Bank Reconciliation
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ