ETEP lights

ARTICLES

Running a flying club without spreadsheets

In many clubs, the management lives in a shared spreadsheet, a calendar and the treasurer's memory. It works until the double booking, the expired rating nobody noticed or the balance three volunteers each work out their own way. What a club follows every day, and how to organise it so that each piece of information is entered only once.

All articles·Published ·5 min read

Why the spreadsheet ends up stuck

A spreadsheet knows no rules. It accepts two bookings on the same aircraft, an hour of flight billed on one sheet and forgotten on another, an inspection date nobody reads again. Each piece of information is entered several times, by several people: the planning, the flight sheet, the pilot's account, the aircraft's hours. And the history depends on who saved the last version.

The principle that replaces the spreadsheet is simple: each fact is entered once, as close to its source as possible, and the rest follows from it. The flight closes the booking; the closure debits the pilot's account and adds the hours to the aircraft; the aircraft's hours move its maintenance forward.

Bookings and planning

The planning is the tool members open most. It shows the fleet and the instructors, takes the students' requests for lessons, blocks an aircraft in maintenance, and should apply the club's rules without anyone having to remind them:

  • the shortest and longest booking, how far ahead, how many open bookings at a time;
  • the notice for a cancellation, and what happens with a late one;
  • a briefing time between two lessons of the same instructor;
  • an aircraft unavailable when an inspection is due, a defect grounds it or a document has expired;
  • a solo flight accepted only if the pilot's licences and ratings cover the aircraft, and if the balance allows it.

The airfield's weather over the day, sunrise and sunset, and a waiting list for the aircraft already taken complete the planning.

Prepaid pilot accounts and invoices

Most clubs run a prepaid account: the member tops it up by cheque, transfer or card, and each flight debits it. The debit gathers the aircraft's hour, fuel included or not, the instruction, the landing fees and the fuel taken from the pump. Three choices avoid arguments:

  • the basis of the time billed, aircraft by aircraft: block time, airborne time or hour meter, with a check that the hour meter at the start picks up where the previous flight ended;
  • entries never deleted: a mistake is undone by a reverse entry, which keeps a trace of what was corrected;
  • invoices numbered in an unbroken series, a credit note to cancel one, and an export the club's accountant can read.

The treasurer needs the whole picture: balances, payments, members in debit to remind, the club's money month by month. VAT depends on each club's situation: settle it with the club's accountant.

Licences, ratings and medical certificates

In Europe, Part-FCL makes the exercise of a licence's privileges depend on the validity of the ratings it holds and of the medical certificate (FCL.040), and requires the pilot to carry a valid licence and a valid medical certificate when exercising those privileges (FCL.045). Carrying passengers also takes recent experience: at least 3 take-offs, approaches and landings in the preceding 90 days, in the same class or type (FCL.060).

The pilot is responsible for it, but the club that lends an aircraft has every reason to know before the flight. One record per member is enough: licence, class or type ratings with their expiry dates, checkouts on each aircraft, and a reminder before each date. The medical certificate calls for restraint: the club needs neither its class nor its limitations; flying with a valid certificate is the pilot's responsibility.

Fees

The yearly fee is often the condition for booking. Whether it is called at once for every member, valid until a given date, paid from the pilot account or otherwise, what matters is that the planning knows whether it is paid: a member whose fee has expired should not be able to book without the club seeing it.

Aircraft documents and maintenance

Each aircraft has its due dates: airworthiness review certificate, insurance, inspections by the hour (50 h, 100 h), the annual inspection, the engine and propeller time limits. The aircraft's hours should come from the flights themselves, not from a reading copied by hand: that is also how to foresee the date of the next inspection at the club's real pace.

The technical log closes the loop. The pilot who finds a defect notes it in a few words, if need be while closing the flight; a defect that grounds the aircraft should block its bookings until the mechanic clears it, and the pilots who had booked it should be told.

Where to start

  1. List the aircraft with their documents, their due dates and how each one is billed.
  2. Bring in the members with their licences and ratings and their expiry dates, and each account's balance on the day of the change.
  3. Write down the club's rules: bookings, cancellations, minimum balance, fee.
  4. Give everyone their role: treasurer, secretary, mechanic, instructors, safety officer.
  5. Keep the old spreadsheet read-only while you check the first account statements.

Sources

  1. Easy Access Rules for Aircrew (Regulation (EU) No 1178/2011) — Part-FCL, Subpart A: FCL.040, FCL.045, FCL.060 EASA, revision of August 2023

Texts read on the date of the article. For regulations, only the official version is authentic.