{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Master Sheet","GA-55","Other Deduction","Form 16","Sheet1"],"not_rendered":{"images":1,"macros":1,"external_links":1,"defined_names":170},"read":"whole","date_system":"1900"}

{"sheet":"Master Sheet","index":0,"n_rows":18,"n_cols":22,"rows_kept":18,"merged":[[0,1,0,15],[0,17,9,20],[1,0,10,0],[1,1,1,2],[1,3,1,13],[2,1,2,15],[3,1,3,7],[3,8,9,8],[3,9,3,15],[4,1,4,3],[4,4,4,7],[4,9,4,11],[4,12,4,15],[5,1,5,3],[5,4,5,7],[5,9,5,11],[5,12,5,15],[6,1,6,3],[6,4,6,7],[6,9,6,11],[6,12,6,15],[7,1,7,3],[7,4,7,7],[7,9,7,15],[8,1,8,3],[8,4,8,7],[8,9,8,11],[8,12,8,15],[9,1,9,3],[9,4,9,7],[9,9,9,11],[9,12,9,15],[10,1,10,15],[10,17,11,20],[12,0,17,0],[12,1,12,6],[12,8,17,8],[12,9,12,11],[12,13,12,15],[12,17,12,20],[13,1,13,6],[13,9,13,11],[13,13,13,15],[14,1,14,6],[14,9,14,11],[14,13,14,15],[15,1,15,6],[15,13,15,15],[16,1,16,6],[16,9,17,12],[16,13,16,15],[17,1,17,6],[17,13,17,15]]}
[null,"मास्टर शीट को पूर्ण भरने के बाद SALARY SHEET व OTHER DEDUCTION वाली शीट को जरूर चेक करें।"]
[null,"OFFICE NAME",null,"GOVT. SR. SECONDARY SCHOOL, GORDHANPURA, ATRU, BARAN",{"$nulls":10},"TAN NO.","JDHG09699E",{"$nulls":5},"YES"]
[{"$nulls":21},"NO"]
[null,"EMPLOYEE INFORMATION",{"$nulls":7},"DDO INFORMATION",{"$nulls":11},{"v":0.09,"d":"9%"}]
[null,"EMPLOYEE NAME",null,null,"PARMANAND MEGHWAL",{"$nulls":4},"DDO NAME",null,null,"RAJENDRA KUMAR CHITTORA",{"$nulls":3},"YES ",{"$nulls":4},{"v":0.18,"d":"18%"}]
[null,"DESIGNATION",null,null,"SENIOR TEACHER",{"$nulls":4},"DDO FATHER'S NAME",null,null,"RAM LAL",{"$nulls":3},"NO",{"$nulls":4},4]
[null,"PAN NUMBER",null,null,"ASQPM6311G",{"$nulls":4},"DESIGNATION",null,null,"PRINCIPAL",{"$nulls":3},{"v":0.09,"d":"9%"},{"$nulls":4},5]
[null,"BANK A/C NUMBER",null,null,2225617763,{"$nulls":4},"HOUSE OWNER DETAIL (HRA RENT RECEIPT)",{"$nulls":6},{"v":0.18,"d":"18%"},{"$nulls":4},6]
[null,"MOBILE NUMBER",null,null,9784379510,{"$nulls":4},"HOUSE OWNER NAME",null,null,"RAM DAYAL NAGAR",{"$nulls":8},7]
[{"$nulls":9},"ADDRESS",null,null,"KAWAI SALPURA, ATRU BARAN",{"$nulls":8},8]
[null,"SALARY DETAIL",{"$nulls":14},4,"           PARMANAND MEGHWAL          SR. TEACHER",{"$nulls":3},9]
[{"$nulls":21},10]
[null,"क्या आप NPS (GPF-2004) के कर्मचारी हैं?",{"$nulls":5},"YES",null,"MARCH 2022 BASIC",null,null,47900,{"$nulls":8},11]
[null,"क्या आपने समर्पित वेतन लिया?",{"$nulls":5},"YES",null,"S.I.",null,null,4000,{"$nulls":8},12]
[null,"समर्पित वेतन लेने का माह ?",{"$nulls":5},8,null,"L.I.C.",null,null,2250,{"$nulls":8},1]
[null,"बोनस मिला ?",{"$nulls":5},"YES",{"$nulls":13},2]
[null,"HRA दर",{"$nulls":5},{"v":0.09,"d":"9%"},null,"RAJTEACHERS.NET",{"$nulls":11},3]
[null,"क्या आप वरिष्ठ नागरिक हैं?",{"$nulls":5},"YES"]

{"sheet":"GA-55","index":1,"n_rows":35,"n_cols":31,"rows_kept":35,"merged":[[0,3,0,4],[0,5,0,7],[0,8,0,9],[0,10,0,13],[0,15,0,16],[0,18,0,20],[0,21,0,22],[0,23,0,26],[1,2,1,28],[2,2,2,28],[3,2,3,28],[4,3,5,7],[4,8,4,9],[4,10,4,13],[4,15,4,17],[4,20,4,22],[4,24,4,26],[4,27,4,28],[5,8,5,9],[5,12,5,19],[5,24,5,26],[5,27,5,28],[6,2,7,2],[6,3,6,13],[6,14,6,26],[6,28,7,28],[36,2,36,28]]}
[null,null,"GPF 2004",{"$f":"'Master Sheet'!H13","v":"YES"},null,"Surrender",null,null,{"$f":"'Master Sheet'!H14","v":"YES"},null,"Surrender Month",{"$nulls":3},{"$f":"'Master Sheet'!H15","v":8},"HRA",null,{"$f":"'Master Sheet'!H17","v":{"v":0.09,"d":"9%"}},"Bounus",null,null,{"$f":"'Master Sheet'!H16","v":"YES"},null,"Senior Citizen",{"$nulls":3},{"$f":"'Master Sheet'!H18","v":"YES"},null,"No","No"]
[{"$nulls":29},{"v":0.09,"d":"9%"}]
[null,null,{"$f":"'Master Sheet'!D2","v":"GOVT. SR. SECONDARY SCHOOL, GORDHANPURA, ATRU, BARAN"},{"$nulls":26},{"v":0.18,"d":"18%"}]
[null,null,"INCOME TAX CALCULATION (GA-55) 2022-23"]
[null,null,"NAME :",{"$f":"'Master Sheet'!E5","v":"PARMANAND MEGHWAL"},{"$nulls":6},{"$f":"'Master Sheet'!E6","v":"SENIOR TEACHER"},{"$nulls":3},"PAN :",{"$f":"'Master Sheet'!E7","v":"ASQPM6311G"},{"$nulls":3},"TAN:",{"$f":"'Master Sheet'!P2","v":"JDHG09699E"},{"$nulls":3},"A/C NO.",null,null,{"$f":"'Master Sheet'!E8","v":2225617763},null,"Yes","Yes"]
[{"$nulls":12},"RAJTEACHERS.NET",{"$nulls":11},"MOB NO.",null,null,{"$f":"'Master Sheet'!E9","v":9784379510},null,"No","No"]
[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":"IF(D1=\"No\",\"GPF\",\"GPF 2004\")","v":"GPF 2004"},{"$f":"IF(D1=\"No\",\"GPF LOAN\",\"\")","v":""},"SI","SI LOAN + INT","RPMF/RGHS","LIC","Group Insurance  \nAccidental","HBA Premium","HBA Interest","Income Tax / TDS","HITKARI NIDHI","CM Corona Fund","Total\nDeduction","Net Payment"]
[null,3,"2022-03-01",{"$f":"'Master Sheet'!M13","v":47900},0,0,0,{"$f":"ROUND(31%*D9,0)","v":14849},{"$f":"IF($R$1=18%,ROUND(0.18*D9,0),ROUND(0.09*D9,0))","v":4311},0,0,0,0,{"$f":"SUM(D9:M9)","v":67060},{"$f":"IF(D9<23101,1450,IF(D9<28501,1625,IF(D9<38501,2100,IF(D9<51501,2850,IF(D9<62001,3575,IF(D9<72001,4200,IF(D9<80001,4800,IF(D9<116001,6150,IF(D9<167001,8900,10500)))))))))","v":2850},0,{"$f":"'Master Sheet'!M14","v":4000},0,{"$f":"IF(D9<18001,265,IF(D9<33501,440,IF(D9<54001,658,875)))","v":658},{"$f":"'Master Sheet'!M15","v":2250},0,null,null,0,null,null,{"$f":"SUM(O9:Y9)","v":9758},{"$f":"N9-AA9","v":57302},null,null,4]
[null,4,"2022-04-01",{"$f":"D9","v":47900},{"$f":"IF(E$9=0,0,ROUND(D10/2,0))","v":0},{"$f":"IF(F$9=0,0,F9)","v":0},0,{"$f":"ROUND(34%*D10,0)","v":16286},{"$f":"IF($R$1=18%,ROUND(0.18*D10,0),ROUND(0.09*D10,0))","v":4311},{"$f":"IF(J$9=0,0,J9)","v":0},{"$f":"IF(K$9=0,0,K9)","v":0},0,{"$f":"IF(M$9=0,0,M9)","v":0},{"$f":"SUM(D10:M10)","v":68497},{"$f":"IF(D10<23101,1450,IF(D10<28501,1625,IF(D10<38501,2100,IF(D10<51501,2850,IF(D10<62001,3575,IF(D10<72001,4200,IF(D10<80001,4800,IF(D10<116001,6150,IF(D10<167001,8900,10500)))))))))","v":2850},{"$f":"P9","v":0},{"$f":"Q9","v":4000},{"$f":"R9","v":0},{"$f":"IF(D10<18001,265,IF(D10<33501,440,IF(D10<54001,658,875)))","v":658},{"$f":"T9","v":2250},null,{"$f":"V9","v":0},0,{"$f":"X9","v":0},0,null,{"$f":"SUM(O10:Y10)","v":9758},58739,null,null,5]
[null,5,"2022-05-01",47900,{"$f":"IF($E$9=0,0,ROUND(D11/2,0))","v":0},0,0,{"$f":"ROUND(34%*D11,0)","v":16286},4311,0,{"$f":"IF(K$9=0,0,K10)","v":0},{"$f":"IF(L$9=0,0,L10)","v":0},0,68497,2850,{"$f":"P10","v":0},{"$f":"Q10","v":4000},{"$f":"R10","v":0},658,{"$f":"T10","v":2250},0,0,0,0,{"$f":"Y10","v":0},null,9758,58739,null,null,6]
[null,6,"2022-06-01",47900,0,0,0,16286,4311,0,0,0,0,68497,2850,0,4000,0,658,2250,0,0,0,0,{"$f":"Y11","v":0},null,9758,58739,null,null,7]
[null,7,"2022-07-01",{"$f":"MROUND(ROUND(1.03*D12,0),100)","v":49300},0,{"$f":"IF(F$9=0,0,F12)","v":0},{"$f":"IF(G$9=0,0,G12)","v":0},16762,4437,{"$f":"IF(J$9=0,0,J12)","v":0},{"$f":"IF(K$9=0,0,K12)","v":0},{"$f":"IF(L$9=0,0,L12)","v":0},{"$f":"IF(M$9=0,0,M12)","v":0},70499,2850,{"$f":"P12","v":0},{"$f":"Q12","v":4000},{"$f":"R12","v":0},658,{"$f":"T12","v":2250},0,{"$f":"V12","v":0},{"$f":"W12","v":0},{"$f":"X12","v":0},0,null,9758,60741,null,null,8]
[null,8,"2022-08-01",{"$f":"D13","v":49300},0,0,0,16762,4437,0,0,0,0,70499,2850,0,4000,0,658,2250,0,0,0,0,0,null,9758,60741,null,null,9]
[null,9,"2022-09-01",49300,0,0,0,16762,4437,0,0,0,0,70499,2850,0,4000,0,658,2250,0,0,0,0,0,null,9758,60741,null,null,10]
[null,10,"2022-10-01",49300,0,{"$f":"IF(F$9=0,0,F15)","v":0},{"$f":"IF(G$9=0,0,G15)","v":0},{"$f":"ROUND(38%*D16,0)","v":18734},4437,0,0,0,0,72471,2850,0,4000,0,658,2250,0,0,0,0,0,null,9758,62713,null,null,11]
[null,11,"2022-11-01",49300,0,{"$f":"IF(F$9=0,0,F16)","v":0},0,{"$f":"ROUND(38%*D17,0)","v":18734},4437,0,0,0,0,72471,2850,0,4000,0,658,2250,0,0,0,0,0,null,9758,62713,null,null,12]
[null,12,"2022-12-01",49300,0,{"$f":"IF(F$9=0,0,F17)","v":0},0,18734,4437,0,0,0,0,72471,2850,0,4000,0,658,2250,0,0,0,0,250,null,10008,62463,null,null,1]
[null,1,"2023-01-01",49300,0,{"$f":"IF(F$9=0,0,F18)","v":0},0,18734,4437,0,0,0,0,72471,2850,0,4000,0,658,2250,0,0,0,0,null,null,9758,62713,null,null,2]
[null,2,"2023-02-01",49300,0,{"$f":"IF(F$9=0,0,F19)","v":0},0,18734,4437,0,0,0,0,72471,2850,0,4000,0,658,2250,0,0,0,0,null,null,9758,62713,null,null,3]
[null,null,"DA Arrear 34%",{"$nulls":4},{"$f":"(ROUND(34%*D9,0)-ROUND(31%*D9,0))*3","v":4311},{"$nulls":5},{"$f":"H21","v":4311},{"$f":"H21","v":4311},{"$nulls":4},0,{"$nulls":6},4311,0]
[null,null,"DA Arrear 38%",{"$nulls":4},{"$f":"(ROUND(38%*D13,0)-ROUND(34%*D13,0))*3","v":5916},{"$nulls":5},{"$f":"H22","v":5916},{"$f":"H22","v":5916},{"$nulls":4},0,{"$nulls":6},5916,0]
[null,null,"Surrender",{"$f":"IF(I1=\"NO\",0,IF(O1=3,D20,VLOOKUP(O1,B9:D20,3,FALSE)))/2","v":24650},{"$nulls":3},{"$f":"IF(AND(O1>3,O1<7),ROUND(34%*D23,0),ROUND(38%*D23,0))","v":9367},{"$nulls":5},34017,{"$nulls":12},0,34017]
[null,null,"Bonus",{"$f":"IF(V1=\"Yes\",6774,0)","v":6774},{"$nulls":9},6774,{"$f":"ROUND(D24*25/100,0)","v":1694},{"$nulls":11},1694,5080]
[null,null,"Fixation Arrear",{"$nulls":10},0,{"$nulls":12},0,0]
[null,null,"Salary Arrear 1",{"$nulls":10},0,{"$nulls":12},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(D9:D29)","v":617424},{"$f":"SUM(E9:E29)","v":0},0,0,227257,52740,0,0,0,0,897421,46121,0,48000,0,7896,27000,{"v":0,"d":"0.00"},0,0,0,250,0,129267,768154]
[]
[]
[]
[]
[{"$nulls":4},"Signature of Employee",{"$nulls":22},"Signature of DDO"]

{"sheet":"Other Deduction","index":2,"n_rows":23,"n_cols":122,"rows_kept":23,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[9,5,11,5],[14,5,16,5],[17,5,18,5],[20,0,20,1],[21,0,21,1],[22,0,22,5]]}
[]
["वेतन के अतिरिक्त कटौतियाँ, आय/जमा राशि एवं छूट का"]
[{"$f":"'GA-55'!D5& \" ,   \" &'GA-55'!K5&\"                         PAN-  \"&'GA-55'!P5","v":"PARMANAND MEGHWAL ,   SENIOR TEACHER                         PAN-  ASQPM6311G"}]
["1. मकान किराया भत्ता (छूट जो लेनी हैं।)",{"v":51228,"d":"51228.00"},null,"18. बचत खाते की जमा राशि पर प्राप्त ब्याज (80 TTA/80 TTB) हेतु",{"v":0,"d":"0.00"},"BASIC+D.A.",{"$nulls":115},"UPS Kuhada Khurd"]
["2. मनोरंजन भत्ता धारा 16(ii) के अंतर्गत",{"v":0,"d":"0.00"},null,"19. अन्य आय - (एफडी पर ब्याज, अन्य ब्याज या अन्य स्त्रोत से आय आदि का योग)",{"v":0,"d":"0.00"},{"$f":"'GA-55'!N30-'GA-55'!I30","v":844681}]
["3. व्यवसाय कर धारा 16(iii) के अंतर्गत",{"v":0,"d":"0.00"},null,"20. अन्य जमा राशि (धारा 80C के अंतर्गत)",{"v":0,"d":"0.00"},"Taxable Amt"]
["4. गृह संपत्ति से प्राप्त किराया - आय",{"v":0,"d":"0.00"},null,"21. धारा 80CCC -पेंशन प्लान हेतु अंशदान (एनपीएस के अलावा)",{"v":0,"d":"0.00"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
["5. गृहकर",{"v":0,"d":"0.00"},null,"22. 80CCD(1B) - नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रु. 50,000)",{"v":0,"d":"0.00"},"Tax Deposited"]
["6. गृह ऋण किस्त मूल (जो वेतन से नहीं काटा गया)",{"v":0,"d":"0.00"},null,"23. धारा 80D - चिकित्सा बीमा प्रीमियम (सामान्य-25,000 व वरिष्ठ नागरिक 50,000)",{"v":0,"d":"0.00"},{"$f":"'GA-55'!X30","v":{"v":0,"d":"0.00"}}]
["7. गृह ऋण किस्त ब्याज (जो वेतन से नहीं काटा गया)",{"v":0,"d":"0.00"},null,"24. धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम: 75,000 व वरिष्ठ नागरिक 125,000)",{"v":0,"d":"0.00"},"Rebate Under Section\n80C, 80CCC, 80CCD(1)"]
["8. जीवन बीमा प्रीमियम जो  (जो वेतन से नहीं काटा गया) LIC",{"v":0,"d":"0.00"},null,"25. धारा 80DDB - विशिष्ट रोगों के उपचार हेतु (सामान्य 40,000 , वरिष्ठ नागरिक 1 लाख)",{"v":0,"d":"0.00"},{"$nulls":116},"UPS Banediya Charnan"]
["9. पी.एल.आई. (PLI)",{"v":0,"d":"0.00"},null,"26. धारा 80E उच्च शिक्षा हेतु लिए ऋण का ब्याज (धारा 10E)",{"v":0,"d":"0.00"},{"$nulls":116},"UPS Laxmipura Dhakaran"]
["10. ट्यूशन फीस (Tution Fees)",{"v":0,"d":"0.00"},null,"27. धारा 80G धर्मार्थ संस्थाओं आदि को दिये दान (क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)",{"v":0,"d":"0.00"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$nulls":115},"UPS Pathraj Kala"]
["11. यू.एल.आई.पी./वार्षिक प्लान",{"v":0,"d":"0.00"},null,"28. धारा 80U स्थाई रूप से शारीरिक असमर्थता की दशा में (अधिकतम 75,000 तथा अधिनियम 1995 के अनुसार 125,000)",{"v":0,"d":"0.00"}]
["12. राष्ट्रीय बचत पत्र (NSC)",{"v":0,"d":"0.00"},null,"29. धारा  80GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"v":0,"d":"0.00"},"मकान किराया छूट के रशीद की आवश्यकता",{"$nulls":115},"PS Aarampura"]
["13. राष्ट्रीय बचत पत्र पर अदत्त ब्याज",{"v":0,"d":"0.00"},null,"30. इक्विटी लिंक सेविंग स्कीम",{"v":0,"d":"0.00"},{"$nulls":116},"UPS Laxmipura Dhakaran"]
["14. लोक भविष्य निधि (PPF)",{"v":0,"d":"0.00"},null,"31. स्थगित वार्षिकी (Defferred Annuty)",{"v":0,"d":"0.00"},{"$nulls":116},"UPS Raghunathpura"]
["15. राष्ट्रीय बचत स्कीम (NSS)",{"v":0,"d":"0.00"},null,"32.  राहत धारा 89 के तहत",{"v":0,"d":"0.00"},{"$f":"IF(B4>=1,(F5*10%+B4),0)","v":{"v":135696.1,"d":"135696.10"}},{"$nulls":115},"UPS Manda"]
["16. सुकन्या समृद्धि योजना में जमा राशि (SSY)",{"v":0,"d":"0.00"},null,"33. वेतन बिल के अलावा जमा कराया गया आयकर (TDS)",{"v":0,"d":"0.00"},{"$nulls":116},"UPS Sandla"]
["17. धारा 10(14) के अंतर्गत अन्य भत्ते ",{"v":0,"d":"0.00"},null,"34. धारा 80GGC राजनीतिक पार्टियों को दिया गया दान ",{"v":0,"d":"0.00"}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"HRA",{"$f":"'GA-55'!I30","v":{"v":52740,"d":"52740.00"}},{"$nulls":115},"UPS Ramsinghpura"]
[{"$f":"\"Total Rebate of (US 80C, 80CCC,80CCD(1)) =  \"&#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"\"Investable Amount = \"&(150000-#REF!)","v":{"$error":"#REF!"}},{"$nulls":117},"GSS Ganeshganj"]
["WWW.RAJTEACHERS.NET "]

{"sheet":"Form 16","index":3,"n_rows":156,"n_cols":12,"rows_kept":156,"merged":[[0,0,0,11],[0,12,156,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]]}
["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'!M9","v":"RAM DAYAL NAGAR"},{"$nulls":5},{"$f":"'GA-55'!D5","v":"PARMANAND MEGHWAL"}]
[{"$f":"'Master Sheet'!M7","v":"PRINCIPAL"},{"$nulls":5},{"$f":"'GA-55'!K5","v":"SENIOR TEACHER"}]
[{"$f":"'GA-55'!C3","v":"GOVT. SR. SECONDARY SCHOOL, GORDHANPURA, ATRU, BARAN"},{"$nulls":5},{"$f":"'GA-55'!C3","v":"GOVT. SR. SECONDARY SCHOOL, GORDHANPURA, ATRU, BARAN"}]
[]
["PAN of the Deducter",null,null,"TAN of the Deducter",null,null,"PAN of the Employee"]
[{"$nulls":3},{"$f":"'GA-55'!U5","v":"JDHG09699E"},null,null,{"$f":"'GA-55'!P5","v":"ASQPM6311G"}]
["TDS Circle where annual",{"$nulls":5},"PERIOD",null,null,"Assessment Year"]
["return / statement under",{"$nulls":5},"FROM",null,"TO","2025-26"]
["section 206 is to be filed",{"$nulls":5},"01.04.2024",null,"31.03.2025"]
["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},0,null,{"$f":"SUM('GA-55'!X9:X11)","v":0},null,null,{"$f":"H18","v":0}]
["Quarter 2",{"$nulls":4},0,null,{"$f":"SUM('GA-55'!X12:X14)+'GA-55'!X21","v":0},null,null,{"$f":"H19","v":0}]
["Quarter 3",{"$nulls":4},0,null,{"$f":"SUM('GA-55'!X15:X17)+'GA-55'!X24","v":0},null,null,{"$f":"H20","v":0}]
["Quarter 4",{"$nulls":4},0,null,{"$f":"SUM('GA-55'!X18:X29)","v":0},null,null,{"$f":"H21","v":0}]
["Total",{"$nulls":4},{"$f":"SUM(F18:F21)","v":0},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'!X9","v":0}]
[2,{"$f":"'GA-55'!X10","v":0}]
[3,{"$f":"'GA-55'!X11","v":0}]
[4,{"$f":"'GA-55'!X12","v":0}]
[5,{"$f":"'GA-55'!X13","v":0}]
[6,{"$f":"'GA-55'!X14","v":0}]
[7,{"$f":"'GA-55'!X15","v":0}]
[8,{"$f":"'GA-55'!X16","v":0}]
[9,{"$f":"'GA-55'!X17","v":0}]
[10,{"$f":"'GA-55'!X18","v":0}]
[11,{"$f":"'GA-55'!X19","v":0}]
[12,{"$f":"'GA-55'!X20","v":0}]
[13,{"$f":"SUM('GA-55'!X21+'GA-55'!X22+'GA-55'!X23+'GA-55'!X24+'GA-55'!X25+'GA-55'!X26+'GA-55'!X27+'GA-55'!X28+'GA-55'!X29)","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'!M5","v":"RAJENDRA KUMAR CHITTORA"},null,null,"Son/Doughter of ",null,{"$f":"'Master Sheet'!M6","v":"RAM LAL"},null,null,"  Working In the Capacity Of"]
[{"$f":"'Master Sheet'!M7","v":"PRINCIPAL"},null,null,"(Designation) do hereby certify that a sum  of Rs.",{"$nulls":4},{"$f":"#REF!","v":{"$error":"#REF!"}},"(in words)"]
[{"$nulls":5},"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},1187667]
[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":1187667}]
[]
["2. Less : Allowance to the extent exempt under section 10"]
["a)HRA",{"$nulls":7},0]
["b)Other"]
["3. Balance (1-2)",{"$nulls":8},{"$f":"J90-I93-I94","v":1187667}]
[]
["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.",2500]
["5. Aggregate of 4 (a to c)",{"$nulls":7},{"$f":"+G98+G99+G100","v":52500}]
[]
["6. Income chargeable under the Head ‘Salaries’(3-5)",{"$nulls":10},{"$f":"IF(AND((J95>50000)),(J95-I101),0)","v":1135167}]
[]
["7. Add. : Any other income reported by the employee"]
[null,"Less:-  Loss From House Properties",{"$nulls":9},21064]
[]
["8. Gross total income  (6+7)",{"$nulls":10},{"$f":"L103+L105-L106","v":1114103}]
[{"$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.",235639,null,{"$f":"G113","v":235639},null,{"$f":"I113","v":235639}]
[null,"(ii)","STATE INSURANCE",null,null,"Rs.",0,null,0,null,0]
[null,"(iii)","LIC",null,null,"Rs.",24192,null,24192,null,24192]
[null,"(iv)","Group Ins.",null,null,"Rs.",531,null,531,null,531]
[null,"(vi)","House Loan Installment",null,null,"Rs.",50563,null,50563,null,50563]
[null,"(vii)","Others",null,null,"Rs.",12,null,12,null,12]
["(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":310937},null,{"$f":"SUM(I113:I120)","v":310937},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)","Other Deductions",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":"+L108-K132","v":964103}]
[]
["12. Tax on Total Income ",{"$nulls":9},{"$f":"Sheet1!O5","v":{"v":105320.6,"d":"105321"}}]
["13. Rebate U/S 87a",{"$nulls":9},0]
["14. Tax Payable on total income (12-13)",{"$nulls":9},{"$f":"+K136-K137","v":{"v":105320.6,"d":"105321"}}]
["15.Education & Health Cess 4%",{"$nulls":9},{"$f":"ROUND(K138*0.04,0)","v":4213}]
["16. Tax payable (14+15)",{"$nulls":9},{"$f":"+K138+K139","v":{"v":109533.6,"d":"109534"}}]
["17. Relife Under Section 89 (attach details)",{"$nulls":9},0]
["18. Tax payable (16-17)",{"$nulls":9},{"$f":"K140-K141","v":{"v":109533.6,"d":"109534"}}]
["19.Tax Deducted at source U/S 192",{"$nulls":9},0]
["20. Tax payable / refundable (17-18)",{"$nulls":9},{"$f":"K141-K142","v":{"v":-109533.6,"d":"-109534"}}]
["Verification"]
["I,",{"$f":"B63","v":"RAJENDRA KUMAR CHITTORA"},null,null,"Son/Doughter of ",null,{"$f":"G63","v":"RAM 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":"'Master Sheet'!M5","v":"RAJENDRA KUMAR CHITTORA"}]
["Date:",{"$nulls":4},"Designation",null,{"$f":"'Master Sheet'!M7","v":"PRINCIPAL"}]

{"sheet":"Sheet1","index":4,"n_rows":5,"n_cols":17,"rows_kept":5,"hidden":true,"merged":[[0,0,0,2],[0,3,0,4],[0,5,0,7],[0,9,0,11],[1,0,1,2],[1,3,1,4],[1,5,1,7],[1,9,1,11],[2,0,2,2],[2,3,2,4],[2,5,2,7],[2,9,2,11],[3,0,3,2],[3,3,3,4],[3,5,3,7],[3,9,3,11],[4,0,4,12]]}
["2,50,000 rd",null,null,"Nil",null,"3,00,000 rd",null,null,"Nil",{"$nulls":4},"#-",{"v":0,"d":"0.00"}]
["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 rd",null,null,"Nil","#-",{"$f":"IF(Q2<250001,0,IF(Q2>500000,12500,((Q2-250000)*0.05)))","v":{"v":12500,"d":"12500.00"}},null,{"$f":"'Form 16'!K134","v":964103}]
["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(Q2<500001,0,IF(Q2>1000000,100000,((Q2-500000)*0.2))))","v":{"v":92820.6,"d":"92820.60"}}]
["10,00,000 ls vf/kd",null,null,{"v":0.3,"d":"30%"},null,"10,00,000 ls vf/kd",null,null,{"v":0.3,"d":"30%"},"10,00,000 ls vf/kd",null,null,{"v":0.3,"d":"30%"},"#-",{"$f":"IF(Q2<1000001,0,((Q2-1000000)*0.3))","v":{"v":0,"d":"0.00"}}]
["¼1½ ;ksx vk;dj",{"$nulls":12},"#-",{"$f":"SUM(O1:O4)","v":{"v":105320.6,"d":"105320.60"}}]