How to Track Makeup Lessons for a Piano Studio in Notion

A step-by-step setup for a makeup lesson tracker in Notion that shows each student's credits, expiry dates and unused balance. It includes the database fields, a formula, a policy template and a worked example.

Makeup lessons are hard to track in a private studio. A student misses a lesson, you offer a makeup, and three months later nobody can remember whether that credit was used, whether it expired or whether there were two of them. A tracker fixes this when it answers three questions quickly:

This guide builds that tracker in Notion with the free plan's features: two databases, one relation, one rollup, one formula and a few filtered views. It takes about 30 minutes to set up. You'll also find a fill-in makeup policy and a worked example at the end.

Before you build: decide your rules

The tracker can only enforce rules you've written down. Settle these four first:

  1. What earns a credit? For example, absences with 24 hours' notice, teacher cancellations or illness.
  2. What doesn't earn a credit? For example, no-shows or same-day cancellations for non-illness reasons.
  3. How long is a credit valid? Common choices are 30 days, 60 days or the end of the current term.
  4. Is there a cap? For example, a maximum of 2 makeup credits per term.

Write your answers down. You'll turn them into the policy template below and use them as field options.

Step 1: Create a Students database

If you already have a student list in Notion, use it and skip to Step 2.

  1. Create a new page called Studio.
  2. Add a database in full-page or inline view and name it Students.
  3. Add these properties:

Leave out anything you don't actually use. Fewer fields means you're more likely to keep it up to date.

Step 2: Create a Makeup Credits database

Each row is one credit, not one student. This is the most important design choice in the whole setup. A row per credit gives every credit its own reason, issue date, expiry date and outcome, so nothing gets lost in a running total.

Create a second database called Makeup Credits with these properties:

When you create the Student relation, Notion asks whether to show it on the related database too. Turn that on. Each student's page then gets a "Makeup Credits" property that lists all their credits.

Optional: auto-calculate expiry. Instead of typing the Expires date, make Expires a Formula property:

dateAdd(prop("Issued"), 60, "days")

Change 60 to your validity period. If credits expire at the end of a term instead, keep Expires as a plain Date field and enter the term end date.

Step 3: Add an "Available credits" count to each student

You want each student's page to show how many usable credits they have.

  1. In Makeup Credits, add a Formula property called Is Available that returns 1 or 0:

if(prop("Status") == "Available", 1, 0)

  1. In Students, add a Rollup property called Credits Available:

Every student row now shows a number, such as 0, 1 or 2. When you change a credit's Status from Available to Used, the number updates by itself.

If you also cap credits per term, add a second rollup called Credits This Term. It counts all credits with Calculate set to "Count all". Then compare it to your cap by eye or with a simple formula.

Step 4: Build the views you'll actually open

In the Makeup Credits database, create these views (use the "+" next to the view tabs):

  1. Open Credits: Table, filtered to Status is Available or Scheduled, sorted by Expires ascending. This is your main working view.
  2. Expiring Soon: Filter Status is Available AND Expires is within the next 2 weeks (use Notion's relative date filter). Check it weekly so you can remind families before a credit lapses.
  3. Scheduled Makeups: Calendar view by Makeup Date, filtered to Status is Scheduled. It shows makeups next to your regular week.
  4. History: Filter Status is Used, Expired or Forfeited. This is your record if a family later asks about a past credit.
  5. By Student: Board view grouped by Student, or a table grouped by Student.

On your main Studio page, add a linked view of "Open Credits" (type /linked and pick the database). You'll see open credits without opening the full database.

Step 5: The weekly 5-minute routine

A tracker is only as good as its habits. Once a week:

  1. Log new absences. Add one row per qualifying missed lesson with Status set to Available.
  2. Mark completed makeups. Change Status from Scheduled to Used and confirm the Makeup Date.
  3. Check Expiring Soon. Message those families with a reminder and a few open slots.
  4. Expire old credits. Anything past its Expires date that's still Available becomes Expired. Don't delete rows, because the history protects you.

If you'd rather expire credits automatically in the view instead of by hand, add a formula called Past Due:

if(prop("Status") == "Available" and now() > prop("Expires"), "Expired – update", "")

Filter a view on Past Due is not empty. It shows you which rows need their Status changed.

Fill-in template: makeup lesson policy

Paste this into your studio policy and fill in the blanks. It's a plain-language starting point, not legal advice, so adjust it to your situation and local rules.

Makeup Lessons

Every bracket here matches a field or rule in your tracker, so what you promise families and what you record stay consistent.

Worked example

Suppose a studio uses 60-day credits with a cap of 2 per term.

Student: Maya (Piano, Tuesdays)

| Credit | Reason | Issued | Expires | Status | Makeup Date | |---|---|---|---|---|---| | Missed 2/4 – sick | Student illness | Feb 4 | Apr 5 | Used | Feb 15 | | Missed 3/11 – school trip | Family conflict | Mar 11 | May 10 | Available | |

Maya's Credits Available rollup shows 1. In late April, the Expiring Soon view lists her Mar 11 credit, so the teacher sends a reminder with three open slots. Maya books one, the teacher sets Status to Scheduled and enters the Makeup Date, and it appears on the Scheduled Makeups calendar. After the lesson, Status becomes Used and her count drops to 0.

If Maya's family asks in June how many makeups she had this term, the History view answers in seconds: two credits, both used, with dates.

Common mistakes to avoid

Quick setup checklist

Once this is running, questions about makeup lessons take seconds to answer, and you don't have to rebuild the record from memory each time a family asks.

More templates and kits
Browse the Quillwork shop