How to Track Piano Lesson Tuition Payments in Notion (Step-by-Step)
Build a simple Notion tuition tracker for your private music studio that shows who has paid, who still owes and which families are overdue. It includes exact property names, copy-paste formulas, a worked example and a monthly checklist.
If you teach privately, you probably know this question well: "Did the Martins pay for October?" The answer ends up spread across a banking app, a text thread and a sticky note. Notion can hold all of it in one place for free, but only if you set it up so it answers that question in a few seconds.
This guide walks you through a tuition tracker with two linked databases. One holds families. The other holds charges and payments. At the end you'll have a view of every unpaid charge, a running balance for each family and a 15-minute monthly routine.
One note first: this tracker records what was billed and paid. It's not accounting software, and it gives no tax advice. If you need records for tax purposes, ask an accountant what they need from you.
What you'll build
- Families: one row per paying household. Siblings share a row, because one parent usually pays for all of them.
- Tuition: one row per charge, such as "October tuition, Ava" or "Recital fee, Leo". You record payment details on the same row.
- A relation between the two, so every family row shows its total balance automatically.
- Three saved views: Unpaid, By Family and This Month.
Step 1: Create the Families database
Make a new page called "Studio Tuition", type /database, and pick a full-page table. Name it Families and add these properties:
- Family name (Title), for example "Martin family"
- Billing contact (Text), the parent who pays
- Email (Email) and Phone (Phone)
- Students (Text), first names, for example "Ava, Leo"
- Usual method (Select) with options such as Bank transfer, Card, Cash, Cheque or Check, and Payment app
- Notes (Text), for things like "pays on the 1st" or "prefers email reminders"
Use the parent's details, not the child's. You'll contact parents about money, so keep the child's information in your student records instead.
Step 2: Create the Tuition database
Make a second full-page table called Tuition with these properties:
- Charge (Title), for example "Oct 2026 – Ava"
- Family (Relation to Families). When Notion asks, turn on Show on Families, which makes the link two-way.
- Type (Select): Monthly tuition, Term tuition, Single lesson, Registration fee, Recital fee, Books/materials, Late fee
- Period (Text), for example "Oct 2026" or "Autumn term"
- Amount due (Number, formatted as your currency)
- Amount paid (Number, same format)
- Due date (Date)
- Paid date (Date)
- Method (Select, with the same options as Usual method)
- Reference (Text), a transfer reference, cheque number or receipt number
Why two amount fields instead of one "Paid" checkbox? Partial payments happen. A family pays half now and half on Friday, and a checkbox can't show that.
Step 3: Add the formulas
In the Tuition database, add a property called Balance and set its type to Formula. Paste this in:
prop("Amount due") - prop("Amount paid")
Then add a second formula property called Status:
if(prop("Balance") <= 0, "Paid", if(dateBefore(prop("Due date"), now()), "Overdue", "Open"))
Status now updates by itself. A charge reads "Open" until its due date passes, "Overdue" after that if money is still owed, and "Paid" once Amount paid matches Amount due. If someone overpays, Balance goes negative and Status still shows "Paid". The negative number tells you there's a credit to carry forward.
Step 4: Show each family's balance
Open the Families database. You'll see a Tuition column that the two-way relation created. Now add a property called Owed and set its type to Rollup:
- Relation: Tuition
- Property: Balance
- Calculate: Sum
Each family row now shows the total it owes across all charges. Sort Families by Owed, highest first, and the families you need to follow up with sit at the top.
Step 5: Set up three views
Views are saved filters. You set them up once and click between them.
- Unpaid: a table view of Tuition with the filter "Status is not Paid", sorted by Due date ascending. You'll check this one most often.
- By Family: a table view of Tuition grouped by Family, so each household's history sits together. It's handy when a parent asks, "What have we paid this year?"
- This Month: a calendar view of Tuition by Due date. It shows what's coming in and when.
Optional: add a board view grouped by Status, with columns for Open, Overdue and Paid. Some teachers find a board easier to scan than a table.
Step 6: Your monthly routine (about 15 minutes)
Use this checklist each billing cycle.
- Create the charges. Add one Tuition row per student. Tip: in a view grouped by Family, duplicate last month's rows and change Period, Due date and Charge name. Clear Amount paid, Paid date, Method and Reference on the copies.
- Send invoices or reminders however you normally do. Notion won't email anyone for you.
- Record payments as they arrive. Fill in Amount paid, Paid date, Method and Reference. Enter the amount actually received, not the amount you expected.
- Check the Unpaid view a few days after the due date. Anything marked Overdue gets one polite reminder.
- Note any credits. If Balance is negative, add a row next month with a negative Amount due (for example, -20) and the Type "Credit", or simply lower the next charge. Pick one method and stick with it.
- Lock the past. Once a month is fully paid, leave it alone. Fixing old records is how mistakes creep in.
Worked example
Here's a made-up family to show how the rows work. The Martin family has two students, Ava and Leo, and tuition is billed monthly.
October tuition, due 1 Oct:
- "Oct 2026 – Ava": Amount due 140, Amount paid 140. Balance 0, Status Paid.
- "Oct 2026 – Leo": Amount due 140, Amount paid 70. Balance 70, Status Overdue once 1 Oct has passed.
- "Recital fee – Leo": Amount due 25, Amount paid 0. Due 15 Oct, so Status stays Open until then.
On the Families page, the Martin family's Owed rollup shows 95, which is 70 + 25 + 0. You can see what's outstanding without opening a single payment app.
When the second 70 for Leo arrives, change his Amount paid to 140. Don't add a new row. Status switches to Paid and Owed drops to 25.
Common mistakes to avoid
- One row per family per month. It seems simpler, but you lose track when one sibling stops lessons or starts halfway through a term. Use one row per student per charge.
- Typing the family name instead of using the relation. Typed names don't roll up, and a typo like "Martin" against "Martins" splits the record in two.
- Deleting paid rows to tidy up. Hide them with the Unpaid filter instead. Your history is your proof if a payment is ever disputed.
- Mixing makeup-lesson credits into tuition. A missed lesson owed back is a lesson credit, not money. Track it separately from tuition unless your written policy says credits turn into refunds.
- No written payment policy. The tracker shows who is late, but your studio policy says what happens next. Put your due date and late-fee rules in writing so families see them before they enrol.
Quick setup checklist
- Families database with Billing contact, Students and Usual method
- Tuition database with Amount due, Amount paid, Due date, Paid date, Method and Reference
- Two-way relation between Tuition and Families
- Balance and Status formulas pasted in
- Owed rollup (Sum of Balance) on Families
- Unpaid, By Family and This Month views saved
- Monthly routine added to your calendar
Once it's built, you can answer "Did they pay?" in a few seconds. It costs nothing beyond your Notion account, and you don't need a monthly studio-software subscription.
StudioBook: Notion Studio Manager for Private Piano and Music Teachers · $14.00
Get it on Gumroad