Skip to content
The title slide and first slides of the Coupon Savings Tracker template

Coupon Savings Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Coupons feel like savings, but only a record proves it. Each Receipts row holds the regular price of the cart, the amount you paid and a note. The sheet works out the dollars saved and the savings rate for every trip. The Coupons tab lists each coupon with its type, value, expiry date and status, which makes it clear whether each is Active, Used or Expired.

The Savings tab adds the total saved, the overall savings rate, coupons used and waiting, plus a chart of regular price against paid by store type. A second chart shows the value redeemed by coupon type: paper, digital, store loyalty, promo code and rebate. Ten sample trips show how it fills in.

Useful for

  • See how much couponing really saves in a month
  • Spot coupons that expired unused
  • Compare savings rates between a grocery store and a drugstore

What's included

  • 4 tabs: Savings, Receipts, Coupons, How to use
  • Savings: a dashboard with 4 summary figures
  • Receipts: a table
  • Coupons: a table
  • 2 charts 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 Receipts 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

How do I track coupon savings?

Write the regular price of the cart and the amount paid after sales and coupons on each trip. The difference is your saving, and the rate shows it as a share of the regular price.

What counts as a coupon saving?

Count the savings that changed what you bought or paid. A discount you would never have used is not a saving. Keep your own rule and apply it every time.

Can I track digital coupons and rebates?

Yes. The Coupons tab has types for paper, digital, store loyalty, promo codes and rebates, with a status for Active, Used or Expired.

  • #tracker
  • #coupon-savings-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tracker templates

See all 33

Also in Finance

All finance templates
Get this template

Preparing your template…