Skip to content
Credit Card Statement Tracker cover: a sample sheet with charged, fees and paid off and a bar chart, beside the Dashboard, Activity and Statement check tabs

Credit Card Statement Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Modern
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Credit Card Statement Tracker is for people with more than one card who want to check each statement before paying. The Activity tab lists each purchase, fee and payment with its card, description and amount. The Dashboard totals charges, fees and payments and shows what is still owed across all cards and on each card.

The Statement check tab reconciles one card. Enter the card name, the statement date and the balance printed on the statement. The sheet adds up the purchases, fees and payments for that card and shows the difference. A difference of zero means the log matches the statement. Anything else is worth checking before the due date.

Useful for

  • Checking each statement before the payment date
  • Spotting fees you did not expect
  • Seeing which card carries the most balance

What's included

  • 4 tabs: Dashboard, Activity, Statement check, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Activity: a table
  • Statement check: a ready-to-fill form
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Activity tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

What if my balance is different from the statement?

Look for a purchase that has not been logged, a payment made after the statement date, or a refund that was not entered. Add the missing line to the Activity tab and the check updates on its own.

How do I record a refund?

This template uses three types: Purchase, Fee and Payment. Enter a refund as a Payment, so the amount owed drops by the same figure. The Payments total then includes it, and the card's balance follows.

Can I track more than two cards?

Yes. Add the card name to the Card list on the Activity tab, then list it in the Balance by card breakdown on the Dashboard as well. Use the same spelling in both places so its figures are counted.

  • #expense-tracker
  • #credit-card-expense-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More expense tracker templates

See all 14

Also in Finance

All finance templates
Get this template

Preparing your template…