LessonbookWhen the invoices and family accounts don't match up
"Every month the invoices and Family Accounts don't match up," writes a music teacher in a review of a well-known studio management program on Capterra, and another adds: "My books never balance!" The error almost always has the same root. The balance is stored as a figure of its own, while the invoice is built from something else, and the two are updated separately.
Why two figures drift apart
Many systems and spreadsheets keep a family's balance in one cell or field and change it whenever something happens: an invoice is created, a payment is recorded, a lesson is moved. The invoice is made somewhere else, from the timetable or a template. As long as every change reaches both places, the figures agree. But one moved lesson that gets invoiced again, one payment recorded against the wrong sibling, one invoice corrected by hand after the balance was updated, and the two trails go their separate ways. Neither is "wrong" on its own, which is exactly why the error is so hard to find.
Find the error in ten minutes
1. Pick one family and find the last date you know everything agreed, for example when they were last at zero. 2. Write down everything since, in date order: every lesson given or charged, every term fee or package, every payment, every make-up lesson. 3. Keep a running total after each line, the way a bank statement does. 4. Compare it with what the program or spreadsheet says. The first line where the totals differ is where the error is. Typical finds are a lesson charged twice because it was moved, a make-up lesson invoiced as a new lesson, a payment recorded against the wrong family, or last month's balance brought forward twice.
The fix: one list, two views
The error goes away when the balance is not stored anywhere, but calculated from one list of dated events every time someone looks at it. The invoice or statement is then just a view of that same list. There are no longer two figures that can drift apart, because there is only one. The other half is how mistakes are corrected. Change an old line and the record of what it said is gone. Add a new line that voids or adjusts it, with a date and a reason, and both you and the family can see what happened.
How this works in Lessonbook
In Lessonbook you mark each lesson as given, missed and charged, missed with notice, cancelled by the teacher, or make-up lesson, and record payments as they arrive. The balance, prepaid lessons and make-up credits are all calculated from those lines, and the statement the family receives is the same calculation. A mistaken entry is voided with a reason. The line stays visible, struck through, and the balance is recalculated without it.
Frequently asked questions
Should I just correct the balance when it is wrong?
Better not. A corrected figure erases the trace of what was wrong. Record an adjustment with a date and a reason instead, so the next check can see why the figure changed.
How often should I check the family accounts?
A short review each month, before you send statements, catches most mistakes while you still remember what happened in those weeks.
Can parents see for themselves how the balance was worked out?
In Lessonbook the family gets a read-only link where every krone is on a dated line, with the running balance after each line.