---
title: Creating an Excel Audit Report (Audit Log Of Changes)
description: "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 (`admin` role) · **Module:** Set up > Reports >…"
url: "https://support.symbiant.co.uk/kb/excel-audit-report/"
updated: "2026-10-30"
category: Reporting Suite Tutorial
tags:
  - Add
  - Excel
  - Reports
  - Spreadsheets
---

# Creating an Excel Audit Report (Audit Log Of Changes)

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 (`admin` role) · **Module:** Set up > Reports

> **Tip:** Most modules ship with an audit report you can copy, for example **Risk Audit Trail**.

## Opening Reports

1. Click the **Set up** spanner at the bottom left of the screen.
   ![The Set up spanner at the bottom left](https://support.symbiant.co.uk/wp-content/uploads/2026/10/kb-common-setup-spanner-c03de5.png)
2. Under **System**, click **Reports**.
   ![Reports in the Set up menu](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-setup-reports-ab6dd7.png)

1. Click the **+** at the top right to start a new report.
   ![The + button](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-add-plus-d8c64f.png)

## Report Details

1. In **Resource**, choose the module the report pulls data from, for example **Register-Risks**. Type to search the list.
   ![Choosing the Resource](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-new-resource-4eb776.png)
2. In **Name**, enter the report's name as users will see it, for example `Risk Audit Trail (Acme)`.

1. In **Type**, choose **Excel (.xlsx)**. The full list is Word (.docx), Excel (.xlsx), PowerPoint (.pptx), XML and JSON.
   ![The Type list](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-new-type-0e893f.png)
2. 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](https://support.symbiant.co.uk/kb/reporting-permissions/).
   ![Assigning the report to roles](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-new-assign-7012c9.png)

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

1. Under **Data sources**, click **Add New**, then **Audit**.
   ![The Add New list of data source types](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-addnew-4833c6.png)
2. Rename it to something short, for example `ds`. Audit data sources have no fields to choose: they always provide the same set of values.
   ![An Audit data source](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-audit-ds-25c8fa.png)

## 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 |

![The shipped audit template](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-audit-template-b4a864.png)

> **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

1. Under **Document template**, click **Choose File** (or drag the file onto **Drop file here**) and pick your template.
   ![Uploading the template](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-doc-template-new-058b91.png)
2. Click **Save** at the top right.
   ![The Save button](https://support.symbiant.co.uk/wp-content/uploads/2026/10/translators-save-f3437f.png)

## Generating the Report

1. Click the **Set up** button at the bottom left to leave Set up.
   ![Leaving Set up](https://support.symbiant.co.uk/wp-content/uploads/2026/10/kb-common-exit-setup-a986db.png)
2. Click **Reports** at the bottom of the menu on the left.
   ![Reports in the main menu](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-front-nav-d62952.png)
3. Find the report (type part of its name in the **Name** filter) and click **Generate**. The file downloads to your computer.
   ![Generate](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-front-generate-372a86.png)

> **Tip:** Click **Filter** next to **Generate** to limit which records go into the report. See [Advanced Filtering on Reports](https://support.symbiant.co.uk/kb/advanced-filtering-on-reports/).

## The Output

Each change is one row.

![The generated audit report](https://support.symbiant.co.uk/wp-content/uploads/2026/10/rp-audit-output-4644be.png)

## Related articles

- [Creating an Excel Report (Basic Data Output)](https://support.symbiant.co.uk/kb/basic-excel-report/)
- [Advanced Report Syntax](https://support.symbiant.co.uk/kb/advanced-report-syntax/)
