Balance Residual Gross to the Payroll Report

At End of Year, you can reconcile Residual Gross on STP Update with the Payroll Report. You can also use the IQ-YTDVAL to reconcile which components are included in the Reporting Groups on the STP Update.

To do this, watch the video or follow the steps below:

Go to Payroll, Reports, Transactions, Payroll Report.
Select all Pay Frequencies.
Ensure that YTD Cumulatives From and To Dates include all paid period end dates in the Financial Year.
Under Totals Options, tick Show Company Totals.
Tick Include Employees not Paid, Include Terminated Employees, Show Hours by Rate Details, and Show Employee Additions / Deductions under Display Options.
Produce the report and save or print a copy.
Next go to Payroll, Transactions, Import and Export, STP Update.
Select the Payroll Company. If you have multiple companies, you will need to run them separately.
Tick All for Employee and select the current Financial Year.
Under Finalise Employees, tick All Employees paid in the selected Financial Year.
Click Apply.
This will populate the STP Update grid with all employees paid in the selected Financial Year.
Ensure that the grid includes the below columns:
- Gross Taxable
- PAYGW (Tax)
- ETP PAYGW Total
- FEI Aus Tax Paid (if you have employees with Foreign Employment Income and the Transaction Paid option is Values not in System)
- Net Pay
- Residual Gross (STP)
- Total Paid Leave
- Director's Fees
- Overtime
- Bonuses and Commissions
- Total Lump Sum
- ETP Taxable Total
- ETP Tax Free Total
- CDEP Payments
- Total Sal Sac
- Deductions Workplace
- Total Allowances
If the columns are not in the grid, right-click and choose Customise Grid Columns to drag the columns into the grid.
Gross Taxable, PAYGW (Tax), ETP PAYGW Total and Net Pay on the STP Update should balance to Gross Taxable, Tax (incl Adjust), and Net Pay on the Payroll Report.
Using the table below, compare the values on the Payroll Report to the totals at the bottom of STP Update for each company. The Gross Taxable from the Payroll Report should match the Total value calculated in the table.

Note: Total Allowances in STP Update includes all Additions that have a STP2 Reporting Group of Allowance Items, meaning that it consists of both Before and After Tax additions. However, when balancing Gross Taxable from the Payroll Report to Residual Gross in STP Update, you only need to include Additions Before Tax that have a STP2 Reporting Group of Allowance Items. Use IQ-YTDVAL to find the Additions to include. You can filter the IQ based on Reporting Group and Add/Ded Before Tax and then total the values.

	Payroll Report	STP Update
Gross Taxable			Residual Gross
			+ Total Paid Leave
			+ Director's Fees
			+ Overtime
			+ Bonuses and Commissions
			+ Total Lump Sum
			+ ETP Taxable Total
			+ ETP Tax Free Total
			+ CDEP Payments
			- Total Sal Sac
			- Deductions Workplace (Before Tax Only)
			+ Total Allowances (Before Tax Only)
			Total

Note: In the table above, enter the total for any before tax Workplace Giving in the Deductions Workplace box.

If you don't balance, check the following:

Ensure you have included the correct parameters in the Payroll Report and STP Update as per the above details.
RDO Pay is included in Paid Leave.
RDO Deduct is included in Residual Gross.
Total Allowance in the STP Update includes all Additions (both before and after tax) that have Allowance Items as the STP2 Reporting Group.
Any employees with FEI values that have Values not in System for Transaction Paid will be included in the STP Update but not in the Payroll Report and should be deducted from Residual Gross, Tax, etc.

If you want to balance values entered as RFB Exempt, RFB Taxable, Exempt Foreign Income, or Foreign Employment Income, you can include these columns in the STP Update.

If you want to balance Super Liability (SG) to the Payroll Report Superannuation value, you will need to take into account:

Any Employer Contribution allocated to Reportable Super (RESC). These values will display in the RESC column.
Any Employer Contribution that has been excluded from STP Reporting.
Any Employer Contribution that is set up as a deduction but flagged as Employer Contribution (STP).