Payroll Upload

To view Payroll Upload

On the HR menu, under Payroll, click Payroll Upload.

The Payroll Upload page appears.

Select Tax Adjustment option from the Payroll Upload Template drop down box.

You will find all the monthly input templates in this path.

Under Payroll Download/Upload section, perform the following steps:

Click Download to download the tax adjustment upload excel file

The reports will get generated.

Click to know how to use the navigation bar on the report.

The columns displayed in the Tax Adjustment Upload report are:

Tax Adjustment Upload Details

Field	Description
Employee No.	Displays the number of the employee
Employee Name	Displays the name of the employee
Month	Displays the month for which the tax adjustment is done
Component Code Name	Displays the component code name
Amount For Adjustment	Displays the amount for which the adjustment was done

Update all the inputs in the excel downloaded.

Click Choose File, browse and select the file to upload.

Upload button will get highlighted. Click Upload.
You will get a message with the number of records uploaded.
If any records are not uploaded, Error Log button will get highlighted.
On clicking Error Log button, a file will open showing the errors due to which the uploading of records failed.

Select the One Time Payment option from the Payroll Upload Template drop down box.

Under Payroll Download/Upload section, perform the following steps:

Click Download to download the one time payment upload excel file.

The one time payment reports will get generated.

Click to know how to use the navigation bar on the report.

The columns displayed in the One Time Payment report are:

One Time Payment report Details

Field	Description
Employee No.	Displays the number of employees
Employee Name	Displays the employee name
Month	Displays the month for which the one time payment is done
Component Code Name	Displays the component code name
Amount for payment	Displays the amount to be paid

Update all the inputs in the excel downloaded.

Click Choose File, browse and select the file to upload.

Upload button will get highlighted. Click Upload.
You will get a message with the number of records uploaded.
If any records are not uploaded, Error Log button will get highlighted.
On clicking Error Log button, a file will open showing the errors due to which the uploading of records failed.

Select the Income Tax for the Month option from the Payroll Upload Template drop down box.

Under Payroll Download/Upload section, perform the following steps:

Click Download to download the income tax for the month upload excel file.

The income tax for the month reports will get generated.

Click to know how to use the navigation bar on the report.

The columns displayed in the Income Tax for the Month report are:

Income Tax for the Month Details

Field	Description
Employee No	Displays the number of employees
Employee Name	Displays the employee name
Month	Displays the month for which the income tax upload is done
Component Code Name	Displays the component code name
Tax For The Month	Displays whether the tax for the month has been uploaded or not.

Update all the inputs in the excel downloaded.

Click Choose File, browse and select the file to upload.

Upload button will get highlighted. Click Upload.
You will get a message with the number of records uploaded.
If any records are not uploaded, Error Log button will get highlighted.
On clicking Error Log button, a file will open showing the errors due to which the uploading of records failed.

Select the One Time Deduction option from the Payroll Upload Template drop down box.

Under Payroll Download/Upload section, perform the following steps:

Click Download to download the one time deduction upload excel file.

The one time deduction reports will get generated.

Click to know how to use the navigation bar on the report.

The columns displayed in the One Time Deduction report are:

One Time Deduction Details

Field	Description
Employee No	Displays the number of employees
Employee Name	Displays the employee name
Month	Displays the month for which the one time deduction upload is done.
Component Name	Displays the component name
Amount For Deduction	Displays the amount to be deducted

Update all the inputs in the excel downloaded.

Click Choose File, browse and select the file to upload.

Upload button will get highlighted. Click Upload.
You will get a message with the number of records uploaded.
If any records are not uploaded, Error Log button will get highlighted.
On clicking Error Log button, a file will open showing the errors due to which the uploading of records failed.

Select the Formula Builder option from the Payroll Upload Template drop down box.

Under Payroll Download/Upload section, perform the following steps:

Click Download to download the formula builder upload excel file.

The formula builder reports will get generated.

Click to know how to use the navigation bar on the report.

The columns displayed in the the Formula Builder report are:

Formula Builder Details

Field	Description
Employee No.	Displays the number of employees
Employee Name	Displays the employee name
Month	Displays the month for which the formula builder upload is done
Component Name	Displays the component name
Input Parameter	Displays the input parameter of the formula builder
Unit	Displays the unit of the formula builder

Update all the inputs in the excel downloaded.

Click Choose File, browse and select the file to upload.

Upload button will get highlighted. Click Upload.
You will get a message with the number of records uploaded.
If any records are not uploaded, Error Log button will get highlighted.
On clicking Error Log button, a file will open showing the errors due to which the uploading of records failed.

Select the Formula Builder option from the Payroll Upload Template drop down box.

Under Payroll Download/Upload section, perform the following steps:

Click Download to download the Stop Pay upload excel file.

The formula builder reports will get generated.

Click to know how to use the navigation bar on the report.

The columns displayed in the the Stop Pay report are:

Stop Pay Details

Field	Description
Employee No	Displays the number of employees
Employee Name	Displays the employee name
Status	Displays the status of the employee

Update all the inputs in the excel downloaded.

Click Choose File, browse and select the file to upload.

Upload button will get highlighted. Click Upload.
You will get a message with the number of records uploaded.
If any records are not uploaded, Error Log button will get highlighted.
On clicking Error Log button, a file will open showing the errors due to which the uploading of records failed.

Select the Fixed Deduction option from the Payroll Upload Template drop down box.

Under Payroll Download/Upload section, perform the following steps:

Click Download to download the Fixed Deduction upload excel file.

The fixed deduction reports will get generated.

Click to know how to use the navigation bar on the report.

The columns displayed in the Fixed deduction report are:

Fixed Deduction Details

Field	Description
Employee No	Displays the number of employees
Employee Name	Displays the employee name
Month	Displays the month for which the fixed deduction upload is done
Component Name	Displays the component name
Effective Date	Displays the date on which the fixed deduction is done
Amount	Displays the fixed amount to be deducted

Update all the inputs in the excel downloaded.

Click Choose File, browse and select the file to upload.

Upload button will get highlighted. Click Upload.
You will get a message with the number of records uploaded.
If any records are not uploaded, Error Log button will get highlighted.
On clicking Error Log button, a file will open showing the errors due to which the uploading of records failed.

Select the Fixed Earning option from the Payroll Upload Template drop down box.

Under Payroll Download/Upload section, perform the following steps:

Click Download to download the Fixed Earning Upload excel file.

The fixed earning upload reports will get generated.

Click to know how to use the navigation bar on the report.

The columns displayed in the Fixed Earning Upload report are:

Fixed Earning Upload Details

Field	Description
Employee No	Displays the number of employees
Employee Name	Displays the employee name
Month	Displays the month for which the fixed earning upload is done
Component Name	Displays the component name
Effective Date	Displays the date on which the fixed earning upload is done
Amount	Displays the fixed earning amount

Update all the inputs in the excel downloaded.

Click Choose File, browse and select the file to upload.

Upload button will get highlighted. Click Upload.
You will get a message with the number of records uploaded.
If any records are not uploaded, Error Log button will get highlighted.
On clicking Error Log button, a file will open showing the errors due to which the uploading of records failed.

Select the Hold and Release option from the Payroll Upload Template drop down box.

Under Payroll Download/Upload section, perform the following steps:

Click Download to download the Hold and Release excel file.

The Hold and Release reports will get generated.

Click to know how to use the navigation bar on the report.

The columns displayed in the Hold and Release report are:

Hold and Release Details

Field	Description
Employee No	Displays the number of employees
Employee Name	Displays the employee name
Month	Displays the month for which the hold and release is done.
Status	Displays the status of the employee
Hold and Release Month	Displays the month for which the hold and release will be done

Update all the inputs in the excel downloaded.

Click Choose File, browse and select the file to upload.

Upload button will get highlighted. Click Upload.
You will get a message with the number of records uploaded.
If any records are not uploaded, Error Log button will get highlighted.
On clicking Error Log button, a file will open showing the errors due to which the uploading of records failed.

To Re-upload a file, template can be uploaded with changes if needed.

On re-upload, if system identifies repeat records, it will pop up a screen with three options.

Replace - Will replace earlier record for each employee with the new record found for the respective employee
Ignore - Will ignore the new record and keep the earlier record for the employee that was uploaded.
Cumulate – Will add the value of the new record uploaded to the earlier value for the respective employees.

Click OK to save the changes done or else click Cancel.

Click to know more:

Payroll

Loan Mapping

Form 16

Form 16 Acknowledgement

Full and Final Settlement

Hold and Release Pay

Loan Master

LOP/LOP Reversal Upload

Transition Data Upload

IT Plan or Proof Upload

Payroll Download