Platform reports¶
Applies to: SuperAdmin only. Last reviewed: 2026-11-18.
This page lists the reports and figures that are available to the SuperAdmin, and says clearly which platform reports do not exist.
What exists¶
Important
All reporting for the SuperAdmin is inside Sales Management. It covers referred schools only.
| Report | Menu | What it answers | Guide |
|---|---|---|---|
| Sales Dashboard | Sales Management > Dashboard | How many salespeople and referred schools there are, and the revenue, gateway fees and commission from referred schools over up to 36 months, with four charts and the top five salespeople | Sales Management |
| Monthly commission report | Sales Management > Monthly Reports | Every commission of one calendar month, with totals and earnings per salesperson. Exports to Excel and PDF, and prints. | Monthly commission reports |
| Salesperson detail | Sales Management > Salespeople > click a row | One salesperson's referred schools, generated, paid and outstanding commission | Salespeople |
| Referral detail | Sales Management > Customer Referrals > click a row | One referred school's agreement and every payment that earned commission | Customer Referrals |
| Payment history | Sales Management > Commission Payments | Every payout recorded | Commission payments |
Lists that can serve as simple reports:
| List | Menu | Use |
|---|---|---|
| All users, with their school | Users | Who has access, per school. No export. |
| All roles, with user counts | Roles | How many users hold each role across all schools |
| Instructor sign-in check | Users > Instructor sign-in check | Instructor accounts that are not linked, per school |
| Schools with their subscription status | Subscriptions > the School box | A quick look at each school's status. Not a report: it is a pick list. |
What does not exist¶
A platform owner would normally expect the following. None of them is built.
| Not available | What to use instead |
|---|---|
| A list of all schools with plan, status, start and end dates | The School box on the Subscriptions page shows one school at a time. A full list needs a database query. |
| Total subscription revenue, per month or per plan | Not available. The Sales Dashboard figure "Revenue from Referrals" covers referred schools only, and counts the commissionable amount, not everything that was paid. |
| New registrations, trials started, trials converted, schools lost | Not available |
| Subscriptions about to expire | Not available |
| Outstanding (pending) manual payments across all schools | Not available. Pending payments are shown per school on the Subscriptions page. |
| Add-on and SMS bundle sales | Not available |
| Usage per school (students, lessons, users) | Not available. The SuperAdmin sees no school data. |
| DriveFlow's own invoices across all schools | Not available. Each school sees its own under Settings > Billing. |
| Messages sent or failed across all schools | Not available. Each school sees its own under Settings > System. |
| An audit report | Not available. There is no audit log. |
The school Reports menu (Overview, Student Report, Lesson Report, Sign-Off Report, Driving Test Report, Financial Report, Vehicle Report, Instructor Earnings Report) is not shown to the SuperAdmin. Those reports show one school's data, and the SuperAdmin belongs to no school.
Working around the gaps¶
Until platform reports are built, the figures have to be taken from the database by someone with database access. The relevant tables are named in the code as:
| Information | Table |
|---|---|
| Schools | Companies |
| Subscriptions and their status | CompanySubscriptions, with SubscriptionPlans |
| Money received for plans, add-ons and bundles | SubscriptionPayments |
| DriveFlow's invoices to schools | SubscriptionInvoices |
| Add-ons per school and SMS credits | CompanyAddOns |
Warning
Table names are taken from the entity names. Check them against the database before writing a query.
Limitations and notes¶
- Sales Management figures are counted by the date the school's payment was received, in UTC.
- The dashboard cannot be exported.
- No report is emailed on a schedule. A background job named
report-generationruns daily at 23:00, but what it produces was not examined for this guide and no platform report is delivered by it to the SuperAdmin.
Related articles¶
- Sales Management - the Sales Dashboard
- Monthly commission reports - commissions per month with export
- Company management - finding schools
- Platform overview - what the SuperAdmin can and cannot do