mightymacros Dat Add-in Audit Report

Page 3 of 9

Creating the Dat report

The DAT report needs to be prepared or generated before it can be downloaded into Excel, and split by category/rule type onto worksheet tabs

Prepare DAT report

Analysing the report output

  • Work through selecting one rule tab at a time
  • Check results against ERP and invoice records
  • Determine the cause if any, then select the comment from the dropdown in the comment 'column J' that best fits
  • Click the 'Update' button of the 'Comments' group on the DAT add-in ribbon menu to update or add new comments to the database

Any changes to highlight or minimum values must be done before the report is generated

Sample of the report

DAT Report
Note: The above sample data is fictitious and is not intended to represent any known business or organisation