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

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:

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:

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:

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.

  1. 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.
  2. 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?"
  3. 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.

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:

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

Quick setup checklist

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.

Want the full done-for-you kit?
StudioBook: Notion Studio Manager for Private Piano and Music Teachers · $14.00
Get it on Gumroad