Student accounts in a flight school: hour sales, instalments and payments

In most flight schools money is tracked in two places: invoices in the accounting package, the student’s balance in a spreadsheet. Flight hours are in a third place. The result is three different answers to “how many hours does this student have left, and how much do they owe”. The student account exists to bring those three into one record.

What the account keeps, and what it does not

The student account is not a set of books. Tax invoices, VAT returns and statutory ledgers stay in the accounting software. The account’s job is to keep the commercial relationship between school and student in the same place as the flight record: what was sold, what was paid, what was flown, what is left.

Sales: package or hours

There are two kinds of sale and they behave differently.

When a course package is sold, the student is enrolled on a course and syllabus progress begins. The debt is the package price; hours flown do not reduce the debt, they complete exercises in the syllabus.

An hour sale is a bank of hours: for PIC flying, refreshers or extra training, the student buys a set number of hours. Every completed flight is deducted from that balance; the remaining hours show on the scheduling screen and no new flight can be scheduled once the balance is gone.

The only thing to do at the point of sale is pick the right type. Everything else, the enrolment or the hour credit, should follow from that choice.

Currency and exchange rates

Flight training is usually priced in euros or dollars and paid in local currency. Every movement on the account needs to carry the exchange rate of its transaction date; otherwise the question of where the exchange difference came from at month end has no answer. Keeping foreign-currency records at the official rate also reduces the reconciliation with accounting to a single line.

Instalments and due dates

Package sales are usually paid in instalments. Defining the instalments with their due dates inside the account turns “who is late” from a report into a list. If a late fee applies, calculating it from a defined rule rather than by hand ends the argument before it starts.

Payments and receipts

Every payment should close with a numbered receipt: date, amount, currency, rate, which instalment it was applied to. A skipped or hand-written receipt number is the first thing asked about in an audit or a dispute with a student. If a payment has to be spread across several instalments, the system should do the allocation; a hand-allocated payment eventually leaves an instalment open.

Students seeing their own balance

This is the feature that removes the most work. When students see their balance, remaining hours and next instalment in their own panel, the phone calls to accounts asking “how much do I owe” stop. On the school side, whether a student with an overdue payment can be scheduled becomes a policy decision, and the system applies it.

Order of setup

Set the account up in this order: first the products (packages and hour types) and their prices; then the open balances of existing students as an opening-balance entry; finally, start making new sales through the system. There is no need to migrate historic movements one by one; the opening balance is enough and the detail stays archived in the old spreadsheet.