WHAT IS ARREARS CALCULATION EXCEL SHEET?

Arrears in salary means payments or the payments outstanding that are to be made after the employee have performed work but it is not scheduled for distribution at the time payroll period. Generally arrears are considered only when the overdue of payment from the employer is still not scheduled or delayed or employee is promoted and increment sated in promotion letter but salary payment is unchanged In order to avoid the arrears in salary if payment of one month is delayed employer need to make overdue payment at next payroll period. Arrears in salary can be delayed payment of basic pay or allowances or it can be caused if deductions are made more than what is to be. Arrears in the salary can be confirmed if the employee missed a month of payment of the payroll period or deduction of payment that has to be paid under normal conditions.

Arrear Calculation in excel sheet contains following terms

1. Employee code
2. Employee name with effect from
3. Loss of pay month
4. New salary
5. Old salary details

Salary template contains

• Basic pay
• FDA
• HRA
• DA
• Medical reimbursement
• Gross pay