Financial Report¶
Applies to: school staff with Reports.View and Payments.View, on a plan that includes Reports. Last reviewed: 2026-11-18.
The Financial Report shows what the school received from its students in a period, how it was paid, and what is still owed.
School-level versus platform-level reporting¶
This report is about the school's own money: invoices the school raised to students and walk-in customers, and the payments it received.
It does not cover:
- what the school pays DriveFlow for its subscription and add-ons (see Billing invoices);
- DriveFlow's platform reports on subscriptions, sales commissions and gateway fees, which only a SuperAdmin sees under Sales Management (see Sales management).
A SuperAdmin has no school of their own, so this report is not in the SuperAdmin menu.
Where to find it¶
- Sidebar > REPORTING > Reports > Financial Report (
/reports/financial). - From the dashboard: Payments Overview panel > Financial Report button.
Who may open it¶
| Requirement | Detail |
|---|---|
| Plan feature | Reports |
| Permissions | Reports.View and Payments.View (both) |
Both permissions are required
Without them the page shows "You don't have access to this report - Ask an administrator for access if you need it." with a Reports button. Staff who can only record payments (Payments.Create) cannot open it.
Filters¶
| Control | Meaning |
|---|---|
| From / To | The period. Both dates are included: the period runs from the start of the From date to the end of the To date. |
| Branch | All branches or one branch. |
| Period | Quick ranges: Today, This week (Monday to today), This month, Last month, Last 30 days, Last 90 days, Year to date, Last year. Choosing one sets the dates and regenerates the report. |
| Generate Report | Runs the report with the chosen dates and branch. |
| Export | Excel, PDF or CSV. See Export. |
| Reports | Back to the Reports Overview. |
The report opens with the period and branch you last used on any report page during this session. The first time, that is one month ago to today, all branches.
Messages: "Please select a date range." and "The start date cannot be after the end date."
Note
A user whose sign-in is tied to one branch only ever sees that branch's figures, whatever the Branch filter says.
Screenshot to be added
Screen: Financial Report. Should show: filter bar, the four summary cards and the Revenue by Month table.
What the report shows¶
Some parts follow the selected period; others are a snapshot of today. The page marks snapshots with "as of today".
Summary cards¶
| Card | Caption | How it is calculated |
|---|---|---|
| Period Revenue | in selected period | Sum of payments with status Successful whose payment date falls in the period. |
| This Month | current calendar month | Sum of Successful payments dated in the current calendar month. Ignores the period filter; respects the branch filter. |
| Outstanding | as of today | Sum of (Total - Amount Paid) for every invoice that is not Paid and not Cancelled. Ignores the period; respects the branch. |
| Overdue | as of today | The same sum, limited to invoices whose due date is before today. |
What revenue means here
"Revenue" throughout this report means money received, counted on the payment date. It is not the value of invoices raised.
Revenue by Month¶
One row per calendar month in the period that has at least one payment.
| Column | Meaning |
|---|---|
| Month | For example "Jul 2026". |
| Payments | Number of Successful payments in that month. |
| Revenue | Their total. |
Months without payments are not listed.
Payment Methods¶
One line per payment method used in the period, highest amount first: the method, the amount and its share of Period Revenue.
Online PayFast payments from the student portal appear under MobilePayment.
Invoice Status (as of today)¶
One row per invoice status that exists.
| Column | Meaning |
|---|---|
| Status | Draft, Pending, PartiallyPaid, Paid, Cancelled, Overdue or Credit. |
| Invoices | Number of invoices with that status. |
| Amount | Sum of the invoice totals (not balances) for that status. |
This table covers all invoices regardless of date. It respects the branch filter.
Student Balances (as of today)¶
One row per student who has ever been invoiced, highest balance first. Walk-in invoices are grouped by customer name.
| Column | Meaning |
|---|---|
| Student | Student or walk-in customer. |
| Invoiced | Sum of the totals of the student's invoices, excluding Cancelled invoices. |
| Paid | Sum of the amount paid on those invoices. |
| Balance | Invoiced - Paid. |
This covers all invoices regardless of date. Credit invoices (negative) reduce a student's Invoiced figure.
Payment Transactions¶
"Successful payments during the selected period." Newest first.
| Column | Meaning |
|---|---|
| Receipt | Receipt number. |
| Student | Student, or the walk-in customer on the invoice. |
| Date | Payment date and time. |
| Method | Payment method. |
| Amount | |
| Status | Always Successful. |
Voided, refunded, pending and failed payments are not listed.
How to read it: example¶
Period 1 to 31 July 2026, all branches:
- Period Revenue R 86 400.00: the school received R 86 400.00 in July.
- This Month R 12 150.00: received so far in the current month (the month you are looking at the report in, not July).
- Outstanding R 41 300.00, Overdue R 9 800.00: owed right now; R 9 800.00 of it is past its due date.
- Payment Methods: EFT R 51 840.00 (60.0%), Cash R 21 600.00 (25.0%), MobilePayment R 12 960.00 (15.0%).
- Student Balances: the top rows are the students who owe the most.
Period Revenue equals the sum of the Revenue column in Revenue by Month, the sum of the Payment Methods amounts, and the sum of the Amount column in Payment Transactions.
Export¶
Click Export and choose Excel, PDF or CSV.
- The file contains the Payment Transactions rows for the selected period and branch. The cards and the other tables are not exported.
- Columns: ReceiptNumber, StudentName, PaymentDate, PaymentMethod, Amount, Status.
- The file is named
financial-report-<date and time>with the extension.xlsx,.pdfor.csv. - The export uses the dates and branch currently in the filter boxes, even if you have not clicked Generate Report since changing them.
General export behaviour (layout, formats) is described in Exporting reports.
Messages: "Please select a date range first.", "Unable to export financial report.", "Export failed: ...".
Things to keep in mind when reconciling¶
Refunds and voids rewrite the past
A payment that is later voided or refunded disappears from the period in which it was received; there is no negative line in the period of the refund. See Refunds and voids.
- Refunds and voids rewrite the past (see above).
- Backdated payments count on their payment date, not the day they were typed in.
- Outstanding includes Credit and Draft invoices, because it counts everything that is not Paid or Cancelled. A Credit invoice lowers the figure.
- Overdue here is by due date, not by the Overdue status, and does not apply the grace period. It can be higher than the Overdue filter on the Invoices page suggests.
- Tax is not separated. Revenue is the gross amount received.
Revenue elsewhere in the product¶
| Place | What it shows |
|---|---|
| Dashboard | Payments today, this month, this year, a 12-month chart, the latest payments and outstanding invoices. |
| Reports Overview | Revenue card and Revenue by Month for the selected period. |
| Payments page | Received This Month and the full payment list. |
| Instructor Earnings Report | Instructors' and the school's share of completed lessons (Enterprise). |
Limitations and notes¶
- Revenue report API without a screen. The API has a separate revenue report (revenue today, this week, this month, this year, outstanding invoices, payment methods and monthly revenue, with an export). No page in the web application calls it; the Financial Report covers the same ground.
- Nightly "report generation" job does not produce reports. A background job runs every day at 23:00 and executes the revenue query for each active school, then writes a line to the server log. It stores nothing, emails nothing and creates no file. Scheduled or emailed reports are not available.
- No VAT report, no aged-debtors report, no income by package or by instructor in this report, no comparison with a previous period, and no charts on this page (figures are shown as tables and lists).
- No invoice-based (accrual) revenue figure for a period; only money received.
- The export contains transactions only. To keep the Student Balances table, copy it from the screen.
Related articles¶
- Outstanding balances: how each outstanding figure is calculated.
- Payment history: the full list of payments.
- Invoicing: invoices and their statuses.
- Exporting reports: export formats and layout.
- Refunds and voids: how reversals affect period figures.