{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["For Help","Basic Deta","Exemp.(HRA+Other) & Other incom","GA-55","New Regime Calc. Report","Old Regime Calc. Report","OLD REGIME"],"not_rendered":{"images":1,"external_links":1,"defined_names":5,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"For Help","index":0,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[0,0,0,7],[1,1,1,2],[1,3,1,6],[2,5,12,5],[3,0,12,0],[3,3,4,3],[3,6,6,6],[3,7,12,7],[4,1,10,1],[8,6,9,6]]}
[]
[null,"FOR HELP CLICK HERE→\n(PLEASE SUBSCRIBE MY YOUTUBE CHANNEL)",null,"Click Here For Help Video"]
[]
[null," ",null,"आयकर गणना प्रपत्र देखें"]
[null,"1- सबसे पहले Basic Data शीट में सफ़ेद सेल्स में कार्मिक से जुड़े विद्यालय,स्वयं कार्मिक तथा वेतन सम्बंधित विवरण फिल करें.\n2- Basic Data भरने के पश्चात Exemp.(HRA+Other) & Other income वाली शीट में HRA अतिरिक्त आय, कटौतियां आदि भरें. (हालाँकि नियमानुसार HRA की गणना स्वतः की हुई मिलेगी फिर भी आपसे जुड़े DDO के निर्देशानुसार इसे बदल भी सकते है.)\n3- Basic Data एंट्री के साथ ही आपको GA-55 तैयार मिलेगा जो कि पूर्णत: अनलॉक है आप Pay Man./Pri Pay Man. से निकाले ऑनलाइन GA-55 रिपोर्ट से भली भांति मिलान कर आवश्यकतानुसार बदलाव भी कर सकते हैं.\n4- उक्त कार्य पूर्ण करने के बाद आपके सामने कार्मिक से जुडी पुरानी तथा नई कर व्यवस्था (Old Tax Regime/New Tax Regime)  के अनुसार आयकर गणना प्रपत्र, फॉर्म-16, HRA से जुडी आवश्यक रिसिप्ट तैयार है, प्रिंट ले सकते हैं.\n5- यदि गत वर्षों के बकाया वेतन का इस वर्ष आयकर की कटौती के साथ भुगतान किया गया है, तो आप आवश्यक फॉर्म-10E भी 10 E Us 89(1) शीट में तैयार कर धारा 89(1) के तहत प्राप्य छूट को आयकर गणना प्रपत्र, फॉर्म-16 में अंकित कर सकते हो.\n6- अंतिम 2 शीट्स HRA Calculator द्वारा कोई कार्मिक अपने HRA में राहत तथा आवश्यक रेसिप्ट की जानकारी प्राप्त कर सकता है एवं शीट Itax Calculate For All Employee द्वारा किसी DDO द्वारा अपने कार्यालय में पदस्थापित सम्पूर्ण कार्मिकों के एक साथ Itax की गणना कर आगामी अंतिम तीन माह दिसम्बर-23, जनवरी-24 तथा फरवरी-24 माह में काटे जाने वाले Itax की गणना कर समेकित ब्यौरा तैयार कर सकते है."]
[]
[{"$nulls":3},"GA55 देखें"]
[]
[{"$nulls":3},"Form-16 देखें",null,null,"Ummed Tarad"]
[]
[{"$nulls":3},"HRA  Receipt देखें",null,null,"(GSSS RAIMALWADA, BAPINI-PHALODI)"]
[null,"नोट :- हालाँकि इस प्रोग्राम को बनाते समय पूर्ण सावधानी के साथ तैयार किया गया है. मानवीय भूल सहज है. यदि किसी भी प्रकार की कोई समस्या, शंका तथा आपत्ति की स्थिति में आप अपने विवेक को प्रमुखता दें. ",null,"Updated On 10-12-2023",null,null,"Email Id-ummedtrdedu@gmail.com"]

{"sheet":"Basic Deta","index":1,"n_rows":19,"n_cols":17,"rows_kept":19,"merged":[[0,0,19,0],[0,1,0,16],[0,17,19,17],[1,1,1,16],[2,1,2,16],[3,1,3,16],[4,1,4,5],[4,6,4,11],[4,12,4,13],[4,14,4,15],[5,1,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,12,5,13],[5,14,5,15],[6,1,6,16],[7,1,7,16],[8,1,8,2],[8,3,8,4],[8,5,8,6],[8,8,8,10],[8,14,8,15],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,8,9,10],[9,14,9,15],[10,1,10,15],[11,1,13,1],[11,2,11,10],[11,11,11,16],[12,2,13,2],[12,7,12,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[12,13,13,13],[12,14,13,14],[12,15,13,15],[12,16,13,16],[15,1,15,16],[16,1,16,16],[17,13,17,16],[18,13,18,16],[19,1,19,16]]}
[null,"PREPARED BY :- UMMED TARAD (TEACHER, GSSS RAIMALWADA-BAPINI, JODHPUR)"]
[null,"Mobile Number-9166973141, Email ID-ummedtrdedu@gmail.com"]
[null,"Deta Entry For School and Employee"]
[null,"School's Detail"]
[null,"DDO Office Name :-",{"$nulls":4},"Govt. Sr. School Raimalwada",{"$nulls":5},"DDO Code :-",null,12345,null,"F.Y."]
[null,"District :-",{"$nulls":4},"Jodhpur",null,"TAN No. :-",null,"JDHG09250D",null,"DDO Name :-",{"$nulls":3},"2023-24"]
[]
[null,"Employee Personal & Salary Details"]
[null,"Employee Name",null,"Employee Service Type",null,"Employee ID",null,"Designation","Posting Place Name",null,null,"Pay Matrix Level","Basic Pay (March-223)","PAN No.","Account Number",null,"Employee Age\n(Less 60=A, Between 60&80=B, Above 80=C)"]
[{"$nulls":3},"Subordinate",{"$nulls":4},{"$f":"G5","v":"Govt. Sr. School Raimalwada"},null,null,{"v":12,"d":"L-12"},{"v":38000,"d":"₹ 38,000"},{"$nulls":3},"A"]
[]
[null,"Employee Status (Regular/ Probation)","Extra Paid Status",{"$nulls":8},"Deducted Amount"]
[null,null,"Bonus Amount","DA Paid ","DA Paid ","DA Arear","DA Arear","Surrender",null,"Washing All.","Handi. All.","GPF/GPF-2004 ","SI","SI Loan","LIC","RGHS","GIS"]
[{"$nulls":3},"From Jan-23","From Jul-23","Jan-23 to Mar-23","Jul-23 to Oct-23","Claimed (Yes/No)","Month"]
[null,"Regular",{"$f":"IF(OR(B15=\"Probation\",D10=\"state Service\",L10>=13),0,6774)","v":{"v":6774,"d":"₹ 6,774"}},{"v":0.42,"d":"42%"},{"v":0.46,"d":"46%"},"YES","YES","YES","2023-10-01","NO","NO",{"v":2850,"d":"₹ 2,850"},{"v":5000,"d":"₹ 5,000"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":850,"d":"₹ 850"},{"v":1400,"d":"₹ 1,400"}]
[]
[null,"Deducted Income Tax "]
[null,"2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","2024-02-01","Extra TDS Deposited (Via Challan etc)"]
[null,{"v":0,"d":"₹ 0"},{"$f":"B19","v":{"v":0,"d":"₹ 0"}},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"v":0,"d":"₹ 0"},{"$f":"SUM('Exemp.(HRA+Other) & Other incom'!Q7:Q10)","v":{"v":0,"d":"₹ 0"}}]

{"sheet":"Exemp.(HRA+Other) & Other incom","index":2,"n_rows":26,"n_cols":16384,"rows_kept":26,"merged":[[0,0,0,16],[0,17,26,17],[1,0,1,16],[2,0,2,1],[3,0,3,1],[4,0,4,12],[4,13,4,16],[5,1,5,10],[5,11,5,12],[6,1,6,10],[6,11,6,12],[7,1,7,10],[7,11,7,12],[8,2,8,10],[8,11,8,12],[9,2,9,10],[9,11,9,12],[10,0,10,16],[11,1,11,10],[11,11,11,12],[11,14,11,15],[12,1,12,10],[12,11,12,12],[12,14,12,15],[13,1,13,10],[13,11,13,12],[13,14,13,15],[14,1,14,10],[14,11,14,12],[14,14,14,15],[15,1,15,10],[15,11,15,12],[15,14,15,15],[16,1,16,10],[16,11,16,12],[16,14,16,15],[17,1,17,10],[17,11,17,12],[17,14,17,15],[18,1,18,10],[18,11,18,12],[18,14,18,15],[19,1,19,10],[19,11,19,12],[19,14,19,15],[20,1,20,10],[20,11,20,12],[20,14,20,15],[21,1,21,10],[21,11,21,12],[21,14,21,15],[22,1,22,10],[22,11,22,12],[22,14,22,15],[23,1,23,10],[23,11,23,12],[23,14,23,15],[24,1,24,10],[24,11,24,12],[24,14,24,15],[25,1,25,10],[25,11,25,12],[25,14,25,15],[26,0,26,16]]}
[{"$f":"'GA-55'!B1","v":"Office: Govt. Sr. School Raimalwada (DDO Code :-12345)"}]
["HRA CALCULATION"]
["Employee Name",null,"Post","Posted Place","Basic","DA","Total",{"v":0.1,"d":"10%"},"PAID HRA",null,"HRA Rebate (Rs.)","Yearly HRA Recipt (Rs.)","Per Month HRA Reciept","Quartly Amount For HRA Reciept","House Owner Name","House Owner Adress","House Owner PAN Number"]
[{"$f":"'Basic Deta'!B10","v":0},null,{"$f":"'Basic Deta'!H10","v":0},{"$f":"'Basic Deta'!I10","v":"Govt. Sr. School Raimalwada"},{"$f":"SUM('GA-55'!F9:F20,'GA-55'!F28,'GA-55'!F29)","v":464800},{"$f":"SUM('GA-55'!G23,'GA-55'!G22,'GA-55'!G9:G20,'GA-55'!G28:G29)","v":210768},{"$f":"E4+F4","v":675568},{"$f":"ROUNDUP((G4*0.1),0)","v":67557},{"$f":"SUM('GA-55'!H9:H20,'GA-55'!H28:H29)","v":41832},{"$f":"ROUNDUP((I4+H4),-1)","v":109390},{"$f":"IF(T4>I4,I4,T4)","v":41832},{"$f":"ROUNDUP((M4*12),-1)","v":109440},{"$f":"IF(H4>100000,0,ROUNDUP(J4/12,-1))","v":9120},{"$f":"ROUNDUP((M4*3),-1)","v":27360},{"$nulls":5},{"$f":"IF(AND(M4=0,H4>100000),0,IF(AND(M4>0,L4>H4),(L4-H4),0))","v":41883}]
["Extra income",{"$nulls":12},"Deposit income tax other than salary"]
["Sr. No.","Area of Income",{"$nulls":9},"Amount",null,"Date","Challan Number","BSR Code","Amount"]
[1,"गृह सम्पति से प्राप्त किराया-आय",{"$nulls":9},0,{"$nulls":4},0]
[2,"अन्य आय (बैंक/एफडी में जमा ब्याज/अन्य ब्याज आदि का योग",{"$nulls":9},0,{"$nulls":4},0,{"$nulls":16366},{"$f":"IF(L8>50000,\"B\",\"A\")","v":"A"}]
[3,"अन्य आय","(-----------------------------------------------------)",{"$nulls":8},0,{"$nulls":4},0,{"$nulls":16366},{"$f":"'Basic Deta'!Q10","v":"A"}]
[4,"अन्य आय","(-----------------------------------------------------)",{"$nulls":8},0,{"$nulls":4},0,{"$nulls":16366},{"$f":"CONCATENATE(XFD8,XFD9)","v":"AA"}]
["Extra exemptions"]
["Sr. No.","Area of Exemption",{"$nulls":9},"Amout",null,"Sr. No.","Area of Exemption",null,"Amount"]
[1,"मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत अधिकतम 5000 रूपये",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,15,"बचत खाते की जमा राशी पर प्राप्त ब्याज में छूट (80 TTA-10000 अधिकतम/80 TTB-अधिकतम 50000)",null,{"v":0,"d":"₹ 0.00"}]
[2,"व्यवसाय कर धारा 16 (ii) के अंतर्गत अधिकतम 5000 रूपये",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,16,"अन्य जमा राशी (80 C धारा के अंतर्गत)",null,{"v":0,"d":"₹ 0.00"}]
[3,"गृहकर",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,17,"धारा 80CCC - पेंशन प्लान हेतु अंशदान (NPS के अतिरिक्त)",null,{"v":0,"d":"₹ 0.00"}]
[4,"गृह ऋण किश्त मूल (जो वेतन से नहीं काटा गया)",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,18,"धारा 80CCD(1B) -नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम 50,000 अधिकतम)",null,{"v":0,"d":"₹ 0.00"}]
[5,"गृह ऋण किश्त ब्याज (जो वेतन से नहीं काटा गया)",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,19,"धारा 80D - चिकित्सा बीमा प्रीमियम (सामान्य 25,000, वरिष्ठ नागरिक 50,000)",null,{"v":0,"d":"₹ 0.00"}]
[6,"जीवन बिमा प्रीमियम (जो वेतन से नहीं काटा गया) LIC",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,20,"धारा 80DD - विकलांग आश्रितों का चिकित्सा उपचार (अधिकतम 75,000,  80%विक्लांगता 1,25,000)",null,{"v":0,"d":"₹ 0.00"}]
[7,"पी.एल.आई. PLI",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,21,"धारा 80DDB -विशिष्ठ रोगों के उपचार हेतु कटौती (सामान्य 40,000 एवं वरिष्ठ नागरिक 1 लाख)",null,{"v":0,"d":"₹ 0.00"}]
[8,"ट्यूशन फी",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,22,"धारा 80E - उच्च शिक्षा हेतु लिए ऋण पर ब्याज (धारा 80E)",null,{"v":0,"d":"₹ 0.00"}]
[9,"UPLI/वार्षिक प्लान",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,23,"धारा 80G -धर्मार्थ संस्थाओं को दिए दान (श्रेणी 'क' 100% एवं श्रेणी 'ख' 50%) ",null,{"v":0,"d":"₹ 0.00"}]
[10,"राष्ट्रीय बचत पत्र (NSC)",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,24,"धारा 80U -स्थाई शारीरिक विक्लांगता  (अधिकतम 75,000,  80%विक्लांगता 1,25,000)",null,{"v":0,"d":"₹ 0.00"}]
[11,"राष्ट्रीय बचत पत्र पर अदत ब्याज",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,25,"धारा 80 GGA -अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास आदि हेतु दिया गया दान",null,{"v":0,"d":"₹ 0.00"}]
[12,"लोक भविष्य निधि (PPF)",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,26,"इक्विटी लिंक सेविंग स्कीम",null,{"v":0,"d":"₹ 0.00"}]
[13,"राष्ट्रीय बचत स्कीम (NSS)",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,27,"स्थिगित वार्षिकी",null,{"v":0,"d":"₹ 0.00"}]
[14,"सुकन्या समृद्धि योजना",{"$nulls":9},{"v":0,"d":"₹ 0.00"},null,28,"धारा 89 के अंतर्गत राहत",null,{"v":0,"d":"₹ 0.00"}]

{"sheet":"GA-55","index":3,"n_rows":32,"n_cols":37,"rows_kept":32,"merged":[[0,1,0,28],[0,29,31,29],[1,2,1,19],[1,20,1,26],[1,27,1,28],[2,1,2,4],[2,5,2,8],[2,9,2,14],[2,15,2,17],[2,19,2,25],[2,26,2,28],[3,1,3,28],[4,1,4,4],[4,5,4,8],[4,9,4,14],[4,15,4,17],[4,19,4,25],[4,26,4,28],[5,1,5,28],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,6,14],[6,15,6,27],[6,28,7,28],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,4],[31,1,31,14],[31,15,31,28]]}
[null,{"$f":"CONCATENATE(\"Office:\",\" \",'Basic Deta'!G5,\" \",\"(\",'Basic Deta'!M5,'Basic Deta'!O5,\")\")","v":"Office: Govt. Sr. School Raimalwada (DDO Code :-12345)"}]
[null,null,"                                                                                               Employee GA-55 (For Itax Calculation)",{"$nulls":17},"Financial Year :-",{"$nulls":6},{"$f":"'Basic Deta'!Q6","v":"2023-24"}]
[null,"Employee Name :-",{"$nulls":3},{"$f":"'Basic Deta'!B10","v":0},{"$nulls":3},"Designation :-",{"$nulls":5},{"$f":"'Basic Deta'!H10","v":0},{"$nulls":3},"Employee ID :-",{"$nulls":6},{"$f":"'Basic Deta'!F10","v":0}]
[]
[null,"PAN No. :-",{"$nulls":3},{"$f":"'Basic Deta'!N10","v":0},{"$nulls":3},"Pay Matrix Level :-",{"$nulls":5},{"$f":"'Basic Deta'!L10","v":{"v":12,"d":"L-12"}},{"$nulls":3},"Account Number :-",{"$nulls":6},{"$f":"'Basic Deta'!O10","v":0}]
[]
[null,"Sr. No.","Month","TV Number","TV Date","Allowance",{"$nulls":9},"Deductions",{"$nulls":12},"Net Payment"]
[{"$nulls":5},"Basic","DA","HRA","DP","Washing All.","Handi. All.","ROP           (If any)","Other-1","Other-2","Groce Amount","GPF/ GPF-2004","SI","SIL","RGHS","LIC","GIS","HBA","CmCorona Relief","Hitkari Nidhi","Other-1","Other-2","Income Tax","Total Deductions"]
[null,1,"2023-03-01",null,null,{"$f":"'Basic Deta'!M10","v":38000},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F9*0.38,0)","v":14440},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F9*0.09,0)","v":3420},null,{"$f":"IF('Basic Deta'!J15=\"Yes\",180,0)","v":0},{"$f":"IF('Basic Deta'!K15=\"Yes\",600,0)","v":0},{"$nulls":3},{"$f":"SUM(F9:N9)","v":55860},{"$f":"'Basic Deta'!L15","v":2850},{"$f":"'Basic Deta'!M15","v":5000},{"$f":"'Basic Deta'!N15","v":0},{"$f":"'Basic Deta'!P15","v":850},{"$f":"'Basic Deta'!O15","v":0},{"$nulls":6},{"$f":"'Basic Deta'!$B19","v":0},{"$f":"SUM(P9:AA9)","v":8700},{"$f":"O9-AB9","v":47160},null,null,{"$f":"IF(C9='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AF9=\"Yes\",ROUND(F9/2,0),0)","v":0},{"$f":"IF(AF9=\"Yes\",ROUND(G9/2,0),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(AF9=\"Yes\",(F9+G9)/2,0)","v":0},{"$f":"IF(AF9=\"yes\",(AI9+(F9*0.03/2)),0)","v":0},{"$f":"IF($AF9=\"Yes\",ROUND(AH9*0.03,0),0)","v":{"v":0,"d":"0.00"}}]
[null,2,"2023-04-01",null,null,{"$f":"F9","v":38000},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F10*'Basic Deta'!$D$15,0)","v":15960},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F10*0.09,0)","v":3420},{"$f":"I9","v":0},{"$f":"J9","v":0},{"$f":"K9","v":0},null,{"$f":"M9","v":0},{"$f":"N9","v":0},{"$f":"SUM(F10:N10)","v":57380},{"$f":"P9","v":2850},{"$f":"Q9","v":5000},{"$f":"R9","v":0},{"$f":"S9","v":850},{"$f":"T9","v":0},{"$f":"'Basic Deta'!Q15","v":1400},{"$nulls":4},{"$f":"Z9","v":0},{"$f":"'Basic Deta'!$C19","v":0},{"$f":"SUM(P10:AA10)","v":10100},{"$f":"O10-AB10","v":47280},null,null,{"$f":"IF(C10='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AF10=\"Yes\",ROUND(F10/2,0),0)","v":0},{"$f":"IF(AF10=\"Yes\",ROUND(G10/2,0),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(AF10=\"Yes\",(F10+G10)/2,0)","v":0}]
[null,3,"2023-05-01",null,null,{"$f":"F10","v":38000},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F11*'Basic Deta'!$D$15,0)","v":15960},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F11*0.09,0)","v":3420},{"$f":"I10","v":0},{"$f":"J10","v":0},{"$f":"K10","v":0},null,{"$f":"M10","v":0},{"$f":"N10","v":0},57380,2850,5000,0,850,0,{"$f":"U9","v":0},{"$nulls":4},0,{"$f":"'Basic Deta'!D19","v":0},8700,48680,null,null,{"$f":"IF(C11='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,4,"2023-06-01",null,null,38000,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F12*'Basic Deta'!$D$15,0)","v":15960},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F12*0.09,0)","v":3420},0,0,0,null,0,0,57380,2850,5000,0,850,0,{"$f":"U11","v":0},{"$nulls":4},0,{"$f":"'Basic Deta'!E19","v":0},8700,48680,null,null,{"$f":"IF(C12='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,5,"2023-07-01",null,null,{"$f":"IF('Basic Deta'!B15=\"Regular\",ROUND(F12*103%,-2),'GA-55'!F12)","v":39100},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F13*'Basic Deta'!$D$15,0)","v":16422},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F13*0.09,0)","v":3519},0,0,0,null,0,0,59041,2850,5000,0,850,0,0,{"$nulls":4},0,{"$f":"'Basic Deta'!F19","v":0},8700,50341,null,null,{"$f":"IF(C13='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0,{"$f":"IF(AF13=\"yes\",(F13*0.04/2),0)","v":0},{"$f":"IF($AF13=\"Yes\",ROUND(AH13*0.04,0),0)","v":{"v":0,"d":"0.00"}}]
[null,6,"2023-08-01",null,null,{"$f":"F13","v":39100},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F14*'Basic Deta'!$D$15,0)","v":16422},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F14*0.09,0)","v":3519},0,0,0,null,0,0,59041,2850,5000,0,850,0,0,{"$nulls":4},0,{"$f":"'Basic Deta'!G19","v":0},8700,50341,null,null,{"$f":"IF(C14='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AF14=\"Yes\",ROUND(F14/2,0),0)","v":0},{"v":0,"d":"0.00"},0,{"$f":"IF(AF14=\"yes\",(F14*0.04/2),0)","v":0},{"$f":"IF($AF14=\"Yes\",ROUND(AH14*0.04,0),0)","v":{"v":0,"d":"0.00"}}]
[null,7,"2023-09-01",null,null,{"$f":"F14","v":39100},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F15*'Basic Deta'!$D$15,0)","v":16422},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F15*0.09,0)","v":3519},0,0,0,null,0,0,59041,2850,5000,0,850,0,0,{"$nulls":4},0,{"$f":"'Basic Deta'!H19","v":0},8700,50341,null,null,{"$f":"IF(C15='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0,0,{"$f":"IF($AF15=\"Yes\",ROUND(AH15*0.04,0),0)","v":{"v":0,"d":"0.00"}}]
[null,8,"2023-10-01",null,null,39100,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F16*'Basic Deta'!$D$15,0)","v":16422},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F16*0.09,0)","v":3519},0,0,0,null,0,0,59041,2850,5000,0,850,0,0,{"$nulls":4},0,{"$f":"'Basic Deta'!I19","v":0},8700,50341,null,null,{"$f":"IF(C16='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"Yes"},19550,{"v":8211,"d":"8211.00"},27761,{"$f":"IF(AF16=\"yes\",(F16*0.04/2),0)","v":782},{"$f":"IF($AF16=\"Yes\",ROUND(AH16*0.04,0),0)","v":{"v":328,"d":"328.00"}}]
[null,9,"2023-11-01",null,null,39100,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F17*'Basic Deta'!$E$15,0)","v":17986},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F17*0.09,0)","v":3519},0,0,0,null,0,0,60605,2850,5000,0,850,0,0,{"$nulls":4},0,{"$f":"'Basic Deta'!J19","v":0},8700,51905,null,null,{"$f":"IF(C17='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,10,"2023-12-01",null,null,39100,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F18*'Basic Deta'!$E$15,0)","v":17986},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F18*0.09,0)","v":3519},0,0,0,null,0,0,60605,2850,5000,0,850,0,0,null,null,{"$f":"IF('Basic Deta'!D10=\"State Service\",500,250)","v":250},null,0,{"$f":"'Basic Deta'!K19","v":0},8950,51655,null,null,{"$f":"IF(C18='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,11,"2024-01-01",null,null,39100,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F19*'Basic Deta'!$E$15,0)","v":17986},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F19*0.09,0)","v":3519},0,0,0,null,0,0,60605,2850,5000,0,850,0,0,{"$nulls":4},0,{"$f":"'Basic Deta'!L19","v":0},8700,51905,null,null,{"$f":"IF(C19='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,12,"2024-02-01",null,null,39100,{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F20*'Basic Deta'!$E$15,0)","v":17986},{"$f":"IF('Basic Deta'!$B$15=\"Regular\",'GA-55'!F20*0.09,0)","v":3519},0,0,0,null,0,0,60605,2850,5000,0,850,{"$f":"T19","v":0},0,{"$nulls":4},0,{"$f":"'Basic Deta'!M19","v":0},8700,51905,null,null,{"$f":"IF(C20='Basic Deta'!$I$15,\"Yes\",\"No\")","v":"No"},0,{"v":0,"d":"0.00"},0]
[null,"Bonus",{"$nulls":3},{"$f":"IF('Basic Deta'!L10>=13,0,'Basic Deta'!C15)","v":6774},{"$nulls":8},6774,{"$f":"ROUND(O21*25/100,0)","v":1694},{"$nulls":11},1694,5080,{"$nulls":3},{"$f":"SUM(AG9:AG20)","v":19550},{"$f":"SUM(AH9:AH20)","v":8211},27761,782,{"$f":"SUM(AK9:AK20)","v":{"v":328,"d":"328.00"}}]
[null,"DA (Jan-23 to Mar-23)",{"$nulls":4},{"$f":"IF('Basic Deta'!F15=\"yes\",ROUND('Basic Deta'!M10*0.04*3,0),0)","v":4560},{"$nulls":7},4560,{"$f":"O22","v":4560},{"$nulls":11},4560,0]
[null,"DA (Jul-23 to  Oct-23)",{"$nulls":4},{"$f":"IF(AND('Basic Deta'!E15>'Basic Deta'!D15,'Basic Deta'!G15=\"yes\"),ROUND(F13*0.04*4,0),0)","v":6256},{"$nulls":7},6256,{"$f":"O23","v":6256},{"$nulls":11},6256,0]
[null,"Surrender",{"$nulls":3},{"$f":"IF('Basic Deta'!H15=\"Yes\",AG21,0)","v":19550},{"$f":"IF('Basic Deta'!H15=\"Yes\",AH21,0)","v":8211},{"$nulls":7},27761,{"$nulls":12},0,27761]
[null,"Surrender Arrear",{"$nulls":4},{"$f":"IF('Basic Deta'!H15=\"Yes\",AJ21,0)","v":782},{"$nulls":7},782,{"$f":"G25","v":782},{"$nulls":11},782,0]
[null,"Other-2",{"$nulls":12},0,{"$nulls":12},0,0]
[null,"Surr. Arear",{"$nulls":4},{"$f":"IF('Basic Deta'!I15=\"Yes\",AJ21,0)","v":0},{"$nulls":7},0,{"$f":"O27","v":0},{"$nulls":11},0,0]
[null,"Sal. Arrear-1",{"$nulls":12},0,{"$nulls":12},0,0]
[null,"Sal. Arrear-2",{"$nulls":12},0,{"$nulls":12},0,0]
[null,"Sal. Arrear-3",{"$nulls":12},0,{"$nulls":12},0,0]
[null,"Total",{"$nulls":3},{"$f":"SUM(F9:F30)","v":491124},{"$f":"SUM(G9:G30)","v":219761},{"$f":"SUM(H9:H30)","v":41832},{"$f":"SUM(I9:I30)","v":0},{"$f":"SUM(J9:J30)","v":0},{"$f":"SUM(K9:K30)","v":0},{"$f":"SUM(L9:L30)","v":0},{"$f":"SUM(M9:M30)","v":0},{"$f":"SUM(N9:N30)","v":0},{"$f":"SUM(O9:O30)","v":752717},{"$f":"SUM(P9:P30)","v":47492},{"$f":"SUM(Q9:Q30)","v":60000},{"$f":"SUM(R9:R30)","v":0},{"$f":"SUM(S9:S30)","v":10200},{"$f":"SUM(T9:T30)","v":0},{"$f":"SUM(U9:U30)","v":1400},{"$f":"SUM(V9:V30)","v":0},{"$f":"SUM(W9:W30)","v":0},{"$f":"SUM(X9:X30)","v":250},{"$f":"SUM(Y9:Y30)","v":0},{"$f":"SUM(Z9:Z30)","v":0},{"$f":"SUM(AA9:AA30)","v":0},{"$f":"SUM(AB9:AB30)","v":119342},{"$f":"SUM(AC9:AC30)","v":633375}]
[null,{"$f":"CONCATENATE(\"Siganture of Employee\", \"(\",'Basic Deta'!B10,\")\")","v":"Siganture of Employee()"},{"$nulls":13},{"$f":"CONCATENATE(\"Signature of DDO\",\" \",\"(\",'Basic Deta'!O6,\")\")","v":"Signature of DDO ()"}]

{"sheet":"New Regime Calc. Report","index":4,"n_rows":73,"n_cols":38,"rows_kept":73,"merged":[[0,0,73,0],[0,1,0,16],[0,17,73,17],[0,19,0,20],[0,21,74,21],[1,1,1,9],[1,10,1,12],[1,13,1,16],[1,19,6,20],[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,1,8,1],[6,2,6,11],[6,12,6,14],[6,15,7,16],[7,2,7,11],[7,12,7,14],[7,18,9,18],[7,19,9,19],[7,20,9,20],[7,23,9,25],[8,2,8,11],[8,12,8,14],[9,2,9,14],[10,1,12,1],[10,2,10,9],[10,10,10,11],[10,12,10,14],[10,15,12,16],[11,2,12,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[11,12,11,14],[11,18,13,18],[11,19,13,19],[11,20,13,20],[11,23,13,25],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,2,13,14],[14,2,14,14],[14,19,14,20],[15,1,17,1],[15,2,17,2],[15,4,15,14],[15,19,74,20],[16,4,16,14],[17,4,17,14],[18,2,18,14],[19,2,19,14],[20,1,34,1],[20,2,20,16],[21,2,21,16],[22,3,22,6],[22,10,22,12],[22,15,31,16],[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,3,30,6],[30,10,30,12],[31,2,31,12],[32,2,32,14],[33,2,33,14],[34,2,34,14],[35,1,44,1],[35,2,35,16],[36,2,37,14],[36,15,37,15],[36,16,37,16],[38,2,39,14],[38,15,39,15],[38,16,39,16],[40,2,41,14],[40,15,41,15],[40,16,41,16],[42,2,43,14],[42,15,43,15],[42,16,43,16],[44,2,44,14],[45,2,45,14],[46,2,46,14],[47,2,47,14],[48,1,65,1],[48,2,48,16],[49,2,49,7],[49,8,49,9],[49,10,49,11],[49,12,49,14],[50,2,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,14],[51,2,51,7],[51,8,51,9],[51,10,51,11],[51,12,51,14],[52,2,52,7],[52,8,52,9],[52,10,52,11],[52,12,52,14],[53,2,53,7],[53,8,53,9],[53,10,53,11],[53,12,53,14],[54,2,54,7],[54,8,54,9],[54,10,54,11],[54,12,54,14],[55,2,55,7],[55,8,55,9],[55,10,55,11],[55,12,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,2,63,14],[64,2,64,14],[65,2,65,14],[66,2,66,14],[67,1,68,1],[67,2,67,14],[68,2,68,14],[69,1,71,1],[69,2,71,2],[69,3,69,4],[69,5,69,7],[69,12,69,13],[69,15,69,16],[70,3,70,4],[70,5,70,7],[70,12,70,13],[71,3,71,10],[71,11,71,14],[72,1,73,9],[72,10,73,16]]}
[null,{"$f":"'Exemp.(HRA+Other) & Other incom'!A1","v":"Office: Govt. Sr. School Raimalwada (DDO Code :-12345)"}]
[null,{"$f":"CONCATENATE(\"Income Tax Calculation F.Y.\",\":-\", 'Basic Deta'!Q6)","v":"Income Tax Calculation F.Y.:-2023-24"},{"$nulls":8},"(A.Y. 2024-25)",null,null,"New Tax Regime",{"$nulls":5},"Comparison of Itax calculation in Old and New Tax Regime"]
[null,1,"कर्मचारी का नाम :-",null,{"$f":"'GA-55'!F3","v":0},{"$nulls":5},"पद :-",{"$f":"'GA-55'!P3","v":0},null,null,"PAN :",{"$f":"'GA-55'!F5","v":0}]
[null,2,"आय:वर्ष 2022-23 में कुल प्राप्त वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"Rs.",{"$f":"'GA-55'!O31","v":{"v":752717,"d":"752717.00"}}]
[null,3,"गृह किराया धारा 10 (13-A) के अंतर्गत एवं 10(14) के अंतर्गत वेतन भत्ते जो कर मुक्त है l",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!K4,0)","v":{"v":0,"d":"0.00"}}]
[null,4,"                                                             शेष (2-3)",{"$nulls":12},"Rs.",{"$f":"Q4-Q5","v":{"v":752717,"d":"752717.00"}}]
[null,5,"(i)  मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L13","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)  व्यवसाय कर धारा 16 (iii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L14","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF(U8>U12,\"n\",\"y\")","v":"n"},"Tax Calculate by Old Tax Regime",{"$f":"'Old Regime Calc. Report'!Q66","v":{"v":23810,"d":"23810.00"}}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction)-अधिकतम 50,000",{"$nulls":9},{"v":50000,"d":"50000.00"},null,null,"Rs.",{"$f":"M7+M8+M9","v":{"v":50000,"d":"50000.00"}}]
[null,6,"                                                             शेष (4-5)",{"$nulls":12},"Rs.",{"$f":"Q6-Q9","v":{"v":702717,"d":"702717.00"}}]
[null,7,"(अ) गृह सम्पति से आय (1) स्वयं के उपयोग में शून्य ",{"$nulls":7},"(2) प्राप्त किराया ",null,{"$f":"'Exemp.(HRA+Other) & Other incom'!L7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ब) घटाइए",null,"किराये का 30%",null,null,"गृह ऋण पर ब्याज",null,null,"गृहकर",null,"योग 7 (ब)",{"$nulls":5},{"$f":"IF(U12>U8,\"n\",\"y\")","v":"y"},"Tax Calculate by New Tax Regime",{"$f":"Q69","v":{"v":2830,"d":"2830.00"}}]
[{"$nulls":4},{"$f":"ROUND(M11*0.3,0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L17,0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L15,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"E13+H13+K13","v":{"v":0,"d":"0.00"}}]
[null,null,"                                                     शेष -/+  {7(अ) एवं योग 7(ब)} ",{"$nulls":12},"Rs.",{"$f":"M11-M13","v":{"v":0,"d":"0.00"}}]
[null,8,"                                                             कुल शेष -/+ (6 एवं 7)",{"$nulls":12},"Rs.",{"$f":"Q10+Q14","v":{"v":702717,"d":"702717.00"}}]
[null,9,"अन्य आय","9(i)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B8","v":"अन्य आय (बैंक/एफडी में जमा ब्याज/अन्य ब्याज आदि का योग"},{"$nulls":10},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!L8","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"9(ii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C9","v":"(-----------------------------------------------------)"},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!L9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"9(iii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C10","v":"(-----------------------------------------------------)"},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!L10","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल (बिंदु संख्या -9)",{"$nulls":13},{"$f":"Q16+Q17+Q18","v":{"v":0,"d":"0.00"}}]
[null,10,"सकल आय                                                                                                                                       योग (8+9)",{"$nulls":12},"Rs.",{"$f":"Q15+Q19","v":{"v":702717,"d":"702717.00"}}]
[null,11,"घटाइए कटौतियां :- धारा  US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1.50 लाख (धारा 80 CCE) के अलावा "]
[null,null,"(i)","राज्य बीमा (SI)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!Q31,0)","v":{"v":0,"d":"0.00"}},"(x)","पेंशन प्लान हेतु अंशदान (धारा 80CCC)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q15,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)","जीवन बीमा प्रीमियम (LIC)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!T31+'Exemp.(HRA+Other) & Other incom'!L18,0)","v":{"v":0,"d":"0.00"}},"(xi)","राष्ट्रीय बचत पत्र पर अदत ब्याज",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L23,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L22,0)","v":{"v":0,"d":"0.00"}},"(xii)","ट्यूशन फी",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L20,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L24,0)","v":{"v":0,"d":"0.00"}},"(xiii)","इक्विटी लिंक सेविंग स्कीम",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q24,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम  (NSS)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L25,0)","v":{"v":0,"d":"0.00"}},"(xv)","स्थिगित वार्षिकी (Defferred Annuty)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q25,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vi)","GPF/GPF 2004",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!P31,0)","v":{"v":0,"d":"0.00"}},"(xiv)","पी.एल.आई. (PLI)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vii)","सामूहिक दुर्घटना बीमा (GIS)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!U31,0)","v":{"v":0,"d":"0.00"}},"(xvi)","अन्य जमा राशी (80 C धारा के अंतर्गत)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q14,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(viii)","UPLI/वार्षिक प्लान",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L21,0)","v":{"v":0,"d":"0.00"}},"(xvii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L26,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ix)","गृह ऋण किश्त(HBA Premium)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L16,0)","v":{"v":0,"d":"0.00"}},"(xviii)",{"$nulls":3},"Rs."]
[null,null,"योग (i से xvii तक)",{"$nulls":10},"Rs.",{"$f":"SUM(O23:O31,I23:I31)","v":{"v":0,"d":"0.00"}}]
[null,null,"                      अधिकतम कटौती की राशि  1.50 लाख रूपये तक",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"new tax regime\",0,IF(O32>=150000,150000,O32))","v":{"v":0,"d":"0.00"}}]
[null,null,"(B) घटाइए - धारा 80CCD (1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रु.50,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q16,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"योग 11(A+B+C)      ",{"$nulls":12},"Rs.",{"$f":"Q33+Q34","v":{"v":0,"d":"0.00"}}]
[null,12,"अन्य कटौतियां"]
[null,null,"1. An employer's contribution to the NPS up to 10% (14% of Govt. employees) of an employer's basic pay plus DA is allowed \n                                                                                                                                                                                                      as U/s 80 CCD(2)",{"$nulls":12},"Rs.",{"v":0,"d":"0.00"}]
[]
[null,null,"2. Any amount paid or deposited to the Agniveer Corpus Fund under the newly proposed \n                                                                                                                                                                                                      as U/s 80 CCH",{"$nulls":12},"Rs.",{"v":0,"d":"0.00"}]
[]
[{"$nulls":23},">300000",">600000",">900000",">1200000",">1500000"]
[{"$nulls":23},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,2,IF($Q$48>900000,3,IF($Q$48>600000,4,IF($Q$48>300000,5,0)))))","v":4},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,2,IF($Q$48>900000,3,IF($Q$48>600000,4,0))))","v":4},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,2,IF($Q$48>900000,3,0)))","v":0},{"$f":"IF($Q$48>1500000,1,IF($Q$48>1200000,2,0))","v":0},{"$f":"IF($Q$48>1500000,1,0)","v":0}]
[{"$nulls":22},"A",{"$f":"IF(X42>=5,ROUND(($Q$48-300000)*0.05,0),IF(X42=0,0,15000))","v":15000},{"$f":"IF(Y42>=4,ROUND(($Q$48-600000)*0.1,0),IF(Y42=0,0,30000))","v":10272},{"$f":"IF(Z42>=3,ROUND(($Q$48-900000)*0.15,0),IF(Z42=0,0,45000))","v":0},{"$f":"IF(AA42>=2,ROUND(($Q$48-1200000)*0.2,0),IF(AA42=0,0,60000))","v":0},{"$f":"IF(AB42>0,ROUND(($Q$48-1500000)*0.3,0),0)","v":0}]
[]
[null,null,"कुल योग 12 ",{"$nulls":12},"Rs.",{"$f":"SUM(Q37:Q44)","v":{"v":0,"d":"0.00"}}]
[null,13,"कुल कटौती (11 एवं 12)",{"$nulls":12},"Rs.",{"$f":"Q35+Q45","v":{"v":0,"d":"0.00"}}]
[null,14,"कर योग्य आय (10-13)",{"$nulls":12},"Rs.",{"$f":"Q20-Q46","v":{"v":702717,"d":"702717.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288A",{"$nulls":12},"Rs.",{"$f":"ROUND(Q47,-1)","v":{"v":702720,"d":"702720.00"}}]
[null,16,"उपरोक्त बिंदु 15 के आधार पर आयकर की गणना "]
[null,null,"Income Slab",{"$nulls":5},"सामान्य करदाता",null,"वरिष्ठ नागरिक (आयु 60 से 80 वर्ष)",null,"81 वर्ष या अधिक आयु "]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,000 तक\",\"3,00,000 तक\")","v":"3,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,001 से 3,00,000 तक\",\"3,00,001 से 6,00,000 तक\")","v":"3,00,001 से 6,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"5% (With Tax Rebate Under Sec.87A)"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"5% (With Tax Rebate Under Sec.87A)"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"5% (With Tax Rebate Under Sec.87A)"},null,null,"Rs.",{"$f":"X55","v":{"v":15000,"d":"15000.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"3,00,001 से 5,00,000 तक\",\"6,00,001 से 9,00,000 तक\")","v":"6,00,001 से 9,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)"},null,{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)"},null,null,"Rs.",{"$f":"ROUND(Y55,0)","v":{"v":10272,"d":"10272.00"}},{"$nulls":6},">300000",">600000",">900000",">1200000",">1500000",">5000000",">10000000","Surcharge",{"$nulls":3},{"$f":"IF(Q48>10000000,3,IF(Q48>5000000,2,IF(Q48>700000,1,0)))","v":1},{"$f":"IF(AI53=1,Q48-700000,0)","v":2720},{"$f":"IF(AI53=2,Q48-5000000,0)","v":0},{"$f":"IF(AI53=3,Q48-10000000,0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"5,00,001 से 10,00,000 तक\",\"9,00,001 से 12,00,000 तक\")","v":"9,00,001 से 12,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"15%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"15%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"15%"},null,null,"Rs.",{"$f":"Z55","v":{"v":0,"d":"0.00"}},{"$nulls":6},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,IF(Q$48>1500000,3,IF($Q$48>1200000,4,IF($Q$48>900000,5,IF($Q$48>600000,6,IF($Q$48>300000,7,0)))))))","v":6},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,IF(Q$48>1500000,3,IF($Q$48>1200000,4,IF($Q$48>900000,5,IF($Q$48>600000,6,0))))))","v":6},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,IF(Q$48>1500000,3,IF($Q$48>1200000,4,IF($Q$48>900000,5,0)))))","v":0},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,IF(Q$48>1500000,3,IF($Q$48>1200000,4,0))))","v":0},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,IF(Q$48>1500000,3,0)))","v":0},{"$f":"IF($Q$48>10000000,1,IF($Q$48>5000000,2,0))","v":0},{"$f":"IF($Q$48>10000000,1,0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"10,00,001 अथवा इससे ऊपर\",\"12,00,001 से 15,00,000 तक\")","v":"12,00,001 से 15,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"20%"},null,null,"Rs.",{"$f":"AA55","v":{"v":0,"d":"0.00"}},{"$nulls":5},"A",{"$f":"IF(X54>=7,($Q$48-300000)*0.05,IF(X54=0,0,15000))","v":15000},{"$f":"IF(Y54>=6,($Q$48-600000)*0.1,IF(Y54=0,0,30000))","v":10272},{"$f":"IF(Z54>=5,($Q$48-900000)*0.15,IF(Z54=0,0,45000))","v":0},{"$f":"IF(AA54>=4,ROUND(($Q$48-1200000)*0.2,0),IF(AA54=0,0,60000))","v":0},{"$f":"IF(OR(AC54>=1,AD54>=1,AB54=0),0,ROUND((Q48-1500000)*0.3,0))","v":0},{"$f":"IF(OR(AD54>=1,AC54=0),0,ROUND((Q48-1500000)*0.3,0))","v":0},{"$f":"IF(AD54>=1,ROUND(($Q$48-1500000)*0.3,0),0)","v":0},{"$f":"IF(Q48>20000000,Y61*0.25,IF(Q48>10000000,Y61*0.15,IF(Q48>5000000,Y61*0.1,0)))","v":0},null,null,{"$f":"SUM(X55:AE55)","v":25272},null,{"$f":"IF(AND(AI53=1,AJ53<=AH55),AJ53,IF(AND(AI53=2,AK53<=AH58),AK53+1200000,IF(AND(AI53=3,AL53<=AH59),AK53+2970000+AL55,0)))","v":2720},{"$f":"ROUND(AK53*0.3,0)","v":0},{"$f":"ROUND(AL53*0.3,0)","v":0}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"15,00,001 अथवा इससे ऊपर\")","v":"15,00,001 अथवा इससे ऊपर"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"30%"},null,null,"Rs.",{"$f":"SUM(AB55:AD55)","v":{"v":0,"d":"0.00"}},{"$nulls":16},{"$f":"IF(AH55<25000,0,25000)","v":25000}]
[null,null,{"$f":"IF(Q48<=5000000,\"\",\"Marginal Relief से पूर्व अधिभार (Surcharge)\")","v":""},{"$nulls":12},{"$f":"IF(Q48<=5000000,\"\",\"Rs.\")","v":""},{"$f":"IF(Q48<=5000000,\"\",ROUND(AE55,0))","v":""}]
[null,null,"(1) योग आयकर",{"$nulls":12},"Rs.",{"$f":"SUM(Q51:Q57)","v":{"v":25272,"d":"25272.00"}},{"$nulls":16},{"$f":"IF(AH55<1200000,0,AH55-1200000)","v":0},null,{"$f":"IF(AND(AJ55>0,AI53=1),AJ55,IF(AND(AJ55>0,AI53=2),AJ55,IF(AND(AJ55>0,AI53=3),AJ55,AH55)))","v":2720}]
[null,null,"(2) छूट धारा 87 (A) (नई स्लैब में 7 लाख की कर योग्य आय पर 25000/- तक राहत)",{"$nulls":12},"Rs.",{"$f":"IF(Q48<=700000,Q58,0)","v":{"v":0,"d":"0.00"}},{"$nulls":16},{"$f":"IF(AH55<2970000,0,AH55-2970000)","v":0}]
[null,null,"(3) छूट धारा 115 BAC  (Marginal Relief) (नई स्लैब में कर योग्य आय कर से न्यून होने की स्थिति में)",{"$nulls":12},"Rs.",{"$f":"IF(AND(AI53=1,AJ55>0),ROUND(Q58-AJ53,0),IF(AND(AI53=2,AJ55>0),ROUND(AH58-AK53+Q63,0),IF(AND(AI53=3,AJ55>0),ROUND(AH59-AL53+Q63,0),0)))","v":{"v":22552,"d":"22552.00"}}]
[null,null,"(2) छूट धारा 87 (A) (नई स्लैब में 7 लाख की कर योग्य आय पर 25000/- तक राहत) \n        Or 115 BAC  (Marginal Relief) (नई स्लैब में कर योग्य आय कर से न्यून होने की स्थिति में)",{"$nulls":12},"Rs.",{"$f":"SUM(Q59:Q60)","v":{"v":22552,"d":"22552.00"}},{"$nulls":7},{"$f":"SUM(X55:AD55)","v":25272}]
[null,null,"(3) शेष आयकर (1-2) {87 (A)  के तहत राहत अथवा Marginal Relief  के पश्चात}",{"$nulls":12},"Rs.",{"$f":"ROUND(Q58-Q61,0)","v":{"v":2720,"d":"2720.00"}},{"$nulls":7},{"$f":"ROUND(Q47,-1)","v":{"v":702720,"d":"702720.00"}}]
[null,null,"(4) अधिभार (Surcharge)  {50 लाख 1 रु.से 1 करोड़ तक आय के कर पर 10%,1 करोड़ 1 रु.से 2 करोड़ तक आय के कर पर 15% तथा 2 करोड़ से ऊपरी आय के कर पर 25% }",{"$nulls":12},"Rs.",{"$f":"AE55","v":{"v":0,"d":"0.00"}}]
[null,null,"(5) अधिभार (Surcharge) को मिलाकर आयकर (3+4)",{"$nulls":12},"Rs.",{"$f":"SUM(Q62:Q63)","v":{"v":2720,"d":"2720.00"}}]
[null,null,"(6) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q64*0.04,0)","v":{"v":109,"d":"109.00"}}]
[null,null,"कुल आयकर (5+6)",{"$nulls":12},"Rs.",{"$f":"SUM(Q64:Q65)","v":{"v":2829,"d":"2829.00"}}]
[null,17,"घटाइए :- धारा 89 के अंतर्गत राहत Rule 21A(2)",{"$nulls":12},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!Q26","v":{"v":0,"d":"0.00"}}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"Rs.",{"$f":"Q66-Q67","v":{"v":2829,"d":"2829.00"}}]
[null,null,"कुल शेष आयकर की राशि (दस के गुणक में)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q68,-1)","v":{"v":2830,"d":"2830.00"}}]
[null,19,"आयकर कटौती का विवरण","Itax deducted Till Jun-2022 (First Quarter)",null,"Itax deducted  July-22 to Sep.-22      (Second Quarter)",null,null,"Itax deducted Oct-22 to Dec.-22 (Third Quarter)","Itax Deducted/Dedctable by Dec.22 Salary","Itax Deducted/Dedctable by Jan-23 Salary","Itax Deducted/Dedctable by Feb-23 Salary","Itax Deducted addition to Salary ",null,"Itax submitted by other means","बिंदु 19 का योग "]
[{"$nulls":3},{"$f":"SUM('GA-55'!AA9:AA11)","v":0},null,{"$f":"SUM('GA-55'!AA12:AA14)","v":0},null,null,{"$f":"SUM('GA-55'!AA15:AA17)","v":0},{"$f":"'GA-55'!AA18","v":0},{"$f":"'GA-55'!AA19","v":0},{"$f":"'GA-55'!AA20","v":0},{"$f":"SUM('GA-55'!AA21:AA30)","v":0},null,{"$f":"'Basic Deta'!N19","v":0},"Rs.",{"$f":"SUM(D71:O71)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Income Tax Refundable/Payble\nHere Refundable figure Show Positive & Green Color and Payble figure Show Negative & Red Colour ",{"$nulls":7},{"$f":"IF(Q71>Q69,\"(Refundable)\",\"(Payble)\")","v":"(Payble)"},{"$nulls":3},"Rs.",{"$f":"Q71-Q69","v":{"v":-2830,"d":"-2830.00"}}]
[null,{"$f":"'GA-55'!B32","v":"Siganture of Employee()"},{"$nulls":8},{"$f":"'GA-55'!P32","v":"Signature of DDO ()"}]

{"sheet":"Old Regime Calc. Report","index":5,"n_rows":70,"n_cols":39,"rows_kept":70,"merged":[[0,0,70,0],[0,1,0,16],[0,17,70,17],[0,19,0,25],[1,1,1,9],[1,10,1,12],[1,13,1,16],[1,19,6,25],[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,1,8,1],[6,2,6,11],[6,12,6,14],[6,15,7,16],[7,2,7,11],[7,12,7,14],[7,18,9,18],[7,19,9,22],[7,23,9,25],[8,2,8,11],[8,12,8,14],[9,2,9,14],[10,1,12,1],[10,2,10,9],[10,10,10,11],[10,12,10,14],[10,15,12,16],[10,19,10,25],[11,2,12,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[11,12,11,14],[11,18,13,18],[11,19,13,22],[11,23,13,25],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,2,13,14],[14,2,14,14],[14,19,14,25],[15,1,17,1],[15,2,17,2],[15,4,15,14],[15,19,71,25],[16,4,16,14],[17,4,17,14],[18,2,18,14],[19,2,19,14],[20,1,34,1],[20,2,20,16],[21,2,21,16],[22,3,22,6],[22,10,22,12],[22,15,31,16],[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,3,30,6],[30,10,30,12],[31,2,31,12],[32,2,32,14],[33,2,33,14],[34,2,34,14],[35,1,44,1],[35,2,35,16],[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,62,1],[48,2,48,16],[49,2,49,7],[49,8,49,9],[49,10,49,11],[49,12,49,14],[50,2,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,14],[51,2,51,7],[51,8,51,9],[51,10,51,11],[51,12,51,14],[52,2,52,7],[52,8,52,9],[52,10,52,11],[52,12,52,14],[53,2,53,7],[53,8,53,9],[53,10,53,11],[53,12,53,14],[54,2,54,7],[54,8,54,9],[54,10,54,11],[54,12,54,14],[55,2,55,7],[55,8,55,9],[55,10,55,11],[55,12,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,2,63,14],[64,1,65,1],[64,2,64,14],[65,2,65,14],[66,1,68,1],[66,2,68,2],[66,3,66,4],[66,5,66,7],[66,12,66,13],[66,15,66,16],[67,3,67,4],[67,5,67,7],[67,12,67,13],[68,3,68,10],[68,11,68,14],[69,1,70,9],[69,10,70,16]]}
[null,{"$f":"'Exemp.(HRA+Other) & Other incom'!A1","v":"Office: Govt. Sr. School Raimalwada (DDO Code :-12345)"}]
[null,{"$f":"CONCATENATE(\"Income Tax Calculation F.Y.\",\":-\", 'Basic Deta'!Q6)","v":"Income Tax Calculation F.Y.:-2023-24"},{"$nulls":8},{"$f":"CONCATENATE(\"(\",\"A.Y.\",\":-\",AC4,\")\")","v":"(A.Y.:-2024-25)"},null,null,"Old Tax Regime",{"$nulls":5},"Comparison of Itax calculation in Old and New Tax Regime",{"$nulls":8},{"$f":"YEAR('GA-55'!C9)","v":2023},{"$f":"AC2+1","v":2024}]
[null,1,"कर्मचारी का नाम :-",null,{"$f":"'GA-55'!F3","v":0},{"$nulls":5},"पद :-",{"$f":"'GA-55'!P3","v":0},null,null,"PAN :",{"$f":"'GA-55'!F5","v":0},{"$nulls":12},{"$f":"YEAR('GA-55'!C19)","v":2024},{"$f":"AC3+1-2000","v":25}]
[null,2,"आय:वर्ष 2022-23 में कुल प्राप्त वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"Rs.",{"$f":"'GA-55'!O31","v":{"v":752717,"d":"752717.00"}},{"$nulls":11},{"$f":"CONCATENATE(AD2,\"-\",AD3)","v":"2024-25"}]
[null,3,"गृह किराया धारा 10 (13-A) के अंतर्गत एवं 10(14) के अंतर्गत वेतन भत्ते जो कर मुक्त है l",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!K4,0)","v":{"v":41832,"d":"41832.00"}}]
[null,4,"                                                             शेष (2-3)",{"$nulls":12},"Rs.",{"$f":"Q4-Q5","v":{"v":710885,"d":"710885.00"}}]
[null,5,"(i)  मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L13","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)  व्यवसाय कर धारा 16 (iii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L14","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"X8-X12","v":{"v":20980,"d":"20980.00"}},"Tax Calculate by Old Tax Regime",{"$nulls":3},{"$f":"'OLD REGIME'!Q64","v":{"v":23810,"d":"₹ 23,810.00"}}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction)-अधिकतम 50,000",{"$nulls":9},{"v":50000,"d":"50000.00"},null,null,"Rs.",{"$f":"M7+M8+M9","v":{"v":50000,"d":"50000.00"}}]
[null,6,"                                                             शेष (4-5)",{"$nulls":12},"Rs.",{"$f":"Q6-Q9","v":{"v":660885,"d":"660885.00"}}]
[null,7,"(अ) गृह सम्पति से आय (1) स्वयं के उपयोग में शून्य ",{"$nulls":7},"(2) प्राप्त किराया ",null,{"$f":"'Exemp.(HRA+Other) & Other incom'!L7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ब) घटाइए",null,"किराये का 30%",null,null,"गृह ऋण पर ब्याज",null,null,"गृहकर",null,"योग 7 (ब)",{"$nulls":5},{"$f":"X12-X8","v":{"v":-20980,"d":"-20980.00"}},"Tax Calculate by New Tax Regime",{"$nulls":3},{"$f":"'New Regime Calc. Report'!Q69","v":{"v":2830,"d":"₹ 2,830.00"}}]
[{"$nulls":4},{"$f":"IF(N2=\"old tax regime\",ROUND(M11*0.3,0),0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L17,0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L15,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"E13+H13+K13","v":{"v":0,"d":"0.00"}}]
[null,null,"                                                     शेष -/+  {7(अ) एवं योग 7(ब)} ",{"$nulls":12},"Rs.",{"$f":"M11-M13","v":{"v":0,"d":"0.00"}}]
[null,8,"                                                             कुल शेष -/+ (6 एवं 7)",{"$nulls":12},"Rs.",{"$f":"Q10+Q14","v":{"v":660885,"d":"660885.00"}}]
[null,9,"अन्य आय","9(i)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B8","v":"अन्य आय (बैंक/एफडी में जमा ब्याज/अन्य ब्याज आदि का योग"},{"$nulls":10},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!L8","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"9(ii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C9","v":"(-----------------------------------------------------)"},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!L9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"9(iii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C10","v":"(-----------------------------------------------------)"},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!L10","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल (बिंदु संख्या -9)",{"$nulls":13},{"$f":"Q16+Q17+Q18","v":{"v":0,"d":"0.00"}}]
[null,10,"सकल आय                                                                                                                                       योग (8+9)",{"$nulls":12},"Rs.",{"$f":"Q15+Q19","v":{"v":660885,"d":"660885.00"}}]
[null,11,"घटाइए कटौतियां :- धारा  US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1.50 लाख (धारा 80 CCE) के अलावा "]
[null,null,"(i)","राज्य बीमा (SI)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!Q31,0)","v":{"v":60000,"d":"60000.00"}},"(x)","पेंशन प्लान हेतु अंशदान (धारा 80CCC)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q15,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)","जीवन बीमा प्रीमियम (LIC)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!T31+'Exemp.(HRA+Other) & Other incom'!L18,0)","v":{"v":0,"d":"0.00"}},"(xi)","राष्ट्रीय बचत पत्र पर अदत ब्याज",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L23,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L22,0)","v":{"v":0,"d":"0.00"}},"(xii)","ट्यूशन फी",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L20,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L24,0)","v":{"v":0,"d":"0.00"}},"(xiii)","इक्विटी लिंक सेविंग स्कीम",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q24,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम  (NSS)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L25,0)","v":{"v":0,"d":"0.00"}},"(xv)","स्थिगित वार्षिकी (Defferred Annuty)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q25,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vi)","GPF/GPF 2004",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!P31,0)","v":{"v":47492,"d":"47492.00"}},"(xiv)","पी.एल.आई. (PLI)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vii)","सामूहिक दुर्घटना बीमा (GIS)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!U31,0)","v":{"v":1400,"d":"1400.00"}},"(xvi)","अन्य जमा राशी (80 C धारा के अंतर्गत)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q14,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(viii)","UPLI/वार्षिक प्लान",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L21,0)","v":{"v":0,"d":"0.00"}},"(xvii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L26,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ix)","गृह ऋण किश्त(HBA Premium)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L16,0)","v":{"v":0,"d":"0.00"}},"(xviii)",{"$nulls":3},"Rs."]
[null,null,"योग (i से xvii तक)",{"$nulls":10},"Rs.",{"$f":"SUM(O23:O31,I23:I31)","v":{"v":108892,"d":"108892.00"}}]
[null,null,"                      अधिकतम कटौती की राशि  1.50 लाख रूपये तक",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"new tax regime\",0,IF(O32>=150000,150000,O32))","v":{"v":108892,"d":"108892.00"}}]
[null,null,"(B) घटाइए - धारा 80CCD (1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रु.50,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q16,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"योग 11(A+B+C)      ",{"$nulls":12},"Rs.",{"$f":"Q33+Q34","v":{"v":108892,"d":"108892.00"}}]
[null,12,"अन्य कटौतियां"]
[null,null,"1. धारा 80D - चिकित्सा बीमा प्रीमियम {स्वयं/पति/पत्नी  हेतु 25,000 माता/पिता हेतु 25,000, वरिष्ठ नागरिक 50,000}",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q17,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"2. धारा 80DD - विकलांग आश्रितों का चिकित्सा उपचार (अधिकतम 75,000,  80% या अधिक विक्लांगता 1,25,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q18,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"3. धारा 80DDB -विशिष्ठ रोगों के उपचार हेतु कटौती (सामान्य 40,000 एवं वरिष्ठ नागरिक 1 लाख)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"4. धारा 80E - उच्च शिक्षा हेतु लिए ऋण पर ब्याज (धारा 80E)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q20,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"5. धारा 80G -धर्मार्थ संस्थाओं को दिए दान (श्रेणी 'क' 100% एवं श्रेणी 'ख' 50%) ",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q21,0)","v":{"v":0,"d":"0.00"}},{"$nulls":16},">250000",">300000",">500000",">1000000",null,"Surcharge"]
[null,null,"6. धारा 80U -स्थाई शारीरिक विक्लांगता की दशा में (अधिकतम 75,000 तथा अधिनियम 1995 के अनुसार 80% विक्लांगता 1,25,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q22,0)","v":{"v":0,"d":"0.00"}},{"$nulls":16},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,IF($Q$48>300000,3,IF($Q$48>250000,4,0))))","v":2},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,IF($Q$48>300000,3,0)))","v":2},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,0))","v":2},{"$f":"IF($Q$48>1000000,1,0)","v":0}]
[null,null,"7. अधिनियम 1995 के अनुसार धारा 80 TTA के तहत बचत खाते की जमा राशी पर प्राप्त ब्याज में छूट 10000 (80 TTB-वरिष्ठ नागरिक अधिकतम 50,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q13,0)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"A",{"$f":"IF(AH42>=1,2500,0)","v":2500},{"$f":"IF(AI42=3,ROUND((Q48-300000)*0.05,0),IF(AI42=0,0,10000))","v":10000},{"$f":"IF($AJ$42=2,($Q$48-500000)*0.2,IF($AJ$42=1,100000,0))","v":10398},{"$f":"IF($AK$42>0,($Q$48-1000000)*0.3,0)","v":0},{"$f":"SUM(AH43:AK43)","v":22898},{"$f":"IF($Q$48>50000000,AL43*0.37,IF($Q$48>20000000,AL43*0.25,IF($Q$48>10000000,Y63*0.15,IF($Q$48>5000000,Y63*0.1,0))))","v":0}]
[null,null,"8. धारा 80 GGA -अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q23,0)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"B",{"v":0,"d":"0.00"},{"$f":"IF(AI42=3,ROUND((Q48-300000)*0.05,0),IF(AI42=0,0,10000))","v":10000},{"$f":"IF($AJ$42=2,($Q$48-500000)*0.2,IF($AJ$42=1,100000,0))","v":10398},{"$f":"IF($AK$42>0,($Q$48-1000000)*0.3,0)","v":0},{"$f":"SUM(AH44:AK44)","v":20398},{"$f":"IF($Q$48>50000000,AL44*0.37,IF($Q$48>20000000,AL44*0.25,IF($Q$48>10000000,Y64*0.15,IF($Q$48>5000000,Y64*0.1,0))))","v":0}]
[null,null,"कुल योग 12 (1 से 8)",{"$nulls":12},"Rs.",{"$f":"SUM(Q37:Q44)","v":{"v":0,"d":"0.00"}},{"$nulls":15},"C",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF($AJ$42=2,($Q$48-500000)*0.2,IF($AJ$42=1,100000,0))","v":10398},{"$f":"IF($AK$42>0,($Q$48-1000000)*0.3,0)","v":0},10398,{"$f":"IF($Q$48>50000000,AL45*0.37,IF($Q$48>20000000,AL45*0.25,IF($Q$48>10000000,Y65*0.15,IF($Q$48>5000000,Y65*0.1,0))))","v":0}]
[null,13,"कुल कटौती (11 एवं 12)",{"$nulls":12},"Rs.",{"$f":"Q35+Q45","v":{"v":108892,"d":"108892.00"}}]
[null,14,"कर योग्य आय (10-13)",{"$nulls":12},"Rs.",{"$f":"Q20-Q46","v":{"v":551993,"d":"551993.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288A",{"$nulls":12},"Rs.",{"$f":"ROUND(Q47,-1)","v":{"v":551990,"d":"551990.00"}},{"$nulls":13},{"$f":"IF(N2=\"Old tax regime\",\"O\",\"N\")","v":"O"},{"$f":"'Basic Deta'!Q10","v":"A"},{"$f":"CONCATENATE(AE48,AF48)","v":"OA"}]
[null,16,"उपरोक्त बिंदु 15 के आधार पर आयकर की गणना "]
[null,null,"Income Slab",{"$nulls":5},"सामान्य करदाता",null,"वरिष्ठ नागरिक (आयु 60 से 80 वर्ष)",null,"81 वर्ष या अधिक आयु "]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,000 तक\",\"3,00,000 तक\")","v":"2,50,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,001 से 3,00,000 तक\",\"3,00,001 से 6,00,000 तक\")","v":"2,50,001 से 3,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"Nil"},null,null,"Rs.",{"$f":"IF($AG$48=\"OA\",AH43,IF($AG$48=\"OB\",AH44,IF($AG$48=\"OC\",AH45,0)))","v":{"v":2500,"d":"2500.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"3,00,001 से 5,00,000 तक\",\"6,00,001 से 9,00,000 तक\")","v":"3,00,001 से 5,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"Nil"},null,null,"Rs.",{"$f":"IF($AG$48=\"OA\",AI43,IF($AG$48=\"OB\",AI44,IF($AG$48=\"OC\",AI45,0)))","v":{"v":10000,"d":"10000.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"5,00,001 से 10,00,000 तक\",\"9,00,001 से 12,00,000 तक\")","v":"5,00,001 से 10,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,null,"Rs.",{"$f":"IF($AG$48=\"OA\",AJ43,IF($AG$48=\"OB\",AJ44,IF($AG$48=\"OC\",AJ45,0)))","v":{"v":10398,"d":"10398.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"10,00,001 अथवा इससे ऊपर\",\"12,00,001 से 15,00,000 तक\")","v":"10,00,001 अथवा इससे ऊपर"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,null,"Rs.",{"$f":"IF($AG$48=\"OA\",AK43,IF($AG$48=\"OB\",AK44,IF($AG$48=\"OC\",AK45,0)))","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"15,00,001 अथवा इससे ऊपर\")","v":"----"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,null,"Rs.",{"$f":"IF($AE$48=\"O\",0,AL55)","v":{"v":0,"d":"0.00"}}]
[null,null,"(1) योग आयकर",{"$nulls":12},"Rs.",{"$f":"SUM(Q51:Q56)","v":{"v":22898,"d":"22898.00"}}]
[null,null,"(2) छूट धारा 87 (A) (पुरानी स्लैब में 5 लाख की कर योग्य आय पर छुट अधिकतम रु. 12500/- व नई स्लैब में 7 लाख की कर योग्य आय पर 25000/- तक राहत)",{"$nulls":12},"Rs.",{"$f":"IF(AND(AE48=\"o\",Q57<=12500),Q57,IF(AND(AE48=\"n\",Q57<=25000),Q57,0))","v":{"v":0,"d":"0.00"}}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":12},"Rs.",{"$f":"Q57-Q58","v":{"v":22898,"d":"22898.00"}}]
[null,null,"(4) अधिभार (Surcharge) \n                     {50 लाख 1 रु.से 1 करोड़ तक आय के कर पर 10%,1 करोड़ 1 रु.से 2 करोड़ तक आय के कर पर 15%,2करोड़ 1 रु.से 5 करोड़ तक आय के कर पर 25%,5 करोड़ से ऊपरी आय के कर पर 37% }",{"$nulls":12},"Rs.",{"$f":"IF($AG$48=\"OA\",AM43,IF($AG$48=\"OB\",AM44,IF($AG$48=\"OC\",AM45,0)))","v":{"v":0,"d":"0.00"}}]
[null,null,"(5) अधिभार (Surcharge) को मिलाकर आयकर (3+4)",{"$nulls":12},"Rs.",{"$f":"SUM(Q59:Q60)","v":{"v":22898,"d":"22898.00"}}]
[null,null,"(6) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q59*0.04,0)","v":{"v":916,"d":"916.00"}}]
[null,null,"कुल आयकर (5+6)",{"$nulls":12},"Rs.",{"$f":"Q61+Q62","v":{"v":23814,"d":"23814.00"}}]
[null,17,"घटाइए :- धारा 89 के अंतर्गत राहत Rule 21A(2)",{"$nulls":12},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!Q26","v":{"v":0,"d":"0.00"}}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"Rs.",{"$f":"Q63-Q64","v":{"v":23814,"d":"23814.00"}}]
[null,null,"कुल शेष आयकर की राशि (दस के गुणक में)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q65,-1)","v":{"v":23810,"d":"23810.00"}}]
[null,19,"आयकर कटौती का विवरण","Itax deducted Till Jun-23 (First Quarter)",null,"Itax deducted  July-23 to Sep-23\n (Second Quarter)",null,null,"Itax deducted Oct-23 to Dec-23\n(Third Quarter)","Itax Deducted/Dedctable by Dec-23 Salary","Itax Deducted/Dedctable by Jan-24 Salary","Itax Deducted/Dedctable by Feb-24 Salary","Itax Deducted addition to Salary ",null,"Itax submitted by other means","बिंदु 19 का योग "]
[{"$nulls":3},{"$f":"SUM('GA-55'!AA9:AA11)","v":0},null,{"$f":"SUM('GA-55'!AA12:AA14)","v":0},null,null,{"$f":"SUM('GA-55'!AA15:AA17)","v":0},{"$f":"'GA-55'!AA18","v":0},{"$f":"'GA-55'!AA19","v":0},{"$f":"'GA-55'!AA20","v":0},{"$f":"SUM('GA-55'!AA21:AA30)","v":0},null,{"$f":"'Basic Deta'!N19","v":0},"Rs.",{"$f":"SUM(D68:O68)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Income Tax Refundable/Payble\nHere Refundable figure Show Positive & Green Color and Payble figure Show Negative & Red Colour ",{"$nulls":7},{"$f":"IF(Q68>Q66,\"(Refundable)\",\"(Payble)\")","v":"(Payble)"},{"$nulls":3},"Rs.",{"$f":"Q68-Q66","v":{"v":-23810,"d":"-23810.00"}}]
[null,{"$f":"'GA-55'!B32","v":"Siganture of Employee()"},{"$nulls":8},{"$f":"'GA-55'!P32","v":"Signature of DDO ()"}]

{"sheet":"OLD REGIME","index":6,"n_rows":68,"n_cols":26,"rows_kept":68,"hidden":true,"merged":[[0,0,68,0],[0,1,0,16],[0,17,68,17],[1,1,1,12],[1,13,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,1,8,1],[6,2,6,11],[6,12,6,14],[6,15,7,16],[7,2,7,11],[7,12,7,14],[8,2,8,11],[8,12,8,14],[9,2,9,14],[10,1,12,1],[10,2,10,9],[10,10,10,11],[10,12,10,14],[10,15,12,16],[11,2,12,3],[11,4,11,6],[11,7,11,9],[11,10,11,11],[11,12,11,14],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[13,2,13,14],[14,2,14,14],[15,1,17,1],[15,2,17,2],[15,4,15,14],[16,4,16,14],[17,4,17,14],[18,2,18,14],[19,2,19,14],[20,1,34,1],[20,2,20,16],[21,2,21,16],[22,3,22,6],[22,10,22,12],[22,15,31,16],[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,3,30,6],[30,10,30,12],[31,2,31,12],[32,2,32,14],[33,2,33,14],[34,2,34,14],[35,1,44,1],[35,2,35,16],[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,60,1],[48,2,48,16],[49,2,49,7],[49,8,49,9],[49,10,49,11],[49,12,49,14],[50,2,50,7],[50,8,50,9],[50,10,50,11],[50,12,50,14],[51,2,51,7],[51,8,51,9],[51,10,51,11],[51,12,51,14],[52,2,52,7],[52,8,52,9],[52,10,52,11],[52,12,52,14],[53,2,53,7],[53,8,53,9],[53,10,53,11],[53,12,53,14],[54,2,54,7],[54,8,54,9],[54,10,54,11],[54,12,54,14],[55,2,55,7],[55,8,55,9],[55,10,55,11],[55,12,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,1,63,1],[62,2,62,14],[63,2,63,14],[64,1,66,1],[64,2,66,2],[64,3,64,4],[64,5,64,7],[64,12,64,13],[64,15,64,16],[65,3,65,4],[65,5,65,7],[65,12,65,13],[66,3,66,10],[66,11,66,14],[67,1,68,9],[67,10,68,16]]}
[null,{"$f":"'Exemp.(HRA+Other) & Other incom'!A1","v":"Office: Govt. Sr. School Raimalwada (DDO Code :-12345)"}]
[null,"Income Tax Calculation F.Y. 2022-22 (A.Y.2023-24)",{"$nulls":11},"Old Tax Regime"]
[null,1,"कर्मचारी का नाम :-",null,{"$f":"'GA-55'!F3","v":0},{"$nulls":5},"पद :-",{"$f":"'GA-55'!P3","v":0},null,null,"PAN :",{"$f":"'GA-55'!F5","v":0}]
[null,2,"आय:वर्ष 2022-23 में कुल प्राप्त वेतन (कर योग्य सुविधाओं के मूल्य सहित)",{"$nulls":12},"Rs.",{"$f":"'GA-55'!O31","v":{"v":752717,"d":"752717.00"}}]
[null,3,"गृह किराया धारा 10 (13-A) के अंतर्गत एवं 10(14) के अंतर्गत वेतन भत्ते जो कर मुक्त है l",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!K4,0)","v":{"v":41832,"d":"41832.00"}}]
[null,4,"                                                             शेष (2-3)",{"$nulls":12},"Rs.",{"$f":"Q4-Q5","v":{"v":710885,"d":"710885.00"}}]
[null,5,"(i)  मनोरंजन भत्ता धारा 16 (ii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L13","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)  व्यवसाय कर धारा 16 (iii) के अंतर्गत (अधिकतम 5000 रूपये)",{"$nulls":9},{"$f":"'Exemp.(HRA+Other) & Other incom'!L14","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii) स्टेंडर्ड डिडक्शन (Standard Deduction)-अधिकतम 50,000",{"$nulls":9},{"v":50000,"d":"50000.00"},null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",M7+M8+M9,0)","v":{"v":50000,"d":"50000.00"}}]
[null,6,"                                                             शेष (4-5)",{"$nulls":12},"Rs.",{"$f":"Q6-Q9","v":{"v":660885,"d":"660885.00"}}]
[null,7,"(अ) गृह सम्पति से आय (1) स्वयं के उपयोग में शून्य ",{"$nulls":7},"(2) प्राप्त किराया ",null,{"$f":"'Exemp.(HRA+Other) & Other incom'!L7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ब) घटाइए",null,"किराये का 30%",null,null,"गृह ऋण पर ब्याज",null,null,"गृहकर",null,"योग 7 (ब)"]
[{"$nulls":4},{"$f":"IF(N2=\"old tax regime\",ROUND(M11*0.3,0),0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L17,0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L15,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"E13+H13+K13","v":{"v":0,"d":"0.00"}}]
[null,null,"                                                     शेष -/+  {7(अ) एवं योग 7(ब)} ",{"$nulls":12},"Rs.",{"$f":"M11-M13","v":{"v":0,"d":"0.00"}}]
[null,8,"                                                             कुल शेष -/+ (6 एवं 7)",{"$nulls":12},"Rs.",{"$f":"Q10+Q14","v":{"v":660885,"d":"660885.00"}}]
[null,9,"अन्य आय","9(i)",{"$f":"'Exemp.(HRA+Other) & Other incom'!B8","v":"अन्य आय (बैंक/एफडी में जमा ब्याज/अन्य ब्याज आदि का योग"},{"$nulls":10},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!L8","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"9(ii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C9","v":"(-----------------------------------------------------)"},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!L9","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"9(iii)",{"$f":"'Exemp.(HRA+Other) & Other incom'!C10","v":"(-----------------------------------------------------)"},{"$nulls":11},{"$f":"'Exemp.(HRA+Other) & Other incom'!L10","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल (बिंदु संख्या -9)",{"$nulls":13},{"$f":"Q16+Q17+Q18","v":{"v":0,"d":"0.00"}}]
[null,10,"सकल आय                                                                                                                                       योग (8+9)",{"$nulls":12},"Rs.",{"$f":"Q15+Q19","v":{"v":660885,"d":"660885.00"}}]
[null,11,"घटाइए कटौतियां :- धारा  US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1.50 लाख (धारा 80 CCE) के अलावा "]
[null,null,"(i)","राज्य बीमा (SI)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!Q31,0)","v":{"v":60000,"d":"60000.00"}},"(x)","पेंशन प्लान हेतु अंशदान (धारा 80CCC)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q15,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ii)","जीवन बीमा प्रीमियम (LIC)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!T31+'Exemp.(HRA+Other) & Other incom'!L18,0)","v":{"v":0,"d":"0.00"}},"(xi)","राष्ट्रीय बचत पत्र पर अदत ब्याज",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L23,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L22,0)","v":{"v":0,"d":"0.00"}},"(xii)","ट्यूशन फी",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L20,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L24,0)","v":{"v":0,"d":"0.00"}},"(xiii)","इक्विटी लिंक सेविंग स्कीम",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q24,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम  (NSS)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L25,0)","v":{"v":0,"d":"0.00"}},"(xv)","स्थिगित वार्षिकी (Defferred Annuty)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q25,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vi)","GPF/GPF 2004",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!P31,0)","v":{"v":47492,"d":"47492.00"}},"(xiv)","पी.एल.आई. (PLI)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vii)","सामूहिक दुर्घटना बीमा (GIS)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'GA-55'!U31,0)","v":{"v":1400,"d":"1400.00"}},"(xvi)","अन्य जमा राशी (80 C धारा के अंतर्गत)",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q14,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(viii)","UPLI/वार्षिक प्लान",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L21,0)","v":{"v":0,"d":"0.00"}},"(xvii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L26,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(ix)","गृह ऋण किश्त(HBA Premium)",{"$nulls":3},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!L16,0)","v":{"v":0,"d":"0.00"}},"(xviii)",{"$nulls":3},"Rs."]
[null,null,"योग (i से xvii तक)",{"$nulls":10},"Rs.",{"$f":"SUM(O23:O31,I23:I31)","v":{"v":108892,"d":"108892.00"}}]
[null,null,"                      अधिकतम कटौती की राशि  1.50 लाख रूपये तक",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"new tax regime\",0,IF(O32>=150000,150000,O32))","v":{"v":108892,"d":"108892.00"}}]
[null,null,"(B) घटाइए - धारा 80CCD (1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रु.50,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q16,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"योग 11(A+B+C)      ",{"$nulls":12},"Rs.",{"$f":"Q33+Q34","v":{"v":108892,"d":"108892.00"}}]
[null,12,"अन्य कटौतियां"]
[null,null,"1. धारा 80D - चिकित्सा बीमा प्रीमियम {स्वयं/पति/पत्नी  हेतु 25,000 माता/पिता हेतु 25,000, वरिष्ठ नागरिक 50,000}",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q17,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"2. धारा 80DD - विकलांग आश्रितों का चिकित्सा उपचार (अधिकतम 75,000,  80% या अधिक विक्लांगता 1,25,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q18,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"3. धारा 80DDB -विशिष्ठ रोगों के उपचार हेतु कटौती (सामान्य 40,000 एवं वरिष्ठ नागरिक 1 लाख)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"4. धारा 80E - उच्च शिक्षा हेतु लिए ऋण पर ब्याज (धारा 80E)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q20,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"5. धारा 80G -धर्मार्थ संस्थाओं को दिए दान (श्रेणी 'क' 100% एवं श्रेणी 'ख' 50%) ",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q21,0)","v":{"v":0,"d":"0.00"}},{"$nulls":5},">250000",">300000",">500000",">1000000"]
[null,null,"6. धारा 80U -स्थाई शारीरिक विक्लांगता की दशा में (अधिकतम 75,000 तथा अधिनियम 1995 के अनुसार 80% विक्लांगता 1,25,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q22,0)","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,IF($Q$48>300000,3,IF($Q$48>250000,4,0))))","v":2},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,IF($Q$48>300000,3,0)))","v":2},{"$f":"IF($Q$48>1000000,1,IF($Q$48>500000,2,0))","v":2},{"$f":"IF($Q$48>1000000,1,0)","v":0}]
[null,null,"7. अधिनियम 1995 के अनुसार धारा 80 TTA के तहत बचत खाते की जमा राशी पर प्राप्त ब्याज में छूट 10000 (80 TTB-वरिष्ठ नागरिक अधिकतम 50,000)",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q13,0)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"A",{"$f":"IF(W42>=1,2500,0)","v":2500},{"$f":"IF(X42=3,ROUND((Q48-300000)*0.05,0),IF(X42=0,0,10000))","v":10000},{"$f":"IF(Y42=2,($Q$48-500000)*0.2,IF(Y42=1,100000,0))","v":10398},{"$f":"IF(Z42>0,($Q$48-1000000)*0.3,0)","v":0}]
[null,null,"8. धारा 80 GGA -अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":12},"Rs.",{"$f":"IF(N2=\"old tax regime\",'Exemp.(HRA+Other) & Other incom'!Q23,0)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"B",{"v":0,"d":"0.00"},{"$f":"IF(X42=3,ROUND((Q48-300000)*0.05,0),IF(X42=0,0,10000))","v":10000},{"$f":"IF(Y42=2,($Q$48-500000)*0.2,IF(Y42=1,100000,0))","v":10398},{"$f":"IF(Z42>0,($Q$48-1000000)*0.3,0)","v":0}]
[null,null,"कुल योग 12 (1 से 8)",{"$nulls":12},"Rs.",{"$f":"SUM(Q37:Q44)","v":{"v":0,"d":"0.00"}},{"$nulls":4},"C",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(Y42=2,($Q$48-500000)*0.2,IF(Y42=1,100000,0))","v":10398},{"$f":"IF(Z42>0,($Q$48-1000000)*0.3,0)","v":0}]
[null,13,"कुल कटौती (11 एवं 12)",{"$nulls":12},"Rs.",{"$f":"Q35+Q45","v":{"v":108892,"d":"108892.00"}}]
[null,14,"कर योग्य आय (10-13)",{"$nulls":12},"Rs.",{"$f":"Q20-Q46","v":{"v":551993,"d":"551993.00"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना (दस के गुणक में) धारा 288A",{"$nulls":12},"Rs.",{"$f":"ROUND(Q47,-1)","v":{"v":551990,"d":"551990.00"}},null,null,{"$f":"'Old Regime Calc. Report'!AF48","v":"A"},{"$f":"'Basic Deta'!F10","v":0},{"$f":"CONCATENATE(T48,U48)","v":"A0"}]
[null,16,"उपरोक्त बिंदु 15 के आधार पर आयकर की गणना "]
[null,null,"Income Slab",{"$nulls":5},"सामान्य करदाता",null,"वरिष्ठ नागरिक (आयु 60 से 80 वर्ष)",null,"81 वर्ष या अधिक आयु "]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,000 तक\",\"3,00,000 तक\")","v":"2,50,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"Nil\")","v":"Nil"},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"2,50,001 से 3,00,000 तक\",\"3,00,001 से 6,00,000 तक\")","v":"2,50,001 से 3,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"Nil"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"5% (With Tax Rebate Under Sec.87A)\")","v":"Nil"},null,null,"Rs.",{"$f":"IF(T48=\"a\",W43,IF(T48=\"B\",W44,W45))","v":{"v":2500,"d":"2500.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"3,00,001 से 5,00,000 तक\",\"6,00,001 से 9,00,000 तक\")","v":"3,00,001 से 5,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"5%\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"5%"},null,{"$f":"IF($N$2=\"old tax regime\",\"Nil\",\"10% (With Tax Rebate Under Sec.87A Up to Rs. 7 Lakh.)\")","v":"Nil"},null,null,"Rs.",{"$f":"IF(T48=\"a\",X43,IF(T48=\"B\",X44,X45))","v":{"v":10000,"d":"10000.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"5,00,001 से 10,00,000 तक\",\"9,00,001 से 12,00,000 तक\")","v":"5,00,001 से 10,00,000 तक"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,{"$f":"IF($N$2=\"old tax regime\",\"20%\",\"15%\")","v":"20%"},null,null,"Rs.",{"$f":"IF(T48=\"a\",Y43,IF(T48=\"B\",Y44,Y45))","v":{"v":10398,"d":"10398.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"10,00,001 अथवा इससे ऊपर\",\"12,00,001 से 15,00,000 तक\")","v":"10,00,001 अथवा इससे ऊपर"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,{"$f":"IF($N$2=\"old tax regime\",\"30%\",\"20%\")","v":"30%"},null,null,"Rs.",{"$f":"IF(T48=\"a\",Z43,IF(T48=\"B\",Z44,Z45))","v":{"v":0,"d":"0.00"}}]
[null,null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"15,00,001 अथवा इससे ऊपर\")","v":"----"},{"$nulls":5},{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,{"$f":"IF($N$2=\"old tax regime\",\"----\",\"30%\")","v":"----"},null,null,"Rs.",{"v":0,"d":"0.00"}]
[null,null,"(1) योग आयकर",{"$nulls":12},"Rs.",{"$f":"SUM(Q51:Q56)","v":{"v":22898,"d":"22898.00"}}]
[null,null,"(2) छूट धारा 87 (A) (2.50 लाख से 5.00 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रूपये 12,500 तक)",{"$nulls":12},"Rs.",{"$f":"IF(Q57<=12500,Q57,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(3) शेष आयकर (1-2)",{"$nulls":12},"Rs.",{"$f":"Q57-Q58","v":{"v":22898,"d":"22898.00"}}]
[null,null,"(4) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2% (योग 4%)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q59*0.04,0)","v":{"v":916,"d":"916.00"}}]
[null,null,"कुल आयकर (3+4)",{"$nulls":12},"Rs.",{"$f":"Q59+Q60","v":{"v":23814,"d":"23814.00"}}]
[null,17,"घटाइए :- धारा 89 के अंतर्गत राहत Rule 21A(2)",{"$nulls":12},"Rs.",{"$f":"'Exemp.(HRA+Other) & Other incom'!Q26","v":{"v":0,"d":"0.00"}}]
[null,18,"कुल शेष आयकर",{"$nulls":12},"Rs.",{"$f":"Q61-Q62","v":{"v":23814,"d":"23814.00"}}]
[null,null,"कुल शेष आयकर की राशि (दस के गुणक में)",{"$nulls":12},"Rs.",{"$f":"ROUND(Q63,-1)","v":{"v":23810,"d":"23810.00"}}]
[null,19,"आयकर कटौती का विवरण","Itax deducted Till Jun-2022 (First Quarter)",null,"Itax deducted  July-22 to Sep.-22      (Second Quarter)",null,null,"Itax deducted Oct-22 to Dec.-22 (Third Quarter)","Itax Deducted/Dedctable by Dec.22 Salary","Itax Deducted/Dedctable by Jan-23 Salary","Itax Deducted/Dedctable by Feb-23 Salary","Itax Deducted addition to Salary ",null,"Itax submitted by other means","बिंदु 19 का योग "]
[{"$nulls":3},{"$f":"SUM('GA-55'!AA9:AA11)","v":0},null,{"$f":"SUM('GA-55'!AA12:AA14)","v":0},null,null,{"$f":"SUM('GA-55'!AA15:AA17)","v":0},{"$f":"'GA-55'!AA18","v":0},{"$f":"'GA-55'!AA19","v":0},{"$f":"'GA-55'!AA20","v":0},{"$f":"SUM('GA-55'!AA21:AA30)","v":0},null,{"$f":"'Basic Deta'!N19","v":0},"Rs.",{"$f":"SUM(D66:O66)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},"Income Tax Refundable/Payble",{"$nulls":7},{"$f":"IF(Q66>Q64,\"(Refundable)\",\"(Payble)\")","v":"(Payble)"},{"$nulls":3},"Rs.",{"$f":"Q66-Q64","v":{"v":-23810,"d":"-23810.00"}}]
[null,{"$f":"'GA-55'!B32","v":"Siganture of Employee()"},{"$nulls":8},{"$f":"'GA-55'!P32","v":"Signature of DDO ()"}]