Overview of the STP Reconciliation report
We have created a new report called the STP Reconciliation Report. The report is a downloadable Microsoft Excel (xlsx) formatted report.
This report will allow users to compare information derived from the Attache Payroll Pay Totals Report (Payroll, Report, History, Pay Totals) with Information derived from the current STP Income Statement Report.
This report will make STP2 reconciliations during the payroll end-of-year payroll much easier.
The STP Reconciliation Report is available now in Attaché Online, Single Touch Payroll from within an STP batch.
Login to your Attaché Online organisation.
Go to the Single Touch Payroll menu.
Click on the most recent STP batch.
Click the Reports button and then select STP Reconciliation Report.
The STP Reconciliation report will ensure that transactions entered between 01/07 and 30/06 for the financial year and values for Fringe Benefit Tax entered between 01/04 and 31/03 for the financial year are reported correctly, prior to finalizing your employees during your end-of-year period.
The STP Reconciliation Report also includes validation features. The report will highlight in a range of colours, depending on the pay elements. Amounts will display highlighted in red when the value between the Payroll Amount and STP Amount columns do not agree.
You can use the standard Microsoft Excel drop-down filter functionality in each report column header to compare the report sections and include or exclude totals in order to reconcile values.
STP Reconciliation report sections
The STP reconciliation report has 2 tabs, and 2 sections on each tab:
The Desktop Totals tab
Pay Totals Comparison section.
Pay Element totals - Comparison section - separate tables divided into pay element types.
The STP Income Totals tab
Pay Totals Comparison section (a duplicate of the Pay Totals Comparison section from the Desktop Totals tab.
Pay Element totals - Disaggregation of Gross Comparison section - all pay elements combined into one table. This section excludes any pay element that is NOT reported through STP. I.e., Tax Certificate category: 0 = Do not show on Tax Certificate.
Desktop Totals tab: Pay Totals Comparison Section
Previously in Attaché Payroll, you would use the Pay Totals report to reconcile YTD values from the STP Income Statement report.
When a pay is processed in Attaché Payroll, it creates an STP batch in Attaché Online. The STP batch created will contain the YTD totals from that Attaché Payroll processed pay, and the YTD figures will populate in the existing.
The new STP Reconciliation report now brings in Pay Totals figures from Attache Payroll into the Pay Totals Comparison section of the report, so you can reconcile your YTD figures in one central reconciliation view.
The Pay Totals Comparison section displays:
The Attache Desktop Pay Totals Value column and compares to.
YTD values from the STP Income Statement Report in the Income Statement Totals column.
The total number of employees and terminated employees.
The Pay Totals Comparison section brings across all the pay element totals as per the Attaché Payroll Pay Totals report. It itemises total various categories such as:
Salary and Wages.
Allowances.
Leave Loading.
Termination.
Gross.
Deduction.
Tax.
Net Pay.
Contributions.
STP2 YTD breakdown comparison figures display alongside the Pay Totals figures in the Income Statement Totals column.
Note: Negative amounts show in red text by default and this is NOT an issue.
Desktop Totals tab: Pay Element totals - Comparison Section
This report section draws YTD values for each pay element derived from the Attaché Payroll Pay Totals report, which are displayed in the Attaché Desktop Payroll Information column.
YTD values from the STP Income statement report are displayed the STP Income Statement Information column.
This report section breaks down each of the pay element types into sections:
Income Type Totals.
Allowances Totals.
Leave Loading Totals.
Termination Totals.
Deductions Totals.
Contributions Totals.
FBT Totals.
Again, you can use the standard Microsoft Excel drop-down filter functionality in each report column header to compare the report sections and include or exclude totals in order to reconcile values.
Note: Again, negative amounts show in red text by default and this is NOT an issue.
Highlighting and Comments within the Desktop Totals tab: Pay Element totals - Comparison Section
If any variances display in the Pay Element totals - Comparison Section, then the variance will cause the fields under the Payroll Amount and STP Amount columns to highlight with a colour. There will be a comment that will display when you hover over the top right corner of the highlighted STP Amount field. See examples below:
Green highlighting - Nothing needs to be done.
Orange highlighting - Configuration needs to be done.
Red highlighting - various reasons. See table below.
Table of mismatch reasons, comments and suggested action to take
The table below displays:
The Type.
The Reason for Mismatch.
The Comment that will display on the report.
The Highlight Colour you will see.
The suggested action to take.
Type | Reason for Mismatch | Comment | Highlight Colour | Action to take |
Allowance/Deductions | 0 = Do not show on Tax Certificate | The amount is zero as there is no mapping setup for this allowance. Please go to Setup Allowances tab of STP Setups page to map the allowance. | GREEN | No action needed |
Allowance | 2 = Itemise on Tax Certificate - and allowance is not mapped | The amount is zero as there is no mapping setup for this allowance. Please go to Setup Allowances tab of STP Setups page to map the allowance. | RED | Mapping required on STP Setup tab as per comment |
Deductions | 2 = Itemise on Tax Certificate | This amount is expected to be zero. Tax Certificate Category is 2=Itemise on Tax Certificate which is not required for ATO reporting. | GREEN | No action needed |
Deduction | 3 = Child Support Deduction/ 4 = Child Support Garnishee | The amount is zero as Child Support reporting is not enabled for this company. To change this go to System Settings tab of STP Setups | ORANGE | As per comment section |
Contribution | Contribution Category A / Contribution Category O | The amount is expected to be zero as this contribution is not required for ATO reporting. | GREEN | No action needed |
Any | More than one Disaggregation of Gross | There are multiple values for disaggregation of Gross. Causing a double up of values. This is an error. Please contact Access Support to have this issue resolved. | RED | Please raise a new case online and reference the title of this article. Attach a copy of:
|
Allowance Totals | Highlight if STP Amount - Total Payroll Amount = Sum of All (0 = Do not show on Tax Certificate) | Difference between STP Total and Payroll Total is expected as amounts from allowance types of type 0 = Do not show on Tax Certificate are not included. | GREEN | No action needed |
Deduction Totals | Highlight if STP Amount - Total Payroll Amount = Sum of All (0 = Do not show on Tax Certificate and | Difference between STP Total and Payroll Total is expected as amounts from deductions types of type 0 = Do not show on Tax Certificate or 2 = Itemise on Tax Certificate are not included. | GREEN | No action needed |
Contribution Totals | Highlight if STP Amount - Total Payroll Amount = Sum of All (Contribution Category A / Contribution Category O) | Difference between STP Total and Payroll Total is expected as amounts from contribution types of type Contribution Category A / Contribution Category O are not included. | GREEN | No action needed |
All Pay Element Tables Totals | Any other difference in totals than listed above | -No comment- | RED | Please raise a new case online and reference the title of this article. Attach a copy of:
|
Deduction = Tax Cert Type 6 | In this scenario is it will contain More than one Disaggregation of Gross | No Comment Required | BLUE | No action needed |
Deduction - Workplace Giving Tax Certificate Code = 2 Itemise With Workplace Giving Checkbox Currently this will show it being green but not display the content against Workplace Giving | We have missed is in the original development | Workplace Giving has not be setup correctly, The Tax Certificate Code must be set as 2 = Itemise on Tax Certificate, Tax Status must be set to After Tax and the Workplace Giving checkbox is ticked | Red | Modify the Deduction of workplace giving as stated in comment and refresh batch |
STP FBT Amount | We currently handle all values even under the FBT Threshold amount |
Please review FBT Totals using the Allowance, Deduction and Employer Contribution Transaction Reports due to calculation display amounts under the FBT threshold |
|
|
STP Income Totals: Pay Totals Comparison Section
This report section duplicates the Desktop Totals tab: Pay Totals Comparison section exactly, allowing you to compare figures with the Pay Element Comparison section on this tab without having to switch back to the Desktop Totals tab.
STP Income Totals: Pay Element Comparison Section
The Pay Element Comparison Section has been designed to display totals for each pay element in one table (not grouped by Pay Element Type):
Income Types.
Allowances.
Leave Loading.
Terminations.
Deductions.
Contributions.
STP2 values are linked by the configuration in your STP Setup menu, associating your YTD STP2 values, and respective Disaggregation of Gross breakdowns.
This provides the payroll officer with a clear understanding of how their pay elements are categorised for reporting purposes in STP2, in alignment with the YTD values in Attaché Payroll.
Again, you can use the standard Microsoft Excel drop-down filter functionality in each report column header to compare the report sections and include or exclude totals in order to reconcile values.
Note: again, negative amounts show in red text by default and this is NOT an issue
Employee PayLines tab added as of May 2024
A new addition to the report is the Employee PayLines tab, which allows now to break down totals by Pay Element type, by employee.
The top section of the report simulates the Desktop Totals tab.
The bottom section is broken down by pay element type, and you can use the filter drop down arrows to apply. filters drill down further to be able to determine what makes up the total amounts.
