Skip to main content

​
Purpose

The purpose of this quick reference guide is to step through the process of reviewing the Reconciliation results, which is the next step after the creation of a Reconciliation record. The intended audience for this document are System Administrators and Payroll Users. The review of Reconciliation History is performed to view Successful and Failed results of a Reconciliation and to manually investigate the Results Status and the Variances within them via the Reconciliation Item.

​
Steps

​
Review Reconciliation History (Results)

To review Reconciliation History (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 Reconciliation History sub-tab is selected to view Reconciliation Results. (See Figure 3)
    Figure 3
  3. To filter the Reconciliation Processes that will display, populate from the available fields of Date Range From and To, Record Type, Payment Entity, Pay Code, Employee and Payee as required. To search for all the Reconciliation Processes, you can leave the fields blank and skip to step 5.
  4. Click on the Search button. (See Figure 4)
    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 filter fields).
    Figure 4
  5. A list of Reconciliations matching any filters used will appear in order of most recent at the top. (See Figure 5)
    Figure 5
    If you wish to adjust the width of columns in the listed Reconciliations to display the full headings and results data, you can move the columns to display a wider or narrower width as required.
  6. To review in further detail the breakdown of a Reconciliation record, click on the Reconciliation Record number starting with TREC-xxxxxxxxxx in blue colour. (See Figure 6)
    Figure 6
  7. On the Reconciliation Record, users can view the number of Reconciliation Items that reconciled successfully, the number that failed, and any excluded payees. There is also a report on the right to visually identify the mix across successful and failed Reconciliation Items.
  8. To review the individual Reconciliation Items in more detail, click on the Related list. (See Figure 7)
    Figure 7
  9. Within the Reconciliation Items related list, click the View All button on the bottom of that section. (See Figure 8)
    Figure 8
  10. On the Reconciliation Items Related List View, users can arrange the results in ascending order to view the failed results on top.
    Figure 9
    If the Reconciliation contains only success results, there is no need to proceed to the steps contained in the QRG Resolving Failed Reconciliation Results. The Manage Variance tab is only required to be accessed if there is a need to resolve failed Reconciliation Items.A separate Reconciliation Item record is created for each unique Record Type and Pay Code combination.
  11. Click the Reconciliation Item Name TRECI-xxxxxxxxxx to view in further detail the Reconciliation Item. (See Figure 10)
    Figure 10
  12. A failed result occurs when the Opening Balance YTD plus the Pay Transactions YTD does not balance the amount in the Payee Aggregates YTD. The result of this equation will populate in the Variance field, so any value other than $0.00 will be failed and require investigation before proceeding with year end processing.
    Figure 11
  13. To investigate any issues within the original Pay Batch processed, scroll down to the Pay Batch Information section and click on the Pay Batch name. (See Figure 12)
    Figure 12

​
Delete Reconciliation History (Results)

To delete Reconciliation records and the associated Reconciliation Items, the following steps should be followed:
  1. Go to the list of Reconciliations within the Reconciliation History page and select the checkbox(es) of Reconciliations to be deleted.
  2. A Delete button will display.
  3. Select the Delete button to delete the selected Reconciliation(s) and the related Reconciliation Items. (See Figure 13)
    Figure 13

​
Do Not Delete - Reconciliation History (Results)

To protect a Reconciliation record and the associated Reconciliation Items from being deleted, the following steps should be followed:
  1. Go to the list of Reconciliations within the Reconciliation History page and open the record that you would like to protect from getting deleted. (See Figure 14)
    Figure 14
  2. On the Page Layout, click the Edit icon that’s located on the right hand side of the Do Not Delete field. (See Figure 15)
    Figure 15
  3. Tick the Do Not Delete checkbox and click the Save button. (See Figure 16)
    Figure 16
  4. The Do Not Delete field will display the checkbox ticked. (See Figure 17)
    Figure 17
  5. All Reconciliations marked as Do Not Delete will display a tick in the Protected column within the Review Reconciliation Manager, and will not be deleted using the Manager whilst the checkbox remains checked. (See Figure 18)
    Figure 18
  6. If you try to delete the protected Reconciliation record, you will notice that the Delete button does not appear upon selecting the record.

​
Field descriptions

No field descriptions are required for this QRG document.

​
Further information