The 12th Bipartite Settlement marks a significant step in revising the pay structure and benefits of bank officers. With the new agreement, many officers are curious to know how their salaries will change and how much arrear payment they can expect. To make this process easier, we’ve developed an Excel calculator that allows you to calculate your revised salary and arrears based on the new terms of the agreement.
How to Calculate Your Revised Salary and Arrears
To simplify the process, we have created an Excel calculator that will help you compute your revised salary and arrears based on the 12th Bipartite Settlement. Here’s how you can use it:
Step-by-Step Instructions:
- Download the Excel Calculator: Click [here] to download the Excel calculator.
- Input Your Details: Once you’ve opened the Excel file, you’ll find various fields where you need to input your details. This includes:
- Your Basic pay Details
- Your Scale, CCA and HRA
- CAIIB Application Date
- Increment Date
- Promotion Date (if any)
- Calculate Revised Salary: The calculator will automatically compute your revised salary based on the inputs provided. It uses the new scales and allowances as per the 12th Bipartite Settlement to give you an accurate revised salary figure.
- Calculate Arrears: The arrears section of the calculator will calculate the total amount of arrears you are entitled to from the date the revised salary is applicable up to the current date. This is based on the difference between your old and new salary scales and allowances.
- Review the Results: The results section will display a summary of your revised salary and the total arrears owed to you. You can review these figures to ensure they match your expectations.
- Download and Save: After reviewing your calculations, you can save the file for your records.
Benefits of Using the Excel Calculator
– Accuracy: The calculator is designed to ensure accurate calculations based on the official guidelines of the 12th Bipartite Settlement.
– User-Friendly: With a simple and intuitive interface, the calculator makes it easy for anyone to use, regardless of their Excel expertise.
– Time-Saving: Avoid the hassle of manual calculations and let the Excel calculator do the work for you in seconds.
– Up-to-Date: The calculator is regularly updated to reflect any changes or clarifications issued by the authorities regarding the 12th Bipartite Settlement.
**Disclaimer**: This calculator is intended to provide an estimate of revised salaries and arrears based on the 12th Bipartite Settlement. For official calculations and detailed understanding, please refer to your bank’s HR department or the official settlement document.
Feel free to click [here] to download the Excel calculator and start your calculations now!
*If you have any questions or need further assistance, please leave a comment below or reach out to us directly. We’re here to help!*
