Payee Reconciliation

Created on Sep 02, 2023 | By Kalpesh Patel
Last Updated on Sep 09, 2023
< All Topics
Print

Payee Reconciliation

Introduction/Purpose:

The purpose of payee reconciliation is to ensure that the financial records of an organization accurately reflect the payments made to its payees. 

Payee reconciliation involves comparing the records of payments made by the organization to the payees against the payees’ own records, such as invoices or statements.It is an important process in financial management to ensure the integrity and transparency of payment operations.

How To Navigate:

The navigation to record a Payee reconciliation in the HRMS system typically involves the following steps:

  • Click on the main navigation icon which is located on the top right corner of the screen then click on the Payroll section which is located on the left side menus on the screen.
  • Click on the Pay Projection section which is located in the Transactions under Payroll. After clicking on this link you can navigate to Pay Projection. Users can view the payee reconciliation section.
  • Click on the Payee Reconciliation, after clicking on this link you can navigate to Payee Reconciliation record, and Listing.

OR

  • Click on the main navigation icon which is located on the top right corner of the screen then click on the Payroll section which is located on the left side menus on the screen.
  • Click on the Payee Reconciliation section which is located in the Transactions under Payroll. After clicking on this link you can navigate Payee Reconciliation record Listing.

Listing:

The user can view the list of all approved or pending payee reconciliation. The key feature of Payee reconciliation listing are: 

  • Pay Projection: 
    • First, the user has to select at least one record from the listing; otherwise, the system will give an error message, “At Least one record should be selected.”
    • After selecting a record, the user clicks on the Pay Projection button The user will able pop-up message “Payee data is reconciled successfully”
  • Hamburger Menu icon: When the user clicks on the hamburger menu icon, the user can perform the following action in this section
  • Import Data: On clicking import data user will able to view a pop-up having the following fields : 
    • Upload Sheet: The user must upload a file in.csv or Excel format in this field. If the user uploads another formatted file, then the system gives an error saying “The file is not acceptable.”
    • Date Format: The user has to select the date format from the drop-down menu such as
      • Y-m-d
      • d-m-Y
      • m/d/Y
      • Y/m/d
      • d.m.Y
    • Date Time Format: The user has to select the date time format from the drop-down menu such as :
      • Y-m-d H:i
      • Y-m-d H:i:s
      • d-m-Y H:i
      • d-m-Y H:i:s
      • m/d/Y H:i
      • m/d/Y H:i:s
      • Y/m/d H:i
      • Y/m/d H:i:s
      • d.m.Y H:i
      • d.m.Y H:i:s
    • The user can perform the following operation in this section
      • Next: This option allows the user to preview the sheet. On the Preview  Sheet page, the user can perform the following action:
        • Preview: On clicking this option, the user will be redirected to the sheet page. Here, the user can perform the following options:
          • Import: In this option, the user can import the leave sheet that the user added in the previous steps.
        • Back: This option allows the user to move back to the previous page.
      • Discard: This option allows the user to discard the importing of the leave sheet and back to the leave request page.
  • Export Data: Selected Records, Current Page records or All records can be exported by users with listed Columns or All Columns to a spreadsheet or other file format for further analysis or reporting.

Recording & Update:

The user can view the list of pay reconciliation records. Where users can see columns such as: 

  • Employee code
  • Reference number
  • Tax amount, Employee
  • Employee Payee
  • Employer Payee
  • Tax Paid, Requested amount
  • Approved amount
  • Reconciliation on Status
Table of Contents