Student Payment Tracker

Music lesson tuition ledger — track each student's monthly fee, attendance, and payments. Outstanding balances are highlighted automatically. Everything stays in your browser; nothing is sent to a server.

🔒 100% offline — data stored in your browser only

Overview

0
Students
$0.00
Outstanding
$0.00
Collected
0
Lessons Logged

Add Student

Student Ledger

No students yet. Add your first student above.

How it works

This tool keeps a running ledger for every student. Each lesson you log creates a charge (debit); each payment you record creates a credit. The balance is the difference.

Balance formula Balance = Total Charged − Total Paid
Charge per lesson Uses the per-session rate if set; otherwise monthly tuition ÷ 4
Monthly tuition Use "Log Lesson" once per session, or "Charge Monthly Fee" as a lump-sum entry
CSV export Exports all students with running balance — ready for a spreadsheet

Example: Alex has a monthly tuition of $120. You log 3 lessons in June (3 × $30 = $90 charged). Alex pays $60 on June 15th. Balance = $90 − $60 = $30 outstanding. Highlighted in red so you remember to follow up.

Frequently asked questions

Is this free and does it require an account?
Yes, completely free and no account needed. All your data is stored in your browser's localStorage. Nothing is uploaded anywhere. If you clear your browser's site data, the ledger will be erased — so export to CSV regularly as a backup.
What's the difference between the monthly tuition and the per-session rate?
Monthly tuition is the fixed fee you charge per month regardless of exact session count. The per-session rate is used when you log individual lessons — the charge per lesson uses the per-session rate (if you set one) or falls back to monthly tuition ÷ 4. You can edit either field at any time and it affects future entries only.
How do I record a partial payment or split payment?
Just log the payment as many times as needed. If a parent pays $40 now and $40 next week, record each as a separate payment entry with the appropriate date. The ledger running balance updates automatically.
Can I track make-up lessons or missed sessions?
Yes. When you log a lesson you can add a note (e.g. "make-up" or "missed — no charge"). If there is no charge for a missed lesson, set the amount to $0 when logging it, or simply skip logging that session.
How do I export the data for my records or accountant?
Click Export CSV in the Overview section. The file contains one row per student with name, contact, monthly tuition, total charged, total paid, and current balance. You can open it in Excel, Google Sheets, or Numbers. For a full entry-by-entry log, the per-student CSV includes every lesson and payment entry in date order.
What happens if I use this on multiple devices?
Because the data lives in localStorage, each browser/device is independent. The recommended workflow is to pick one device (e.g. your teaching laptop) as the primary and export CSV regularly to share or archive. Cloud sync is not provided intentionally — no data ever leaves your device.