{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Page1&2 ","Form 12BB Page3&4","Page5","Annexure 1","DATA"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":7,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Page1&2 ","index":0,"n_rows":76,"n_cols":11,"rows_kept":76,"cut":false,"hidden":false,"merged":[[18,7,18,8],[25,2,25,6],[66,1,66,8],[59,1,59,3],[59,4,59,7],[59,8,59,10],[60,1,60,3],[60,4,60,7],[60,8,60,10],[61,1,61,10],[62,1,62,10],[63,1,63,8],[64,1,64,8],[65,1,65,8],[56,1,56,10],[57,1,57,3],[57,4,57,7],[74,1,76,5],[71,1,71,2],[75,8,75,10],[67,1,67,8],[68,1,68,8],[69,1,69,8],[70,1,70,8],[73,1,73,8],[71,7,71,8],[57,8,57,10],[58,1,58,3],[58,4,58,7],[58,8,58,10],[51,1,51,6],[52,1,52,8],[53,1,53,10],[54,1,54,10],[55,1,55,3],[55,4,55,7],[55,8,55,10],[30,2,30,6],[50,2,50,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[42,2,42,6],[44,1,44,6],[45,1,45,6],[46,2,46,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[41,2,41,6],[43,2,43,6],[13,1,13,6],[14,1,14,4],[19,1,19,6],[20,1,20,4],[23,1,23,6],[15,2,15,4],[16,2,16,4],[9,2,9,4],[12,1,12,6],[6,1,6,8],[11,2,11,4],[10,3,10,4],[7,1,7,6],[5,0,5,2],[1,3,1,9],[1,1,1,2],[2,3,2,8],[5,7,5,10],[5,3,5,5],[0,3,0,9],[3,6,3,10],[4,6,4,10],[3,0,3,2],[4,0,4,2],[4,3,4,5],[3,3,3,5],[28,2,28,6],[36,2,36,6],[37,2,37,6],[17,2,17,4],[18,2,18,4],[21,2,21,4],[22,2,22,4],[24,1,24,6],[26,2,26,6],[27,2,27,6],[31,2,31,6],[32,2,32,6],[33,2,33,6],[34,2,34,6],[29,2,29,6],[35,2,35,6]]}
["OLD REGIME",null,null,"INCOME  TAX  CALCULATION  STATEMENT",null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(Page5!$C$4,GK,2,FALSE),\"\")","v":""}]
[null,"ANTICIPATED IT",null,"FOR  THE  PERIOD  FROM  01.04.2023  TO  31.03.2024"]
[null,null,null,"  ASSESSMENT  YEAR  2024 - 2025"]
["Name          ",null,null,{"$f":"Page5!E4","v":""},null,null,"GOVERNMENT COLLEGE OF TECHNOLOGY"]
["Designation  ",null,null,{"$f":"Page5!M4","v":0},null,null,"COIMBATORE 641 013"]
["PAN No.         ",null,null,{"$f":"Page5!S4","v":0},null,null,"TAN No.","CMBO 03224 E"]
[1,"TOTAL ANNUAL GROSS SALARY INCOME: Including HRA, SLS, Additional Charge allowance, Arrears, Remunerations and any other income (Excluding cash allowance if any)",null,null,null,null,null,null,null,"Rs.",{"$f":"Page5!$I$28","v":0}]
[2,"LESS - HRA  (sec.10(13A) & Rule 2A) ( Fill Form-12BB, S.No. 1 & Anexure 1)",null,null,null,null,false,null,{"$f":"IF(G8=TRUE,1,0)","v":0}]
[null,"A. ","Actual Rent Paid ",null,null,"Rs.",{"$f":"'Annexure 1'!C24","v":0}]
[null,"B.","Less:10% of (Pay + DA) ",null,null,"Rs.",{"$f":"'Annexure 1'!F24","v":0}]
[null,"C. ","( A - B ) ",{"$f":"IF(I8=0,IF(G11<0,\"( Not elegible for HRA Savings )\",\"\"),\"\")","v":""},null,"Rs.",{"$f":"SUM($G$9-$G$10)","v":0}]
[null,"D.","Actual HRA received",null,null,"Rs.",{"$f":"'Annexure 1'!H24","v":0}]
[null," Least of the above (C or D) / If Occupied Govt. Qtrs Less \"D\"",null,null,null,null,null,"Rs.",{"$f":"IF($G$8>=TRUE,$G$12,IF($G$11>=0,MIN($G$11,$G$12),0))","v":0}]
[3,"GROSS SALARY INCOME  (1 - 2)",null,null,null,null,null,null,null,"Rs.",{"$f":"SUM($K$7-$I$13)","v":0}]
[4,"LESS:"]
[null,"A.","Standard Deduction under IT Rules u/s 16 (ia)",null,null,"Rs.",50000]
[null,"B.","Professional Tax  u/s 16 (iii)",null,null,"Rs.",{"$f":"Page5!U2","v":0}]
[null,"C.","Conveyance Allowance u/s 10(14)",null,null,"Rs."]
[null,"D.","Interest on Housing Loan u/s 24(b)(Max Rs. 2,00,000/- )",null,null,"Rs.",{"$f":"IF('Form 12BB Page3&4'!G13:H13<=200000,'Form 12BB Page3&4'!G13:H13,200000)","v":0}]
[5,"TAXABLE SALARY INCOME [ 3 - 4 ]",null,null,null,null,null,"Rs.",{"$f":"SUM(G16+G17+G18+G19)","v":50000},"Rs.",{"$f":"K14-I20","v":-50000}]
[6,"ADD: (OTHER SOURCE OF INCOME)"]
[null,"A.","Income from House property ",null,null,"Rs."]
[null,"B.","Any Other income ( Interest in savings bank, Interest on fixed deposit, Dividend, NSC Interest, Interest on PCA arrs, Agricultural Income,etc..",null,null,"Rs."]
[7,"GROSS  TOTAL  INCOME  [ 5 + 6 ]",null,null,null,null,null,"Rs.",{"$f":"SUM(G22+G23)","v":0},"Rs.",{"$f":"SUM(K20+I24)","v":-50000}]
[8," LESS: DEDUCTION UNDER CHAPTER VI A ( Fill Form-12BB, S.No. 4 )"]
[null,"(i) ","( A to  L )] Maximum amount of Deduction u/s 80C is Rs.1,50,000/-"]
[null,"A.","LIC, PLI, RPLI, PPF, SSY, UTI (ULIP) Premium  (  )",null,null,null,null,"Rs.",{"$f":"'Form 12BB Page3&4'!K35+'Form 12BB Page3&4'!K22","v":0}]
[null,"B.","NSC  VIII  Issue",null,null,null,null,"Rs.",{"$f":"'Form 12BB Page3&4'!K41","v":0}]
[null,"C.","Interest  accrued  on  NSC's",null,null,null,null,"Rs.",{"$f":"'Form 12BB Page3&4'!K47","v":0}]
[null,"D.","Equitity  Linked  Saving  Scheme (ELSS)",null,null,null,null,"Rs.",{"$f":"'Form 12BB Page3&4'!K53","v":0}]
[null,"E.","G.P.F.",null,null,null,null,"Rs.",{"$f":"Page5!J24","v":0}]
[null,"F.","S.P.F, F.B.F & HBA F.B.F",null,null,null,null,"Rs.",{"$f":"Page5!L24+Page5!M24+Page5!Q24","v":0}]
[null,"G.","C.T.D.",null,null,null,null,"Rs."]
[null,"H.","Repayment  of  Housing  Loan (for Principal Max Rs.1'50'000/-)",null,null,null,null,"Rs.",{"$f":"'Form 12BB Page3&4'!G14","v":0}]
[null,"I.","Tuition  Fees (Please  Refer  page  No.3  Note. No.2)",null,null,null,null,"Rs.",{"$f":"'Form 12BB Page3&4'!J58","v":0}]
[null,"J.","Subscription to Equity  shares / Debentures  or Units  of  Intrastructure  sector  (Like ICICI,  IDBI  Infrastructure  bonds)",null,null,null,null,"Rs."]
[null,"K.","Others (Please specify)",null,null,null,null,"Rs."]
[null,"L.","Others (Please specify)",null,null,null,null,"Rs."]
[null,"(ii)","U / S  80 CCC :  Annuity Pension Funds",null,null,null,null,"Rs."]
[null,"(iii)","U / S  80 CCD (1) :  Contribution  to  pension  scheme  of  central  Govt. (CPS)",null,null,null,null,"Rs."]
[null,"(iv)","U / S  80 CCE :  Aggregate  amount  of  deduction  u/s 80C, 80CCC and  80 CCD  is  restricted  to  Rs.1,50,000/-",null,null,null,null,"Rs.",{"$f":"IF(SUM(I27:I40)>=150000,150000,SUM(I27:I40))","v":0}]
[null,"(v)","U / S  80 CCD (1B) Additional Contribution  to  pension  scheme  of  central  Govt (upto Rs.50000/-)",null,null,null,null,"Rs."]
[null,"(vi)","U / S  80D :  Medical insurance premium paid in the name of assessee (if age<60, Self/Spouse/Child - ₨25,000 & if age<60 for Parents ₨. 25,000)   \n",null,null,null,null,"Rs.",{"$f":"IF('Form 12BB Page3&4'!$L$72=0,MIN('Form 12BB Page3&4'!$L$73,25000),IF('Form 12BB Page3&4'!L72<=2,MIN('Form 12BB Page3&4'!$L$73,50000),0))","v":0}]
[null,"(vii)","U / S 80DD :  Expenses  on  medical  treatment  etc.,  and  deposit  made  for  maintenance  of  handicapped  dependents (Max  Rs.75,000/-) in  case  of  severe  disabilities  Rs.1,25,000/-",null,null,null,null,"Rs.",{"$f":"Page5!O19","v":0}]
[null,"I PAGE TOTAL                                             C/O ",null,null,null,null,null,"Rs.",{"$f":"SUM(I41+I42+I43+I44)","v":0}]
[null,"I PAGE TOTAL                                             B/F",null,null,null,null,null,"Rs.",{"$f":"I45","v":0}]
[null,"(viii)","U / S 80DDB :  Medical  expenses  towards  treatment  of  himself,  or  a  dependent  relative  for  specified  diseases  and  ailments  (amounts  actually  paid  or  Rs.40,000/- Whichever  is  less,  form 10  should  be  enclosed)  for  senior  citizen  Rs.1,00,000/-  or  expenditure  incurred",null,null,null,null,"Rs."]
[null,"(ix)","U / S 80 E : Repayment  of  interest  on  loan  taken  for  higher  studies  availed  by  the  assessee",null,null,null,null,"Rs."]
[null,"(x)","U / S  80 G :  Donation  to  approved  funds  and  charitable  institutions",null,null,null,null,"Rs."]
[null,"(xi)","U / S  80 U :  Deduction  in  respect  of  totally  blind or  mentally  retarded  or  permanent  physically  handicapped  persons ( Upto Rs.75,000/- if  disabilities  is  over  40%  and  Rs.1,25,000/-  if  disabilities  is  over  80%.",null,null,null,null,"Rs."]
[null,"(xii)","Others (Please specify)",null,null,null,null,"Rs."]
[null,"GRAND TOTAL [ SUM  OF 8(i) TO 8(xii) ]",null,null,null,null,null,"Rs.",{"$f":"SUM(I46:I51)","v":0}]
[9,"TOTAL  TAXABLE  INCOME  ( 7 - 8 )\n(Rounded  off  to  nearest  ten  rupees)\nNote: ALL  DEDUCTION UNDER COLUMN 9(i)  TO  9(xii)  CANNOT  EXCEED  GROSS  TOTAL INCOME",null,null,null,null,null,null,null,"Rs.",{"$f":"(K24-I52+5)-MOD(K24-I52+5,10)","v":-50000}]
[null,"COMPUTATION  OF  TAX: ( Rounded off to nearest one rupee)"]
[null,"Table  1 : Tax  rates  applicable  to  Men and Women Employees   "]
[{"$f":"INC","v":-50000},"TAXABLE  INCOME",null,null,"INCOME  TAX  RATE",null,null,null,"INCOME  TAX                                                      Rs."]
[null,"Deduction u/s 80C, 80D are permitted as usual"]
[null,"Upto  Rs.2,50,000",null,null,"Nil",null,null,null,{"$f":"IF(A58<250000,\"NIL\",\"\")","v":"NIL"}]
[null,"Rs.2,50,001  to  Rs.5,00,000",null,null,"5%  of  the  amt  exceeding  Rs.2,50,000",null,null,null,{"$f":"IF(AND(K53>250000,K53<=500000),(K53-250000)*5%,0)","v":0}]
[null,"Rs.5,00,001  to  Rs.10,00,000",null,null,"Rs.12,500 + 20% of amt exceeding Rs.5,00,000",null,null,null,{"$f":"IF(AND(K53>500000,K53<=1000000),(K53-500000)*20%+12500,0)","v":0}]
[null,"Exceeding  Rs.10,00,000",null,null,"Rs.1,12,500 + 30% of the amt exceeding Rs.10,00,000",null,null,null,{"$f":"IF(K53>1000000,(K53-1000000)*30%+112500,0)","v":0}]
[null,"Table  2 : Education Cess"]
[null,"Education  cess of  4% is payable on  total tax"]
[10,"Tax  payable  on  Taxable  Income  :                                                                                                      \n(As per  table  1 or 2  as  above)",null,null,null,null,null,null,null,"Rs.",{"$f":"IF(I59<>0,I59,IF(I60<>0,I60,I61))","v":0}]
[11,"Less: Rebate u/s 87A (Rs.12500/-)\n(Applicable if the Total Taxable Income does not exceed Rs.5,00,000/-)",null,null,null,null,null,null,null,"Rs.",{"$f":"IF(AND(K53<=500000,K64<12500),K64,IF(AND(K53<=500000,K64<>0,K64>=12500),12500,0))","v":0}]
[12,"Tax  payable  on  Taxable  Income",null,null,null,null,null,null,null,"Rs.",{"$f":"K64-K65","v":0}]
[13,"ADD :  Education  cess  @ 4%  on  Tax  Payable",null,null,null,null,null,null,null,"Rs.",{"$f":"K66*4%","v":0}]
[14,"Total  Tax  Payable",null,null,null,null,null,null,null,"Rs.",{"$f":"IF($K$66+$K$67<>0,$K$66+$K$67,\"NIL\")","v":"NIL"}]
[15,"LESS : Rebate  u / s 86, 89, 90  or  91",null,null,null,null,null,null,null,"Rs."]
[16,"LESS : Pre Paid Tax (TDS)",null,null,null,null,null,null,null,"Rs.",{"$f":"IFERROR(SUM(Page5!$O$28+$E$72+$G$72),Page5!$O$28)","v":0}]
[17,"Balance Income Tax with Education cess to be deducted in February 2023 / Refund",null,null,null,null,null,null,null,"Rs.",{"$f":"IFERROR(IFERROR(SUM(TAX-($K$69+$K$70)),$K$68-($K$69+$K$70)),\"NIL\")","v":"NIL"}]
[18,"Paid by Challan",null,"TAN",null,"PAN",null,"FORM16 -",null,"Rs.",{"$f":"IFERROR(SUM($K$70-$G$72),0)","v":0}]
[]
[null,"COUNTERSIGNED"]
[null,"FOR PRINCIPAL \nGOVT COLLEGE OF TECHNOLOGY, COIMBATORE 13",null,null,null,null,null,"Signature:"]
[null,null,null,null,null,null,null,"Designation:",{"$f":"Page5!M4","v":0}]

{"sheet":"Form 12BB Page3&4","index":1,"n_rows":85,"n_cols":12,"rows_kept":85,"cut":false,"hidden":false,"merged":[[62,8,62,9],[59,0,59,3],[59,4,59,5],[59,6,59,7],[59,8,59,9],[60,0,60,3],[60,4,60,5],[60,6,60,7],[60,8,60,9],[61,0,61,3],[61,4,61,5],[61,6,61,7],[61,8,61,9],[62,0,62,3],[62,4,62,5],[62,6,62,7],[36,7,36,9],[37,7,37,9],[49,6,49,7],[50,6,50,7],[51,6,51,7],[49,8,49,9],[50,8,50,9],[51,8,51,9],[51,0,51,2],[51,3,51,5],[50,0,50,2],[49,0,49,2],[49,3,49,5],[36,0,36,4],[36,5,36,6],[37,0,37,4],[37,5,37,6],[45,5,45,6],[48,8,48,9],[48,6,48,7],[39,7,39,9],[42,7,42,9],[40,0,40,9],[48,3,48,5],[50,3,50,5],[48,0,48,2],[58,0,58,10],[53,0,53,10],[54,0,54,2],[54,3,54,4],[54,5,54,8],[46,0,46,9],[39,0,39,4],[39,5,39,6],[41,0,41,10],[52,0,52,9],[57,9,57,10],[57,0,57,8],[47,0,47,10],[43,5,43,6],[45,0,45,4],[42,0,42,4],[42,5,42,6],[43,0,43,4],[43,7,43,9],[45,7,45,9],[54,9,54,10],[55,0,55,2],[55,3,55,4],[55,5,55,8],[55,9,55,10],[56,0,56,2],[56,3,56,4],[56,5,56,8],[56,9,56,10],[25,0,25,2],[25,3,25,5],[25,6,25,7],[25,8,25,9],[28,0,28,2],[28,3,28,5],[28,6,28,7],[28,8,28,9],[26,0,26,2],[26,3,26,5],[26,6,26,7],[26,8,26,9],[27,0,27,2],[27,3,27,5],[13,8,13,10],[14,6,14,7],[14,8,14,10],[15,6,15,7],[15,8,15,10],[16,6,16,7],[27,8,27,9],[19,6,19,7],[19,8,19,10],[21,6,21,9],[27,6,27,7],[15,2,15,5],[18,2,18,5],[23,6,23,7],[23,8,23,9],[24,0,24,2],[24,3,24,5],[24,6,24,7],[24,8,24,9],[22,0,22,10],[23,0,23,2],[23,3,23,5],[10,6,10,10],[10,2,10,5],[20,0,20,1],[20,2,20,5],[20,6,20,10],[11,6,11,7],[11,8,11,10],[17,2,17,5],[19,2,19,5],[17,6,17,7],[18,6,18,7],[17,8,17,10],[18,8,18,10],[10,0,10,1],[11,2,11,5],[11,0,19,1],[12,6,12,7],[12,8,12,10],[13,6,13,7],[16,8,16,10],[16,2,16,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[0,0,0,10],[3,6,3,10],[1,0,1,10],[6,9,6,10],[5,2,5,5],[4,6,4,10],[6,2,6,5],[7,6,7,10],[5,8,5,10],[2,0,2,10],[3,0,3,1],[3,2,3,5],[4,0,9,1],[4,2,4,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[8,6,8,10],[9,6,9,10],[69,0,69,2],[69,3,69,5],[69,6,69,7],[69,8,69,9],[70,0,70,2],[70,3,70,5],[70,6,70,7],[70,8,70,9],[63,6,63,10],[65,6,65,10],[67,0,67,2],[67,3,67,5],[67,6,67,7],[67,8,67,9],[66,0,66,5],[66,6,66,9],[29,0,29,2],[29,3,29,5],[29,6,29,7],[29,8,29,9],[35,0,35,10],[34,0,34,9],[33,0,33,2],[33,3,33,5],[33,6,33,7],[30,0,30,2],[30,3,30,5],[30,6,30,7],[30,8,30,9],[32,0,32,2],[32,3,32,5],[32,6,32,7],[32,8,32,9],[33,8,33,9],[71,0,71,9],[21,0,21,5],[65,0,65,5],[63,0,63,5],[64,0,64,5],[64,6,64,10],[72,0,72,5],[72,6,72,10],[73,0,73,5],[73,6,73,10],[31,0,31,2],[31,3,31,5],[31,6,31,7],[31,8,31,9],[38,0,38,4],[38,5,38,6],[38,7,38,9],[44,0,44,4],[44,5,44,6],[44,7,44,9],[68,0,68,2],[68,3,68,5],[68,6,68,7],[68,8,68,9],[74,0,74,5],[74,6,74,10],[75,0,75,10],[76,0,76,10],[77,0,77,5],[78,0,78,5],[79,0,79,5],[77,6,77,10],[78,6,78,10],[79,7,79,10]]}
["FORM NO.12BB"]
["(See rule 26C)"]
["Details of Claims and Evidence thereof (Financial Year 2023-24) (Other than Salary Savings Scheme)"]
["Sl No.",null,"Nature of claim",null,null,null,"Particulars"]
[1,null,"House Rent Allowance:"]
[null,null,"(i) Rent paid to the landlord",null,null,null,"Total (Rs.)",{"$f":"'Annexure 1'!C24","v":0},"( Fill Anexure 1)"]
[null,null,"(ii) Occupied Period",null,null,null,"From",null,"To"]
[null,null,"(iii) Name of the landlord",null,null,null,{"$f":"'Annexure 1'!D6:H6","v":0}]
[null,null,"(iv) Address of the landlord (If Occupied Quarters iv, v, vi are not needed)",null,null,null,{"$f":"'Annexure 1'!D7:H7","v":0}]
[null,null,"(v)  [Permanent Account No. or Aadhaar No.] of the landlord. Note. Copy of PAN/ Aadhaar Card was a must to claim HRA.",null,null,null,{"$f":"'Annexure 1'!F8:H8","v":0}]
[2,null,"Leave travel concessions or assistance"]
[3,null,"Deduction of Interest/Principal on Borrowing:",null,null,null,"Loan 1 (Specify)",null,"Loan 2 (Specify)"]
[null,null,"(i) Interest payable/paid to the lender "]
[null,null,"(ii) Principal payable/paid to the lender"]
[null,null,"(iii) Name of the lender"]
[null,null,"(iv) Address of the lender"]
[null,null,"(v)  [Permanent Account No. or Aadhaar No.] of the lender. "]
[null,null,"(a) Financial Institutions(if available)  "]
[null,null,"(b) Employer(Applied/Not Applied/Approved)"]
[null,null,"(c) Others"]
[4,null,"Deduction under Chapter VI-A"]
["(A) Section 80C",null,null,null,null,null,"LIC & PLI (SSS)",null,null,null,{"$f":"Page5!R24+Page5!S24","v":0}]
["i) Details of LIC, PLI, RPLI, PPF, SSY, UTI (ULIP) PREMIUM PAID"]
["Policy No.",null,null,"Name of the Insured & Relationship",null,null,"LIC/PLI/RPLI/PPF/SSY/UTI (ULIP)",null,"Sum Insured",null,"Premium Paid (Exclude G.S.T)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total.",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K25:K34)","v":0}]
["ii) Details of National Savings Certificate (N.S.C.)"]
["Post Office",null,null,null,null,"Issue No.",null,"N.S.C. No.",null,null,"Amount"]
[]
[]
[]
["Total.",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K38:K40)","v":0}]
["Details of Interest Accured on N.S.C."]
["N.S.C. No. & Name of Post Office",null,null,null,null,"Date of Purchase ",null,"Rate of Int. %",null,null,"Amount"]
[]
[]
[]
["Total.",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K44:K46)","v":0}]
["iii) Details of Investment made in E.L.S.S. of Mutual Funds"]
["Folio Number",null,null,"Scheme Name",null,null,"Date of Investment",null,"Rate of Int. %",null,"Amount"]
[]
[]
[]
["Total.",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K50:K52)","v":0}]
["iv) Details of Tution Fees Paid in F.Y. 2022-23 (Maximum Two Children)"]
["Name of the Child",null,null,"Class / Course",null,"Name of the School / College",null,null,null,"Amount (Tuition Fees)"]
[]
[]
["Total.",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J56:K57)","v":0}]
["v) Details of  Other Eligible Investments in THE F.Y. 2022-23"]
["NATURE OF INVESTMENT",null,null,null,"DATE OF INVESTMENT",null,"DATE OF MATURITY",null,"AMOUNT",null,"REMARKS"]
[]
[]
[]
["B) Section 80CCC (Please specify)"]
["C) Section 80CCD (Please specify)"]
["D) Section 80D"]
["Details of Medical Insurance Premium Paid.",null,null,null,null,null,"NHIS(SSS)",null,null,null,{"$f":"Page5!N24","v":0}]
["Policy No.",null,null,"Name of the Insured & Relationship",null,null,"Name of Policy",null,"Age",null,"Premium Paid (Exclude G.S.T)"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($I$69>=60,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($I$70>=60,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($I$71>=60,1,0)","v":0}]
["Total.",null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K69:K71)","v":0},{"$f":"SUM(L69+L70+L71)","v":0}]
["E) Others (Please specify)",null,null,null,null,null,null,null,null,null,null,{"$f":"K67+K72","v":0}]
["F) Others (Please specify)"]
["G) Others (Please specify)"]
["Verification"]
["                           I,…….………….……………..,son/daughter of…………………….…………….. do hereby certify that the information given above is true, complete and correct and I have enclosed all the evidences for savings claimed by me with this certificate."]
["Place……………………………………………..."]
["Date……………………………………………....",null,null,null,null,null,"(Signature of the employee)"]
["Designation ……………………………….……..",null,null,null,null,null,"Full Name"]
[]
[null,"Note."]
[null,"1. Copy of PAN/ Aadhaar Card & Rent Receipt with Stamp was a must to claim HRA."]
[null,"2. Copy of Evidences & Original Receipts was a must to claim Other savings."]
[null,"3. Copy of Self Certificate was a must."]

{"sheet":"Page5","index":2,"n_rows":37,"n_cols":21,"rows_kept":37,"cut":false,"hidden":false,"merged":[[19,19,19,20],[36,1,36,4],[36,16,36,19],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,8,5,8],[4,2,5,2],[27,2,27,7],[27,9,27,13],[28,9,28,13],[27,15,27,19],[25,2,25,7],[25,9,25,13],[1,17,1,19],[3,18,3,20],[4,1,5,1],[4,6,5,6],[4,7,5,7],[4,17,4,18],[4,9,4,16],[4,19,5,20],[3,12,3,15],[3,16,3,17],[1,1,1,16],[3,4,3,8],[3,9,3,11]]}
[null,null,"STATEMENT SHOWING THE PAY AND OTHER ALLOWANCES DRAWN AND DEDUCTIONS PARTICULARS"]
[null,"  FOR  THE FINANCIAL YEAR  2023 - 2024 (ASSESSMENT  YEAR   2024 - 2025)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Professional Tax"]
[]
[null,"Emp.Code.",null,"Name.",{"$f":"IFERROR(VLOOKUP($C$4,GK,3,FALSE),\"\")","v":""},null,null,null,null,"Designation.",null,null,null,null,null,null,"PAN. No."]
[null,"MONTH"," Pay\nRs.","DA       Rs.","HRA      Rs.","CCA      Rs.","MA        Rs.","OA          Rs.","TOTAL  Rs.","DEDUCTIONS",null,null,null,null,null,null,null,"SSS",null,"OTHER REMUNERATIONS          Rs."]
[null,null,null,null,null,null,null,null,null,"GPF","CPS","FBF","SPF","NHIS","IT      (include cess)","HBA","HBA FBF","LIC","PLI"]
[null,"2023-03-01",null,null,null,null,null,null,{"$f":"SUM(C7:H7)","v":0},null,null,null,null,null,null,null,null,null,null,"BONUS"]
[null,"2023-04-01",null,null,null,null,null,null,{"$f":"SUM(C8:H8)","v":0},null,null,null,null,null,null,null,null,null,null,"Consult 1"]
[null,"2023-05-01",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Testing 1"]
[null,"2023-06-01",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"PartTime 1"]
[null,"2023-07-01",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"PartTime 2"]
[null,"2023-08-01",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"EXAM"]
[null,"2023-09-01",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"TFC"]
[null,"2023-10-01",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"TNEA"]
[null,"2023-11-01",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Hostel"]
[null,"2023-12-01",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Others"]
[null,"2024-01-01",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Others"]
[null,"2024-02-01",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Others"]
[null,"DA ARR.",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"SUBTOTAL(9,U7:U18)","v":0}]
[null,"CAS ARR.",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"REM. TAXES"]
[null,"MPHIL ARR.",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Cons Tax 1"]
[null,"INCR ARR.",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Tax 3"]
[null,"ARREAR 5",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,"Tax 2"]
[null,"GROSS TOTAL",{"$f":"SUBTOTAL(9,C7:C23)","v":0},{"$f":"SUBTOTAL(9,D7:D23)","v":0},0,0,0,{"$f":"SUBTOTAL(9,H7:H23)","v":0},0,0,0,0,0,0,0,{"$f":"SUBTOTAL(9,P7:P23)","v":0},0,0,0,"TOTAL",{"$f":"SUBTOTAL(9,U21:U23)","v":0}]
[]
[]
[]
[null,null,"Gross Total Income",null,null,null,null,null,{"$f":"I24+U19","v":0},"Gross Total Income Tax",null,null,null,null,{"$f":"O24+U24","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"SIGNATURE OF THE EMPLOYEE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIGNATURE OF THE ASSESSEE"]

{"sheet":"Annexure 1","index":3,"n_rows":34,"n_cols":8,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,2,3,4],[6,0,6,2],[3,6,3,7],[0,0,0,7],[1,0,1,7],[5,0,5,2],[3,0,3,1],[4,0,4,1],[25,0,27,7],[28,0,29,7],[4,2,4,7],[10,1,10,7],[7,5,7,7],[5,3,5,7],[6,3,6,7],[23,0,23,1],[7,0,7,4]]}
["Annexure 1"]
["(See rule 26C)"]
[]
["Name",null,{"$f":"Page5!E4","v":""},null,null,"PAN. No.",{"$f":"Page5!S4","v":0}]
["Designation.",null,{"$f":"Page5!M4","v":0}]
["(i) Name of the landlord"]
["(ii) Address of the landlord "]
["(iii)  [Permanent Account No. or Aadhaar No.] of the landlord. Note. Copy of PAN/ Aadhaar Card was must to claim HRA."]
["S. No.","Month","Actual Rent Paid (Rs.)","Pay (Rs.)","DA (Rs.)","10% of (Pay + DA) (Rs.)","( A - D ) ","Actual HRA Received (Rs.)"]
[null,null,"(A)","(B)","(C)","(D)","(E)","(F)"]
[null,"( Only Fill the Actual Period of Occupying Rental House )"]
[1,"2023-03-01",null,null,null,{"$f":"ROUND(SUM(SUM(D12+E12)*10%),0)","v":0},{"$f":"C12-F12","v":0}]
[2,"2023-04-01",null,null,null,{"$f":"ROUND(SUM(SUM(D13+E13)*10%),0)","v":0},{"$f":"C13-F13","v":0}]
[3,"2023-05-01",null,null,null,0,0]
[4,"2023-06-01",null,null,null,0,0]
[5,"2023-07-01",null,null,null,0,0]
[6,"2023-08-01",null,null,null,0,0]
[7,"2023-09-01",null,null,null,0,0]
[8,"2023-10-01",null,null,null,0,0]
[9,"2023-11-01",null,null,null,0,0]
[10,"2023-12-01",null,null,null,0,0]
[11,"2024-01-01",null,null,null,0,0]
[12,"2024-02-01",null,null,null,0,0]
["Total",null,{"$f":"SUM(C12:C23)","v":0},{"$f":"SUM(D12:D23)","v":0},0,0,0,0]
[]
["i) I Certified that, i am occupying GCT/ TNHB Quarters from ..................... and I also certified that i don't have own House in the coimbatore District."]
[]
[]
["ii) I Certified that, I am occupying Rental House from ..................... and I also certified that i don't have own House in the coimbatore District."]
[]
[]
[]
[]
[null,null,null,null,null,"(Signature of the employee)"]

{"sheet":"DATA","index":4,"n_rows":273,"n_cols":3,"rows_kept":273,"cut":false,"hidden":true,"merged":[]}
[10,1,"B.NITHYAKALYANI          "]
[130,2,"M.MURUGESH               "]
[104,3,"M.THAMIZHSELVAN          "]
[105,4,"M.NITHYA                 "]
[112,5,"M.DHARMALINGAN           "]
[113,6,"S. SATHYA                "]
[109,7,"P.S.VIMALARANI           "]
[123,8,"G.PRABHU                 "]
[111,9,"P.R.RANGASAMY            "]
[114,10,"M.SABITHAMANI            "]
[115,11,"M.DEVIKA                 "]
[119,12,"T.S.VISWALINGAM          "]
[120,13,"S. MAHENDRAN             "]
[118,14,"J.ARAVINTH KUMAR         "]
[107,15,"S.ASHOKRANJAN            "]
[117,16,"P.UMADEVI                "]
[133,17,"T. KAVIYA                "]
[126,18,"K.NAGARAJAN              "]
[125,19,"T.RAJENDRAN              "]
[106,20,"C.KAVERI                 "]
[317,21,"M. JAIKUMARI             "]
[348,22,"R RANGARAJ               "]
[349,23,"G.K.PREMKUMAR            "]
[356,24,"K. CHITHRA               "]
[361,25,"R.YOGANATHAN             "]
[353,26,"P.MAHESWARI              "]
[315,27,"P.GOKHUL KRISHNAN        "]
[337,28,"R. KARPAGASHANMUGI                      "]
[309,29,"S.MUTHAMIZHAN            "]
[350,30,"M. SATHYA                "]
[322,31,"P.GOMATHI                "]
[334,32,"M. SARAVANAN             "]
[310,33,"D RAVI                   "]
[311,34,"K. VIGNESH               "]
[313,35,"P. CHANDRAKUMAR          "]
[301,36,"K.NATARAJ                "]
[307,37,"P.JAGATHESAN             "]
[306,38,"MOHAN BABU S             "]
[351,39,"P.MURUGANANTHAM          "]
[305,40,"SENTHILKUMAR K           "]
[324,41,"J.SATHISH                "]
[359,42,"D. NANTHAKUMAR           "]
[367,43,"R.VIMAL SINGH            "]
[318,44,"C.ANBUMALAR              "]
[319,45,"M.KARTHIKKUMAR           "]
[325,46,"V.AMSA                   "]
[332,47,"P.GIRIJA                 "]
[333,48,"S.MURUGESAN              "]
[335,49,"D.REETA                  "]
[342,50,"S.VIJAYAKUMAR            "]
[364,51,"P.SRINIVASAN             "]
[320,52,"P.KARTHIKEYAN            "]
[304,53,"S.JAYASEELA              "]
[818,54,"R.KARTHIKEYAN            "]
[807,55,"HARINI M                 "]
[806,56,"M.MAHESWARAN             "]
[813,57,"M.VEERAMMAL              "]
[815,58,"V.SUKUMAR                "]
[848,59,"A.KARUPPATHAL            "]
[829,60,"SILAMBARASAN K           "]
[830,61,"DINESH G                 "]
[831,62,"A.J.NAZIRUDEEN           "]
[832,63,"KARUPPASAMY B            "]
[833,64,"A.KARPAGAM               "]
[835,65,"R.SASIKUMAR              "]
[836,66,"R.SELVAKUMAR             "]
[839,67,"SAKTHIVEL K              "]
[834,68,"B.NAGARAJ                "]
[802,69,"N. MARUDACHALAM          "]
[803,70,"M.MYTHEENSHA             "]
[804,71,"C.SARAVANAN              "]
[901,72,"T.NAGARAJAN              "]
[964,73,"V.MUTHUKILI              "]
[947,74,"C.PALPANDI               "]
[948,75,"VENKATACHALAM G          "]
[951,76,"B.RAGHAVADEVI            "]
[904,77,"A.MURTHY                 "]
[934,78,"B.MURALI                 "]
[936,79,"K.S.RAJAN                "]
[906,80,"P.RATHINASAMY            "]
[907,81,"GURUSAMY S               "]
[909,82,"RAMASAMY K               "]
[910,83,"N.KUMAR                  "]
[911,84,"N.DHANDAPANI             "]
[912,85,"SUBASHCHANDRABOSE P      "]
[914,86,"LOKESH R                 "]
[915,87,"RAMYA P                  "]
[916,88,"KALAISELVAN R            "]
[922,89,"G.GEORGE JOHN            "]
[925,90,"K.MANIKANDAN             "]
[953,91,"S.THIRUMOORTHY           "]
[954,92,"P.RANGASAMY              "]
[955,93,"D.SIVAKUMAR              "]
[957,94,"C.PANNEERSELVAM          "]
[958,95,"P.THAMBURAJ              "]
[960,96,"N.RANGARAJ               "]
[961,97,"R.MANIVANNAN             "]
[1136,98,"S.MURUGESAN              "]
[1158,99,"P.RAJAMMAL               "]
[917,100,"A.KUMARAVELU             "]
[918,101,"H.SATHIYANARAYANAN       "]
[919,102,"R.MOHANASUNDARAM         "]
[920,103,"R.A.DHARMARAJAN          "]
[923,104,"V.KRISHNAMOORTHY         "]
[926,105,"S. SENTHILKUMAR          "]
[1102,106,"P.BALAMURUGAN            "]
[1103,107,"K.SUBASH                 "]
[1105,108,"V.VENGATESH              "]
[1122,109,"R.SEKAR                  "]
[1123,110,"N.BALAMURUGAN            "]
[1124,111,"I.CHANDRASEKAR           "]
[1125,112,"R.THIRUVENKATASUBRAMANIAN"]
[824,113,"B.SARAVANAN              "]
[825,114,"D.SELVARASU              "]
[851,115,"K.RAMESH                 "]
[852,116,"G.VELAZHAGAN             "]
[854,117,"T.SELVAM                 "]
[856,118,"R.SARAVANAN              "]
[857,119,"G.BABU                   "]
[858,120,"G.DURAIMANIKANDAN        "]
[859,121,"P.MURUGAVEL              "]
[860,122,"P.SENTHILVELAVAN         "]
[861,123,"P.SUNDHARARAJAN          "]
[850,124,"C.SAKTHIVEL              "]
[853,125,"R.RAMACHANDRAN           "]
[838,126,"A.SIRAJUNISHABEGAME      "]
[840,127,"U.BALACHANDRAN           "]
[841,128,"N.RAJMOHAN               "]
[842,129,"S.ANBALAGAN              "]
[843,130,"J.TAMILMATHI             "]
[844,131,"P.R.ANANDHABALAN         "]
[355,132,"S. JAYSANKAR             "]
[338,133,"M. SRINIVASAN            "]
[357,134,"P. SIVARAMAN             "]
[437,135,"G.DHAMOTHARAKKANNAN      "]
[440,136,"K.REKHA                  "]
[446,137,"S.SATHYAPRIYA            "]
[450,138,"C. BHARATHI              "]
[451,139,"S.CHITHRA (CIVIL)               "]
[452,140,"M.RAMA                   "]
[461,141,"R.BHUVANESWARI           "]
[443,142,"K. RAJESH KUMAR          "]
[448,143,"P. ANDAVAR               "]
[444,144,"V.SATHEES KUMAR          "]
[407,145,"P. NIRMAL                "]
[412,146,"R.SURENDRAN              "]
[413,147,"B.RAJESWARI              "]
[414,148,"M S AEZHISAI VALLAVI     "]
[415,149,"S.BRADEESH MOORTHY       "]
[416,150,"T. SEKAR                 "]
[418,151,"RAKESH GAUTAM            "]
[417,152,"D. KULANDAIVEL           "]
[441,153,"C.MEIARAJ                "]
[442,154,"S.P.JAYAPRIYA            "]
[401,155,"S.CHITRA (EEE)              "]
[406,156,"P.MARUTHUPANDI           "]
[428,157,"G.SUCHITRA               "]
[409,158,"S.SOWKARTHIKA            "]
[419,159,"N.NANDHAKUMAR            "]
[420,160,"S.PARIMALA MURUGAVENI    "]
[462,161,"K.RAMESH                 "]
[431,162,"M.MUTHUCHELVAM           "]
[432,163,"J.DURAIKANNAN            "]
[435,164,"M.RAJESWARI              "]
[455,165,"S.AYYAPPAN (PHYSICS)               "]
[434,166,"S.ANBUCHUDAR AZHAGAN     "]
[439,167,"R.SATHYA                 "]
[453,168,"J.ANBAZHAGAN VIJAY       "]
[421,169,"M.KALPANA                "]
[457,170,"G.RAVINDRA DEVI REVATHI  "]
[402,171,"V.PRASANNA MOORTHY       "]
[403,172,"N.NARMADHAI              "]
[463,173,"R.RAJESWARI              "]
[464,174,"K.RANJITHKUMAR           "]
[433,175,"P.ASAIGEETHAN            "]
[430,176,"R.RAJENDIRAN             "]
[404,177,"SUJATHA BALARAMAN        "]
[445,178,"S.MURUGAN                "]
[576,179,"N.VADIVEL                "]
[577,180,"S.USHA                   "]
[534,181,"P.ILAMATHI               "]
[535,182,"M.SANKAR KUMAR           "]
[536,183,"A.SASIKUMAR              "]
[537,184,"G.VIJAYA RAJA RAGAVAN    "]
[538,185,"S.KUMAR                  "]
[539,186,"N.AJAY MANIKANDAN        "]
[501,187,"K.YASODA                 "]
[524,188,"O.SARANYA                "]
[549,189,"N.AMEENA BIBI            "]
[531,190,"A.MEENA KOWSHALYA        "]
[530,191,"T.RAJASENBAGAM           "]
[532,192,"L.SUMATHI                "]
[512,193,"K.KUMAR                  "]
[510,194,"R.BHAVANI                "]
[507,195,"P.N.KANNAN               "]
[525,196,"M.SAKTHIVEL              "]
[502,197,"S.LATHA VENKATESHWARI    "]
[508,198,"J.C.MIRACLIN JOYCE PAMILA"]
[509,199,"S.RATHI                  "]
[533,200,"S.MATHIVANAN             "]
[550,201,"A.ANITHA                 "]
[548,202,"P.DEEPA                  "]
[574,203,"M.C.RAVATHI              "]
[575,204,"S.MAKESH KUMAR           "]
[541,205,"C.MARIMUTHU              "]
[542,206,"A.S.WINCY PON ANNAL      "]
[543,207,"M.RAGHAPPRIYA            "]
[544,208,"N.ARULMOZHI              "]
[545,209,"G.R.RADHIKA              "]
[546,210,"A.SUGUNA                 "]
[551,211,"R.DEVI                   "]
[552,212,"M.BLESSY QUEEN MARY      "]
[553,213,"T.SUGUNA                 "]
[554,214,"M.JEYANTHI               "]
[555,215,"S.GLADSON OLIVER         "]
[556,216,"C.ASWINI                 "]
[558,217,"R.MALAVIKA               "]
[557,218,"M. GOWRI SHANKAR         "]
[559,219,"J.ARUN  BASKARAN         "]
[560,220,"R.NITHYA                 "]
[561,221,"A.THIRUNAVUKKARASU       "]
[562,222,"P.SARANYA                "]
[563,223,"K.SELVAPRIYA             "]
[564,224,"A.ANNU                   "]
[565,225,"D.ANGELINE KIRUBA        "]
[567,226,"V.KARTHIK                "]
[568,227,"S.MADHUVANTHI            "]
[570,228,"J.MERCY NISHA PAULINE    "]
[571,229,"V.RAJASEKAR              "]
[572,230,"C.MUTHUKUMARAN           "]
[573,231,"G.SHARMILA               "]
[569,232,"T.MALARVIZHI             "]
[566,233,"M.N.NAFISA BEGAM         "]
[580,234,"R. MUTHURAM              "]
[718,235,"R.R. SRIDEVI             "]
[716,236,"R.CHITHRA                "]
[707,237,"S PERIYASAMY             "]
[708,238,"S. AYYAPPAN (MECH)            "]
[715,239,"M.KUMAR                  "]
[709,240,"K.RAJUPILLAI             "]
[710,241,"M.GNANAKUMAR             "]
[711,242,"N.DEEPA                  "]
[712,243,"A.VANITHA                "]
[713,244,"L.BALAKRISHNAN           "]
[717,245,"D.VIMALA                 "]
[719,246,"E. RAGA IMA DEVI         "]
[714,247,"M.SHYAMALA               "]
[721,248,"C.SIVASANKARI            "]
[504,249,"D. KANAGARAJAN           "]
[513,250,"P. MANGAIYARKARASI       "]
[511,251,"G. THIRUGNANAM           "]
[540,252,"S. ANBU                  "]
[547,253,"B. ACHIAMMAL             "]
[422,254,"K.KUMARAVEL              "]
[411,255,"J.RANGARAJ               "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1,2,3]