7th CPC Pay (Basic Salary) and Arrears Calculator for CG Employees 7th Pay Commission Pay Arrears Calculator for Central Govt Employees: Enter Your Basic Pay and Allowances details as on 1.1.2016. We just estimate your 7th Pay Commission arrears. Calculator Prepared By Mr.Khet Singh Gehlot,Programmer(DOITC) 7 th Pay Calculator For Schedule-V (2400,2800,4800) Arrear Sheets. About 7 th Pay Calculator Latest 7 th Pay Commission Arrears Calculator 2016. The government has announced the implementation of Seventh Pay Commission effective from 1 January 2016, that would hike the salaries and allowances for over 1 crore government employees and pensioners by at least 23.5 per cent. Increment Table 7th Pay commission Rajasthan For Level-1 to Level-13. Arrear calculation excel sheet. HRA Sanction Order Excel Utility (by Hansraj Joshi, Principal) वर्कबुक.
7th CPC Pay Calculator for Teachers in Universities and Colleges
7th Pay Commission Teachers, Associate Professor, Assistant Professor in Universities and Colleges PayScale Salary Calculator
Revision of pay of teachers and equivalent cadres in universities and colleges
UGC 7th Pay Commission Salary Calculator for Assistant Professors, Associate Professors and Professors
Pay Review Committee (PRC) constituted by the University Grants Commission (UGC) to revise the pay scales of teachers in the Higher Educational Institutions under the purview of the UGC. We have developed a simple online calculator (not in the excel sheet) to find your new and revised basic pay.
[Note: All figures are indicative]
Revised pay for Teachers in Universities and Colleges
Assistant Professor Pay Scale 6000 GP
- Existing pay: Rs.6000 AGP in PB Rs.15,600- 39,100
- Revised pay: Academic Level 10 with rationalized entry pay of Rs.57,700
Assistant Professor Pay Scale 7000 GP
- Existing pay: Rs.7000 AGP in PB Rs.15,600- 39,100
- Revised pay: Academic Level 11 with rationalized entry pay of Rs.68,900)
Assistant Professor Pay Scale 8000 GP
- Existing pay: Rs.8000 AGP in PB Rs.15,600- 39,100
- Revised pay: Academic Level 12 with rationalized entry pay of Rs.79,800
Associate Professor Pay Scale 9000 GP
- Existing pay: Rs.9000 AGP in PB Rs.37,400- 67,000
- Revised pay: Academic Level 13A with rationalized entry pay of Rs. 1,31,400
Associate Professor Pay Scale 10000 GP
- Existing pay: Rs. 10000 AGP in PB Rs.37,400- 67,000
- Revised pay: Academic Level 14 with rationalized entry pay of Rs.1,44,200
Associate Professor Pay HAG Scale
- Existing pay: Rs.67,000-79,000
- Revised pay: Academic Level 15 with rationalized entry pay of Rs.1,82,200
Also Check: Career Advancement Scheme for Teachers and Civilian Academic Officer of the National Defence Academy
For fixation of pay of an employee in the Pay Matrix as on 1st January 2016, the existing pay (Pay in Pay Band plus Academic Grade Pay) in the pre-revised structure as on 31st December 2015 shall be multiplied by a factor of 2.57.
The figure so arrived at is to be located in the Academic Level corresponding to employee's Pay Band and Academic Grade Pay in the new Pay Matrix.
If a Cell identical with the figure so arrived at is available in the appropriate Academic Level, that Cell shall be the revised pay; otherwise the next higher cell in that Academic Level shall be the revised pay of the employee.
If the figure arrived at in this manner is less than the first cell in that Academic Level, then the pay shall be fixed at the first cell of that Academic Level.
AICTE Pay Matrix Table for Teachers and Academic Staff
| Notification issued by MHRD on 2nd Nov 2017 |
| 7th CPC Pay Matrix for Teachers and Equivalent Cadres in Universities and Colleges |
| 7th CPC Arrears: 30% of Arrears for Non-Teaching Staff of Central Universities |
| Revision of pay of Teachers, Officers and Non-Teaching Staff |
| 7th CPC Pay Matrix for IITs, IISe, IIM, NITIE, IISER, NIT, IIIT |
How is the assistant professor's salary calculated?
As per UGC pay revision order, the Assistant Professor basic salary is Rs. 57700 after 7th pay commission. In 6th CPC, Assistant Professor grade was in Rs. 6000 AGP, now their pay level is 10.
Important Notification by MHRD issued on 2.11.2017
UGC Pay Scale Latest News 2020
- Concordance Pension Table for Retired Teaching and Non-Teaching Staff of University and college July 14, 2020
- AICTE (All India Council for Technical Education) Clarification on 7th CPC Pay Matrix for Teachers of Technical June 6, 2020
- 7th CPC Revised UGC pay scales to the Teachers, Civilian Academic Officer of NDA, Khadakwasla and ACC Wing, IMA April 17, 2020
- Precautions to be taken in light of Novel Coronavirus (COVID-19) – MoHFW Order March 20, 2020
- Revision of UGC Pay Scale from 1.1.2020 in West Bengal November 5, 2019
- Revised rates of Honorarium of Guest Faculty in Universities and Colleges October 9, 2019
- UGC Pay Scal as per 7th Pay Commission February 22, 2019
- Revision of Allowances as per 7th CPC to University and College Teachers January 29, 2019
- 7th CPC to Teachers and Academic Staff of Technical Institutes January 18, 2019
- 7th CPC Arrears: 30% of Arrears for Non-Teaching Staff of Central Universities July 7, 2018
- Implementation of Reservation Policy – UGC March 13, 2018
- 7th CPC Pay Calculator for Teachers in Universities and Colleges November 16, 2017
- TA and Sitting Fee Payable to Official and Non-Official Members/Experts – UGC November 10, 2017
- 7th CPC: Scheme of Revision of Pay of Teachers and Equivalent Cadres in Universities and Colleges November 9, 2017
- 7th CPC Pay Matrix for Teachers and Equivalent Cadres in Universities and Colleges November 9, 2017
- 7th CPC Pay for Teachers and Equivalent Academic Staff in Universities/Colleges – Cabinet Approval October 12, 2017
- Pay Revision of Academic Staff of Universities and Colleges March 24, 2017
- Revision of UGC Pay Scale from 1.1.2020 in West Bengal 7th CPC: Scheme of Revision of Pay of Teachers and Equivalent Cadres in Universities and Colleges 7th CPC Pay Matrix for Teachers and Equivalent Cadres in Universities and Colleges 7th CPC Pay for Teachers and Equivalent Academic Staff in Universities/Colleges – Cabinet Approval 7th CPC Revised Pay for Teachers in Universities and Colleges Pay Revision of Academic Staff of Universities and Colleges Revised rates of Honorarium of Guest Faculty in Universities and Colleges 7th CPC Arrears: 30% of Arrears for Non-Teaching Staff of Central Universities 7th CPC to Teachers and Academic Staff of Technical Institutes
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.
7th Pay Commission Arrear Calculator In Excel Uttar Pradesh
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.
Note: To edit and customize the Google Sheet, save the file on your Google Drive by using the 'Make a Copy' option from the File menu.
How To Use Salary Arrears Calculator Template?
This template consists of 3 sections: Total Gross Salary, Total Deductions, and the Differential Arrears.
The first 2 columns are for Month and Year. To select the month use the drop-down list. All 12 months starting from January to December.
7th Pay Arrear Calculator In Excel Formula
Similarly, to select the year, use the drop-down list.
Years Starting from 1990 to 2025. You can calculate the arrears for about 35 years using this template.
Top panes have been frozen using the Freeze Panes Function. Select the cell from where you want to freeze.
Go to Ribbon -> View -> Click on 'Freeze Panes'
Total Gross Salary Calculation
Gross Salary is the total amount of salary without any kind of deductions. Components of gross salary differ from country to country as well as company to company. It consists of heads according to Indian salary markups:
Basic Salary
Dearness Allowance (DA)
House Rent Allowance (HRA)
Conveyance Allowance
Medical Allowance
Special Allowance
Bonus Pay
Travel Allowance
7th Pay Commission Arrear Calculator In Excel Maharashtra
There are 2 columns for each head. One is for inserting the actual amount and the second for the revised amount. In the end, there are 2 columns; Total Gross Salary and Revised Total Gross Salary.
Total Deductions Calculations
AICTE Pay Matrix Table for Teachers and Academic Staff
| Notification issued by MHRD on 2nd Nov 2017 |
| 7th CPC Pay Matrix for Teachers and Equivalent Cadres in Universities and Colleges |
| 7th CPC Arrears: 30% of Arrears for Non-Teaching Staff of Central Universities |
| Revision of pay of Teachers, Officers and Non-Teaching Staff |
| 7th CPC Pay Matrix for IITs, IISe, IIM, NITIE, IISER, NIT, IIIT |
How is the assistant professor's salary calculated?
As per UGC pay revision order, the Assistant Professor basic salary is Rs. 57700 after 7th pay commission. In 6th CPC, Assistant Professor grade was in Rs. 6000 AGP, now their pay level is 10.
Important Notification by MHRD issued on 2.11.2017
UGC Pay Scale Latest News 2020
- Concordance Pension Table for Retired Teaching and Non-Teaching Staff of University and college July 14, 2020
- AICTE (All India Council for Technical Education) Clarification on 7th CPC Pay Matrix for Teachers of Technical June 6, 2020
- 7th CPC Revised UGC pay scales to the Teachers, Civilian Academic Officer of NDA, Khadakwasla and ACC Wing, IMA April 17, 2020
- Precautions to be taken in light of Novel Coronavirus (COVID-19) – MoHFW Order March 20, 2020
- Revision of UGC Pay Scale from 1.1.2020 in West Bengal November 5, 2019
- Revised rates of Honorarium of Guest Faculty in Universities and Colleges October 9, 2019
- UGC Pay Scal as per 7th Pay Commission February 22, 2019
- Revision of Allowances as per 7th CPC to University and College Teachers January 29, 2019
- 7th CPC to Teachers and Academic Staff of Technical Institutes January 18, 2019
- 7th CPC Arrears: 30% of Arrears for Non-Teaching Staff of Central Universities July 7, 2018
- Implementation of Reservation Policy – UGC March 13, 2018
- 7th CPC Pay Calculator for Teachers in Universities and Colleges November 16, 2017
- TA and Sitting Fee Payable to Official and Non-Official Members/Experts – UGC November 10, 2017
- 7th CPC: Scheme of Revision of Pay of Teachers and Equivalent Cadres in Universities and Colleges November 9, 2017
- 7th CPC Pay Matrix for Teachers and Equivalent Cadres in Universities and Colleges November 9, 2017
- 7th CPC Pay for Teachers and Equivalent Academic Staff in Universities/Colleges – Cabinet Approval October 12, 2017
- Pay Revision of Academic Staff of Universities and Colleges March 24, 2017
- Revision of UGC Pay Scale from 1.1.2020 in West Bengal 7th CPC: Scheme of Revision of Pay of Teachers and Equivalent Cadres in Universities and Colleges 7th CPC Pay Matrix for Teachers and Equivalent Cadres in Universities and Colleges 7th CPC Pay for Teachers and Equivalent Academic Staff in Universities/Colleges – Cabinet Approval 7th CPC Revised Pay for Teachers in Universities and Colleges Pay Revision of Academic Staff of Universities and Colleges Revised rates of Honorarium of Guest Faculty in Universities and Colleges 7th CPC Arrears: 30% of Arrears for Non-Teaching Staff of Central Universities 7th CPC to Teachers and Academic Staff of Technical Institutes
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.
7th Pay Commission Arrear Calculator In Excel Uttar Pradesh
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.
Note: To edit and customize the Google Sheet, save the file on your Google Drive by using the 'Make a Copy' option from the File menu.
How To Use Salary Arrears Calculator Template?
This template consists of 3 sections: Total Gross Salary, Total Deductions, and the Differential Arrears.
The first 2 columns are for Month and Year. To select the month use the drop-down list. All 12 months starting from January to December.
7th Pay Arrear Calculator In Excel Formula
Similarly, to select the year, use the drop-down list.
Years Starting from 1990 to 2025. You can calculate the arrears for about 35 years using this template.
Top panes have been frozen using the Freeze Panes Function. Select the cell from where you want to freeze.
Go to Ribbon -> View -> Click on 'Freeze Panes'
Total Gross Salary Calculation
Gross Salary is the total amount of salary without any kind of deductions. Components of gross salary differ from country to country as well as company to company. It consists of heads according to Indian salary markups:
Basic Salary
Dearness Allowance (DA)
House Rent Allowance (HRA)
Conveyance Allowance
Medical Allowance
Special Allowance
Bonus Pay
Travel Allowance
7th Pay Commission Arrear Calculator In Excel Maharashtra
There are 2 columns for each head. One is for inserting the actual amount and the second for the revised amount. In the end, there are 2 columns; Total Gross Salary and Revised Total Gross Salary.
Total Deductions Calculations
Deductions include a contribution to PF, Professional Tax, TDS (Tax Deductions at Source), and Salary Advances (if any).
Similar to the gross salary section, this section also has 2 columns for each head. Insert the current amount in the first column and the revised amount in the second.
Differential Salary Arrears Calculations
The Net payable salary and revised Net salary are calculated using the below-given formula:
Net Salary/Revised Net Salary = Total Gross Salary – Total Deductions
Thus, the Net salary is the amount payable to the employee/you. Whereas, the Revised Salary is the incremental amount that the company has to pay.
Therefore, the difference between these amounts is the salary arrear to be paid by the employer/company to the employee/you.
We thank our readers for liking, sharing, and following us on various social media platforms.
If you have any queries or suggestions, please share in the comment section below. We will be more than happy to assist you.
Frequently Asked Questions
Is PF applicable to salary arrears?
Yes, PF is applicable to salary arrears. But, no interest or penalty will be applicable if the employer or employee pays the PF for the arrears within 15 days of its payment.
Is TDS applicable to Salary Arrears?
Yes, TDS is applicable to salary arrears. The employer has to deduct tax as per the applicable income slab rate while paying the salary arrears. Moreover, the employer is responsible for depositing the TDS collected into the government treasury within the due dates.
How to save tax on Salary Arrears?
Under Section 89(1) of the Income Tax Act, any citizen to claim the tax benefit for salary received in arrear, gratuity received for past services extending a period of not less than 5 years but less than 15 years, compensation on termination of employment, and payment of commutation of pension. You need to fill Form 10E to avail of the benefit.
