{"text_format":"2","workbook":"xls","n_sheets":18,"sheets":["DATA","Pay Calu","Pay","SL","DA","PRC 2020","IT Cal","Anne","Table","12BB","Form 16(F)","w","Form 16 (B)","10E(2)","Rent","Empty","10E","10E Caluculation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"DATA","index":0,"n_rows":137,"n_cols":19,"rows_kept":137,"cut":false,"hidden":false,"merged":[[34,3,34,4],[34,7,34,8],[37,7,37,8],[38,7,38,8],[39,7,39,8],[35,3,35,4],[35,7,35,8],[37,3,37,4],[13,6,13,7],[2,11,54,11],[29,6,29,7],[45,9,45,10],[20,2,20,3],[22,1,22,7],[47,5,47,6],[48,5,48,6],[29,3,29,4],[33,1,33,10],[9,2,9,3],[23,1,23,4],[24,3,24,4],[11,2,11,3],[16,2,16,3],[8,2,8,3],[42,1,42,2],[41,1,41,2],[49,3,49,4],[49,5,49,6],[50,5,50,6],[39,3,39,4],[49,1,49,2],[40,1,40,10],[46,1,46,2],[51,1,51,2],[46,3,46,4],[47,3,47,4],[46,5,46,6],[47,1,47,2],[51,3,51,4],[50,3,50,4],[51,5,51,6],[2,0,54,0],[41,3,41,4],[6,2,6,3],[7,2,7,3],[53,3,53,4],[15,6,15,7],[32,1,32,10],[45,5,45,7],[45,1,45,4],[38,3,38,4],[54,1,54,10],[20,6,20,7],[21,6,21,7],[18,2,18,3],[52,3,52,4],[50,1,50,2],[48,1,48,2],[42,3,42,4],[21,2,21,3],[36,3,36,4],[0,0,0,11],[1,0,1,11],[17,9,17,10],[10,2,10,3],[9,9,9,10],[2,1,2,3],[12,2,12,3],[13,2,13,3],[2,4,21,4],[17,2,17,3],[30,6,30,7],[23,6,28,7],[30,3,30,4],[31,6,31,7],[36,7,36,8],[25,3,25,4],[27,3,27,4],[28,3,28,4],[31,3,31,4],[26,3,26,4],[18,6,18,7],[19,6,19,7],[14,2,14,3],[3,2,3,3],[19,2,19,3],[5,2,5,3],[5,6,5,7],[4,2,4,3],[15,2,15,3],[7,6,7,7],[51,9,52,9],[2,9,2,10],[2,8,31,8],[2,5,2,7],[9,6,9,7],[11,6,11,7],[51,10,52,10],[52,5,52,6],[3,6,3,7],[17,6,17,7],[53,5,53,10],[41,7,41,8],[42,7,42,8],[44,1,44,10],[43,3,43,4],[52,1,52,2],[53,1,53,2],[48,3,48,4],[43,1,43,2],[43,7,43,8]],"flags":["formulas_cached_only"]}
["PARTICULARS FOR INCOMETAX FOR THE FY YEAR 2024-25\n(ASSESSMENT YEAR 2025-26)"]
[]
[null,"PERSONAL DETAILS",null,null,null,"DEDUCTIONS",null,null,null,"DDO DETAILS",null,0]
[null,"Name of the Employee","N RAJENDER REDDY",null,null,"GPF in March, 2024",10000,null,null,"Name of the DDO","ABCDEFXYZ"]
[null,"Father's Name","RAJI REDDY",null,null,"If PF Change","No Change",10000,null,"D.D.O. Designation","HEADMASTER"]
[null,"Designation","SGT",null,null,"TSGLI in March 2024",3000,null,null,"Place of Working","ZPHS XYZ"]
[null,"EMP ID No.","1234567",null,null,"If TSGLI Change","No Change",3000,null,"Mandal","JULAPALLI"]
[null,"Present place of Working","MPUPS KACHAPUR",null,null,"GIS in March, 2024",60,null,null,"District","PEDDAPALLI"]
[null,"Mandal","JULAPALLI",null,null,"IF GIS Change","No Change",120,null,"TAN Number","HYDH1234F"]
[null,"District","PEDDAPLLI",null,null,"HM Allowance",0,null,null,"TAX DETAILS"]
[null,"PAN No.","EFGH5678D",null,null,"IF HM Allowance Change","No Change",125,null,"Taxable Income",831930]
[null,"GPF No. / PRAN No",12563,null,null,"CCA",0,null,null,"Tax Payble",82041]
[null,"Policy No.","L 1234567",null,null,"IF CCA Allowance Change","No Change",700,null,"Advance Tax Paid",0]
[null,"Pension type","GPF",null,null,"Special Pay / Higher Class Allow",0,null,null,"Advance Tax Paid by Employee",0]
[null,"Employee Status","Non Gezetted",null,null,"IF Change Special Pay","No Change",0,null,"NET TAX PAYBLE",82041,{"$nulls":5},75000,0,0]
[null,"Type of Residence","Rented House",null,null,"HRA ",11,null,null,"PHA","NO",{"$nulls":5},125000,0,0]
[null,"Name of the House Owner","NAR Reddy",null,null,"IF HRA Change","No Change",11,null,"PHA Percentage","80% Below",{"$nulls":5},0,0,0]
[null,"PAN of the House Owner","ABCG2548F",null,null,"PP",null,null,null,"ADVANCE TAX TABLE",{"$nulls":7},0]
[null,"Adress","1-22-333, Bhagya Nagar, Karimnagar, Telangana",null,null,"FP",null,null,null,"MONTH","AMOUNT"]
[null,"House Rent Paid for Month",20000,null,null,"TS_SP",360,null,null,"Mar, 2024"]
[null,"Enhance Rent upto",15611.583333333334,null,null,"Child Fee Concession",0,null,null,"Apr, 2024"]
[null,"Choose Your Tax Slab","OLD",null,null,"Age as on 31.03.2025","Below 60",null,null,"May, 2024"]
[null,"SALARY DETAILS",{"$nulls":7},"Jun, 2024"]
[null,"Basic Pay in July, 2022",null,null,null,63840,null,null,null,"Jul, 2024"]
[null,"Pay Raised due to","Day","Month & Year",null,"Basic Pay",null,null,null,"Aug, 2024"]
[null,"AGI",1,"Jul, 2023",null,65570,null,null,null,"Sep, 2024"]
[null,"AGI",1,"Jul, 2024",null,67300,null,null,null,"Oct, 2024"]
[null,"No Change",1,"Nov, 2023",null,69150,null,null,null,"Nov, 2024"]
[null,"No Change",1,"Jan, 2024",null,71000,null,null,null,"Dec, 2024"]
[null,"         Surrender Leave Taken (Jul, 22 to Feb, 23)","Not Taken","Nov, 2022",null,"Other Income If any",0,null,null,"Jan, 2025"]
[null,"Surrender Leave Taken (Mar, 23 to Feb, 24)","Not Taken","Nov, 2023",null,"DA 26.390% Arrears Claimed in 2024-25 YF","No",null,null,"Feb, 2025",82041]
[null,"Surrender Leave Taken (Mar, 24 to Feb, 25)","Not Taken","Nov, 2024",{"$nulls":5},"Advance Tax Paid by Employee (Except Salary)"]
[]
[null,"DA & Sup Salary Dertails"]
[null,"Details","Pay","DA",null,"HRA ","IR","Allow",null,"CPS/GPF","NET"]
[null,"Any sup. Bills ",{"$nulls":8},0]
[null,"April, 2021 & May, 2021 PRC Arrears Details",{"$nulls":8},0]
[null,"July, 21 to Dec, 22 CPS 20.020% DA Arrears",0,null,null,0,0,0,null,0,0]
[null,"Jan, 22 to May, 23 CPS 22.750% DA Arrears",0,null,null,0,0,0,null,0,0]
[null,"Jul, 22 to Oct, 24 CPS 26.390% DA Arrears",0,null,null,0,0,0,null,0,0]
[]
[null,"FY 2023-24 Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?",null,"No",null,"F Y 2023-24 Arrears Amount",null,"F Y 2023-24 Taxable Income as per Form 16"]
[null,"FY 2022-23 Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?",null,"No",null,"F Y 2022-23 Arrears Amount",null,"F Y 2022-23 Taxable Income as per Form 16"]
[null,"FY 2021-22 Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?",null,"No",null,"F Y 2021-22 Arrears Amount",null,"F Y 2021-22 Taxable Income as per Form 16"]
[]
[null,"DEDUCTIONS UNDER CHAPTER VI A  (Sections 80 C, 80 CCC and 80 CCD)",null,null,null,"OTHER DEDUCTIONS UNDER CHAPTER VI-A (80D, 80DD, 80 DDB, 80E, 80G, 80L, 80E)",null,null,null,"Housing Loan Detials"]
[null,"LIC Policies Premium (Yearly)",null,null,null,"No Handipcapped Dependent",null,null,null,"Home Loan Taken FY","Between 4/2019 to 3/2022"]
[null,"Tution fee for 2 children",null,null,null,"Medical Insuracne Premium for Senior Citizen Parents U/S 80D",null,null,null,"Name of th Bank"]
[null,"SBI Life Insuracne",null,null,null,"Medical Insuracne Premium for Self, Spouse & Children U/S 80D",null,null,null,"Address / Branch"]
[null,"PLI",null,null,null,"Master Health Check up of U/S 80D (up to Rs. 5000)",null,null,null,"Principle Amount"]
[null,"Invesment in Sukanya Samruddhi",null,null,null,"Interest of Educational Loan 80 E",null,null,null,"Interest Amount"]
[null,"ULIP",null,null,null,"Interest Paid for Electrical Vehicle (EV) U/S 80EEB (Purchased between 01.04.2019 o 31.03.2023)",null,null,null,"1. Stamp Duty less than 45 L 2. Carpet Area should not exceed 90 Sq. M (968 sft) 3. No other house property","YES"]
[null,"Subscription to NSC",null,null,null,"CMRF by self if any"]
[null,"Additional Benefit Under NPS U/S 80CCD(1B)"]
[]
[{"$nulls":7},120000]
[null,null,null,11,null,1,"Mar",null,null,"OLD",19000]
[null,null,null,13,null,2,"Apr",null,null,"NEW",19640]
[null,null,null,17,null,3,"May","Others if any",null,null,20280]
[null,"Rented House",null,24,null,4,"Jun","CMRF by self if any",null,null,20920]
[null,"Own House",null,0,null,5,"Jul",null,null,0,21580]
[null,"CPS",null,50,null,6,"Aug","GPF","-",200,22240]
[null,"GPF",null,75,null,7,"Sep","CPS Deduction",null,220,22900]
[null,0,null,100,null,8,"Oct","-",null,240,23590]
[null,2500,null,null,null,9,"Nov",null,null,260,24280]
[null,5000,null,"YES",null,10,"Dec",null,null,280,24970]
[null,0,null,"NO",null,11,"Jan","No Change",null,300,25690]
[null,100,null,null,null,12,"Feb","AGI",null,330,26410]
[null,200,null,null,null,13,null,"AAS",null,360,27130]
[null,0,null,0,null,14,null,"Promotion",null,390,27880]
[null,15,null,20,null,15,null,null,null,420,28630]
[null,30,null,50,null,16,null,"",null,450,29380]
[null,60,null,null,null,17,null,"",null,490,30210]
[null,120,null,"Non Gezetted",null,18,null,"NO",null,530,31040]
[null,"Not Taken",null,"Gezetted",null,19,null,"Jul, 2022",null,570,31870]
[null,"15 Days",null,null,null,20,null,"Aug, 2022",null,610,32810]
[null,"30 Days",null,null,null,21,null,"Sep, 2022",null,650,33750]
[null,"No Change",null,null,null,22,null,"Oct, 2022",null,700,34690]
[null,"Mar","Jul","Below 60",null,23,null,"Nov, 2022",null,750,35720]
[null,"Apr","Aug","Above 60",null,24,null,"Dec, 2022",null,800,36750]
[null,"May","Sep",null,null,25,null,"Jan, 2023",null,850,37780]
[null,"Jun","Oct",null,null,26,null,"Feb, 2023",null,900,38890]
[null,"Jul","Nov",null,null,27,null,"Mar, 2023",null,970,40000]
[null,"Aug","Dec",null,null,28,null,"Apr, 2023",null,1040,41110]
[null,"Sep","Jan",null,null,29,null,"May, 2023",null,1110,42300]
[null,"Oct","Feb",null,null,30,null,"Jun, 2023",null,1200,43490]
[null,"Nov","Mar",null,null,31,null,"Jul, 2023",null,1300,44680]
[null,"Dec","Apr",{"$nulls":4},"Aug, 2023",null,null,45960]
[null,"Jan","May",null,null,"LIC Policies Premium (Yearly)",null,"Sep, 2023",null,null,47240]
[null,"Feb","Jun",null,null,"Subscription to NSC",null,"Oct, 2023",null,null,48520]
[null,null,"Yes",null,null,"Tution fee for 2 children",null,"Nov, 2023",null,null,49920]
[null,null,"No",null,null,"ULIP",null,"Dec, 2023",null,null,51320]
[{"$nulls":5},"PLI",null,"Jan, 2024",null,null,52720]
[null,"80% Below",75000,null,null,"SBI Life Insuracne",null,"Feb, 2024",null,"No Change",54220]
[null,"NO",0,null,null,"Public Provident Fund",null,"Mar, 2024",null,"Mar, 2024",55720]
[null,"Maintance for Disabled Individual 80% Below Disability  U/S 80U",null,null,null,"Subscriptions made to Equity Shares/Debentures",null,"Apr, 2024",null,"Apr, 2024",57220]
[null,"80% Below",null,null,null,"Invesment in Sukanya Samruddhi",null,"May, 2024",null,"May, 2024",58850]
[null,"80% Above",null,null,null,"Fixed Deposits in Bank More Than (5) years.",null,"Jun, 2024",null,"Jun, 2024",60480]
[{"$nulls":5},"Stamp Duty on Registration",null,"Jul, 2024",null,"Jul, 2024",62110]
[null,"NO",null,null,null,"Medical Treatment of below 80% Handicapped  dependent U/S 80DD",null,"Aug, 2024",null,"Aug, 2024",63840]
[null,"Before FY 2018-19",null,null,null,"Medical Treatment of above 80% Handicapped dependent U/S 80DD",null,"Sep, 2024",null,"Sep, 2024",65570]
[null,"Between 4/2019 to 3/2022",null,null,null,"No Handipcapped Dependent",null,"Oct, 2024",null,"Oct, 2024",67300]
[null,"After FY 2022-23",{"$nulls":5},"Nov, 2024",null,"Nov, 2024",69150]
[{"$nulls":7},"Dec, 2024",null,"Dec, 2024",71000]
[{"$nulls":7},"Jan, 2025",null,"Jan, 2025",72850]
[{"$nulls":7},"Feb, 2025",null,"Feb, 2025",74840]
[{"$nulls":10},76830]
[{"$nulls":10},78820]
[null,"YES",{"$nulls":8},80960]
[null,"NO",{"$nulls":8},83100]
[{"$nulls":10},85240]
[{"$nulls":10},87510]
[{"$nulls":10},89780]
[{"$nulls":10},92050]
[{"$nulls":10},94470]
[{"$nulls":10},96890]
[{"$nulls":10},99310]
[{"$nulls":10},101870]
[{"$nulls":10},104430]
[{"$nulls":10},106990]
[{"$nulls":10},109750]
[{"$nulls":10},112510]
[{"$nulls":10},115270]
[{"$nulls":10},118230]
[{"$nulls":10},121190]
[{"$nulls":10},124150]
[{"$nulls":10},127310]
[{"$nulls":10},130470]
[{"$nulls":10},133630]
[{"$nulls":10},137050]
[{"$nulls":10},140470]
[{"$nulls":10},143890]
[{"$nulls":10},147310]
[{"$nulls":10},151000]
[{"$nulls":10},154690]
[{"$nulls":10},158380]
[{"$nulls":10},162070]

{"sheet":"Pay Calu","index":1,"n_rows":73,"n_cols":72,"rows_kept":73,"cut":false,"hidden":true,"merged":[[0,49,0,63],[0,68,0,71],[0,66,0,67],[0,1,0,18],[0,19,0,33],[0,34,0,48]],"flags":["formulas_cached_only"]}
[null,1,{"$nulls":17},2,{"$nulls":14},3,{"$nulls":14},4,{"$nulls":16},2,null,"HRA"]
[null,"Month & Year","Days","Old","New",null,"AGI",1,null,"Jul, 2023",null,null,63840,{"$nulls":5},"Final","New","AGI",1,null,"Jul, 2024",null,null,63840,null,63840,{"$nulls":4},"Final","New","No Change",1,null,"Nov, 2023",null,null,63840,null,63840,{"$nulls":4},"Final","New","No Change",1,null,"Jan, 2024",null,null,63840,null,63840,{"$nulls":4},"Final","Final Pay","Supp Pay","Month & Year","New  DA",null,null,null,"Final HRA"]
[null,"Jul, 2022",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,31,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,31,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,31,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,31,0,0,63840,63840,0,"Jul, 2022",22.75,11,"No Change",11,11]
[null,"Aug, 2022",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,31,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,31,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,31,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,31,0,0,63840,63840,0,"Aug, 2022",22.75,11,"No Change",11,11]
[null,"Sep, 2022",30,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,30,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,30,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,30,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,30,0,0,63840,63840,0,"Sep, 2022",22.75,11,"No Change",11,11]
[null,"Oct, 2022",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,31,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,31,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,31,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,31,0,0,63840,63840,0,"Oct, 2022",22.75,11,"No Change",11,11]
[null,"Nov, 2022",30,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,30,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,30,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,30,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,30,0,0,63840,63840,0,"Nov, 2022",22.75,11,"No Change",11,11]
[null,"Dec, 2022",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,31,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,31,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,31,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,31,0,0,63840,63840,0,"Dec, 2022",22.75,11,"No Change",11,11]
[null,"Jan, 2023",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,31,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,31,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,31,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,31,0,0,63840,63840,0,"Jan, 2023",22.75,11,"No Change",11,11]
[null,"Feb, 2023",28,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,28,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,28,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,28,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,28,0,0,63840,63840,0,"Feb, 2023",22.75,11,"No Change",11,11]
[null,"Mar, 2023",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,31,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,31,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,31,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,31,0,0,63840,63840,0,"Mar, 2023",22.75,11,"No Change",11,11]
[null,"Apr, 2023",30,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,30,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,30,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,30,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,30,0,0,63840,63840,0,"Apr, 2023",22.75,11,"No Change",11,11]
[null,"May, 2023",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,31,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,31,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,31,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,31,0,0,63840,63840,0,"May, 2023",22.75,11,"No Change",11,11]
[null,"Jun, 2023",30,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",63840,63840,0,30,0,0,63840,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,63840,63840,0,30,0,0,63840,69150,"No Change",1,1,"Nov, 2023","","",63840,63840,63840,0,30,0,0,63840,71000,"No Change",1,1,"Jan, 2024","","",63840,63840,63840,0,30,0,0,63840,63840,0,"Jun, 2023",22.75,11,"No Change",11,11]
[null,"Jul, 2023",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","Jul, 2023",65570,65570,0,31,31,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,31,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,31,0,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,31,0,0,65570,65570,0,"Jul, 2023",22.75,11,"No Change",11,11]
[null,"Aug, 2023",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,31,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,31,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,31,0,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,31,0,0,65570,65570,0,"Aug, 2023",22.75,11,"No Change",11,11]
[null,"Sep, 2023",30,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,30,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,30,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,30,0,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,30,0,0,65570,65570,0,"Sep, 2023",22.75,11,"No Change",11,11]
[null,"Oct, 2023",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,31,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,31,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,31,0,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,31,0,0,65570,65570,0,"Oct, 2023",22.75,11,"No Change",11,11]
[null,"Nov, 2023",30,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,30,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,30,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,30,30,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,30,0,0,65570,65570,0,"Nov, 2023",22.75,11,"No Change",11,11]
[null,"Dec, 2023",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,31,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,31,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,31,0,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,31,0,0,65570,65570,0,"Dec, 2023",22.75,11,"No Change",11,11]
[null,"Jan, 2024",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,31,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,31,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,31,0,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,31,31,0,65570,65570,0,"Jan, 2024",22.75,11,"No Change",11,11]
[null,"Feb, 2024",29,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,29,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,29,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,29,0,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,29,0,0,65570,65570,0,"Feb, 2024",22.75,11,"No Change",11,11]
[null,"Mar, 2024",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,31,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,31,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,31,0,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,31,0,0,65570,65570,0,"Mar, 2024",22.75,11,"No Change",11,11]
[null,"Apr, 2024",30,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,30,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,30,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,30,0,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,30,0,0,65570,65570,0,"Apr, 2024",22.75,11,"No Change",11,11]
[null,"May, 2024",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,31,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,31,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,31,0,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,31,0,0,65570,65570,0,"May, 2024",22.75,11,"No Change",11,11]
[null,"Jun, 2024",30,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,30,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",63840,65570,65570,0,30,0,0,65570,69150,"No Change",1,1,"Nov, 2023","","",63840,65570,65570,0,30,0,0,65570,71000,"No Change",1,1,"Jan, 2024","","",63840,65570,65570,0,30,0,0,65570,65570,0,"Jun, 2024",22.75,11,"No Change",11,11]
[null,"Jul, 2024",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,31,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","Jul, 2024",67300,67300,67300,0,31,31,0,67300,69150,"No Change",1,1,"Nov, 2023","","",63840,67300,67300,0,31,0,0,67300,71000,"No Change",1,1,"Jan, 2024","","",63840,67300,67300,0,31,0,0,67300,67300,0,"Jul, 2024",22.75,11,"No Change",11,11]
[null,"Aug, 2024",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,31,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",67300,67300,67300,0,31,0,0,67300,69150,"No Change",1,1,"Nov, 2023","","",63840,67300,67300,0,31,0,0,67300,71000,"No Change",1,1,"Jan, 2024","","",63840,67300,67300,0,31,0,0,67300,67300,0,"Aug, 2024",22.75,11,"No Change",11,11]
[null,"Sep, 202",30,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,30,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",67300,67300,67300,0,30,0,0,67300,69150,"No Change",1,1,"Nov, 2023","","",63840,67300,67300,0,30,0,0,67300,71000,"No Change",1,1,"Jan, 2024","","",63840,67300,67300,0,30,0,0,67300,67300,0,"Sep, 202",22.75,11,"No Change",11,11]
[null,"Oct, 2024",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,31,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",67300,67300,67300,0,31,0,0,67300,69150,"No Change",1,1,"Nov, 2023","","",63840,67300,67300,0,31,0,0,67300,71000,"No Change",1,1,"Jan, 2024","","",63840,67300,67300,0,31,0,0,67300,67300,0,"Oct, 2024",22.75,11,"No Change",11,11]
[null,"Nov, 2024",30,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,30,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",67300,67300,67300,0,30,0,0,67300,69150,"No Change",1,1,"Nov, 2023","","",63840,67300,67300,0,30,0,0,67300,71000,"No Change",1,1,"Jan, 2024","","",63840,67300,67300,0,30,0,0,67300,67300,0,"Nov, 2024",26.39,11,"No Change",11,11]
[null,"Dec, 2024",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,31,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",67300,67300,67300,0,31,0,0,67300,69150,"No Change",1,1,"Nov, 2023","","",63840,67300,67300,0,31,0,0,67300,71000,"No Change",1,1,"Jan, 2024","","",63840,67300,67300,0,31,0,0,67300,67300,0,"Dec, 2024",26.39,11,"No Change",11,11]
[null,"Jan, 2025",31,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,31,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",67300,67300,67300,0,31,0,0,67300,69150,"No Change",1,1,"Nov, 2023","","",63840,67300,67300,0,31,0,0,67300,71000,"No Change",1,1,"Jan, 2024","","",63840,67300,67300,0,31,0,0,67300,67300,0,"Jan, 2025",26.39,11,"No Change",11,11]
[null,"Feb, 2025",28,63840,65570,null,"AGI",1,1,"Jul, 2023","Jul, 2023","",65570,65570,0,28,0,0,65570,67300,"AGI",1,1,"Jul, 2024","Jul, 2024","",67300,67300,67300,0,28,0,0,67300,69150,"No Change",1,1,"Nov, 2023","","",63840,67300,67300,0,28,0,0,67300,71000,"No Change",1,1,"Jan, 2024","","",63840,67300,67300,0,28,0,0,67300,67300,0,"Feb, 2025",26.39,11,"No Change",11,11]
[]
[null,"Supp Salary"]
[]
[null,"Month","Pay","DA","HRA","IR","GROSS","CPS","NET","DA","HRA"]
[null,"Jul, 2022",0,0,0,0,0,0,0,22.75,11]
[null,"Aug, 2022",0,0,0,0,0,0,0,22.75,11]
[null,"Sep, 2022",0,0,0,0,0,0,0,22.75,11]
[null,"Oct, 2022",0,0,0,0,0,0,0,22.75,11]
[null,"Nov, 2022",0,0,0,0,0,0,0,22.75,11]
[null,"Dec, 2022",0,0,0,0,0,0,0,22.75,11]
[null,"Jan, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"Feb, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"Mar, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"Apr, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"May, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"Jun, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"Jul, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"Aug, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"Sep, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"Oct, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"Nov, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"Dec, 2023",0,0,0,0,0,0,0,22.75,11]
[null,"DA purpose",0,0,0,0,0,0,0]
[null,"Jan, 2024",0,0,0,0,0,0,0,22.75,11]
[null,"Feb, 2024",0,0,0,0,0,0,0,22.75,11]
[null,"Mar, 2024",0,0,0,0,0,0,0,22.75,11]
[null,"Apr, 2024",0,0,0,0,0,0,0,22.75,11]
[null,"May, 2024",0,0,0,0,0,0,0,22.75,11]
[null,"DA purpose",0,0,0,0,0,0,0]
[null,"Jun, 2024",0,0,0,0,0,0,0,22.75,11]
[null,"Jul, 2024",0,0,0,0,0,0,0,22.75,11]
[null,"Aug, 2024",0,0,0,0,0,0,0,22.75,11]
[null,"Sep, 202",0,0,0,0,0,0,0,22.75,11]
[null,"Oct, 2024",0,0,0,0,0,0,0,22.75,11]
[null,"Nov, 2024",0,0,0,0,0,0,0,26.39,11]
[null,"Dec, 2024",0,0,0,0,0,0,0,26.39,11]
[null,"Jan, 2025",0,0,0,0,0,0,0,26.39,11]
[null,"Feb, 2025",0,0,0,0,0,0,0,26.39,11]
[null,"Supp Bill",0,0,0,0,0,0,0]

{"sheet":"Pay","index":2,"n_rows":36,"n_cols":58,"rows_kept":36,"cut":false,"hidden":true,"merged":[[29,0,29,1],[0,54,1,54],[0,55,0,57],[0,28,0,32],[0,33,0,36],[0,37,0,40],[0,41,0,44],[0,45,0,48],[0,49,0,52],[0,0,1,0],[0,2,0,12],[22,1,22,4],[27,0,27,1],[0,53,1,53],[21,1,21,4],[18,1,18,4],[28,0,28,1],[25,0,25,1],[0,13,0,20],[0,21,1,21],[24,1,24,7],[19,1,19,4],[20,1,20,4],[26,0,26,1],[23,0,23,1],[0,1,1,1]],"flags":["formulas_cached_only"]}
["Sl No.","Month","PAY PARTICULARS",{"$nulls":10},"DEDUCTIONS",{"$nulls":7},"NET PAY",{"$nulls":6},"GPF",{"$nulls":4},"TSGLI",null,null,null,"GIS",null,null,null,"HMA",null,null,null,"CCA",null,null,null,"HCA",null,null,null,"PP","FP","PHA"]
[null,null,"Basic Pay","PP/FP/Spl. Pay","TS_SP","HM Allowance","DA","HRA","IR","CCA","PHC",null,"Gross Pay","GPF","APGLI","GIS","ACTUAL PT","PT","Adv. Tax","EWF/ SWF/ GF etc","Total Deduc",null,"CPS","GPF",null,"GPF/CPS","DA","HRA",null,"Change month",10000,10000,10000,"Change month",3000,3000,3000,"Change month",60,120,60,"Change month",0,125,0,"Change month",0,700,0,"Change month",0,0,0,null,null,"NO","NO",2000]
[1,"Mar, 2024",65570,0,360,0,14917,7213,3279,0,0,null,91339,10000,3000,60,200,200,0,20,13480,77859,8049,10000,"GPF",10000,22.75,11,"Mar, 2024","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[2,"Apr, 2024",65570,0,360,0,14917,7213,3279,0,0,null,91339,10000,3000,60,200,200,0,300,13760,77579,8049,10000,"GPF",10000,22.75,11,"Apr, 2024","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[3,"May, 2024",65570,0,360,0,14917,7213,3279,0,0,null,91339,10000,3000,60,200,200,0,0,13460,77879,8049,10000,"GPF",10000,22.75,11,"May, 2024","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[4,"Jun, 2024",65570,0,360,0,14917,7213,3279,0,0,null,91339,10000,3000,60,200,200,0,0,13460,77879,8049,10000,"GPF",10000,22.75,11,"Jun, 2024","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[5,"Jul, 2024",67300,0,360,0,15311,7403,3365,0,0,null,93739,10000,3000,60,200,200,0,0,13460,80279,8261,10000,"GPF",10000,22.75,11,"Jul, 2024","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[6,"Aug, 2024",67300,0,360,0,15311,7403,3365,0,0,null,93739,10000,3000,60,200,200,0,0,13460,80279,8261,10000,"GPF",10000,22.75,11,"Aug, 2024","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[7,"Sep, 2024",67300,0,360,0,15311,7403,3365,0,0,null,93739,10000,3000,60,200,200,0,2243,15703,78036,8261,10000,"GPF",10000,22.75,11,"Sep, 2024","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[8,"Oct, 2024",67300,0,360,0,15311,7403,3365,0,0,null,93739,10000,3000,60,200,200,0,0,13460,80279,8261,10000,"GPF",10000,22.75,11,"Oct, 2024","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[9,"Nov, 2024",67300,0,360,0,17760,7403,3365,0,0,null,96188,10000,3000,60,200,200,0,0,13460,82728,8506,10000,"GPF",10000,26.39,11,"Nov, 2024","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[10,"Dec, 2024",67300,0,360,0,17760,7403,3365,0,0,null,96188,10000,3000,60,200,200,0,100,13560,82628,8506,10000,"GPF",10000,26.39,11,"Dec, 2024","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[11,"Jan, 2025",67300,0,360,0,17760,7403,3365,0,0,null,96188,10000,3000,60,200,200,0,0,13460,82728,8506,10000,"GPF",10000,26.39,11,"Jan, 2025","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[12,"Feb, 2025",67300,0,360,0,17760,7403,3365,0,0,null,96188,10000,3000,60,200,200,0,0,13460,82728,8506,10000,"GPF",10000,26.39,11,"Feb, 2025","No Change",10000,10000,10000,"No Change",3000,3000,3000,"No Change",60,120,60,"No Change",0,125,0,"No Change",0,700,0,"No Change",0,0,0,0,0,"NO","NO",0]
[13,"Sur. Leave",0,0,0,0,0,0,0,0,null,null,0,0,{"$nulls":6},0,0,0,0,"GPF",0]
[14,"Supp. Salary",0,0,0,0,0,0,0,0,null,null,0,0,null,null,0,null,null,null,0,0,0,0,"GPF",0]
[15,"Supp. Salary",0,0,0,0,0,0,0,0,0,null,0,0,{"$nulls":8},0,0,"GPF",0]
[16,"PRC Arrears",0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,null,null,null,0,0,0,0,"GPF",0]
[17,"26.390% DA Arrears (Jul-22 to Oct-24) Adjustment Bill",null,null,null,"No","",0,null,0,null,null,0,"",{"$nulls":8},6632,66316,"GPF",66316]
[19,"July, 21 to Dec, 22 CPS 20.020% DA Arrears",{"$nulls":4},0,0,{"$nulls":4},0,0,{"$nulls":6},0,0,0,0,"GPF",0]
[20,"Jan, 22 to May, 23 CPS 22.750% DA Arrears",{"$nulls":4},0,0,{"$nulls":4},0,0,{"$nulls":6},0,0,0,0,"GPF",0]
[21,"Jul, 22 to Oct, 24 CPS 26.390% DA Arrears",{"$nulls":4},0,0,{"$nulls":4},0,0,{"$nulls":6},0,0,0,0,"GPF",0]
[22,"Child Education Concession",{"$nulls":10},0,0,{"$nulls":6},0,0,0,0,"GPF",0]
["TOTAL",null,800680,0,null,0,88076,191952,null,0,0,null,1125064,120000,36000,720,2400,null,0,2663,161783,963281]
[{"$nulls":19},"Non Gezetted"]
[{"$nulls":5},"Gross","Dedu","Net",null,null,"Rent Paid",{"$nulls":8},"Non Gezetted"]
["April, 2021 & May, 2021 PRC Arrears Details",null,0,0,0,0,0,0,null,null,240000,99263,88076,187339]
["July, 21 to Dec, 22 CPS 20.020% DA Arrears",null,0,0,0,0,0,0,null,null,null,140737,null,15611.583333333334]
["Jan, 22 to May, 23 CPS 22.750% DA Arrears",null,0,0,0,0,0,0,null,null,null,397053]
["Jul, 22 to Oct, 24 CPS 26.390% DA Arrears",null,0,0,0,0,0,0]
[{"$nulls":10},1125064,null,"Rented House"]
[{"$nulls":10},88076]
[{"$nulls":10},140737]
[{"$nulls":10},397053]
[{"$nulls":10},1036988]
[{"$nulls":10},1036988,"0",1036988]

{"sheet":"SL","index":3,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[{"$nulls":9},"Not Taken","No",0,0]
[null,"Month & Year","Pay","DA","HRA","Gross","DA","HRA",null,0,null,"Nov, 2022"]
[null,"Jul, 2022",0,0,0,0,22.75,11,63840,0,0,"Nov, 2022",0]
[null,"Aug, 2022",0,0,0,0,22.75,11,63840,0,0,"Nov, 2022",0]
[null,"Sep, 2022",0,0,0,0,22.75,11,63840,0,0,"Nov, 2022",0]
[null,"Oct, 2022",0,0,0,0,22.75,11,63840,0,0,"Nov, 2022",0]
[null,"Nov, 2022",0,0,0,0,22.75,11,63840,0,0,"Nov, 2022",0]
[null,"Dec, 2022",0,0,0,0,22.75,11,63840,0,0,"Nov, 2022",0]
[null,"Jan, 2023",0,0,0,0,22.75,11,63840,0,0,"Nov, 2022",0]
[null,"Feb, 2023",0,0,0,0,22.75,11,63840,0,0,"Nov, 2022",0]
[null,"Total",0,0,0,0]
[]
[null,"Month & Year","Pay","DA","HRA","Gross","DA","HRA",null,"Not Taken","No",0,0]
[null,"Mar, 2023",0,0,0,0,22.75,11,63840,0,0,"Nov, 2023",0]
[null,"Apr, 2023",0,0,0,0,22.75,11,63840,0,0,"Nov, 2023",0]
[null,"May, 2023",0,0,0,0,22.75,11,63840,0,0,"Nov, 2023",0]
[null,"Jun, 2023",0,0,0,0,22.75,11,63840,0,0,"Nov, 2023",0]
[null,"Jul, 2023",0,0,0,0,22.75,11,65570,0,0,"Nov, 2023",0]
[null,"Aug, 2023",0,0,0,0,22.75,11,65570,0,0,"Nov, 2023",0]
[null,"Sep, 2023",0,0,0,0,22.75,11,65570,0,0,"Nov, 2023",0]
[null,"Oct, 2023",0,0,0,0,22.75,11,65570,0,0,"Nov, 2023",0]
[null,"Nov, 2023",0,0,0,0,22.75,11,65570,0,0,"Nov, 2023",0]
[null,"Dec, 2023",0,0,0,0,22.75,11,65570,0,0,"Nov, 2023",0]
[null,"Jan, 2024",0,0,0,0,22.75,11,65570,0,0,"Nov, 2023",0]
[null,"Feb, 2024",0,0,0,0,22.75,11,65570,0,0,"Nov, 2023",0]
[null,"Total",0,0,0,0]
[]
[null,"Month & Year","Pay","DA","HRA","Gross","DA","HRA",null,"Not Taken","No",0,0]
[null,"Mar, 2024",0,0,0,0,22.75,11,65570,0,0,"Nov, 2024",0]
[null,"Apr, 2024",0,0,0,0,22.75,11,65570,0,0,"Nov, 2024",0]
[null,"May, 2024",0,0,0,0,22.75,11,65570,0,0,"Nov, 2024",0]
[null,"Jun, 2024",0,0,0,0,22.75,11,65570,0,0,"Nov, 2024",0]
[null,"Jul, 2024",0,0,0,0,22.75,11,67300,0,0,"Nov, 2024",0]
[null,"Aug, 2024",0,0,0,0,22.75,11,67300,0,0,"Nov, 2024",0]
[null,"Sep, 2024",0,0,0,0,22.75,11,67300,0,0,"Nov, 2024",0]
[null,"Oct, 2024",0,0,0,0,22.75,11,67300,0,0,"Nov, 2024",0]
[null,"Nov, 2024",0,0,0,0,26.39,11,67300,0,0,"Nov, 2024",0]
[null,"Dec, 2024",0,0,0,0,26.39,11,67300,0,0,"Nov, 2024",0]
[null,"Jan, 2025",0,0,0,0,26.39,11,67300,0,0,"Nov, 2024",0]
[null,"Feb, 2025",0,0,0,0,26.39,11,67300,0,0,"Nov, 2024",0]
[null,"Total",0,0,0,0]

{"sheet":"DA","index":4,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":true,"merged":[[32,1,32,4],[1,1,1,9]],"flags":["formulas_cached_only"]}
[]
[null,"DA"]
[null,"Month & Year","Pay","New DA","Old DA","Difference","CPS","NET","New DA%","Old DA%"]
[null,"Jul, 2022",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"Aug, 2022",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"Sep, 2022",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"Oct, 2022",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"Nov, 2022",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"Dec, 2022",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"Jan, 2023",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"Feb, 2023",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"Mar, 2023",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"Apr, 2023",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"May, 2023",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"Jun, 2023",63840,16847,14524,2323,232,2091,26.39,22.75]
[null,"Jul, 2023",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"Aug, 2023",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"Sep, 2023",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"Oct, 2023",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"Nov, 2023",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"Dec, 2023",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"Jan, 2024",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"Feb, 2024",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"Mar, 2024",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"Apr, 2024",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"May, 2024",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"Jun, 2024",65570,17304,14917,2387,239,2148,26.39,22.75]
[null,"Jul, 2024",67300,17760,15311,2449,245,2204,26.39,22.75]
[null,"Aug, 2024",67300,17760,15311,2449,245,2204,26.39,22.75]
[null,"Sep, 2024",67300,17760,15311,2449,245,2204,26.39,22.75]
[null,"Oct, 2024",67300,17760,15311,2449,245,2204,26.39,22.75]
[null,"Supp",0,0,0,0,0,0,26.39,22.75]
[null,"Total",null,null,null,66316,6632,59684]
[]
[null,"GPF","CPS",null,null,66316]

{"sheet":"PRC 2020","index":5,"n_rows":85,"n_cols":16,"rows_kept":85,"cut":false,"hidden":true,"merged":[[1,4,1,22]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,null,63840,19000,"","","","","","","","","","",""]
[null,null,null,63840,19640,"","","","","","","","","","",""]
[null,null,null,63840,20280,"","","","","","","","","","",""]
[null,null,null,63840,20920,"","","","","","","","","","",""]
[null,null,null,63840,21580,"","","","","","","","","","",""]
[null,null,null,63840,22240,"","","","","","","","","","",""]
[null,null,null,63840,22900,"","","","","","","","","","",""]
["Pay",63840,null,63840,23590,"","","","","","","","","","",""]
["AGI",65570,null,63840,24280,"","","","","","","","","","",""]
["AGI",67300,null,63840,24970,"","","","","","","","","","",""]
["No Change",69150,null,63840,25690,"","","","","","","","","","",""]
["No Change",71000,null,63840,26410,"","","","","","","","","","",""]
[null,null,null,63840,27130,"","","","","","","","","","",""]
[null,null,null,63840,27880,"","","","","","","","","","",""]
[null,null,null,63840,28630,"","","","","","","","","","",""]
[null,null,null,63840,29380,"","","","","","","","","","",""]
[null,null,null,63840,30210,"","","","","","","","","","",""]
[null,null,null,63840,31040,"","","","","","","","","","",""]
[null,null,null,63840,31870,"","","","","","","","","","",""]
[null,null,null,63840,32810,"","","","","","","","","","",""]
[null,null,null,63840,33750,"","","","","","","","","","",""]
[null,null,null,63840,34690,"","","","","","","","","","",""]
[null,null,null,63840,35720,"","","","","","","","","","",""]
[null,null,null,63840,36750,"","","","","","","","","","",""]
[null,null,null,63840,37780,"","","","","","","","","","",""]
[null,null,null,63840,38890,"","","","","","","","","","",""]
[null,null,null,63840,40000,"","","","","","","","","","",""]
[null,null,null,63840,41110,"","","","","","","","","","",""]
[null,null,null,63840,42300,"","","","","","","","","","",""]
[null,null,null,63840,43490,"","","","","","","","","","",""]
[null,null,null,63840,44680,"","","","","","","","","","",""]
[null,null,null,63840,45960,"","","","","","","","","","",""]
[null,null,null,63840,47240,"","","","","","","","","","",""]
[null,null,null,63840,48520,"","","","","","","","","","",""]
[null,null,null,63840,49920,"","","","","","","","","","",""]
[null,null,null,63840,51320,"","","","","","","","","","",""]
[null,null,null,63840,52720,"","","","","","","","","","",""]
[null,null,null,63840,54220,"","","","","","","","","","",""]
[null,null,null,63840,55720,"","","","","","","","","","",""]
[null,null,null,63840,57220,"","","","","","","","","","",""]
[null,null,null,63840,58850,"","","","","","","","","","",""]
[null,null,null,63840,60480,"","","","","","","","","","",""]
[null,null,null,63840,62110,"","","","","","","","","","",""]
[null,null,null,63840,63840,63840,"","","","","","","","","",""]
[null,null,null,63840,65570,65570,65570,"","","","","","","","",""]
[null,null,null,63840,67300,67300,67300,67300,"","","","","","","",""]
[null,null,null,63840,69150,69150,69150,69150,69150,"","","","","","",""]
[null,null,null,63840,71000,71000,71000,71000,71000,71000,"","","","","",""]
[null,null,null,63840,72850,72850,72850,72850,72850,72850,72850,"","","","",""]
[null,null,null,63840,74840,74840,74840,74840,74840,74840,74840,74840,"","","",""]
[null,null,null,63840,76830,76830,76830,76830,76830,76830,76830,76830,76830,"","",""]
[null,null,null,63840,78820,78820,78820,78820,78820,78820,78820,78820,78820,78820,"",""]
[null,null,null,63840,80960,80960,80960,80960,80960,80960,80960,80960,80960,80960,80960,""]
[null,null,null,63840,83100,83100,83100,83100,83100,83100,83100,83100,83100,83100,83100,83100]
[null,null,null,63840,85240,85240,85240,85240,85240,85240,85240,85240,85240,85240,85240,85240]
[null,null,null,63840,87510,87510,87510,87510,87510,87510,87510,87510,87510,87510,87510,87510]
[null,null,null,63840,89780,89780,89780,89780,89780,89780,89780,89780,89780,89780,89780,89780]
[null,null,null,63840,92050,92050,92050,92050,92050,92050,92050,92050,92050,92050,92050,92050]
[null,null,null,63840,94470,94470,94470,94470,94470,94470,94470,94470,94470,94470,94470,94470]
[null,null,null,63840,96890,96890,96890,96890,96890,96890,96890,96890,96890,96890,96890,96890]
[null,null,null,63840,99310,99310,99310,99310,99310,99310,99310,99310,99310,99310,99310,99310]
[null,null,null,63840,101870,101870,101870,101870,101870,101870,101870,101870,101870,101870,101870,101870]
[null,null,null,63840,104430,104430,104430,104430,104430,104430,104430,104430,104430,104430,104430,104430]
[null,null,null,63840,106990,106990,106990,106990,106990,106990,106990,106990,106990,106990,106990,106990]
[null,null,null,63840,109750,109750,109750,109750,109750,109750,109750,109750,109750,109750,109750,109750]
[null,null,null,63840,112510,112510,112510,112510,112510,112510,112510,112510,112510,112510,112510,112510]
[null,null,null,63840,115270,115270,115270,115270,115270,115270,115270,115270,115270,115270,115270,115270]
[null,null,null,63840,118230,118230,118230,118230,118230,118230,118230,118230,118230,118230,118230,118230]
[null,null,null,63840,121190,121190,121190,121190,121190,121190,121190,121190,121190,121190,121190,121190]
[null,null,null,63840,124150,124150,124150,124150,124150,124150,124150,124150,124150,124150,124150,124150]
[null,null,null,63840,127310,127310,127310,127310,127310,127310,127310,127310,127310,127310,127310,127310]
[null,null,null,63840,130470,130470,130470,130470,130470,130470,130470,130470,130470,130470,130470,130470]
[null,null,null,63840,133630,133630,133630,133630,133630,133630,133630,133630,133630,133630,133630,133630]
[null,null,null,63840,137050,137050,137050,137050,137050,137050,137050,137050,137050,137050,137050,137050]
[null,null,null,63840,140470,140470,140470,140470,140470,140470,140470,140470,140470,140470,140470,140470]
[null,null,null,63840,143890,143890,143890,143890,143890,143890,143890,143890,143890,143890,143890,143890]
[null,null,null,63840,147310,147310,147310,147310,147310,147310,147310,147310,147310,147310,147310,147310]
[null,null,null,63840,151000,151000,151000,151000,151000,151000,151000,151000,151000,151000,151000,151000]
[null,null,null,63840,154690,154690,154690,154690,154690,154690,154690,154690,154690,154690,154690,154690]
[null,null,null,63840,158380,158380,158380,158380,158380,158380,158380,158380,158380,158380,158380,158380]
[null,null,null,63840,162070,162070,162070,162070,162070,162070,162070,162070,162070,162070,162070,162070]
[{"$nulls":5},63840,65570,67300,69150,71000,72850,74840,76830,78820,80960,83100]

{"sheet":"IT Cal","index":6,"n_rows":12,"n_cols":19,"rows_kept":12,"cut":false,"hidden":true,"merged":[[1,13,1,18],[2,13,2,15],[11,13,11,16],[2,10,2,11],[11,8,11,9],[11,10,11,11],[1,7,1,11],[2,7,2,9],[1,1,1,5],[2,1,2,3],[2,4,2,5],[11,2,11,3],[11,4,11,5]],"flags":["formulas_cached_only"]}
[]
[null,"Old Slab Below 60",{"$nulls":5},"Old Slab above 60",{"$nulls":5},"New Slab"]
[null,"Taxable Income",null,null,831930,null,null,"Taxable Income",null,null,831930,null,null,"Taxable Income",null,null,null,831930]
[null,null,831930,{"$nulls":5},831930,{"$nulls":4},"Slab Rate","Slab Amount","Slab Income","Slab Rate of %","Tax"]
[null,250000,250000,250000,250000,0,null,300000,300000,300000,300000,0,null,300000,300000,300000,0,0,300000]
[null,581930,581930,500000,250000,12500,null,531930,531930,500000,200000,10000,null,700000,400000,400000,5,20000,531930]
[null,331930,331930,100000,331930,66386,null,331930,331930,100000,331930,66386,null,1000000,300000,131930,10,13193,131930]
[null,0,0,null,0,0,null,0,0,null,0,0,null,1200000,200000,0,15,0,0]
[{"$nulls":13},1500000,300000,0,20,0,0]
[null,null,0,{"$nulls":5},0,{"$nulls":4},"15,00,000+",0,0,30,0,0]
[null,null,0,0,null,78886,null,null,0,0,null,76386,null,25000,25000,0]
[null,null,"Total Tax",null,78886,null,null,null,"Total Tax",null,76386,null,null,"Total Tax",null,null,null,33193]

{"sheet":"Anne","index":7,"n_rows":65,"n_cols":28,"rows_kept":65,"cut":false,"hidden":false,"merged":[[47,14,47,17],[47,23,47,24],[47,18,47,19],[53,1,53,6],[31,1,31,6],[26,1,26,6],[38,1,38,6],[45,1,45,6],[34,1,34,6],[46,1,46,6],[64,0,64,6],[54,1,54,6],[48,1,48,6],[49,1,49,6],[50,1,50,6],[56,1,56,6],[64,8,64,9],[36,1,36,6],[41,1,41,6],[40,1,40,6],[62,1,62,8],[44,1,44,6],[42,1,42,6],[57,1,57,6],[60,1,60,6],[59,1,59,6],[43,1,43,6],[61,1,61,6],[58,1,58,6],[55,1,55,6],[52,1,52,6],[24,1,24,6],[30,1,30,6],[33,1,33,6],[51,1,51,6],[39,1,39,6],[47,1,47,6],[11,1,11,6],[35,1,35,6],[14,1,14,6],[18,1,18,6],[25,1,25,6],[21,1,21,6],[22,1,22,6],[19,1,19,6],[27,1,27,6],[10,0,13,0],[3,1,3,3],[9,1,9,6],[2,3,2,9],[23,1,23,6],[32,1,32,6],[29,1,29,6],[15,1,15,6],[13,1,13,6],[10,1,10,6],[0,0,0,9],[5,0,8,0],[6,1,6,6],[1,0,2,0],[1,1,2,2],[5,1,5,6],[3,7,3,8],[3,4,3,6],[1,3,1,9],[37,1,37,6],[4,1,4,6],[12,1,12,6],[17,1,17,6],[20,1,20,6],[7,1,7,6],[8,1,8,6],[16,1,16,6],[28,1,28,6]],"flags":["formulas_cached_only"]}
["INCOME TAX CALUCULATION FOR THE FINANCIAL YEAR 2024-25 as per  OLD Regime"]
[null,"Name of the Employee\n & Address",null,"N RAJENDER REDDY,   EMP ID No. 1234567"]
[null,null,null,"SGT, MPUPS KACHAPUR, Mdl JULAPALLI",{"$nulls":7},"OLD"]
[1,"PAN Number of the employee",null,null,"EFGH5678D",null,null,"Living In",null,"Rented House"]
[2,"Gross Pay & Allowances as indicated in the Statement Enclosed",{"$nulls":7},1125064]
[3,"Deductions towards HRA U/s.  10(13-A) (least of the following exempted)"]
[null,"a) Actual HRA Received",{"$nulls":5},"Rs. ",88076,null,null,88076]
[null,"b) Actual Rent Paid - {10% of (BP+DA)}        (Rs.  20000 X 12)",{"$nulls":5},"Rs. ",140737,null,null,140737]
[null,"c) 40% of Salary (Basic Pay + D.A)",{"$nulls":5},"Rs. ",397053,88076,null,397053,88076,88076]
[4,"TOTAL SALARY  (2-3)",{"$nulls":7},1036988]
[5,"DEDUCTIONS FROM SALARY INCOME"]
[null,"Exemption from conveyance allowance u/s.10(14)(i)",{"$nulls":5},"Rs. ",0,null,null,0]
[null,"Standard Deduction U/S 16 (ia)",{"$nulls":5},"Rs. ",50000,null,null,50000,75000]
[null,"Professional Tax  U/S 16(3) B",{"$nulls":5},"Rs. ",2400,52400,null,2400,{"$nulls":12},"GPF Deductions      (A/c No. 12563)"]
[6,"INCOME FROM SALARY (4-5)",{"$nulls":7},984588,{"$nulls":14},"CPS Employee Contribution Amount. PRAN 12563"]
[7,"Income from Capital Gains",{"$nulls":5},"Rs. ",0]
[8,"Other Sources of income if any (Agriculture, Business, Chits, etc,.)",{"$nulls":5},"Rs. ",0,{"$nulls":15},"GPF"]
[9,"Employer Contribution towards NPS Account ( GOVT Contribution )",{"$nulls":5},"Rs. ",0,{"$nulls":5},120000,0]
[10,"Income from House Property (U/s.24(vi))",{"$nulls":5},"Rs. ",0,0]
[11,"GROSS TOTAL INCOME (6+7+8+9+10)",{"$nulls":5},"Rs. ",null,984588]
[12,"DEDUCTIONS UNDER CHAPTER VI A  (Sections 80 C, 80 CCC and 80 CCD)",{"$nulls":12},0]
[null,"GPF Deductions      (A/c No. 12563)",{"$nulls":5},"Rs. ",120000,null,null,120000,null,null,0,0,120000]
[null,"TSGLI Deductions (Policy No. L 1234567 )",{"$nulls":5},"Rs. ",36000,null,null,36000,null,null,"GPF",0]
[null,"Group Insurance",{"$nulls":5},"Rs. ",720,null,null,720]
[null,"LIC Policies Premium (Yearly)",{"$nulls":5},"Rs. ","",null,null,""]
[null,"Tution fee for 2 children",{"$nulls":5},"Rs. ","",null,null,""]
[null,"SBI Life Insuracne",{"$nulls":5},"Rs. ","",null,null,""]
[null,"PLI",{"$nulls":5},"Rs. ","",null,null,""]
[null,"Invesment in Sukanya Samruddhi",{"$nulls":5},"Rs. ","",null,null,""]
[null,"Repayment of Housing Loan Principle",{"$nulls":5},"Rs. ",0,0,null,0,"Between 4/2019 to 3/2022"]
[13,"TOTAL QUALIFYING AMOUNT (UP TO Rs.1,50,000/-) UNDER CHAPTER VI A  (Sections 80 C, 80 CCC and 80 CCD)",{"$nulls":5},"Rs. ",156720,150000,null,156720,150000,null,156720]
[null,"Additional Benefit Under NPS U/S 80CCD(1B) ",{"$nulls":5},"Rs. ",null,0,null,0,0,0,0]
[14,"TOTAL INCOME (12-13)",{"$nulls":7},834588]
[15,"OTHER DEDUCTIONS UNDER CHAPTER VI-A (e.g., 80D, 80DD, 80 DDB, 80E, 80G, 80L, 80E)"]
[null,"Maintance for Disabled Individual 80% Below Disability  U/S 80U",{"$nulls":5},"Rs. ",0,null,null,0]
[null,"No Handipcapped Dependent",{"$nulls":5},"Rs. ",0,null,null,0]
[null,"Medical Insuracne Premium for Senior Citizen Parents U/S 80D",{"$nulls":5},"Rs. ",0,null,null,0,0]
[null,"Medical Insuracne Premium for Self, Spouse & Children U/S 80D",{"$nulls":5},"Rs. ",0,null,null,0,0]
[null,"Master Health Check up of U/S 80D (up to Rs. 5000)",{"$nulls":5},"Rs. ",0,null,null,0,0]
[null,"Employer Contribution towards NPS Account ( GOVT Contribution ) U/S 80 CCD(2)",{"$nulls":5},"Rs. ",0,null,null,0,"GPF"]
[null,"Interest of Educational Loan 80 E",{"$nulls":5},"Rs. ",0,null,null,0]
[null,"Interest of House Building U/S 24(B)",{"$nulls":5},"Rs. ",0,null,null,0,0,0,0,"Between 4/2019 to 3/2022"]
[null,"Interest of House Building U/S 80EEA",{"$nulls":5},"Rs. ",0,null,null,0,0,"YES",0,0]
[null,"Interest Paid for Electrical Vehicle (EV) U/S 80EEB (Purchased between 01.04.2019 o 31.03.2023)",{"$nulls":5},"Rs. ",0,null,null,0]
[null,"EWF, SWF & CMRF",{"$nulls":5},"Rs. ",2663,null,null,2663]
[null,"Total",{"$nulls":5},"Rs. ",2663,2663,null,2663,1331.5]
[16,"TAXABLE INCOME (14-15)         (Round off to nearest multiple of Rs.10)",{"$nulls":7},831930,{"$nulls":4},831925,83193,831930]
[17,"AMOUNT OF TAX (as per rates given below)",{"$nulls":12},"Old Slab Below 60",null,null,null,"Old Slab above 60",{"$nulls":4},"New Slab"]
[null,"i) Up to 2,50,000/-    (@ 0% )",{"$nulls":7},0,null,0,0,0,"i) Up to 2,50,000/-    (@ 0% )",null,null,null,"i) Up to 3,00,000/-    (@ 0% )",{"$nulls":4},"i) Up to 3,00,000/-    (@ 0% )",null,"Below 60",0,"i) Up to 2,50,000/-    (@ 0% )"]
[null,"ii) Rs.2,50,001 to 5,00,000       (@ 5% )",{"$nulls":6},0,12500,null,12500,10000,20000,"ii) Rs.2,50,001 to 5,00,000       (@ 5% )",null,null,null,"ii) Rs.3,00,001 to 5,00,000       (@ 5% )",{"$nulls":4},"ii) Rs.3,000,001 to 7,00,000       (@ 5% )",null,"Below 60",12500,"ii) Rs.2,50,001 to 5,00,000       (@ 5% )"]
[null,"iii) Rs.5,00,001 to 10,00,000    ( @ 20% )",{"$nulls":7},66386,null,66386,66386,13193,"iii) Rs.5,00,001 to 10,00,000    ( @ 20% )",null,null,null,"iii) Rs.5,00,001 to 10,00,000    ( @ 20% )",{"$nulls":4},"iii) Rs.7,00,001 to 10,00,000    ( @ 10% )",null,"Below 60",66386,"iii) Rs.5,00,001 to 10,00,000    ( @ 20% )"]
[null,"iv) above Rs.10,00,000           ( @ 30% )",{"$nulls":6},0,0,null,0,0,0,"iv) above Rs.10,00,000           ( @ 30% )",null,null,null,"iv) above Rs.10,00,000           ( @ 30% )",{"$nulls":4},"iv) Rs.10,00,001 to 12,00,000    ( @ 15% )",null,"Below 60",0,"iv) above Rs.10,00,000           ( @ 30% )"]
[null,"-",{"$nulls":7},0,null,0,0,0,"-",null,null,null,"-",{"$nulls":4},"v) Rs.12,00,001 to 15,00,000    ( @ 20% )",null,"Below 60",0,"-"]
[null,"-",{"$nulls":7},0,null,0,0,0,"-",null,null,null,"-",{"$nulls":4},"vi) above Rs.15,00,000           ( @ 30% )",null,"Below 60",0,"-"]
[null,"-",{"$nulls":6},0,0,null,0,0,0,"-",null,null,null,"-",{"$nulls":6},"Below 60",0]
[null,"TAX ON TOTAL INCOME",{"$nulls":5},"Rs. ",null,78886,null,78886,76386,33193,{"$nulls":11},"Below 60",78886]
[18,"TAX Rebate U/S 87A ( Rs. 12,500/- Rebate upto Rs. 5,000,000/- Taxable Income)",{"$nulls":5},"Rs. ",null,0,null,0,0,0,"TAX Rebate U/S 87A ( Rs. 12,500/- Rebate upto Rs. 5,000,000/- Taxable Income)","TAX Rebate U/S 87A ( Rs. 20,000/- Rebate upto Rs. 7,000,000/- Taxable Income)",{"$nulls":9},"Below 60",0]
[19,"Health & Education Cess @ 4% ",{"$nulls":5},"Rs. ",null,3155,null,78886,76386,33193,{"$nulls":11},"Below 60",78886]
[20,"Relief Under Section 89(1)",{"$nulls":5},"Rs. ",null,0,null,3155,3055,1328,{"$nulls":11},"Below 60",3155]
[21,"Total Tax Payble (17-18+19-20)",{"$nulls":5},"Rs. ",null,82041,null,3155]
[22,"Advance Tax Deductons",{"$nulls":5},"Rs. ",null,0]
[23,"NET TAX PAYABLE (21-22)  Now",{"$nulls":5},"Rs. ",null,82041,null,82041,"NO TAX"]
[null,"TAX PAYABLE : (Eighty two Thousand and Forty one rupees only)",{"$nulls":9},82041]
[]
["Signature of the  Drawing & Disbursing Officer",{"$nulls":7},"Signature of the Employee"]

{"sheet":"Table","index":8,"n_rows":27,"n_cols":20,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,19],[1,12,1,18],[24,0,24,1],[1,0,2,0],[1,2,1,11],[19,1,19,4],[22,1,22,4],[26,1,26,8],[1,19,2,19],[26,16,26,19],[20,1,20,4],[21,1,21,4],[1,1,2,1],[23,1,23,10]],"flags":["formulas_cached_only"]}
["STATEMENT SHOWING THE SALARY PARTICULARS OF SRI/SMT. N RAJENDER REDDY (EMP ID: 1234567), SGT, MPUPS KACHAPUR, Mdl JULAPALLI"]
["Sl. No.","Month & Year","PAY PARTICULARS",{"$nulls":9},"DEDUCTIONS",{"$nulls":6},"NET PAY"]
[null,null,"Basic Pay","PP/FP/Spl. Pay","TS_SP","DA","HRA","IR","HMA / HCA","CCA","PHC","Gross Pay","GPF","TSGLI","GIS","PT","Adv. Tax","SWF / EWF / GF","Total Dedu."]
[1,"Mar, 2024",65570,0,360,14917,7213,3279,0,0,0,91339,10000,3000,60,200,0,20,13280,78059]
[2,"Apr, 2024",65570,0,360,14917,7213,3279,0,0,0,91339,10000,3000,60,200,0,300,13560,77779]
[3,"May, 2024",65570,0,360,14917,7213,3279,0,0,0,91339,10000,3000,60,200,0,0,13260,78079]
[4,"Jun, 2024",65570,0,360,14917,7213,3279,0,0,0,91339,10000,3000,60,200,0,0,13260,78079]
[5,"Jul, 2024",67300,0,360,15311,7403,3365,0,0,0,93739,10000,3000,60,200,0,0,13260,80479]
[6,"Aug, 2024",67300,0,360,15311,7403,3365,0,0,0,93739,10000,3000,60,200,0,0,13260,80479]
[7,"Sep, 2024",67300,0,360,15311,7403,3365,0,0,0,93739,10000,3000,60,200,0,2243,15503,78236]
[8,"Oct, 2024",67300,0,360,15311,7403,3365,0,0,0,93739,10000,3000,60,200,0,0,13260,80479]
[9,"Nov, 2024",67300,0,360,17760,7403,3365,0,0,0,96188,10000,3000,60,200,0,0,13260,82928]
[10,"Dec, 2024",67300,0,360,17760,7403,3365,0,0,0,96188,10000,3000,60,200,0,100,13360,82828]
[11,"Jan, 2025",67300,0,360,17760,7403,3365,0,0,0,96188,10000,3000,60,200,0,0,13260,82928]
[12,"Feb, 2025",67300,0,360,17760,7403,3365,0,0,0,96188,10000,3000,60,200,0,0,13260,82928]
[13,"Sur. Leave",0,0,0,0,0,0,0,0,0,0,0,{"$nulls":5},0,0]
[14,"Supp. Salary",0,0,0,0,0,0,0,0,0,0,0,{"$nulls":5},0,0]
[15,"Supp. Salary",0,0,0,0,0,0,0,0,0,0,0,{"$nulls":5},0,0]
[16,"PRC Arrears",0,0,0,0,0,0,0,0,0,0,0,{"$nulls":5},0,0]
[17,"26.390% DA Arrears (Jul-22 to Oct-24) Adjustment Bill",null,null,null,"",{"$nulls":5},0,"",{"$nulls":5},0,0]
[18,"July, 21 to Dec, 22 CPS 20.020% DA Arrears",null,null,null,0,{"$nulls":5},0,0,{"$nulls":5},0,0]
[19,"Jan, 22 to May, 23 CPS 22.750% DA Arrears",null,null,null,0,{"$nulls":5},0,0,{"$nulls":5},0,0]
[20,"Jul, 22 to Oct, 24 CPS 26.390% DA Arrears",null,null,null,0,{"$nulls":5},0,0,{"$nulls":5},0,0]
[21,"Child Education Concession",{"$nulls":9},0,{"$nulls":6},0,0]
["TOTAL",null,800680,0,4320,191952,88076,40036,0,0,0,1125064,120000,36000,720,2400,0,2663,161783,963281]
[]
[null,"Signature of the D.D.O",{"$nulls":14},"Signature of the Employee"]

{"sheet":"12BB","index":9,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":false,"merged":[[57,6,57,9],[58,6,58,9],[52,0,52,9],[55,0,55,4],[58,4,58,5],[58,2,58,3],[55,7,55,9],[53,0,54,9],[43,8,43,9],[44,8,44,9],[51,8,51,9],[56,1,56,3],[56,6,56,9],[40,2,40,3],[40,5,40,6],[40,8,40,9],[41,1,41,7],[41,8,41,9],[42,8,42,9],[35,8,35,9],[36,2,36,6],[36,8,36,9],[37,8,37,9],[38,8,38,9],[39,8,39,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[26,1,26,6],[26,8,26,9],[27,1,27,6],[27,8,27,9],[28,3,28,6],[28,8,28,9],[18,1,18,6],[18,8,18,9],[19,2,19,6],[19,7,25,7],[19,8,25,9],[20,2,20,3],[20,4,20,6],[21,2,21,3],[23,2,23,6],[24,2,24,6],[16,1,16,2],[16,3,16,9],[10,7,15,7],[12,2,12,6],[13,2,14,3],[17,1,17,6],[17,8,17,9],[13,4,14,6],[11,5,11,6],[9,1,9,6],[9,8,9,9],[10,1,10,6],[10,8,15,9],[11,2,11,4],[8,12,8,13],[14,12,18,12],[13,1,14,1],[10,12,10,14],[15,5,15,6],[7,0,7,9],[8,1,8,6],[5,7,5,9],[0,0,0,9],[2,0,2,9],[3,0,3,9],[4,5,4,9],[6,0,6,9],[8,8,8,9],[21,4,21,6],[50,2,50,6],[48,2,48,6],[45,8,45,9],[46,8,46,9],[47,8,47,9],[48,8,48,9],[49,8,49,9],[50,8,50,9],[25,2,25,6]],"flags":["formulas_cached_only"]}
["INCOME-TAX RULES, 1962"]
[]
["FORM NO.12BB"]
["(See rule 26C)"]
["1. Name and address of the employee: ",{"$nulls":4},"N RAJENDER REDDY, SGT, MPUPS KACHAPUR, Mdl: JULAPALLI"]
["2. Permanent Account Number of the employee : ",{"$nulls":6},"EFGH5678D"]
["3. Financial year :    2024-25"]
["Details of claims and evidence thereof"]
["Sl No.","Nature of claim",{"$nulls":5},"Amount (Rs.)","Evidence / particulars",null,null,null,"20000X12",null,"Rented House"]
["(1)","(2)",{"$nulls":5},"(3)","(4)",null,null,null,{"$error":"#REF!"}]
[1,"House Rent Allowance:",{"$nulls":5},240000,"Receipt Produced",null,null,null,"NAR Reddy, ABCG2548F"]
[null,"(i) ","Rent paid to the landlord",null,null,"20000X12",{"$nulls":6},"1-22-333, Bhagya Nagar, Karimnagar, Telangana"]
[null,"(ii) ","Name of the landlord : NAR Reddy",{"$nulls":9},"Receipt Produced"]
[null,"(iii)","Address of the landlord:",null,"1-22-333, Bhagya Nagar, Karimnagar, Telangana",{"$nulls":9},"GPF"]
[{"$nulls":12},240000,null,120000]
[null,"(iv) ","PAN of the landlord :",null,null,"ABCG2548F"]
[null,"Note :",null,"Permanent Account Number shall be furnished if the aggregate rent paid during the previous year exceeds one lakh rupees"]
[2,"Leave travel concessions or assistance"]
[3,"Deduction of interest on borrowing:"]
[null,"(i)","Interest payable/paid to the lender",{"$nulls":4},0,"Certificate Produced"]
[null,"(ii) ","Name of the Lender :",null,0]
[null,"(iii)","Address of the lender :  ",null,0]
[null,"(iv) ","Permanent Account Number of the lender : "]
[null,"a)","Financial Institutions(if available)  "]
[null,"b)","Employer(if available)"]
[null,"c) ","Others"]
[4,"Deduction under Chapter VI-A"]
[null,"(A) Section 80C,80CCC and 80CCD"]
[null,"(i)","a)","TSGLI No. L 1234567",null,null,null,36000,"Salary Deduction"]
[null,null,"b)","GIS",null,null,null,720,"Salary Deduction"]
[null,null,"c)","LIC Policies Premium (Yearly)",null,null,null,"",""]
[null,null,"d)","Tution fee for 2 children",null,null,null,"",""]
[null,null,"e)","SBI Life Insuracne",null,null,null,"",""]
[null,null,"f)","PLI",null,null,null,"",""]
[null,null,"g)","Invesment in Sukanya Samruddhi",null,null,null,"",""]
[null,null,"h)","Repayment of Housing Loan Principle",null,null,null,0,"Reciept Produced"]
[null,"(ii) ","Section 80CCC",{"$nulls":4},0,"-"]
[null,null,"a)","Public Provident Fund",null,null,null,0,"-"]
[null,null,"b)","LIC Premium Deducted in Salary Savings Scheme",null,null,null,0,"-"]
[null,null,"c)","GPF Deductions      (A/c No. 12563)",null,null,null,120000,"Salary Deduction"]
[null,"(iii)","Section 80CCD",null,"PRAN NO:",12563,null,0,"-"]
[null,"(B) Other sections (e.g. 80E, 80G, 80TTA, etc.) under Chapter VI-A."]
[null,1,"Interest on Housing Loan Advance U/s 24[B]",{"$nulls":4},0,"-"]
[null,2,"Maintance for Disabled Individual 80% Below Disability  U/S 80U",{"$nulls":4},0,"-"]
[null,3,"No Handipcapped Dependent",{"$nulls":4},0,"-"]
[null,4,"Medical Insuracne Premium for Senior Citizen Parents U/S 80D",{"$nulls":4},0,"-"]
[null,5,"Medical Insuracne Premium for Self, Spouse & Children U/S 80D",{"$nulls":4},0,"-"]
[null,6,"Master Health Check up of U/S 80D (up to Rs. 5000)",{"$nulls":4},0,"-"]
[null,7,"Employer Contribution towards NPS Account ( GOVT Contribution ) U/S 80 CCD(2)",{"$nulls":4},0,"-"]
[null,8,"Interest of Educational Loan 80 E",{"$nulls":4},0,"-"]
[null,9,"Interest Paid for Electrical Vehicle (EV) U/S 80EEB (Purchased between 01.04.2019 o 31.03.2023)",{"$nulls":4},0,"-"]
[null,10,"EWF, SWF & CMRF",{"$nulls":4},2663,"Salary Deduction"]
["Verification"]
["I,  N RAJENDER REDDY  son/ daughter of  RAJI REDDY  do hereby certify that the information given above is complete and correct."]
[]
["Place"]
["Date"]
[{"$nulls":6},"(Signature of the employee)"]
["Designation :",null,"SGT",null,"Full Name :",null,"N RAJENDER REDDY"]

{"sheet":"Form 16(F)","index":10,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":false,"merged":[[34,4,34,5],[44,1,44,3],[34,6,34,7],[4,0,4,2],[4,4,4,5],[11,0,11,9],[34,8,34,9],[4,6,4,9],[6,4,6,7],[10,0,10,2],[5,0,5,9],[7,6,7,7],[0,0,0,9],[1,0,1,9],[2,0,2,3],[2,4,2,9],[3,0,3,3],[3,4,3,9],[6,8,7,9],[8,8,10,9],[8,4,10,5],[8,6,10,7],[12,6,15,7],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[7,4,7,5]],"flags":["formulas_cached_only"]}
["FORM NO. 16\n[See Rule 31(1)(a)]"]
["Certificate under Section 203 of the Income Tax Act, 1961 for Tax Deduction at source\n from Income chargeable under the head of \"Salaries\""]
["Name &  Address of the Employer:",null,null,null,"Name & Designation of the Employee:"]
["ABCDEFXYZ, HEADMASTER, ZPHS XYZ, Mdl: JULAPALLI",null,null,null,"N RAJENDER REDDY, SGT, MPUPS KACHAPUR, Mdl: JULAPALLI"]
["TAN No.",null,null,"HYDH1234F","PAN No.",null,"EFGH5678D"]
["Acknowledgement Nos. of all quarterly statements of TDS under sub-section (3) of section 200 as provided by TIN Facilitation Center or NSDL web-site"]
["Quarter",null,null,"Acknowledgment No.","Period",null,null,null,"Assessment Year :"]
[1,null,null,null,"From",null,"To"]
[2,null,null,null,"April, 2024",null,"March, 2025",null,"2025-26"]
[3]
[4]
["DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
["1.","GROSS SALARY"]
[null,null,"a)","Salary as per provisions contained in Section 17(1)","Rs.",1125064]
[null,null,"b)","Value of Perquisities under Section 17(2) (as per Form No. 12BA, wherever applicable)","Rs.",0]
[null,null,"c)","Profits in lieu of salary under Section 17(3) (as per From No. 12 BA. Whereever applicable)","Rs.",0]
[null,null,"d)","Total   ",{"$nulls":4},"Rs.",1125064]
["2.",null,"LESS: Allowance to the extent exempt under Section 10"]
[null,null,"a)","House Rent allowence","Rs.",88076]
[null,null,"b)","Other Allowance","Rs.",0]
[{"$nulls":4},"",null,null,null,"Rs.",88076]
["3.","BALANCE (1-2)",{"$nulls":6},"Rs.",1036988]
["4.","DEDUCTIONS UNDER SECTION 16:"]
[null,null,"a)","Entertainment Allowance","Rs.",0,"Rs.",0]
[null,null,"b)","Standard Deduction U/S 16 (ia)","Rs.",50000,"Rs.",50000]
[null,null,"c)","Tax on Employment U/S 16(3) B","Rs.",2400,"Rs.",2400]
["5.","AGGREGATE OF 4(a) to (c)",{"$nulls":4},"",null,"Rs.",52400]
["6.","INCOME CHARGEABLE UNDER THE HEAD 'SALARIES' (3-5)",{"$nulls":6},"Rs.",984588]
["7.","ADD ANY OTHER INCOME REPORTED BY THE EMPLOYEE"]
[null,null,"a)","Income from Capital Gains","Rs.",0]
[null,null,"b)","Other Sources of income if any (Agriculture, Business, Chits, etc,.)","Rs.",0]
[null,null,"c)","Employer Contribution towards NPS Account ( GOVT Contribution )","Rs.",0]
[null,null,"d)","Income from House Property (U/s.24(vi))","Rs.",0]
["8.","GROSS TOTAL INCOME (6+7)",{"$nulls":6},"Rs.",984588]
["9.","A.   DEDUCTIONS UNDER CHAPER VI A (80C, 80CCC, 80CCD)",null,null,"GROSS AMOUNT",null,"QUALIFYING AMOUNT",null,"DEDUCTIBLE AMOUNT"]
[null,null,"a","GPF Deductions      (A/c No. 12563)","Rs.",120000,"Rs.",120000,"Rs.",120000]
[null,null,"b","TSGLI Deductions (Policy No. L 1234567 )","Rs.",36000,"Rs.",36000,"Rs.",36000]
[null,null,"c","Group Insurance","Rs.",720,"Rs.",720,"Rs.",720]
[null,null,"d","LIC Policies Premium (Yearly)","","","","","",""]
[null,null,"e","Tution fee for 2 children","","","","","",""]
[null,null,"f","SBI Life Insuracne","","","","","",""]
[null,null,"g","PLI","","","","","",""]
[null,null,"h","Invesment in Sukanya Samruddhi","","","","","",""]
[null,null,"i","Repayment of Housing Loan Principle","Rs.",0,"Rs.",0,"Rs.",0]
[null,"TOTAL QUALIFYING AMOUNT (UP TO Rs.1,50,000/-) UNDER CHAPTER VI A  (Sections 80 C, 80 CCC and 80 CCD)",null,null,"Rs.",156720,"Rs.",156720,"Rs.",150000]
[null,null,"b","Additional Benefit Under NPS U/S 80CCD(1B) ","Rs.",0,"Rs.",0,"Rs.",0]
[null,"AGGREGATE OF DEDUCTIBLE AMOUNT UNDER CHAPTER VI A (80C, 80CCC, 80CCD)",{"$nulls":6},"Rs.",150000]
[null,"Note:",null,"1. Aggregate amount deductible under section 80C shall not exceed one lakh fifty thousand rupees"]
[null,null,null,"2. Aggregate amount deductible under section 80C, 80CCC, 80CCD(1) shall not exceed 1.5 lakh rupees."]

{"sheet":"w","index":11,"n_rows":34,"n_cols":111,"rows_kept":34,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[{"$nulls":8},1,2,3,4,5,6,7,{"$nulls":4},8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99]
[{"$nulls":8},"One","Two","Three","Four","Five","Six","Seven",{"$nulls":4},"Eight","Nine","Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen","Twenty","Twenty one","Twenty two","Twenty three","Twenty four","Twenty five","Twenty six","Twenty seven","Twenty eight","Twenty nine","Thirty ","Thirty one","Thirty two","Thirty three","Thirty four","Thirty five","Thirty six","Thirty seven","Thirty eight","Thirty nine","Forty ","Forty one","Forty two","Forty three","Forty four","Forty five","Forty six","Forty seven","Forty eight","Forty nine","Fifty","Fifty one","Fifty two","Fifty three","Fifty four","Fifty five","Fifty six","Fifty seven","Fifty eight","Fifty nine","sixty","Sixty one","Sixty two","Sixty three","Sixty four","Sixty five","Sixty six","Sixty seven","Sixty eight","Sixty nine","Seventy","Seventy one","Seventy two","Seventy three","Seventy four","Seventy five","Seventy six","Seventy seven","Seventy eight","Seventy nine","Eighty ","Eighty one","Eighty two","Eighty three","Eighty four","Eighty five","Eighty six","Eighty seven","Eighty eight","Eighty nine","Ninety","Ninety one","Ninety two","Ninety three","Ninety four","Ninety five","Ninety six","Ninety seven","Ninety eight","Ninety nine"]
[]
[]
[]
[]
[]
[]
["Number","Rupees in Words Conversion"]
[82041,"(Eighty two Thousand and Forty one rupees only)",0,0,82,0,41,"","","Eighty two","","Forty one",2,4,6,"",""," Thousand ","","Eighty two Thousand and Forty one"]
[82041,"(Eighty two Thousand and Forty one rupees only)",0,0,82,0,41,"","","Eighty two","","Forty one",2,4,6,"",""," Thousand ","","Eighty two Thousand and Forty one"]
[240000,"(Two Lakhs Forty Thousand rupees only)",0,2,40,0,0,"","Two","Forty ","","",1,3,5,""," Lakhs "," Thousand ","","Two Lakhs Forty Thousand"]
[20000,"(Twenty Thousand rupees only)",0,0,20,0,0,"","","Twenty","","",1,3,5,"",""," Thousand ","","Twenty Thousand"]
[125,"(One Hundred and Twenty five rupees only)",0,0,0,1,25,"","","","One","Twenty five",2,4,6,"","",""," Hundred ","One Hundred and Twenty five"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[1254879657,"(Ninety nine Crores Forty eight Lakhs Seventy nine Thousand Six Hundred and Fifty seven rupees only)",125,48,79,6,57,"Ninety nine","Forty eight","Seventy nine","Six","Fifty seven",2,4,6," Crores "," Lakhs "," Thousand "," Hundred ","Ninety nine Crores Forty eight Lakhs Seventy nine Thousand Six Hundred and Fifty seven"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[null,"",0,0,0,0,0,"","","","","",1,3,5,"","","","","Zero"]
[856953,"(Eight Lakhs Fifty six Thousand Nine Hundred and Fifty three rupees only)",0,8,56,9,53,"","Eight","Fifty six","Nine","Fifty three",2,4,6,""," Lakhs "," Thousand "," Hundred ","Eight Lakhs Fifty six Thousand Nine Hundred and Fifty three"]

{"sheet":"Form 16 (B)","index":12,"n_rows":48,"n_cols":10,"rows_kept":48,"cut":false,"hidden":false,"merged":[[41,0,41,9],[42,0,42,2],[43,0,43,2],[44,4,44,8],[46,6,46,9],[47,6,47,9],[25,1,25,7],[26,2,26,9],[36,1,36,2],[31,4,31,6],[31,7,31,8],[32,4,32,6],[32,7,32,8],[30,7,30,8],[35,4,35,6],[28,4,28,6],[36,7,36,8],[0,1,1,3],[0,4,1,5],[0,6,1,7],[0,8,1,9],[14,1,14,5],[15,1,15,7],[16,1,16,7],[17,1,17,7],[18,1,18,7],[18,11,18,17],[28,7,28,8],[28,1,28,2],[29,1,29,2],[29,7,29,8],[22,1,22,7],[24,3,24,7],[19,1,19,7],[20,1,20,7],[21,1,21,7],[38,4,38,6],[39,4,39,6],[37,1,37,2],[38,1,38,2],[39,1,39,2],[29,4,29,6],[36,4,36,6],[40,4,40,6],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[30,4,30,6],[40,1,40,2],[37,4,37,6],[37,7,37,8],[38,7,38,8],[39,7,39,8],[40,7,40,8],[27,1,27,8],[33,4,33,6],[33,7,33,8],[34,4,34,6],[34,7,34,8],[35,7,35,8]],"flags":["formulas_cached_only"]}
["B)","OTHER DEDUCTIONS UNDER CHAPTER VI-A\n UNDER SECTIONS e.g.,  80E, 80G etc.",null,null,"GROSS AMOUNT",null,"QUALIFYING AMOUNT",null,"DEDUCTIBLE AMOUNT"]
[]
[null,null,null,"Maintance for Disabled Individual 80% Below Disability  U/S 80U","Rs.",0,"Rs.",0]
[null,null,null,"No Handipcapped Dependent","Rs.",0,"Rs.",0]
[null,null,null,"Medical Insuracne Premium for Senior Citizen Parents U/S 80D","Rs.",0,"Rs.",0]
[null,null,null,"Medical Insuracne Premium for Self, Spouse & Children U/S 80D","Rs.",0,"Rs.",0]
[null,null,null,"Master Health Check up of U/S 80D (up to Rs. 5000)","Rs.",0,"Rs.",0]
[null,null,null,"Employer Contribution towards NPS Account ( GOVT Contribution ) U/S 80 CCD(2)","Rs.",0,"Rs.",0]
[null,null,null,"Interest of Educational Loan 80 E","Rs.",0,"Rs.",0]
[null,null,null,"Interest of House Building U/S 24(B)","Rs.",0,"Rs.",0]
[null,null,null,"Interest of House Building U/S 80EEA","",null,"Rs.",0]
[null,null,null,"Interest Paid for Electrical Vehicle (EV) U/S 80EEB (Purchased between 01.04.2019 o 31.03.2023)","Rs.",0,"Rs.",0]
[null,null,null,"EWF, SWF & CMRF","Rs.",2663,"Rs.",2663]
[null,null,null,"Total","Rs.",0,"Rs.",0,"Rs.",2663]
["10.","AGGREGATE OF DEDUCTABLE AMOUNT UNDER CHAPER VI-A (A+B)",{"$nulls":6},"Rs.",152663]
["11.","TOTAL INCOME (8-10)",{"$nulls":6},"Rs.",831930]
["12.","TAX ON TOTAL INCOME",{"$nulls":6},"Rs.",78886]
[13,"TAX Rebate U/S 87A ( Rs. 12,500/- Rebate upto Rs. 5,000,000/- Taxable Income)",{"$nulls":6},"Rs.",0]
[14,"Education Cess @ 4% for Primary Education on Tax payable",{"$nulls":6},"Rs.",3155]
[15,"TAX ON TOTAL INCOME AFTER REBATE",{"$nulls":6},"Rs.",82041]
[16,"Relief Under Section 89 (1) (attach details)",{"$nulls":6},"Rs.",0]
[17,"NET TAX PAYABLE  (15 - 16)",{"$nulls":6},"Rs.",82041]
[18,"Less:",{"$nulls":6},""]
[null,null,"(a)","Tax deducted at source under Section 192 (I)",null,null,"",null,"Rs.",0]
[null,null,"(b)","Tax Paid by the employer on behalf of the Employees under Section 192(IA) on perquisities under Sec 17(2)",{"$nulls":4},""]
[19,"Tax Payable / Refundable (18-19)",{"$nulls":6},"Rs.",82041]
[null,null,"TAX PAYABLE : (Eighty two Thousand and Forty one rupees only)"]
[null,"The employer is to provide transaction wise details of tax deducted and deposited\n\n\n\n  \n  \n\n  \n  \n\n"]
[null,"Sl. No.",null,"TDS Amount","Education Cess",null,null,"Total Tax"]
[null,1,null,0,0,null,null,0]
[null,2,null,0,0,null,null,0]
[null,3,null,0,0,null,null,0]
[null,4,null,0,0,null,null,0]
[null,5,null,0,0,null,null,0]
[null,6,null,0,0,null,null,0]
[null,7,null,0,0,null,null,0]
[null,8,null,0,0,null,null,0]
[null,9,null,0,0,null,null,0]
[null,10,null,0,0,null,null,0]
[null,11,null,0,0,null,null,0]
[null,12,null,78886,3155,null,null,82041]
["                 I, Sri/Smt. ABCDEFXYZ working in the capacity of  HEADMASTER  do here by certify that a sum of Rs. 82041 (Eighty two Thousand and Forty one rupees only)  has been deducted at source and paid to the credit of the Central Government. I further certify that the information given above is true and correct based on the books of accounts, documents and other available records."]
["Place:",null,null,"ZPHS XYZ"]
["Dated:"]
[{"$nulls":4},"Signature of the person responsible for deduction of Tax"]
[]
[{"$nulls":4},"Full Name:",null,"ABCDEFXYZ"]
[{"$nulls":4},"Designation:",null,"HEADMASTER"]

{"sheet":"10E(2)","index":13,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":true,"merged":[[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[24,0,24,1],[25,0,25,1],[21,0,21,1],[22,0,22,1],[4,7,4,8],[5,7,5,8],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[0,0,0,8],[1,0,1,8],[2,0,2,8],[20,0,20,1],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[26,0,26,7],[17,0,17,8],[18,0,18,8],[20,6,20,7],[21,6,21,7],[22,6,22,7],[23,6,23,7],[24,6,24,7],[25,6,25,7],[23,0,23,1]],"flags":["formulas_cached_only"]}
["Annexure - I"]
["(See item 2 of Form No. 10E)"]
["ARREARS OR ADVANCE SALARY"]
[]
[1,"Total Income (excluding salary received in arrears or advance)",{"$nulls":4},"Rs.",831930,null,null,831930,null,831930]
[2,"Salary received in arrears or advance",{"$nulls":4},"Rs.",0,null,null,0,"No",0]
[3,"Total income (as increased by salary received in arrears or advance)",{"$nulls":4},"Rs.",831930,null,null,0,"No",0]
[4,"Tax on total income (as per item 3)",{"$nulls":4},"Rs.",82041,null,null,0,"No",0]
[5,"Tax on total income (as per item 1)",{"$nulls":4},"Rs.",82041,{"$nulls":4},0]
[6,"Tax on salary received in arrears or advance                                                                                (Difference of item 4 and item 5)",{"$nulls":4},"Rs.",0]
[7,"Tax on computed in accordance with table \"A\"                                                                 (Brought form column 7 of Table \"A\")",{"$nulls":4},"Rs.",0]
[8,"Relief under section 89(1) [Indicate the difference between the amounts mentioned against items 6 and 7)",{"$nulls":4},"Rs.",0]
[]
[]
[]
[]
[]
["TABLE \"A\""]
["(See item 7 of Annexure I)"]
[]
["Previous Years",null,"Total Income of the relevnt pervious years(Rs)","Salary received in arrears or advance relating to the previous year as mentioned in columne 1 (Rs)","Total income (as increased by salary received in arrears or advance) of the relevent previous year mentioned in column 1 (Rs)","Tax on total income (as per column 2 (Rs.)","Tax on total income (as per column 4 (Rs.)",null,"Difference in tax (amount under column 6 minus amount under column 5) (Rs)"]
[1,null,2,3,4,5,6,null,7]
["FY 2023-24",null,0,0,0,0,0,null,0,null,"No",0,0,0,0]
["FY 2022-23",null,0,0,0,0,0,null,0,null,"No",0,0,0,0]
["FY 2021-22",null,0,0,0,0,0,null,0,null,"No",0,0,0,0]
[null,null,0,0,0,0,0,null,0]
["Total",{"$nulls":7},0]

{"sheet":"Rent","index":14,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[20,5,20,9],[21,5,21,9],[0,0,0,9],[4,0,4,9],[1,0,1,9],[15,5,15,9],[14,5,14,9],[17,0,17,9],[14,2,14,4],[15,2,15,4]],"flags":["formulas_cached_only"]}
["HOUSE RENT RECEIPT"]
["(Under Section 10 (13-A) of Income Tax Act )"]
[]
[]
["          This is to certify that Sri /Smt N RAJENDER REDDY, SGT, MPUPS KACHAPUR, Mdl. JULAPALLI  has paid me an amount of Rs 240000.00  in words (Two Lakhs Forty Thousand rupees only)  towards rent as tenant Annual House Rent @ Rs. 20000 per month in respect of my house H.No. 1-22-333, Bhagya Nagar, Karimnagar, Telangana  for the period of Mar, 2024 to Feb, 2025."]
[{"$nulls":10},"PAN of the House Owner: ABCG2548F"]
["PAN of the House Owner: ABCG2548F"]
[{"$nulls":10},20000,12,240000]
[{"$nulls":13},"PAN of the House Owner"]
[{"$nulls":6},"Rs. 1/- "]
[{"$nulls":6},"Revenue "]
[{"$nulls":6},"Stamp"]
[]
[]
[null,null,"Name of the Owner:",null,null,"NAR Reddy"]
[null,null,"Address:",null,null,"1-22-333, Bhagya Nagar, Karimnagar, Telangana"]
[]
["      I. do hereby declare that what is stated above is true to the best of my knowledge and belief and nothing has been concealed."]
[]
[]
[{"$nulls":5},"Signature of the Employee"]
[{"$nulls":5},"(N RAJENDER REDDY)"]

{"sheet":"Empty","index":15,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5],[5,0,5,5],[16,0,16,5],[20,2,20,5],[19,2,19,5]],"flags":["formulas_cached_only"]}
["HOUSE RENT RECEIPT"]
["(Under Section 10 (13-A) of Income Tax Act)"]
[]
[]
[]
["                 This is to certify that Sri / Smt _________________________ Desi:  _____________, Working Place: __________________________________, Mdl: _____________________________ has paid me an amount of Rs _____________  in words (Rupees ___________________________________ )  per month Rs. ____________ towards rent as tenant of my house at H. No. _______________________________ for the period of March 2020 to February 2021."]
[]
[]
[]
[null,null,null,"Rs. 1/- "]
[null,null,null,"Revenue "]
[null,null,null,"Stamp"]
[]
[null,null,"Name of the Owner:"]
[null,null,"Address"]
[]
["      I. do hereby declare that what is stated above is true to the best of my knowledge and belief and nothing has been concealed."]
[]
[]
[null,null,"Signature of the Employee"]
[null,null,"(N RAJENDER REDDY)"]

{"sheet":"10E","index":16,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":true,"merged":[[23,5,23,7],[18,2,18,7],[1,1,1,7],[2,1,2,7],[3,2,3,3],[4,2,4,3],[5,2,5,3],[9,3,9,5],[7,2,7,7],[3,5,3,7],[16,2,16,7],[4,5,4,7],[10,3,10,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[5,5,5,7]],"flags":["formulas_cached_only"]}
[]
[null,"FORM No. 10E"]
[null,"(See Rule 21AA)"]
[null,1,"Name and address of the Employee",null,":","N RAJENDER REDDY, SGT, MPUPS KACHAPUR, JULAPALLI, PEDDAPLLI"]
[null,2,"Permanent Account Number",null,":","EFGH5678D"]
[null,3,"Residential Status",null,":","Indian Resident"]
[]
[null,null,"Particulars of Income referred to in rule 21A of the Income Tax Rules, 1962 during the previous year relevent to Assessment Year 2023-24"]
[]
[null,1,"a","Salary received in arrears or in advance in accordance with the provision of sub rule (2) of rule 21A.",null,null,"Rs.",0]
[null,null,"b","Payment in the nature of gratuity in respect of past services, exeding over a period of not less than 5 years in accordance with the provisions of sub rule (3) of rule 21A.",null,null,"Rs.","Not Applicable"]
[null,null,"c","Payment in the nature of compensaion from the empoloyer or former emplyer at or in connection with termination of employment after continuous service of not less than 3 years or where the unexpired portion of term of employment is also not less than 3 years in accordance with the provisions of sub rule (4) of the rule 21A.",null,null,"Rs.","Not Applicable"]
[null,null,"d","Payment in commutation of pension is accordance with the provisions of sub rule (5) of rule 21A.",null,null,"Rs.","Not Applicable"]
[null,2,null,"Detailed particulars of payments refered to above may be given in Annexure-I, IIA, III or IV as the case may be.",null,null,null,"Annexure - I"]
[]
[]
[null,null,"Verification"]
[]
[null,null,"         I  N RAJENDER REDDY do here by declare that what is stated above is true to the best of my knowledge and belief. Verified today."]
[]
[]
[]
[null,"Place:",null,"MPUPS KACHAPUR"]
[null,"Date:",null,null,null,"Signature of the Employee"]

{"sheet":"10E Caluculation","index":17,"n_rows":24,"n_cols":29,"rows_kept":24,"cut":false,"hidden":true,"merged":[[11,15,11,16],[8,18,8,19],[8,15,8,16],[6,15,6,16],[7,15,7,16],[9,15,9,16],[10,15,10,16],[5,18,5,19],[6,18,6,19],[13,14,13,17],[15,20,16,20],[13,18,13,19],[1,20,13,20],[1,18,1,19],[2,18,2,19],[12,15,12,16],[7,18,7,19],[1,15,1,16],[2,15,2,16],[3,15,3,16],[4,15,4,16],[5,15,5,16],[14,14,14,20],[9,18,9,19],[10,18,10,19],[11,18,11,19],[12,18,12,19],[3,18,3,19],[4,18,4,19],[0,14,0,20],[0,22,0,28],[1,23,1,24],[1,26,1,27],[1,28,13,28],[2,23,2,24],[2,26,2,27],[3,23,3,24],[3,26,3,27],[4,23,4,24],[4,26,4,27],[5,23,5,24],[5,26,5,27],[6,23,6,24],[6,26,6,27],[7,23,7,24],[7,26,7,27],[8,23,8,24],[8,26,8,27],[9,23,9,24],[9,26,9,27],[13,22,13,25],[13,26,13,27],[14,22,14,28],[15,28,16,28],[10,23,10,24],[10,26,10,27],[11,23,11,24],[11,26,11,27],[12,23,12,24],[12,26,12,27],[0,7,0,13],[1,8,1,9],[1,11,1,12],[1,13,13,13],[2,8,2,9],[2,11,2,12],[3,8,3,9],[3,11,3,12],[4,8,4,9],[4,11,4,12],[5,8,5,9],[5,11,5,12],[6,8,6,9],[6,11,6,12],[7,8,7,9],[7,11,7,12],[8,8,8,9],[8,11,8,12],[9,8,9,9],[9,11,9,12],[10,8,10,9],[10,11,10,12],[14,7,14,13],[15,13,16,13],[11,8,11,9],[11,11,11,12],[12,8,12,9],[12,11,12,12],[13,7,13,10],[13,11,13,12],[1,1,1,2],[1,4,1,5],[2,1,2,2],[2,4,2,5],[3,1,3,2],[3,4,3,5],[4,1,4,2],[4,4,4,5],[5,1,5,2],[5,4,5,5],[6,1,6,2],[6,4,6,5],[7,1,7,2],[7,4,7,5],[8,1,8,2],[8,4,8,5],[9,1,9,2],[9,4,9,5],[13,0,13,3],[13,4,13,5],[0,0,0,6],[15,6,16,6],[10,1,10,2],[10,4,10,5],[11,1,11,2],[11,4,11,5],[12,1,12,2],[12,4,12,5]],"flags":["formulas_cached_only"]}
["FY 2023-24",{"$nulls":6},"FY 2022-23",{"$nulls":6},"FY 2021-22",{"$nulls":7},"FY 2020-21"]
["Details","Amount",null,"Details","Amount",null,null,"Details","Amount",null,"Details","Amount",null,null,"Details","Amount",null,"Details","Amount",null,null,null,"Details","Amount",null,"Details","Amount"]
["Total Taxable Income (Excluding Arrears)",831930,null,"Total Taxable Income (Excluding Arrears)",831930,null,null,"Total Taxable Income (Excluding Arrears)",0,null,"Total Taxable Income (Excluding Arrears)",0,null,null,"Total Taxable Income (Excluding Arrears)",0,null,"Total Taxable Income (Excluding Arrears)",0,null,null,null,"Total Taxable Income (Excluding Arrears)",0,null,"Total Taxable Income (Excluding Arrears)",0]
["Arrears Recieved",0,null,"Arrears Recieved",0,null,null,"Arrears Recieved",0,null,"Arrears Recieved",0,null,null,"Arrears Recieved",0,null,"Arrears Recieved",0,null,null,null,"Arrears Recieved",0,null,"Arrears Recieved",0]
["Total Taxable Amount",831930,null,"Total Taxable Amount",831930,null,null,"Total Taxable Amount",0,null,"Total Taxable Amount",0,null,null,"Total Taxable Amount",0,null,"Total Taxable Amount",0,null,null,null,"Total Taxable Amount",0,null,"Total Taxable Amount",0]
["Up to 2,50,000",0,null,"Up to 2,50,000",0,null,null,"Up to 2,50,000",0,null,"Up to 2,50,000",0,null,null,"Up to 2,50,000",0,null,"Up to 2,50,000",0,null,null,null,"Up to 2,50,000",0,null,"Up to 2,50,000",0]
["2,50,001 to 5,00,000 @ 5%",12500,null,"2,50,001 to 5,00,000 @ 5%",12500,null,null,"2,50,001 to 5,00,000 @ 5%",-12500,null,"2,50,001 to 5,00,000 @ 5%",-12500,null,null,"2,50,001 to 5,00,000 @ 5%",-12500,null,"2,50,001 to 5,00,000 @ 5%",-12500,null,null,null,"2,50,001 to 5,00,000 @ 5%",-12500,null,"2,50,001 to 5,00,000 @ 5%",-12500]
["5,00,000 to 10,00,000 @ 20%",66386,null,"5,00,000 to 10,00,000 @ 20%",66386,null,null,"5,00,000 to 10,00,000 @ 20%",0,null,"5,00,000 to 10,00,000 @ 20%",0,null,null,"5,00,000 to 10,00,000 @ 20%",0,null,"5,00,000 to 10,00,000 @ 20%",0,null,null,null,"5,00,000 to 10,00,000 @ 20%",0,null,"5,00,000 to 10,00,000 @ 20%",0]
["above 10,00,001 @ 30%",0,null,"above 10,00,001 @ 30%",0,null,null,"above 10,00,001 @ 30%",0,null,"above 10,00,001 @ 30%",0,null,null,"above 10,00,001 @ 30%",0,null,"above 10,00,001 @ 30%",0,null,null,null,"above 10,00,001 @ 30%",0,null,"above 10,00,001 @ 30%",0]
["Tax Rebate US 87A",0,null,"Tax Rebate US 87A",0,null,null,"Tax Rebate US 87A",-12500,null,"Tax Rebate US 87A",-12500,null,null,"Tax Rebate US 87A",-12500,null,"Tax Rebate US 87A",-12500,null,null,null,"Tax Rebate US 87A",-12500,null,"Tax Rebate US 87A",-12500]
["Total",78886,null,"Total",78886,null,null,"Total",0,null,"Total",0,null,null,"Total",0,null,"Total",0,null,null,null,"Total",0,null,"Total",0]
["Education Cess @ 4%",3155,null,"Education Cess @ 4%",3155,null,null,"Education Cess @ 4%",0,null,"Education Cess @ 4%",0,null,null,"Education Cess @ 4%",0,null,"Education Cess @ 4%",0,null,null,null,"Education Cess @ 4%",0,null,"Education Cess @ 4%",0]
["Total Net Tax",82041,null,"Total Net Tax",82041,null,null,"Total Net Tax",0,null,"Total Net Tax",0,null,null,"Total Net Tax",0,null,"Total Net Tax",0,null,null,null,"Total Net Tax",0,null,"Total Net Tax",0]
["Difference",null,null,null,0,null,null,"Difference",null,null,null,0,null,null,"Difference",null,null,null,0,null,null,null,"Difference",null,null,null,0]
[]
[{"$nulls":6},"TAX %",{"$nulls":6},"TAX %",{"$nulls":6},"TAX %",{"$nulls":7},"TAX %"]
["FY 2023-24",831930,null,"FY 2023-24",831930,null,null,"FY 2022-23",0,null,"FY 2022-23",0,null,null,"FY 2021-22",0,null,"FY 2021-22",0,null,null,null,"FY 2020-21",0,null,"FY 2020-21",0]
[250000,250000,0,250000,250000,0,0,250000,250000,0,250000,250000,0,0,250000,250000,0,250000,250000,0,0,null,250000,250000,0,250000,250000,0,0]
[581930,250000,12500,581930,250000,12500,5,-250000,-250000,-12500,-250000,-250000,-12500,5,-250000,-250000,-12500,-250000,-250000,-12500,5,null,-250000,-250000,-12500,-250000,-250000,-12500,5]
[331930,331930,66386,331930,331930,66386,20,0,0,0,0,0,0,20,0,0,0,0,0,0,20,null,0,0,0,0,0,0,20]
[0,0,0,0,0,0,30,0,0,0,0,0,0,30,0,0,0,0,0,0,30,null,0,0,0,0,0,0,30]
["Total Tax",null,78886,"Total Tax",null,78886,null,"Total Tax",null,-12500,"Total Tax",null,-12500,null,"Total Tax",null,-12500,"Total Tax",null,-12500,null,null,"Total Tax",null,-12500,"Total Tax",null,-12500]
["Rebate",null,0,"Rebate",null,0,null,"Rebate",null,-12500,"Rebate",null,-12500,null,"Rebate",null,-12500,"Rebate",null,-12500,null,null,"Rebate",null,-12500,"Rebate",null,-12500]
["NET TAX",831930,78886,"NET TAX",831930,78886,null,"NET TAX",0,0,"NET TAX",0,0,null,"NET TAX",0,0,"NET TAX",0,0,null,null,"NET TAX",0,0,"NET TAX",0,0]