{"text_format":"2","workbook":"xls","n_sheets":14,"sheets":["DATA","Annexure","Table","12BB","Form 16(Front)","w","Form 16 (Back)","Rent Rec","Empty","10E(1)","10E(2)","10E Caluculation","A","AA"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":4,"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":141,"n_cols":22,"rows_kept":141,"cut":false,"hidden":false,"merged":[[53,1,53,6],[43,1,43,7],[39,12,40,13],[39,11,40,11],[40,3,40,4],[57,1,57,6],[54,1,54,6],[42,1,42,13],[46,1,46,6],[47,1,47,6],[58,1,58,13],[44,8,44,12],[43,8,43,13],[46,8,46,12],[52,8,56,10],[44,1,44,6],[49,1,49,6],[45,1,45,6],[50,1,50,6],[47,8,47,12],[52,1,52,6],[51,1,51,6],[39,3,39,4],[37,1,37,13],[38,1,38,10],[48,8,48,12],[48,1,48,6],[20,5,20,6],[22,5,22,6],[52,11,56,13],[45,8,45,12],[27,1,28,3],[38,12,38,13],[33,12,33,13],[33,1,33,5],[27,7,27,8],[28,7,28,8],[14,5,14,6],[21,5,21,6],[19,2,19,3],[50,8,50,12],[51,8,51,12],[25,2,25,3],[17,5,17,6],[18,5,18,6],[19,5,19,6],[22,2,22,3],[5,7,5,8],[6,7,6,8],[57,8,57,13],[9,5,9,6],[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[25,7,25,8],[26,7,26,8],[25,5,25,6],[12,7,12,8],[19,7,19,8],[20,7,20,8],[10,7,10,8],[4,7,4,8],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[14,2,14,3],[24,9,24,10],[2,1,2,3],[2,5,2,8],[15,5,15,6],[16,5,16,6],[2,9,2,10],[8,5,8,6],[3,5,3,6],[3,7,3,8],[3,2,3,3],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[0,0,0,14],[1,0,1,14],[2,12,2,13],[2,0,64,0],[2,14,64,14],[56,1,56,6],[55,1,55,6],[12,9,12,10],[26,5,26,6],[27,5,27,6],[28,5,28,6],[23,7,23,8],[49,8,49,12],[23,5,23,6],[24,5,24,6],[8,2,8,3],[11,7,11,8],[10,2,10,3],[29,1,29,10],[8,7,8,8],[9,7,9,8],[9,2,9,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[36,10,36,11],[35,1,35,5],[36,1,36,5],[34,1,34,5],[31,3,31,4],[32,3,32,4],[31,7,31,8],[32,7,32,9],[34,12,34,13],[35,12,35,13],[36,12,36,13],[33,7,33,8],[34,7,34,8],[35,7,35,8],[36,7,36,8],[33,10,33,11],[34,10,34,11],[35,10,35,11]],"flags":["formulas_cached_only"]}
["PARTICULARS FOR INCOMETAX FOR THE YEAR 2022-23\n(ASSESSMENT YEAR 2023-24)"]
[]
[null,"PERSONAL DETAILS",null,null,null,"SALARY  DETAILS",null,null,null,"DDO DETAILS",null,null,"ADVANCE TAX TABLE",null,null,null,"LIC Policies Premium (Yearly)"]
[null,"Name of the Employee","N RAJENDER REDDY",null,null,"MONTH",null,"PAY",null,"Name of the DDO","ABCDEFXYZ",null,"MONTH","AMOUNT",null,null,"Subscription to NSC"]
[null,"Father's Name","RAJI REDDY",null,null,"Jan, 2022",null,60480,null,"D.D.O. Designation","HEADMASTER",null,"Mar, 2022",0,null,null,"Tution fee for 2 children"]
[null,"Designation","SGT",null,null,"Feb, 2022",null,60480,null,"Place of Working","ZPHS XYZ",null,"Apr, 2022",0,null,null,"Repayment of Home Loan Principle"]
[null,"EMP ID No.",1234567,null,null,"Incr Month",null,"Mar",null,"Mandal","JULAPALLI",null,"May, 2022",0,null,null,"ULIP"]
[null,"Present place of Working","MPUPS KACHAPUR",null,null,"Surrender Leave Taken         (Mar, 22 to Feb, 23)",null,"Not Taken","Nov","District","PEDDAPALLI",null,"Jun, 2022",0,null,null,"PLI"]
[null,"Mandal","JULAPALLI",null,null,"TS_SP",null,360,null,"TAN Number","HYDH1234F",null,"Jul, 2022",0,null,null,"SBI Life Insuracne"]
[null,"District","PEDDAPLLI",null,null,"Child Education Concession Amount",null,0,null,"Name of the House Owner","MSN Reddy",null,"Aug, 2022",0,null,null,"Public Provident Fund"]
[null,"Type of Residence","Rented House",null,null,"Sainik Welfare Fund",null,100,null,"PAN of the House Owner",null,null,"Sep, 2022",0,null,null,"Subscriptions made to Equity Shares/Debentures"]
[null,"House Rent Paid for Month",14200,null,null,"Employee Welfare Fund",null,20,null,"Adress","1-22-333, Bhagya Nagar, Karimnagar",null,"Oct, 2022",0,null,null,"Invesment in Sukanya Samruddhi"]
[null,"Enhance Rent upto",14202.166666666666,null,null,"HRA ",null,11,null,"July, 19 to May, 20 Basic Pay                                                                        (If wrong please change)",null,null,"Nov, 2022",0,null,null,"Fixed Deposits in Bank More Than (5) years."]
[null,"Pension type","CPS",null,null,"IF HRA Change",null,"No Change",20,"July, 2021",60480,null,"Dec, 2022",0]
[null,"PAN No.","EFGH5678D",null,null,"HM Allowance",null,0,null,"Aug, 2021",60480,null,"Jan, 2023",0,null,null,"Medical Treatment of below 80% Handicapped  dependent U/S 80DD",null,null,75000,0,"No Handipcapped Dependent"]
[null,"DEDUCTIONS",null,null,null,"IF HM Allowance Change",null,"No Change",0,"Sept, 2021",60480,null,"Feb, 2023",56175,null,null,"Medical Treatment of above 80% Handicapped dependent U/S 80DD",null,null,125000,0,"No Handipcapped Dependent"]
[{"$nulls":5},"CCA",null,0,null,"Oct, 2021",60480,{"$nulls":5},"No Handipcapped Dependent",null,null,0,0,"No Handipcapped Dependent"]
[null,"GPF in March, 2020",5000,null,null,"IF CCA Allowance Change",null,"No Change",0,"Nov, 2021",60480,null,0,{"$nulls":7},0]
[null,"If PF Change","No Change",0,null,"PHA",null,"NO",null,"Dec, 2021",60480,{"$nulls":5},"80U-Deductions for Disabled Individual above 40% Disability",null,null,75000,0,"No Indivdual Disability"]
[null,"GPF No. / PRAN No",12563,null,null,"PP",null,0,null,"Jan, 2022",60480,{"$nulls":5},"80U-Deductions for Disabled Individual above 80% Disability",null,null,125000,0,"No Indivdual Disability"]
[null,"TSGLI in March 2020",3000,null,null,"FP",null,0,null,"Feb, 2022",60480,{"$nulls":5},"No Indivdual Disability",null,null,0,0,"No Indivdual Disability"]
[null,"If TSGLI Change","No Change",0,null,"Special Pay / Higher Class Allow",null,0,null,"Mar, 2022",62110,{"$nulls":9},0]
[null,"Policy No.","L 1234567",null,null,"IF Change Special Pay",null,"No Change",0,"Apr, 2022",62110]
[null,"GIS in March, 2020",60,null,null,"CMRF Given?",null,"NO",null,"May, 2022",62110,{"$nulls":5},"Medical Insuracne Premium for Self, Spouse & Children U/S 80D"]
[null,"IF GIS Change","No Change",60,null,"Surrender Leave Taken         (Jul, 21 to Dec, 2021)",null,"Not Taken","Nov","TAX DETAILS",{"$nulls":6},"Senior Citizen Parents Medical Insurance U/S 80D"]
[null,"AAS (6/12/18/24) taken","No",null,null,"Choose Your Tax Slab",null,"OLD",null,"Taxable Income",707570]
[null,"IF so, Date & Month",17,"Oct",null,"Income from Capital Gains",null,null,null,"Tax Payble",56175]
[{"$nulls":5},"Other Sources of income if any (Agriculture, Business, Chits, etc,.)",null,null,null,"Advance Tax Paid",0]
[{"$nulls":5},"Income from House Property",null,null,null,"NET TAX PAYBLE",56175]
[]
[null,"2014-15 PRC Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?",{"$nulls":4},"No","2014-15 Taxable Income as Form 16",null,null,255000]
[null,"April, 2021 & May, 2021 Arrears Details","PRC Arrears Per Month",1637,null,"Total No. of Months bills passed",3,"CPS Amount",null,146]
[null,"July. 21 to Dec, 21 CPS DA Arrears per mont","DA Arrears Per Month",3438,null,"Total No. of Months bills passed",0]
[null,"FY 2021-22 Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?",{"$nulls":4},"No","F Y 2021-22 Arrears Amount",null,5468,"F Y 2021-22 Taxable Income as per Form 16",null,1299582]
[null,"FY 2020-21 Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?",{"$nulls":4},"No","F Y 2020-21 Arrears Amount",null,2568,"F Y 2020-21 Taxable Income as per Form 16",null,526252]
[null,"FY 2019-20 Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?",{"$nulls":4},"No","F Y 2019-20 Arrears Amount",null,1251,"F Y 2019-21 Taxable Income as per Form 16",null,498529]
[null,"FY 2018-19 Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?",{"$nulls":4},"No","F Y 2018-19 Arrears Amount",null,2658,"F Y 2018-19 Taxable Income as per Form 16",null,378521]
[]
[null,"ARREARS"]
[null,"DETAILS","PAY","DA",null,"HRA","IR","GROSS","GPF/CPS","PT","NET"]
[null,"AAS/Others",0,0,null,0,0,0,0,0,0]
[null,"OTHERS",0,0,null,0,0,0,0,0,0]
[]
[null,"DEDUCTIONS UNDER CHAPTER VI A  (Sections 80 C, 80 CCC and 80 CCD)",{"$nulls":6},"OTHER DEDUCTIONS UNDER CHAPTER VI-A (e.g., 80D, 80DD, 80 DDB, 80E, 80G, 80L, 80E)"]
[null,"GPF Deductions",{"$nulls":5},"0","No Handipcapped Dependent",{"$nulls":4},0]
[null,"TSGLI Deductions ",{"$nulls":5},36000,"No Indivdual Disability",{"$nulls":4},0]
[null,"Group Insurance",{"$nulls":5},720,"Medical Insuracne Premium for Self, Spouse & Children U/S 80D"]
[null,"LIC Policies Premium (Yearly)",{"$nulls":6},"Master Health Check up of parents (Senior Citizen) U/S 80D"]
[null,"Tution fee for 2 children",{"$nulls":6},"Interest of House Building U/S 24(B)"]
[null,"Repayment of Home Loan Principle",{"$nulls":6},"Interest of Educational Loan 80 E"]
[null,"PLI",{"$nulls":6},"EWF, SWF & CMRF",{"$nulls":4},420]
[null,"Invesment in Sukanya Samruddhi",{"$nulls":6},"CMRF by self if any"]
[null,"SBI Life Insuracne",{"$nulls":6}," This IT software developed by  N.Rajender Reddy, Manakondur, for other softwares  please visit www.nallarreddy.webnode.com and send comments and suggestions to nalla.rreddy@gmail.com or call to 9440074706 (No need to fill red cells)"]
[null,"Fixed Deposits in Bank More Than (5) years."]
[null,"Rajiv Gandhi Equity Saving Scheme US 80CCG"]
[null,"Additional Benefit Under NPS U/S 80CCD(1B)"]
[null,"Sri Ram Janma Bhoomi Teerth Kshetra Under Secion 80G (2)(b)"]
[null,"Contribution to any Pension Scheme U/S  80 CCD (Max. 10% of salary)",{"$nulls":5},91657]
[]
[{"$nulls":5},0,null,91657,null,null,0]
[null,null,null,11,null,1,"Mar",null,null,"OLD",19000]
[null,"Male",null,13,null,2,"Apr",null,null,"NEW",19640]
[null,"Female",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,null,21580]
[null,"CPS",null,50,null,6,"Aug","CPS","CPS Deduction",null,22240]
[null,"GPF",null,75,null,7,"Sep","CPS Deduction",null,null,22900]
[null,0,null,100,null,8,"Oct","-",null,null,23590]
[null,2500,null,null,null,9,"Nov",null,null,null,24280]
[null,5000,null,"YES",null,10,"Dec",null,null,null,24970]
[null,0,null,"NO",null,11,"Jan",null,null,null,25690]
[null,100,null,null,null,12,"Feb",null,null,null,26410]
[null,200,null,null,null,13,{"$nulls":4},27130]
[null,0,null,0,null,14,{"$nulls":4},27880]
[null,15,null,20,null,15,{"$nulls":4},28630]
[null,30,null,50,null,16,{"$nulls":4},29380]
[null,60,null,null,null,17,{"$nulls":4},30210]
[null,120,null,null,null,18,{"$nulls":4},31040]
[null,"Not Taken",null,null,null,19,{"$nulls":4},31870]
[null,"15 Days",null,null,null,20,{"$nulls":4},32810]
[null,"30 Days",null,null,null,21,{"$nulls":4},33750]
[null,"No Change",null,null,null,22,{"$nulls":4},34690]
[null,"Mar","Jul",null,null,23,{"$nulls":4},35720]
[null,"Apr","Aug",null,null,24,{"$nulls":4},36750]
[null,"May","Sep",null,null,25,{"$nulls":4},37780]
[null,"Jun","Oct",null,null,26,{"$nulls":4},38890]
[null,"Jul","Nov",null,null,27,{"$nulls":4},40000]
[null,"Aug","Dec",null,null,28,{"$nulls":4},41110]
[null,"Sep","Jan",null,null,29,{"$nulls":4},42300]
[null,"Oct","Feb",null,null,30,{"$nulls":4},43490]
[null,"Nov","Mar",null,null,31,{"$nulls":4},44680]
[null,"Dec","Apr",{"$nulls":7},45960]
[null,"Jan","May",{"$nulls":7},47240]
[null,"Feb","Jun",{"$nulls":7},48520]
[null,null,"Yes",{"$nulls":7},49920]
[null,null,"No",{"$nulls":7},51320]
[{"$nulls":10},52720]
[{"$nulls":10},54220]
[{"$nulls":10},55720]
[{"$nulls":10},57220]
[{"$nulls":10},58850]
[{"$nulls":10},60480]
[{"$nulls":10},62110]
[{"$nulls":10},63840]
[{"$nulls":10},65570]
[{"$nulls":10},67300]
[{"$nulls":10},69150]
[{"$nulls":10},71000]
[{"$nulls":10},72850]
[{"$nulls":10},74840]
[{"$nulls":10},76830]
[{"$nulls":10},78820]
[{"$nulls":10},80960]
[{"$nulls":10},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":"Annexure","index":1,"n_rows":65,"n_cols":25,"rows_kept":65,"cut":false,"hidden":false,"merged":[[52,1,52,6],[53,1,53,6],[32,1,32,6],[26,1,26,6],[39,1,39,6],[45,1,45,6],[35,1,35,6],[46,1,46,6],[30,1,30,6],[57,1,57,6],[60,1,60,6],[59,1,59,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],[51,1,51,6],[64,8,64,9],[37,1,37,6],[42,1,42,6],[41,1,41,6],[62,1,62,8],[19,1,19,6],[28,1,28,6],[43,1,43,6],[61,1,61,6],[58,1,58,6],[55,1,55,6],[4,1,4,8],[1,3,1,9],[40,1,40,6],[47,1,47,6],[11,1,11,6],[36,1,36,6],[14,1,14,6],[18,1,18,6],[25,1,25,6],[10,0,13,0],[3,1,3,3],[9,1,9,6],[2,3,2,9],[23,1,23,6],[33,1,33,6],[29,1,29,6],[15,1,15,6],[13,1,13,6],[10,1,10,6],[21,1,21,6],[22,1,22,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],[24,1,24,6],[31,1,31,6],[34,1,34,6],[44,1,44,6],[27,1,27,6],[38,1,38,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]],"flags":["formulas_cached_only"]}
["INCOME TAX CALUCULATION FOR THE FINANCIAL YEAR 2022-23"]
[null,"Name of the Employee\n & Address",null,"N RAJENDER REDDY,   EMP ID No. 1234567"]
[null,null,null,"SGT, MPUPS KACHAPUR, Mdl JULAPALLI",{"$nulls":6},"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},970728]
[3,"Deductions towards HRA U/s.  10(13-A) (least of the following exempted)"]
[null,"a) Actual HRA Received",{"$nulls":5},"Rs. ",81984,null,81984]
[null,"b) Actual Rent Paid - {10% of (BP+DA)}        (Rs.  14200 X 12)",{"$nulls":5},"Rs. ",81958,null,81958]
[null,"c) 40% of Salary (Basic Pay + D.A)",{"$nulls":5},"Rs. ",353770,81958,353770,81958,null,null,81958]
[4,"TOTAL SALARY  (2-3)",{"$nulls":7},888770]
[5,"DEDUCTIONS FROM SALARY INCOME"]
[null,"Exemption from conveyance allowance u/s.10(14)(i)",{"$nulls":5},"Rs. ",0,null,0]
[null,"Standard Deduction U/S 16 (ia)",{"$nulls":5},"Rs. ",50000,null,50000]
[null,"Professional Tax  U/S 16(3) B",{"$nulls":5},"Rs. ",2400,52400,2400,{"$nulls":12},"GPF Deductions      (A/c No. 12563)","0"]
[6,"INCOME FROM SALARY (4-5)",{"$nulls":7},836370,{"$nulls":13},"CPS Employee Contribution Amount. PRAN 12563",91657]
[7,"Income from Capital Gains",{"$nulls":5},"Rs. ",0,{"$nulls":15},91657]
[8,"Other Sources of income if any (Agriculture, Business, Chits, etc,.)",{"$nulls":5},"Rs. ",0,{"$nulls":14},"CPS"]
[9,"Employer Contribution towards NPS Account ( GOVT Contribution )",{"$nulls":5},"Rs. ",91657,{"$nulls":4},91657,91657]
[10,"Income from House Property (U/s.24(vi))",{"$nulls":5},"Rs. ",0,91657]
[11,"GROSS TOTAL INCOME (6+7+8+9+10)",{"$nulls":5},"Rs. ",null,928027]
[12,"DEDUCTIONS UNDER CHAPTER VI A  (Sections 80 C, 80 CCC and 80 CCD)",{"$nulls":11},0]
[null,"CPS Employee Contribution Amount. PRAN 12563",{"$nulls":5},"Rs. ",41657,null,41657,null,null,91657,50000,"0"]
[null,"TSGLI Deductions (Policy No. L 1234567 )",{"$nulls":5},"Rs. ",36000,null,36000,null,null,"CPS",41657]
[null,"Group Insurance",{"$nulls":5},"Rs. ",720,null,720]
[null,"LIC Policies Premium (Yearly)",{"$nulls":5},"Rs. ","",null,""]
[null,"Tution fee for 2 children",{"$nulls":5},"Rs. ","",null,""]
[null,"Repayment of Home Loan Principle",{"$nulls":5},"Rs. ","",null,""]
[null,"PLI",{"$nulls":5},"Rs. ","",null,""]
[null,"Invesment in Sukanya Samruddhi",{"$nulls":5},"Rs. ","",null,""]
[null,"SBI Life Insuracne",{"$nulls":5},"Rs. ","",null,""]
[null,"Fixed Deposits in Bank More Than (5) years.",{"$nulls":5},"Rs. ","",null,"",null,null,78377]
[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. ",78377,78377,78377,78377]
[null,"Additional Benefit Under NPS U/S 80CCD(1B) ",{"$nulls":5},"Rs. ",null,50000,50000,50000]
[14,"TOTAL INCOME (12-13)",{"$nulls":7},799650]
[15,"OTHER DEDUCTIONS UNDER CHAPTER VI-A (e.g., 80D, 80DD, 80 DDB, 80E, 80G, 80L, 80E)"]
[null,"No Handipcapped Dependent",{"$nulls":5},"Rs. ",0,null,0]
[null,"No Indivdual Disability",{"$nulls":5},"Rs. ",0,null,0]
[null,"Medical Insuracne Premium for Self, Spouse & Children U/S 80D",{"$nulls":5},"Rs. ",0,null,0]
[null,"Master Health Check up of parents (Senior Citizen) U/S 80D",{"$nulls":5},"Rs. ",0,null,0]
[null,"Employer Contribution towards NPS Account ( GOVT Contribution ) U/S 80 CCD(2)",{"$nulls":5},"Rs. ",91657]
[null,"Interest of House Building U/S 24(B)",{"$nulls":5},"Rs. ",0,null,0,null,null,0]
[null,"Interest of Educational Loan 80 E",{"$nulls":5},"Rs. ",0,null,0]
[null,"EWF, SWF & CMRF",{"$nulls":5},"Rs. ",420,null,420]
[null,"CMRF by self if any",{"$nulls":5},"Rs. ",0,null,0]
[null,"Total",{"$nulls":5},"Rs. ",92077,92077]
[null,"Sri Ram Janma Bhoomi Teerth Kshetra Under Secion 80G (2)(b)",{"$nulls":5},"Rs. ",0,0,0,0]
[16,"TAXABLE INCOME (14-15)         (Round off to nearest multiple of Rs.10)",{"$nulls":7},707570,null,null,null,707573,70757,707570]
[17,"AMOUNT OF TAX (as per rates given below)"]
[null,"i) Up to 2,50,000/-    (@ 0% )",{"$nulls":7},0,0,0,null,"i) Up to 2,50,000/-    (@ 0% )",null,null,null,"i) Up to 2,50,000/-    (@ 0% )"]
[null,"ii) Rs.2,50,001 to 5,00,000       (@ 5% )",{"$nulls":6},0,12500,12500,12500,null,"ii) Rs.2,50,001 to 5,00,000       (@ 5% )",null,null,null,"ii) Rs.2,50,001 to 5,00,000       (@ 5% )"]
[null,"iii) Rs.5,00,001 to 10,00,000    ( @ 20% )",{"$nulls":7},41514,41514,20757,null,"iii) Rs.5,00,001 to 10,00,000    ( @ 20% )",null,null,null,"iii) Rs.5,00,001 to 7,50,000    ( @ 10% )"]
[null,"iv) above Rs.10,00,000           ( @ 30% )",{"$nulls":6},0,0,0,0,null,"iv) above Rs.10,00,000           ( @ 30% )",null,null,null,"iv) Rs.7,50,001 to 10,00,000    ( @ 15% )"]
[null,"-",{"$nulls":7},0,0,0,null,"-",null,null,null,"v) Rs.10,00,001 to 12,50,000    ( @ 20% )"]
[null,"-",{"$nulls":7},0,0,0,0,"-",null,null,null,"vi) Rs.12,50,001 to 15,00,000    ( @ 25% )"]
[null,"-",{"$nulls":6},0,0,0,0,null,"-",null,null,null,"vii) above Rs.15,00,000           ( @ 30% )"]
[null,"TAX ON TOTAL INCOME",{"$nulls":5},"Rs. ",null,54014]
[18,"TAX Rebate U/S 87A ( Rs. 12,500/- Rebate upto Rs. 5,000,000/- Taxable Income)",{"$nulls":5},"Rs. ",null,0,null,null,0]
[19,"Health & Education Cess @ 4% ",{"$nulls":5},"Rs. ",null,2161]
[20,"TAX PAYABLE",{"$nulls":5},"Rs. ",null,56175]
[21,"Relief Under Section 89(1)",{"$nulls":5},"Rs. ",null,0]
[22,"Advance Tax Deductons",{"$nulls":5},"Rs. ",null,0]
[23,"NET TAX PAYABLE (20-21-22)  Now",{"$nulls":5},"Rs. ",null,56175]
[null,"TAX PAYABLE : (Fifty six Thousand One Hundred and Seventy five rupees only)"]
[]
["Signature of the  Drawing & Disbursing Officer",{"$nulls":7},"Signature of the Employee"]

{"sheet":"Table","index":2,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,20],[2,12,2,19],[22,0,22,1],[2,0,3,0],[2,2,2,11],[19,1,19,4],[24,1,24,7],[2,20,3,20],[24,16,24,20],[1,0,1,1],[1,2,1,7],[21,1,21,9],[20,1,20,4]],"flags":["formulas_cached_only"]}
["STATEMENT SHOWING THE SALARY PARTICULARS OF SRI/SMT. N RAJENDER REDDY, SGT, MPUPS KACHAPUR, Mdl JULAPALLI"]
["EMP. ID No.",null,1234567]
["Sl. No.","Month","PAY PARTICULARS",{"$nulls":9},"DEDUCTIONS",{"$nulls":7},"NET PAY"]
[null,null,"Basic Pay","PP/FP/Spl. Pay","TS_SP","D.A.","H.R.A.","HMA","CCA","PHC","PRC Arrears","Gross Pay","CPS","TSGLI","GIS","PT","Adv. Tax","SEF / EWF","CMRF","Total Deduc"]
[1,"Mar, 2022",62110,0,360,10739,6832,0,0,0,0,80041,7285,3000,60,200,0,20,0,10565,69476,"NO"]
[2,"Apr, 2022",62110,0,360,10739,6832,0,0,0,0,80041,7285,3000,60,200,0,300,0,10845,69196,"NO"]
[3,"May, 2022",62110,0,360,10739,6832,0,0,0,0,80041,7285,3000,60,200,0,0,0,10545,69496,"NO"]
[4,"Jun, 2022",62110,0,360,10739,6832,0,0,0,0,80041,7285,3000,60,200,0,0,0,10545,69496,"NO"]
[5,"Jul, 2022",62110,0,360,10739,6832,0,0,0,0,80041,7285,3000,60,200,0,0,0,10545,69496,"NO"]
[6,"Aug, 2022",62110,0,360,10739,6832,0,0,0,0,80041,7285,3000,60,200,0,0,0,10545,69496,"NO"]
[7,"Sep, 2022",62110,0,360,10739,6832,0,0,0,0,80041,7285,3000,60,200,0,0,0,10545,69496,"NO"]
[8,"Oct, 2022",62110,0,360,10739,6832,0,0,0,0,80041,7285,3000,60,200,0,0,0,10545,69496,"NO"]
[9,"Nov, 2022",62110,0,360,10739,6832,0,0,0,0,80041,7285,3000,60,200,0,0,0,10545,69496,"NO"]
[10,"Dec, 2022",62110,0,360,10739,6832,0,0,0,0,80041,7285,3000,60,200,0,100,0,10645,69396,"NO"]
[11,"Jan, 2023",62110,0,360,10739,6832,0,0,0,0,80041,7285,3000,60,200,0,0,0,10545,69496,"NO"]
[12,"Feb, 2023",62110,0,360,12434,6832,0,0,0,0,81736,7454,3000,60,200,0,0,0,10714,71022,"NO"]
[13,"Sur. Leave",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[14,"AAS",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[15,"PRC Arrears",4911,null,null,0,0,{"$nulls":4},4911,438,0,0,0,0,0,0,438,4473]
[16,"DA arrears (Jul-21 to Dec, 21)",null,null,null,3630,0,0,0,0,null,3630,3630,0,0,0,0,0,0,3630,0]
[17,"DA arrears (Jul-21 to Dec, 21) 90%",null,null,null,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0]
[18,"Child Education Concession",{"$nulls":9},0,{"$nulls":7},0,0]
["TOTAL",null,750231,0,4320,134193,81984,0,0,0,0,970728,91657,36000,720,2400,0,420,0,131197,839531]
[]
[null,"Signature of the D.D.O",{"$nulls":14},"Signature of the Employee"]

{"sheet":"12BB","index":3,"n_rows":56,"n_cols":15,"rows_kept":56,"cut":false,"hidden":false,"merged":[[53,1,53,3],[53,6,53,9],[54,6,54,9],[55,6,55,9],[48,3,48,6],[48,8,48,9],[49,0,49,9],[52,0,52,4],[55,4,55,5],[55,2,55,3],[52,7,52,9],[43,8,43,9],[44,8,44,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[40,2,40,3],[40,5,40,6],[40,8,40,9],[41,1,41,7],[41,8,41,9],[50,0,51,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],[25,2,25,6],[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]],"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 :    2022-23"]
["Details of claims and evidence thereof"]
["Sl No.","Nature of claim",{"$nulls":5},"Amount (Rs.)","Evidence / particulars",null,null,null,"14200X12",null,"Rented House"]
["(1)","(2)",{"$nulls":5},"(3)","(4)",null,null,null,0]
[1,"House Rent Allowance:",{"$nulls":5},170400,"Receipt Produced",null,null,null,"MSN Reddy, "]
[null,"(i) ","Rent paid to the landlord",null,null,"14200X12",{"$nulls":6},"1-22-333, Bhagya Nagar, Karimnagar"]
[null,"(ii) ","Name of the landlord : MSN Reddy",{"$nulls":9},"Receipt Produced"]
[null,"(iii)","Address of the landlord:",null,"1-22-333, Bhagya Nagar, Karimnagar",{"$nulls":9},"CPS"]
[{"$nulls":12},170400,null,91657]
[null,"(iv) ","PAN of the landlord :",null,null,0]
[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,""]
[null,"(iii)","Address of the lender :  ",null,""]
[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)","Repayment of Home Loan Principle",null,null,null,"",""]
[null,null,"f)","PLI",null,null,null,"",""]
[null,null,"g)","Invesment in Sukanya Samruddhi",null,null,null,"",""]
[null,null,"h)","SBI Life Insuracne",null,null,null,"",""]
[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)","CPS Employee Contribution Amount. PRAN 12563",null,null,null,41657,"Salary Deduction"]
[null,"(iii)","Section 80CCD",null,"PRAN NO:",0,null,50000,"Salary Deduction"]
[null,"(B) Other sections (e.g. 80E, 80G, 80TTA, etc.) under Chapter VI-A."]
[null,null,"(i) ","Interest on Housing Loan Advance U/s 24[B]",null,null,null,0,"-"]
[null,null,"(ii) ","80E-Interest on Educational Loan",null,null,null,0,"-"]
[null,null,"(iii)","No Indivdual Disability",null,null,null,0,"-"]
[null,null,"(iv)","Medical Insuracne Premium for Self, Spouse & Children U/S 80D",null,null,null,0,"-"]
[null,null,"(v)","Master Health Check up of parents (Senior Citizen) U/S 80D",null,null,null,0,"-"]
[null,null,"(vi)","E.W.F, S.W.F & CM Relief Fund U/s 80G",null,null,null,420,"Salary Deduction"]
[null,null,"(vii)","Employer Contribution towards NPS U/s 80CCD(2)",null,null,null,91657,"Amount equilent to my contribution"]
["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(Front)","index":4,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[34,4,34,5],[45,1,45,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, 2022",null,"March, 2023",null,"2023-24"]
[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.",970728]
[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.",970728]
["2.",null,"LESS: Allowance to the extent exempt under Section 10"]
[null,null,"a)","House Rent allowence","Rs.",81958]
[null,null,"b)","Other Allowance","Rs.",0]
[{"$nulls":4},"",null,null,null,"Rs.",81958]
["3.","BALANCE (1-2)",{"$nulls":6},"Rs.",888770]
["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.",836370]
["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.",91657]
[null,null,"d)","Income from House Property (U/s.24(vi))","Rs.",0]
["8.","GROSS TOTAL INCOME (6+7)",{"$nulls":6},"Rs.",928027]
["9.","A.   DEDUCTIONS UNDER CHAPER VI A (80C, 80CCC, 80CCD)",null,null,"GROSS AMOUNT",null,"QUALIFYING AMOUNT",null,"DEDUCTIBLE AMOUNT"]
[null,null,"a","CPS Employee Contribution Amount. PRAN 12563","Rs.",41657,"Rs.",41657,"Rs.",41657]
[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","Repayment of Home Loan Principle","","","","","",""]
[null,null,"g","PLI","","","","","",""]
[null,null,"h","Invesment in Sukanya Samruddhi","","","","","",""]
[null,null,"i","SBI Life Insuracne","","","","","",""]
[null,null,"j","Fixed Deposits in Bank More Than (5) years.","","","","","",""]
[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.",78377,"Rs.",78377,"Rs.",78377]
[null,null,"b","Additional Benefit Under NPS U/S 80CCD(1B) ","Rs.",50000,"Rs.",50000,"Rs.",50000]
[null,"AGGREGATE OF DEDUCTIBLE AMOUNT UNDER CHAPTER VI A (80C, 80CCC, 80CCD)",{"$nulls":6},"Rs.",128377]
[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":5,"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"]
[56175,"(Fifty six Thousand One Hundred and Seventy five rupees only)",0,0,56,1,75,"","","Fifty six","One","Seventy five",2,4,6,"",""," Thousand "," Hundred ","Fifty six Thousand One Hundred and Seventy five"]
[56176,"(Fifty six Thousand One Hundred and Seventy six rupees only)",0,0,56,1,76,"","","Fifty six","One","Seventy six",2,4,6,"",""," Thousand "," Hundred ","Fifty six Thousand One Hundred and Seventy six"]
[170400,"(One Lakh Seventy Thousand Four Hundred rupees only)",0,1,70,4,0,"","One","Seventy","Four","",2,3,5,""," Lakh "," Thousand "," Hundred ","One Lakh Seventy Thousand Four Hundred"]
[14200,"(Fourteen Thousand Two Hundred rupees only)",0,0,14,2,0,"","","Fourteen","Two","",2,3,5,"",""," Thousand "," Hundred ","Fourteen Thousand Two Hundred"]
[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 (Back)","index":6,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[28,0,28,9],[29,0,29,2],[30,0,30,2],[31,4,31,8],[33,6,33,9],[34,6,34,9],[21,1,21,7],[22,1,22,7],[24,3,24,7],[25,1,25,7],[26,2,26,9],[27,0,27,9],[15,1,15,7],[16,1,16,7],[17,1,17,7],[18,1,18,7],[19,1,19,7],[20,1,20,7],[0,1,1,3],[0,4,1,5],[0,6,1,7],[0,8,1,9],[13,1,13,5],[14,1,14,7]],"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,"No Handipcapped Dependent","Rs.",0,"Rs.",0]
[null,null,null,"No Indivdual Disability","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 parents (Senior Citizen) U/S 80D","Rs.",0,"Rs.",0]
[null,null,null,"Employer Contribution towards NPS Account ( GOVT Contribution ) U/S 80 CCD(2)",null,91657,null,91657]
[null,null,null,"Interest of House Building U/S 24(B)",null,0,null,0]
[null,null,null,"Interest of Educational Loan 80 E","Rs.",0,"Rs.",0]
[null,null,null,"EWF, SWF & CMRF","Rs.",420,"Rs.",420]
[null,null,null,"CMRF by self if any","Rs.",0,"Rs.",0]
[null,null,null,"Sri Ram Janma Bhoomi Teerth Kshetra Under Secion 80G (2)(b)","Rs.",0,"Rs.",0]
[null,null,null,"Total Under Sections 80G, 80E, 80DD etc…","Rs.",0,"Rs.",0,"Rs.",92077]
["10.","AGGREGATE OF DEDUCTABLE AMOUNT UNDER CHAPER VI-A (A+B)",{"$nulls":6},"Rs.",220454]
["11.","TOTAL INCOME (8-10)",{"$nulls":6},"Rs.",707570]
["12.","TAX ON TOTAL INCOME",{"$nulls":6},"Rs.",54014]
[13,"TAX Rebate U/S 87A ( Rs. 12500/- Rebate upto Rs. 5,00,000/- Taxable Income)",{"$nulls":6},"Rs.",0]
[14,"TAX ON TOTAL INCOME AFTER REBATE",{"$nulls":6},"Rs.",54014]
[15,"Education Cess @ 4% for Primary Education on Tax payable at Sl No. 14",{"$nulls":6},"Rs.",2161]
[16,"TAX PAYABLE (14+15)",{"$nulls":6},"Rs.",56175]
[17,"Relief Under Section 89 (Adv. Tax Paid - attach details)",{"$nulls":6},"Rs.",0]
[18,"NET TAX PAYABLE  (15 - 16)",{"$nulls":6},"Rs.",56175]
[19,"Less:"]
[null,null,"(a)","Tax deducted at source under Section 192 (I)",null,null,""]
[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},"Rs.",0]
[20,"Tax Payable / Refundable (18-19)",{"$nulls":6},"Rs.",56175]
[null,null,"TAX PAYABLE : (Fifty six Thousand One Hundred and Seventy five rupees only)"]
["DETAILS OF TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT\nAMOUNT           DATE OF PAYMENT                       NAME OF THE BANK & BRANCH WHERE TAX DEPOSITED\n\n\n\n  \n  \n\n  \n  \n\n"]
["                 I, Sri/Smt. ABCDEFXYZ working in the capacity of  HEADMASTER  do here by certify that a sum of Rs. 56175 (Fifty six Thousand One Hundred and Seventy five 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":"Rent Rec","index":7,"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 170400.00  in words (One Lakh Seventy Thousand Four Hundred rupees only)  towards rent as tenant Annual House Rent @ Rs. 14200 per month in respect of my house H.No. 1-22-333, Bhagya Nagar, Karimnagar  for the period of Mar, 2022 to Feb, 2023."]
[{"$nulls":10},"PAN of the House Owner: "]
["PAN of the House Owner: "]
[{"$nulls":10},14200,12,170400]
[{"$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,"MSN Reddy"]
[null,null,"Address:",null,null,"1-22-333, Bhagya Nagar, Karimnagar"]
[]
["      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":8,"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(1)","index":9,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"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 2021-22"]
[]
[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(2)","index":10,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"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.",970728,null,null,"No",1299582,5468,0]
[2,"Salary received in arrears or advance",{"$nulls":4},"Rs.",0,null,null,"No",526252,2568,0]
[3,"Total income (as increased by salary received in arrears or advance)",{"$nulls":4},"Rs.",970728,null,null,"No",498529,1251,0]
[4,"Tax on total income (as per item 3)",{"$nulls":4},"Rs.",110912,null,null,"No",378521,2658,0]
[5,"Tax on total income (as per item 1)",{"$nulls":4},"Rs.",110912,null,null,null,970728,970728,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 2021-22",null,0,0,0,0,0,null,0,null,"No",1299582,5468,210470,212176]
["FY 2020-21",null,0,0,0,0,0,null,0,null,"No",526252,2568,18460,18995]
["FY 2019-20",null,0,0,0,0,0,null,0,null,"No",498529,1251,0,0]
["FY 2018-19",null,0,0,0,0,0,null,0,null,"No",378521,2658,6683,6821]
["Total",{"$nulls":7},0]

{"sheet":"10E Caluculation","index":11,"n_rows":24,"n_cols":39,"rows_kept":24,"cut":false,"hidden":true,"merged":[[9,9,9,10],[10,9,10,10],[11,9,11,10],[4,25,4,26],[8,25,8,26],[12,25,12,26],[13,8,13,11],[15,14,16,14],[1,9,1,10],[2,9,2,10],[3,9,3,10],[4,9,4,10],[5,9,5,10],[14,8,14,14],[6,9,6,10],[7,9,7,10],[12,9,12,10],[1,12,1,13],[2,12,2,13],[3,12,3,13],[4,12,4,13],[5,12,5,13],[6,12,6,13],[7,12,7,13],[8,12,8,13],[8,9,8,10],[9,12,9,13],[10,12,10,13],[11,12,11,13],[12,12,12,13],[13,12,13,13],[1,14,13,14],[0,8,0,14],[0,16,0,22],[1,17,1,18],[1,20,1,21],[1,22,13,22],[2,17,2,18],[2,20,2,21],[3,17,3,18],[3,20,3,21],[4,17,4,18],[4,20,4,21],[5,17,5,18],[5,20,5,21],[6,17,6,18],[6,20,6,21],[7,17,7,18],[7,20,7,21],[8,17,8,18],[8,20,8,21],[9,17,9,18],[9,20,9,21],[10,17,10,18],[10,20,10,21],[11,17,11,18],[11,20,11,21],[12,17,12,18],[12,20,12,21],[13,16,13,19],[13,20,13,21],[14,16,14,22],[15,22,16,22],[0,24,0,30],[1,25,1,26],[1,28,1,29],[1,30,13,30],[2,25,2,26],[2,28,2,29],[3,25,3,26],[3,28,3,29],[4,28,4,29],[5,25,5,26],[5,28,5,29],[6,25,6,26],[6,28,6,29],[7,25,7,26],[7,28,7,29],[8,28,8,29],[9,25,9,26],[9,28,9,29],[10,25,10,26],[10,28,10,29],[11,25,11,26],[11,28,11,29],[12,28,12,29],[13,24,13,27],[13,28,13,29],[14,24,14,30],[15,30,16,30],[0,32,0,38],[1,33,1,34],[1,36,1,37],[1,38,13,38],[2,33,2,34],[2,36,2,37],[3,33,3,34],[3,36,3,37],[4,33,4,34],[4,36,4,37],[5,33,5,34],[5,36,5,37],[6,33,6,34],[6,36,6,37],[7,33,7,34],[7,36,7,37],[8,33,8,34],[8,36,8,37],[9,33,9,34],[9,36,9,37],[10,33,10,34],[10,36,10,37],[11,33,11,34],[11,36,11,37],[12,33,12,34],[12,36,12,37],[13,32,13,35],[13,36,13,37],[14,32,14,38],[15,38,16,38],[0,1,0,7],[1,2,1,3],[1,5,1,6],[1,7,13,7],[2,2,2,3],[2,5,2,6],[3,2,3,3],[3,5,3,6],[4,2,4,3],[4,5,4,6],[5,2,5,3],[5,5,5,6],[6,2,6,3],[6,5,6,6],[7,2,7,3],[7,5,7,6],[8,2,8,3],[8,5,8,6],[9,2,9,3],[9,5,9,6],[10,2,10,3],[10,5,10,6],[14,1,14,7],[15,7,16,7],[11,2,11,3],[11,5,11,6],[12,2,12,3],[12,5,12,6],[13,1,13,4],[13,5,13,6]],"flags":["formulas_cached_only"]}
[null,"FY 2022-23",{"$nulls":6},"FY 2021-22",{"$nulls":7},"FY 2020-21",{"$nulls":7},"FY 2019-20",{"$nulls":7},"FY 2018-19"]
[null,"Details","Amount",null,"Details","Amount",null,null,"Details","Amount",null,"Details","Amount",null,null,null,"Details","Amount",null,"Details","Amount",null,null,null,"Details","Amount",null,"Details","Amount",null,null,null,"Details","Amount",null,"Details","Amount"]
[null,"Total Taxable Income (Excluding Arrears)",970728,null,"Total Taxable Income (Excluding Arrears)",970728,null,null,"Total Taxable Income (Excluding Arrears)",1299582,null,"Total Taxable Income (Excluding Arrears)",1299582,null,null,null,"Total Taxable Income (Excluding Arrears)",526252,null,"Total Taxable Income (Excluding Arrears)",526252,null,null,null,"Total Taxable Income (Excluding Arrears)",498529,null,"Total Taxable Income (Excluding Arrears)",498529,null,null,null,"Total Taxable Income (Excluding Arrears)",378521,null,"Total Taxable Income (Excluding Arrears)",378521]
[null,"Arrears Recieved",0,null,"Arrears Recieved",0,null,null,"Arrears Recieved",5468,null,"Arrears Recieved",0,null,null,null,"Arrears Recieved",2568,null,"Arrears Recieved",0,null,null,null,"Arrears Recieved",1251,null,"Arrears Recieved",0,null,null,null,"Arrears Recieved",2658,null,"Arrears Recieved",0]
[null,"Total Taxable Amount",970728,null,"Total Taxable Amount",970728,null,null,"Total Taxable Amount",1305050,null,"Total Taxable Amount",1299582,null,null,null,"Total Taxable Amount",528820,null,"Total Taxable Amount",526252,null,null,null,"Total Taxable Amount",499780,null,"Total Taxable Amount",498529,null,null,null,"Total Taxable Amount",381179,null,"Total Taxable Amount",378521]
[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,null,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]
[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,null,null,null,"2,50,001 to 5,00,000 @ 5%",12489,null,"2,50,001 to 5,00,000 @ 5%",12426,null,null,null,"2,50,001 to 5,00,000 @ 5%",6559,null,"2,50,001 to 5,00,000 @ 5%",6426]
[null,"5,00,000 to 10,00,000 @ 20%",94146,null,"5,00,000 to 10,00,000 @ 20%",94146,null,null,"5,00,000 to 10,00,000 @ 20%",100000,null,"5,00,000 to 10,00,000 @ 20%",100000,null,null,null,"5,00,000 to 10,00,000 @ 20%",5764,null,"5,00,000 to 10,00,000 @ 20%",5250,null,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]
[null,"above 10,00,001 @ 30%",0,null,"above 10,00,001 @ 30%",0,null,null,"above 10,00,001 @ 30%",91515,null,"above 10,00,001 @ 30%",89875,null,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,null,null,null,"above 10,00,001 @ 30%",0,null,"above 10,00,001 @ 30%",0]
[null,"Tax Rebate US 87A",0,null,"Tax Rebate US 87A",0,null,null,"Tax Rebate US 87A",0,null,"Tax Rebate US 87A",0,null,null,null,"Tax Rebate US 87A",0,null,"Tax Rebate US 87A",0,null,null,null,"Tax Rebate US 87A",12489,null,"Tax Rebate US 87A",12426,null,null,null,"Tax Rebate US 87A",0,null,"Tax Rebate US 87A",0]
[null,"Total",106646,null,"Total",106646,null,null,"Total",204015,null,"Total",202375,null,null,null,"Total",18264,null,"Total",17750,null,null,null,"Total",0,null,"Total",0,null,null,null,"Total",6559,null,"Total",6426]
[null,"Education Cess @ 4%",4266,null,"Education Cess @ 4%",4266,null,null,"Education Cess @ 4%",8161,null,"Education Cess @ 4%",8095,null,null,null,"Education Cess @ 4%",731,null,"Education Cess @ 4%",710,null,null,null,"Education Cess @ 4%",0,null,"Education Cess @ 4%",0,null,null,null,"Education Cess @ 4%",262,null,"Education Cess @ 4%",257]
[null,"Total Net Tax",110912,null,"Total Net Tax",110912,null,null,"Total Net Tax",212176,null,"Total Net Tax",210470,null,null,null,"Total Net Tax",18995,null,"Total Net Tax",18460,null,null,null,"Total Net Tax",0,null,"Total Net Tax",0,null,null,null,"Total Net Tax",6821,null,"Total Net Tax",6683]
[null,"Difference",null,null,null,0,null,null,"Difference",null,null,null,1706,null,null,null,"Difference",null,null,null,535,null,null,null,"Difference",null,null,null,0,null,null,null,"Difference",null,null,null,138]
[]
[{"$nulls":5},0,null,"TAX %","FY 2021-22 Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?","No",null,"F Y 2021-22 Arrears Amount",5468,null,"TAX %",null,"FY 2020-21 Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?","No",null,"F Y 2020-21 Arrears Amount",2568,null,"TAX %",null,"FY 2019-20 Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?","No",null,"F Y 2019-20 Arrears Amount",1251,null,"TAX %",null,"FY 2018-19 Arreras రిలీఫ్ పొందాలనుకుంటున్నారా?","No",null,"F Y 2018-19 Arrears Amount",2658,null,"TAX %"]
[null,"FY 2022-23",970728,null,"FY 2022-23",970728,null,null,"FY 2021-22",1305050,null,"FY 2021-22",1299582,null,null,null,"FY 2020-21",528820,null,"FY 2020-21",526252,null,null,null,"FY 2019-20",499780,null,"FY 2019-20",498529,null,null,null,"FY 2018-19",381179,null,"FY 2018-19",378521]
[null,250000,250000,0,250000,250000,0,0,250000,250000,0,250000,250000,0,0,null,250000,250000,0,250000,250000,0,0,null,250000,250000,0,250000,250000,0,0,null,250000,250000,0,250000,250000,0,0]
[null,720728,250000,12500,720728,250000,12500,5,1055050,250000,12500,1049582,250000,12500,5,null,278820,250000,12500,276252,250000,12500,5,null,249780,249780,12489,248529,248529,12426,5,null,131179,131179,6559,128521,128521,6426,5]
[null,470728,470728,94146,470728,470728,94146,20,805050,500000,100000,799582,500000,100000,20,null,28820,28820,5764,26252,26252,5250,20,null,0,0,0,0,0,0,20,null,0,0,0,0,0,0,20]
[null,0,0,0,0,0,0,30,305050,305050,91515,299582,299582,89875,30,null,0,0,0,0,0,0,30,null,0,0,0,0,0,0,30,null,0,0,0,0,0,0,30]
[null,"Total Tax",null,106646,"Total Tax",null,106646,null,"Total Tax",null,204015,"Total Tax",null,202375,null,null,"Total Tax",null,18264,"Total Tax",null,17750,null,null,"Total Tax",null,12489,"Total Tax",null,12426,null,null,"Total Tax",null,6559,"Total Tax",null,6426]
[null,"Rebate",null,0,"Rebate",null,0,null,"Rebate",null,0,"Rebate",null,0,null,null,"Rebate",null,0,"Rebate",null,0,null,null,"Rebate",null,12489,"Rebate",null,12426,null,null,"Rebate",null,0,"Rebate",null,0]
[null,"NET TAX",970728,106646,"NET TAX",970728,106646,null,"NET TAX",1305050,204015,"NET TAX",1299582,202375,null,null,"NET TAX",528820,18264,"NET TAX",526252,17750,null,null,"NET TAX",499780,0,"NET TAX",498529,0,null,null,"NET TAX",381179,6559,"NET TAX",378521,6426]

{"sheet":"A","index":12,"n_rows":85,"n_cols":79,"rows_kept":85,"cut":false,"hidden":true,"merged":[[18,1,18,6],[19,1,19,6],[20,1,20,9],[22,0,22,1],[0,0,1,0],[0,1,1,1],[1,49,1,58],[1,60,1,73],[0,2,0,11],[46,1,46,6],[62,1,62,6],[75,1,75,6],[37,9,37,10],[0,12,0,19],[0,20,1,20],[23,1,23,7]],"flags":["formulas_cached_only"]}
["Sl No.","Month","PAY PARTICULARS",{"$nulls":9},"DEDUCTIONS",{"$nulls":7},"NET PAY",{"$nulls":26},"NO"]
[null,null,"Basic Pay","PP/FP/Spl. Pay","TS_SP","HM Allowance","H.R.A.","D.A.","CCA","PHC","PRC Arrears","Gross Pay","CPS","APGLI","GIS","PT","Adv. Tax","CMRF Caluculation","EWF/ SWF/ CMRF etc","Total Deduc",null,2,null,null,"CPS","GPF",{"$nulls":20},"DA %","PHC",null,"Increment",{"$nulls":10},"AAS"]
[1,"Mar, 2022",62110,0,360,0,6832,10739,0,0,0,80041,7285,3000,60,200,0,null,null,10545,69496,2,7285,0,7285,5000,"Month","GPF",3000,"Month","APGLI",60,"Month","GIS",11,"Month","HRA",0,"Month","HM",0,"Month","CCA",0,"Month","Sp Pay",17.29,0,0,null,null,null,60480,"last Pay","Pay",null,60480,"Month","HRA",{"$nulls":4},0,"last Pay","Date",17,null,null,60480,60480,"Month","AAS Month","HRA","0","No",null,"DA Arrears"]
[2,"Apr, 2022",62110,0,360,0,6832,10739,0,0,0,80041,7285,3000,60,200,0,null,null,10545,69496,2,7285,0,7285,5000,"No Change",0,3000,"No Change",0,60,"No Change",60,11,"No Change",20,0,"No Change",0,0,"No Change",0,0,"No Change",0,17.29,0,0,19000,640,0,1630,"Incr","Jan, 2022",60480,62110,"Mar",62110,null,19000,640,0,0,"Incr","Month","Oct","0",62110,62110,60480,"Mar","0",0,"0",31,null,"0","0"]
[3,"May, 2022",62110,0,360,0,6832,10739,0,0,0,80041,7285,3000,60,200,0,null,null,10545,69496,2,7285,0,7285,5000,"No Change",0,3000,"No Change",0,60,"No Change",60,11,"No Change",20,0,"No Change",0,0,"No Change",0,0,"No Change",0,17.29,0,0,19640,640,0,62110,"Pres Pay","Feb, 2022",60480,62110,"Mar",62110,null,19640,640,0,0,"Pres Pay",0,16,"0",62110,62110,60480,"Apr","0",0,"0",30,null,"0","0"]
[4,"Jun, 2022",62110,0,360,0,6832,10739,0,0,0,80041,7285,3000,60,200,0,null,null,10545,69496,2,7285,0,7285,5000,"No Change",0,3000,"No Change",0,60,"No Change",60,11,"No Change",20,0,"No Change",0,0,"No Change",0,0,"No Change",0,17.29,0,0,20280,640,0,null,null,"Increment Month","Mar",62110,"Mar",62110,null,20280,640,0,null,null,null,-16,"0",62110,62110,60480,"May","0",0,"0",31,null,"0","0"]
[5,"Jul, 2022",62110,0,360,0,6832,10739,0,0,0,80041,7285,3000,60,200,0,null,null,10545,69496,2,7285,0,7285,5000,"No Change",0,3000,"No Change",0,60,"No Change",60,11,"No Change",20,0,"No Change",0,0,"No Change",0,0,"No Change",0,17.29,0,0,20920,660,0,{"$nulls":4},62110,"Mar",62110,null,20920,660,0,{"$nulls":4},"0",62110,62110,60480,"Jun","0",0,"0",30,null,"0","0"]
[6,"Aug, 2022",62110,0,360,0,6832,10739,0,0,0,80041,7285,3000,60,200,0,null,null,10545,69496,2,7285,0,7285,5000,"No Change",0,3000,"No Change",0,60,"No Change",60,11,"No Change",20,0,"No Change",0,0,"No Change",0,0,"No Change",0,17.29,0,0,21580,660,0,{"$nulls":4},62110,"Mar",62110,null,21580,660,0,{"$nulls":4},"0",62110,62110,60480,"Jul","0",0,"0",31,null,"0","0"]
[7,"Sep, 2022",62110,0,360,0,6832,10739,0,0,0,80041,7285,3000,60,200,0,null,null,10545,69496,2,7285,0,7285,5000,"No Change",0,3000,"No Change",0,60,"No Change",60,11,"No Change",20,0,"No Change",0,0,"No Change",0,0,"No Change",0,17.29,0,0,22240,660,0,{"$nulls":4},62110,"Mar",62110,null,22240,660,0,{"$nulls":4},"0",62110,62110,60480,"Aug","0",0,"0",31,null,"0","0"]
[8,"Oct, 2022",62110,0,360,0,6832,10739,0,0,0,80041,7285,3000,60,200,0,null,null,10545,69496,2,7285,0,7285,5000,"No Change",0,3000,"No Change",0,60,"No Change",60,11,"No Change",20,0,"No Change",0,0,"No Change",0,0,"No Change",0,17.29,0,0,22900,690,0,{"$nulls":4},62110,"Mar",62110,null,22900,690,0,{"$nulls":4},"0",62110,62110,60480,"Sep","0",0,"0",30,null,"0","0"]
[9,"Nov, 2022",62110,0,360,0,6832,10739,0,0,0,80041,7285,3000,60,200,0,2070,0,12615,67426,2,7285,0,7285,5000,"No Change",0,3000,"No Change",0,60,"No Change",60,11,"No Change",20,0,"No Change",0,0,"No Change",0,0,"No Change",0,17.29,0,0,23590,690,0,{"$nulls":4},62110,"Mar",62110,null,23590,690,0,{"$nulls":4},"0",62110,62110,60480,"Oct","0",0,"0",31,null,"0","0"]
[10,"Dec, 2022",62110,0,360,0,6832,10739,0,0,0,80041,7285,3000,60,200,0,null,null,10545,69496,2,7285,0,7285,5000,"No Change",0,3000,"No Change",0,60,"No Change",60,11,"No Change",20,0,"No Change",0,0,"No Change",0,0,"No Change",0,17.29,0,0,24280,690,0,{"$nulls":4},62110,"Mar",62110,null,24280,690,0,{"$nulls":4},"0",62110,62110,60480,"Nov","0",0,"0",30]
[11,"Jan, 2023",62110,0,360,0,6832,10739,0,0,0,80041,7285,3000,60,200,0,null,null,10545,69496,2,7285,0,7285,5000,"No Change",0,3000,"No Change",0,60,"No Change",60,11,"No Change",20,0,"No Change",0,0,"No Change",0,0,"No Change",0,17.29,0,0,24970,720,0,{"$nulls":4},62110,"Mar",62110,null,24970,720,0,{"$nulls":4},"0",62110,62110,60480,"Dec","0",0,"0",31]
[12,"Feb, 2023",62110,0,360,0,6832,12434,0,0,0,81736,7454,3000,60,200,56175,null,null,66889,14847,2,7454,0,7454,5000,"No Change",0,3000,"No Change",0,60,"No Change",60,11,"No Change",20,0,"No Change",0,0,"No Change",0,0,"No Change",0,20.02,0,0,25690,720,0,{"$nulls":4},62110,"Mar",62110,null,25690,720,0,{"$nulls":4},"0",62110,62110,60480,"Jan","0",0,"0",31]
[13,"Sur. Leave",0,null,null,null,0,0,0,null,null,0,0,{"$nulls":6},0,0,2,null,null,0,0,{"$nulls":23},26410,720,0,{"$nulls":4},62110,"Mar",62110,null,26410,720,0,{"$nulls":4},"0",62110,62110,60480,"Feb","0",0,"0",28]
[14,"AAS","0",0,0,0,"0","0",0,null,null,0,"0",null,null,0,null,null,null,0,0,2,null,null,"0",0,{"$nulls":23},27130,750,0,{"$nulls":8},27130,750,0,{"$nulls":4},0,{"$nulls":6},0,null,null,0]
[15,"Promotion",0,null,null,null,0,0,0,null,null,0,0,null,null,0,null,null,null,0,0,2,null,null,0,0,{"$nulls":23},27880,750,0,{"$nulls":8},27880,750,0]
[16,"Others",0,null,null,null,0,0,0,null,null,0,0,0,0,0,0,null,null,0,0,2,null,null,0,0,{"$nulls":23},28630,750,0,{"$nulls":8},28630,750,0,null,null,null,"Pay","DA","HRA","Gross","CPS","Net",null,"No","No","No","No","No","No"]
[17,"DA arrears (Jul-21 to Dec, 21)",{"$nulls":5},36324,null,null,null,36324,3630,{"$nulls":6},3630,32694,2,null,null,3630,36324,{"$nulls":23},29380,830,0,{"$nulls":8},29380,830,0,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"0","0","0","0","0","0"]
[18,{"$nulls":6},0,null,null,null,0,0,{"$nulls":6},0,0,2,null,null,0,0,{"$nulls":23},30210,830,0,{"$nulls":8},30210,830,0]
[19,"Child Education Concession",{"$nulls":9},0,0,{"$nulls":6},0,0,2,null,null,0,0,{"$nulls":23},31040,830,0,{"$nulls":8},31040,830,0]
[20,{"$nulls":18},0,0,"CPS",null,null,"CPS","CPS",{"$nulls":23},31870,940,0,{"$nulls":8},31870,940,0,null,62110,60480,1630,"0",null,null,"0"]
["TOTAL",null,750231,0,null,0,81984,134193,0,0,0,970728,91657,36000,720,2400,0,null,0,131197,839531,null,null,null,2,"0",{"$nulls":23},32810,940,0,{"$nulls":8},32810,940,0,null,62110,62110,0,"0","0",17.29,"0","0"]
[null,"DA ARREARS from Jul, 2019 to Oct, 2020",{"$nulls":47},33750,940,0,{"$nulls":8},33750,940,0,null,62110,62110,0,"0","0",17.29,"0","0"]
[null,"Month & Year","PAY  ","DA @ 17.290","DA @ 7.280","Diff","10% CPS","90% Net",{"$nulls":41},34690,1030,0,{"$nulls":8},34690,1030,0,null,62110,62110,0,"0","0",17.29,"0","0"]
[null,"July, 2021",60480,10457,4403,6054,605,5449,null,"Rent Paid",{"$nulls":39},35720,1030,0,{"$nulls":8},35720,1030,0,null,62110,62110,0,"0","0",17.29,"0","0"]
[null,"Aug, 2021",60480,10457,4403,6054,605,5449,null,170400,88442,81984,170426,{"$nulls":36},36750,1030,0,{"$nulls":8},36750,1030,0,null,62110,62110,0,"0","0",17.29,"0","0"]
[null,"Sept, 2021",60480,10457,4403,6054,605,5449,null,null,81958,null,14202.166666666666,{"$nulls":36},37780,1110,0,{"$nulls":8},37780,1110,0,null,62110,62110,0,"0","0",17.29,"0","0"]
[null,"Oct, 2021",60480,10457,4403,6054,605,5449,null,null,353770,{"$nulls":38},38890,1110,0,{"$nulls":8},38890,1110,0,null,62110,62110,0,"0","0",17.29,"0","0"]
[null,"Nov, 2021",60480,10457,4403,6054,605,5449,{"$nulls":41},40000,1110,0,{"$nulls":8},40000,1110,0,null,62110,62110,0,"0","0",17.29,"0","0"]
[null,"Dec, 2021",60480,10457,4403,6054,605,5449,null,970728,null,"Rented House",{"$nulls":37},41110,1190,0,{"$nulls":8},41110,1190,0,null,62110,62110,0,"0","0",17.29,"0","0"]
[null,"Jan, 2022",0,0,0,0,0,0,null,81984,{"$nulls":39},42300,1190,0,{"$nulls":8},42300,1190,0,null,62110,62110,0,"0","0",17.29,"0","0"]
[null,"Feb, 2022",0,0,0,0,0,0,null,81958,{"$nulls":39},43490,1190,0,{"$nulls":8},43490,1190,0,null,62110,62110,0,"0","0",17.29,"0","0"]
[null,"Mar, 2022",0,0,0,0,0,0,null,353770,{"$nulls":39},44680,1280,0,{"$nulls":8},44680,1280,0,null,"HRA",null,null,null,"0",null,null,"0"]
[null,"Apr, 2022",0,0,0,0,0,0,null,888770,{"$nulls":39},45960,1280,0,{"$nulls":8},45960,1280,0,null,11,{"$error":"#DIV/0!"},null,null,0,null,null,0]
[null,"May, 2022",0,0,0,0,0,0,null,888770,"0",888770,{"$nulls":37},47240,1280,0,{"$nulls":8},47240,1280,0]
[null,"Jun, 2022",0,0,0,0,0,0,{"$nulls":41},48520,1400,0,{"$nulls":8},48520,1400,0]
[null,"Jul, 2022",0,0,0,0,0,0,null,"DA Arrears",{"$nulls":39},49920,1400,0,{"$nulls":8},49920,1400,0]
[null,"Aug, 2022",0,0,0,0,0,0,null,"2019-20",36324,{"$nulls":38},51320,1400,0,{"$nulls":8},51320,1400,0]
[null,"Sep, 2022",0,0,0,0,0,0,null,"2020-21",0,{"$nulls":38},52720,1500,0,{"$nulls":8},52720,1500,0]
[null,"Oct, 2022",0,0,0,0,0,0,null,"Total",36324,{"$nulls":38},54220,1500,0,{"$nulls":8},54220,1500,0]
[null,"AAS",0,0,0,0,0,0,{"$nulls":41},55720,1500,0,{"$nulls":8},55720,1500,0]
[null,"SL 1",0,0,0,0,0,0,{"$nulls":41},57220,1630,0,{"$nulls":8},57220,1630,0]
[null,"SL 2",0,0,0,0,0,0,{"$nulls":41},58850,1630,0,{"$nulls":8},58850,1630,0]
[null,"TOTAL",362880,62742,26418,36324,3630,32694,{"$nulls":41},60480,1630,1630,{"$nulls":8},60480,1630,0]
[null,"CPS",null,null,null,3630,3630]
[null,"Surrender Amount from Mar, 2020 to Feb, 2021",{"$nulls":47},62110,1730,0,{"$nulls":8},62110,1730,0]
[null,"Month","Pay","DA",null,"HRA","Total","DA Arrears","30 Days Pay","15 Days Pay",null,"30 Days Pay","15 Days Pay",null,"30 Days Pay","15 Days Pay",{"$nulls":33},63840,1730,0,{"$nulls":8},63840,1730,0]
[null,"Mar, 2022",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},65570,1730,0,{"$nulls":8},65570,1730,0]
[null,"Apr, 2022",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},67300,1850,0,{"$nulls":8},67300,1850,0]
[null,"May, 2022",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},69150,1850,0,{"$nulls":8},69150,1850,0]
[null,"Jun, 2022",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},71000,1850,0,{"$nulls":8},71000,1850,0]
[null,"Jul, 2022",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},72850,1990,0,{"$nulls":8},72850,1990,0]
[null,"Aug, 2022",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},74840,1990,0,{"$nulls":8},74840,1990,0]
[null,"Sep, 2022",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},76830,1990,0,{"$nulls":8},76830,1990,0]
[null,"Oct, 2022",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},78820,2140,0,{"$nulls":8},78820,2140,0]
[null,"Nov, 2022",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},80960,2140,0,{"$nulls":8},80960,2140,0]
[null,"Dec, 2022",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},83100,2140,0,{"$nulls":8},83100,2140,0]
[null,"Jan, 2023",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},85240,2270,0,{"$nulls":8},85240,2270,0]
[null,"Feb, 2023",0,0,null,0,0,0,"0","0",null,"0","0",null,62110,31055,{"$nulls":33},87510,2270,0,{"$nulls":8},87510,2270,0]
[null,"Total",0,0,null,0,0,0,"Not Taken","Nov",{"$nulls":39},89780,2270,0,{"$nulls":8},89780,2270,0]
[{"$nulls":49},92050,2420,0,{"$nulls":8},92050,2420,0]
[null,"Surrender Amount from Jul, 2021 to Dec, 2021",{"$nulls":47},94470,2420,0,{"$nulls":8},94470,2420,0]
[null,"Month","Pay","DA",null,"HRA","Total",null,"30 Days Pay","15 Days Pay",null,"30 Days Pay","15 Days Pay",null,"30 Days Pay","15 Days Pay",{"$nulls":33},96890,2420,0,{"$nulls":8},96890,2420,0]
[null,"July, 2021",0,0,null,0,0,null,"0","0",null,"0","0",null,60480,30240,{"$nulls":33},99310,2560,0,{"$nulls":8},99310,2560,0]
[null,"Aug, 2021",0,0,null,0,0,null,"0","0",null,"0","0",null,60480,30240,{"$nulls":33},101870,2560,0,{"$nulls":8},101870,2560,0]
[null,"Sept, 2021",0,0,null,0,0,null,"0","0",null,"0","0",null,60480,30240,{"$nulls":33},104430,2560,0,{"$nulls":8},104430,2560,0]
[null,"Oct, 2021",0,0,null,0,0,null,"0","0",null,"0","0",null,60480,30240,{"$nulls":33},106990,2760,0,{"$nulls":8},106990,2760,0]
[null,"Nov, 2021",0,0,null,0,0,null,"0","0",null,"0","0",null,60480,30240,{"$nulls":33},109750,2760,0,{"$nulls":8},109750,2760,0]
[null,"Dec, 2021",0,0,null,0,0,null,"0","0",null,"0","0",null,60480,30240,{"$nulls":33},112510,2760,0,{"$nulls":8},112510,2760,0]
[null,"Jan, 2022",0,0,null,0,0,null,"0","0",null,"0","0",null,0,0,{"$nulls":33},115270,2960,0,{"$nulls":8},115270,2960,0]
[null,"Feb, 2022",0,0,null,0,0,null,"0","0",null,"0","0",null,0,0,{"$nulls":33},118230,2960,0,{"$nulls":8},118230,2960,0]
[null,"Total",0,0,null,0,0,null,"Not Taken","Nov",{"$nulls":39},121190,2960,0,{"$nulls":8},121190,2960,0]
[{"$nulls":49},124150,3160,0,{"$nulls":8},124150,3160,0]
[{"$nulls":49},127310,3160,0,{"$nulls":8},127310,3160,0]
[null,"PRC Arrears",{"$nulls":47},130470,3160,0,{"$nulls":8},130470,3160,0]
[{"$nulls":49},133630,3420,0,{"$nulls":8},133630,3420,0]
[null,1637,146,"CPS",{"$nulls":45},137050,3420,0,{"$nulls":8},137050,3420,0]
[null,3,3,438,{"$nulls":45},140470,3420,0,{"$nulls":8},140470,3420,0]
[null,4911,438,{"$nulls":46},143890,3420,0,{"$nulls":8},143890,3420,0]
[{"$nulls":49},147310,3690,0,{"$nulls":8},147310,3690,0]
[null,null,"DA Arrears",{"$nulls":46},151000,3690,0,{"$nulls":8},151000,3690,0]
[null,3438,{"$nulls":47},154690,3690,0,{"$nulls":8},154690,3690,0]
[null,0,{"$nulls":47},158380,3690,1630,{"$nulls":8},158380,3690,0]
[null,0,{"$nulls":47},162070,{"$nulls":10},162070]

{"sheet":"AA","index":13,"n_rows":98,"n_cols":16,"rows_kept":98,"cut":false,"hidden":true,"merged":[[88,10,88,12],[87,7,87,12],[88,7,88,9],[97,7,97,10],[1,2,1,12],[88,4,88,5],[97,2,97,3],[97,4,97,5],[87,1,87,5],[88,1,88,3]],"flags":["formulas_cached_only"]}
[]
[null,null,"Increment"]
[{"$nulls":5},60480,"last Pay",null,"Pay",null,60480,"Month","HRA","Jan, 2022"]
[null,null,13000,null,0,0,"Incr",null,"Jan, 2022",60480,60480,"Mar",60480,"Dec, 2021","July, 2021",60480]
[null,null,13390,390,0,60480,"Pres Pay",null,"Feb, 2022",60480,60480,"Mar",60480,"Nov, 2021","Aug, 2021",60480]
[null,null,13780,390,0,null,null,null,"Increment Month","Mar",60480,"Mar",60480,"Oct, 2021","Sept, 2021",60480]
[null,null,14170,390,0,{"$nulls":5},60480,"Mar",60480,"Sept, 2021","Oct, 2021",60480]
[null,null,14600,430,0,{"$nulls":5},60480,"Mar",60480,"Aug, 2021","Nov, 2021",60480]
[null,null,15030,430,0,{"$nulls":5},60480,"Mar",60480,"July, 2021","Dec, 2021",60480]
[null,null,15460,430,0,{"$nulls":5},60480,"Mar",60480,null,"Jan, 2022",60480]
[null,null,15930,470,0,{"$nulls":5},60480,"Mar",60480,null,"Feb, 2022",60480]
[null,null,16400,470,0,{"$nulls":5},60480,"Mar",60480,null,"Mar, 2022",62110]
[null,null,16870,470,0,{"$nulls":5},60480,"Mar",60480,null,"Apr, 2022",62110]
[null,null,17380,510,0,{"$nulls":5},60480,"Mar",60480,null,"May, 2022",62110]
[null,null,17890,510,0,{"$nulls":5},60480,"Mar",60480,null,"Jun, 2022",62110]
[null,null,18400,510,0,{"$nulls":9},"Jul, 2022",62110]
[null,null,18950,550,0,{"$nulls":9},"Aug, 2022",62110]
[null,null,19500,550,0,{"$nulls":9},"Sep, 2022",62110]
[null,null,20050,550,0,{"$nulls":9},"Oct, 2022",62110]
[null,null,20640,590,0,{"$nulls":9},"Nov, 2022",62110]
[null,null,21230,590,0,{"$nulls":9},"Dec, 2022",62110]
[null,null,21820,590,0,{"$nulls":9},"Jan, 2023",62110]
[null,null,22460,640,0,{"$nulls":9},"Feb, 2023",62110]
[null,null,23100,640,0]
[null,null,23740,640,0]
[null,null,24440,700,0]
[null,null,25140,700,0]
[null,null,25840,700,0]
[null,null,26600,760,0]
[null,null,27360,760,0]
[null,null,28120,760,0]
[null,null,28940,820,0]
[null,null,29760,820,0]
[null,null,30580,820,0]
[null,null,31460,880,0]
[null,null,32340,880,0]
[null,null,33220,880,0]
[null,null,34170,950,0]
[null,null,35120,950,0]
[null,null,36070,950,0]
[null,null,37100,1030,0]
[null,null,38130,1030,0]
[null,null,39160,1030,0]
[null,null,40270,1110,0]
[null,null,41380,1110,0]
[null,null,42490,1110,0]
[null,null,43680,1190,0]
[null,null,44870,1190,0]
[null,null,46060,1190,0]
[null,null,47330,1270,0]
[null,null,48600,1270,0]
[null,null,49870,1270,0]
[null,null,51230,1360,0]
[null,null,52590,1360,0]
[null,null,53950,1360,0]
[null,null,55410,1460,0]
[null,null,56870,1460,0]
[null,null,58330,1460,0]
[null,null,59890,1560,0]
[null,null,61450,1560,0]
[null,null,63010,1560,0]
[null,null,64670,1660,0]
[null,null,66330,1660,0]
[null,null,67990,1660,0]
[null,null,69750,1760,0]
[null,null,71510,1760,0]
[null,null,73270,1760,0]
[null,null,75150,1880,0]
[null,null,77030,1880,0]
[null,null,78910,1880,0]
[null,null,80930,2020,0]
[null,null,82950,2020,0]
[null,null,84970,2020,0]
[null,null,87130,2160,0]
[null,null,89290,2160,0]
[null,null,91450,2160,0]
[null,null,93780,2330,0]
[null,null,96110,2330,0]
[null,null,98440,2330,0]
[null,null,100770,2330,0]
[null,null,103290,2520,0]
[null,null,105810,2520,0]
[null,null,108330,2520,0]
[null,null,110850,2520]
[]
[]
[]
[null,"Old Slab",{"$nulls":5},"New Slab"]
[null,"Taxable Income",null,null,707570,null,null,"Taxable Income",null,null,707570]
[null,null,707570,{"$nulls":4},"Slab Rate","Slab Amount","Slab Income","Slab Rate of %","Tax"]
[null,250000,250000,250000,250000,0,null,250000,250000,250000,0,0,250000]
[null,457570,457570,500000,250000,12500,null,500000,250000,250000,5,12500,457570]
[null,207570,207570,250000,207570,41514,null,750000,250000,207570,10,20757,207570]
[null,0,0,null,0,0,null,1000000,250000,0,15,0,0]
[null,null,null,"",null,null,null,1250000,250000,0,20,0,0]
[null,null,0,null,0,null,null,1500000,250000,0,25,0,0]
[null,null,0,null,null,54014,null,"15,00,000+",null,0,30,0,0]
[null,null,"Total Tax",null,54014,null,null,"Total Tax",null,null,null,33257]