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

Education Expense Tracker

Spreadsheet template for Google Sheets and Excel

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

Every slide (5)

Overview

Families with a student in college, a trade program or graduate school use this education expense tracker to see what a year of schooling really cost. The Students tab lists each person and school and tracks the 1098-T form. The Expenses tab holds each bill as a row with the type, who paid it and a receipt flag. The Dashboard totals costs per student and per type and separates what you paid from what a grant or plan covered.

Log bookstore, fee and tuition payments as they happen, since a school's account statement may not show everything. When the 1098-T arrives, type the box 1 amount on the Students tab and compare it with your tuition rows. Differences are normal because of timing, so keep your own records. Credits and deductions depend on current IRS rules, so check with a tax professional.

Useful for

  • Compare your payments with the school's 1098-T
  • See how much a grant or savings plan covered each term
  • Keep bookstore and fee receipts together for each student

What's included

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

Which education papers should I save?

Keep the school's billing statements, receipts for books and required supplies, proof of payment and the 1098-T when you get one. This sheet keeps the figures together and points out any missing receipts.

Why does my 1098-T not match what I paid?

Timing is a common reason. A school may report amounts billed or paid in a different year than you did. Keep your own log, note the difference in the description and ask the school's billing office if the gap is large.

How do I track scholarship money?

Add a row for the amount and pick 'Scholarship or grant' as the payment source. It counts in the total cost but not in your out-of-pocket column. Ask a tax professional how it affects your return.

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

Also in Finance

All finance templates
Get this template

Preparing your template…