---
title: "STP reconciliation"
id: "stp-reconciliation"
project: "EHR User Guide"
url: "https://help.cloud5.com.au/articles/ehr-user-guide/stp-reconciliation"
updated: 2026-10-19T00:53:34Z
---

# STP reconciliation

| We recommend you balance STP .**xml**files after every pay run rather than wait until the end of the financial year.<br><br>Consider the number of changes that typically occur throughout the course of a year. Managing them as they crop up makes life easier when busy EOFY comes around. |
| --- |

This topic explains the EmpowerHR reports you can run and use together for reconciliation of EOFY ![](/resources/Storage/ehr-user-guide/icons/leave%20-%20info%20icon.png) STP files. It's only intended to provide guidance and is no substitute for sound skills and experience in payroll management.
EOFY = End Of Financial Year

| ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | **Reminder about running payroll events before EOFY**<br><br>At any time before EOFY, you can run an STP payroll event. Just remember to set:<br><ul style="color: #4d4d4d; text-align: left; text-decoration-color: initial;"><li><span style="font-family: Arial, &quot;Helvetica Neue&quot;, Helvetica, sans-serif;"><span style=""><b>Final Event</b>&#160;to<b>&#160;n&#160;</b>(no)</span></span></li><li><span style="font-family: Arial, &quot;Helvetica Neue&quot;, Helvetica, sans-serif;"><span style=""><b>Full File Replacement</b>&#160;to&#160;<b>n</b>&#160;(no)</span></span></li></ul><br>For instructions, see the topic, [Run an STP payroll event](/articles/ehr-user-guide/run-an-stp-payroll-event). |
| --- | --- |

## 

## Your EOFY processing checklist

Here's a checklist to help prepare for EOFY processing.![](/resources/Storage/ehr-user-guide/icons/pencil.png)

* * *

| ![](/resources/Storage/ehr-user-guide/icons/checkbox%20icon.png) | Remember, do *not* run the payroll event with the Final Event flag set to y (yes) until you're confident everything balances. |
| --- | --- |
| ![](/resources/Storage/ehr-user-guide/icons/checkbox%20icon.png) | Make sure you check all errors and warnings from the payroll event’s first output text file and fix any issues. |
| ![](/resources/Storage/ehr-user-guide/icons/checkbox%20icon.png) | If you know you'll require ad hoc pay runs to fix discrepancies (or you’re unsure whether an ad hoc pay will be required), then load your last normal pay period payroll event before finalising the end of year. |
| ![](/resources/Storage/ehr-user-guide/icons/checkbox%20icon.png) | Go through the reconciliation process using the last pay period **Paid Date** details. |
| ![](/resources/Storage/ehr-user-guide/icons/checkbox%20icon.png) | Run any required ad hoc pays with dates prior to 30 June to fix any discrepancies. |
| ![](/resources/Storage/ehr-user-guide/icons/checkbox%20icon.png) | Go through the reconciliation process again if you feel you need to confirm balancing. |
| ![](/resources/Storage/ehr-user-guide/icons/checkbox%20icon.png) | Run an **STP Update Event - Phase 2 (prrstp22)** with the **Final Event for Fin Year** flag set to **y** (yes) and the date set to 30 June. |
|  | | ![Information](/resources/Storage/ehr-user-guide/ehr-user-guide/Info.png) | After 30 June, you can only run update events. |<br>| --- | --- | |
| ![](/resources/Storage/ehr-user-guide/icons/checkbox%20icon.png) | You can start running STP payroll events for the next financial year. |

* * *

## Report summary

Here's a summary of the reports to use in the reconciliation process.

![](/resources/Storage/ehr-user-guide/reconciliation/report%20summary.png)

* * *

## 

## Running the reports

### STP checking report – phase 2 (crrstpck)

Run this report after running an STP payroll event. It produces a list of all employees processed in the payroll event and shows the individual components reported in the .**xml** file you send to the ATO ![](/resources/Storage/ehr-user-guide/icons/leave%20-%20info%20icon.png).
ATO = Australian Taxation Office
Some of the main STP sections (which the ATO refers to as tuples ![](/resources/Storage/ehr-user-guide/icons/leave%20-%20info%20icon.png)) are included in the output. Where a section has multiple types of tuple codes, EmpowerHR only includes columns for those used in accumulating the payment code totals.
A tuple is a *container* of a group of two or more related data elements, in other words, a section in the pay event that has a subset of fields.
To run this report (**crrstpck**): ![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png)

1. Go to **Background Jobs** &gt; **STP** &gt; **STP Files Generation** &gt; **STP Checking Report - Phase 2**
2. Complete the parameters, including:

* **Payroll Code**
* **Paid Date** – enter the same date you set for the payroll event
* **Submission ID** – enter an individual submission ID if you want to look at a specific **.****xml** file, otherwise enter **%** for everything created in the payroll event

* * *

### Pay reconciliation (RTF) (prrprece)

This is a standard EmpowerHR report you can use when reconciling YTD ![](/resources/Storage/ehr-user-guide/icons/leave%20-%20info%20icon.png) values for individual payment codes.
YTD = Year To Date
You’d normally run this report after processing a pay run to check total payments for the pay period.

You can also use this report to check the Payer Gross ![](/resources/Storage/ehr-user-guide/icons/leave%20-%20info%20icon.png) and Payer PAYGW ![](/resources/Storage/ehr-user-guide/icons/leave%20-%20info%20icon.png) totals from the **STP Checking Report – Phase 2 (crrstpck)**.
Payer Gross is the total Gross payment accumulated since the last time you ran the STP payroll eventPAYGW (Pay As You Go Withholding) is the total of all tax payments recorded in the Pay Reconciliation (RTF) report
To run this report (**prrprece**) for EOFY balancing (or any time during the year to balance YTD values): ![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png)

1. Go to **Background Jobs** &gt; **Payroll Processing** &gt; **Pay Run** &gt; **Pay Reconciliation (RTF)**
2. Complete the parameters, including:

* **Payroll Code**
* **Sort Option (L,S,D,A)** – enter **A** to sort by ABN
* **Date From** – enter 1 July in the current financial year
* **Date Upto** – enter the same **Paid Date** you set for the payroll event or, if the last period for the tax year has been processed, enter the financial year end date

| Reconcile this report with... |
| --- |
| <ul style="color: #4d4d4d; text-decoration-color: initial;"><li><span style="font-size: 10pt;"><span style="font-family: &quot;Segoe UI&quot;, Frutiger, &quot;Frutiger Linotype&quot;, &quot;Dejavu Sans&quot;, &quot;Helvetica Neue&quot;, Arial, sans-serif;"><b>STP Payment Code Totals Reconciliation</b><b>&#160;(xstp005k)</b>&#160;- match the YTD values for each payment code between the two reports&#160;</span></span></li><li><span style="font-size: 10pt;"><span style="font-family: &quot;Segoe UI&quot;, Frutiger, &quot;Frutiger Linotype&quot;, &quot;Dejavu Sans&quot;, &quot;Helvetica Neue&quot;, Arial, sans-serif;"><b>STP Pay History Reconciliation Checking&#160;</b><b>(xstp006k)</b>&#160;- match the YTD values for each payment code under section 3 of the xstp006k report&#160;</span></span></li></ul> |

* * *

### STP payment code totals reconciliation (xstp005k)

This report is output to PDF and includes all processed payment codes.

The report is sorted by tuples ![](/resources/Storage/ehr-user-guide/icons/leave%20-%20info%20icon.png)used by the ATO and payment codes are grouped in the individual tuples. Where a main tuple (e.g. Disaggregation of Gross) contains multiple individual tuples, they are each recorded separately.
A tuple is a *container* of a group of two or more related data elements, in other words, a section in the pay event that has a subset of fields.

To run this report (**xstp005k**): ![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png)

1. Go to **Background Jobs** &gt; **STP** &gt; **STP Reconciliation Reports** &gt; **STP Payment Code Totals Reconc**
2. Complete the parameters, including:

* **Fin Year Start Date** – enter 1 July for the current financial year
* **Fin Year End Date** – enter 30 Jun for the current financial year or, if you haven’t finished processing for the current financial year, enter the same **Paid Date** you set for the payroll event
* **Payroll Code** – enter an individual payroll code (recommended if you entered an individual payroll code for the **P** **ay Reconciliation (RTF)** report), or else enter **%** if employees move between payrolls
* **Summarise By (c,p or a)** – enter **a** to sort by ABN

#### 

| Reconcile this report with... |
| --- |
| <ul style="color: #4d4d4d; text-decoration-color: initial;"><li><span style="font-size: 10pt;"><span style="font-family: &quot;Segoe UI&quot;, Frutiger, &quot;Frutiger Linotype&quot;, &quot;Dejavu Sans&quot;, &quot;Helvetica Neue&quot;, Arial, sans-serif;"><b>Pay Reconciliation (RTF)&#160;</b><b>(prrprece)&#160;</b>– match the YTD values for each payment code between the two reports</span></span></li><li><span style="font-family: &quot;Segoe UI&quot;, Frutiger, &quot;Frutiger Linotype&quot;, &quot;Dejavu Sans&quot;, &quot;Helvetica Neue&quot;, Arial, sans-serif;"><span style="font-size: 10pt;"><b>STP Pay History Reconciliation Checking&#160;</b><b>(xstp006k)&#160;</b>– match the YTD values for each payment code under Section 3 of the xstp006k&#160;report and make sure each payment code is recorded under the same tuple</span></span></li></ul> |

* * *

### STP pay history reconciliation checking (xstp006k)

This report extracts data directly from the Pay History table. It:

* defaults to Excel output
* can only be run for one **Submission ID**at a time (relating to one ABN)
* contains three sections

To run this report (**xstp006k**): ![](/resources/Storage/ehr-user-guide/ehr-user-guide/icons/desktop%20icon.png)

1. Go to **Background Jobs** &gt; **STP** &gt; **STP Reconciliation Reports** &gt; **STP Pay Hist Rec Check Phase 2**
2. Complete the parameters, including:

* **Fin Year Start Date** – enter 1 July for the current financial year
* **Fin Year End Date** – enter 30 Jun for the current financial year or, if you haven’t finished processing for the current financial year, enter the same **Paid Date** you set for the payroll event
* **Payroll Code** – enter an individual payroll code (recommended if you entered an individual payroll code for the **Pay Reconciliation (RTF)** report), or else enter **%** if employees move between payrolls
* **Submission ID** – enter the submission ID

Here's a description of the three sections in this report.

| Section 1 | Employee detail<br><br>Section 1 provides a record for every employee processed for the **Submission ID** parameter you entered.<br><ul><li><span style="font-size: 10pt;">Where an employee has YTD values against multiple payroll codes, they have a separate line per payroll code.</span></li><li><span style="font-size: 10pt;">Fields include:</span><ul><li><span style="font-size: 10pt;">employee code</span></li><li><span style="font-size: 10pt;">employee name</span></li><li><span style="font-size: 10pt;">payroll code </span></li><li><span style="font-size: 10pt;">various columns&#160;(e.g. gross pay, overtime, leave, etc) showing the YTD value paid in each</span></li></ul></li><li><span style="font-size: 10pt;">You can check YTD values for individual employees against their:</span><ul><li><span style="font-size: 10pt;">records in the&#160;<b>STP Checking Report - Phase 2</b> (crrstpck)</span></li><li style="font-size: 10pt;"><span style=""><b>Pay Journal Enquiry </b>screen</span></li></ul></li><li><span style="font-size: 10pt;">Below each ABN, totals for each individual column are included. You can check these totals against totals in:</span><ul><li><span style="font-size: 10pt;"> Section 2 of this report, <i>and</i></span></li><li><span style="font-size: 10pt;">the&#160;</span><span style="font-size: 10pt;"><b>STP Payment Code Totals Reconciliation</b> (</span><span style="font-size: 10pt;">xstp005k) report</span></li></ul></li></ul> |
| --- | --- |
| Section 2 | Pay history reconciliation totals<br><br>Section 2 provides a summary of every column in Section 1.<br><ul><li><span style="font-size: 10pt;">Balance the:</span><ul><li><span style="font-size: 10pt;">totals from Sections 1 and 2 of this report output</span></li><li><span style="font-size: 10pt;">totals for each STP category listed in this report to the same details in the&#160;<b>STP Payment Code Totals Reconciliation</b>&#160;(xstp005k) report&#160;</span></li></ul></li></ul> |
| Section 3 | YTD pay history reconciliation by STP groups/pay code/payroll<br><br>Section 3 provides a listing of all payment codes processed for the reporting date range parameters you entered.<br><ul><li><span style="font-size: 10pt;">Where employees have been paid across multiple payroll codes under the same ABN:</span><ul><li><span style="font-size: 10pt;">the YTD values are split across the relevant payroll</span></li><li><span style="font-size: 10pt;">there is a separate column for each payroll code</span></li></ul></li><li><span style="font-size: 10pt;">This report is split into the different main tuples and then the individual tuples recorded under the STP <b>.xml</b> file.</span></li><li><span style="font-size: 10pt;">Under each STP sub-group, the individual payment code that makes up the sub-group is recorded with its YTD values.</span></li><li><span style="font-size: 10pt;">Where a payment code has been defined as a special type (e.g. leave, allowances, etc), the code is included and can be checked.</span></li><li><span style="font-size: 10pt;">You can use Section 3 output to check the payment code YTD totals against the:</span><ul><li><span style="font-size: 10pt;"><b>Pay Reconciliation (RTF)</b>&#160;(prrprece) report, <i>and</i></span></li><li><span style="font-size: 10pt;"><b>STP Payment Code Totals Reconciliation</b>&#160;(xstp005k) report </span></li></ul></li></ul> |

| Next topic<br> <br>[FAQs](/articles/ehr-user-guide/faqs) |
| --- |

© 2023 Fusion5. All rights reserved.