{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Master Sheet","GA-55","Other Deduction","Tax Old Regime","Tax New Regime","Form 16","Hra Receipt"],"not_rendered":{"images":1,"macros":1,"external_links":1,"defined_names":343},"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":"'Tax Old Regime'!Q48","v":675070}]
["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":"'Tax Old Regime'!Q32","v":121121},{"$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":"'Tax Old Regime'!B64","v":"Income Tax Payable"},null,null,{"$f":"'Tax Old Regime'!Q64","v":{"v":46815,"d":"46815.00"}},"HRA",{"$f":"'GA-55'!I30","v":{"v":52740,"d":"52740.00"}},{"$nulls":115},"UPS Ramsinghpura"]
[{"$f":"\"Total Rebate of (US 80C, 80CCC,80CCD(1)) =  \"&'Tax Old Regime'!Q32","v":"Total Rebate of (US 80C, 80CCC,80CCD(1)) =  121121"},null,null,{"$f":"\"Investable Amount = \"&(150000-'Tax Old Regime'!Q32)","v":"Investable Amount = 28879"},{"$nulls":117},"GSS Ganeshganj"]
["WWW.RAJTEACHERS.NET "]

{"sheet":"Tax Old Regime","index":3,"n_rows":66,"n_cols":17,"rows_kept":66,"merged":[[0,1,0,16],[1,1,1,16],[2,1,2,16],[3,2,3,3],[3,4,3,9],[3,11,3,13],[3,15,3,16],[4,2,4,14],[5,2,5,14],[6,2,6,14],[7,2,7,14],[8,1,10,1],[8,2,8,11],[8,12,8,14],[8,15,9,16],[9,2,9,11],[9,12,9,14],[10,2,10,11],[10,12,10,14],[11,2,11,14],[12,1,14,1],[12,2,12,9],[12,10,12,11],[12,12,12,14],[12,15,14,16],[13,2,14,3],[13,4,13,6],[13,7,13,9],[13,10,13,11],[13,12,13,14],[14,4,14,6],[14,7,14,9],[14,10,14,11],[14,12,14,14],[15,2,15,14],[16,2,16,14],[17,2,17,14],[18,2,18,14],[19,1,33,1],[19,2,19,16],[20,2,20,16],[21,3,21,6],[21,10,21,12],[21,15,30,16],[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,3,29,6],[29,10,29,12],[30,2,30,12],[31,2,31,14],[32,2,32,14],[33,2,33,14],[34,1,44,1],[34,2,34,16],[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,2,47,14],[48,1,58,1],[48,2,48,16],[49,2,49,6],[49,7,49,10],[49,11,49,14],[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,14],[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,1,62,1],[61,2,62,4],[61,5,61,8],[61,9,61,10],[61,12,61,13],[61,15,61,16],[62,5,62,8],[62,9,62,10],[62,12,62,13],[62,15,62,16],[63,1,63,14],[65,3,65,4],[65,12,65,15],[67,2,69,16],[70,11,76,16],[75,3,75,9]]}
[]
[null,{"$f":"'GA-55'!C3","v":"GOVT. SR. SECONDARY SCHOOL, GORDHANPURA, ATRU, BARAN"}]
[null,"आयकर गणना प्रपत्र वर्ष 2022-23 (कर निर्धारण वर्ष 2023-24)"]
[null,1,"नाम कर्मचारी :",null,{"$f":"'GA-55'!D5","v":"PARMANAND MEGHWAL"},{"$nulls":5},"पद :",{"$f":"'GA-55'!K5","v":"SENIOR TEACHER"},null,null,"PAN :",{"$f":"IF('GA-55'!P5=\"\",\"\",'GA-55'!P5)","v":"ASQPM6311G"}]
[null,2,"आय: वर्ष-2022-23 में प्राप्त कुल वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"रु.",{"$f":"'GA-55'!N30","v":{"v":897421,"d":"897421.00"}}]
[null,3,"(i) गृह किराया, धारा 10(13-A) के अंतर्गत जो कर मुक्त हैं।",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!B4","v":{"v":51228,"d":"51228.00"}}]
[null,null,"(ii) धारा 10(14) के अंतर्गत अन्य भत्ते ",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!B20","v":{"v":0,"d":"0.00"}}]
[null,4,"                                                शेष (2-3)",{"$nulls":12},"रु.",{"$f":"Q5-Q6-Q7","v":{"v":846193,"d":"846193.00"}}]
[null,5,"(i) मनोरंजन भत्ता धारा 16(ii) के अंतर्गत (अधिकतम सीमा रु. 5000)",{"$nulls":9},{"$f":"'Other Deduction'!B5","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii) व्यवसाय कर धारा 16(iii) के अंतर्गत",{"$nulls":9},{"$f":"'Other Deduction'!B6","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction) 50,000 (अधिकतम)",{"$nulls":9},{"$f":"IF(Q8<50000,Q8,50000)","v":{"v":50000,"d":"50000.00"}},null,null,"रु.",{"$f":"SUM(M9:O11)","v":{"v":50000,"d":"50000.00"}}]
[null,6,"                                                                                             शेष (4-5)",{"$nulls":12},"रु.",{"$f":"Q8-Q11","v":{"v":796193,"d":"796193.00"}}]
[null,7,"(अ) गृह संपत्ति से आय (1)स्वयं के उपयोग में शून्य",{"$nulls":7},"(2) प्राप्त किराया रु.",null,{"$f":"'Other Deduction'!B7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ब) घटाये",null,"किराए का 30%",null,null,"गृह ऋण पर ब्याज",null,null,"गृहकर",null,"योग 7(ब)"]
[{"$nulls":4},{"$f":"ROUND(M13*0.3,0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(('GA-55'!W30+'Other Deduction'!B10)>200000,200000,('GA-55'!W30+'Other Deduction'!B10))","v":{"v":0,"d":"0.00"}},null,null,{"$f":"'Other Deduction'!B8","v":{"v":0,"d":"0.00"}},null,{"$f":"E15+H15+K15","v":{"v":0,"d":"0.00"}}]
[null,null,"                                            शेष -/+(7(अ) एवं योग 7(ब) का",{"$nulls":12},"रु.",{"$f":"M13-M15","v":{"v":0,"d":"0.00"}}]
[null,8,"                                                        कुल शेष -/+(6  एवं 7)",{"$nulls":12},"रु.",{"$f":"Q12+Q16","v":{"v":796193,"d":"796193.00"}}]
[null,9,"अन्य आय",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E4+'Other Deduction'!E5","v":{"v":0,"d":"0.00"}}]
[null,10,"सकल आय                                                                                                                                          योग (8+9)",{"$nulls":12},"रु.",{"$f":"Q17+Q18","v":{"v":796193,"d":"796193.00"}}]
[null,11,"घटाइए कटौतियाँ - धारा US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1,50,000/- (धारा 80CCE) के अलावा"]
[null,null,"(i)","राज्य बीमा (SI)",{"$nulls":3},"रु.",{"$f":"'GA-55'!Q30","v":{"v":48000,"d":"48000.00"}},"(x)","पेंशन प्लान हेतु अंशदान धारा (80CCC)",null,null,"रु.",{"$f":"'Other Deduction'!E7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)","जीवन बीमा प्रीमियम (LIC)",{"$nulls":3},"रु.",{"$f":"'GA-55'!T30+'Other Deduction'!B11","v":{"v":27000,"d":"27000.00"}},"(xi)","राष्ट्रीय बचत पत्र पर आदत्त ब्याज",null,null,"रु.",{"$f":"'Other Deduction'!B16","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},"रु.",{"$f":"'Other Deduction'!B15","v":{"v":0,"d":"0.00"}},"(xii)","ट्यूशन फीस",null,null,"रु.",{"$f":"'Other Deduction'!B13","v":{"v":0,"d":"0.00"}}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",{"$nulls":3},"रु.",{"$f":"'Other Deduction'!B17","v":{"v":0,"d":"0.00"}},"(xiii)"," इक्विटी लिंक सेविंग स्कीम",null,null,"रु.",{"$f":"'Other Deduction'!E16","v":{"v":0,"d":"0.00"}}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम (NSS)",{"$nulls":3},"रु.",{"$f":"'Other Deduction'!B18","v":{"v":0,"d":"0.00"}},"(xv)","स्थगित वार्षिकी (Defferred Annuty)",null,null,"रु.",{"$f":"'Other Deduction'!E17","v":{"v":0,"d":"0.00"}}]
[null,null,"(vi)","सामान्य प्रावधायी निधि (GPF/GPF 2004)",{"$nulls":3},"रु.",{"$f":"'GA-55'!O30","v":{"v":46121,"d":"46121.00"}},"(xiv)","पी.एल.आई. (PLI)",null,null,"रु.",{"$f":"'Other Deduction'!B12","v":{"v":0,"d":"0.00"}}]
[null,null,"(vii)","सामूहिक बीमा प्रीमियम (G.Ins.)",{"$nulls":3},"रु.",{"$f":"'GA-55'!U10","v":{"v":0,"d":"0.00"}},"(xvi)","अन्य जमा राशि (80C के अंतर्गत)",null,null,"रु.",{"$f":"'Other Deduction'!E6","v":{"v":0,"d":"0.00"}}]
[null,null,"(viii)","यू.एल.आई.पी./वार्षिक प्लान",{"$nulls":3},"रु.",{"$f":"'Other Deduction'!B14","v":{"v":0,"d":"0.00"}},"(xvii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"रु.",{"$f":"'Other Deduction'!B19","v":{"v":0,"d":"0.00"}}]
[null,null,"(ix)","गृह ऋण किश्त (HBA Premium)",{"$nulls":3},"रु.",{"$f":"'GA-55'!V30+'Other Deduction'!B9","v":{"v":0,"d":"0.00"}},"(xviii)",{"$nulls":3},"रु."]
[null,null,"योग (i से XViii) ",{"$nulls":10},"रु.",{"$f":"SUM(I22:I30)+SUM(O22:O30)","v":{"v":121121,"d":"121121.00"}}]
[null,null,"अधिकतम कटौती की राशि 1.50 लाख रु. तक",{"$nulls":12},"रु.",{"$f":"IF(O31<150001,ROUND(O31,0),150000)","v":{"v":121121,"d":"121121.00"}}]
[null,null,"(B) घटाइए - धारा 80CCD 1(B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रु. 50,000)",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E8","v":{"v":0,"d":"0.00"}}]
[null,null,"योग 11(A+B+C)      ",{"$nulls":12},"रु.",{"$f":"SUM(Q32:Q33)","v":{"v":121121,"d":"121121.00"}}]
[null,12,"अन्य कटौतियाँ"]
[null,null,"1-धारा 80D, चिकित्सा बीमा प्रीमियम (स्वयं, पति/पत्नी व बच्चों के लिए रु. 25000, माता-पिता के लिए रु. 25000, सीनियर सिटीजन  रु. 50,000)",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E9","v":{"v":0,"d":"0.00"}}]
[null,null,"2-धारा 80D, विकलांग आश्रितों के चिकित्सा आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80% या अधिक विकलांगता रु. 125000)",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E10","v":{"v":0,"d":"0.00"}}]
[null,null,"3-धारा 80D विशीष्ट रोगों के उपचार हेतु कटौती (अधिकतम रु. 40,000 , सीनियर सिटीजन  हेतु रु. 100,000)",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E11","v":{"v":0,"d":"0.00"}}]
[null,null,"4-धारा 80D, उच्च शिक्षा हेतु लिए ऋण का ब्याज",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E12","v":{"v":0,"d":"0.00"}}]
[null,null,"5-धारा 80G धर्मार्थ संस्थाओं आदि को दिये दान (क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E13","v":{"v":0,"d":"0.00"}}]
[null,null,"6-धारा 80U स्थाई रूप से शारीरिक असमर्थता की दशा में (अधिकतम 75,000 तथा अधिनियम 1995 के अनुसार 125,000)",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E14","v":{"v":0,"d":"0.00"}}]
[null,null,"7-धारा 80 TTA बचत खाते पर अधिकतम ब्याज रु. 10,000 194(1A) (80TTB-वरिष्ठ नागरिक अधिकतम ब्याज 50,000 रु.)",{"$nulls":12},"रु.",{"$f":"IF('GA-55'!AB1<>\"No\",IF('Other Deduction'!E4<50001,'Other Deduction'!E4,50000),IF('Other Deduction'!E4<10001,'Other Deduction'!E4,10000))","v":{"v":0,"d":"0.00"}}]
[null,null,"8-धारा  80GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E15","v":{"v":0,"d":"0.00"}}]
[null,null,"9-धारा 80GGC राजनीतिक पार्टियों को दिया गया दान ",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E20","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल योग 12 (1 से 9 तक)",{"$nulls":12},"रु.",{"$f":"SUM(Q36:Q44)","v":{"v":0,"d":"0.00"}}]
[null,13,"कुल कटौती ( 11 + 12)",{"$nulls":12},"रु.",{"$f":"Q34+Q45","v":{"v":121121,"d":"121121.00"}}]
[null,14,"कर योग्य आय ( 10-13 )",{"$nulls":12},"रु.",{"$f":"(Q19-Q46)","v":{"v":675072,"d":"675072.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणज में करना) धारा 288A",{"$nulls":12},"रु.",{"$f":"ROUND(Q47,-1)","v":{"v":675070,"d":"675070.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 तक",{"$nulls":3},"रु.",{"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,"Nil","रु.",{"$f":"ROUND(IF('GA-55'!AB1=\"No\",IF(Q48<250001,0,IF(Q48>500000,12500,((Q48-250000)*0.05))),IF(Q48<300001,0,IF(Q48>500000,10000,((Q48-300000)*0.05)))),0)","v":{"v":10000,"d":"10000.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(Q48<500001,0,IF(Q48>1000000,100000,((Q48-500000)*0.2)))","v":{"v":35014,"d":"35014.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(Q48<1000001,0,((Q48-1000000)*0.3))","v":{"v":0,"d":"0.00"}}]
[null,null,"(1) योग आयकर",{"$nulls":12},"रु.",{"$f":"SUM(Q51:Q54)","v":{"v":45014,"d":"45014.00"}}]
[null,null,"(2) छूट धारा 87(A) (2.50 लाख से 5.00 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रु. 12,500 तक)",{"$nulls":12},"रु.",{"$f":"IF(Q48>500000,0,IF(Q55<12501,Q55,12500))","v":{"v":0,"d":"0.00"}}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":12},"रु.",{"$f":"Q55-Q56","v":{"v":45014,"d":"45014.00"}}]
[null,null,"(4) शिक्षा उपकार 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"रु.",{"$f":"ROUND(Q57*0.04,0)","v":{"v":1801,"d":"1801.00"}}]
[null,null,"कुल आयकर (3+4)",{"$nulls":12},"रु.",{"$f":"SUM(Q57:Q58)","v":{"v":46815,"d":"46815.00"}}]
[null,17,"घटाइए : राहत धारा 89 के तहत",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E18","v":{"v":0,"d":"0.00"}}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"रु.",{"$f":"Q59-Q60","v":{"v":46815,"d":"46815.00"}}]
[null,19,"आयकर कटौती का विवरण",null,null,"सितम्बर 2022 तक रु.",{"$nulls":3},"दिसम्बर 2022 तक रु.",null,"जनवरी 2023 तक रु.","फरवरी 2023 तक रु.",null,"टी.डी.एस. रु.","योग कॉलम 19"]
[{"$nulls":5},{"$f":"SUM('GA-55'!X9:X15)","v":0},{"$nulls":3},{"$f":"SUM('GA-55'!X16:X18)","v":0},null,{"$f":"'GA-55'!X19","v":0},{"$f":"'GA-55'!X20","v":0},null,{"$f":"SUM('GA-55'!X21:X29)+'Other Deduction'!E19","v":0},{"$f":"F63+J63+L63+M63+O63","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(Q61>P63,\"Income Tax Payable\",IF(Q61<P63,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},{"$nulls":13},"रु.",{"$f":"IF(Q61>P63,Q61-P63,P63-Q61)","v":{"v":46815,"d":"46815.00"}}]
[]
[{"$nulls":3},"हस्ताक्षर कार्मिक",{"$nulls":8},"हस्ताक्षर डीडीओ"]

{"sheet":"Tax New Regime","index":4,"n_rows":69,"n_cols":17,"rows_kept":69,"merged":[[0,1,0,16],[1,1,1,16],[2,1,2,16],[3,2,3,3],[3,4,3,9],[3,11,3,13],[3,15,3,16],[4,2,4,14],[5,2,5,14],[6,2,6,14],[7,2,7,14],[8,1,10,1],[8,2,8,11],[8,12,8,14],[8,15,9,16],[9,2,9,11],[9,12,9,14],[10,2,10,11],[10,12,10,14],[11,2,11,14],[12,1,14,1],[12,2,12,9],[12,10,12,11],[12,12,12,14],[12,15,14,16],[13,2,14,3],[13,4,13,6],[13,7,13,9],[13,10,13,11],[13,12,13,14],[14,4,14,6],[14,7,14,9],[14,10,14,11],[14,12,14,14],[15,2,15,14],[16,2,16,14],[17,2,17,14],[18,2,18,14],[19,1,33,1],[19,2,19,16],[20,2,20,16],[21,3,21,6],[21,10,21,12],[21,15,30,16],[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,3,29,6],[29,10,29,12],[30,2,30,12],[31,2,31,14],[32,2,32,14],[33,2,33,14],[34,1,44,1],[34,2,34,16],[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,2,47,14],[48,1,61,1],[48,2,48,16],[49,2,49,6],[49,7,49,10],[49,11,49,14],[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,4],[55,5,55,6],[55,7,55,9],[55,11,55,13],[56,2,56,4],[56,5,56,6],[56,7,56,9],[56,11,56,13],[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,2,63,14],[64,1,65,1],[64,2,65,4],[64,5,64,8],[64,9,64,10],[64,12,64,13],[64,15,64,16],[65,5,65,8],[65,9,65,10],[65,12,65,13],[65,15,65,16],[66,1,66,14],[68,3,68,5],[70,2,72,16],[73,11,79,16],[78,3,78,9]]}
[]
[null,{"$f":"'GA-55'!C3","v":"GOVT. SR. SECONDARY SCHOOL, GORDHANPURA, ATRU, BARAN"}]
[null,"आयकर गणना प्रपत्र वर्ष 2022-23 (कर निर्धारण वर्ष 2023-24)"]
[null,1,"नाम कर्मचारी :",null,{"$f":"'GA-55'!D5","v":"PARMANAND MEGHWAL"},{"$nulls":5},"पद :",{"$f":"'GA-55'!K5","v":"SENIOR TEACHER"},null,null,"PAN :",{"$f":"IF('GA-55'!P5=\"\",\"\",'GA-55'!P5)","v":"ASQPM6311G"}]
[null,2,"आय: वर्ष-2022-23 में प्राप्त कुल वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"रु.",{"$f":"'GA-55'!N30","v":{"v":897421,"d":"897421.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,"                                                                                                       शेष (2-3)",{"$nulls":12},"रु.",{"$f":"Q5-Q6-Q7","v":{"v":897421,"d":"897421.00"}}]
[null,5,"(i) मनोरंजन भत्ता धारा 16(ii) के अंतर्गत (अधिकतम सीमा रु. 5000)",{"$nulls":9},{"$f":"'Other Deduction'!B5","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii) व्यवसाय कर धारा 16(iii) के अंतर्गत",{"$nulls":9},{"$f":"'Other Deduction'!B6","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction) 50,000 (अधिकतम)",{"$nulls":9},{"v":0,"d":"0.00"},null,null,"रु.",{"$f":"SUM(M9:O11)","v":{"v":0,"d":"0.00"}}]
[null,6,"                                                                                                     शेष (4-5)",{"$nulls":12},"रु.",{"$f":"Q8-Q11","v":{"v":897421,"d":"897421.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(M13*0.3,0)","v":{"v":0,"d":"0.00"}},null,null,{"v":0,"d":"0.00"},null,null,{"$f":"'Other Deduction'!B8","v":{"v":0,"d":"0.00"}},null,{"$f":"E15+H15+K15","v":{"v":0,"d":"0.00"}}]
[null,null,"                                            शेष -/+(7(अ) एवं योग 7(ब) का",{"$nulls":12},"रु.",{"$f":"M13-M15","v":{"v":0,"d":"0.00"}}]
[null,8,"                                                        कुल शेष -/+(6  एवं 7)",{"$nulls":12},"रु.",{"$f":"Q12+Q16","v":{"v":897421,"d":"897421.00"}}]
[null,9,"अन्य आय",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E4+'Other Deduction'!E5","v":{"v":0,"d":"0.00"}}]
[null,10,"सकल आय                                                                                                                                          योग (8+9)",{"$nulls":12},"रु.",{"$f":"Q17+Q18","v":{"v":897421,"d":"897421.00"}}]
[null,11,"घटाइए कटौतियाँ - धारा US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1,50,000/- (धारा 80CCE) के अलावा"]
[null,null,"(i)","राज्य बीमा (SI)",{"$nulls":3},"रु.",{"$f":"'GA-55'!Q30","v":{"v":48000,"d":"48000.00"}},"(x)","पेंशन प्लान हेतु अंशदान धारा (80CCC)",null,null,"रु.",{"$f":"'Other Deduction'!E7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)","जीवन बीमा प्रीमियम (LIC)",{"$nulls":3},"रु.",{"$f":"'GA-55'!T30+'Other Deduction'!B11","v":{"v":27000,"d":"27000.00"}},"(xi)","राष्ट्रीय बचत पत्र पर आदत्त ब्याज",null,null,"रु.",{"$f":"'Other Deduction'!B16","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},"रु.",{"$f":"'Other Deduction'!B15","v":{"v":0,"d":"0.00"}},"(xii)","ट्यूशन फीस",null,null,"रु.",{"$f":"'Other Deduction'!B13","v":{"v":0,"d":"0.00"}}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",{"$nulls":3},"रु.",{"$f":"'Other Deduction'!B17","v":{"v":0,"d":"0.00"}},"(xiii)"," इक्विटी लिंक सेविंग स्कीम",null,null,"रु.",{"$f":"'Other Deduction'!E16","v":{"v":0,"d":"0.00"}}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम (NSS)",{"$nulls":3},"रु.",{"$f":"'Other Deduction'!B18","v":{"v":0,"d":"0.00"}},"(xv)","स्थगित वार्षिकी (Defferred Annuty)",null,null,"रु.",{"$f":"'Other Deduction'!E17","v":{"v":0,"d":"0.00"}}]
[null,null,"(vi)","सामान्य प्रावधायी निधि (GPF/GPF 2004)",{"$nulls":3},"रु.",{"$f":"'GA-55'!O30","v":{"v":46121,"d":"46121.00"}},"(xiv)","पी.एल.आई. (PLI)",null,null,"रु.",{"$f":"'Other Deduction'!B12","v":{"v":0,"d":"0.00"}}]
[null,null,"(vii)","सामूहिक बीमा प्रीमियम (G.Ins.)",{"$nulls":3},"रु.",{"$f":"'GA-55'!U10","v":{"v":0,"d":"0.00"}},"(xvi)","अन्य जमा राशि (80C के अंतर्गत)",null,null,"रु.",{"$f":"'Other Deduction'!E6","v":{"v":0,"d":"0.00"}}]
[null,null,"(viii)","यू.एल.आई.पी./वार्षिक प्लान",{"$nulls":3},"रु.",{"$f":"'Other Deduction'!B14","v":{"v":0,"d":"0.00"}},"(xvii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"रु.",{"$f":"'Other Deduction'!B19","v":{"v":0,"d":"0.00"}}]
[null,null,"(ix)","गृह ऋण किश्त (HBA Premium)",{"$nulls":3},"रु.",{"$f":"'GA-55'!V30+'Other Deduction'!B9","v":{"v":0,"d":"0.00"}},"(xviii)",{"$nulls":3},"रु."]
[null,null,"योग (i से XViii) ",{"$nulls":10},"रु.",{"$f":"SUM(I22:I30)+SUM(O22:O30)","v":{"v":121121,"d":"121121.00"}}]
[null,null,"अधिकतम कटौती की राशि 1.50 लाख रु. तक",{"$nulls":12},"रु.",{"v":0,"d":"0.00"}]
[null,null,"(B) घटाइए - धारा 80CCD 1(B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रु. 50,000)",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E8","v":{"v":0,"d":"0.00"}}]
[null,null,"  योग 11(A+B+C)      ",{"$nulls":12},"रु.",{"$f":"SUM(Q32:Q32)","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":"Q34+Q45","v":{"v":0,"d":"0.00"}}]
[null,14,"कर योग्य आय ( 10-13 )",{"$nulls":12},"रु.",{"$f":"(Q19-Q46)","v":{"v":897421,"d":"897421.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणज में करना) धारा 288A",{"$nulls":12},"रु.",{"$f":"ROUND(Q47,-1)","v":{"v":897420,"d":"897420.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,"2,50,001-5,00,000",null,null,{"v":0.05,"d":"5%"},"5,00,000 rd",null,null,{"v":0.05,"d":"5%"},"रु.",{"$f":"ROUND(IF('GA-55'!AB1=\"No\",IF(Q48<250001,0,IF(Q48>500000,12500,((Q48-250000)*0.05))),IF(Q48<300001,0,IF(Q48>500000,10000,((Q48-300000)*0.05)))),0)","v":{"v":10000,"d":"10000.00"}}]
[null,null,"5,00,001-7,50,000",null,null,{"v":0.1,"d":"10%"},null,"5,00,001-7,50,000",null,null,{"v":0.1,"d":"10%"},"5,00,001-7,50,000",null,null,{"v":0.1,"d":"10%"},"रु.",{"$f":"IF(Q48<500001,0,IF(Q48>750000,25000,((Q48-500000)*0.1)))","v":{"v":25000,"d":"25000.00"}}]
[null,null,"7,50,001-10,00,000",null,null,{"v":0.15,"d":"15%"},null,"7,50,001-10,00,000",null,null,{"v":0.15,"d":"15%"},"7,50,001-10,00,000",null,null,{"v":0.15,"d":"15%"},"रु.",{"$f":"IF(Q48<750001,0,IF(Q48>1000000,37500,((Q48-750000)*0.15)))","v":{"v":22113,"d":"22113.00"}}]
[null,null,"10,00,001-12,50,000",null,null,{"v":0.2,"d":"20%"},null,"10,00,001-12,50,000",null,null,{"v":0.2,"d":"20%"},"10,00,001-12,50,000",null,null,{"v":0.2,"d":"20%"},"रु.",{"$f":"IF(Q48<1000001,0,IF(Q48>1250000,50000,((Q48-1000000)*0.2)))","v":{"v":0,"d":"0.00"}}]
[null,null,"12,50,001-15,00.000",null,null,{"v":0.25,"d":"25%"},null,"12,50,001-15,00.000",null,null,{"v":0.25,"d":"25%"},"12,50,001-15,00.000",null,null,{"v":0.25,"d":"25%"},"रु.",{"$f":"IF(Q48<1250001,0,IF(Q48>1500000,62500,((Q48-1250000)*0.25)))","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(Q48<1500001,0,((Q48-1500000)*0.3))","v":{"v":0,"d":"0.00"}}]
[null,null,"(1) योग आयकर",{"$nulls":12},"रु.",{"$f":"SUM(Q51:Q57)","v":{"v":57113,"d":"57113.00"}}]
[null,null,"(2) छूट धारा 87(A) (2.50 लाख से 5.00 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रु. 12,500 तक)",{"$nulls":12},"रु.",{"$f":"IF(Q48>500000,0,IF(Q58<12501,Q58,12500))","v":{"v":0,"d":"0.00"}}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":12},"रु.",{"$f":"Q58-Q59","v":{"v":57113,"d":"57113.00"}}]
[null,null,"(4) शिक्षा उपकार 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"रु.",{"$f":"ROUND(Q60*0.04,0)","v":{"v":2285,"d":"2285.00"}}]
[null,null,"कुल आयकर (3+4)",{"$nulls":12},"रु.",{"$f":"SUM(Q60:Q61)","v":{"v":59398,"d":"59398.00"}}]
[null,17,"घटाइए : राहत धारा 89 के तहत",{"$nulls":12},"रु.",{"$f":"'Other Deduction'!E18","v":{"v":0,"d":"0.00"}}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"रु.",{"$f":"Q62-Q63","v":{"v":59398,"d":"59398.00"}}]
[null,19,"आयकर कटौती का विवरण",null,null,"सितम्बर 2022 तक रु.",{"$nulls":3},"दिसम्बर 2022 तक रु.",null,"जनवरी 2023 तक रु.","फरवरी 2023 तक रु.",null,"टी.डी.एस. रु.","योग कॉलम 19"]
[{"$nulls":5},{"$f":"SUM('GA-55'!X9:X15)","v":0},{"$nulls":3},{"$f":"SUM('GA-55'!X16:X18)","v":0},null,{"$f":"'GA-55'!X19","v":0},{"$f":"'GA-55'!X20","v":0},null,{"$f":"SUM('GA-55'!X21:X29)+'Other Deduction'!E19","v":0},{"$f":"F66+J66+L66+M66+O66","v":{"v":0,"d":"0.00"}}]
[null,{"$f":"IF(Q64>P66,\"Income Tax Payable\",IF(Q64<P66,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},{"$nulls":13},"रु.",{"$f":"IF(Q64>P66,Q64-P66,P66-Q64)","v":{"v":59398,"d":"59398.00"}}]
[]
[{"$nulls":3},"हस्ताक्षर कार्मिक",{"$nulls":10},"हस्ताक्षर डीडीओ"]

{"sheet":"Form 16","index":5,"n_rows":157,"n_cols":12,"rows_kept":157,"merged":[[0,0,0,11],[1,0,1,11],[1,12,157,12],[2,0,2,11],[3,0,3,11],[4,0,4,11],[5,0,5,11],[6,0,6,5],[6,6,6,11],[7,0,7,5],[7,6,7,11],[8,0,8,5],[8,6,8,11],[9,0,10,5],[9,6,10,11],[11,0,11,2],[11,3,11,5],[11,6,11,11],[12,0,12,2],[12,3,12,5],[12,6,12,11],[13,3,15,5],[13,6,13,8],[13,9,13,11],[14,6,14,7],[14,9,15,11],[15,6,15,7],[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,1],[22,2,22,4],[22,5,22,6],[22,7,22,9],[22,10,22,11],[23,0,23,11],[24,1,24,3],[24,4,24,11],[25,1,25,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[27,1,27,3],[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],[29,4,29,5],[29,6,29,7],[29,8,29,9],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[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],[39,4,39,5],[39,6,39,7],[39,8,39,9],[40,1,40,3],[41,1,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[43,0,43,11],[44,1,44,3],[44,4,44,11],[45,1,45,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[46,4,46,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[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],[59,6,59,7],[59,8,59,9],[60,1,60,3],[61,1,61,3],[61,4,61,5],[61,6,61,11],[62,0,62,11],[63,1,63,3],[63,6,63,8],[64,0,64,2],[64,9,64,10],[65,0,65,4],[66,0,67,11],[68,0,68,1],[69,0,69,11],[70,0,70,11],[71,0,71,11],[72,0,72,11],[73,0,73,6],[74,0,74,11],[75,0,75,11],[76,0,76,11],[77,0,77,11],[78,0,78,11],[79,0,79,4],[82,0,82,11],[83,0,83,11],[90,9,90,10],[93,0,93,6],[94,0,94,6],[95,9,95,10],[109,6,111,7],[109,8,111,9],[109,10,111,11],[110,0,110,3],[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,2,116,4],[116,6,116,7],[116,8,116,9],[116,10,116,11],[117,6,117,7],[117,8,117,9],[117,10,117,11],[118,2,118,4],[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],[121,6,121,7],[121,8,121,9],[121,10,121,11],[124,6,124,7],[124,8,124,9],[124,10,124,11],[125,6,125,7],[125,8,125,9],[125,10,125,11],[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,2,131,4],[131,6,131,7],[131,8,131,9],[131,10,131,11],[132,6,132,7],[132,8,132,9],[132,10,132,11],[133,10,133,11],[134,10,134,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,10,144,11],[145,0,145,11],[146,1,146,3],[146,6,146,8],[147,0,147,2],[148,0,148,11],[153,5,153,11],[154,5,154,11],[155,0,155,2],[155,7,155,11],[156,0,156,2],[156,7,156,11],[157,5,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'!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","2023-24"]
["section 206 is to be filed",{"$nulls":5},"01.04.2022",null,"31.03.2023"]
["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'!N9+'GA-55'!N10+'GA-55'!N11)","v":204054},null,{"$f":"SUM('GA-55'!X9:X11)","v":0},null,null,{"$f":"H19","v":0}]
["Quarter 2",{"$nulls":4},{"$f":"SUM('GA-55'!N12+'GA-55'!N13+'GA-55'!N14+'GA-55'!N21)","v":213806},null,{"$f":"SUM('GA-55'!X12:X14)+'GA-55'!X21","v":0},null,null,{"$f":"H20","v":0}]
["Quarter 3",{"$nulls":4},{"$f":"SUM('GA-55'!N15+'GA-55'!N16+'GA-55'!N17+'GA-55'!N24)","v":222215},null,{"$f":"SUM('GA-55'!X15:X17)+'GA-55'!X24","v":0},null,null,{"$f":"H21","v":0}]
["Quarter 4",{"$nulls":4},{"$f":"SUM('GA-55'!N18+'GA-55'!N19+'GA-55'!N20+'GA-55'!N21+'GA-55'!N23+'GA-55'!N25+'GA-55'!N226+'GA-55'!N27+'GA-55'!N28+'GA-55'!N29)","v":255741},null,{"$f":"SUM('GA-55'!X18:X29)","v":0},null,null,{"$f":"H22","v":0}]
["Total",{"$nulls":4},{"$f":"SUM(F19:F22)","v":895816},null,{"$f":"SUM(H19:H22)","v":0},null,null,{"$f":"SUM(K19:K22)","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(B29:B41)","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(B49:D60)","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":"'Tax Old Regime'!Q61","v":46815},"(in words)"]
[{"$f":"PROPER(SpellNumber(I65))","v":"Forty-Six Thousand Eight Hundred Fifteen"},{"$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'!Q5","v":897421}]
[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":"I86+I87+I88+I89+I90","v":897421}]
[]
["2. Less : Allowance to the extent exempt under section 10"]
["a)HRA",{"$nulls":7},{"$f":"'Tax Old Regime'!Q6","v":51228}]
["b)Other"]
["3. Balance (1-2)",{"$nulls":8},{"$f":"J91-I94-I95","v":846193}]
[]
["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((J96>50000)),(J96-I102),0)","v":796193}]
[]
["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":"L104+L106-L107","v":796193}]
[{"$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'!O30","v":46121},null,{"$f":"G114","v":46121},null,{"$f":"I114","v":46121}]
[null,"(ii)","STATE INSURANCE",null,null,"Rs.",{"$f":"'Tax Old Regime'!I22","v":48000},null,48000,null,48000]
[null,"(iii)","LIC",null,null,"Rs.",null,null,0,null,0]
[null,"(iv)","Group Ins.",null,null,"Rs.",{"$f":"'Tax Old Regime'!I28","v":0},null,0,null,0]
[null,"(vi)","House Loan Installment",null,null,"Rs.",{"$f":"'Tax Old Regime'!I30","v":0},null,0,null,0]
[null,"(vii)","Others",null,null,"Rs.",{"$f":"'Tax Old Regime'!I24+'Tax Old Regime'!I25+'Tax Old Regime'!I26+'Tax Old Regime'!I29+'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+'Tax Old Regime'!O31","v":121121},null,121121,null,121121]
["(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(G114:G121)","v":215242},null,{"$f":"SUM(I114:I121)","v":215242},null,{"$f":"IF(SUM(K114:L119)>150000,150000,SUM(K114:L119))","v":150000}]
["i.e.80C, 80CCC and 80CCD"]
[]
["(d)","Section 80CCD2",{"$nulls":3},"Rs.",0,null,{"$f":"G125","v":0},null,{"$f":"I125","v":0}]
["(e)","Section 80CCD (1B)",{"$nulls":3},"Rs.",{"$f":"'[1]Tax Old Regime'!Q33","v":0},null,{"$f":"G126","v":0},null,{"$f":"I126","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":"G130","v":0},null,{"$f":"I130","v":0}]
[null,"(ii)",{"$nulls":3},"Rs.",null,null,{"$f":"G131","v":0},null,{"$f":"I131","v":0}]
[null,"(iii)",{"$nulls":3},"Rs.",null,null,{"$f":"G132","v":0},null,{"$f":"I132","v":0}]
["10. Aggregate of deductible amount under chapter VI-A",{"$nulls":9},{"$f":"K122+K125+K126+K130+K131+K132","v":150000},0]
[]
["11. Total Income (8-10 )",{"$nulls":9},{"$f":"'Tax Old Regime'!Q48","v":675070}]
[]
["12. Tax on Total Income ",{"$nulls":9},{"$f":"'Tax Old Regime'!Q55","v":45014}]
["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":"K137-K138","v":45014}]
["15.Education & Health Cess 4%",{"$nulls":9},{"$f":"'Tax Old Regime'!Q58","v":1801}]
["16. Tax payable (14+15)",{"$nulls":9},{"$f":"'Tax Old Regime'!Q59","v":46815}]
["17. Relife Under Section 89 (attach details)",{"$nulls":9},{"$f":"'Other Deduction'!E18","v":0}]
["18. Tax payable (16-17)",{"$nulls":9},{"$f":"'Tax Old Regime'!Q61","v":46815}]
["19.Tax Deducted at source U/S 192",{"$nulls":9},{"$f":"H23+B62","v":0}]
["20. Tax payable / refundable (17-18)",{"$nulls":9},{"$f":"K143-K144","v":46815}]
["Verification"]
["I,",{"$f":"B64","v":"RAJENDRA KUMAR CHITTORA"},null,null,"Son/Doughter of ",null,{"$f":"G64","v":"RAM LAL"},null,null,"  Working In the Capacity Of"]
[{"$f":"A65","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":"Hra Receipt","index":6,"n_rows":18,"n_cols":9,"rows_kept":18,"merged":[[0,0,0,9],[1,0,1,9],[2,0,3,9],[5,2,5,9],[6,2,6,4],[6,5,6,7],[7,2,7,9],[8,4,8,9],[9,1,9,3],[9,5,9,9],[10,1,10,2],[10,3,10,5],[12,2,12,3],[13,2,13,3],[14,6,14,9],[15,6,15,9],[16,6,16,9],[17,6,17,9],[18,0,18,9]]}
[]
["RECEIPT OF HOUSE RENT"]
["(Under section 1 (13-A) of Income Tax Act)"]
[]
[{"$nulls":7},"Date:-",{"$f":"TODAY()","v":"2022-12-26"}]
[null,"I Owner ",{"$f":"'Master Sheet'!M9","v":"RAM DAYAL NAGAR"}]
[null,null,"Received with Thanks from Sri/Smt. ",null,null,{"$f":"'Master Sheet'!E5","v":"PARMANAND MEGHWAL"},null,null,{"$f":"'Master Sheet'!E6","v":"SENIOR TEACHER"}]
[null,"Address-",{"$f":"'Master Sheet'!D2","v":"GOVT. SR. SECONDARY SCHOOL, GORDHANPURA, ATRU, BARAN"}]
[null,"The sum of ","Rs.=",{"$f":"'Other Deduction'!F18","v":{"v":135696.1,"d":"135696.10"}},{"$f":"PROPER(SpellNumber(D9))","v":"One Hundred Thirty-Five Thousand Six Hundred Ninety-Six"}]
[null,"Towards the House Rent @  Rs. =",null,null,{"$f":"ROUND(D9/12,0)","v":11308},{"$f":"PROPER(SpellNumber(E10))","v":"Eleven Thousand Three Hundred Eight"}]
[null,"Per Month From :-",null,"April 2022 To March 2023"]
[]
[null,"Rs.  =  ",{"$f":"D9","v":135696.1}]
[null,"Date:-",{"$f":"TODAY()","v":"2022-12-26"}]
[{"$nulls":6},"(Signature of House Owner)"]
[{"$nulls":6},"(Affix Revenue Stamp of Rs.1/-) \n"]
[{"$nulls":6},{"$f":"'Master Sheet'!M9","v":"RAM DAYAL NAGAR"}]
[{"$nulls":6},{"$f":"'Master Sheet'!M10","v":"KAWAI SALPURA, ATRU BARAN"}]