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:
- Who has makeup credits right now, and how many?
- When does each credit expire?
- Which credits were used, and on what date?
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:
- What earns a credit? For example, absences with 24 hours' notice, teacher cancellations or illness.
- What doesn't earn a credit? For example, no-shows or same-day cancellations for non-illness reasons.
- How long is a credit valid? Common choices are 30 days, 60 days or the end of the current term.
- 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.
- Create a new page called Studio.
- Add a database in full-page or inline view and name it Students.
- Add these properties:
- Name (Title)
- Parent/Guardian (Text)
- Instrument (Select: Piano, Voice, Violin, and so on)
- Lesson Day (Select: Mon to Sat)
- Status (Select: Active, Paused, Former)
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:
- Credit (Title): a short label such as "Missed 3/12 – sick"
- Student (Relation → Students)
- Reason (Select: Student illness, Family conflict, Teacher cancelled, Weather, Other)
- Missed Lesson Date (Date)
- Issued (Date)
- Expires (Date)
- Status (Select: Available, Scheduled, Used, Expired, Forfeited)
- Makeup Date (Date): fill this in once the makeup is booked or done
- Notes (Text)
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.
- In Makeup Credits, add a Formula property called Is Available that returns 1 or 0:
if(prop("Status") == "Available", 1, 0)
- In Students, add a Rollup property called Credits Available:
- Relation: Makeup Credits
- Property: Is Available
- Calculate: Sum
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):
- Open Credits: Table, filtered to Status is Available or Scheduled, sorted by Expires ascending. This is your main working view.
- 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.
- Scheduled Makeups: Calendar view by Makeup Date, filtered to Status is Scheduled. It shows makeups next to your regular week.
- History: Filter Status is Used, Expired or Forfeited. This is your record if a family later asks about a past credit.
- 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:
- Log new absences. Add one row per qualifying missed lesson with Status set to Available.
- Mark completed makeups. Change Status from Scheduled to Used and confirm the Makeup Date.
- Check Expiring Soon. Message those families with a reminder and a few open slots.
- 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
- Lessons missed with at least [24/48] hours' notice for [illness / family emergency / school event] earn one makeup credit.
- No-shows and cancellations with less than [24/48] hours' notice [do not earn a credit / earn a credit only for illness].
- If I cancel a lesson, you will receive a makeup credit or a [refund / tuition credit].
- Makeup credits are valid for [60 days / until the end of the current term] and are not refundable or transferable.
- Each student may hold up to [2] makeup credits per [term / semester].
- Makeups are scheduled from my open slots, which I share [monthly / on request]. Makeup times may differ from your regular lesson time.
- If a scheduled makeup is missed, the credit is [used / forfeited].
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
- Keeping a single "credits" number on the student. You lose the reason and the dates, and you can't settle disagreements.
- Deleting used or expired credits. Keep them all and filter them out of daily views instead.
- No expiry date. Without one, credits pile up and become a scheduling debt you can't pay off.
- Tracking makeups separately from your lesson notes. If you also keep a Lesson Log in Notion, relate it to Students too. Then one student page shows notes, credits and history together.
Quick setup checklist
- [ ] Makeup rules written down (what earns a credit, validity, cap)
- [ ] Students database created
- [ ] Makeup Credits database created, one row per credit
- [ ] Two-way relation between Students and Makeup Credits
- [ ] Is Available formula plus Credits Available rollup
- [ ] Open Credits, Expiring Soon, Scheduled, History views
- [ ] Linked Open Credits view on your Studio dashboard
- [ ] Policy updated and shared with families
- [ ] Weekly 5-minute review on your calendar
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.
Browse the Quillwork shop