Music school opening balances: carry prepaid tuition into a new month
A music school opening balance is the amount a family owes, or the tuition credit remaining, immediately before the new period’s movements begin. Carry it from an approved closing balance and document the cutoff. Don’t also import the older payments and credits that already produced it.
What belongs in a music school opening balance?
An opening balance summarizes the prior ledger; it is not another payment or another tuition charge. For each family, store a stable family ID, an amount, an explicit owed-or-credit direction and the date the balance applies.
A confirmed zero deserves a record too. A blank may mean zero, missing information or a formula that failed. You shouldn’t have to guess which one it means.
Keep the supporting previous-period ledger in your own records. The opening amount explains where you start, while that ledger explains how you got there.
Define the cutoff before importing transactions
Use a convention everyone at the school can follow: the opening balance dated 1 Nov 2026 is the position before any 1 Nov movements. The new period includes movements from 1–30 Nov 2026.
For systems that label a closing balance “31 Oct,” confirm that it includes all movements through that date. A report named “October” might have been generated before the last day’s receipts were recorded.
| Record | Treatment under this convention |
|---|---|
| Payment included in approved October closing ledger | Already reflected in November opening; don’t add again |
| Payment received on 1 Nov | November movement, not opening balance |
| October lesson with credit approved and included before cutoff | Already reflected in opening |
| Newly discovered October correction | Review and record a documented correction; don’t silently alter the carried balance |
Choose whether payment dates mean receipt dates or another defined date in your operational ledger. Use the same convention across the files. A transfer initiated by a family before month end but received afterward needs evidence, not an assumed date.
Work through a fictional rollover
Every amount below is fictional. FAM-202 has these approved October movements:
| October movement | Amount |
|---|---|
| Opening amount owed | USD 25.00 |
| Lesson charges | USD 160.00 |
| Payments received | USD 180.00 |
| Approved money credit | USD 40.00 |
| Closing result, 31 Oct 2026 | Credit remaining: USD 35.00 |
The calculation is USD 25.00 + USD 160.00 − USD 180.00 − USD 40.00 = USD 35.00 credit remaining.
November starts with that USD 35.00 credit. Add USD 160.00 November charges and a USD 125.00 November payment. The closing result is USD 0.00: the opening credit and new payment together cover November’s charges.
If you import October’s USD 180.00 payment again as a November receipt, the spreadsheet wrongly shows USD 180.00 credit remaining. The row is genuine, but it belongs to the earlier calculation.
Bridge a gap instead of relabeling an old balance
Suppose your last approved balance is from 28 Oct, but your next period starts 1 Nov. Review the intervening dates first.
In a fictional bridge, USD 10.00 owed at the end of 28 Oct plus a USD 40.00 charge on 29 Oct minus a USD 50.00 payment on 30 Oct produces a confirmed USD 0.00 opening balance on 1 Nov. Renaming the old USD 10.00 balance “1 Nov” would omit two movements.
Record the bridge’s included transactions and reviewer. Don’t fix a date mismatch by changing only the as-of cell.
Check the rollover at family and school level
- Compare each opening amount and direction with the previous approved closing result.
- Investigate any family that is missing from either list.
- Ensure old payments and credits aren’t included again as current movements.
- Check that the sum of the signed opening balances equals the sum of the signed previous closing balances, allowing only documented corrections.
- Label every difference with its source and approval rather than using a balancing adjustment with no explanation.
A school-level total can agree even when two families’ opening balances have been exchanged. Compare by family ID before accepting the total.
For the broader worksheet structure, use the tuition reconciliation spreadsheet layout. Tufton’s public sample lets you select an opening balance separately from payments and credits, so you can see how a brought-forward amount differs from a current-period movement.