Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do I Stop Spending the First Week of Every Term Building Lesson Invoices by Hand?
Problems We Solve

How Do I Stop Spending the First Week of Every Term Building Lesson Invoices by Hand?

Termly lesson invoices take a music school days to build by hand. We build invoicing that reads your timetable and term dates and drafts every bill for you.

Updated 4 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Termly invoices go wrong because the number of lessons a pupil gets depends on term dates, their lesson day, bank holidays, lesson length and any mid-term start, and all of that lives in different places. We build invoicing that reads your timetable and term calendar, counts the lessons each pupil will actually receive, drafts the invoice in your accounts package and holds anything unusual for a person to check.

Invoice week in a music school

Term starts on a Monday. The week before, someone sits down with last term's invoice list, the new timetable and the term calendar pinned above the desk. A pupil who has a Monday piano lesson gets eleven lessons because of the bank holiday. The Thursday violinist gets twelve. The boy who moved from 30 to 45 minutes over the summer needs a new rate. Two sisters get a family discount, and one of them has dropped from weekly to fortnightly.

The work is careful and slow, and it is done by one person who usually also answers the phone to parents asking when term starts. By the time the last invoice goes out, the first lessons have already happened, and the first query arrives: 'Why am I paying for twelve when there are only eleven Tuesdays?'

It is usually a fair question. Half-term fell on a different week at the child's school, or an inset day moved a lesson, and nobody told the office.

Why a count of lessons is harder than it looks

The invoice is only as right as the lesson count, and the lesson count is the product of several things that are stored separately: the term calendar, the pupil's day and slot, the lesson length, the rate card, discounts, and any start or stop date inside the term. Most music schools keep the timetable in one place and the billing in another, and the link between them is a person reading one and typing into the other.

  • Term dates and closure days sit in a document, not in the billing tool.
  • Lesson length changes are agreed with the teacher and never reach the office.
  • Pupils who start in week three still get invoiced for a full term by default.
  • Discounts are remembered, not recorded, so they are applied inconsistently.
  • Pupils taught inside a partner school follow that school's calendar, not yours.

None of these is difficult on its own. Together, for a few hundred pupils, they turn invoicing into a week of cross-checking.

What the manual week is costing

The obvious cost is the time. The less obvious one is the credibility of the bill. When a parent spots one wrong count, they start checking every invoice, and the office spends the first fortnight of term handling credit notes and apologies instead of welcoming new pupils.

Late invoices also mean late payment. Lessons are being delivered and teachers expect to be paid on time whether or not parents have paid you. The gap sits on your cash, and chasing it falls to the same person who built the invoices in the first place.

The invoicing we build around your timetable

  1. Your term calendar goes in once a year: term start and end, half-term, bank holidays and any closure days, plus separate calendars for each partner school you teach in.
  2. Each pupil's lesson record holds the day, slot, teacher, length and start date, taken from your timetable or lesson management system rather than retyped.
  3. At invoice time, the system counts the lessons each pupil will actually receive this term against the right calendar.
  4. Your rate card and discount rules (siblings, second instrument, bursary) are applied the same way to everyone.
  5. Draft invoices are created in your accounts package, such as Xero or QuickBooks, through its API, with a line that shows how the lesson count was reached.
  6. Anything unusual is held back for a person: a mid-term start, a lesson length change, a pupil with no calendar, or a total that differs sharply from last term.
  7. Once approved, invoices are sent with a plain summary of dates, so parents can see which weeks they are paying for.
SituationWhat the system doesWho checks it
Standard weekly pupilCounts lessons from the calendar and drafts the invoiceNobody, unless flagged
Starts in week fourCounts from the start date onlyOffice, one glance
Lesson moved from 30 to 45 minutesUses the new rate from the change dateOffice
Taught at a partner schoolUses that school's term datesOffice, first term only
Family with three childrenCombines onto one account with the discount ruleNobody, unless flagged

The count is shown on the invoice, so a parent who queries it can see the dates straight away.

A quieter start to term

Invoice week becomes a morning of reviewing the flagged items and approving the rest. Parents get bills that show their child's dates, so queries drop to the genuine ones. When a parent does ask, the answer is on screen: which dates were counted and why.

Because the lesson record and the invoice come from the same place, changes agreed mid-term (a new pupil, a longer lesson, a leaver) feed next term's bills without anyone having to remember them.

Does this sound like your office?

  • Termly invoices are built by hand from a timetable and a calendar.
  • Parents regularly query how many lessons they are being charged for.
  • Lesson length changes reach the office late or not at all.
  • Pupils in partner schools are billed on your term dates by mistake.
  • Invoices go out after lessons have already started.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

Do we have to change our lesson management software?

Not usually. We read the timetable from what you use now, through an export or an API where one exists, and tell you plainly if it holds the data too loosely to work from.

Can it handle pupils who pay monthly rather than termly?

Yes. The same lesson count can be spread into monthly amounts, and the rule for how you spread it is yours to set.

What if the count is wrong for a pupil?

Nothing is sent without approval, and every invoice shows the dates counted, so a wrong count is easy to spot and correct before it reaches the parent.

What drives the cost of building this?

How many calendars you work to, how your timetable is stored today, and which accounts package the invoices need to land in.

Keep reading

More on Problems We Solve

Start here

Tell us where the admin piles up in your music school

Describe how lessons, teachers, rooms and invoices run today: the lesson software, the spreadsheets and the email threads with parents. We will tell you what we would build and what we would leave alone, and if a setting in a tool you already pay for would fix it, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →