Skip to main content

Purpose

The purpose of this quick reference guide details how to perform a Payroll Reconciliation which will create a Reconciliation Record and Reconciliation Items to report the results. The intended audience for this document are System Administrators and Payroll Users. The Reconciliation process outlined in all the quick reference guides combined is used to compare the Opening Balances, Pay Transactions and Payee Aggregates to ensure the figures balance, and once balanced, provide confidence for the Final Update Event for STP Lodgements to be sent to the ATO.

Steps

Process a new Reconciliation

To create a Reconciliation, the following steps should be completed:
  1. Click on the App Launcher icon. (See Figure 1)
Figure 1
  1. Go to the Reconciliation Manager App by using the Search function. (See Figure 2)
    Figure 2
  2. In the Reconciliation Manager App, ensure the Reconciliation Details sub-tab is selected to process a new Reconciliation. (See Figure 3)
    Figure 3
  3. Populate the following optional fields to filter the records: (See Figure 4)
    1. Payment Entity (maximum 10 if required).
    If no Payment Entity is selected before proceeding, the process will be run for all Payment Entities that are listed in the Available section.
  4. Populate the following required fields to filter the records: (See Figure 4)
    1. Period
      1. Since Last Reconciliation
        • When this option is selected, Last Reconciled Date and EFY Date fields appear automatically, and are pre-populated.
      2. Custom Payment Date
        • When this option is selected, Custom Date From and Custom Date To fields appear automatically and need to be populated by the user.
      3. EFY 30 June
        • When this option is selected, the Year field will appear automatically and needs to be populated by the user.
    2. Reconcile Payees
      1. Failed Payees Only
      2. Everyone
    When populating the Custom Date or the Year fields manually, please ensure to populate dates within a specific Financial Year. Dates ranging over two or more Financial Years cannot be populated, and a validation error will advise users of this.
  5. Click on the Begin button.
    Figure 4
  6. A notification message will appear advising “A batch job for reconciliation has been successfully initiated.” This process could take a number of hours, depending on the volume of Payees and Pay Transactions to be reconciled. There is a progress bar which will keep users updated with how the process is progressing, along with the percentage currently completed. (see Figure 5)
    Figure 5
  7. When completed, another notification will appear advising “Reconciliation process completed successfully. Please review the new Reconciliation record TREC-xxxxxxxxxx for further details.” (see Figure 6)
    Figure 6
The progress bar stays on the page when navigating anywhere within the Reconciliation Manager. If you navigate to a different object, then it disappears.
  1. If successful, a new Reconciliation record will be created.
A single Reconciliation record will be created for the whole process regardless of the Payment Entities selected. This Reconciliation record contains multiple Reconciliation Items that relate to various Payment Entities, Payees and Payee Aggregates.
  1. If unsuccessful, a red notification message will be displayed, indicating “There were one or more errors in the process. Please review the debug header for further details.”. If you need help resolving the error within the Debug Header, please contact your Customer Support Team. (see Figure 7)
Figure 7
  1. For steps on how to review the results of the Reconciliation, please review the QRG Review Reconciliation History (Results).

Field descriptions

No field descriptions are required for this QRG document.

Further information