Spreadsheets from every corner of the school
At the end of each term, the bursary sends a reminder asking departments for their extras. The music school sends a spreadsheet of lessons, with some pupils listed by first name only. The exams officer sends a list of entry fees. The sports department forgets. The librarian emails about two lost books. A club leader sends a photo of a paper register.
Some arrive after bills have gone, so they go on next term's bill with a note, which parents query. Some never arrive, so the school absorbs the cost.
Every department keeps its own records
Departments are good at running their activities. They are not set up to produce billing data, and nothing asks them to do it consistently. Each builds a spreadsheet in its own way, with pupil names typed by hand, prices typed from memory, and no link to the MIS.
- Pupils are identified by name, sometimes incompletely.
- Prices are typed rather than taken from an approved list.
- Deadlines for extras are missed because the term is busy.
- Late extras go on the following term's bill.
- Some charges are never passed on at all.
What missed extras cost
Charges that never reach the bill are a direct loss. Charges that arrive late cause queries from parents who have already paid the term's bill. The bursary spends days cleaning and matching department spreadsheets. And departments feel chased at the busiest point of their term.
There is a fairness point as well. When one department is diligent and another forgets, some families are charged for extras their child used and others are not. Parents talk, and a family who paid for a term of fencing coaching may reasonably ask why a friend in the same club was never billed. Consistent capture is as much about treating families evenly as it is about income.
Extras capture we build
- The school's approved extras and prices are held in one list: lesson rates by length and instrument, exam fees by board and level, club charges, standard charges for lost items.
- Each department has a simple form to record charges against pupils, choosing pupils from the MIS list rather than typing names.
- Recurring charges such as weekly lessons are set once for the term and adjusted for missed or extra lessons under your rules.
- Charges are recorded as they happen, not at the end of term, so the bursary can see what is coming.
- Before each fee run, departments get a reminder to confirm their charges are complete, and the bursary sees who has and has not confirmed.
- Confirmed extras pass to your MIS or finance system as bill lines, with a clear description for parents.
| Extra | Recorded by | When |
|---|---|---|
| Instrumental lessons | Music school | Set termly, adjusted weekly |
| Exam entry fees | Exams officer | When entries are made |
| Club charges | Club leader | When places are confirmed |
| Lost books or kit | Library, department | When the loss is recorded |
| Trip balance | Trip leader | From the trip record |
Extras that arrive complete and on time
When the fee run comes, the extras are already there, recorded against the right pupils at the right prices, and the bursary can see which departments have confirmed. Parents see clear lines on the bill. Late charges become rare, and missed ones rarer still. Departments stop dreading the end-of-term reminder.
On a normal day, the head of strings records that a Year 8 pupil has moved from thirty to forty-minute lessons from next week. The change takes a minute and appears on the next bill correctly.
Is this your end of term?
- Departments send extras in their own spreadsheets.
- Pupils are identified by name only.
- Extras regularly arrive after bills have gone.
- Some charges are never billed.
- The bursary spends days cleaning department data.