Skip to content

Exporting reports

Applies to: school staff who can open the report concerned (Reports.View plus the report's own permission). Last reviewed: 2026-11-18.

Most reports can be saved as an Excel, PDF or CSV file. This page explains what goes into the file and how the three formats differ.

Which reports can be exported

Report Export menu items Rows in the file
Reports Overview none -
Student Report Excel, PDF, CSV Student Progress table
Lesson Report Excel, PDF, CSV Lesson Details table
Sign-Off Report PDF (with signatures), Excel, CSV Sign-Off Details table
Driving Test Report Excel, PDF, CSV Test Details table
Financial Report Excel, PDF, CSV Payment Transactions table
Vehicle Report Excel, PDF, CSV Vehicle Details table
Instructor Earnings Report PDF (per instructor), Excel (per instructor), PDF (every lesson), Excel (every lesson), CSV (every lesson) Earnings per Instructor, or Earning Details

The dashboard, the Invoices page, the Payments page and the Quotes page have no export. Single documents (an invoice, a quote, a receipt) are downloaded as PDFs from their own menus; see the financial management pages.

How to export

  1. Open the report and set From, To and Branch.
  2. Click Generate Report to check the figures on screen.
  3. On the Lesson Report or Sign-Off Report, optionally set the Student column filter.
  4. Click Export and choose the format.
  5. The browser downloads the file.

Screenshot to be added

Screen: Any report. Should show: the filter bar with the Export menu open showing Excel, PDF and CSV.

What goes into the file

  • Only the detail table. Each export contains one list of rows (see the table above). Summary cards, breakdowns and "as of today" sections are not in the file.
  • All rows, not just the page on screen. The on-screen tables show 10 rows at a time; the file contains every row. There is no row limit.
  • The filters in the boxes are used: period and branch as they currently stand in the filter bar, even if you changed them without clicking Generate Report. For the Lesson and Sign-Off reports the Student column filter is applied too, so the file matches the table.
  • Sorting on screen is not carried over. Rows come in the report's own order (for example newest lesson first).
  • Columns are the report's data fields, named in English without spaces, for example StudentName, PaymentDate, DurationMinutes. Some files contain a column that is not shown on screen (for example PickupLocation in the Lesson Report). Internal identifiers are left out.

Column lists per report are given on each report's page.

Differences between the formats

Excel (.xlsx) PDF (.pdf) CSV (.csv)
Best for Sorting, filtering, totals Printing, sending as a record Importing into other software
Title Worksheet name = report title (cut to 31 characters) Report title at the top, with "Generated on <date time> UTC" none
Header row Bold, grey background Bold, grey background, repeated on every page First line
Amounts Real numbers, format #,##0.00 Text with thousands separator and 2 decimals Text with thousands separator and 2 decimals, in quotes when it contains a comma
Dates and times Real dates, format yyyy-mm-dd hh:mm yyyy-MM-dd HH:mm yyyy-MM-dd HH:mm
Dates without time (for example vehicle expiry dates) Text yyyy-MM-dd yyyy-MM-dd yyyy-MM-dd
Whole numbers Numbers Text Text
Signatures (Sign-Off Report) Not included Included as images Not included
Layout Columns sized to their content A4; landscape when there are more than 6 columns, otherwise portrait; small print; page numbers "n / total" at the bottom right Comma separated, UTF-8
Totals row none none none

Tip

No file has a totals row, the school's name or logo, or a line stating the period and branch. Note the period yourself, for example in the file name.

Notes:

  • In CSV, values containing a comma, a quotation mark or a line break are wrapped in quotation marks.
  • Because CSV amounts are written with a thousands separator ("1,250.00"), spreadsheet programs may read them as text. Use the Excel format when you want to calculate.
  • A PDF with many columns (for example the Vehicle Report with 17) has narrow columns; use Excel for wide reports.
  • Yes/no fields appear as True or False.

File names

<report title in lower case with hyphens>-<yyyyMMddHHmmss>.<xlsx | pdf | csv>

For example lesson-report-20261118093015.xlsx. The time stamp is in UTC.

Report File name starts with
Student Report student-report-
Lesson Report lesson-report-
Sign-Off Report sign-off-report-
Driving Test Report driving-test-report-
Financial Report financial-report-
Vehicle Report vehicle-utilization-report-
Instructor Earnings Report instructor-earnings-report-

Sign-off signatures

The Sign-Off Report's PDF (with signatures) embeds the instructor's and the student's signature for every row, using the full-size signatures. A missing signature prints as "-". Excel and CSV leave the two signature columns out. See Sign-Off Report.

Who can export

Important

Exporting needs exactly the same permissions as viewing the report: Reports.View plus the report's own permission, and the Reports plan feature. There is no separate export permission. A user tied to one branch gets only that branch's rows.

Messages

Message Meaning
"Please select a date range first." From or To is empty.
"Unable to export <name> report." The server refused or failed, for example because access was removed or the period is invalid.
"Export failed: ..." A connection or browser problem; the reason follows the colon.

Example

The owner needs proof of all lessons Sipho Mokoena attended in October. She opens the Sign-Off Report, chooses Last month, clicks the funnel next to Student, types "mokoena", checks the table, then clicks Export > PDF (with signatures). The PDF lists Sipho's signed October lessons with both signatures.

Limitations and notes

  • No export of summary cards, charts or breakdown tables.
  • No export of the Reports Overview, the dashboard or the list pages.
  • No scheduled or emailed exports.
  • No choice of columns, and column headings cannot be renamed.
  • Times in exported files are written as stored by the server; signing times in the Sign-Off export may differ from the local times shown on screen.
  • Very large periods are exported in one go and can take a while, especially the sign-off PDF.
  • When called directly through the API without dates, the lesson, sign-off, driving test and financial exports fall back to the last month. The screens always send dates.