9th BIPARTITE AGREEMENT
ARREARS CALCULATOR
This Arrears Calculator is the property of the undersigned.
THIS UTILITY IS AVAILABLE FREE
Purpose:
This utility has been designed to benefit Officers of Union Bank Family.
Pre-requisites:
It is required that security level is set at medium for proper running of the macros. This may be
checked from Tools - Macro - Security Options. If while opening the ITRR, systems asks
IMPORTANT INSTRUCTIONS FOR USING THE ARREARS CALCULATOR UTILITY
1. Please do not make any change in the format of the file. There are some hidden rows,
columns and sheets which should not be unhidden.
2.Do not use paste data from other sources in the file in such a fashion which may result in
loss of validations / formulae provided for cells.
4. If the drop down list has been provided for any row, then the value should be picked from the given
list only
5. The Utility consists of 8 worksheets other than the guidelines sheet
6. To start with, the user create a folder in C:/ or D:/
7. Under the said folder, copies of the "IX Bipartite Arrears Calculator - Officers - Ver 1.01 may be
pasted and renamed as Mr. X, Mr.Y to contain the details of individual employees.
8. For each Individual File, the Info sheet should be first filled in, starting with the name of theemployee. The Info sheet is like a questionairre eliciting all relevant information. All the rows must be answered. Offline help is provided by way of messages while traversing the cells. List boxoption should be exercised wherever needed. If the answer is "Yes", select "Yes" from theList or"No". No row should be left unanswered.
This utility is for computation of arrears for Officers on account of 9th Bipartite Agreement dt
27.4.2010
This utility enables generation of Yearwise arrears for relief u/s 89 of IT Act, Income Tax Planner for 2010-2011 apart from generation of Summary Sheet.
The utility is comprehensive to cover computation of arrears on account of Salary Revision, Medical Aid, Leave encashment, Hill/Fuel allowance revision, Officiating Pay revision, etc.
This Arrears Calculator utility can be run on any computer installed with Microsoft Office - Excel 97 or versions above.
whether to disable or enable the macro, please click on Enable Macro option.
3.Date should always be entered in dd-mm-yyyy format.
Suggested Folder name: 9th Bipartite Agreement. The IX Bipartite Arrears Calculator - Officers -
Ver 1.01 should be stored in the said folder.
The path would then be: C:/9th Bipartite Agreement/IX Bipartite Arrears Calculator - Officers - Ver 1.01
9. To arrive at the IT rate and also to plan IT for the rest of the Year, the Income Tax Estimate sheet should be filled in. The Cells or Boxes which are coloured blue alone should be filled in with appropriate details.
DISCLAIMER:
contact the undersigned at his WAN Mail Box: [email protected]
or "[email protected] " or "[email protected]"
ACKNOWLEDGEMENT
I look forward for your Comments/Suggestions towards improving this utility.
Mobile:+9109444917116e-mail: [email protected]: [email protected]: [email protected]
CLICKDOWN FOR 9th BIPARTITE AGREEMENT-
O.D.KAMALAKANNAN
MANAGER,
FGMO, CHENNAI.
12. Upon completing the "Info" & "Income Tax Estimate" worksheet, other worksheets such "Old
Scale", "New Scale", "Summary", "Year wise Summary"," PF Statement", "PL Encashment",
Income Tax Planner etc would be generated.
It may be noted this Arrears Calculator has been prepared with a view to help UBI staff in
computation of Arrears on account of 9th Bipartite Agreement and also to make the computation
transparent and accurate.
While all necessary precautions have been taken, the author does not assume any responsibility in
respect of performance or output of the Arrears Calculator in any manner.
While using the Arrears Calculator, if you come across any difficulty or you require any clarification or
if you would like to make suggestions, you may
I gratefully acknowledge with thanks the support & motivation given by several Unionites for Income Tax Ready reckoner iwhich prompted me to bring out this calculator and also the compliments received from innumerable users of UBI and other Banks for the calculator developed during 8th Bipartite settlement.
I gratefully acknowledge with thanks the support of all my colleagues for their valuable suggestion in
bringing out the calculator.
9th Bipartite wage settlement.pdf.txtH:\9th Bipartite
Settlement\CO Arrears Circular.pdf
Name of the Officer : Supratim Mitra
Sex Male Select "Male" or "Female" from the drop down box
Provident Fund Number : 502504 Enter your Provident Fund Number / Employee Number
Branch : Camac Street
Region : KOLKATA Enter the Region
Designation Scale : 2 Enter your Present Grade/Scale from the drop down box
Date of Promotion to present Scale : 03.07.09
Whether existing Pension / P.F Optee? : Pension Optee
If P.F.Optee, whether willing to convert as Pension Optee? :Date of Joining : 03.07.09 Enter the Date of Joining the Bank [dd/mm/yy]
Month of increment : Jul Enter the Month of Increment from the drop down box
JAIIB or CAIIB - Part I : Yes Select "Yes" if passed CAIIB(Part I)/JAIIB. Else "No".
CAIIB - or CAIIB-Part II : No Select "Yes" if passed CAIIB(Part II). Else "No".
Encashment of Privilege Leave I :
Encashment of Privilege Leave II :
Are you in receipt of FPP? (State "Yes" or "No") : No
:
Voluntary PF contribution? : No
: No
Rate
Is HRR based on Standard Rent : No
If HRA claimed by Rent Receipt, state the rent paid. :From To
From To
From To
: No
: metres
Month
### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###Jan-08 0 0.00 0.00 0.00 No 1 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###Apr-08 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###Jun-08 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###Jul-08 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 2 No No 1 1 No Area-I ###Oct-08 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###Jan-09 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###Apr-09 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###Jun-09 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###Jul-09 ### 0.00 0.00 0.00 No 2 No No 1 1 No Area-I ###### ### 0.00 0.00 0.00 No 2 No No 1 1 No Area-I ###### ### 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###Oct-09 ### 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### ### 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### ### 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###Jan-10 ### 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### ### 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###### ### 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###Apr-10 ### 0.00 0.00 0.00 No 22 No No 1 1 No Area-I ###### 0 0.00 0.00 0.00 No 0 No No 1 1 No Area-I ###
Month
Enter Branch/Office where working/last worked
Enter the date of promotion to the present Grade/Scale. Date format "dd/mm/yy"
Select "Pension Optee or P.F Optee from the drop down box
Month --->
Days --->
1 - Enter Encashment Month and No. of days in appropriate boxes
Month --->
Days --->
2 - Enter Encashment Month and No. of days in appropriate boxes
Select "Yes" if you are already in receipt of FPP, Else select "No" from the drop down box.
If FPP is received, prior to Nov 07, simply state Nov 07 [ cell: A20]. If FPP is received subsequently, state the month of receipt of FPP [Valid Months: Nov 07- Apr 10]. In the Total FPP received, Enter the FPP received (as seen in the Salary slip]. Please select the FPP from the drop down list. [#] along with the amount indicates the scale at which FPP released.
Month of receipt of
FPP
TOTAL FPA
If Yes, Please fill in the existing VPF contribution's monthwise herebelow in the column provided.
Would you like VPF to continue on revised Pay Scale also?
If Yes, kindly state the rate of VPF contribution or Quantumize VPF.
State the rate of VPF contribution or specify the amount of VPF per month
Fixed VPF per month
For quarters/Leased accomodation, Select "Yes" if HRR is based on Standard rent.
Else select, "No".
Grade/Scale
Are you in receipt of Hill & Fuel allowance during the period Nov 07 - April 10? Select "Yes" if you are in receipt of HILL & FUEL allowance. Else Select No.
If "Yes", to the above, please state the altitude of the place where posted.
Enter the altitude of the place, if you are in receipt of Hill & Fuel Allowance. Else leave it blank.
* - COMPULSORILY TO BE ENTERED/FILLED IN.[Last field VPF contribution]
Old Basic Pay*
PQP* [Old
]
FPP* [Old]
Off Pay (New)
Off.Pay (Old)
Off. Pay received
during the
month?*
Loss of Pay (Days
)*
Quarters / Leased
accomodatio
n provided?*
Furniture Provided?
*
HRA Category
*
HRA - Area
status*
Hill & Fuel Allow.
Received?
*
Existing House Rent
Recovery*
CCA
Status*
VPF Contributi
on made*
Grade for Medical Aid
Old Basic Pay*
PQP* [Old]
FPP* [Old]
Off Pay (New)
Off.Pay (Old)
Off. Pay received
during the month?*
Loss of Pay
(Days)*
Quarters / Leased
accomodation provided?*
Furniture Provided?
*
HRA Category
*
HRA - Area
status*
Hill & Fuel Allow.
Received?*
Existing House Rent
Recovery*
CCA Status*
VPF Contribution
made*
INCOME TAX ESTIMATION FOR THE FINANCIAL YEAR 2010-2011
Name: Supratim Mitra P.A.N P.F.No 502504 Financial Year 2010-2011Branch Camac Street Assessment Year 2011-2012Furniture Value at Quarters Rs. - Sex Male
Total Salary Income [Estimate] (a+b+c) Rs. 120,952.16 a) Apr-10 Rs. 7,508.47 b) May -10 - Mar-11 Rs. 82,593.13
c) Rs. 30,850.56
PERQUISITES
Residential Accomodation status No Rs. - Gross Salary Rs. 90,101.60 Dearness Allowance Rs. 23,637.60 10% of [Gross-DA] Rs. 6,646.40 Add:Furniture Value Rs. - Less:House rent Recovery Rs. - Less: Furniture rent recovery Rs. - EXEMPTIONS U/S SEC 10 Rs. -
1 HRA U/s 10(13A) Rs. - a) RENT PAID Less:10% of BP+DA
b) HRA Paid c) 50% of Salary
Least of a,b,c Rs. - 2 Conveyance Allowance Rs. -
3
Rs. - DEDUCTIONS U/S 16Professional Tax Rs. -
DEDUCTION U/S 24Interest on Housing Loan Rs. - Loan prior to 1.4.99: Max:Rs.30,000Loan after 1.4.99: Max:Rs.1,50,000
GROSS TOTAL INCOME Rs. 120,952.16
DEDUCTIONS U/S CHAPTER VI-A Rs. 11,442.00
DEDUCTIONS U/S SEC 80CCE Rs. 11,442.00 DEDUCTIONS U/S SEC 80-C Rs. 11,442.00 a) Education Expenses(Tuition fees of Wards) Rs. - b) LIC premium (SSS+ Dir payment) Rs. - c)CPF on arrears Rs. 5,010.00 d) PF on Salary + Voluntary PF Rs. 6,432.00 e) PPF - f) Interest on NSC Rs. - g) NSC VIII Issue Rs. - h) ULIP/Dhanraksha Rs. - i) Jeevan Dhara/Jeevan Akshay Rs. - j) Annuity of Insurance Company Rs. - k) MEP Rs. - l) Pension fund of Mutual Funds Rs. - m) Home Loan Account - NHB Rs. - n) Housing Loan Repayments Rs. - o) Infrastructure Bonds Rs. -
Rs. - q) Notified Term deposits with a Sch.Bank Rs. - r) 5 year deposits under Post office rules Rs. -
Arrears for 07/08;08/08;09/10
Mid Academic Transfer/Tribal Area/Composite Hill/Border
Area/Underground/Counter insurgency/Compensatory field
area/compensatory modified field area allowances, etc.
p) Units of MF investing in Infrastructure bonds
Deduction u/s 80 CCC Rs. -
Deduction U/s 80 D
Mediclaim (Self)
35
Deduction U/s 80 DDB Rs. -
Deduction U/s 80E Rs. -
Deduction U/s 80U Rs. -
TOTAL TAXABLE INCOME Rs. 109,510.16
TOTAL TAXABLE INCOME AFTER DEDUCTIONS
Income Tax Rs. - ADD: Education Cess Rs. - Total IncomeTax Payable Rs. -
INCOME TAX PLANNER
Apr-10 May-10 Jun-10 Jul-10 Aug-10 Sep-10 Oct-10 Nov-10
0.00 0.00 0.00 0.00 0.00 0.00
Dec-10 Jan-11 Feb-11 Mar-11 Total
0.00 0.00 0.00 0.00 0.00
LIC Pension - Jeevan Suraksha
Mediclaim (Parent> 60
yrs)
Exp. Incurred for handicapped dependent relative
Repayment of interest on loan for Education
Deduction in respect of total blind/mentally retarded/physically handicapped persons
Please enter the Income Tax remitted during the months of April 10, May 10 and June 10 alone below the "Month" caption [Blue coloured cells]
Tax on arrears
Page 7 of 17
UNION BANK OF INDIA
ARREARS SHEET - REVISION OF PAY SCALE OF OFFICER STAFF
Name Supratim Mitra Emp. No 502504 Month of Increment Jul Region KOLKATA
Designation MMG/S-II D.O.Joining 03.07.09 Branch / Office Camac Street Basic as on 31.10.07
EMOLUMENTS DRAWN AS PER THE OLD SCALES OF PAY
Month Days Basic P.Q.P F.P.A D.A H.R.A C.C.A Hill/Fuel Off. All Gross C.P.F V.P.F H.R.R F.R.R Net
1 2 3 4 5 6 7 8 6 7 8 9 10 11
Nov-07 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Dec-07 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jan-08 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Feb-08 29 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Mar-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-(07-08) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Apr-08 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
May-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jun-08 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jul-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Aug-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sep-08 28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Oct-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Nov-08 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Dec-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jan-09 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Feb-09 28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Mar-09 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-(08-09) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Apr-09 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
May-09 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jun-09 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jul-09 29 12928.39 0.00 0.00 6329.74 1098.91 517.14 0.00 0.00 20874.17 1292.84 0.00 0.00 0.00 19581.34
Aug-09 29 12928.39 0.00 0.00 6771.89 1098.91 517.14 0.00 0.00 21316.32 1292.84 0.00 0.00 0.00 20023.49
Page 8 of 17
UNION BANK OF INDIA
ARREARS SHEET - REVISION OF PAY SCALE OF OFFICER STAFF
Name Supratim Mitra Emp. No 502504 Month of Increment Jul Region KOLKATA
Designation MMG/S-II D.O.Joining 03.07.09 Branch / Office Camac Street Basic as on 31.10.07
Sep-09 30 13820.00 0.00 0.00 7238.92 1174.70 540.00 0.00 0.00 22773.62 1382.00 0.00 0.00 0.00 21391.62
Oct-09 31 13820.00 0.00 0.00 7238.92 1174.70 540.00 0.00 0.00 22773.62 1382.00 0.00 0.00 0.00 21391.62
Nov-09 30 13820.00 0.00 0.00 8706.60 1174.70 540.00 0.00 0.00 24241.30 1382.00 0.00 0.00 0.00 22859.30
Dec-09 31 13820.00 0.00 0.00 8706.60 1174.70 540.00 0.00 0.00 24241.30 1382.00 0.00 0.00 0.00 22859.30
Jan-10 31 14320.00 0.00 0.00 9021.60 1217.20 540.00 0.00 0.00 25098.80 1432.00 0.00 0.00 0.00 23666.80
Feb-10 28 14320.00 0.00 0.00 9846.43 1217.20 540.00 0.00 0.00 25923.63 1432.00 0.00 0.00 0.00 24491.63
Mar-10 31 14320.00 0.00 0.00 9846.43 1217.20 540.00 0.00 0.00 25923.63 1432.00 0.00 0.00 0.00 24491.63
Sub-(09-10) 124096.77 0.00 0.00 73707.12 10548.23 4814.27 0.00 0.00 0.00 213166.39 12409.68 0.00 0.00 0.00 200756.72
Apr-10 8 3818.67 0.00 0.00 2625.72 324.59 152.75 0.00 0.00 6921.72 381.87 0.00 0.00 0.00 6539.85
May-10 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jun-10 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-(10-11) 3818.67 0.00 0.00 2625.72 324.59 152.75 0.00 0.00 0.00 6921.72 381.87 0.00 0.00 0.00 6539.85
Grand Total ### 0.00 0.00 76332.84 ### 4967.02 0.00 0.00 0.00 220088.11 ### 0.00 0.00 0.00 207296.57
UNION BANK OF INDIA
ARREARS SHEET - REVISION OF PAY SCALE OF OFFICER STAFF
Name Supratim Mitra Emp. No 502504 Month of Increment Jul Region KOLKATA
Designation MMG/S-II Join Dt 03.07.09 Branch / Office Camac Street Revised BP as on 31.10.07 Rs0.00
EMOLUMENTS DRAWN AS PER THE NEW SCALES OF PAY
Month Days Basic P.Q.P F.P.A D.A H.R.A C.C.A Hill/Fuel Off Gross C.P.F V.P.F H.R.R F.R.R Net Gross Inc
1 2 3 4 5 6 7 8 6 7 8 9 10 11 28
Nov-07 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Dec-07 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jan-08 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Feb-08 29 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Mar-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-(07-08) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 ### 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Apr-08 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
May-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jun-08 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jul-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Aug-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sep-08 28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Oct-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Nov-08 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Dec-08 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jan-09 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Feb-09 28 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Mar-09 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Sub-(08-09) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Apr-09 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
May-09 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jun-09 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jul-09 29 18148.39 0.00 0.00 3675.05 1443.09 505.16 0.00 0.00 23771.69 1814.84 0.00 0.00 0.00 21956.85 2897.51
Aug-09 29 18148.39 0.00 0.00 4192.28 1443.09 505.16 0.00 0.00 24288.92 1814.84 0.00 0.00 0.00 22474.08 2972.59
UNION BANK OF INDIA
ARREARS SHEET - REVISION OF PAY SCALE OF OFFICER STAFF
Name Supratim Mitra Emp. No 502504 Month of Increment Jul Region KOLKATA
Designation MMG/S-II Join Dt 03.07.09 Branch / Office Camac Street Revised BP as on 31.10.07 Rs0.00
EMOLUMENTS DRAWN AS PER THE NEW SCALES OF PAY
Month Days Basic P.Q.P F.P.A D.A H.R.A C.C.A Hill/Fuel Off Gross C.P.F V.P.F H.R.R F.R.R Net Gross Inc
1 2 3 4 5 6 7 8 6 7 8 9 10 11 28
Sep-09 30 19400.00 0.00 0.00 4481.40 1649.00 540.00 0.00 0.00 26070.40 1940.00 0.00 0.00 0.00 24130.40 3296.78
Oct-09 31 19400.00 0.00 0.00 4481.40 1649.00 540.00 0.00 0.00 26070.40 1940.00 0.00 0.00 0.00 24130.40 3296.78
Nov-09 30 19400.00 0.00 0.00 6198.30 1649.00 540.00 0.00 0.00 27787.30 1940.00 0.00 0.00 0.00 25847.30 3546.00
Dec-09 31 19400.00 0.00 0.00 6198.30 1649.00 540.00 0.00 0.00 27787.30 1940.00 0.00 0.00 0.00 25847.30 3546.00
Jan-10 31 20100.00 0.00 0.00 6421.95 1708.50 540.00 0.00 0.00 28770.45 2010.00 0.00 0.00 0.00 26760.45 3671.65
Feb-10 28 20100.00 0.00 0.00 7386.75 1708.50 540.00 0.00 0.00 29735.25 2010.00 0.00 0.00 0.00 27725.25 3811.62
Mar-10 31 20100.00 0.00 0.00 7386.75 1708.50 540.00 0.00 0.00 29735.25 2010.00 0.00 0.00 0.00 27725.25 3811.62
Sub-(09-10) 174196.77 0.00 0.00 50422.18 14607.68 4790.32 0.00 0.00 0.00 244016.95 17419.68 0.00 0.00 0.00 226597.27 30850.56
Apr-10 8 5360.00 0.00 0.00 1969.80 121.49 57.17 0.00 0.00 7508.47 536.00 0.00 0.00 0.00 6972.47 586.75
May-10 31 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Jun-10 30 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
0
0
sub-(05-06) 5360.00 0.00 0.00 1969.80 121.49 57.17 0.00 0.00 0.00 7508.47 536.00 0.00 0.00 0.00 6972.47 586.75
Grand Total 179556.77 0.00 0.00 52391.98 14729.17 4847.50 0.00 0.00 0.00 251525.42 17955.68 0.00 0.00 0.00 233569.74 31437.31
UNION BANK OF INDIA
ARREARS SHEET - REVISION OF PAY SCALE OF OFFICER STAFF
KOLKATA
Rs0.00
EMOLUMENTS DRAWN AS PER THE NEW SCALES OF PAY
Net Inc
29
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
2375.51
2450.59
UNION BANK OF INDIA
ARREARS SHEET - REVISION OF PAY SCALE OF OFFICER STAFF
KOLKATA
Rs0.00
EMOLUMENTS DRAWN AS PER THE NEW SCALES OF PAY
Net Inc
29
2738.78
2738.78
2988.00
2988.00
3093.65
3233.62
3233.62
25840.56
432.62
0.00
0.00
432.62
26273.18
UNION BANK OF INDIA
ARREARS SUMMARY SHEET - REVISION OF PAY SCALE OF OFFICER STAFF
Name Supratim Mitra Designation MMG/S-II Increment Month Jul Basic Pay as on 31 Oct 2007 Rs -
Emp No 502504 Date of Joining 03.07.09 Branch/Office Camac Street Region KOLKATA
OFFICIATING PAY ARREARS PARTICULARS
No.of days From To From To Amount of Gross Arrears Rs 31,437.31
ADD:
Arrears of Medical Aid: 2006-07, 2007-08 and 2008-09 Rs 3,262.50
Rs -
LESS:
PF RECOVERABLE (25 - 12) Rs 5,164.13
VPF RECOVERABLE(26 - 13) Rs -
Income tax [ Rate % ] 0.00% Rs -
Rs -
MEDICAL AID Contribution towards Pension Fund Rs -
Arrears of Medical Aid NET ARREARS Rs 29,535.68
2006-07* 2007-08 2008-09 2006-07* 2007-08 2008-09 2006-07* 2007-08 2008-09
1562.5 3750 3750 2125.00 5100.00 5100.00 562.50 1350.00 1350.00 3262.50Prepared By:
Checked by
PARTICULARS OF LEAVE ON HALF PAY/WITHOUT PAY DURING NOVEMBER 07
TO JUNE 2010
Amount in Rupees
1/2 /Without Pay
Name of Permanent incumbent and his Basic
salary
Difference in PL Encashment : As per Details enclosed
Difference in House Rent Recovery/Furniture Rent recovery - recoverable
Amount Credited under 8th Bipartite
*Pro-rata for Nov 07 - Mar 08
Amount receivable under 9th Bipartite
TOTAL ARREARS
OF MEDICAL
AID
UNION BANK OF INDIAYEARWISE SUMMARY OF ARREARS PAID TO OFFICER STAFF UNDER IX BIPARTITE SETTLEMENT DATED ..............
Created by O.D.Kamalakannan
Year Scale of payBasic P.Q.A F.P.A D.A H.R.A C.C.A Hill/Fuel Off. Pay Gross C.P.F V.P.F H.R.R F.R.R Net
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Supratim Mitra
Revised 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Old Scale 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Difference 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Revised 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Old Scale 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Difference 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Revised 174196.77 0.00 0.00 50422.18 14607.68 4790.32 0.00 0.00 244016.95 17419.68 0.00 0.00 0.00 0.00 226597.27
Old Scale 124096.77 0.00 0.00 73707.12 10548.23 4814.27 0.00 0.00 213166.39 12409.68 0.00 0.00 0.00 0.00 200756.72
Difference 50100.00 0.00 0.00 ### 4059.45 -23.95 0.00 0.00 30850.56 5010.00 0.00 0.00 0.00 0.00 ###
Revised ### 0.00 0.00 50422.18 ### 4790.32 0.00 0.00 ### ### 0.00 0.00 0.00 0.00 226597.27
Old Scale ### 0.00 0.00 73707.12 ### 4814.27 0.00 0.00 ### ### 0.00 0.00 0.00 0.00 200756.72
Difference 50100.00 0.00 0.00 ### 4059.45 -23.95 0.00 0.00 30850.56 5010.00 0.00 0.00 0.00 0.00 ###
Revised 5360.00 0.00 0.00 1969.80 121.49 57.17 0.00 0.00 7508.47 536.00 0.00 0.00 0.00 0.00 6972.47
Old Scale 3818.67 0.00 0.00 2625.72 324.59 152.75 0.00 0.00 6921.72 381.87 0.00 0.00 0.00 0.00 6539.85
Difference 1541.33 0.00 0.00 -655.92 -203.09 -95.57 0.00 0.00 586.75 154.13 0.00 0.00 0.00 0.00 432.62
Revised ### 0.00 0.00 52391.98 ### 4847.50 0.00 0.00 ### ### 0.00 0.00 0.00 0.00 233569.74
Old Scale ### 0.00 0.00 76332.84 ### 4967.02 0.00 0.00 ### ### 0.00 0.00 0.00 0.00 207296.57
Difference 51641.33 0.00 0.00 ### 3856.36 -119.52 0.00 0.00 31437.31 5164.13 0.00 0.00 0.00 0.00 ###
2007-08
2008-09
2009-10
SUB TOTAL
2010-11
GRAND TOTAL
Name of the Staff Supratim Mitra
Designation
Branch/Office Camac Street
Provident Fund Number 502504
Whether Pension/PF Optee? Pension Optee
Month
Compulsory Provident Fund Voluntary Provident Fund
November-07 0.00 0.00 0.00 0.00 0.00 0.00 0.00December-07 0.00 0.00 0.00 0.00 0.00 0.00 0.00January-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00February-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00March-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00April-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00May-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00June-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00July-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00August-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00September-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00October-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00November-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00December-08 0.00 0.00 0.00 0.00 0.00 0.00 0.00January-09 0.00 0.00 0.00 0.00 0.00 0.00 0.00February-09 0.00 0.00 0.00 0.00 0.00 0.00 0.00March-09 0.00 0.00 0.00 0.00 0.00 0.00 0.00April-09 0.00 0.00 0.00 0.00 0.00 0.00 0.00May-09 0.00 0.00 0.00 0.00 0.00 0.00 0.00June-09 0.00 0.00 0.00 0.00 0.00 0.00 0.00July-09 1292.84 1814.84 522.00 0.00 0.00 0.00 0.00August-09 1292.84 1814.84 522.00 0.00 0.00 0.00 0.00September-09 1382.00 1940.00 558.00 0.00 0.00 0.00 0.00October-09 1382.00 1940.00 558.00 0.00 0.00 0.00 0.00November-09 1382.00 1940.00 558.00 0.00 0.00 0.00 0.00December-09 1382.00 1940.00 558.00 0.00 0.00 0.00 0.00January-10 1432.00 2010.00 578.00 0.00 0.00 0.00 0.00February-10 1432.00 2010.00 578.00 0.00 0.00 0.00 0.00March-10 1432.00 2010.00 578.00 0.00 0.00 0.00 0.00April-10 381.87 536.00 154.13 0.00 0.00 0.00 0.00May-10 0.00 0.00 0.00 0.00 0.00 0.00 0.00June-10 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total ### ### 5164.13 0.00 0.00 0.00 0.00
YEARWISE BREAK UP OF ARREARS OF PROVIDENT FUND
2007-2008 0.00 0.00 0.00 0.00 0.00 0.00 0.00
2008-2009 0.00 0.00 0.00 0.00 0.00 0.00 0.00
2009-2010 12409.68 17419.68 5010.00 0.00 0.00 0.00 0.00
Sub-Total ### ### 5010.00 0.00 0.00 0.00 0.00
2010-2011 381.87 536.00 154.13 0.00 0.00 0.00 0.00
Total ### ### 5164.13 0.00 0.00 0.00 0.00
STATEMENT OF PROVIDENT FUND CONTRIBUTION ON ACCOUNT OF IX BIPARTITE ARREARS PAID FOR THE PERIOD NOVEMBER 2007 TO JUNE 2010
PF on Old Scale
PF on Revised
Scale
Difference in PF
Employer's
Contribution on PF
VPF on Old
Scale
VPF on New Scale
Difference in VPF
Designed by O.D.Kamalakannan
Name of the Staff Supratim MitraENCASHMENT DETAILS
Designation MMG/S-II Month of encashment No of days PL encashed
I
Branch / Office Camac Street II
COMPUTATION OF ARREARS ON ACCOUNT OF ENCASHMENT OF PRIVILEGE LEAVE DONE.
Encashment I
Month Basic Pay D.A H.R.A P.Q.A F.P.A Gross
Revised Scale 0.00 0.00 0.00 0.00 0.00 0.00 0.00Old Scale 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Difference Payable 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Encashment II
Month Basic Pay D.A H.R.A P.Q.A F.P.A Gross
Revised Scale 0.00 0.00 0.00 0.00 0.00 0.00 0.00Old Scale 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Difference Payable 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
2007-08 2008-09 2009-10 2010-11Encashment I 0.00 0.00 0.00 0.00Encashment II 0.00 0.00 0.00 0.00Total 0.00 0.00 0.00 0.00
No of days
Notional HRA
No of days
Notional HRA
Designed by O.D.Kamalakannan
###
###
###
###
###
###
######
COMPUTATION OF ARREARS ON ACCOUNT OF ENCASHMENT OF PRIVILEGE LEAVE DONE.######
###
##################
###
########################