Skip to content
Receipt Tracker cover: a sample sheet with receipts logged, total spent and waiting to claim and a doughnut chart, beside the Dashboard and Receipts tabs

Receipt Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (4)

Overview

The Receipt Tracker suits freelancers, small business owners and anyone who keeps paper slips for returns or claims. The Receipts tab records the date, store, category, amount, tax, return-by date, claim status and whether a scan is saved. The Dashboard counts receipts, adds up spending, shows the value waiting to be claimed and breaks the total down by status and by category.

Start by logging a receipt the day you get it, while the store's return policy is fresh in mind. Tick Scanned once the photo is stored in a folder you can find. Rows with a return date that has passed and a status of To claim turn red, so you can act before the window closes. Delete the sample entries but leave the empty rows ready for your next batch of receipts.

Useful for

  • Tracking receipts for a reimbursement or tax claim
  • Keeping track of items you may need to return
  • Checking which receipts have no scanned copy

What's included

  • 3 tabs: Dashboard, Receipts, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Receipts: 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

What should I do with receipts that have no scan?

Photograph each one as soon as you log it and save the picture in a folder named by month. Tick the Scanned box when the copy is safe. The Scanned count on the Dashboard shows how many are still missing a copy.

How do I know when a receipt must be returned?

Type the last day of the store's return window into the Return by column. Rows whose date has passed while still marked To claim turn red. Check the store's own policy, since windows differ by store and by item.

Can the tracker hold receipts for more than one trip or project?

Yes. Use the Category column to mark each project, or add a trip name to the Store column. The category breakdown on the Dashboard then shows each group's total, and you can filter the list for one project at a time.

  • #expense-tracker
  • #receipt-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…