Key takeaways
- Prepaid drive hours are tracked as a liability.
- No-shows charge the hour, cancellations return it.
- Instructor pay derives from the pay type.
- Pass rate sits beside each instructor's margin.
Greenlight Driving School takes the whole package up front. By the middle of August the account looks healthy, but most of that money is drive hours nobody has taught yet, one family missed two slots without paying the fee, and the school has never checked whether the percentage instructor returns more than the hourly one. DriveDesk US records the package, the lesson and the pay rule once, so the school always knows what it still owes.
Prepaid hours are a liability
Every package records the classroom hours and drive hours included and the price paid, so the per-hour value, the hours used and the hours remaining all derive from the lessons actually logged against that package.
Remaining hours times the per-hour value is what the school still owes in teaching, and the dashboard totals it across every student, so the cash in the account can be read honestly at any point in the month.
No-shows and cancellations by rule
A lesson is logged as completed, a no-show or a cancellation. A completed lesson charges the package the time actually driven; a no-show charges the scheduled hour; a cancellation charges nothing and returns the hour.
The fee register sits beside it, recording whether a no-show or late cancellation was charged and whether the fee was ever collected, which is the money most driving schools write off without noticing.
Instructor pay from the pay type
Each instructor carries a pay type: an hourly rate on the time actually driven, or a percentage of the lesson's value. Pay derives on the row, and a no-show or cancelled lesson pays nothing because nobody drove.
The car cost per hour comes off the same row, so the margin on an hour in the Corolla with a percentage instructor and an hour in the Civic with an hourly one can finally be compared side by side.
Classroom seats and road tests
Classroom Saturdays are opened as sessions, seats are booked against a package, and attendance decides whether the hours are credited, so a student who missed a Saturday is visible before the road test is booked.
Each road test records the instructor who prepared the student and the outcome, and the instructor summary turns that into a pass rate sitting next to that instructor's margin and hours taught.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
DriveDesk US Private Google Sheets Web App is designed for use with a Google account, Google Sheets, and Apps Script, using owner-only deployment by default.
No lesson scheduling or booking calendar, no state licensing or driver record filing, no license or permit numbers stored anywhere, no instructor payroll or contractor tax filing, and no card processing or automatic tuition billing.

