Audit Records
Audit records improve transparency, and can help strengthen internal controls - helping you operate with confidence. Projectworks captures audit logs for a number of important actions and changes that are made.
What Actions are Audited?
Projectworks audit records provide a time-stamped log to answer key questions such as:
-
What changed?
-
Who made the change?
-
When was it changed?
-
What was the previous value?
We currently log audit events for the following entities when they are created, edited, or deleted:
-
Expenses;
-
Integrations;
-
Invoices;
-
Leave;
-
Projects;
-
Resourcing;
-
Time Entries; and
-
Timesheets.
How can I access these audit logs?
If you have connected to Projectworks from Microsoft Power BI, you can build your own audit report in Power BI.
Read more about how to connect Power BI to Projectworks →
We have created some Projectworks managed reports containing the audit logs for some entities.
|
Entity |
Projectworks managed report name |
|---|---|
|
Timesheets |
Timesheet Audit Report |
|
Time Entries |
Time Entry Audit Report |

Like all Projectworks Managed Reports, if you have access to Custom Reporting, and “Can Edit” reports, you can duplicate the audit reports and edit them to meet your requirements.
Read more about customizing Projectworks managed reports →
As there are a number of values that belong to some entities (e.g. time entries), there may be multiple rows for a single action. e.g If someone adds a time entry, the following “Look Up Values” will be saved and each value will be represented as a row in the audit report (unless you have filtered by one of these “Look Up Values”):
-
User
-
Task (the timecode ID for the time entry)
-
TaskDate (the date the time entry was logged for)
-
Comment
-
Minutes
-
IsReviewed

In the example, “On call” is a time entry custom field and, so is included as another row for that audit action.
Create your own custom report
If you have access to Custom Reporting, and “Can Manage” reports, you can “Add Custom Report” and build a custom audit report.
Read more about building a custom report using Metabase →
Starting (or Join) data to build a custom audit report
|
Entity |
Starting (or Join) data |
Deafult filter |
|---|---|---|
|
Integrations |
IntegrationAudit |
|
|
Invoices |
InvoiceAudit |
|
|
Leave |
LeaveAudit |
|
|
LeaveLineAudit |
|
|
|
Projects |
ProjectAudit |
|
|
Resourcing |
ResourceAudit |
|
|
ResourceCommentAudit |
|
|
|
Time Entries |
TimeEntryAudit
|
The first time you access the report, the Time Entry Date filter will be set to = Previous 7 days If no time entries have been added for the previous 7 days, the report will be empty. |
|
Timesheets |
TimesheetAudit |
The first time you access the report, the Timesheets filter will be set to = Previous 1 month If no timesheets have been added for the previous month, the report will be empty. |