Skip to content

Monthly commission reports

Applies to: SuperAdmin only. Last reviewed: 2026-11-18.

The monthly report lists every commission for one calendar month, with totals and a summary per salesperson. Use it to check a month before approving and paying, and to give a salesperson a statement.

Menu: Sales Management > Monthly Reports (/sales/reports)

The page heading is Monthly Reports. The browser tab reads "Monthly Commission Report | DriveFlow".

Which commissions fall in a month

A commission belongs to the month in which the school's payment was received. It does not move when it is approved or paid out.

  • A clawback line belongs to the month in which the refund was marked.

Months are counted in UTC

The month runs from 00:00 UTC on the 1st to 00:00 UTC on the 1st of the next month. South African time is two hours ahead of UTC, so a payment received between 00:00 and 02:00 South African time on the 1st falls in the previous month.

Generating the report

  1. Open Sales Management > Monthly Reports. The report for the current month is generated straight away.
  2. Set the filters.
  3. Click Generate report.
Monthly Reports page with month, year and other filters, summary cards and the earnings per salesperson table
The Monthly Reports page.

Filters

Filter Options Default
Month January to December The current month
Year The current year and the five years before it The current year
Salesperson "All salespeople" or one salesperson, shown as "Name (CODE)" All
Payment gateway "All gateways", PayFast, Paystack, Flutterwave, Stripe, Manual All
Subscription plan "All plans", each plan name that has earned commission, and Add-on All
Commission status "All statuses", Pending, Approved, Paid, Reversed All

Important

Changing a filter does not refresh the report on screen. Click Generate report again.

The plan list contains only plans that have already earned a commission. "Add-on" selects commissions earned on monthly add-ons.

If the report cannot be loaded the message "Unable to load the report." appears. The server refuses a month outside 1 to 12 or a year outside 2000 to 2100 with "Choose a valid month and year."

Reading the report

The report title is the month and year, for example "November 2026".

Summary cards

Card Meaning
Subscription Revenue Total eligible amount of the generated commissions (not Reversed, clawbacks left out)
Gateway Fees Total gateway fees on those commissions
Net Eligible Revenue Subscription revenue less gateway fees
Commission Generated Total commission on those commissions
Commission Paid Total commission of the rows that have a payout. A clawback settled in a payout counts as a negative amount.
Outstanding Commission Total commission of the rows that are Pending or Approved. A clawback that is not settled counts as a negative amount.
Salespeople Number of different salespeople in the report
Referred Customers Number of different schools in the report

All cards respect the filters. If you filter on status Paid, for example, the Outstanding card shows R 0.00.

Earnings per salesperson

Column Meaning
Salesperson Name, linked to the salesperson's detail page
Referral Code The code on the first of that salesperson's rows
Customers Number of different schools
Revenue Eligible amount of the generated commissions
Commission Generated commission
Paid Commission settled by a payout
Outstanding Pending and Approved commission

Sorted by salesperson name.

Commission transactions

One row per commission, sorted by salesperson name and then payment date.

Column Meaning
Salesperson Name
Referral Code The code as it was applied to the school
Driving School School name
Plan The plan name, or "Add-on". Hover over it to see the full description of what was bought.
Gateway PayFast, Paystack, Flutterwave, Stripe or Manual
Payment Date Date the school's payment was received
Amount Eligible amount, without VAT and without setup fees
Fee % The configured gateway percentage that applied. This is shown even when the actual fee was used.
Gateway Fee The fee, with Actual or Estimated underneath
Net Revenue Amount less gateway fee
Commission % The percentage agreed for that school
Commission The commission. Negative on a clawback.
Status Pending, Approved, Paid, Reversed or Clawback

Twenty rows are shown per page. When there are more, a pager appears with page sizes 10, 20, 50 and 100.

If the month has no commissions, both tables read "No commissions in this month."

A reversed commission stays in the transaction list with its original figures and the status Reversed, but it is left out of the Revenue, Gateway Fees, Net and Commission Generated totals.

Exporting and printing

The three export buttons are enabled once a report is on screen.

Button Result
Export to Excel Downloads an .xlsx file
Export to PDF Downloads a .pdf file
Print Opens the PDF in a new browser tab, where you print it from the browser

The exported document is titled "Sales commission report {Month Year}", for example "Sales commission report November 2026". If the server does not supply a file name, the browser saves it as Sales-Commission-Report-2026-11.xlsx or .pdf.

The export contains the transaction rows only, with these columns:

Export column Content
Salesperson Name
Referral Code Code
Driving School School name
Subscription Plan Plan name or "Add-on"
Gateway Gateway name
Payment Date yyyy-MM-dd
Subscription Amount Eligible amount
Gateway Fee Percent Configured percentage
Gateway Fee Fee amount
Gateway Fee Type Actual or Estimated
Net Revenue Net eligible revenue
Commission Percent Agreed percentage
Commission Amount Commission
Commission Status Pending, Approved, Paid, Reversed or Clawback

Warning

The export uses the filter values as they are on screen when you click the button, not the values of the report shown below. If you changed a filter after generating, click Generate report first so that the screen and the file agree.

Things to know:

  • The summary cards and the per-salesperson table are not part of the export.
  • In the export a clawback is always labelled "Clawback". On screen a clawback that has been settled in a payout is labelled "Paid".
  • If the export fails the message "Unable to export the report." or "Export failed: ..." appears.

Example: checking November 2026 for one salesperson

  1. Open Sales Management > Monthly Reports.
  2. Month: November. Year: 2026. Salesperson: Thily Naidoo (DF-THILY-001).
  3. Click Generate report.
  4. The cards show Subscription Revenue R 1,498.00, Gateway Fees R 44.94, Net Eligible Revenue R 1,453.06, Commission Generated R 290.62, Commission Paid R 96.81 and Outstanding Commission R 193.81.
  5. Click Export to PDF and send the file to the salesperson as her statement.

Limitations and notes

  • The report covers one calendar month. There is no date-range or year-to-date report. Use the Sales Dashboard for a longer period.
  • A CSV export exists in the API (format=Csv) but there is no button for it on the page.
  • The exact column headings and layout of the Excel and PDF files are produced by the shared export service and were not checked against a generated file for this guide.
  • The report cannot be scheduled or emailed automatically.
  • Totals add all rows together without regard to currency. All subscription payments are in ZAR today.