One lesson, three payers
A Year 8 pupil has weekly trumpet lessons at her school. The school pays half as part of its music offer. A local charity grant pays a quarter because she qualifies for support. Her family pays the rest. The grant needs a report each term on attendance and spend. The school wants an invoice for its share, per pupil. The family wants to know why their bill is so small this term and whether it will change.
The office builds each of these by hand from the lesson register. When the pupil misses three lessons, nobody is sure who should get the credit.
Why funding splits get messy
Lesson systems usually assume one payer per pupil. Funding breaks that assumption in several ways. Bursaries can be a percentage or a fixed amount. Partner schools may pay for a group of pupils and want one invoice. Grants often have a set amount for a period, with reporting on who benefited. Each has its own rules about missed lessons. All of this is tracked in spreadsheets, if at all.
- Each lesson's cost has to be divided between payers.
- Funding rules for missed lessons differ from the family's rules.
- Grants have a budget that runs down during the year.
- Funders need reports on attendance, not just money.
- Families on bursaries need discretion in how bills and reminders are worded.
What the manual split costs
Office time, again, but here the stakes are higher. A grant report that cannot show where the money went can threaten next year's funding. A partner school invoiced wrongly may question the whole arrangement. A family on a bursary who receives a standard, full-price reminder can feel embarrassed. And when the grant budget runs out mid-year, you want to know before, not after.
Billing with the funding built in
- Each funding source is set up with its rules: percentage or fixed amount, which pupils, which lessons, the budget and period, and how missed lessons are treated.
- Each pupil's lessons are linked to their funding sources, in the order they apply.
- Lesson counts come from the register, so each payer's share is based on lessons actually due under their rules.
- Invoices are produced per payer: the family's share on their statement, the school's share on one invoice for all its pupils, grants drawn down against the budget.
- Budgets show how much is committed and how much is left, with a warning before a grant runs out.
- Funder reports show attendance and spend per pupil or in aggregate, in the format the funder asks for.
- Bursary families' bills show their share simply, and reminders use wording you have approved for them.
| Payer | Share (example) | Invoice | Report |
|---|---|---|---|
| Partner school | Half of each lesson | One per term, all its pupils | Pupil list with attendance |
| Charity grant | A quarter, up to a budget | Drawn down, not invoiced | Attendance and spend |
| Family | The remainder | Their normal statement | None |
| Bursary fund | Fixed amount per term | Internal transfer | Internal summary |
Funding you can account for
Each payer gets the right bill from the same lesson record. Grant reports take minutes because attendance is already there. You see a budget running low while there is still time to decide what to do. Families on support are billed without fuss.
When you apply for next year's funding, you have a clear record of who benefited and how many lessons they received, taken from registers rather than estimates.
Signs your funded lessons need this
- Some lessons have more than one payer.
- Partner school invoices are built by hand.
- Grant reports take days to put together.
- You are not sure how much of a grant is left.
- Bursary families receive standard reminders.