{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["दिशानिर्देश","MASTERDATA","GA55","EXTRA DEDUCATION","OLD TAX REGIME","NEW TAX REGIME","Sheet1"],"not_rendered":{"images":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"दिशानिर्देश","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"merged":[[0,1,0,16],[1,2,1,16],[2,2,2,16],[3,2,3,16],[4,2,4,16],[5,2,5,16],[6,2,6,16],[7,2,7,16],[8,2,8,16],[9,0,9,17],[10,0,10,17]]}
[null,"उपयोग के दिशानिर्देश"]
[null,1,"इस वर्कबुक को मोबाइल फ्रेंडली बनाया गया है |"]
[null,2,"MASTER DATA SHEET की सभी पूर्तियां करनी अनिवार्य है |"]
[null,3,"मोबाइल में उपयोग हेतु WPS OFFICE APPLICATION या MICROSOFT EXCLE APPLICATION काम में ले, अन्यथा वर्कबुक ठीक प्रकार से काम नही करेगी |"]
[null,4," मास्टर डाटा शीट में अपना वेतन व व्यक्तिगत जानकारी भरें व GA55 से विवरण का मिलान कर लेंवें विसंगति होने पर GA55 में मेन्यूल सुधार कर लेंवें |"]
[null,5,"EXTRA DEDUCATION शीट में वेतन के अतिरिक्त आय, विभिन्न कटौतियाँ, विभिन्न जमा राशि / छूट, वेतन के अलावा काटा गया आयकर आदि विवरण लिखा जाना है ।"]
[null,6,"OLD TAX REGIME व NEW TAX REGIME वाली शीट पूर्णतया लॉक है इसमें कुछ भी लिखने की अनुमति नही है जो भी सुधार करना हो GA55 व EXTRA DEDUCATION वाली शीटमें करे |"]
[null,7,"GA55 व TAX SHEETS को पेपर साइज़ A4 पर सेट किया हुआ है, OLD TAX REGIME OR NEW TAX REGIME में से जिसमे फायदा हो उसे चुने व उसका प्रिंट ले लेंवें |"]
[]
["यह प्रोग्राम राजस्थान के शिक्षकों के अनुरूप बनाया गया है \nसुनील कुमार महावर, अध्यापक राउमावि वीर धोलिया, मावली, (उदयपुर)\nकिसी भी प्रकार की समस्या / सुझाव के लिए ईमेल करें-sk969019@gmail.com या  WhatsApp :- 9664061084"]
["You Tube:- DIGITAL GURUJI HELP "]

{"sheet":"MASTERDATA","index":1,"n_rows":35,"n_cols":12,"rows_kept":35,"merged":[[0,1,0,6],[0,7,15,7],[1,1,1,6],[2,3,2,6],[14,1,14,6]]}
[null,"MASTER DATA ",{"$nulls":5},"हमारे यू - ट्यूब चैनल को सबस्क्राइब अवश्य करें व साथ ही नोटिफिकेशन बेल को भी दबाये ताकि     नवीनतम अपडेट्स आप तक पहुँच सकें                                                             DIGITALGURUJI HELP"]
[null,"कार्मिक की व्यक्तिगत जानकारी ",{"$nulls":6},"NA"]
[null,1,"कार्यालय का नाम:-","GOVT SR SEC SCHOOL VEER DHOLIYA ",{"$nulls":4},"2024-03-01"]
[null,2,"कार्यालय का TAN NO.:-","JDH70C",13,"DDO का नाम:-","MR. SANTOSH KUMAR VYAS",null,"2024-04-01"]
[null,3,"कार्मिक का नाम:-","SUNIL KUMAR MAHAWAR ",14,"कार्मिक का  पद:-","TEACHER ",null,"2024-05-01"]
[null,4,"कार्मिक का PAN NO.:-","GGGGGHGH ",15,"कार्मिक का A/C NO.:-",44444444444444,null,"2024-06-01"]
[null,5,"SI नंबर:-",null,16,"राज्य बीमा मासिक कटौती राशि:-",5000,null,"2024-07-01"]
[null,6,"GPF NO.:-","GPF066",17,"कार्मिक का मोबाईल नंबर:-",null,null,"2024-08-01"]
[null,7,"मार्च 2024 का मूल वेतन:-",40100,18,"  HOUSE RENT ALL. दर",{"v":0.1,"d":"10%"},null,"2024-09-01"]
[null,8,"पे लेवल :-","L10",19,"GPF की मासिक कटौती:-",2100,null,"2024-10-01"]
[null,9,"क्या आपने वित्तीय वर्ष 2024-25 मे समर्पित लिया है?","NO",20,"यदि हाँ, तो समर्पित बिल माह:-","2024-08-01",null,"2024-11-01",null,null,"L1"]
[null,10,"क्या आपको बोनस मिला है ?","NO",21,"क्या आपने RGHS कटौती का विकल्प लिया है ?","YES",null,"2024-12-01",null,"YES","L2"]
[null,11,"दुर्घटना बीमा प्रीमियम राशि:-",null,22,"क्या हितकारी निधि की कटौती करनी है ?","YES",null,"2025-01-01",null,"NO","L3"]
[null,12,"क्या आप वरिष्ट नागरिक (60-80) आयु वर्ग में आते है ?","NO",23,"शहरी क्षतिपूर्ती भत्ता (CCA) :-","NA",null,"2025-02-01","NA","NA","L4"]
[null," NOTE:-  इस वर्क बुक को तैयार करने मे पूर्ण सावधानी बरती गयी है, यदि फिर भी कोई विसंगति होती है तो, विभागीय आदेश ही मान्य होंगे, जिसका उत्तरदायित्व शीट तैयार करने वाले का नही होगा |",{"$nulls":7},{"v":0.1,"d":"10%"},"2022-03-22","L5"]
[null,null,"https://youtu.be/7a0Kds6wPcg  ",{"$nulls":6},{"v":0.2,"d":"20%"},"2022-04-22","L6"]
[{"$nulls":7},"JJJJJJ",null,"NA","2022-05-22","L7"]
[{"$nulls":9},320,"2022-06-22","L8"]
[{"$nulls":9},620,"2022-07-22","L9"]
[{"$nulls":9},1000,"2022-08-22","L10"]
[{"$nulls":10},"2022-09-22","L11"]
[{"$nulls":10},"2022-10-22","L12"]
[{"$nulls":10},"2022-11-22","L13"]
[{"$nulls":10},"2022-12-22","L14"]
[{"$nulls":10},"2022-01-23","L15"]
[{"$nulls":10},"2022-02-23","L16"]
[{"$nulls":11},"L17"]
[{"$nulls":11},"L18"]
[{"$nulls":11},"L19"]
[{"$nulls":11},"L20"]
[{"$nulls":11},"L21"]
[{"$nulls":11},"L22"]
[{"$nulls":11},"L23"]
[{"$nulls":11},"L24"]
[{"$nulls":11},"L25"]

{"sheet":"GA55","index":2,"n_rows":31,"n_cols":28,"rows_kept":31,"merged":[[1,2,1,27],[2,2,2,27],[4,3,4,9],[4,10,4,11],[4,12,4,14],[4,18,4,21],[4,24,4,25],[4,26,4,27],[5,3,5,9],[5,10,5,11],[5,12,5,13],[5,17,5,18],[5,19,5,22],[5,24,5,25],[5,26,5,27],[30,13,30,15]]}
[]
[null,null,{"$f":"MASTERDATA!D3","v":"GOVT SR SEC SCHOOL VEER DHOLIYA "}]
[null,null,"Salary and Deduction Detail for FY : 2024-25"]
[]
[null,null,"Name :",{"$f":"MASTERDATA!D5","v":"SUNIL KUMAR MAHAWAR "},{"$nulls":6},"PAN :",null,{"$f":"MASTERDATA!D6","v":"GGGGGHGH "},{"$nulls":4},"TAN:",{"$f":"MASTERDATA!D4","v":"JDH70C"},{"$nulls":5},"Bank A/c :",null,{"$f":"MASTERDATA!G6","v":44444444444444}]
[null,null,"     Post :",{"$f":"IF(MASTERDATA!G5=\"\",\"\",CONCATENATE(MASTERDATA!G5,\" \",\"(\",MASTERDATA!D10,\")\"))","v":"TEACHER  (L10)"},{"$nulls":6},"SI No :",null,{"$f":"MASTERDATA!D7","v":0},{"$nulls":4},{"$f":"MASTERDATA!C8","v":"GPF NO.:-"},null,{"$f":"IF(MASTERDATA!D8=\"\",\"\",MASTERDATA!D8)","v":"GPF066"},{"$nulls":4},"Mobile No. :",null,{"$f":"MASTERDATA!G8","v":0}]
[null,null,"Month","Basic Pay","Dearness Pay","Leave  Pay","Spl. Pay","D.A.","H.R.A.","Washing Allow.","ROP (If any, put the value in minus)",{"$f":"IF(MASTERDATA!G14=\"NA\",\"Other Allowance\",\"CCA\")","v":"Other Allowance"},"Other Allowance","Gross  Salary","GPF/GPF2004","GPF LOAN","SI","SI LOAN + INT","RGHS / RPMF","LIC","Group Insurance  \nAccidental","Income Tax / TDS","Hitkari Nidhi","Other Deduction","Other Deduction","Total\nDeduction","Net Payment","Bill No. - Date \n/ \nTV No. - Date"]
[null,3,"2024-03-01",{"$f":"MASTERDATA!D9","v":40100},0,0,0,{"$f":"ROUND(50%*D8,0)","v":20050},{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.09*D8,0),ROUND(0.18*D8,0)))","v":3609},null,null,{"$f":"IF(MASTERDATA!G14=\"NA\",\"\",MASTERDATA!G14)","v":""},null,{"$f":"SUM(D8:M8)","v":63759},{"$f":"MASTERDATA!G10","v":2100},0,{"$f":"MASTERDATA!G7","v":5000},null,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D9<18001,265,IF(D9<33501,440,IF(D9<54001,658,875))))","v":658},2576,0,null,null,"",null,{"$f":"SUM(O8:Y8)","v":{"v":10334,"d":"10,334"}},{"$f":"N8-Z8","v":{"v":53425,"d":"53,425"}}]
[null,4,"2024-04-01",{"$f":"D8","v":40100},0,0,0,{"$f":"ROUND(50%*D9,0)","v":20050},{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.09*D9,0),ROUND(0.18*D9,0)))","v":3609},0,0,{"$f":"IF(L$8=L78,0,L8)","v":0},{"$f":"M8","v":0},63759,{"$f":"O8","v":2100},0,{"$f":"Q8","v":5000},{"$f":"R8","v":0},{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D10<18001,265,IF(D10<33501,440,IF(D10<54001,658,875))))","v":658},{"$f":"T8","v":2576},700,{"$f":"V8","v":0},null,"",0,{"$f":"SUM(O9:Y9)","v":{"v":11034,"d":"11,034"}},{"v":52725,"d":"52,725"}]
[null,5,"2024-05-01",{"$f":"D9","v":40100},0,0,0,20050,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.09*D10,0),ROUND(0.18*D10,0)))","v":3609},0,0,{"$f":"IF(L$8=0,0,L9)","v":0},{"$f":"M9","v":0},63759,{"$f":"O11","v":2100},0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D10<18001,265,IF(D10<33501,440,IF(D10<54001,658,875))))","v":658},2576,0,{"$f":"V9","v":0},null,"",0,{"v":10334,"d":"10,334"},{"v":53425,"d":"53,425"}]
[null,6,"2024-06-01",{"$f":"D10","v":40100},0,0,0,20050,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.09*D11,0),ROUND(0.18*D11,0)))","v":3609},0,0,0,0,63759,{"$f":"MASTERDATA!G10","v":2100},0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D11<18001,265,IF(D11<33501,440,IF(D11<54001,658,875))))","v":658},2576,0,0,null,"",0,{"v":10334,"d":"10,334"},{"v":53425,"d":"53,425"}]
[null,7,"2024-07-01",{"$f":"MROUND(ROUND(1.03*D11,0),100)","v":41300},0,0,0,20650,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.09*D12,0),ROUND(0.18*D12,0)))","v":3717},0,0,0,0,65667,2100,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D12<18001,265,IF(D12<33501,440,IF(D12<54001,658,875))))","v":658},2576,0,0,null,"",0,{"v":10334,"d":"10,334"},{"v":55333,"d":"55,333"}]
[null,8,"2024-08-01",{"$f":"D12","v":41300},0,0,0,20650,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.09*D13,0),ROUND(0.18*D13,0)))","v":3717},0,0,0,0,65667,{"$f":"O12","v":2100},0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D13<18001,265,IF(D13<33501,440,IF(D13<54001,658,875))))","v":658},2576,0,0,null,"",0,{"v":10334,"d":"10,334"},{"v":55333,"d":"55,333"}]
[null,9,"2024-09-01",41300,0,0,0,20650,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.09*D14,0),ROUND(0.18*D14,0)))","v":3717},0,0,0,0,65667,2100,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D14<18001,265,IF(D14<33501,440,IF(D14<54001,658,875))))","v":658},2576,0,0,null,"",0,{"v":10334,"d":"10,334"},{"v":55333,"d":"55,333"}]
[null,10,"2024-10-01",41300,0,0,0,20650,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.09*D15,0),ROUND(0.18*D15,0)))","v":3717},0,0,0,0,{"$f":"SUM(D15:M15)","v":65667},2100,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D15<18001,265,IF(D15<33501,440,IF(D15<54001,658,875))))","v":658},2576,0,0,null,"",0,{"v":10334,"d":"10,334"},{"v":55333,"d":"55,333"}]
[null,11,"2024-11-01",41300,0,0,0,{"$f":"ROUND(53%*D16,0)","v":21889},{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.1*D16,0),ROUND(0.2*D16,0)))","v":4130},0,0,0,0,67319,2100,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D16<18001,265,IF(D16<33501,440,IF(D16<54001,658,875))))","v":658},2576,0,0,null,"",0,{"v":10334,"d":"10,334"},{"v":56985,"d":"56,985"}]
[null,12,"2024-12-01",41300,0,0,0,{"$f":"ROUND(53%*D17,0)","v":21889},{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.1*D17,0),ROUND(0.2*D17,0)))","v":4130},0,0,0,0,67319,{"$f":"O16","v":2100},0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D17<18001,265,IF(D17<33501,440,IF(D17<54001,658,875))))","v":658},2576,0,0,null,"",0,{"v":10334,"d":"10,334"},{"v":56985,"d":"56,985"}]
[null,1,"2025-01-01",41300,0,0,0,21889,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.1*D18,0),ROUND(0.2*D18,0)))","v":4130},0,0,0,0,67319,2100,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D18<18001,265,IF(D18<33501,440,IF(D18<54001,658,875))))","v":658},2576,0,0,null,"",0,{"v":10334,"d":"10,334"},{"v":56985,"d":"56,985"}]
[null,2,"2025-02-01",41300,0,0,0,21889,{"$f":"IF(MASTERDATA!$G$9=\"NA\",0,IF(MASTERDATA!$G$9=10%,ROUND(0.1*D19,0),ROUND(0.2*D19,0)))","v":4130},0,0,0,0,67319,2100,0,5000,0,{"$f":"IF(MASTERDATA!$G$12=\"NO\",0,IF(D19<18001,265,IF(D19<33501,440,IF(D19<54001,658,875))))","v":658},2576,0,0,null,"",0,{"v":10334,"d":"10,334"},{"v":56985,"d":"56,985"}]
[null,null,"Salary Arrear",{"$nulls":10},0,{"$nulls":9},"",null,0,0]
[null,null,"Surender\n2024-25",{"$f":"IF(MASTERDATA!G11=\"NA\",0,IF(AND(MONTH(MASTERDATA!G11)>=3,MONTH(MASTERDATA!G11)<=6),'GA55'!D8/2,IF(OR(MONTH(MASTERDATA!G11)>=7,MONTH(MASTERDATA!G11)<=2),'GA55'!D12/2)))","v":20650},{"$nulls":3},{"$f":"IF(AND(MASTERDATA!G11>=DATE(2024,3,1),MASTERDATA!G11<=DATE(2024,10,31)),'GA55'!D21*50%,IF(OR(AND(MASTERDATA!G11>=DATE(2024,11,1),MASTERDATA!G11<=DATE(2024,12,31)),AND(MASTERDATA!G11>=DATE(2025,1,1),MASTERDATA!G11<=DATE(2025,2,28))),'GA55'!D21*53%,\" \"))","v":10325},{"$nulls":5},30975,{"$nulls":9},"",null,0,{"v":30975,"d":"30,975"}]
[null,null,"Bonus\n2024-25",{"$f":"IF(MASTERDATA!D12=\"YES\",6774,0)","v":0},{"$nulls":9},0,{"$f":"IF(D22=0,0,ROUND(D22*25%,0))","v":0},0,{"$nulls":7},"",null,0,{"$f":"N22-Z22","v":0}]
[null,null,"DA Arrear 1.24 to2.24 ",{"$nulls":4},{"$f":"(ROUND(D8*50%,0)-ROUND(D8*46%,0))*2","v":3208},{"$nulls":3},"",null,3208,{"$f":"N23","v":3208},0,{"$nulls":7},"",null,{"v":3208,"d":"3,208"},0]
[null,null,"DA Arrear 7.24 to 10.24",{"$nulls":4},{"$f":"(ROUND(D12*53%,0)-ROUND(D12*50%,0))*4","v":4956},{"$nulls":5},4956,{"$f":"N24","v":4956},{"$nulls":10},{"v":4956,"d":"4,956"},0]
[null,null,"Other Arrear ",{"$nulls":10},0,{"$f":"N25","v":0},{"$nulls":8},"",null,0,0]
[null,null,"Other 1",{"$nulls":10},0,{"$nulls":9},"",null,{"$f":"SUM(O26:Y26)","v":0},0]
[null,null,"TOTAL",{"$f":"SUM(D8:D26)","v":{"v":511450,"d":"511,450"}},0,0,0,{"v":268845,"d":"268,845"},{"v":45824,"d":"45,824"},0,0,0,0,{"v":826119,"d":"826,119"},{"v":33364,"d":"33,364"},0,{"v":60000,"d":"60,000"},0,{"$f":"SUM(S8:S26)","v":{"v":7896,"d":"7,896"}},{"v":30912,"d":"30,912"},700,0,0,0,0,{"v":132872,"d":"132,872"},{"v":693247,"d":"693,247"}]
[]
[]
[{"$nulls":4},"Signature of Employee",{"$nulls":21},"Signature of DDO"]
[{"$nulls":4},{"$f":"MASTERDATA!D5","v":"SUNIL KUMAR MAHAWAR "},{"$nulls":8},"digitalgurujihelp",{"$nulls":12},{"$f":"MASTERDATA!G4","v":"MR. SANTOSH KUMAR VYAS"}]

{"sheet":"EXTRA DEDUCATION","index":3,"n_rows":21,"n_cols":7,"rows_kept":21,"merged":[[0,0,0,6],[1,0,1,6]]}
["वेतन के अलावा अन्य आय, कटौतियाँ, एवं छूट का विवरण "]
[{"$f":"MASTERDATA!D5& \",          \"&'GA55'!D6&\"         PAN- \"&'GA55'!M5","v":"SUNIL KUMAR MAHAWAR ,          TEACHER  (L10)         PAN- GGGGGHGH "}]
[]
[1,"मकान किराया भत्ता (यदि रसीद से छूट ) HRA",{"v":0,"d":"00"},null,19,"स्टैण्डर्ड डिडक्शन रुपये 50,000(old tax regime,75000(new tax regime)",75000]
[2,"  मनोरंजन भत्ता धारा  16  (ii) के अंतर्गत ",{"v":0,"d":"00"},null,20," बचत खाते  (All Saving Accounts) की जमा राशि पर प्राप्त ब्याज",{"v":0,"d":"00"}]
[3," व्यवसाय कर  धारा  16  (iii) के अंतर्गत  ",{"v":0,"d":"00"},null,21,"FD (Bank/ Post Office) आदि अन्य जमा राशि पर प्राप्त कुल ब्याज (PPF को छोड़कर)",{"v":0,"d":"00"}]
[4," गृह सम्पति से प्राप्त किराया  - आय ",{"v":0,"d":"00"},null,22,"ब्याज के अलावा अन्य आय (विभिन्न स्त्रो़त्र से) ",{"v":0,"d":"00"}]
[5," गृहकर ",{"v":0,"d":"00"},null,23,"अन्य मद में जमा करायी गयी राशि यदि कोई हो तो (धारा 80C के अन्तर्गत) ",{"v":0,"d":"00"}]
[6," गृह ऋण की मूल किस्त यहाँ लिखनी है, HBA Premium",{"v":0,"d":"00"},null,24,"धारा 80CCD पेंशन प्लान हेतु अंशदान (NPS के अलावा)",{"v":0,"d":"00"}]
[7," गृह ऋण की किस्त पर ब्याज जो छूट लेना है, यहाँ लिखें I",{"v":0,"d":"00"},null,25,"स्थगित वार्षिकी (Defferred Anniuty)",{"v":0,"d":"00"}]
[8," जीवन बीमा प्रीमियम  (जो वेतन से नहीं काटा गया है ) LIC",{"v":0,"d":"00"},null,26,"धारा 10(14) के अन्तर्गत भत्ते जो कर मुक्त है",{"v":0,"d":"00"}]
[9," पी.एल.आई. (PLI)",{"v":0,"d":"00"},null,27,"धारा 80D -चिकित्सा बीमा प्रीमियम (सामान्य 25000, वरिष्ठ नागरिक 50000)",{"v":0,"d":"00"}]
[10," ट्यूशन फ़ीस (Tution Fees)",{"v":0,"d":"00"},null,28,"धारा 80DD-विकलांग आश्रितों के चिकित्सा उपचार (विकलांगता 40%-75000, 80%-125000)",{"v":0,"d":"00"}]
[11,"  यू एल आई पी / वार्षिक प्लान",{"v":0,"d":"00"},null,29,"धारा 80DDB- विशिष्ट रोगों के उपचार हेतु कटौती (सामान्य 40000, वरिष्ठ नागरिक 1 लाख)",{"v":0,"d":"00"}]
[12,"  राष्ट्रीय बचत पत्र (NSC)",{"v":0,"d":"00"},null,30,"धारा 80E- उच्च शिक्षा हेतु लिए ऋण का ब्याज",{"v":0,"d":"00"}]
[13,"  राष्ट्रीय बचत पत्र पर अदत ब्याज ",null,null,31,"धारा 80G-धर्मार्थ संस्थाओं आदि को दिये दान (क श्रेणी 100%, एवं ख श्रेणी 50%)",{"v":0,"d":"00"}]
[14,"  लोक भविष्य निधि (PPF)",{"v":0,"d":"00"},null,32,"धारा 80U- स्थाई शारीरिक विकलांगता (अधिकतम 75000, 80% विकलांगता 125000)"]
[15,"  राष्ट्रीय बचत पत्र स्कीम (NSS) ",{"v":0,"d":"00"},null,33,"धारा 80GGA- अनुमोदित वैज्ञानिक,सामाजिक,ग्रामीण विकास हेतु दिया गया दान",{"v":0,"d":"00"}]
[16,"  सुकन्या समृद्धि योजना में जमा राशि  (SSY)",{"v":0,"d":"00"},null,34,"धारा 89 के अन्तर्गत राहत",{"v":0,"d":"00"}]
[17,"  इक्विटी लिंक सेविंग स्कीम ",{"v":0,"d":"00"},null,35,"वेतन बिल के अलावा जमा कराया गया आयकर (TDS)"]
[18,"धारा 80 CCD (1B) NPS में अतिरिक्त अंशदान ( अधिकतम 50,000)",null,null,36,"धारा 80 ccc पेंशन प्लान हेतु अंश दान ( NPS के अलावा )"]

{"sheet":"OLD TAX REGIME","index":4,"n_rows":67,"n_cols":16,"rows_kept":67,"merged":[[1,1,1,13],[1,14,2,16],[2,1,2,13],[3,2,3,3],[3,4,3,9],[3,11,3,13],[3,15,3,16],[4,2,4,14],[4,15,4,16],[5,2,5,14],[5,15,5,16],[6,2,6,14],[6,15,6,16],[7,1,10,1],[7,2,7,11],[7,12,7,14],[7,15,9,16],[8,2,8,11],[8,12,8,14],[9,2,9,11],[9,12,9,14],[10,2,10,14],[10,15,10,16],[11,2,11,14],[11,15,11,16],[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],[15,15,15,16],[16,2,16,14],[16,15,16,16],[17,2,17,14],[17,15,17,16],[18,2,18,14],[18,15,18,16],[19,1,34,1],[19,2,19,16],[20,2,20,16],[21,3,21,6],[21,7,21,8],[21,9,22,9],[21,10,22,12],[21,13,22,14],[21,15,30,16],[22,3,22,6],[22,7,22,8],[23,3,23,6],[23,7,23,8],[23,10,23,12],[23,13,23,14],[24,3,24,6],[24,7,24,8],[24,10,24,12],[24,13,24,14],[25,3,25,6],[25,7,25,8],[25,10,25,12],[25,13,25,14],[26,3,26,6],[26,7,26,8],[26,10,26,12],[26,13,26,14],[27,3,27,6],[27,7,27,8],[27,10,27,12],[27,13,27,14],[28,3,28,6],[28,7,28,8],[28,10,28,12],[28,13,28,14],[29,3,29,6],[29,7,29,8],[29,10,29,12],[29,13,29,14],[30,3,30,6],[30,7,30,8],[30,10,30,12],[30,13,30,14],[31,2,31,14],[31,15,31,16],[32,2,32,14],[32,15,32,16],[33,2,33,14],[33,15,33,16],[34,2,34,14],[34,15,34,16],[35,1,45,1],[35,2,35,16],[36,2,36,14],[36,15,36,16],[37,2,37,14],[37,15,37,16],[38,2,38,14],[38,15,38,16],[39,2,39,14],[39,15,39,16],[40,2,40,14],[40,15,40,16],[41,2,41,14],[41,15,41,16],[42,2,42,14],[42,15,42,16],[43,2,43,14],[43,15,43,16],[44,2,44,14],[44,15,44,16],[45,2,45,14],[45,15,45,16],[46,2,46,14],[46,15,46,16],[47,2,47,14],[47,15,47,16],[48,2,48,14],[48,15,48,16],[49,1,59,1],[49,2,49,16],[50,2,50,6],[50,7,50,10],[50,11,50,14],[50,15,50,16],[51,2,51,4],[51,5,51,6],[51,7,51,9],[51,11,51,13],[51,15,51,16],[52,2,52,4],[52,5,52,6],[52,7,52,9],[52,11,52,13],[52,15,52,16],[53,2,53,4],[53,5,53,6],[53,7,53,9],[53,11,53,13],[53,15,53,16],[54,2,54,4],[54,5,54,6],[54,7,54,9],[54,11,54,13],[54,15,54,16],[55,2,55,14],[55,15,55,16],[56,2,56,14],[56,15,56,16],[57,2,57,14],[57,15,57,16],[58,2,58,14],[58,15,58,16],[59,2,59,14],[59,15,59,16],[60,2,60,14],[60,15,60,16],[61,2,61,14],[61,15,61,16],[62,1,63,1],[62,2,63,4],[62,5,62,8],[62,9,62,10],[62,12,62,13],[62,15,62,16],[63,5,63,8],[63,9,63,10],[63,12,63,13],[63,15,63,16],[64,1,64,14],[64,15,64,16]]}
[]
[null,{"$f":"MASTERDATA!D3","v":"GOVT SR SEC SCHOOL VEER DHOLIYA "},{"$nulls":12},"OLD TAX REGIME"]
[null,"आयकर गणना प्रपत्र वर्ष 2024-25 ( कर निर्धारण वर्ष  2025-26 )"]
[null,1,"नाम कर्मचारी :-",null,{"$f":"MASTERDATA!D5","v":"SUNIL KUMAR MAHAWAR "},{"$nulls":5},"पद",{"$f":"'NEW TAX REGIME'!L4:N4","v":"TEACHER   -L10"},null,null,"PAN :",{"$f":"'NEW TAX REGIME'!P4:Q4","v":"GGGGGHGH "}]
[null,2,"आय : वर्ष  2024-25  में प्राप्त कुल आय ( कर योग्य मूल्यों सहित ) ",{"$nulls":12},{"$f":"'GA55'!N27","v":{"v":826119,"d":"₹ 826,119"}}]
[null,3,"गृह किराया धारा 10 (13-A) के अंतर्गत व धारा  10(14) के अंतर्गत भत्ते  तथा अन्य भत्ते जो कर मुक्त है I",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G10+'EXTRA DEDUCATION'!C4","v":0}]
[null,4,"शेष ( 2-3) ",{"$nulls":12},{"$f":"P5-P6","v":{"v":826119,"d":"₹ 826,119"}}]
[null,5,"  (i) मनोरंजन भत्ता धारा  16  (ii) के अंतर्गत ",{"$nulls":9},{"$f":"'EXTRA DEDUCATION'!C5","v":{"v":0,"d":"0.00"}}]
[null,null," (ii) व्यवसाय कर  धारा  16  (iii) के अंतर्गत ",{"$nulls":9},{"$f":"'EXTRA DEDUCATION'!C6","v":{"v":0,"d":"0.00"}}]
[null,null," (iii) स्टैण्डर्ड डीडेक्सन (Standard Deduction)  50,000  (अधिकतम )",{"$nulls":9},{"$f":"IF('EXTRA DEDUCATION'!G4=0,0,IF('EXTRA DEDUCATION'!G4=50000,50000,IF('EXTRA DEDUCATION'!G4=75000,50000,)))","v":{"v":50000,"d":"50000.00"}}]
[null,null,"योग (5) ",{"$nulls":12},{"$f":"SUM(M8:O10)","v":{"v":50000,"d":"₹ 50,000"}}]
[null,6,"                                                      शेष ( 4-5) ",{"$nulls":12},{"$f":"P7-P11","v":{"v":776119,"d":"₹ 776,119"}}]
[null,7," गृह सम्पति से आय : (1) स्वयं के उपभोग में शून्य :-",{"$nulls":7},"(2)प्राप्त किराया रु.",null,{"$f":"'EXTRA DEDUCATION'!C7","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":"'EXTRA DEDUCATION'!C10","v":{"v":0,"d":"0.00"}},null,null,{"$f":"'EXTRA DEDUCATION'!C8","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":0}]
[null,8,"कुल शेष -/+ (6 एवं 7)",{"$nulls":12},{"$f":"P12+P16","v":{"v":776119,"d":"₹ 776,119"}}]
[null,9,"अन्य आय ",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G6","v":0}]
[null,10,"सकल आय                                                                                                                                                            योग (8+9)",{"$nulls":12},{"$f":"P17+P18","v":{"v":776119,"d":"₹ 776,119"}}]
[null,11,"घटाए कटोतियाँ :- धारा  US 80C, 80CCC,80CCD (1)  "]
[null,null,"(A) अधिकतम सीमा 1,50,000/- (धारा 80CCE), धारा 80CCD(2), तथा धारा 80CCD(1B) के अतिरिक्त"]
[null,null,"(i)","राज्य बीमा (SI)",{"$nulls":3},{"$f":"'GA55'!Q27","v":{"v":60000,"d":"₹ 60,000"}},null,"(xi)","पेंशन योजना में योगदान  ECPF धारा  80ccd(1)",null,null,{"$f":"'EXTRA DEDUCATION'!G8","v":0}]
[null,null,"(ii)","जीवन बीमा  ( LIC)",{"$nulls":3},{"$f":"'GA55'!T27+'EXTRA DEDUCATION'!C11","v":{"v":30912,"d":"₹ 30,912"}}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C15","v":0},null,"(xii)","पेंशन प्लान हेतु योगदान  (धारा 80ccc)",null,null,{"$f":"'EXTRA DEDUCATION'!G20","v":0}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C17","v":0},null,"(xiii)","राष्ट्रीय बचत पत्र पर अदत ब्याज ",null,null,{"$f":"'EXTRA DEDUCATION'!C15","v":0}]
[null,null,"(v)","राष्ट्रीय बचत पत्र स्कीम (NSS)",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C18","v":0},null,"(xiv)","टियुशन फ़ीस",null,null,{"$f":"'EXTRA DEDUCATION'!C13","v":0}]
[null,null,"(vi)","सामान्य प्रावधायी निधि  GPF) / GPF - 2004",{"$nulls":3},{"$f":"'GA55'!O27","v":{"v":33364,"d":"₹ 33,364"}},null,"(xv)","इक्विटी लिंक सेविंग स्कीम ",null,null,{"$f":"'EXTRA DEDUCATION'!C20","v":0}]
[null,null,"(vii)","सामूहिक बीमा प्रीमियम  (G.Ins.)",{"$nulls":3},{"$f":"'GA55'!U27","v":{"v":700,"d":"₹ 700"}},null,"(xvi)","स्थगत वार्षिकी (Defferred Annuty)",null,null,{"$f":"'EXTRA DEDUCATION'!G9","v":0}]
[null,null,"(viii)","यू एल आई पी / वार्षिक प्लान ",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C14","v":0},null,"(xvii)","पी.एल.आई . (PLI)",null,null,{"$f":"'EXTRA DEDUCATION'!C12","v":0}]
[null,null,"(ix)","गृह ऋण किस्त (HBA Premium)",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C9","v":0},null,"(xviii)","अन्य राशि जो धारा 80 C के अंतर्गत छुट  ",null,null,{"$f":"'EXTRA DEDUCATION'!G7","v":0}]
[null,null,"(x)","सुकन्या समृद्धि योजना में जमा राशि",{"$nulls":3},{"$f":"'EXTRA DEDUCATION'!C19","v":0},null,"(xix)","योग  ( i से xix )",null,null,{"$f":"SUM(H22:I31)+SUM(N22:O30)","v":{"v":124976,"d":"₹ 124,976"}}]
[null,null,"अधिकतम कटोती राशि 1.50 लाख रुपये तक",{"$nulls":12},{"$f":"IF(N31<150001,ROUND(N31,0),150000)","v":{"v":124976,"d":"₹ 124,976"}}]
[null,null,"(B) घटाइये धारा  80CCD(2) नियोक्ता द्वारा  पेंशन अंशदान की राशि  (अधिकतम वेतन का 10%)  पृथक से छुट ",{"$nulls":12},0]
[null,null,"(C) घटाइये - धारा  80CCD (1B) नवीन पेंशन योजना में अतिरिक्त अंशदान  (अधिकतम 50,000 रु. )",{"$nulls":12},{"$f":"IF('EXTRA DEDUCATION'!C21>=50000,50000,'EXTRA DEDUCATION'!C21)","v":0}]
[null,null,"योग 11(A+B+C)      ",{"$nulls":12},{"$f":"SUM(P32:Q34)","v":{"v":124976,"d":"₹ 124,976"}}]
[null,12,"अन्य कटोतियाँ"]
[null,null,"1. धारा 80 D चिकित्सा बीमा प्रीमियम  (स्वयं पति पत्नि व बच्चों के लिए रु. 25,000 माता - पिता के लिए रु. 25,000 , सीनियर सिटीजन रु. 50,000 )",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G11","v":0}]
[null,null,"2. धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80% या अधिक विकलांगता ( 1,25,000)",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G12","v":0}]
[null,null,"3. धारा  80DDB विशिष्ट रोगों के उपचार हेतु छुट  (अधिकतम रु. 40,000, सीनियर सिटीजन हेतु रु. 1,00,000)",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G13","v":0}]
[null,null,"4. धारा  80E उच्च शिक्षा हेतु लिए गए ऋण का ब्याज ",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G14","v":0}]
[null,null,"5. धारा 80G धर्मार्थ संस्थाओ आदि को दिए दान ( क श्रेणी में  100 प्रतिशत एव ख श्रेणी में 50 प्रतिशत)   (केंद्र एव राज्य सरकार के फण्ड में )",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G15","v":0}]
[null,null,"6. धारा 80U स्थाई रूप से शारीरिक असमर्थता की दशा में  (अधिकतम  75,000 तथा अधिनियम 1995 के अनुसार 1,25,000)",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G16","v":0}]
[null,null,"7. धारा 80 TTA बचत खाते पर अधिकतम ब्याज पर 10,000           U/S 194(IA)  ",{"$nulls":12},{"$f":"IF(MASTERDATA!D14=\"YES\",0,IF('EXTRA DEDUCATION'!G4>10000,10000,'EXTRA DEDUCATION'!G4))","v":{"v":10000,"d":"₹ 10,000"}}]
[null,null,"8. धारा 80 TTB वरिष्ठ नागरिकों को सभी प्रकार के ब्याज पर छूट अधिकतम - 50,000 रु.        U/S 194(A)",{"$nulls":12},{"$f":"IF(MASTERDATA!D14=\"NO\",0,IF('EXTRA DEDUCATION'!G4<50001,'EXTRA DEDUCATION'!G4,50000))","v":0}]
[null,null,"9. धारा 80 GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G17","v":0}]
[null,null,"कुल योग 12 ( 1 से 9 तक )",{"$nulls":12},{"$f":"SUM(P37:Q45)","v":{"v":10000,"d":"₹ 10,000"}}]
[null,13,"कुल कटोती ( 11 + 12)",{"$nulls":12},{"$f":"P35+P46","v":{"v":134976,"d":"₹ 134,976"}}]
[null,14,"कर योग्य आय ( 10 - 13 )",{"$nulls":12},{"$f":"(P19-P47)","v":{"v":641143,"d":"₹ 641,143"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना ( दस के गुणांक में ) धारा  288A",{"$nulls":12},{"$f":"ROUND(P48,-1)","v":{"v":641140,"d":"₹ 641,140"}}]
[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",{"$nulls":4},0]
[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(MASTERDATA!$D$14=\"NO\",IF(P49<250001,0,IF(P49>500000,12500,((P49-250000)*0.05))),IF(P49<300001,0,IF(P49>500000,10000,((P49-300000)*0.05)))),0)","v":{"v":12500,"d":"₹ 12,500"}}]
[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(P49<500001,0,IF(P49>1000000,100000,((P49-500000)*0.2)))","v":{"v":28228,"d":"₹ 28,228"}}]
[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(P49<1000001,0,((P49-1000000)*0.3))","v":0}]
[null,null,"(1) योग आयकर ",{"$nulls":12},{"$f":"SUM(P52:Q55)","v":{"v":40728,"d":"₹ 40,728"}}]
[null,null,"(2) छुट धारा 87(A)  (5 लाख की कर योग्य आय पर आयकर की छुट अधिकतम रु. 12500/- तक)",{"$nulls":12},{"$f":"IF(P49>500000,0,IF(P56<12501,P56,12500))","v":0}]
[null,null,"(3) शेष आयकर  (1-2)",{"$nulls":12},{"$f":"P56-P57","v":{"v":40728,"d":"₹ 40,728"}}]
[null,null,"(4) शिक्षा एवं चिकित्सा उपकर  4% (आयकर पर )",{"$nulls":12},{"$f":"ROUND(P58*0.04,0)","v":{"v":1629,"d":"₹ 1,629"}}]
[null,null,"                                                                                                                                                             कुल आयकर  (3+4)",{"$nulls":12},{"$f":"SUM(P58:Q59)","v":{"v":42357,"d":"₹ 42,357"}}]
[null,17," घटाइये :-   राहत धारा  89 के तहत  ",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G18","v":0}]
[null,18,"कुल शेष आयकर ",{"$nulls":12},{"$f":"P60-P61","v":{"v":42357,"d":"₹ 42,357"}}]
[null,19,"आयकर कटौती \n का विवरण ",null,null,"सितम्बर  2024\nतक कुल राशि ",{"$nulls":3},"अक्टू. से दिस. 24\nतक राशि ",null,"जनवरी 2025\nराशि ","फरवरी 2025\nराशि ",null,"टी. डी. एस. राशि ","कुल टैक्स कटौती योग कॉलम 19 "]
[{"$nulls":5},{"$f":"SUM('GA55'!V8:V14)","v":0},{"$nulls":3},{"$f":"SUM('GA55'!V15:V17)","v":0},null,{"$f":"'GA55'!V18","v":0},{"$f":"'GA55'!V19","v":0},null,{"$f":"'EXTRA DEDUCATION'!G19+'GA55'!V20+'GA55'!V21+'GA55'!V22+'GA55'!V23+'GA55'!V25+'GA55'!V26","v":0},{"$f":"F64+J64+L64+M64+O64","v":0}]
[null,{"$f":"IF(P62>P64,\"Income Tax Payable (Old Tax Regime)\",IF(P62<P64,\"Income Tax Refundable (Old Tax Regime)\",\"Income Tax Payble/Refundable (Old Tax Regime)\"))","v":"Income Tax Payable (Old Tax Regime)"},{"$nulls":13},{"$f":"P62-P64","v":{"v":42357,"d":"₹ 42,357"}}]
[]
[{"$nulls":4},"Signature of Employee",{"$nulls":9},"Signature of DDO"]

{"sheet":"NEW TAX REGIME","index":5,"n_rows":59,"n_cols":16,"rows_kept":59,"merged":[[1,1,1,13],[1,14,2,16],[2,1,2,13],[3,2,3,3],[3,4,3,9],[3,11,3,13],[3,15,3,16],[4,2,4,14],[4,15,4,16],[5,2,5,14],[5,15,5,16],[6,2,6,14],[6,15,6,16],[7,1,10,1],[7,2,7,11],[7,12,7,14],[7,15,9,16],[8,2,8,11],[8,12,8,14],[9,2,9,11],[9,12,9,14],[10,2,10,14],[10,15,10,16],[11,2,11,14],[11,15,11,16],[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],[15,15,15,16],[16,2,16,14],[16,15,16,16],[17,2,17,14],[17,15,17,16],[18,2,18,14],[18,15,18,16],[19,1,23,1],[19,2,19,16],[20,2,20,14],[20,15,20,16],[21,2,21,14],[21,15,21,16],[22,2,22,14],[22,15,22,16],[23,2,23,14],[23,15,23,16],[24,1,34,1],[24,2,24,16],[25,2,25,14],[25,15,25,16],[26,2,26,14],[26,15,26,16],[27,2,27,14],[27,15,27,16],[28,2,28,14],[28,15,28,16],[29,2,29,14],[29,15,29,16],[30,2,30,14],[30,15,30,16],[31,2,31,14],[31,15,31,16],[32,2,32,14],[32,15,32,16],[33,2,33,14],[33,15,33,16],[34,2,34,14],[34,15,34,16],[35,2,35,14],[35,15,35,16],[36,2,36,14],[36,15,36,16],[37,2,37,14],[37,15,37,16],[38,1,50,1],[38,2,38,16],[39,2,39,6],[39,7,39,10],[39,11,39,14],[39,15,39,16],[40,2,40,4],[40,5,40,6],[40,7,40,9],[40,11,40,13],[40,15,40,16],[41,2,41,4],[41,5,41,6],[41,7,41,9],[41,11,41,13],[41,15,41,16],[42,2,42,4],[42,5,42,6],[42,7,42,9],[42,11,42,13],[42,15,42,16],[43,2,43,4],[43,5,43,6],[43,7,43,9],[43,11,43,13],[43,15,43,16],[44,2,44,4],[44,5,44,6],[44,7,44,9],[44,11,44,13],[44,15,44,16],[45,2,45,4],[45,5,45,6],[45,7,45,9],[45,11,45,13],[45,15,45,16],[46,2,46,14],[46,15,46,16],[47,2,47,14],[47,15,47,16],[48,2,48,14],[48,15,48,16],[49,2,49,14],[49,15,49,16],[50,2,50,14],[50,15,50,16],[51,2,51,14],[51,15,51,16],[52,2,52,14],[52,15,52,16],[53,1,54,1],[53,2,54,4],[53,5,53,8],[53,9,53,10],[53,12,53,13],[53,15,53,16],[54,5,54,8],[54,9,54,10],[54,12,54,13],[54,15,54,16],[55,1,55,14],[55,15,55,16]]}
[]
[null,{"$f":"MASTERDATA!D3","v":"GOVT SR SEC SCHOOL VEER DHOLIYA "},{"$nulls":12},"NEW TAX REGIME"]
[null,"आयकर गणना प्रपत्र वर्ष 2024-25 ( कर निर्धारण वर्ष  2025-26 )"]
[null,1,"नाम कर्मचारी :-",null,{"$f":"MASTERDATA!D5","v":"SUNIL KUMAR MAHAWAR "},{"$nulls":5},"पद :-",{"$f":"MASTERDATA!G5&\"  -\"&MASTERDATA!D10","v":"TEACHER   -L10"},null,null,"PAN :  ",{"$f":"MASTERDATA!D6","v":"GGGGGHGH "}]
[null,2,"आय : वर्ष  2024-25  में प्राप्त कुल आय ( कर योग्य मूल्यों सहित ) ",{"$nulls":12},{"$f":"'OLD TAX REGIME'!P5:Q5","v":{"v":826119,"d":"₹ 826,119"}}]
[null,3,"गृह किराया धारा 10 (13-A) के अंतर्गत व धारा  10(14) के अंतर्गत भत्ते  तथा अन्य भत्ते जो कर मुक्त है I",{"$nulls":12},0]
[null,4,"शेष ( 2-3)   ",{"$nulls":12},{"$f":"P5-P6","v":{"v":826119,"d":"₹ 826,119"}}]
[null,5,"  (i) मनोरंजन भत्ता धारा  16  (ii) के अंतर्गत ",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,null," (ii) व्यवसाय कर  धारा  16  (iii) के अंतर्गत ",{"$nulls":9},{"v":0,"d":"0.00"}]
[null,null," (iii) स्टैण्डर्ड डीडेक्सन (Standard Deduction)  75,000  (अधिकतम )",{"$nulls":9},{"$f":"IF('EXTRA DEDUCATION'!G4=0,0,IF('EXTRA DEDUCATION'!G4=50000,0,IF('EXTRA DEDUCATION'!G4=75000,75000)))","v":{"v":75000,"d":"75000.00"}}]
[null,null,"                                                           योग (5)    ",{"$nulls":12},{"$f":"SUM(M8:O10)","v":{"v":75000,"d":"₹ 75,000"}}]
[null,6,"                                                      शेष ( 4-5)    ",{"$nulls":12},{"$f":"P7-P11","v":{"v":751119,"d":"₹ 751,119"}}]
[null,7," गृह सम्पति से आय : (1) स्वयं के उपभोग में शून्य :-",{"$nulls":7},"(2) प्राप्त किराया रु .",null,{"$f":"'EXTRA DEDUCATION'!C7","v":{"v":0,"d":"0.00"}}]
[null,null,"(ब) घटाइये",null,"किराये का 30%",null,null,"गृह ऋण पर ब्याज ",null,null,"गृह कर ",null,"योग 7 (ब)"]
[{"$nulls":4},{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,null,{"v":0,"d":"0.00"},null,{"$f":"SUM(E15:L15)","v":{"v":0,"d":"0.00"}}]
[null,null,"शेष -/+  (7 (अ)  एवं योग 7 (ब) का ) :-   ",{"$nulls":12},{"$f":"M13","v":0}]
[null,8,"कुल शेष -/+ (6 एवं 7)   ",{"$nulls":12},{"$f":"P12+P16","v":{"v":751119,"d":"₹ 751,119"}}]
[null,9,"अन्य आय ",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G6","v":0}]
[null,10,"सकल आय                                                                                                                                                            योग (8+9)",{"$nulls":12},{"$f":"P17+P18","v":{"v":751119,"d":"₹ 751,119"}}]
[null,11,"घटाए कटोतियाँ :- "]
[null,null,"(A) धारा  US 80C, 80CCC,80CCD (1) अधिकतम कटौती की राशि ",{"$nulls":12},0]
[null,null,"(B) घटाइये धारा  80CCD(2) नियोक्ता द्वारा  पेंशन अंशदान की राशि  (अधिकतम वेतन का 10%)  पृथक से छुट ",{"$nulls":12},0]
[null,null,"(C) घटाइये - धारा  80CCD (1B) नवीन पेंशन योजना में अतिरिक्त अंशदान  (अधिकतम 50,000 रु. )",{"$nulls":12},0]
[null,null,"योग 11(A+B+C)      ",{"$nulls":12},{"$f":"SUM(P21:Q23)","v":0}]
[null,12,"अन्य कटोतियाँ"]
[null,null,"1. धारा 80 D चिकित्सा बीमा प्रीमियम  (स्वयं पति पत्नि व बच्चों के लिए रु. 25,000 माता - पिता के लिए रु. 25,000 , सीनियर सिटीजन रु. 50,000 )",{"$nulls":12},0]
[null,null,"2. धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80% या अधिक विकलांगता ( 1,25,000)",{"$nulls":12},0]
[null,null,"3. धारा  80DDB विशिष्ट रोगों के उपचार हेतु छुट  (अधिकतम रु. 40,000, सीनियर सिटीजन हेतु रु. 1,00,000)",{"$nulls":12},0]
[null,null,"4. धारा  80E उच्च शिक्षा हेतु लिए गए ऋण का ब्याज ",{"$nulls":12},0]
[null,null,"5. धारा 80G धर्मार्थ संस्थाओ आदि को दिए दान ( क श्रेणी में  100 प्रतिशत एव ख श्रेणी में 50 प्रतिशत)   (केंद्र एव राज्य सरकार के फण्ड में )",{"$nulls":12},0]
[null,null,"6. धारा 80U स्थाई रूप से शारीरिक असमर्थता की दशा में  (अधिकतम  75,000 तथा अधिनियम 1995 के अनुसार 1,25,000)",{"$nulls":12},0]
[null,null,"7. धारा 80 TTA बचत खाते पर अधिकतम ब्याज पर 10,000           U/S 194(IA)  ",{"$nulls":12},0]
[null,null,"8. धारा 80 TTB वरिष्ठ नागरिकों को सभी प्रकार के ब्याज पर छूट अधिकतम - 50,000 रु.        U/S 194(A)",{"$nulls":12},0]
[null,null,"9. धारा 80 GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान",{"$nulls":12},0]
[null,null,"कुल योग 12 ( 1 से 9 तक )  ",{"$nulls":12},{"$f":"SUM(Q26:Q34)","v":0}]
[null,13,"कुल कटोती ( 11 + 12)",{"$nulls":12},{"$f":"P24+P35","v":0}]
[null,14,"कर योग्य आय ( 10 - 13 )",{"$nulls":12},{"$f":"(P19-P36)","v":{"v":751119,"d":"₹ 751,119"}}]
[null,15,"कुल आय की राशि को सम्पूर्ण करना ( दस के गुणांक में ) धारा  288A",{"$nulls":12},{"$f":"ROUND(P37,-1)","v":{"v":751120,"d":"₹ 751,120"}}]
[null,16,"आयकर की गणना उपर्युक्त कॉलम  15 के आधार पर "]
[null,null,"80 वर्ष या अधिक आयु ",{"$nulls":4},"वरिष्ठ नागरिक (60 से 80 वर्ष तक)",{"$nulls":3},"सामान्य नागरिक "]
[null,null,"3,00,000 तक ",null,null,"Nil",null,"3,00,000 तक ",null,null,"Nil","3,00,000 तक ",null,null,"Nil",0]
[null,null,"3,00,001-7,00,000",null,null,{"v":0.05,"d":"5%"},null,"3,00,001-7,00,000",null,null,{"v":0.05,"d":"5%"},"3,00,001-7,00,000",null,null,{"v":0.05,"d":"5%"},{"$f":"IF(P38<300001,0,IF(P38>700000,20000,((P38-300000)*0.05)))","v":{"v":20000,"d":"₹ 20,000"}}]
[null,null,"7,00,001-10,00,000",null,null,{"v":0.1,"d":"10%"},null,"7,00,001-10,00,000",null,null,{"v":0.1,"d":"10%"},"7,00,001-10,00,000",null,null,{"v":0.1,"d":"10%"},{"$f":"IF(P38<700001,0,IF(P38>1000000,30000,((P38-700000)*0.1)))","v":{"v":5112,"d":"₹ 5,112"}}]
[null,null,"10,00,001-12,00,000",null,null,{"v":0.15,"d":"15%"},null,"10,00,001-12,00,000",null,null,{"v":0.15,"d":"15%"},"10,00,001-12,00,000",null,null,{"v":0.15,"d":"15%"},{"$f":"IF(P38<1000001,0,IF(P38>1200000,30000,((P38-1000000)*0.15)))","v":0}]
[null,null,"12,00,001 - 15,00,000",null,null,{"v":0.2,"d":"20%"},null,"12,00,001 - 15,00,000",null,null,{"v":0.2,"d":"20%"},"12,00,001 - 15,00,000",null,null,{"v":0.2,"d":"20%"},{"$f":"IF(P38<1200001,0,IF(P38>1500000,60000,((P38-1200000)*0.2)))","v":0}]
[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(P38<1500001,0,(P38-1500000)*0.3)","v":0}]
[null,null,"(1) योग आयकर ",{"$nulls":12},{"$f":"SUM(P41:Q46)","v":{"v":25112,"d":"₹ 25,112"}}]
[null,null,"(2) छुट धारा 87(A)  (7 लाख की कर योग्य आय पर आयकर की छुट अधिकतम रु. 25000/- तक)",{"$nulls":12},{"$f":"IF(P38<700001,P47,IF(P38>722224,0,P47-(P38-700000)))","v":0}]
[null,null,"(3) शेष आयकर  (1-2)",{"$nulls":12},{"$f":"P47-P48","v":{"v":25112,"d":"₹ 25,112"}}]
[null,null,"(4) शिक्षा एवं चिकित्सा उपकर  4% (आयकर पर )",{"$nulls":12},{"$f":"ROUND(P49*0.04,0)","v":{"v":1004,"d":"₹ 1,004"}}]
[null,null,"कुल आयकर (3+4):-",{"$nulls":12},{"$f":"SUM(P49:Q50)","v":{"v":26116,"d":"₹ 26,116"}}]
[null,17," घटाइये :-   राहत धारा  89 के तहत  ",{"$nulls":12},{"$f":"'EXTRA DEDUCATION'!G18","v":0}]
[null,18,"कुल शेष आयकर ",{"$nulls":12},{"$f":"P51-P52","v":{"v":26116,"d":"₹ 26,116"}}]
[null,19,"आयकर कटौती \n का विवरण ",null,null,"सितम्बर  2024\nतक कुल राशि ",{"$nulls":3},"अक्टूम्बर से दिसम्बर 24\nतक राशि ",null,"जनवरी 2025\nराशि ","फरवरी 2025\nराशि ",null,"टी. डी. एस. राशि ","कुल टैक्स कटौती योग कॉलम 19 "]
[{"$nulls":5},{"$f":"'OLD TAX REGIME'!F64:I64","v":0},{"$nulls":3},{"$f":"'OLD TAX REGIME'!J64:K64","v":0},null,{"$f":"'OLD TAX REGIME'!L64","v":0},{"$f":"'OLD TAX REGIME'!M64:N64","v":0},null,{"$f":"'OLD TAX REGIME'!O64","v":0},{"$f":"F55+J55+L55+M55+O55","v":0}]
[null,{"$f":"IF(P53>P55,\"Income Tax Payable (New Tax Regime)\",IF(P53<P55,\"Income Tax Refundable (New Tax Regime)\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable (New Tax Regime)"},{"$nulls":13},{"$f":"P53-P55","v":{"v":26116,"d":"₹ 26,116"}}]
[]
[]
[{"$nulls":4},"Signature of Employee",{"$nulls":9},"Signature of DDO"]

{"sheet":"Sheet1","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}