Arrier Calculate in Exel For SAS Portal
salary arrear calculation excel sheet free download
Download Salary Arrears Calculator Excel Template
Download Salary Arrears Calculator Excel Template
Salary Arrears Calculator is a ready-to-use template in Excel, Google Sheet, and OpenOffice to calculate month wise salary arrears with salary break-up.
Moreover, with the help of this template, you can calculate salary arrears up to 35 years for an employee. Just insert the desired amounts and the template will automatically calculate the arrears for you.
What Does It Mean By Salary Arrears?
The word “Arrears” means previous partial or full overdue of any payments. Salary Arrears means the previous salary dues that an employer pays during the current month or year.
In simple terms, salary arrears are the delayed either the differential payment of incremental salary or full payment normal salary after the due date.
Reasons for Salary Arrears
Usually, these delays can be either natural or artificial. Natural causes include delay in opening a bank account, payment system failures, etc. Whereas artificial causes include, lawsuits, delayed promotions, etc.
An employee’s bank account process took 2 months to open. Thus, he/she receives 2 month’s salary in arrears. It is an example of natural causes.
An employee is due for promotion and not promoted for any company reason. Later on, the company decides to pay him the difference in salary for that delayed period. It is an example of artificial causes.
In simple terms, Salary Arrear is the difference between current and incremental salary.
Let us understand it with an example.
Example
Anuj’s is having a salary of 10,000 salaries. He files a lawsuit for not getting a promotion for a period of time or for some valid reason.
Anuj wins the case. The court instructs the company to pay salary arrears for the past year on a new pay scale which is demanded by Anuj.
Previous Salary Breakup of Anuj = 5,000 Basic + 2,000 HRA + 1,000 DA + 1,000 Conveyance + 1,000 Medical
New Salary Breakup of Anuj = 8,000 Basic + 3,000 HRA + 2,000 DA + 2,000 Conveyance + 2,000 Medical
The total of the previous salary already paid is 10,000 per month and the total of newly approved salary is 17,000.
Now there are 2 scenarios that can be taken into account:
Scenario 1 – Complete Salary Arrears
If the company hasn’t paid a single rupee during that period. In this case, he is entitled to the following:
17,000 X the total number of unpaid months.
Scenario 2 – Partial Salary Arrears
He is paid as per the previous salary that is 10,000. Now he is eligible for the difference of pay.
(17,000 – 10,000) X the total number of partly paid months.
Salary Arrears Calculator Template (Excel, Google Sheet, OpenOffice)
To simplify the process of calculating arrears we have created a simple and easy Salary Arrears Calculator with predefined formulas.
You just need to enter the previous and newly approved amounts under each head of the salary. The template will automatically calculate the difference and provide you with the amount of Salary Arrears.
Download Rar:Click Here
Download In Exel:Click Here
