The CIQ-TRNTOT - Summarised Payroll Emoployee Transaction Totals Report summarises transactions totals per employee based on a selected date range. This range can include a single, multiple, and previous financial year periods.
Steps to download and import into MicrOpay:
Download and save to your desktop the CIQ-TRNTOT.zip below:
Unzip the CIQ-TRNTOT.zip to your desktop.
Log into MicrOpay and select a Payroll Database
Go to Common, IQ
From the toolbar, select Import
Browse to select the CIQ-TRNTOT.xml file saved on the desktop
Click Import then OK once the import is complete.
Double-click on the IQ report and the Parameters will appear. There are three Parameters:
Include Terminated = 0 for False and 1 for True
Period End Date From - This Value needs to be a Period End date.
Period End Date To - This Value needs to be a Period End date.
OK to produce the report.
Terminated Employees are excluded from the report by default.
The default Cost Account, Location, Employee Normal Hours and Employee Normal Rate are based on the employee file.