Why does the Payroll Tax and Payroll Summary Reports by State show different data?

We would like to inform you that we have investigated both reports. As per our discussion, we come to the conclusion that the difference observed in these two reports is due to the treatment of exempt allowance amounts in the gross figures.

In the Payroll History Report, we include the exempt allowance total amount in the Gross amount. On the other hand, in the Payroll Tax Report, we do not include the exempt allowance amount in the gross figure. This variance results in the difference in figures between the two reports.

When you run a report without selecting the state, the following figures match between the two reports:

• Normal Hrs Total
• Allowance Total (Exempt + Non-Exempt)
• Overtime Hours Value

However, for the Payroll History Report, we calculate Gross as Exempt Allowance + Non-Exempt Allowance + Overtime Hours Value + Normal Hours Total. In contrast, for the Payroll Tax Report, we calculate Gross by including Normal Hours Total + Overtime Hrs Total + Non-exempt Allowance.

Therefore, the figures differ based on the treatment of allowances.

If you select the state, both reports will provide different figures.

The Payroll Tax Report is generated based on the client's registered state, so it only includes payroll data for clients that are associated with the selected state. For example, if the report is run for VIC, it will only return payroll records for clients registered in Victoria.

The Payroll History Report, on the other hand, is generated based on the member's state. Its purpose is to provide a complete history of payroll transactions according to where the work was performed. Therefore, if a member worked in VIC, their payroll record will appear in the report even if their associated client is registered in NSW, QLD, VIC.