Skip to content
logo Knowledgebase

Audit Reports: How to print the ETI Data Extract

Created on  | Last modified on 

Summary

You require a report for audit purposes for ETI to extract all the ETI information per employee on Sage200c VIP, Sage Classic or Sage Premier

Description

This Audit Reports contain Financial and Employee Reconciliation Reports that present the same information as the Company Reconciliation Report (RN 501), available from the normal Reports Menu, but in a different format.  There are various Audit Reports available and these reports are presented in an HTML format.  The user can either view information on the screen (print preview) or select to print it out. These Reports would typically be part of the Audit Pack required by the Auditors.

Resolution

The Audit Reports are found from the main screen of the company under Reports>Audit Reports. There are 16 audit reports.

To print the ETI Data Report, select Reports>Audit Reports>ETI Data Extract.

Excel will open up - you might be required to click on 'Enable Content' in Excel before the data will merge.

EXAMPLE: 

Image

NOTE: We are aware of instances where the data does not populate correctly and the issue has not been resolved. Should this be the case, you can go to Interfaces>Import Data>Utility Imports>ETI take-on. Select to Export and make the relevant selections to export the data.