Skip to content
The title slide and first slides of the Teacher Classroom Expense Tracker template

Teacher Classroom Expense Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
6
Difficulty
Beginner
Updated
November 15, 2026

Every slide (6)

Overview

Teachers use this classroom expense tracker to keep one list of everything they buy for the room. The Purchases tab holds the store, what you bought, the school year, a category, the amount spent, any amount the school paid back and a receipt flag. The Year Check tab compares your own costs with a limit that you type in after checking the IRS site. The Wish List tab keeps planned purchases with a priority. The Dashboard sums spending for each category.

Add a row when you leave the store and photograph the receipt before it fades. Use the paid back column whenever the school, a grant or a parent group reimburses you, so your own cost stays accurate. Look up the current educator limit yourself and update the Year Check each fall. Ask a tax professional whether the purchases qualify, since rules differ by situation.

Useful for

  • Total supplies you paid for yourself this school year
  • Compare your costs with the limit you looked up
  • Plan the next round of classroom purchases

What's included

  • 5 tabs: Dashboard, Purchases, Year Check, Wish List, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Purchases: a table
  • Year Check: a table
  • Wish List: a table
  • 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 Purchases 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 records do teachers need for classroom expenses?

Keep receipts or card statements showing the store, date and amount, plus a brief note about the purpose of each item. A list like the Purchases tab with saved receipts gives a preparer what they need.

How do I track supplies the school paid me back for?

Type the reimbursement in the Paid back column on the same row. Your own cost is then the amount spent minus what was paid back, so only your out-of-pocket total is compared with the limit.

Where do I find the educator expense limit?

Look on the IRS website for the figure for the tax year, and type it in the Limit column on Year Check. The limit changes over time, so this sheet leaves it for you to enter.

  • #tax-tracker
  • #teacher-classroom-expense-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

Also in Finance

All finance templates
Get this template

Preparing your template…