Monthly Family Balance Sheet
A one-page monthly log that shows, for every tutoring family, how many sessions were held, what remains on a package, what was invoiced, what was paid, and what needs a follow-up.
Reviewed for 2026, updated September 8, 2026.
Tracking one family's payments is easy. Tracking fifteen families, some on prepaid packages, some paying per session, and one or two split across two households, is where notebooks and memory quietly fail. A session gets delivered but never billed, a package runs out three sessions ago, or a payment lands and nobody records which family it came from. This worksheet gives each family one row per month so those gaps are visible on a single page.
Fill it in at the end of each month, or weekly if your roster is large. The example rows below show the kinds of situations that come up; replace them with your own families and amounts. Keep the last row as a monthly total so you can see at a glance how much is outstanding, and carry any balance into next month's sheet. If you later move to software, this is exactly the data it should hold, so nothing is lost in the transition.
| Family and student | Billing type | Sessions held this month | Sessions left on package | Invoiced this month | Paid this month | Balance and next step |
|---|---|---|---|---|---|---|
| Family A (student initials) | Prepaid package, 10 sessions | 4 | 6 | None, package paid in advance | Your figure | No balance. Send a low-balance note when 2 sessions remain |
| Family B | Per session, billed monthly | 3 | n/a | Your figure (3 x rate) | Your figure | Due on your billing date. Reminder sent? |
| Family C (two households) | Per session, two invoices at half each | 4 | n/a | Your figure per household | Your figure per household | Track each household as its own line |
| Family D | Prepaid package, 5 sessions | 5 | 0 | Renewal package invoice | Your figure | Package finished. Confirm renewal before the next session |
| Family E | Per session | 2 held, 1 late cancellation | n/a | Your figure (fee applied per policy) | Your figure | Late-cancellation fee applied as agreed at intake |
| Family F | Prepaid package, 20 sessions | 6 | 9 | None | Your figure | No action this month |
| Family G | Per session | 4 | n/a | Your figure | Partial, your figure | Balance carried forward. Follow up in 7 days |
| Family H (new, started mid-month) | Package chosen at intake | 1 | 9 | Package invoice | Pending | Payment due before session 2 |
| Your next family | Your billing type | Your count | Your count | Your figure | Your figure | Your note |
| Month total | Sum of sessions held | Sum invoiced | Sum paid | Total outstanding: your figure |
https://tutorloopr.com/templates/monthly-family-balance-sheet/Use it in your business, share it with your team, or link to it from your own site.
Also from TutorLoopr
- New Tutoring Family Intake Checklist: Everything to confirm with a new tutoring family before the first session, so scheduling and payment questions are settled in writing instead of negotiated later.
- Free calculators