This article shows you how to create an Excel report listing the changes made to a module’s records: what changed, to what, by whom and when.
Applies to: System administrators (
adminrole) ยท Module: Set up > Reports
Tip: Most modules ship with an audit report you can copy, for example Risk Audit Trail.
Opening Reports #
- Click the Set up spanner at the bottom left of the screen.

- Under System, click Reports.

- Click the + at the top right to start a new report.

Report Details #
- In Resource, choose the module the report pulls data from, for example Register-Risks. Type to search the list.

- In Name, enter the report’s name as users will see it, for example
Risk Audit Trail (Acme).
- In Type, choose Excel (.xlsx). The full list is Word (.docx), Excel (.xlsx), PowerPoint (.pptx), XML and JSON.

- Under Assignments, tick who can generate the report: users, roles and/or divisions. In this example, the admin and risk_admin roles. See Reporting Permissions.

Once a type is chosen, the Preferences panel on the right is where you set up the data and the template.
Adding the Audit Data Source #
- Under Data sources, click Add New, then Audit.

- Rename it to something short, for example
ds. Audit data sources have no fields to choose: they always provide the same set of values.
Building the Template #
In Excel, add your headings and put these markers in the row underneath (replace ds with your data source name):
| Marker | What it shows |
|---|---|
{{ds:reference}} | The record reference |
{{ds:attr}} | The field that changed |
{{ds:value}} | The value added or removed |
{{ds:path}:join(/)} | Where the field sits, for example Residual score |
{{ds:added}:bool(Added/Removed/N/A)} | Whether the value was added or removed |
{{ds:by}} | Who made the change |
{{ds:on}} | When the change was made |

Tip: If the On column shows a number instead of a date, format that column in your template as a date and time (Format Cells > Custom, for example
dd/mm/yyyy hh:mm).
Uploading the Template #
- Under Document template, click Choose File (or drag the file onto Drop file here) and pick your template.

- Click Save at the top right.

Generating the Report #
- Click the Set up button at the bottom left to leave Set up.

- Click Reports at the bottom of the menu on the left.

- Find the report (type part of its name in the Name filter) and click Generate. The file downloads to your computer.

Tip: Click Filter next to Generate to limit which records go into the report. See Advanced Filtering on Reports.
The Output #
Each change is one row.

