{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Master Sheet","GA-55","Tax Old Regime","Tax New Regime","Form 16","Hra Receipt"],"not_rendered":{"images":1,"macros":1,"external_links":1,"defined_names":338},"read":"whole","date_system":"1900"}

{"sheet":"Master Sheet","index":0,"n_rows":35,"n_cols":68,"rows_kept":35,"merged":[[0,0,0,1],[0,2,0,9],[0,11,0,12],[0,13,0,14],[0,16,0,19],[0,20,0,24],[0,25,0,29],[0,30,0,33],[0,34,0,36],[0,37,0,38],[0,39,0,65],[1,0,3,0],[1,1,3,1],[1,2,3,2],[1,3,3,3],[1,4,3,4],[1,5,3,5],[1,6,3,6],[1,7,1,8],[1,10,1,15],[1,16,1,63],[2,7,3,7],[2,8,3,8],[2,9,3,9],[2,10,3,10],[2,11,2,15],[2,16,3,16],[2,17,2,24],[2,25,3,25],[2,28,2,39],[2,40,2,51],[2,52,2,63],[2,64,2,65]]}
["Office Name",null,"Govt. Sr. Sec. School Gordhanpura, Atru Baran",{"$nulls":7},"TAN No.","JDHG09699E",null,"HRA",null,{"v":0.09,"d":"9%"},"DDO NAME",{"$nulls":3},"Rajendra Kumar Chittora",{"$nulls":4},"DDO FATHERS NAME",{"$nulls":4},"Bhanwar Lal",{"$nulls":3},"DDO PAN NUMBER",null,null,"ABCPC2588K"]
["S.N.","Employee Name","Designation","PAN No.","GPF/GPF 2004","Bank A/c No.","Mobile No.","Surender Payment",null,"Bonus","Allowances",{"$nulls":5},"Deductions"]
[{"$nulls":7},"Yes/No","Month","Yes/No"," Basic Pay March 2024","Arrear if Any - प्राप्त व कटौती जो एरियर से हुई",{"$nulls":4},"S.I. मासिक","वार्षिक राशि भरें",{"$nulls":7},"HRA Rebate",null,null,"GPF/GPF 2004",{"$nulls":11},"INCOME TAX",{"$nulls":11},"LIC",{"$nulls":11},"मकान किराए की रशीद के लिए"]
[{"$nulls":11},"Basic","D.A.","HRA","GPF Ded.","ITax ",null,"G.I.S","HITKARINIDHI","House Loan Interest ","Tution Fees","LIC-जो पेमेंट से नहीं काटी जाती","PLI","सुकन्या"," धारा 80DD",{"$nulls":3},"2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","मकान मालिक का नाम\t","पता"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,null,null,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]
[1,"Parmanand Meghwal","Senior Teacher","XXXXXXXX","GPF 2004",61146986773,9784379510,"Yes",9,"Yes",37800,0,0,0,0,0,5000,700,250,0,30000,0,0,0,0,52740,{"$f":"MROUND(ROUND(1.03*K6,0),100)","v":38900},{"$f":"K6*4*9%+AA6*8*9%+N6","v":41616},2850,{"$f":"AC6","v":2850},{"$f":"AD6","v":2850},2850,2850,2850,2850,2850,2850,2850,2850,2850,null,{"$f":"AO6","v":0},{"$f":"AP6","v":0},0,0,0,0,0,0,0,0,0,1200,{"$f":"BA6","v":1200},{"$f":"BB6","v":1200},1200,1200,1200,1200,1200,1200,1200,1200,1200,"Vikas Sharma","Village Kawai Salpura, The atru Dist. Baran","Yes","Yes"]
[2,"Rajendra Kumar Chittora","Principal","XXXXXXXX","GPF",61198238909,9784135222,"No",8,"No",90400,0,0,0,0,0,4000,700,500,200000,0,0,1200,14000,0,94212,{"$f":"MROUND(ROUND(1.03*K7,0),100)","v":93100},{"$f":"K7*4*9%+AA7*8*9%+N7","v":99576},8000,{"$f":"AC7","v":8000},{"$f":"AD7","v":8000},{"$f":"AE7","v":8000},{"$f":"AF7","v":8000},{"$f":"AG7","v":8000},{"$f":"AH7","v":8000},{"$f":"AI7","v":8000},{"$f":"AJ7","v":8000},{"$f":"AK7","v":8000},{"$f":"AL7","v":8000},{"$f":"AM7","v":8000},5000,{"$f":"AO7","v":5000},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,2400,{"$f":"BA7","v":2400},2400,2400,2400,2400,2400,2400,2400,2400,2400,2400,"Harishankar Sharma","Village Kawai Salpura, The atru Dist. Baran","No","No"]
[3,"Kailash Chandra Nagar","Senior Teacher","XXXXXXXX","GPF 2004",61024509630,9413635185,"Yes",4,"Yes",51400,0,0,0,0,0,3000,700,250,0,0,0,0,0,0,56592,52900,56592,2850,2850,2850,2850,2850,2850,2850,2850,2850,2850,2850,2850,5000,{"$f":"AO8","v":5000},5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,672,{"$f":"BA8","v":672},672,672,672,672,672,672,672,672,672,672,"Ankit Galav","Village Kawai Salpura, The atru Dist. Baran"]
[4,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO9","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA9","v":0},0,0,0,0,0,0,0,0,0,0,null,null,4]
[5,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO10","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA10","v":0},0,0,0,0,0,0,0,0,0,0,null,null,5]
[6,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO11","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA11","v":0},0,0,0,0,0,0,0,0,0,0,null,null,6]
[7,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO12","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA12","v":0},0,0,0,0,0,0,0,0,0,0,null,null,7,"GPF"]
[8,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO13","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA13","v":0},0,0,0,0,0,0,0,0,0,0,null,null,8,"GPF 2004"]
[9,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO14","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA14","v":0},0,0,0,0,0,0,0,0,0,0,null,null,9]
[10,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO15","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA15","v":0},0,0,0,0,0,0,0,0,0,0,null,null,10]
[11,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO16","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA16","v":0},0,0,0,0,0,0,0,0,0,0,null,null,11]
[12,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO17","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA17","v":0},0,0,0,0,0,0,0,0,0,0,null,null,12]
[13,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO18","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA18","v":0},0,0,0,0,0,0,0,0,0,0,null,null,1]
[14,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO19","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA19","v":0},0,0,0,0,0,0,0,0,0,0,null,null,2]
[15,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO20","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA20","v":0},0,0,0,0,0,0,0,0,0,0,null,null,3]
[16,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO21","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA21","v":0},0,0,0,0,0,0,0,0,0,0]
[17,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO22","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA22","v":0},0,0,0,0,0,0,0,0,0,0]
[18,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO23","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA23","v":0},0,0,0,0,0,0,0,0,0,0]
[19,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO24","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA24","v":0},0,0,0,0,0,0,0,0,0,0]
[20,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO25","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA25","v":0},0,0,0,0,0,0,0,0,0,0]
[21,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO26","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA26","v":0},0,0,0,0,0,0,0,0,0,0]
[22,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO27","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA27","v":0},0,0,0,0,0,0,0,0,0,0]
[23,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO28","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA28","v":0},0,0,0,0,0,0,0,0,0,0]
[24,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO29","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA29","v":0},0,0,0,0,0,0,0,0,0,0]
[25,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO30","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA30","v":0},0,0,0,0,0,0,0,0,0,0]
[26,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO31","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA31","v":0},0,0,0,0,0,0,0,0,0,0]
[27,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO32","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA32","v":0},0,0,0,0,0,0,0,0,0,0]
[28,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO33","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA33","v":0},0,0,0,0,0,0,0,0,0,0]
[29,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO34","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA34","v":0},0,0,0,0,0,0,0,0,0,0]
[30,{"$nulls":25},0,0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"AO35","v":0},0,0,0,0,0,0,0,0,0,0,null,{"$f":"BA35","v":0},0,0,0,0,0,0,0,0,0,0]

{"sheet":"GA-55","index":1,"n_rows":36,"n_cols":38,"rows_kept":36,"merged":[[0,2,0,28],[1,3,1,4],[1,5,1,7],[1,8,1,9],[1,10,1,13],[1,15,1,16],[1,18,1,20],[1,21,1,22],[1,23,1,26],[2,2,2,31],[3,2,3,28],[4,2,4,28],[5,3,6,7],[5,8,5,9],[5,10,5,13],[5,15,5,17],[5,20,5,22],[5,24,5,26],[5,27,5,28],[6,8,6,9],[6,12,6,19],[6,24,6,26],[6,27,6,28],[7,2,8,2],[7,3,7,13],[7,14,7,26],[7,28,8,28],[8,31,37,31],[37,2,37,28]]}
[null,null,"Please Install - Devlys 10 & Krutidev 10 Fonts"]
[{"$nulls":3},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,5,0)","v":"GPF 2004"},null,"Surrender",null,null,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,8,0)","v":"Yes"},null,"Surrender Month",{"$nulls":3},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,9,0)","v":9},"HRA",null,{"$f":"'Master Sheet'!P1","v":{"v":0.09,"d":"9%"}},"Bounus",null,null,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,10,0)","v":"Yes"},null,"Senior Citizen",{"$nulls":3},"No"]
[]
[null,null,{"$f":"'Master Sheet'!C1","v":"Govt. Sr. Sec. School Gordhanpura, Atru Baran"},{"$nulls":28},1]
[null,null,"INCOME TAX CALCULATION (GA-55) 2024-25"]
[null,null,"NAME :",{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,2,0)","v":"Parmanand Meghwal"},{"$nulls":6},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,3,0)","v":"Senior Teacher"},{"$nulls":3},"PAN :",{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,4,0)","v":"XXXXXXXX"},{"$nulls":3},"TAN:",{"$f":"'Master Sheet'!L1","v":"JDHG09699E"},{"$nulls":3},"A/C NO.",null,null,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,6,0)","v":61146986773}]
[{"$nulls":12},"RAJTEACHERS.NET",{"$nulls":11},"MOB NO.",null,null,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,7,0)","v":9784379510}]
[null,null,"Month","ALLOWANCES",{"$nulls":10},"DEDUCTIONS",{"$nulls":13},"Bill No. & T.V. No."]
[{"$nulls":3},"Basic Pay","Dearness Pay","Leave  Pay","Spl. Pay","D.A.","H.R.A.","Washing Allow.","ROP (If any, put the value in minus)","Other Allowance 1","Other Allowance 2","Gross  Salary",{"$f":"D2","v":"GPF 2004"},{"$f":"IF(D2=\"GPF\",\"GPF LOAN\",\"\")","v":""},"SI","SI LOAN + INT","RPMF/RGHS","LIC","G.I.S.","HBA Premium","HBA Interest","Income Tax / TDS","HITKARI NIDHI","Other","Total\nDeduction","Net Payment"]
[null,3,"2024-03-01",{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,11,0)","v":37800},0,0,0,{"$f":"ROUND(50%*D10,0)","v":18900},{"$f":"IF($R$2=18%,ROUND(0.18*D10,0),ROUND(0.09*D10,0))","v":3402},0,0,0,0,{"$f":"SUM(D10:M10)","v":60102},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,29,0)","v":2850},0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,17,0)","v":5000},0,{"$f":"IF(D10<18001,265,IF(D10<33501,440,IF(D10<54001,658,875)))","v":658},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,53,0)","v":1200},0,null,null,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,41,0)","v":0},null,null,{"$f":"SUM(O10:Y10)","v":9708},{"$f":"N10-AA10","v":50394},{"$nulls":4},4,{"$f":"IF(AG10='GA-55'!$O$2,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AH10=\"Yes\",ROUND(D11/2,0),0)","v":0},{"$f":"IF(AH10=\"Yes\",ROUND(H10/2,0),0)","v":0}]
[null,4,"2024-04-01",{"$f":"D10","v":37800},{"$f":"IF(E$10=0,0,ROUND(D11/2,0))","v":0},{"$f":"IF(F$10=0,0,F10)","v":0},0,{"$f":"ROUND(50%*D11,0)","v":18900},{"$f":"IF($R$2=18%,ROUND(0.18*D11,0),ROUND(0.09*D11,0))","v":3402},{"$f":"IF(J$10=0,0,J10)","v":0},{"$f":"IF(K$10=0,0,K10)","v":0},0,{"$f":"IF(M$10=0,0,M10)","v":0},{"$f":"SUM(D11:M11)","v":60102},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,30,0)","v":2850},{"$f":"P10","v":0},{"$f":"Q10","v":5000},{"$f":"R10","v":0},{"$f":"IF(D11<18001,265,IF(D11<33501,440,IF(D11<54001,658,875)))","v":658},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,54,0)","v":1200},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,18,0)","v":{"v":700,"d":"700.00"}},{"$f":"V10","v":0},0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,42,0)","v":0},0,null,{"$f":"SUM(O11:Y11)","v":10408},49694,{"$nulls":4},5,{"$f":"IF(AG11='GA-55'!$O$2,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AH11=\"Yes\",ROUND(D12/2,0),0)","v":0},{"$f":"IF(AH11=\"Yes\",ROUND(H11/2,0),0)","v":0}]
[null,5,"2024-05-01",37800,{"$f":"IF($E$10=0,0,ROUND(D12/2,0))","v":0},0,0,18900,3402,0,{"$f":"IF(K$10=0,0,K11)","v":0},{"$f":"IF(L$10=0,0,L11)","v":0},0,60102,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,31,0)","v":2850},{"$f":"P11","v":0},{"$f":"Q11","v":5000},{"$f":"R11","v":0},658,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,55,0)","v":1200},0,0,0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,43,0)","v":0},{"$f":"Y11","v":0},null,9708,50394,{"$nulls":4},6,{"$f":"IF(AG12='GA-55'!$O$2,\"Yes\",\"No\")","v":"No"},0,0]
[null,6,"2024-06-01",37800,0,0,0,18900,3402,0,0,0,0,60102,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,32,0)","v":2850},0,5000,0,658,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,56,0)","v":1200},0,0,0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,44,0)","v":0},{"$f":"Y12","v":0},null,9708,50394,{"$nulls":4},7,{"$f":"IF(AG13='GA-55'!$O$2,\"Yes\",\"No\")","v":"No"},0,0,{"$f":"AI13+AJ13","v":0},{"$f":"IF(AH13=\"yes\",ROUND(AI13*3/100,0))","v":false}]
[null,7,"2024-07-01",{"$f":"MROUND(ROUND(1.03*D13,0),100)","v":38900},0,{"$f":"IF(F$10=0,0,F13)","v":0},{"$f":"IF(G$10=0,0,G13)","v":0},19450,3501,{"$f":"IF(J$10=0,0,J13)","v":0},{"$f":"IF(K$10=0,0,K13)","v":0},{"$f":"IF(L$10=0,0,L13)","v":0},{"$f":"IF(M$10=0,0,M13)","v":0},61851,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,33,0)","v":2850},{"$f":"P13","v":0},{"$f":"Q13","v":5000},{"$f":"R13","v":0},658,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,57,0)","v":1200},0,{"$f":"V13","v":0},{"$f":"W13","v":0},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,45,0)","v":0},{"$f":"Y13","v":0},null,9708,52143,{"$nulls":4},8,{"$f":"IF(AG14='GA-55'!$O$2,\"Yes\",\"No\")","v":"No"},0,0,0,{"$f":"IF(AH14=\"yes\",ROUND(AI14*3/100,0))","v":false}]
[null,8,"2024-08-01",{"$f":"D14","v":38900},0,0,0,19450,3501,0,0,0,0,61851,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,34,0)","v":2850},null,5000,0,658,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,58,0)","v":1200},0,0,0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,45,0)","v":0},0,null,9708,52143,{"$nulls":4},9,{"$f":"IF(AG15='GA-55'!$O$2,\"Yes\",\"No\")","v":"Yes"},19450,9725,29175,584]
[null,9,"2024-09-01",38900,0,0,0,19450,3501,0,0,0,0,61851,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,35,0)","v":2850},0,5000,0,658,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,59,0)","v":1200},0,0,0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,47,0)","v":0},0,null,9708,52143,{"$nulls":4},10,{"$f":"IF(AG16='GA-55'!$O$2,\"Yes\",\"No\")","v":"No"},0,0,0,false]
[null,10,"2024-10-01",38900,0,{"$f":"IF(F$10=0,0,F16)","v":0},{"$f":"IF(G$10=0,0,G16)","v":0},19450,3501,0,0,0,0,61851,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,36,0)","v":2850},0,5000,0,658,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,60,0)","v":1200},0,0,0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,48,0)","v":0},0,null,9708,52143,{"$nulls":4},11,{"$f":"IF(AG17='GA-55'!$O$2,\"Yes\",\"No\")","v":"No"},0,0,0]
[null,11,"2024-11-01",38900,0,{"$f":"IF(F$10=0,0,F17)","v":0},0,{"$f":"ROUND(53%*D18,0)","v":20617},{"$f":"IF($R$2=20%,ROUND(0.2*D18,0),ROUND(0.1*D18,0))","v":3890},0,0,0,0,63407,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,37,0)","v":2850},null,5000,0,658,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,61,0)","v":1200},0,0,0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,49,0)","v":0},0,null,9708,53699,{"$nulls":4},12,{"$f":"IF(AG18='GA-55'!$O$2,\"Yes\",\"No\")","v":"No"},0,0]
[null,12,"2024-12-01",38900,0,{"$f":"IF(F$10=0,0,F18)","v":0},0,{"$f":"ROUND(53%*D19,0)","v":20617},{"$f":"IF($R$2=20%,ROUND(0.2*D19,0),ROUND(0.1*D19,0))","v":3890},0,0,0,0,63407,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,38,0)","v":2850},0,5000,0,658,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,62,0)","v":1200},0,0,0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,50,0)","v":0},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,19,0)","v":250},null,9958,53449,{"$nulls":4},1,{"$f":"IF(AG19='GA-55'!$O$2,\"Yes\",\"No\")","v":"No"},0,0]
[null,1,"2025-01-01",38900,0,{"$f":"IF(F$10=0,0,F19)","v":0},0,20617,3890,0,0,0,0,63407,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,39,0)","v":2850},0,5000,0,658,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,63,0)","v":1200},0,0,0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,51,0)","v":0},null,null,9708,53699,{"$nulls":4},2,{"$f":"IF(AG20='GA-55'!$O$2,\"Yes\",\"No\")","v":"No"},0,0]
[null,2,"2025-02-01",38900,0,{"$f":"IF(F$10=0,0,F20)","v":0},0,20617,3890,0,0,0,0,63407,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,40,0)","v":2850},0,5000,0,658,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,64,0)","v":1200},0,0,0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,52,0)","v":0},null,null,9708,53699,{"$nulls":4},3,{"$f":"IF(AG21='GA-55'!$O$2,\"Yes\",\"No\")","v":"No"},0,0]
[null,null,"DA Arrear 50%",{"$nulls":4},{"$f":"(ROUND(50%*D10,0)-ROUND(46%*D10,0))*2","v":3024},{"$nulls":5},{"$f":"H22","v":3024},{"$f":"H22","v":3024},{"$nulls":4},0,{"$nulls":6},3024,0,{"$nulls":6},{"$f":"SUM(AI10:AI21)","v":19450},{"$f":"SUM(AJ10:AJ21)","v":9725},29175,584]
[null,null,"DA Arrear 53%",{"$nulls":4},{"$f":"(ROUND(53%*D17,0)-ROUND(50%*D17,0))*4","v":4668},{"$nulls":5},{"$f":"H23","v":4668},{"$f":"H23","v":4668},{"$nulls":4},0,{"$nulls":6},{"$f":"SUM(O23:Y23)","v":4668},{"$f":"N23-AA23","v":0}]
[null,null,"Surrender",{"$f":"IF(I2=\"NO\",0,IF(O2=3,D21,VLOOKUP(O2,B10:D21,3,FALSE)))/2","v":19450},{"$nulls":3},{"$f":"IF(AND('GA-55'!O2>3,'GA-55'!O2<11),ROUND('GA-55'!D24*50%,0),IF(AND('GA-55'!O2>10,'GA-55'!O2<13),ROUND('GA-55'!D24*53%,0),ROUND('GA-55'!D24*53%,0)))","v":9725},{"$nulls":5},29175,{"$nulls":12},0,29175]
[null,null,"Bonus",{"$f":"IF(V2=\"Yes\",6774,0)","v":6774},{"$nulls":9},{"$f":"SUM(D25:M25)","v":6774},{"$f":"ROUND(D25*25/100,0)","v":1694},{"$nulls":11},1694,5080]
[null,null,"Surrender Arrear",{"$nulls":4},{"$f":"IF('GA-55'!I2=\"Yes\",AL22,0)","v":584},{"$nulls":5},{"$f":"SUM(D26:M26)","v":584},{"$nulls":12},0,584]
[null,null,"Salary Arrear 1",{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,12,0)","v":0},{"$nulls":3},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,13,0)","v":0},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,14,0)","v":0},{"$nulls":4},0,{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,15,0)","v":0},{"$nulls":8},{"$f":"VLOOKUP(AF4,'Master Sheet'!A6:BL35,16,0)","v":0},null,null,0,0]
[null,null,"Salary Arrear 2",{"$nulls":10},0,{"$nulls":12},0,0]
[null,null,"Salary Arrear 3",{"$nulls":10},0,{"$nulls":12},0,0]
[null,null,"Other ",null,0,0,{"$nulls":7},0,{"$nulls":12},0,0]
[null,null,"TOTAL",{"$f":"SUM(D10:D30)","v":488624},{"$f":"SUM(E10:E30)","v":0},0,0,253869,43172,0,0,0,0,785665,43586,0,60000,0,7896,14400,{"v":700,"d":"700.00"},0,0,0,250,0,126832,658833]
[]
[]
[]
[]
[{"$nulls":4},"Signature of Employee",{"$nulls":22},"Signature of DDO"]

{"sheet":"Tax Old Regime","index":2,"n_rows":65,"n_cols":19,"rows_kept":65,"merged":[[0,1,0,16],[1,1,1,16],[2,2,2,3],[2,4,2,9],[2,11,2,13],[2,15,2,16],[3,2,3,14],[4,2,4,14],[5,2,5,14],[6,2,6,14],[7,1,9,1],[7,2,7,11],[7,12,7,14],[7,15,8,16],[8,2,8,11],[8,12,8,14],[9,2,9,11],[9,12,9,14],[10,2,10,14],[11,1,13,1],[11,2,11,9],[11,10,11,11],[11,12,11,14],[11,15,13,16],[12,2,13,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,4,13,6],[13,7,13,9],[13,10,13,11],[13,12,13,14],[14,2,14,14],[15,2,15,14],[16,2,16,14],[17,2,17,14],[18,1,32,1],[18,2,18,16],[19,2,19,16],[20,3,20,6],[20,10,20,12],[20,15,29,16],[21,3,21,6],[21,10,21,12],[22,3,22,6],[22,10,22,12],[23,3,23,6],[23,10,23,12],[24,3,24,6],[24,10,24,12],[25,3,25,6],[25,10,25,12],[26,3,26,6],[26,10,26,12],[27,3,27,6],[27,10,27,12],[28,3,28,6],[28,10,28,12],[29,2,29,12],[30,2,30,14],[31,2,31,14],[32,2,32,14],[33,1,43,1],[33,2,33,16],[34,2,34,14],[35,2,35,14],[36,2,36,14],[37,2,37,14],[38,2,38,14],[39,2,39,14],[40,2,40,14],[41,2,41,14],[42,2,42,14],[43,2,43,14],[44,2,44,14],[45,2,45,14],[46,2,46,14],[47,1,57,1],[47,2,47,16],[48,2,48,6],[48,7,48,10],[48,11,48,14],[49,2,49,4],[49,5,49,6],[49,7,49,9],[49,11,49,13],[50,2,50,4],[50,5,50,6],[50,7,50,9],[50,11,50,13],[51,2,51,4],[51,5,51,6],[51,7,51,9],[51,11,51,13],[52,2,52,4],[52,5,52,6],[52,7,52,9],[52,11,52,13],[53,2,53,14],[54,2,54,14],[55,2,55,14],[56,2,56,14],[57,2,57,14],[58,2,58,14],[59,2,59,14],[60,1,61,1],[60,2,61,4],[60,5,60,8],[60,9,60,10],[60,12,60,13],[60,15,60,16],[61,5,61,8],[61,9,61,10],[61,12,61,13],[61,15,61,16],[62,1,62,14],[64,3,64,4],[64,12,64,15],[66,2,68,16],[69,11,75,16],[74,3,74,9]]}
[null,{"$f":"'GA-55'!C4","v":"Govt. Sr. Sec. School Gordhanpura, Atru Baran"},{"$nulls":16},{"$f":"'GA-55'!AF4","v":1}]
[null,"आयकर गणना प्रपत्र वर्ष 2024-25 (कर निर्धारण वर्ष 2025-26)"]
[null,1,"नाम कर्मचारी :",null,{"$f":"'GA-55'!D6","v":"Parmanand Meghwal"},{"$nulls":5},"पद :",{"$f":"'GA-55'!K6","v":"Senior Teacher"},null,null,"PAN :",{"$f":"IF('GA-55'!P6=\"\",\"\",'GA-55'!P6)","v":"XXXXXXXX"}]
[null,2,"आय: वर्ष-2024-25 में प्राप्त कुल वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"रु.",{"$f":"'GA-55'!N31","v":{"v":785665,"d":"785665.00"}}]
[null,3,"(i) गृह किराया, धारा 10(13-A) के अंतर्गत जो कर मुक्त हैं।",{"$nulls":12},"रु.",{"$f":"VLOOKUP(S1,'Master Sheet'!A6:BL55,26,0)","v":{"v":52740,"d":"52740.00"}}]
[null,null,"(ii) धारा 10(14) के अंतर्गत अन्य भत्ते ",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,4,"                                                शेष (2-3)",{"$nulls":12},"रु.",{"$f":"Q4-Q5-Q6","v":{"v":732925,"d":"732925.00"}}]
[null,5,"(i) मनोरंजन भत्ता धारा 16(ii) के अंतर्गत (अधिकतम सीमा रु. 5000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,null,"(ii) व्यवसाय कर धारा 16(iii) के अंतर्गत",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction) 50,000 (अधिकतम)",{"$nulls":9},{"$f":"IF(Q7<50000,Q7,50000)","v":{"v":50000,"d":"50000.00"}},null,null,"रु.",{"$f":"SUM(M8:O10)","v":{"v":50000,"d":"50000.00"}}]
[null,6,"                                                                                             शेष (4-5)",{"$nulls":12},"रु.",{"$f":"Q7-Q10","v":{"v":682925,"d":"682925.00"}}]
[null,7,"(अ) गृह संपत्ति से आय (1)स्वयं के उपयोग में शून्य",{"$nulls":7},"(2) प्राप्त किराया रु.",null,{"v":0,"d":"0.00"}]
[null,null,"(ब) घटाये",null,"किराए का 30%",null,null,"गृह ऋण पर ब्याज",null,null,"गृहकर",null,"योग 7(ब)"]
[{"$nulls":4},0,null,null,{"$f":"VLOOKUP(S1,'Master Sheet'!A6:BL55,20,0)","v":0},null,null,0,null,{"$f":"E14+H14+K14","v":0}]
[null,null,"                                            शेष -/+(7(अ) एवं योग 7(ब) का",{"$nulls":12},"रु.",{"$f":"M12-M14","v":{"v":0,"d":"0.00"}}]
[null,8,"                                                        कुल शेष -/+(6  एवं 7)",{"$nulls":12},"रु.",{"$f":"Q11+Q15","v":{"v":682925,"d":"682925.00"}}]
[null,9,"अन्य आय",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,10,"सकल आय                                                                                                                                          योग (8+9)",{"$nulls":12},"रु.",{"$f":"Q16+Q17","v":{"v":682925,"d":"682925.00"}}]
[null,11,"घटाइए कटौतियाँ - धारा US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1,50,000/- (धारा 80CCE) के अलावा"]
[null,null,"(i)","राज्य बीमा (SI)",{"$nulls":3},"रु.",{"$f":"'GA-55'!Q31","v":{"v":60000,"d":"60000.00"}},"(x)","पेंशन प्लान हेतु अंशदान धारा (80CCC)",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(ii)","जीवन बीमा प्रीमियम (LIC)",{"$nulls":3},"रु.",{"$f":"'GA-55'!T31+VLOOKUP(S1,'Master Sheet'!A6:BL55,22,0)","v":{"v":14400,"d":"14400.00"}},"(xi)","राष्ट्रीय बचत पत्र पर आदत्त ब्याज",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xii)","ट्यूशन फीस",null,null,"रु.",{"$f":"VLOOKUP(S1,'Master Sheet'!A6:BL55,21,0)","v":{"v":30000,"d":"30000.00"}}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xiii)"," इक्विटी लिंक सेविंग स्कीम",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम (NSS)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xv)","स्थगित वार्षिकी (Defferred Annuty)",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(vi)","सामान्य प्रावधायी निधि (GPF/GPF 2004)",{"$nulls":3},"रु.",{"$f":"'GA-55'!O31","v":{"v":43586,"d":"43586.00"}},"(xiv)","पी.एल.आई. (PLI)",null,null,"रु.",{"$f":"VLOOKUP(S1,'Master Sheet'!A6:BL55,23,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vii)","सामूहिक बीमा प्रीमियम (G.Ins.)",{"$nulls":3},"रु.",{"$f":"'GA-55'!U11","v":{"v":700,"d":"700.00"}},"(xvi)","अन्य जमा राशि (80C के अंतर्गत)",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(viii)","यू.एल.आई.पी./वार्षिक प्लान",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xvii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"रु.",{"$f":"VLOOKUP(S1,'Master Sheet'!A6:BL55,24,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ix)","गृह ऋण किश्त (HBA Premium)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xviii)",{"$nulls":3},"रु."]
[null,null,"योग (i से XViii) ",{"$nulls":10},"रु.",{"$f":"SUM(I21:I29)+SUM(O21:O29)","v":{"v":148686,"d":"148686.00"}}]
[null,null,"अधिकतम कटौती की राशि 1.50 लाख रु. तक",{"$nulls":12},"रु.",{"$f":"IF(O30<150001,ROUND(O30,0),150000)","v":{"v":148686,"d":"148686.00"}}]
[null,null,"(B) घटाइए - धारा 80CCD 1(B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रु. 50,000)",{"$nulls":12},"रु."]
[null,null,"योग 11(A+B+C)      ",{"$nulls":12},"रु.",{"$f":"SUM(Q31:Q32)","v":{"v":148686,"d":"148686.00"}}]
[null,12,"अन्य कटौतियाँ"]
[null,null,"1-धारा 80D, चिकित्सा बीमा प्रीमियम (स्वयं, पति/पत्नी व बच्चों के लिए रु. 25000, माता-पिता के लिए रु. 25000, सीनियर सिटीजन  रु. 50,000)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"2-धारा 80D, विकलांग आश्रितों के चिकित्सा आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80% या अधिक विकलांगता रु. 125000)",{"$nulls":12},"रु.",{"$f":"VLOOKUP(S1,'Master Sheet'!A6:BL55,25,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"3-धारा 80D विशीष्ट रोगों के उपचार हेतु कटौती (अधिकतम रु. 40,000 , सीनियर सिटीजन  हेतु रु. 100,000)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"4-धारा 80D, उच्च शिक्षा हेतु लिए ऋण का ब्याज",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"5-धारा 80G धर्मार्थ संस्थाओं आदि को दिये दान (क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"6-धारा 80U स्थाई रूप से शारीरिक असमर्थता की दशा में (अधिकतम 75,000 तथा अधिनियम 1995 के अनुसार 125,000)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"7-धारा 80 TTA बचत खाते पर अधिकतम ब्याज रु. 10,000 194(1A) (80TTB-वरिष्ठ नागरिक अधिकतम ब्याज 50,000 रु.)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"8-धारा  80GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"9-धारा 80GGC राजनीतिक पार्टियों को दिया गया दान ",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"कुल योग 12 (1 से 9 तक)",{"$nulls":12},"रु.",{"$f":"SUM(Q35:Q43)","v":{"v":0,"d":"0.00"}}]
[null,13,"कुल कटौती ( 11 + 12)",{"$nulls":12},"रु.",{"$f":"Q33+Q44","v":{"v":148686,"d":"148686.00"}}]
[null,14,"कर योग्य आय ( 10-13 )",{"$nulls":12},"रु.",{"$f":"(Q18-Q45)","v":{"v":534239,"d":"534239.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणज में करना) धारा 288A",{"$nulls":12},"रु.",{"$f":"ROUND(Q46,-1)","v":{"v":534240,"d":"534240.00"}}]
[null,16,"आय की गणना उपरोक्त कॉलम 15 के आधार पर "]
[null,null,"एक व्यक्ति कर दाता",{"$nulls":4},"वरिष्ठ नागरिक (60 से 80 वर्ष तक)",{"$nulls":3},"80 वर्ष या अधिक आयु"]
[null,null,"2,50,000 तक",null,null,"Nil",null,"3,00,000 तक",null,null,"Nil","3,00,000 तक",null,null,"Nil","रु.",{"v":0,"d":"0.00"}]
[null,null,"2,50,001-5,00,000",null,null,{"v":0.05,"d":"5%"},null,"3,00,001-5,00,000",null,null,{"v":0.05,"d":"5%"},"5,00,000 तक",null,null,{"v":0.05,"d":"5%"},"रु.",{"$f":"ROUND(IF('GA-55'!AB2=\"No\",IF(Q47<250001,0,IF(Q47>500000,12500,((Q47-250000)*0.05))),IF(Q47<300001,0,IF(Q47>500000,10000,((Q47-300000)*0.05)))),0)","v":{"v":12500,"d":"12500.00"}}]
[null,null,"5,00,001-10,00,000",null,null,{"v":0.2,"d":"20%"},null,"5,00,001-10,00,000",null,null,{"v":0.2,"d":"20%"},"5,00,001-10,00,000",null,null,{"v":0.2,"d":"20%"},"रु.",{"$f":"IF(Q47<500001,0,IF(Q47>1000000,100000,((Q47-500000)*0.2)))","v":{"v":6848,"d":"6848.00"}}]
[null,null,"10,00,000 से अधिक",null,null,{"v":0.3,"d":"30%"},null,"10,00,000 से अधिक",null,null,{"v":0.3,"d":"30%"},"10,00,000 से अधिक",null,null,{"v":0.3,"d":"30%"},"रु.",{"$f":"IF(Q47<1000001,0,((Q47-1000000)*0.3))","v":{"v":0,"d":"0.00"}}]
[null,null,"(1) योग आयकर",{"$nulls":12},"रु.",{"$f":"SUM(Q50:Q53)","v":{"v":19348,"d":"19348.00"}}]
[null,null,"(2) छूट धारा 87(A) (2.50 लाख से 5.00 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रु. 12,500 तक)",{"$nulls":12},"रु.",{"$f":"IF(Q47>500000,0,IF(Q54<12501,Q54,12500))","v":{"v":0,"d":"0.00"}}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":12},"रु.",{"$f":"Q54-Q55","v":{"v":19348,"d":"19348.00"}}]
[null,null,"(4) शिक्षा उपकार 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"रु.",{"$f":"ROUND(Q56*0.04,0)","v":{"v":774,"d":"774.00"}}]
[null,null,"कुल आयकर (3+4)",{"$nulls":12},"रु.",{"$f":"SUM(Q56:Q57)","v":{"v":20122,"d":"20122.00"}}]
[null,17,"घटाइए : राहत धारा 89 के तहत",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"रु.",{"$f":"Q58-Q59","v":{"v":20122,"d":"20122.00"}}]
[null,19,"आयकर कटौती का विवरण",null,null,"सितम्बर 2024 तक रु.",{"$nulls":3},"दिसम्बर 2024 तक रु.",null,"जनवरी 2025 तक रु.","फरवरी 2025 तक रु.",null,"टी.डी.एस. रु.","योग कॉलम 19"]
[{"$nulls":5},{"$f":"SUM('GA-55'!X10:X16)","v":0},{"$nulls":3},{"$f":"SUM('GA-55'!X17:X19)","v":0},null,{"$f":"'GA-55'!X20","v":0},{"$f":"'GA-55'!X21","v":0},null,0,{"$f":"F62+J62+L62+M62+O62","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(Q60>P62,\"Income Tax Payable\",IF(Q60<P62,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},{"$nulls":13},"रु.",{"$f":"IF(Q60>P62,Q60-P62,P62-Q60)","v":{"v":20122,"d":"20122.00"}}]
[]
[{"$nulls":3},"हस्ताक्षर कार्मिक",{"$nulls":8},"हस्ताक्षर डीडीओ"]

{"sheet":"Tax New Regime","index":3,"n_rows":68,"n_cols":17,"rows_kept":68,"merged":[[0,1,0,16],[1,1,1,16],[2,2,2,3],[2,4,2,9],[2,11,2,13],[2,15,2,16],[3,2,3,14],[4,2,4,14],[5,2,5,14],[6,2,6,14],[7,1,9,1],[7,2,7,11],[7,12,7,14],[7,15,8,16],[8,2,8,11],[8,12,8,14],[9,2,9,11],[9,12,9,14],[10,2,10,14],[11,1,13,1],[11,2,11,9],[11,10,11,11],[11,12,11,14],[11,15,13,16],[12,2,13,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,4,13,6],[13,7,13,9],[13,10,13,11],[13,12,13,14],[14,2,14,14],[15,2,15,14],[16,2,16,14],[17,2,17,14],[18,1,32,1],[18,2,18,16],[19,2,19,16],[20,3,20,6],[20,10,20,12],[20,15,29,16],[21,3,21,6],[21,10,21,12],[22,3,22,6],[22,10,22,12],[23,3,23,6],[23,10,23,12],[24,3,24,6],[24,10,24,12],[25,3,25,6],[25,10,25,12],[26,3,26,6],[26,10,26,12],[27,3,27,6],[27,10,27,12],[28,3,28,6],[28,10,28,12],[29,2,29,12],[30,2,30,14],[31,2,31,14],[32,2,32,14],[33,1,43,1],[33,2,33,16],[34,2,34,14],[35,2,35,14],[36,2,36,14],[37,2,37,14],[38,2,38,14],[39,2,39,14],[40,2,40,14],[41,2,41,14],[42,2,42,14],[43,2,43,14],[44,2,44,14],[45,2,45,14],[46,2,46,14],[47,1,60,1],[47,2,47,16],[48,2,48,6],[48,7,48,10],[48,11,48,14],[49,2,49,4],[49,5,49,6],[49,7,49,9],[49,11,49,13],[50,2,50,4],[50,5,50,6],[50,7,50,9],[50,11,50,13],[51,2,51,4],[51,5,51,6],[51,7,51,9],[51,11,51,13],[52,2,52,4],[52,5,52,6],[52,7,52,9],[52,11,52,13],[53,2,53,4],[53,5,53,6],[53,7,53,9],[53,11,53,13],[54,2,54,4],[54,5,54,6],[54,7,54,9],[54,11,54,13],[55,2,55,14],[56,2,56,14],[57,2,57,14],[58,2,58,14],[59,2,59,14],[60,2,60,14],[61,2,61,14],[62,2,62,14],[63,1,64,1],[63,2,64,4],[63,5,63,8],[63,9,63,10],[63,12,63,13],[63,15,63,16],[64,5,64,8],[64,9,64,10],[64,12,64,13],[64,15,64,16],[65,1,65,14],[67,3,67,5],[69,2,71,16],[72,11,78,16],[77,3,77,9]]}
[null,{"$f":"'GA-55'!C4","v":"Govt. Sr. Sec. School Gordhanpura, Atru Baran"}]
[null,"आयकर गणना प्रपत्र वर्ष 2024-25 (कर निर्धारण वर्ष 2025-26)"]
[null,1,"नाम कर्मचारी :",null,{"$f":"'GA-55'!D6","v":"Parmanand Meghwal"},{"$nulls":5},"पद :",{"$f":"'GA-55'!K6","v":"Senior Teacher"},null,null,"PAN :",{"$f":"IF('GA-55'!P6=\"\",\"\",'GA-55'!P6)","v":"XXXXXXXX"}]
[null,2,"आय: वर्ष-2024-25 में प्राप्त कुल वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"रु.",{"$f":"'GA-55'!N31","v":{"v":785665,"d":"785665.00"}}]
[null,3,"(i) गृह किराया, धारा 10(13-A) के अंतर्गत जो कर मुक्त हैं।",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"(ii) धारा 10(14) के अंतर्गत अन्य भत्ते ",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,4,"                                                                                                 शेष (4-5)",{"$nulls":12},"रु.",{"$f":"Q4-Q5-Q6","v":{"v":785665,"d":"785665.00"}}]
[null,5,"(i) मनोरंजन भत्ता धारा 16(ii) के अंतर्गत (अधिकतम सीमा रु. 5000)",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,null,"(ii) व्यवसाय कर धारा 16(iii) के अंतर्गत",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction) 50,000 (अधिकतम)",{"$nulls":9},{"v":75000,"d":"75000.00"},null,null,"रु.",{"$f":"SUM(M8:O10)","v":{"v":75000,"d":"75000.00"}}]
[null,6,"                                                                                                             शेष (4-5)",{"$nulls":12},"रु.",{"$f":"Q7-Q10","v":{"v":710665,"d":"710665.00"}}]
[null,7,"(अ) गृह संपत्ति से आय (1)स्वयं के उपयोग में शून्य",{"$nulls":7},"(2) प्राप्त किराया रु.",null,{"v":0,"d":"0.00"}]
[null,null,"(ब) घटाये",null,"किराए का 30%",null,null,"गृह ऋण पर ब्याज",null,null,"गृहकर",null,"योग 7(ब)"]
[{"$nulls":4},{"$f":"ROUND(M12*0.3,0)","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"$f":"E14+H14+K14","v":{"v":0,"d":"0.00"}}]
[null,null,"                                            शेष -/+(7(अ) एवं योग 7(ब) का",{"$nulls":12},"रु.",{"$f":"M12-M14","v":{"v":0,"d":"0.00"}}]
[null,8,"                                                        कुल शेष -/+(6  एवं 7)",{"$nulls":12},"रु.",{"$f":"Q11+Q15","v":{"v":710665,"d":"710665.00"}}]
[null,9,"अन्य आय",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,10,"सकल आय                                                                                                                                          योग (8+9)",{"$nulls":12},"रु.",{"$f":"Q16+Q17","v":{"v":710665,"d":"710665.00"}}]
[null,11,"घटाइए कटौतियाँ - धारा US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1,50,000/- (धारा 80CCE) के अलावा"]
[null,null,"(i)","राज्य बीमा (SI)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(x)","पेंशन प्लान हेतु अंशदान धारा (80CCC)",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(ii)","जीवन बीमा प्रीमियम (LIC)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xi)","राष्ट्रीय बचत पत्र पर आदत्त ब्याज",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xii)","ट्यूशन फीस",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xiii)"," इक्विटी लिंक सेविंग स्कीम",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम (NSS)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xv)","स्थगित वार्षिकी (Defferred Annuty)",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(vi)","सामान्य प्रावधायी निधि (GPF/GPF 2004)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xiv)","पी.एल.आई. (PLI)",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(vii)","सामूहिक बीमा प्रीमियम (G.Ins.)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xvi)","अन्य जमा राशि (80C के अंतर्गत)",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(viii)","यू.एल.आई.पी./वार्षिक प्लान",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xvii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"रु.",{"v":0,"d":"0.00"}]
[null,null,"(ix)","गृह ऋण किश्त (HBA Premium)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"},"(xviii)",{"$nulls":3},"रु.",{"v":0,"d":"0.00"}]
[null,null,"योग (i से XViii) ",{"$nulls":10},"रु.",{"$f":"SUM(I21:I29)+SUM(O21:O29)","v":{"v":0,"d":"0.00"}}]
[null,null,"अधिकतम कटौती की राशि 1.50 लाख रु. तक",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"(B) घटाइए - धारा 80CCD 1(B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रु. 50,000)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"  योग 11(A+B+C)      ",{"$nulls":12},"रु.",{"$f":"SUM(Q31:Q31)","v":{"v":0,"d":"0.00"}}]
[null,12,"अन्य कटौतियाँ"]
[null,null,"1-धारा 80D, चिकित्सा बीमा प्रीमियम (स्वयं, पति/पत्नी व बच्चों के लिए रु. 25000, माता-पिता के लिए रु. 25000, सीनियर सिटीजन  रु. 50,000)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"2-धारा 80D, विकलांग आश्रितों के चिकित्सा आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80% या अधिक विकलांगता रु. 125000)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"3-धारा 80D विशीष्ट रोगों के उपचार हेतु कटौती (अधिकतम रु. 40,000 , सीनियर सिटीजन  हेतु रु. 100,000)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"4-धारा 80D, उच्च शिक्षा हेतु लिए ऋण का ब्याज",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"5-धारा 80D धर्मार्थ संस्थाओं आदि को दिये दान (क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"6-धारा 80U स्थाई रूप से शारीरिक असमर्थता की दशा में (अधिकतम 75,000 तथा अधिनियम 1995 के अनुसार 125,000)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"7-धारा 80 TTA बचत खाते पर अधिकतम ब्याज रु. 10,000 194(1A) (80TTB-वरिष्ठ नागरिक अधिकतम ब्याज 50,000 रु.)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"8-धारा  80GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"9-धारा 80GGC राजनीतिक पार्टियों को दिया गया दान ",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"कुल योग 12 (1 से 9 तक)",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,13,"कुल कटौती ( 11 + 12)",{"$nulls":12},"रु.",{"$f":"Q33+Q44","v":{"v":0,"d":"0.00"}}]
[null,14,"कर योग्य आय ( 10-13 )",{"$nulls":12},"रु.",{"$f":"(Q18-Q45)","v":{"v":710665,"d":"710665.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणज में करना) धारा 288A",{"$nulls":12},"रु.",{"$f":"ROUND(Q46,-1)","v":{"v":710670,"d":"710670.00"}}]
[null,16,"आय की गणना उपरोक्त कॉलम 15 के आधार पर "]
[null,null,"एक व्यक्ति कर दाता",{"$nulls":4},"वरिष्ठ नागरिक (60 से 80 वर्ष तक)",{"$nulls":3},"80 वर्ष या अधिक आयु"]
[null,null,"3,00,000 तक",null,null,"Nil",null,"3,00,000 तक",null,null,"Nil","3,00,000 तक",null,null,"Nil","रु.",{"v":0,"d":"0.00"}]
[null,null,"3,00,001-7,00,000",null,null,{"v":0.05,"d":"5%"},null,"3,00,001-7,00,000",null,null,{"v":0.05,"d":"5%"},"7,00,000 तक",null,null,{"v":0.05,"d":"5%"},"रु.",{"$f":"ROUND(IF('GA-55'!AB2=\"No\",IF(Q47<300001,0,IF(Q47>700000,20000,((Q47-300000)*0.05))),IF(Q47<300001,0,IF(Q47>700000,10000,((Q47-300000)*0.05)))),0)","v":{"v":20000,"d":"20000.00"}}]
[null,null,"7,00,001-10,00,000",null,null,{"v":0.1,"d":"10%"},null,"7,00,001-10,00,000",null,null,{"v":0.1,"d":"10%"},"7,00,001-10,00,000",null,null,{"v":0.1,"d":"10%"},"रु.",{"$f":"IF(Q47<700001,0,IF(Q47>1000000,30000,((Q47-700000)*0.1)))","v":{"v":1067,"d":"1067.00"}}]
[null,null,"10,00,001-12,00,000",null,null,{"v":0.15,"d":"15%"},null,"10,00,001-12,00,000",null,null,{"v":0.15,"d":"15%"},"10,00,001-12,00,000",null,null,{"v":0.15,"d":"15%"},"रु.",{"$f":"IF(Q47<1000001,0,IF(Q47>1200000,30000,((Q47-1000000)*0.15)))","v":{"v":0,"d":"0.00"}}]
[null,null,"12,00,001-15,00,000",null,null,{"v":0.2,"d":"20%"},null,"12,00,001-15,00,000",null,null,{"v":0.2,"d":"20%"},"12,00,001-15,00,000",null,null,{"v":0.2,"d":"20%"},"रु.",{"$f":"IF(Q47<1200001,0,IF(Q47>1500000,60000,((Q47-1200000)*0.2)))","v":{"v":0,"d":"0.00"}}]
[null,null,"15,00,001 से अधिक",null,null,{"v":0.3,"d":"30%"},null,"15,00,001 से अधिक",null,null,{"v":0.3,"d":"30%"},"15,00,001 से अधिक",null,null,{"v":0.3,"d":"30%"},"रु.",{"$f":"IF(Q47<1500001,0,((Q47-1500000)*0.3))","v":{"v":0,"d":"0.00"}}]
[null,null,"(1) योग आयकर",{"$nulls":12},"रु.",{"$f":"SUM(Q50:Q55)","v":{"v":21067,"d":"21067.00"}}]
[null,null,"(2) छूट धारा 87(A) (3.00 लाख से 7.00 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रु. 25,000 तक)",{"$nulls":12},"रु.",{"$f":"IF(Q47<700001,Q56,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(3) छूट धारा 115BAC(1) के तहत सीमांत राहत लाभ (Marginal Relief benefit under section 115BAC(1)",{"$nulls":12},"रु.",{"$f":"IF(Q47<700001,0,IF(Q47>727770,0,Q56-(Q47-700000)))","v":{"v":10397,"d":"10397.00"}}]
[null,null,"(4) शेष आयकर (1-2)",{"$nulls":12},"रु.",{"$f":"Q56-Q57-Q58","v":{"v":10670,"d":"10670.00"}}]
[null,null,"(5) शिक्षा उपकार 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"रु.",{"$f":"ROUND(Q59*0.04,0)","v":{"v":427,"d":"427.00"}}]
[null,null,"कुल आयकर (3+4)",{"$nulls":12},"रु.",{"$f":"SUM(Q59:Q60)","v":{"v":11097,"d":"11097.00"}}]
[null,17,"घटाइए : राहत धारा 89 के तहत",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"रु.",{"$f":"Q61-Q62","v":{"v":11097,"d":"11097.00"}}]
[null,19,"आयकर कटौती का विवरण",null,null,"सितम्बर 2024 तक रु.",{"$nulls":3},"दिसम्बर 2024 तक रु.",null,"जनवरी 2025 तक रु.","फरवरी 2025 तक रु.",null,"टी.डी.एस. रु.","योग कॉलम 19"]
[{"$nulls":5},{"$f":"SUM('GA-55'!X10:X16)","v":0},{"$nulls":3},{"$f":"SUM('GA-55'!X17:X19)","v":0},null,{"$f":"'GA-55'!X20","v":0},{"$f":"'GA-55'!X21","v":0},null,0,{"$f":"F65+J65+L65+M65+O65","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(Q63>P65,\"Income Tax Payable\",IF(Q63<P65,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},{"$nulls":13},"रु.",{"$f":"IF(Q63>P65,Q63-P65,P65-Q63)","v":{"v":11097,"d":"11097.00"}}]
[]
[{"$nulls":3},"हस्ताक्षर कार्मिक",{"$nulls":10},"हस्ताक्षर डीडीओ"]

{"sheet":"Form 16","index":4,"n_rows":156,"n_cols":12,"rows_kept":156,"merged":[[0,0,0,11],[0,12,157,12],[1,0,1,11],[2,0,2,11],[3,0,3,11],[4,0,4,11],[5,0,5,5],[5,6,5,11],[6,0,6,5],[6,6,6,11],[7,0,7,5],[7,6,7,11],[8,0,9,5],[8,6,9,11],[10,0,10,2],[10,3,10,5],[10,6,10,11],[11,0,11,2],[11,3,11,5],[11,6,11,11],[12,3,14,5],[12,6,12,8],[12,9,12,11],[13,6,13,7],[13,9,14,11],[14,6,14,7],[16,0,16,1],[16,2,16,4],[16,5,16,6],[16,7,16,9],[16,10,16,11],[17,0,17,1],[17,2,17,4],[17,5,17,6],[17,7,17,9],[17,10,17,11],[18,0,18,1],[18,2,18,4],[18,5,18,6],[18,7,18,9],[18,10,18,11],[19,0,19,1],[19,2,19,4],[19,5,19,6],[19,7,19,9],[19,10,19,11],[20,0,20,1],[20,2,20,4],[20,5,20,6],[20,7,20,9],[20,10,20,11],[21,0,21,1],[21,2,21,4],[21,5,21,6],[21,7,21,9],[21,10,21,11],[22,0,22,11],[23,1,23,3],[23,4,23,11],[24,1,24,3],[24,4,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[26,1,26,3],[26,6,26,7],[26,8,26,9],[27,1,27,3],[27,4,27,5],[27,6,27,7],[27,8,27,9],[28,1,28,3],[28,4,28,5],[28,6,28,7],[28,8,28,9],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[36,1,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[37,1,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[38,1,38,3],[38,4,38,5],[38,6,38,7],[38,8,38,9],[39,1,39,3],[40,1,40,3],[40,4,40,5],[40,6,40,7],[40,8,40,9],[42,0,42,11],[43,1,43,3],[43,4,43,11],[44,1,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[46,1,46,3],[46,6,46,7],[46,8,46,9],[47,1,47,3],[47,6,47,7],[47,8,47,9],[48,1,48,3],[48,6,48,7],[48,8,48,9],[49,1,49,3],[49,6,49,7],[49,8,49,9],[50,1,50,3],[50,6,50,7],[50,8,50,9],[51,1,51,3],[51,6,51,7],[51,8,51,9],[52,1,52,3],[52,6,52,7],[52,8,52,9],[53,1,53,3],[53,6,53,7],[53,8,53,9],[54,1,54,3],[54,6,54,7],[54,8,54,9],[55,1,55,3],[55,6,55,7],[55,8,55,9],[56,1,56,3],[56,6,56,7],[56,8,56,9],[57,1,57,3],[57,6,57,7],[57,8,57,9],[58,1,58,3],[58,6,58,7],[58,8,58,9],[59,1,59,3],[60,1,60,3],[60,4,60,5],[60,6,60,11],[61,0,61,11],[62,1,62,3],[62,6,62,8],[63,0,63,2],[63,9,63,10],[64,0,64,4],[65,0,66,11],[67,0,67,1],[68,0,68,11],[69,0,69,11],[70,0,70,11],[71,0,71,11],[72,0,72,6],[73,0,73,11],[74,0,74,11],[75,0,75,11],[76,0,76,11],[77,0,77,11],[78,0,78,4],[81,0,81,11],[82,0,82,11],[89,9,89,10],[92,0,92,6],[93,0,93,6],[94,9,94,10],[108,6,110,7],[108,8,110,9],[108,10,110,11],[109,0,109,3],[111,6,111,7],[111,8,111,9],[111,10,111,11],[112,2,112,4],[112,6,112,7],[112,8,112,9],[112,10,112,11],[113,2,113,4],[113,6,113,7],[113,8,113,9],[113,10,113,11],[114,2,114,4],[114,6,114,7],[114,8,114,9],[114,10,114,11],[115,2,115,4],[115,6,115,7],[115,8,115,9],[115,10,115,11],[116,6,116,7],[116,8,116,9],[116,10,116,11],[117,2,117,4],[117,6,117,7],[117,8,117,9],[117,10,117,11],[118,6,118,7],[118,8,118,9],[118,10,118,11],[119,6,119,7],[119,8,119,9],[119,10,119,11],[120,6,120,7],[120,8,120,9],[120,10,120,11],[123,6,123,7],[123,8,123,9],[123,10,123,11],[124,6,124,7],[124,8,124,9],[124,10,124,11],[127,8,127,9],[127,10,127,11],[128,2,128,4],[128,6,128,7],[128,8,128,9],[128,10,128,11],[129,2,129,4],[129,6,129,7],[129,8,129,9],[129,10,129,11],[130,2,130,4],[130,6,130,7],[130,8,130,9],[130,10,130,11],[131,6,131,7],[131,8,131,9],[131,10,131,11],[132,10,132,11],[133,10,133,11],[135,10,135,11],[136,10,136,11],[137,10,137,11],[138,10,138,11],[139,10,139,11],[140,10,140,11],[141,10,141,11],[142,10,142,11],[143,10,143,11],[144,0,144,11],[145,1,145,3],[145,6,145,8],[146,0,146,2],[147,0,147,11],[152,5,152,11],[153,5,153,11],[154,0,154,2],[154,7,154,11],[155,0,155,2],[155,7,155,11],[156,5,156,11],[157,0,157,11]]}
["FORM NO.16"]
["[See rule 31 (1) (a)]"]
["Part A"]
["Certificate under section 203 of the Income Tax Act, 1961 for tax deducted"]
["at source from income chargeable under the head  “ Salaries “"]
["Name and address of the employer",{"$nulls":5},"Name and Designation of the employee"]
[{"$f":"'Master Sheet'!U1","v":"Rajendra Kumar Chittora"},{"$nulls":5},{"$f":"'GA-55'!D6","v":"Parmanand Meghwal"}]
["Principal",{"$nulls":5},{"$f":"'GA-55'!K6","v":"Senior Teacher"}]
[{"$f":"'GA-55'!C4","v":"Govt. Sr. Sec. School Gordhanpura, Atru Baran"},{"$nulls":5},{"$f":"A9","v":"Govt. Sr. Sec. School Gordhanpura, Atru Baran"}]
[]
["PAN of the Deducter",null,null,"TAN of the Deducter",null,null,"PAN of the Employee"]
[{"$f":"'Master Sheet'!AL1","v":"ABCPC2588K"},null,null,{"$f":"'GA-55'!U6","v":"JDHG09699E"},null,null,{"$f":"'GA-55'!P6","v":"XXXXXXXX"}]
["TDS Circle where annual",{"$nulls":5},"PERIOD",null,null,"Assessment Year"]
["return / statement under",{"$nulls":5},"FROM",null,"TO","2024-25"]
["section 206 is to be filed",{"$nulls":5},"01.04.2023",null,"31.03.2024"]
["Smmary of amount Paid/credited and tax Deducted at source thereon in respect of the Employee"]
["Quarter(s)",null,"Receipt Numbersof Original Quaterly Statements of TDS Under Sub-Section (3) of Section 200",null,null,"Amount Paid cridited",null,"      Amount of Tax Deducted     (Rs)",null,null,"Amount of Tax Deposited / Remitted                               (Rs)"]
["Quarter 1",{"$nulls":4},{"$f":"SUM('GA-55'!N10+'GA-55'!N11+'GA-55'!N12)","v":180306},null,{"$f":"SUM('GA-55'!X10:X12)","v":0},null,null,{"$f":"H18","v":0}]
["Quarter 2",{"$nulls":4},{"$f":"SUM('GA-55'!N13+'GA-55'!N14+'GA-55'!N15+'GA-55'!N22)","v":186828},null,{"$f":"SUM('GA-55'!X13:X15)+'GA-55'!X22","v":0},null,null,{"$f":"H19","v":0}]
["Quarter 3",{"$nulls":4},{"$f":"SUM('GA-55'!N16+'GA-55'!N17+'GA-55'!N18+'GA-55'!N25)","v":193883},null,{"$f":"SUM('GA-55'!X16:X18)+'GA-55'!X25","v":0},null,null,{"$f":"H20","v":0}]
["Quarter 4",{"$nulls":4},{"$f":"SUM('GA-55'!N19+'GA-55'!N20+'GA-55'!N21+'GA-55'!N22+'GA-55'!N24+'GA-55'!N26+'GA-55'!N227+'GA-55'!N28+'GA-55'!N29+'GA-55'!N30)","v":223004},null,{"$f":"SUM('GA-55'!X19:X30)","v":0},null,null,{"$f":"H21","v":0}]
["Total",{"$nulls":4},{"$f":"SUM(F18:F21)","v":784021},null,{"$f":"SUM(H18:H21)","v":0},null,null,{"$f":"SUM(K18:K21)","v":0}]
["I.DETAILS TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT THROUGH BOOK ADJUSTMENT"]
["S.No","Tax Deposited In Respect",null,null,"Book Identification Number (BIN)"]
[null,"of the deducter",null,null,"Receipt Numbers of",null,"DDO Serial No in",null,"Date Of Transfer",null,"Status of Maching"]
[null,null,"(Rs)",null,"Form No.24G",null,"Form No.24G",null,"Form No.24G",null,"with Form.No 24G"]
[{"$nulls":8},"(dd/mm/yyyy)"]
[1,{"$f":"'GA-55'!X10","v":0}]
[2,{"$f":"'GA-55'!X11","v":0}]
[3,{"$f":"'GA-55'!X12","v":0}]
[4,{"$f":"'GA-55'!X13","v":0}]
[5,{"$f":"'GA-55'!X14","v":0}]
[6,{"$f":"'GA-55'!X15","v":0}]
[7,{"$f":"'GA-55'!X16","v":0}]
[8,{"$f":"'GA-55'!X17","v":0}]
[9,{"$f":"'GA-55'!X18","v":0}]
[10,{"$f":"'GA-55'!X19","v":0}]
[11,{"$f":"'GA-55'!X20","v":0}]
[12,{"$f":"'GA-55'!X21","v":0}]
[13,{"$f":"SUM('GA-55'!X22+'GA-55'!X23+'GA-55'!X24+'GA-55'!X25+'GA-55'!X26+'GA-55'!X27+'GA-55'!X28+'GA-55'!X29+'GA-55'!X30)","v":0}]
["Total (Rs)",{"$f":"SUM(B28:B40)","v":0}]
[]
["II.DETAILS TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT THROUGH BOOK CHALLANA"]
["S.No","Tax Deposited In Respect",null,null,"Book Identification Number (CIN)"]
[null,"of the deducter",null,null,"BRS Code of  the ",null,"Date on Which",null,"Challana Serial",null,"Status of Maching"]
[null,null,"(Rs)",null,"Bank Branch",null,"Tax Deposited",null,"Number",null,"with Form.No 24G"]
[{"$nulls":6},"(dd/mm/yyyy)"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
["Total (Rs)",{"$f":"SUM(B48:D59)","v":0}]
["Verification"]
["I,",{"$f":"'Master Sheet'!U1","v":"Rajendra Kumar Chittora"},null,null,"Son/Doughter of ",null,{"$f":"'Master Sheet'!AE1","v":"Bhanwar Lal"},null,null,"  Working In the Capacity Of"]
[{"$f":"A8","v":"Principal"},null,null,"(Designation) do hereby certify that a sum  of Rs.",{"$nulls":4},{"$f":"H22","v":0},"(in words)"]
[{"$f":"SpellNumber(I64)","v":{"$error":"#NAME?"}},{"$nulls":4},"has beeen 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 book of accounts, documents and TDS Statements, TDS Deposited and other available records."]
[]
["Notes :"]
["1.  Government deductors to fill information in item I if tax is paid without production of an income-tax challan and in item II if tax ."]
["        is paid accompanied by an income-tax challan"]
["2.  Non-Government deductors to fill information in item II."]
["3.  The deductor shall furnish the address of  the Commissioner of  Income-tax (TDS) having jurisdiction as regards TDS "]
["     statements of the assessee."]
["4.  If an assessee is employed under one employer only during the year, certificate in Form No. 16 issued for the quarter ending on"]
["      31st March of the financial year shall contain the details of tax deducted and deposited for all the quarters of the financial year."]
["5.  If  an  assessee  is  employed  under  more  than  one  employer  during  the  year,  each  of  the employers shall issue Part "]
["      A of the certificate in Form No. 16 pertaining to the period for which such assessee was employed with each of the employers."]
["    Part B (Annexure) of the certificate in Form No.16 may be issued by each of the employers or the last employer at the"]
["    option of the assessee."]
["6.  In items I and II, in column for tax deposited in respect of deductee, furnish total amount of TDS and education cess.\""]
[]
["Part B"]
["DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
["1. Gross Salary *"]
[null,"( a ) Salary as per provisions contained in section 17 (1)",{"$nulls":6},{"$f":"'Tax Old Regime'!Q4","v":785665}]
[null,"( b ) Value of perquisites under section 17 (2)"]
[null,"        (as per Form No. 12 BA, wherever applicable)"]
[null,"( c ) Profits in lieu of Salary under section 17 (3)"]
[null,"        (as per Form No. 12 BA, wherever applicable)"]
[null,"( d ) Total",{"$nulls":7},{"$f":"I85+I86+I87+I88+I89","v":785665}]
[]
["2. Less : Allowance to the extent exempt under section 10"]
["a)HRA",{"$nulls":7},{"$f":"'Tax Old Regime'!Q5","v":52740}]
["b)Other"]
["3. Balance (1-2)",{"$nulls":8},{"$f":"J90-I93-I94","v":732925}]
[]
["4. Deductions :          "]
[null,"(a) Standard deduction",{"$nulls":3},"Rs.",50000]
[null,"(b) Entertainment allowance",{"$nulls":3},"Rs.",0]
[null,"(c) Tax on Employment",{"$nulls":3},"Rs.",0]
["5. Aggregate of 4 (a to c)",{"$nulls":7},50000]
[]
["6. Income chargeable under the Head ‘Salaries’(3-5)",{"$nulls":10},{"$f":"IF(AND((J95>50000)),(J95-I101),0)","v":682925}]
[]
["7. Add. : Any other income reported by the employee"]
[null,"Less:-  Loss From House Properties",{"$nulls":9},{"$f":"'[1]Other Deduction'!B9","v":0}]
[]
["8. Gross total income  (6+7)",{"$nulls":10},{"$f":"L103+L105-L106","v":682925}]
[{"$nulls":6},"Gross Amount",null,"Qualifying Amt.",null,"Deductible Amt."]
["9. Deductions Under Chapter VIA    "]
["A.","Sections 80C,80CC and 80CCD1"]
["(a)","Section 80C"]
[null,"(i)","GPF/NPS ",null,null,"Rs.",{"$f":"'GA-55'!O31","v":43586},null,{"$f":"G113","v":43586},null,{"$f":"I113","v":43586}]
[null,"(ii)","STATE INSURANCE",null,null,"Rs.",{"$f":"'Tax Old Regime'!I21","v":60000},null,60000,null,60000]
[null,"(iii)","LIC",null,null,"Rs.",null,null,0,null,0]
[null,"(iv)","Group Ins.",null,null,"Rs.",{"$f":"'Tax Old Regime'!I27","v":700},null,700,null,700]
[null,"(vi)","House Loan Installment",null,null,"Rs.",{"$f":"'Tax Old Regime'!I29","v":0},null,0,null,0]
[null,"(vii)","Others",null,null,"Rs.",{"$f":"'Tax Old Regime'!I23+'Tax Old Regime'!I24+'Tax Old Regime'!I25+'Tax Old Regime'!I28+'Tax Old Regime'!O22+'Tax Old Regime'!O23+'Tax Old Regime'!O24+'Tax Old Regime'!O25+'Tax Old Regime'!O26+'Tax Old Regime'!O27+'Tax Old Regime'!O28+'Tax Old Regime'!O29+'Tax Old Regime'!O30","v":178686},null,178686,null,178686]
["(b)","Section 80CCC",{"$nulls":3},"Rs.",null,null,0,null,0]
["(c)","Section 80CCD",{"$nulls":3},"Rs.",null,null,0,null,0]
["Aggregate amount deductible under the three sections ",{"$nulls":5},{"$f":"SUM(G113:G120)","v":282972},null,{"$f":"SUM(I113:I120)","v":282972},null,{"$f":"IF(SUM(K113:L118)>150000,150000,SUM(K113:L118))","v":150000}]
["i.e.80C, 80CCC and 80CCD"]
[]
["(d)","Section 80CCD2",{"$nulls":3},"Rs.",0,null,{"$f":"G124","v":0},null,{"$f":"I124","v":0}]
["(e)","Section 80CCD (1B)",{"$nulls":3},"Rs.",{"$f":"'[1]Tax Old Regime'!Q33","v":0},null,{"$f":"G125","v":0},null,{"$f":"I125","v":0}]
[]
["B.","Other Sections ( e.g. 80E, 80G, 80TTA etc) Under Chapter VIA"]
[{"$nulls":6},"Gross Amount",null,"Qualifying Amt.",null,"Deductible Amt."]
[null,"(i)","अन्य कटौतियाँ",null,null,"Rs.",null,null,{"$f":"G129","v":0},null,{"$f":"I129","v":0}]
[null,"(ii)",{"$nulls":3},"Rs.",null,null,{"$f":"G130","v":0},null,{"$f":"I130","v":0}]
[null,"(iii)",{"$nulls":3},"Rs.",null,null,{"$f":"G131","v":0},null,{"$f":"I131","v":0}]
["10. Aggregate of deductible amount under chapter VI-A",{"$nulls":9},{"$f":"K121+K124+K125+K129+K130+K131","v":150000},0]
[]
["11. Total Income (8-10 )",{"$nulls":9},{"$f":"'Tax Old Regime'!Q47","v":534240}]
[]
["12. Tax on Total Income ",{"$nulls":9},{"$f":"'Tax Old Regime'!Q54","v":19348}]
["13. Rebate U/S 87a",{"$nulls":9},{"$f":"'[1]Tax Old Regime'!Q55","v":0}]
["14. Tax Payable on total income (12-13)",{"$nulls":9},{"$f":"K136-K137","v":19348}]
["15.Education & Health Cess 4%",{"$nulls":9},{"$f":"'Tax Old Regime'!Q57","v":774}]
["16. Tax payable (14+15)",{"$nulls":9},{"$f":"'Tax Old Regime'!Q58","v":20122}]
["17. Relife Under Section 89 (attach details)",{"$nulls":9},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["18. Tax payable (16-17)",{"$nulls":9},{"$f":"'Tax Old Regime'!Q60","v":20122}]
["19.Tax Deducted at source U/S 192",{"$nulls":9},{"$f":"H22+B61","v":0}]
["20. Tax payable / refundable (17-18)",{"$nulls":9},{"$f":"K142-K143","v":20122}]
["Verification"]
["I,",{"$f":"B63","v":"Rajendra Kumar Chittora"},null,null,"Son/Doughter of ",null,{"$f":"G63","v":"Bhanwar Lal"},null,null,"  Working In the Capacity Of"]
[{"$f":"A64","v":"Principal"},null,null,"(Designation) do hereby certify that the information given  above is true  correct based on the "]
["book of accounts, documents and TDS Statements, TDS Deposited and other available records."]
[]
[]
[]
[]
[{"$nulls":5},"                                    Signature & Seal"]
[]
["Place:",{"$nulls":4},"Full Name  ",null,{"$f":"A7","v":"Rajendra Kumar Chittora"}]
["Date:",{"$nulls":4},"Designation",null,{"$f":"A8","v":"Principal"}]

{"sheet":"Hra Receipt","index":5,"n_rows":17,"n_cols":18,"rows_kept":17,"merged":[[0,0,0,3],[0,4,18,4],[0,5,1,8],[1,0,1,3],[2,0,2,3],[2,5,2,8],[3,0,3,3],[4,0,4,3],[5,5,5,8],[6,5,6,8],[7,5,7,8],[8,2,8,3],[8,5,8,8],[9,2,9,3],[9,5,18,6],[9,7,18,8],[12,0,12,1],[13,0,15,1]]}
["RECEIPT OF HOUSE RENT",{"$nulls":4},"RAJTEACHERS.NET"]
["Under Section 1 (13 – A) of Income Tax Act",{"$nulls":8},{"$f":"'GA-55'!AF4","v":1}]
[{"$nulls":5},"HRA REBATE CALCULATION",{"$nulls":3},{"$f":"'GA-55'!D6","v":"Parmanand Meghwal"}]
[{"$f":"CONCATENATE(J4,\" \",R4,\" \",I5,\" \",K4,\" \",R4,\" \",J7,\") \",M4,\" \",R4,\" \",J6,\" \",N4,\" \",N5,\" \",O4,\" \",O5,\" \",P4,\" \",J3,\" \",Q4,)","v":{"$error":"#NAME?"}},{"$nulls":4},"मकान किराया छूट के रशीद की आवश्यकता       (12 माह के लिए)","एक माह का किराया (रशीद की राशि इस राशि से कम नहीं हो सकती)","आप द्वारा चुकाया गया एक माह का किराया यहाँ भरें","आप द्वारा चुकाया गया 12 माह का किराया ","Received a sum of Rs.","(Rupees","only)","towards House Rent @ Rs. (Rupees","per month from","to","from Dr/Sri/Smt","in respect of House No - ","-"]
["Situated at",{"$nulls":4},{"$f":"L5","v":126989.3},{"$f":"M5","v":10582},{"$f":"G5","v":10582},{"$f":"H5*12","v":126984},{"$f":"'Tax Old Regime'!Q5","v":{"v":52740,"d":"52740.00"}},{"$f":"'GA-55'!N31-'GA-55'!I31","v":742493},{"$f":"IF(J5>=1,(K5*10%+J5),J5)","v":126989.3},{"$f":"ROUND(L5/12,0)","v":10582},"Feb","March"]
["………………………………………………………………….",{"$nulls":8},{"$f":"SpellNumber(H5)","v":{"$error":"#NAME?"}}]
["………………………………………………………………….",{"$nulls":4},"CREATED BY",{"$nulls":3},{"$f":"SpellNumber(I5)","v":{"$error":"#NAME?"}}]
["………………………………………………………………….",{"$nulls":4},"PARMANAND MEGHWAL, SENIOR TEACHER"]
[null,null,"(Affix Revenue Stamp of Rs.1/-)",null,null,"GUPS KANWARPURA, ATRU- BARAN"]
[null,null,"Signature of the House Owner",null,null,"साथियों नमस्कार! यह शीट वित्तीय वर्ष 2023-24 के आयकर गणना हेतु बनाई गयी है, इसके द्वारा आप एक से अधिक कार्मिकों का आयकर गणना कर सकते हैं, शीट को सावधानीपूर्वक व आयकर विभाग के नियमों के अनुरूप बनाया गया है, किसी प्रकार की गलती के लिए आपके विचार अपेक्षित हैं।"]
["Date:"]
["Name",{"$f":"VLOOKUP(J2,'Master Sheet'!A6:BN35,65,0)","v":"Vikas Sharma"}]
["Address:-"]
[{"$f":"VLOOKUP(J2,'Master Sheet'!A6:BN35,66,0)","v":"Village Kawai Salpura, The atru Dist. Baran"}]
[]
[]
["PAN No."]