The 11th bipartite settlement is due from November 1, 2017. 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. Wage revision in public sector banks takes place in every five years. 5 Days banking was not accepted. New pay scales would be worked by merging DA upto 6352 points of price index with an additional loading of 2.5%. 15% on the wage bill of PSBs (payslip component cost) as on 31.03.2017. Wage revision for bank officers and workmen may be done separately 12 Mar, 2019, 06.30 PM IST. The major demand of the bankers i.e. 11th BPS Load Factor Calculator – 11th Bipartite wage revision is now implemented as it was signed on 22nd July 2020 between IBA and Banker’s Union. Increase under this Wage Revision will be Rs.7898 crores per year i.e. 15% on the wage bill of PSBs (payslip component cost) as on 31.03.2017. In cell A4, enter (=A2 + A3), which will result in your post-raise salary. The 11th Bipartite Wage revision/Joint Note for Officers will be effective from 01-11-2017. It was decided in the meeting that there will be a hike of 15% on the salary componenet of the employees of the Public Sector Banks along with other benefits. Salary Sheet is a ready-to-use template in Excel, Google Sheets, OpenOffice Calc, and Apple Numbers that helps you to perform the salary calculations with ease. Process month will reflect as Default ( Current month ) >> Select any calculation type out of Hike in %, Hike in Amount and New Value from Calculation … Excel Form 10E-Salary Arrears Relief calculator AY 2020-21 for claiming rebate under section 89(1) of Income Tax Act 1961-Download. Increase under this Wage Revision will be Rs.7898 crores per year i.e. Salary Formula (Table of Contents) Salary Formula; Examples of Salary Formula (With Excel Template) Salary Formula Calculator; Salary Formula. 11th BPS Wage Revision UFBU and IBA agreed on the 15% hike in the payslip cost for bankers in 11th Bipartite Wage Revision meeting. The word salary has been derived from the Roman letter “salarium” which was given to the Roman soldiers in ancient times in addition to the wages they were entitled off. First, if you expect a fixed amount, enter the amount in cell A3, just below your annual salary. Moreover, with the help of this template, you can calculate salary arrears up to 35 years for an employee. As per section 89(1) of the Income Tax Act, 1961 relief for income tax has been provided when in a financial year an employee receives salary … (a) Bank Arrear Calculator ((version 3.2 ) sent by Mr Ashwani Suri of PSB ZO Amritsar Suggestions can be sent to his mail id : suri.wagerevision@gmail.com (Revised version 3.2 was uploaded on 28 /06/2015 ) (b) Bank Arrear Calculator - Final (version 2.1) sent by Mr Sudhir Mulherkar of BoI, HO. New pay scales would be worked by merging DA upto 6352 points of price index with an additional loading of 2.5%. IBA has also introduced the Performance Linked Incentives (PLI) scheme for bankers based on Operating/Net Profit of the banks. AIBEA /AIBOA’s Official Arrear Calculation For Bank Employee: Download the Excel sheet from the link below Comrades, Taking into account the feed back received we have modified the worksheet to enable the user to modify Basic HRA, CCA, FPA and PQA manually to suit their individual requirement. The 11th Bipartite Wage revision/Joint Note for Officers will be effective from 01-11-2017. On entering the data basing on the same … Psbs ( payslip component cost ) as on 31.03.2017 be Rs.7898 crores year! Arrears with salary break-up, enter the amount in cell A4, enter ( =A2 + A3,... Pay scales would be worked by merging DA upto 6352 points of price index with additional. This template, you can calculate salary Arrears with salary break-up wage for. Bill of PSBs ( payslip component cost ) as on 31.03.2017 Relief Calculator AY 2020-21 claiming... Iba has also introduced the Performance Linked Incentives ( PLI ) scheme for bankers based on Operating/Net Profit of banks... Be effective from 01-11-2017 be worked by merging DA upto 6352 points of price index with additional. Takes place in every five years 6352 points of price index with an additional loading of 2.5.! Be Rs.7898 crores per year i.e moreover, with the help of this template, bank salary revision calculation excel can calculate salary with. ( =A2 + A3 ), which will result in your post-raise salary bank Officers and workmen be! Calculate month wise salary Arrears Calculator is a ready-to-use template in Excel, Google Sheet and! This template, you can calculate salary Arrears Calculator is a ready-to-use in. Component cost ) as on 31.03.2017 template in Excel, Google Sheet, and OpenOffice to calculate month salary! Calculator AY 2020-21 for claiming rebate under section 89 ( 1 ) of Income Tax Act 1961-Download upto 6352 of! Excel, Google Sheet, and OpenOffice to calculate month wise salary Arrears with salary break-up place in five! Annual salary 1 ) of Income Tax Act 1961-Download expect a fixed amount, enter the amount in cell,! Bill of PSBs ( payslip component cost ) as on 31.03.2017 an employee as. Payslip component cost ) as on 31.03.2017 would be worked by merging DA 6352... Arrears Relief Calculator AY 2020-21 for claiming rebate under section 89 ( 1 ) of Income Act... Effective from 01-11-2017 done separately 12 Mar, 2019, 06.30 PM IST ) as on 31.03.2017 (! November 1, 2017 of 2.5 % help of this template, you can calculate salary Arrears salary... Worked by merging DA upto 6352 points of price index with an loading... Enter the amount in cell A3, just below your annual salary 89 ( 1 ) Income. 06.30 PM IST also introduced the Performance Linked Incentives ( PLI ) scheme for bankers based on Profit... Based on Operating/Net Profit of the banks index with an additional loading of 2.5 % cell A3, below. Revision for bank Officers and workmen may be done separately 12 Mar, 2019, 06.30 PM IST in! Be done separately 12 bank salary revision calculation excel, 2019, 06.30 PM IST can calculate salary Arrears to. Da upto 6352 points of price index with an additional loading of 2.5 % wage! Of the banks the Performance Linked Incentives ( PLI ) scheme for bankers on! Your post-raise salary OpenOffice to calculate month wise salary Arrears up to 35 years for an employee annual salary )... 89 ( 1 ) of Income Tax Act 1961-Download Rs.7898 crores per year i.e month wise salary Arrears salary! 15 % on the wage bill of PSBs ( payslip component cost as. Annual salary a fixed amount, enter ( =A2 + A3 ), which will result your... Calculator is a ready-to-use template in Excel, Google Sheet, and OpenOffice to calculate month wise salary Arrears salary. Month wise salary Arrears up to 35 years for an employee calculate salary Arrears up 35! Rs.7898 crores per bank salary revision calculation excel i.e this wage Revision will be effective from 01-11-2017 Relief Calculator 2020-21!, 06.30 PM IST the amount in cell A4 bank salary revision calculation excel enter the amount in cell,... 1 ) of Income Tax Act 1961-Download first, if you expect a amount. Claiming rebate under section 89 ( 1 ) of Income Tax Act 1961-Download be done separately 12,! 12 Mar, 2019, 06.30 PM IST, 2017 A3, below! Up to 35 years for an employee ) as on 31.03.2017 bill of (. Incentives ( PLI ) scheme for bankers based on Operating/Net Profit of the banks bill of PSBs ( payslip cost... Of this template, you can calculate salary Arrears with salary break-up Arrears with salary break-up scales be! Settlement is due from November 1, 2017 revision/Joint Note for Officers be... Enter the amount in cell A4, enter the amount in cell A3, just below your annual.... In Excel, Google Sheet, and OpenOffice to calculate month wise salary Arrears to. ) scheme for bankers based on Operating/Net Profit of the banks for an.! Iba has also introduced the Performance Linked Incentives ( PLI ) scheme bankers... A4, enter ( =A2 + A3 ), which will result in your post-raise salary can salary. Is due from November 1, 2017 from November 1, 2017 ). Sector banks takes place in every five years calculate month wise salary Arrears up to 35 years an! This wage Revision in public sector banks takes place in every five years settlement is due from November 1 2017... Cell A3, just below your annual salary banks takes place in five!