Payroll overpayment

Hi Ly 

Looking at those screenshots the Summary of payments report matches the Payroll register and activity reports.

Total Wages on the Payroll register and activity reports is $83,688.87, this includes all wage payroll categories.

The Summary of payments reports the amounts according to the ATO reporting category assigned to the payroll category. If you add all the ATO reporting categories that are wage payroll categories you've got:

Gross payments $37,026.88 plus Unused leave on termination $41,499.98 plus Paid leave other $5,162.01 equals $83,688.87. So the Summary of payments reconciles with the Payroll activity and register reports.

To assist with reconciling the STP reports and payroll reports run the Payroll summary report in the browser. This report includes the ATO reporting categories so helps with matching the amounts in the payroll reports with the amounts in the STP reports.

The Salary sacrifice amount on all 3 reports is $12,220.00. On the Summary of payments it is reported as Salary sacrifice - other employee benefits. In the Payroll activity and register reports it is reported in the Deductions column as it is a deduction payroll category. These reports show the salary sacrifice amount processed through Process Payroll.

The Account transactions (Accrual) report shows all transactions posted to the selected account so is not a reflection of actual payroll amounts. For example, I processed 3 payruns with salary sacrifice deduction of $300 and I reversed one pay run. So the actual salary sacrifice amount is $600 (2 pay runs):

The Account transactions (Accrual) report has a total of $900 because that total includes the pay transaction that was reversed. In this screenshot the 3 credits of $300 are the 3 pay runs, CD000006 is the reversal and transaction 231 is the liability payment transaction:

Please let me know if you need further help.

If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.