# WHAT IS ARREAR CALCULATION EXCEL SHEET?

Posted on 31st Jul 2018 | 8421 views

5 avg. rating (100% score) - 1 votes

## Arrear 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

Below is the salary arrears calculation in excel with example

Place the tables in excel sheet to perform the calculations

## Arrears of Salary Calculator

1. The Difference in Salary to be calculated in New Salary - Old Salary based on the With Effect date by affecting the LOP Days

2. In the Above the Current Month is 31 Aug 2018, The Current Month Salary is along with Revision will go in the Current Month of Aug 2018 so the arrears will be calculated up to 31st July 2018

3. If the Current month is 30Sep 2018 then the Arrears will be calculated up to 31Aug 2018

4. The Salary Revision Date is Mentioned in the With effect from column

5. LOP to be input between starting and ending month

6. The Output or Results Should come in The Arrears table

## 0 Comments on WHAT IS ARREAR CALCULATION EXCEL SHEET?

Comment as a guest:

### POPULAR POSTS

 What is Appointment letter Format? 26th Jun 2018 Top 10 facts why you need a cover letter? 08th Jun 2018 Are you looking for a job in Event Management? 28th May 2018 Pharmaceutical job opportunities on rise in Gulf 23rd May 2018 MNC Vs Startup: Are you Confused to Choose between? 08th Aug 2017 Perspectives of Unemployment in India 30th Jun 2013

View All

How consistently does your organization reward you for good work?

Very difficult

Reasonably consistently

Not at all consistently

View All

View All

View All