Skip to main content

​
Purpose

The purpose of this quick reference guide is to step through the process of resolving the Reconciliation results, which is the last step of the Reconciliation process and required only when there are failed results. The intended audience for this document are System Administrators and Payroll Users. The Resolve function is an automated function performed after the manual review to ensure Payee Aggregates balance the Pay Transactions paid throughout the year to Payees.

​
Steps

​
Resolving Failed Reconciliation Results

To resolve failed reconciliation results, 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 Manage Variances sub-tab is selected to search and resolve the Variances. (See Figure 3)
    Figure 3
  3. Populate the following required fields to filter the records: (See Figure 4)
    1. Reconciliation Record
  4. To further filter the variances that will display, populate from the available fields of Record Type, Pay Code, Employee and Payee as required, or skip these fields to display all variances within the Reconciliation Record selected in step 4.
  5. Click on the Search button.
    All of the filters above allow only one value in each field. Therefore, you can either search one item at a time or you can search all (if you skip the field). If you need to review multiple values (two, three or more), they must be reviewed separately.
    Figure 4
  6. A list of Failed Reconciliation Items matching any filters selected will appear in the Variances section. (See Figure 5)
    Figure 5
  7. Select the radio button next to a Reconciliation Item to be resolved.
  8. The Resolve button will appear within the Variances section.
  9. Click the Resolve button. (See Figure 6)
Figure 6
  1. A popup window titled Resolution Required will open. This popup displays the Opening Balance YTD, Pay Transactions YTD, Payee Aggregate YTD, Variance and Expected Value YTD.
  2. Please choose one of the following:
    1. If the popup displays multiple Payee Aggregates, proceed to the next step 13. (See Figure 7)
      Figure 7
    2. If the popup displays only one Payee Aggregate, please skip to step 19. (See figure 8)
      Figure 8
  3. You will need to delete one of the Payee Aggregates first. On the right hand side of the row, select the drop down arrow and then click Delete. (See Figure 9)
Figure 9
  1. When another popup called Confirm Deletion of Record appears, click the Delete button again. (See Figure 10)
Figure 10
  1. A notification will appear indicating “Payee Aggregate PAG-xxxxxxxxxx deleted.” and the Payee Aggregate will be removed from the list of Duplicate Payee Aggregates. (See Figure 11)
Figure 11
  1. Click the Cancel button to close the popup screen. (See Figure 12)
Figure 12
  1. Now click on the Resolve button again. (See Figure 13)
Figure 13
  1. The Resolution required popup will display.
  2. The Amended YTD Value displays with a predetermined suggestion of what the Payee Aggregate should be for the Failed Reconciliation Item to be corrected. This value can be edited manually if you do not agree with the suggested Amended YTD Value provided. To action the Amended YTD Value to the Payee Aggregate, click the Amend Payee Aggregate button. (See Figure 14)
Figure 14
If the user manually puts in an amount different than the suggested value, then it will NOT reconcile successfully in the future when the process is run again.
  1. A Success notification will appear indicating “Records Amended”, and the resolved Reconciliation Item will be removed from the list of variances. (See Figure 15)
Figure 15
  1. To confirm the Failed Reconciliation Item is now resolved, open the Reconciliation Items Related List from the Reconciliation Record, and check the Reconciliation Item is now a Result of Success. (See Figure 16)
Figure 16
  1. Please note, if more than one non-identical Payee Aggregates appear in the popup due to different ATO Income Classifications, it is recommended to contact the Customer Success team to assist with resolving the issue. (See Figure 17)
Figure 17

​
Field descriptions

No field descriptions are required for this QRG document.

​
Further information