Skip to content
The title slide and first slides of the Tuition Payment Plan Tracker template

Tuition Payment Plan 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

Many schools let families spread tuition across monthly installments. The Terms tab holds every term with its tuition and fees, grants and aid, any plan fee and the number of installments. The sheet works out the total to pay and the amount of each installment. The Payments tab lists every installment with its date, term, number, method and a status of Paid, Scheduled or Late.

The Balance tab shows the total to pay, what has been paid, the balance left plus any late installments, with a chart of the total against the paid amount for each term. Sample entries show a fall term nearly paid, with a late final installment, and spring and summer terms still scheduled. Swap them for the plan your school bursar gave you.

Useful for

  • Budget tuition for a whole school year
  • Catch a missed installment before fees are added
  • Show a parent or student what is left to pay

What's included

  • 4 tabs: Terms, Payments, Balance, How to use
  • Terms: a table
  • Payments: a table
  • Balance: a dashboard with 4 summary figures
  • 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 Terms 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 tuition payments?

List each term with its total, then add one row per installment with the date and amount. Mark each Paid when it clears and the Balance tab shows what remains.

Does the sheet include financial aid?

Yes. Enter grants and aid for each term and the total to pay is tuition minus aid plus any plan fee.

What if the school changes the amount?

Update the Terms row, then change the affected installment amounts on the Payments tab to match the new schedule.

  • #bill-tracker
  • #tuition-payment-plan-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bill tracker templates

See all 13

Also in Finance

All finance templates
Get this template

Preparing your template…