{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["INTRO","Gen Info","Pay & Allowances","Deductions","HRA","Salary","Assesment","Master","NSC INTT","RULES"],"not_rendered":{"images":3,"macros":1,"defined_names":10,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"INTRO","index":0,"n_rows":35,"n_cols":3,"rows_kept":35,"merged":[[0,0,20,0],[0,1,0,3],[1,1,1,2],[1,3,21,3],[2,1,2,2],[4,1,4,2],[15,2,19,2],[21,0,21,2]]}
[]
[null,"INCOME TAX ASSESMENT FOR FINANCIAL YEAR 2021-22"]
[null,"HOW TO USE   "]
[null,null,"राजस्थान राज्य कर्मचारियों के  लिए FY 2021-22 के लिए आयकर आकलन   बाबत इस UTILITY का प्रयोग किया जा सकता है । FILE को SAVE करने के लिए अपनी सुविधा से नाम देकर SAVE AS से Excel Macro- Enable Workbook के रूप में Save करें। file को open करते समय Enable Macro करें।यह excel utility केवल मात्र राज्य कार्मिको के income tax assesment के लिए सहायतार्थ तैयार की गई है ।यद्यपि इसे तैयार करने में पूर्ण सावधानी बरती गई है फिर भी किसी भूल चूक के लिए तैयार कर्ता उत्तरदायी नहीं है । किसी भी गणना के लिए त्रुटि पाए जाने पर आयकर विभाग के नियम मान्य होंगे  किसी प्रकार की तकनीकी कमी पाए जाने पर नीचे दिये गए EMAIL द्वारा अवगत कराने का श्रम करावे।(PLEASE USE LATEST VERSION OF THAT IS  OFFICE 2010 AND ABOVE FOR BEST RESULT)"]
[null,"   1. First Enable Macro whenever open file               2 Save as always in  Excel Macro-Enabled Workbook (*.xlsm)    "]
[null,"1.Gen Info Sheet :-","Gen Info शीट में कार्मिक की सामान्य सूचना, भरना है।शीट में महत्वपूर्ण स्थान पर आवश्यक निर्देश दिये गए है।वेतन से income tax कटौती को आपको manually MONTHLY भरना है।"]
[null,"2.PAY & Allowances Sheet :-","सर्वप्रथम माह मार्च 2021 का मूल वेतन F5 सेल मे लिखना है ।यदि वार्षिक वेतन वृद्धि को छोडकर acp या अन्य कारणो किसी माह मे वेतन मे बदलाव हुआ है तो सेल J2 मे माह क्रमांक और सेल M2 मे मूल वेतन लिखे।अन्य लागू भत्तो के संबन्धित सेल मे YES का चयन कर ड्रॉपडाउन या mannual डाटा भरे। यदि किसी माह में Fix वेतन मिला है तो सेल L12   में YES चयन कर  जिस माह मे FIX PAY मिला है उसके आगे YES अन्यथा NO का चयन करें।"]
[null,"3. Deductions SHEET","Deduction और Investment की एंट्री इस शीट मे करनी है ।अगर किसी प्रकार की अन्य आय को शामिल करना चाहते है तो CELL E6 मे एंट्री करनी है। SI कटौती ,80CCD1(B),RGHS एवं BONUS से संबन्धित विशेष सुविधा शीट के अंत मे आवश्यक दिशानिर्देश सहित दी गई है।"]
[null,"4. HRA SHEET ","यदि आप HRA छूट के लिए पात्र है तो सेल F5 मे आप द्वारा भुगतान किए गए किराये की राशि भरे ।complete  year के लिए HRA छूट के लिए पात्र नहीं है और   Partially HRA की छूट लेना चाहते है तो इस शीट में जिन महीनों के लिए छूट प्राप्त करना चाहते है उनके सामने \"YES\" चुने और Data Entry Sheet मे Dropdown से \"Partially\" चुने तथा Data Entry Sheet में B15 cell मे आप द्वारा भुगतान किए गए किराये की राशि भरे। नियमानुसार छूट Auto generate हो जाएगी।आप द्वारा अधिकतम छूट के लिए कितने किराए की रसीद आवश्यक है भी Auto Generate हो जाएगी।"]
[null," 5. Salary Sheet","सर्वप्रथम Refresh Salary बटन पर क्लिक कर आप द्वारा Data Entry शीट में भरे data अनुसार सैलरी शीट तैयार हो जाएगी ।यदि कोई बदलाव अपेक्षित है तो शीट मे आपकी आवश्यकता अनुसार कर सकते है।Refresh Salary बटन को क्लिक करने पर पुनः प्रारम्भिक अवस्था मे आ जाएगी । WHITE सेल में आवश्यकता अनुसार प्रविष्टि कर सकते है ।अन्य भत्ते एवं कटौती आप SALARY SHEET में MANUALLY कर सकते है।इसका प्रिंट लेना है ।"]
[null,"6. Assesment  sheet","Assesment  Sheet Auto generate है।आप OLD REGIME या NEW REGIME में से किसी एक का चुनाव option बटन  करे और आपके चुनाव अनुसार Assesment form  रिपोर्ट तैयार प्राप्त करे । OLD REGIME या NEW REGIME में तुलनात्मक कौनसा चुनाव आपके लिए बेहतर की रिपोर्ट भी आप COMAPARISSION के द्वारा देख सकते है।इसका प्रिंट लेना है।"]
[null,"7. NSC INT.","आप ने यदि NSC में निवेश कर रखा है तो प्र्तिवर्ष अर्जित ब्याज की गणना के लिए इस शीट का प्रयोग कर सकते है।आप ने जिस अवधि में NSC खरीदा है उसके सबंधित कॉलम में जिस अवधि का ब्याज गणना करना चाहते है NSC की राशि लिखे ।समस्त ब्याज का योग N15 cell मे Auto generate हो जाएगी जिसकी प्रविष्टि Data Entry Sheet में D40 cell में करे।"]
[null,"Disclaimer: -","All care has been taken to keep the information upto date and correct and is for educational purpose only. You are encouraged to consult your Accountant or Advisor before taking any decesion based on this calculator"]
[]
[null,null,"                                  सुधार हेतु सुझाव  आमंत्रित  है "]
[]
[]
[]
[]
[]
[null,null,"                                         joshihansraj72@gmail.com"]
[]
[]
[null,null,"KEY FEATURES "]
[null,null,"1. SALARY SHEET AVAILABLE AS PER PD EMPLOYEE GA 55"]
[null,null,"​2.​ FOR NPS EMPLOYEE 80 CCD(1) AUTO SPLIT OPTION FOR GET BENIFIT U/S 80CDD(1B) FROM EMPLOYEE CONTRIBUTION"]
[null,null,"​3.​MORE OPTION PROVIDE FOR FIX PAY EMPLOYEE DURING FY 2021-22"]
[null,null,"5. YEARLY /PARTIALLY HRA REBATE RELETED OPTION"]
[null,null,"6. IF BASIC PAY CHANGE DURING FY 2021-22 PROVIDE OPTION FOR GENERATE SALARY SHEET (GA 55)"]
[null,null,"7.IF ASSESSEE PAY SI PREMIUM UPTO NEXT TWO SLAB THAN FILL OPTION PROVIDE IN DATA ENTRY SHEET"]
[null,null,"8 AUTO RGHS DEDUCTION AS PER DEDUCTION MONTH PROVIDED FOR NPS EMPLOYEE "]
[null,null,"9. BONUS की गत वर्ष एवं पूर्व वर्षों के आधार पर वित्त विभाग की संभावित घोषणा अनुसार गणना विकल्प सहित "]
[]
[null,"UPDATED 30-10-2021","DA @ 31% FROM JULY 2021 UPDATED"]
[null,null,"DA ARREAR FROM JULY 2021 TO SEPT 2021 CALCULTED WITH SURRENDER LEAVE(IF SURRENDER LEAVE ENCASH BETWEEN JULY TO SEPT 2021)"]

{"sheet":"Gen Info","index":1,"n_rows":13,"n_cols":21,"rows_kept":13,"merged":[[1,1,2,5],[2,17,2,20],[3,1,3,5],[3,8,7,11],[3,17,3,18],[4,3,10,3],[4,17,4,18],[5,17,5,18],[6,17,6,18],[7,17,7,18],[8,17,8,18],[9,17,9,18],[11,1,11,5],[12,1,12,5]]}
[]
[null,"INCOME TAX ASSESMENT FOR FINANCIAL YEAR 2021-22"]
[{"$nulls":17},"SI PREMIUM FROM SALARY"]
[null,"GENERAL INFORMATION",{"$nulls":15},"PAY RANGE",null,"2018-03-01","2020-03-01"]
[null,"NAME OF EMPLOYEE","HANS RAJ JOSHI",null,"EMPLOYEE ID","RJGA199412341234",{"$nulls":11},"UPTO 22000",null,500,800]
[null,"Designation","Principal",null,"OFFICE","GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR",{"$nulls":11},"22001 TO 28500",null,700,1200]
[null,"CADER","State Service",null,"PAY LEVAL","L-16",{"$nulls":11},"28501TO 46500",null,1300,2200]
[null,"Mobile No","999999999",null,"DOB","1975-01-01",{"$nulls":11},"46501 TO 72000",null,1800,3000]
[null,"PAN NO","XXXXX1234X",null,"TAX DEDUCTOR'S DESIGNATION","PRINCIPAL",{"$nulls":11},"ABOVE 72000",null,3000,5000]
[null,"क्या आपका वेतन  PD से उठता है","No",null,"TAX DEDUCTOR'S OFFICE ADDRESS","GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR",{"$nulls":11},"MAXIMUM",null,4000,7000]
[null,"आप NPS के सदस्य है तो Yes\" नहीं तो  \"No\" चुने","Yes",null,"TAN NO","JDHG01234H"]
[]
[null,"DISCLAIMER  :---यद्यपि इस आयकर आकलन प्रोग्राम तैयार करने में पूर्ण सावधानी बरती गई है फिर भी किसी भूल चूक के लिए तैयार कर्ता उत्तरदायी नहीं है अंतिम रूप आयकर विभाग के नियम लागू एवं मान्य होंगे। You are encouraged to consult your Accountant or Advisor before taking any decesion based on this calculator"]

{"sheet":"Pay & Allowances","index":2,"n_rows":26,"n_cols":27,"rows_kept":26,"merged":[[2,4,2,11],[4,2,4,4],[4,5,4,6],[4,8,4,12],[5,2,5,6],[5,9,5,10],[7,2,7,4],[7,6,7,8],[7,9,7,10],[7,11,7,13],[8,9,8,10],[10,2,10,5],[10,11,10,13],[11,4,11,5],[11,11,11,13],[12,11,12,13],[13,2,13,7],[13,11,13,12],[14,2,14,4],[14,5,14,7],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,2,19,7],[19,11,19,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[23,11,23,12],[24,11,24,12],[25,11,25,12]]}
[]
[{"$nulls":22},1]
[{"$nulls":4},"Pay & Allowancess Details",{"$nulls":17},2]
[{"$nulls":22},3]
[null,null,"        मूल  वेतन (मार्च 2021 का)  F",null,null,78000,null,null,"मूल वेतन में परिवर्तन (एसीपी या अन्य कारण ,INCREMENT के अलावा) का माह क्रमांक",{"$nulls":13},4]
[null,null,"( 7वें वेतन आयोग के अनुसार ) ",{"$nulls":5},"माह क्रमांक",null,null,"मूल वेतन",{"$nulls":10},5]
[{"$nulls":22},6]
[null,null,"HRA का भुगतान उठाया है तो \"Yes \" अन्यथा \"No\" ड्रॉपडाउन से चुने                                    ",{"$nulls":3},"SURRENDER OF PL का भुगतान उठाया है तो \"Yes\",अन्यथा \"No\" चुने व जिस माह में भुगतान लिया है का क्रमांक चुने  \n",{"$nulls":4},"बोनस मिला है  तो \"Yes\" अन्यथा  \"No\" चुने और कितने माह का मिला है चयन करें",{"$nulls":10},7]
[null,null,"Yes","HRA दर",{"v":0.09,"d":"9%"},null,"YES","माह",10,null,null,"No","माह",6,{"$nulls":8},8]
[{"$nulls":22},9]
[null,null,"CCA लागू है तो \"Yes \" अन्यथा \"No\" ड्रॉपडाउन से चुने और CITY SELECT करें ",{"$nulls":4},"धारा 10(14) के अन्तर्गत अन्य भत्ते ","मनोरंजन भत्ता धारा 16(iii) के अंतर्गत ","व्यवसाय कर धारा 16(iii) के अंतर्गत ",null,"वर्ष में आपको  FIX PAY वेतन मिला है तो \"YES\" अन्यथा \"NO\"का चयन करें ",{"$nulls":10},10]
[null,null,"No ","SELECT CITY ","KOTA",{"$nulls":6},"NO",{"$nulls":10},11]
[{"$nulls":11},"FIX PAY MONTH",{"$nulls":10},12,null,"CITY",">23100","<=23100"]
[null,null,"यदि आपको चालू वित्त वर्ष में कोई Arrear मिला है तो Arrear 1/Arrear 2 में दर्ज करें ",{"$nulls":8},"MONTHS",null,"\"YES\"/NO",{"$nulls":10},"JAIPUR(U)",1000,620]
[null,null,"Arrear 1",null,null,"Arrear 2",{"$nulls":5},"MARCH 20 ",null,"YES",{"$nulls":10},"JODHPUR",620,320]
[null,null,"Amount","TDS","NPS/GPF Ded","Amount","TDS","NPS/GPF Ded",{"$nulls":3},"APRIL 20",null,"YES",{"$nulls":10},"BIKANER",620,320]
[{"$nulls":11},"MAY 20",null,"YES",{"$nulls":10},"AJMER",620,320]
[{"$nulls":11},"JUNE 20",null,"YES",{"$nulls":10},"KOTA",620,320]
[{"$nulls":11},"JULY 20",null,"YES"]
[null,null,"यदि आपने अन्य कोई एरिअर का भुगतान उठाया है तो Salary शीट के अंतिम Unlocked पंक्ति में लिखे ",{"$nulls":8},"AUGUST 20",null,"YES"]
[{"$nulls":11},"SEPTEMBER 20",null,"NO"]
[{"$nulls":11},"OCTOBER 20",null,"NO"]
[{"$nulls":11},"NOVEMBER 20",null,"NO"]
[{"$nulls":11},"DECEMBER 20",null,"NO"]
[{"$nulls":11},"JANUARY 21",null,"NO"]
[{"$nulls":11},"FEBRUARY 21",null,"NO"]

{"sheet":"Deductions","index":3,"n_rows":36,"n_cols":19,"rows_kept":36,"merged":[[2,3,2,12],[4,1,4,19],[5,0,7,0],[5,1,5,3],[5,5,20,5],[5,18,20,19],[6,1,6,3],[6,6,6,15],[6,16,6,17],[7,1,7,3],[7,6,7,15],[7,16,7,17],[8,1,8,3],[8,6,8,15],[8,16,8,17],[9,1,9,3],[9,6,9,9],[9,11,9,12],[9,13,9,14],[9,16,9,17],[10,1,10,3],[10,6,10,15],[10,16,10,17],[11,1,11,3],[11,6,11,15],[11,16,11,17],[12,1,12,3],[12,6,12,15],[12,16,12,17],[13,1,13,3],[13,6,13,15],[13,16,13,17],[14,1,14,3],[14,6,14,8],[14,10,14,11],[14,13,14,14],[14,16,14,17],[15,1,15,3],[15,6,15,15],[15,16,15,17],[16,1,16,3],[16,6,16,15],[16,16,16,17],[17,1,17,3],[17,6,17,15],[17,16,17,17],[18,1,18,3],[18,6,18,15],[18,16,18,17],[19,1,19,3],[19,6,19,15],[19,16,19,17],[20,1,20,3],[20,6,20,15],[20,16,20,17],[21,1,21,5],[21,6,21,8],[21,9,21,11],[21,12,21,14],[22,1,22,19],[23,5,23,6],[23,14,23,15],[23,16,23,17],[23,18,23,19],[24,5,24,6],[24,14,24,15],[24,16,24,17],[24,18,24,19],[25,1,25,2],[25,7,25,9],[25,10,25,11],[27,1,27,19],[28,16,28,17],[30,2,31,4],[30,5,31,6],[30,10,31,12],[30,13,31,13],[30,14,30,15],[30,16,30,17],[31,14,31,15],[31,16,31,17],[34,2,35,4],[34,5,35,6],[34,10,35,14],[34,15,34,17],[35,15,35,17]]}
[]
[]
[{"$nulls":3},"Deductions and Investments Details"]
[]
[null,"वेतन एवं अन्य अतिरिक्त कटौतियों,अन्य आय /जमा राशि एवं छूट का विवरण "]
["OTHER INCOME","अन्य स्रोत से आय (FD पर ब्याज इत्यादि समस्त अन्य आय का योग )"]
[null," बचत खाते  की जमाराशि पर अर्जित ब्याज धारा (80TTA )  ",{"$nulls":4}," जीवन बीमा प्रीमियम -LIC (जो वेतन से काटा गया )",{"$nulls":9},{"v":469,"d":"469.00"}]
[null," वरिष्ठ नागरिकों को बचत खाते एवं स्थायी जमा खाते से प्राप्त ब्याज धारा (80TTB)  ",{"$nulls":4},"अन्य जमा राशि (धारा 80 C के अंतर्गत ) "]
[null," गृह सम्पति से आय - किराया ",null,null,{"v":0,"d":"0.00"},null,"धारा 80 CCC के अंतर्गत-पेंशन प्लान हेतु अंशदान (एनपीएस के अलावा ) "]
[null," गृह कर  ",null,null,{"v":0,"d":"0.00"},null,"धारा 80 CCD(1B) के अंतर्गत-NPS मे अतिरिक्त अंशदान  ",{"$nulls":3},{"v":50000,"d":"50000.00"},"SPLIT FROM 80CCD(1)",null,{"$f":"IFERROR(IF(N31=\"YES\",Q31,0),0)","v":{"v":0,"d":"0.00"}},null,"योग",{"$f":"IF(SUM(K10+N10)>50000,50000,SUM(K10+N10))","v":{"v":50000,"d":"50000.00"}}]
[null," गृह ऋण मूल (जो वेतन से नहीं काटा गया )",null,null,{"v":30000,"d":"30000.00"},null,"धारा 80D -चिकित्सा बीमा प्रीमियम (सामान्य 25000,वरिष्ठ नागरिक 50000) "]
[null," गृह ऋण ब्याज  (जो वेतन से नहीं काटा गया )",null,null,{"v":29000,"d":"29000.00"},null,"धारा 80DD -विकलांग आश्रितों के चिकित्सा उपचार  (सामान्य 75000,80% से अधिक विकलांगता पर 125000) "]
[null," जीवन बीमा प्रीमियम -LIC (जो वेतन से नहीं काटा गया )",{"$nulls":4},"धारा 80DDB -विशिष्ट रोगों के  उपचार हेतु   (अधिकतम 40000,वरिष्ठ नागरिक 100000) "]
[null," पी.एल.आई . (PLI )",null,null,{"v":14000,"d":"14000.00"},null," धारा 80E - उच्च शिक्षा हेतु ऋण का  ब्याज "]
[null,"ट्यूशन फीस  (Tution Fees)",{"$nulls":4},"धारा 80G -धर्मार्थ संस्थाओं को दिये दान",null,null,"श्रेणी  100%",null,null,"श्रेणी - 50%",null,null,"योग",{"$f":"ROUND(N15*50%,0)+K15","v":{"v":0,"d":"0.00"}}]
[null,"ULIP/वार्षिक प्लान ",{"$nulls":4},"धारा 80 U -स्थायी शारीरिक विकलांगता (साधारण 75000, 80% से अधिक के मामले में 125000)"]
[null,"राष्ट्रीय बचत पत्र  (NSC)",{"$nulls":4},"धारा 80 GGA -अनुमोदित वैज्ञानिक ,सामाजिक ग्रामीण विकास हेतु दिया गया दान "]
[null,"राष्ट्रीय बचत पत्र  (NSC) से प्राप्त ब्याज ",{"$nulls":4},"इक्विटी लिंक सविंग स्कीम में निवेश "]
[null,"लोक भविष्य निधि (PPF) में निवेश ",{"$nulls":4},"स्थगित वार्षिकी "]
[null,"राष्ट्रीय बचत स्कीम  (NSS) में निवेश ",{"$nulls":4},"धारा 89 के तहत राहत "]
[null,"सुकन्या समृद्धि योजना  में जमा  ",{"$nulls":4},"वेतन बिल के अलावा जमा कराया गया TDS"]
[]
[null," वेतन से माहवार आयकर कटौती विवरण "]
[null,"MONTH NAME","MARCH","APRIL","MAY","JUNE",null,"JULY","AUGUST","SEPT","OCT","NOV","DEC","JAN","FEB",null,"टी .डी.एस.एरियर आदि से",null,"TOTAL"]
[null,"TDS",3000,3000,4000,4000,null,12000,12000,12000,12000,18500,18500,18500,19000,null,{"$f":"SUM(Salary!$X$22:$X$29)","v":0},null,{"$f":"SUM(C25:R25)","v":136500}]
[null,"PER MONTH TDS REQUIRED",null,{"$f":"ROUNDUP(Assesment!Q65/12,-1)","v":11360},{"$nulls":3},{"$f":"Assesment!B68","v":"Income Tax Refundable"},null,null,{"$f":"Assesment!Q68","v":{"v":234,"d":"234.00"}}]
[]
[null," वेतन से माहवार राज्य बीमा कटौती आगे में की दो स्लैब तक अंशदान ,80CCD(1B) SPLIT,RGHS, BONUS का विवरण "]
[null," "]
[{"$nulls":16},{"$f":"IF(N30=\"YES\",Master!T31,0)","v":0}]
[null,null,"यदि आप राज्य बीमा की अंशदान दो स्लैब आगे तक करते है तो \"YES\" का चयन करे और प्रीमियम  भरे अन्यथा \"NO\" चुने प्रीमियम को खाली छोड़े",null,null,"YES",null,"अंशदान",null,null,"यदि आप NPS की अंशदान 80CCD(1) को SPLIT कर 80CCD 1(B) का लाभ लेना चाहते है तो \"YES\" का चयन करे  अन्यथा \"NO\" ",null,null,"NO","80CCD(1B)  SPLIT FROM 80CCD1",null,{"$f":"IF(N31=\"YES\",Master!T31,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":7},7000,{"$nulls":6},"संशोधित 80CCD(1)",null,{"$f":"IF($N$31=\"YES\",Master!$T$30,0)","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,null,"यदि आप NPS कार्मिक है और RGHS योजना का चयन  करते है तो \"YES\" का अन्यथा \"NO\" चयन करे और किस माह से कटौति हुई का माह क्रमांक  भरे ",null,null,"YES",null,"माह",null,null,"यदि आपको बोनस देय है तो वित्त विभाग के संभावित 100% नकद या 25% नकद मे से जो देय हो का चयन ड्रॉपडाउन से करे ",{"$nulls":4},"नकद देय"]
[{"$nulls":7},8,{"$nulls":7},{"v":1,"d":"100%"}]

{"sheet":"HRA","index":4,"n_rows":23,"n_cols":13,"rows_kept":23,"merged":[[2,5,2,11],[4,1,4,2],[4,5,4,6],[6,7,6,11],[7,1,7,2],[8,11,9,12],[10,6,10,11],[11,9,11,10],[12,6,12,10],[13,7,13,10],[14,7,14,10],[15,7,15,10],[16,7,16,10],[17,6,17,10],[22,1,23,7]]}
[]
[]
[{"$nulls":5},"HRA EXEMPTION CALCULATOR"]
[]
[null,"\n मकान किराये का वास्तविक भुगतान  ( FOR HRA EXEMPTION )",{"$nulls":5},"HRA exemption ","Partially",{"$f":"IF(HRA!I5=\"Yearly\",Master!E27,Master!H27)","v":0},null,"Rent receipt required for max. HRA exemption",{"$f":"IF(HRA!I5=\"Yearly\",Master!E26,Master!H26)","v":202712}]
[]
[{"$nulls":7},"IF YOU ARE NOT ELIGIBLE TO GET HRA EXEMPTION FOR COMPLETE YEAR THEN CHOOSE PARTIALLY"]
[null,"PARTIALY HRA"]
[null,"MONTHS","\"YES\"/NO","PAY+DA","HRA",{"$nulls":3},"CITY TYPE","NON METRO",null," "]
[null,"MARCH 21 ","YES",{"$f":"IF(C10=\"YES\",SUM(Salary!D10:E10,Salary!D28:E28),0)","v":91260},{"$f":"IF(C10=\"YES\",SUM(Salary!F10,Salary!F28),0)","v":6240},null,null,"Choose Metro for Delhi,Mumbai,Chennai,Kolkata and for others Non Metro"]
[null,"APRIL 21","YES",{"$f":"IF(C11=\"YES\",SUM(Salary!D11:E11),0)","v":91260},{"$f":"IF(C11=\"YES\",Salary!F11,0)","v":6240},null,"HRA exempted from income tax ",{"$nulls":5},{"$f":"HRA!I5","v":"Partially"}]
[null,"MAY 21","YES",{"$f":"IF(C12=\"YES\",SUM(Salary!D12:E12),0)","v":91260},{"$f":"IF(C12=\"YES\",Salary!F12,0)","v":6240},{"$nulls":4},"वेतन (PAY+DA)",null,{"$f":"IF($M$11=\"Yearly\",Master!E20,\"-\")","v":"-"},{"$f":"IF($M$11=\"Partially\",Master!H20,\"-\")","v":1199357}]
[null,"JUNE 21","YES",{"$f":"IF(C13=\"YES\",SUM(Salary!D13:E13),0)","v":91260},{"$f":"IF(C13=\"YES\",Salary!F13,0)","v":6240},null,"Details",{"$nulls":4},{"$f":"IF(M11=\"Yearly\",\"Complete year HRA exemption\",\"-\")","v":"-"},{"$f":"IF(M11=\"Partially\",\"Partial HRA exemption\",\"-\")","v":"Partial HRA exemption"}]
[null,"JULY 21","YES",{"$f":"IF(C14=\"YES\",SUM(Salary!D14:E14),0)","v":102784},{"$f":"IF(C14=\"YES\",Salary!F14,0)","v":7227},null,null,"मकान किराया का वास्तविक भुगतान ",{"$nulls":3},{"$f":"IF(M11=\"Yearly\",HRA!F5,\"-\")","v":"-"},{"$f":"IF(M11=\"Partially\",HRA!F5,\"-\")","v":0}]
[null,"AUGUST 21","YES",{"$f":"IF(C15=\"YES\",SUM(Salary!D15:E15),0)","v":102784},{"$f":"IF(C15=\"YES\",Salary!F15,0)","v":7227},null,"A","प्राप्त मकान किराया भत्ता (HRA)",{"$nulls":3},{"$f":"IF(M11=\"Yearly\",Master!E21,\"-\")","v":"-"},{"$f":"IF(M11=\"Partially\",E22,\"-\")","v":82776}]
[null,"SEPTEMBER 21","YES",{"$f":"IF(C16=\"YES\",SUM(Salary!D16:E16),0)","v":102784},{"$f":"IF(C16=\"YES\",Salary!F16,0)","v":7227},null,"B","वेतन (मूल +मंहगाई भत्ता ) के 10% से अधिक मकान किराया  भुगतान की राशि ",{"$nulls":3},{"$f":"IF(M11=\"Yearly\",IF(Master!$E$24>0,Master!$E$24,0),\"-\")","v":"-"},{"$f":"IF(M11=\"Partially\",IF(Master!$H$24>0,Master!$H$24,0),\"-\")","v":0}]
[null,"OCTOBER 21","YES",{"$f":"IF(C17=\"YES\",SUM(Salary!D17:E17),0)","v":105193},{"$f":"IF(C17=\"YES\",Salary!F17,0)","v":7227},null,"C",{"$f":"IF(J9=\"NON METRO\",\"वेतन (मूल +मंहगाई भत्ता ) का  40%\",\"वेतन (मूल +मंहगाई भत्ता ) का  50%\")","v":"वेतन (मूल +मंहगाई भत्ता ) का  40%"},{"$nulls":3},{"$f":"IF(M11=\"Yearly\",IF(Master!$E$25>0,Master!$E$25,0),\"-\")","v":"-"},{"$f":"IF(M11=\"Partially\",IF(Master!$E$25>0,Master!$E$25,0),\"-\")","v":479743}]
[null,"NOVEMBER 21","YES",{"$f":"IF(C18=\"YES\",SUM(Salary!D18:E18),0)","v":105193},{"$f":"IF(C18=\"YES\",Salary!F18,0)","v":7227},null,"HRA exemption amount from Income Tax(Minimum amongA,B,C)",{"$nulls":4},{"$f":"IF(M11=\"Yearly\",Master!$E$27,\"-\")","v":"-"},{"$f":"MIN(M15,M16,M19)","v":0}]
[null,"DECEMBER 21","YES",{"$f":"IF(C19=\"YES\",SUM(Salary!D19:E19),0)","v":105193},{"$f":"IF(C19=\"YES\",Salary!F19,0)","v":7227}]
[null,"JANUARY 22","YES",{"$f":"IF(C20=\"YES\",SUM(Salary!D20:E20),0)","v":105193},{"$f":"IF(C20=\"YES\",Salary!F20,0)","v":7227}]
[null,"FEBRUARY 22","YES",{"$f":"IF(C21=\"YES\",SUM(Salary!D21:E21),0)","v":105193},{"$f":"IF(C21=\"YES\",Salary!F21,0)","v":7227}]
[{"$nulls":3},{"$f":"SUM(D10:D21)","v":1199357},{"$f":"SUM(E10:E21)","v":82776}]
[null,"IF YOU ARE NOT ELIGIBLE TO GET HRA EXEMPTION FOR COMPLETE YEAR THEN CHOOSE PARTIALLY HRA \"YES\" FROM DROPDOWN"]

{"sheet":"Salary","index":5,"n_rows":34,"n_cols":44,"rows_kept":34,"merged":[[0,4,0,11],[0,14,0,30],[1,1,1,30],[2,1,2,30],[3,1,3,30],[4,1,4,4],[4,5,4,10],[4,11,4,13],[4,14,4,17],[4,18,4,19],[4,20,4,23],[4,24,4,27],[4,28,4,29],[5,3,5,6],[5,8,5,10],[5,11,5,12],[5,14,5,17],[5,18,5,19],[5,20,5,23],[5,24,5,25],[5,26,5,27],[6,1,6,11],[6,12,6,30],[9,36,9,39],[10,36,10,37],[11,36,11,37],[12,36,12,37],[13,36,13,37],[14,36,14,37],[15,36,15,37],[16,36,16,37],[17,36,17,37],[29,1,29,2],[30,7,30,10],[31,22,31,28]]}
[{"$nulls":14},"आप अपनी आवश्यकता अनुसार सैलरी शीट की UNLOCKED CELL मे बदलाव कर सकते है तथा REFRESH SALARY बटन पर क्लिक कर पुनः प्रारम्भिक स्थिति मे आ सकते है। ",{"$nulls":25},"cader"]
[{"$nulls":40},"State Service",null,null,"ALLOWANCES"]
[null,{"$f":"Master!AI3","v":"OFFICE OF THE PRINCIPAL GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR"},{"$nulls":38},"Subordinate",null,null,"CCA"]
[null,{"$f":"Master!AI4","v":" SALARY STATEMENT FOR FINANCIAL YEAR 2021-22"},{"$nulls":38},"Ministrial",null,null,"WASHING ALLOWANCE"]
[null,"Name of the Employee",{"$nulls":3},{"$f":"IF('Gen Info'!C5=\"\",\"\",'Gen Info'!C5)","v":"HANS RAJ JOSHI"},{"$nulls":5},"Designation",null,null,{"$f":"IF('Gen Info'!$C$6=\"\",\"\",'Gen Info'!$C$6)","v":"Principal"},{"$nulls":3},"OFFICE",null,{"$f":"IF('Gen Info'!F6=\"\",\"\",'Gen Info'!F6)","v":"GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR"},{"$nulls":3},"Date of Birth",{"$nulls":3},{"$f":"IF('Gen Info'!F8=\"\",\"\",'Gen Info'!F8)","v":"1975-01-01"},{"$nulls":11},"Class IV",null,null,"HANDICAPTED ALLWANCE"]
[null,"Employee ID",null,{"$f":"IF('Gen Info'!F5=\"\",\"\",'Gen Info'!F5)","v":"RJGA199412341234"},{"$nulls":3},"Cader",{"$f":"IF('Gen Info'!C7=\"\",\"\",'Gen Info'!C7)","v":"State Service"},null,null,"Employee Type",null,{"$f":"IF('Gen Info'!C11=\"\",\"\",IF('Gen Info'!C11=\"Yes\",\"NPS\",\"OPS\"))","v":"NPS"},{"$f":"IF('Gen Info'!C10=\"YES\",\"Salary From PD Head\",\"\")","v":""},{"$nulls":3},"PAN ",null,{"$f":"IF('Gen Info'!C9=\"\",\"\",'Gen Info'!C9)","v":"XXXXX1234X"},{"$nulls":3},"Pay leval",null,{"$f":"IF('Gen Info'!F7=\"\",\"\",'Gen Info'!F7)","v":"L-16"},null,"Pay March",{"$f":"Master!$AH$10","v":78000},{"$nulls":13},"ANY OTHER"]
[null,"PAY & ALLOWANCES",{"$nulls":10},"DEDUCTIONS"]
[null,"SN","MONTH","BASIC","DA","HRA","CCA","Bonus","ANY OTHER","ARREAR","Govt.NPS","Gross Salary",{"$f":"IF('Gen Info'!C11=\"YES\",\"NPS\",\"GPF\")","v":"NPS"},"GPF 2004","SIP","SI LOAN","GPF LOAN","HBA","HBA INT","LIC","RGHS","GIS","CM CORONA RELIEF","INCOME TAX","ANY OTHER","Govt.NPS","HITKARI NIDHI","Total Deduction","Net paid Amount","BILL NO","TV NO"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,{"$f":"Master!BA9","v":0},20,21,22,23,24,null,null,25,26,27,28]
[null,1,"2021-03-01",{"$f":"Master!AK10","v":78000},{"$f":"Master!D7","v":13260},{"$f":"Master!E7","v":6240},{"$f":"Master!$H$5","v":0},{"$nulls":3},{"$f":"Master!U7","v":0},{"$f":"ROUND((D10+E10+F10+G10+H10+I10+J10+K10),0)","v":97500},{"$f":"Master!S7","v":9126},null,{"$f":"Master!T7","v":7000},{"$nulls":4},{"$f":"Master!T3","v":469},{"$f":"Master!P7","v":0},null,{"$f":"Master!W21","v":0},{"$f":"Master!K7","v":3000},null,{"$f":"IF(K10=\"\",0,K10)","v":0},null,{"$f":"M10+N10+O10+P10+Q10+R10+S10+T10+U10+V10+W10+X10+Y10+Z10","v":19595},{"$f":"L10-AB10","v":77905},{"$nulls":7},"SI PREMIUM FROM SALARY"]
[null,2,"2021-04-01",{"$f":"Master!AH11","v":78000},{"$f":"Master!D8","v":13260},{"$f":"Master!E8","v":6240},{"$f":"Master!G8","v":0},{"$nulls":3},{"$f":"Master!U8","v":0},{"$f":"ROUND((D11+E11+F11+G11+H11+I11+J11+K11),0)","v":97500},{"$f":"Master!S8","v":9126},null,{"$f":"Master!T8","v":7000},{"$nulls":4},{"$f":"T10","v":469},{"$f":"Master!P8","v":0},220,null,{"$f":"Master!K8","v":3000},{"$f":"Y10","v":0},{"$f":"IF(K11=\"\",0,K11)","v":0},null,{"$f":"M11+N11+O11+P11+Q11+R11+S11+T11+U11+V11+W11+X11+Y11+Z11","v":19815},{"$f":"L11-AB11","v":77685},{"$nulls":7},"PAY RANGE",null,"2018-03-01","2020-03-01"]
[null,3,"2021-05-01",{"$f":"Master!AH12","v":78000},{"$f":"Master!D9","v":13260},{"$f":"Master!E9","v":6240},{"$f":"Master!G9","v":0},{"$nulls":3},{"$f":"Master!U9","v":0},97500,{"$f":"Master!S9","v":9126},null,{"$f":"Master!T9","v":7000},{"$nulls":4},469,{"$f":"Master!P9","v":0},null,null,{"$f":"Master!K9","v":4000},0,0,null,20595,76905,{"$nulls":7},"UPTO 22000",null,500,800]
[null,4,"2021-06-01",{"$f":"Master!AH13","v":78000},{"$f":"Master!D10","v":13260},{"$f":"Master!E10","v":6240},{"$f":"Master!G10","v":0},{"$nulls":3},{"$f":"Master!U10","v":0},97500,{"$f":"Master!S10","v":9126},null,{"$f":"Master!T10","v":7000},{"$nulls":4},469,{"$f":"Master!P10","v":0},null,null,{"$f":"Master!K10","v":4000},0,0,null,20595,76905,{"$nulls":7},"22001 TO 28500",null,700,1200]
[null,5,"2021-07-01",{"$f":"Master!AH14","v":80300},{"$f":"Master!D11","v":22484},{"$f":"Master!E11","v":7227},{"$f":"Master!G11","v":0},{"$nulls":3},{"$f":"Master!U11","v":0},110011,{"$f":"Master!S11","v":10278},null,{"$f":"Master!T11","v":7000},{"$nulls":4},469,{"$f":"Master!P11","v":0},null,null,{"$f":"Master!K11","v":12000},0,0,null,29747,80264,{"$nulls":7},"28501TO 46500",null,1300,2200]
[null,6,"2021-08-01",{"$f":"Master!AH15","v":80300},{"$f":"Master!D12","v":22484},{"$f":"Master!E12","v":7227},{"$f":"Master!G12","v":0},{"$nulls":3},{"$f":"Master!U12","v":0},110011,{"$f":"Master!S12","v":10278},null,{"$f":"Master!T12","v":7000},{"$nulls":4},469,{"$f":"Master!P12","v":440},null,null,{"$f":"Master!K12","v":12000},0,0,null,30187,79824,{"$nulls":7},"46501 TO 72000",null,1800,3000]
[null,7,"2021-09-01",{"$f":"Master!AH16","v":80300},{"$f":"Master!D13","v":22484},{"$f":"Master!E13","v":7227},{"$f":"Master!G13","v":0},{"$nulls":3},{"$f":"Master!U13","v":0},110011,{"$f":"Master!S13","v":10278},null,{"$f":"Master!T13","v":7000},{"$nulls":4},469,{"$f":"Master!P13","v":440},null,{"$f":"Master!W22","v":0},{"$f":"Master!K13","v":12000},0,0,null,30187,79824,{"$nulls":7},"ABOVE 72000",null,3000,5000]
[null,8,"2021-10-01",{"$f":"Master!AH17","v":80300},{"$f":"Master!D14","v":24893},{"$f":"Master!E14","v":7227},{"$f":"Master!G14","v":0},{"$nulls":3},{"$f":"Master!U14","v":0},112420,{"$f":"Master!S14","v":10519},null,{"$f":"Master!T14","v":7000},{"$nulls":4},469,{"$f":"Master!P14","v":440},null,{"$f":"Master!W23","v":0},{"$f":"Master!K14","v":12000},0,0,null,{"$f":"M17+N17+O17+P17+Q17+R17+S17+T17+U17+V17+W17+X17+Y17+Z17+AA17","v":30428},81992,{"$nulls":7},"MAXIMUM",null,4000,7000]
[null,9,"2021-11-01",{"$f":"Master!AH18","v":80300},{"$f":"Master!D15","v":24893},{"$f":"Master!E15","v":7227},{"$f":"Master!G15","v":0},{"$nulls":3},{"$f":"Master!U15","v":0},112420,{"$f":"Master!S15","v":10519},null,{"$f":"Master!T15","v":7000},{"$nulls":4},469,{"$f":"Master!P15","v":440},null,{"$f":"Master!W24","v":0},{"$f":"Master!K15","v":18500},0,0,null,{"$f":"M18+N18+O18+P18+Q18+R18+S18+T18+U18+V18+W18+X18+Y18+Z18+AA18","v":36928},75492,{"$nulls":7},"NO DEDUCTION",null,0,0]
[null,10,"2021-12-01",{"$f":"Master!AH19","v":80300},{"$f":"Master!D16","v":24893},{"$f":"Master!E16","v":7227},{"$f":"Master!G16","v":0},{"$nulls":3},{"$f":"Master!U16","v":0},112420,{"$f":"Master!S16","v":10519},null,{"$f":"Master!T16","v":7000},{"$nulls":4},469,{"$f":"Master!P16","v":440},null,{"$f":"Master!W25","v":0},{"$f":"Master!K16","v":18500},0,0,{"$f":"Master!T2","v":500},37428,74992]
[null,11,"2022-01-01",{"$f":"Master!AH20","v":80300},{"$f":"Master!D17","v":24893},{"$f":"Master!E17","v":7227},{"$f":"Master!G17","v":0},{"$nulls":3},{"$f":"Master!U17","v":0},112420,{"$f":"Master!S17","v":10519},null,{"$f":"Master!T17","v":7000},{"$nulls":4},469,{"$f":"Master!P17","v":440},null,{"$f":"Master!W26","v":0},{"$f":"Master!K17","v":18500},0,0,null,36928,75492]
[null,12,"2022-02-01",{"$f":"Master!AH21","v":80300},{"$f":"Master!D18","v":24893},{"$f":"Master!E18","v":7227},{"$f":"Master!G18","v":0},{"$nulls":3},{"$f":"Master!U18","v":0},112420,{"$f":"Master!S18","v":10519},null,{"$f":"Master!T18","v":7000},{"$nulls":4},{"$f":"T20","v":469},{"$f":"Master!P18","v":440},null,{"$f":"Master!W27","v":0},{"$f":"Master!K18","v":19000},0,0,null,37428,74992]
[null,13,"SURRENDER",{"$f":"Master!M6","v":40150},{"$f":"Master!N6","v":11242},{"$nulls":6},51392,{"$nulls":13},0,null,0,51392]
[null,14,"D.A.ARREAR with Surr.Arr 7/21 TO 9/21 ",null,{"$f":"Master!K36","v":7227},{"$nulls":5},{"$f":"Master!N36","v":0},7227,{"$f":"Master!L36","v":723},{"$f":"Master!O36","v":6504},{"$nulls":11},0,null,7227,0]
[null,15,"OTHER",null,{"$f":"Master!K39","v":0},{"$nulls":5},{"$f":"Master!N39","v":0},0,{"$f":"Master!L39","v":0},{"$nulls":12},0,null,0,0]
[null,16,"BONUS",{"$nulls":4},{"$f":"Master!L3","v":0},{"$nulls":3},0,{"$f":"IF(N6=\"OPS\",Master!M3,0)","v":0},{"$f":"IF(N6=\"NPS\",Master!M3,0)","v":0},{"$nulls":11},0,null,0,0]
[null,17,"ARREAR 1",{"$nulls":6},{"$f":"Master!J21","v":0},{"$f":"Master!L23","v":0},{"$f":"ROUND((D26+E26+F26+G26+H26+I26+J26+K26),0)","v":0},{"$f":"Master!L21","v":0},{"$nulls":10},{"$f":"Master!K21","v":0},null,0,null,0,0]
[null,18,"ARREAR 2",{"$nulls":6},{"$f":"Master!M21","v":0},{"$f":"Master!O23","v":0},0,{"$f":"Master!O21","v":0},{"$nulls":10},{"$f":"Master!N21","v":0},null,0,null,0,0]
[null,19,null,{"$f":"Master!AK15","v":0},{"$f":"Master!D19","v":0},{"$f":"Master!E19","v":0},{"$f":"Master!G19","v":0},{"$nulls":3},{"$f":"Master!U19","v":0},0,{"$f":"Master!S19","v":0},{"$nulls":12},0,null,0,0]
[null,19,"OTHER",{"$nulls":8},0,{"$nulls":15},0,0]
[null,"TOTAL",null,{"$f":"SUM(D10:D29)","v":994550},{"$f":"SUM(E10:E29)","v":263426},{"$f":"SUM(F10:F29)","v":82776},{"$f":"SUM(G10:G29)","v":0},{"$f":"SUM(H10:H29)","v":0},{"$f":"I10+I11+I12+I13+I14+I15+I16+I17+I18+I19+I20+I21+I22+I23+I24+I25+I26+I27+I28+I29","v":0},{"$f":"J10+J11+J12+J13+J14+J15+J16+J17+J18+J19+J20+J21+J22+J23+J24+J25+J26+J27+J28+J29","v":0},0,1340752,120656,6504,84000,0,0,0,0,5628,3080,220,0,136500,0,0,500,357088,983664]
[]
[{"$nulls":22},{"$f":"'Gen Info'!F9","v":"PRINCIPAL"}]
[{"$nulls":4},"हस्ताक्षर कार्मिक",{"$nulls":17},{"$f":"'Gen Info'!F10","v":"GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR"}]
[{"$nulls":29},"Programmed by Hans Raj Joshi"]

{"sheet":"Assesment","index":6,"n_rows":70,"n_cols":23,"rows_kept":70,"merged":[[0,0,0,17],[1,1,1,15],[1,16,2,16],[1,19,2,20],[2,1,2,14],[3,2,3,3],[3,4,3,9],[3,11,3,13],[3,15,3,16],[4,2,4,14],[4,19,5,21],[5,2,5,14],[6,2,6,14],[6,19,7,20],[6,21,7,21],[7,1,9,1],[7,2,7,11],[7,12,7,14],[7,15,8,16],[8,2,8,11],[8,12,8,14],[9,2,9,11],[9,12,9,14],[10,2,10,14],[10,19,11,19],[11,1,13,1],[11,2,11,9],[11,10,11,11],[11,12,11,14],[11,15,13,16],[12,2,13,3],[12,4,12,6],[12,7,12,9],[12,10,12,11],[12,12,12,14],[12,19,13,19],[12,20,13,21],[13,4,13,6],[13,7,13,9],[13,10,13,11],[13,12,13,14],[14,2,14,14],[14,19,15,21],[15,2,15,14],[16,2,16,14],[17,2,17,14],[18,2,18,14],[19,1,34,1],[19,2,19,14],[19,15,19,16],[20,2,20,16],[21,3,21,6],[21,10,21,12],[21,15,30,16],[22,3,22,6],[22,10,22,12],[23,3,23,6],[23,10,23,12],[24,3,24,6],[24,10,24,12],[25,3,25,6],[25,10,25,12],[25,20,27,20],[26,3,26,6],[26,10,26,12],[27,3,27,6],[27,10,27,12],[28,3,28,6],[28,10,28,12],[29,3,29,6],[29,10,29,12],[30,2,30,12],[31,2,31,14],[32,2,32,14],[33,2,33,14],[34,2,34,14],[35,2,35,16],[36,1,45,1],[36,3,36,14],[37,3,37,14],[38,3,38,14],[39,3,39,14],[40,3,40,14],[41,3,41,14],[42,3,42,14],[43,3,43,14],[44,3,44,14],[45,2,45,14],[46,2,46,14],[47,2,47,14],[48,2,48,14],[49,1,62,1],[49,2,49,14],[50,2,50,11],[50,12,50,14],[51,2,51,4],[51,5,51,8],[51,9,51,11],[51,12,51,13],[52,2,52,3],[52,5,52,7],[52,9,52,11],[52,12,52,13],[53,2,53,3],[53,5,53,7],[53,9,53,10],[53,12,53,13],[54,2,54,3],[54,5,54,7],[54,9,54,10],[54,12,54,13],[55,2,55,3],[55,5,55,7],[55,9,55,10],[55,12,55,13],[56,2,57,11],[56,12,56,13],[57,12,57,13],[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,1,66,1],[65,2,66,4],[65,5,65,8],[65,9,65,10],[65,12,65,13],[65,15,65,16],[66,5,66,8],[66,9,66,10],[66,12,66,13],[66,15,66,16],[67,1,67,14],[68,2,68,5],[68,6,68,16]]}
[]
[null,{"$f":"Salary!B3","v":"OFFICE OF THE PRINCIPAL GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR"},{"$nulls":14},{"$f":"IF($W$2=1,\"OLD REGIME\",\"NEW REGIME\")","v":"OLD REGIME"},{"$nulls":5},1]
[null,"आयकर गणना  प्रपत्र वर्ष 2021-22 (कर निर्धारण वर्ष 2022-23)",{"$nulls":13},{"$f":"P51","v":"1"}]
[null,1,"नाम कार्मिक ",null,{"$f":"'Gen Info'!C5","v":"HANS RAJ JOSHI"},{"$nulls":5},"पद",{"$f":"'Gen Info'!C6","v":"Principal"},null,null,"PAN :",{"$f":"'Gen Info'!C9","v":"XXXXX1234X"}]
[null,2,"आय : वर्ष 2021-22 में प्राप्त कुल वेतन (कर योग्य सुविधाओं के मूल्य सहित )",{"$nulls":12},"रु.",{"$f":"IF('Gen Info'!$C$11=\"NO\",SUM(Salary!$L$30,Master!$U$4),IF(AND('Gen Info'!$C$11=\"YES\",'Gen Info'!$C$10=\"YES\"),SUM(Salary!$L$30,Master!$U$4),SUM(Salary!$L$30,Salary!$M$30,Master!$U$4)))","v":{"v":1461408,"d":"1461408.00"}},null,null,"COMPARISION"]
[null,3,"गृह किराया, धारा 10(13-।) के अन्तर्गत एवं धारा 10(14)के अन्तगर्त अन्य भते जो कर मुक्त्त है",{"$nulls":12},"रु.",{"$f":"IF($P$3=\"1\",-SUM(HRA!$J$5,'Pay & Allowances'!$H$12),0)","v":{"v":0,"d":"0.00"}}]
[null,4,"                                                              शेष (2-3)",{"$nulls":12},"रु.",{"$f":"$Q$5+$Q$6","v":{"v":1461408,"d":"1461408.00"}},null,null,"OLD REGIME",null,"NEW REGIME"]
[null,5," (i)मनोरंजन भता धारा 16 (ii) के अन्तगर्त ( अधिकतम सीमा रू 5000 )",{"$nulls":9},{"$f":"IF($P$3=\"1\",IF('Pay & Allowances'!$I$12>5000,5000,'Pay & Allowances'!$I$12),0)","v":{"v":0,"d":"0.00"}}]
[null,null," (ii) व्यवयाय कर धारा 16 (iii) के अन्तगर्त",{"$nulls":9},{"$f":"IF($P$3=\"1\",'Pay & Allowances'!J12,0)","v":{"v":0,"d":"0.00"}},{"$nulls":6},"TAX",{"$f":"Master!R97","v":{"v":131025,"d":"131025.00"}},{"$f":"Master!S97","v":{"v":147688,"d":"147688.00"}}]
[null,null," (iii) स्टेण्डर्ड डिडेक्शन(Standard Deduction)  50,000 (अधिकतम)",{"$nulls":9},{"$f":"IF($P$3=\"1\",MIN($Q$7,50000),0)","v":{"v":50000,"d":"50000.00"}},null,null,"रु.",{"$f":"-SUM(M8:O10)","v":{"v":-50000,"d":"-50000.00"}},null,null,"CESS 4%",{"$f":"ROUND(U9*4%,0)","v":{"v":5241,"d":"5241.00"}},{"$f":"ROUND(V9*4%,0)","v":{"v":5908,"d":"5908.00"}}]
[null,6,"                                                          शेष (4-5)",{"$nulls":12},"रु.",{"$f":"Q7+Q10","v":{"v":1411408,"d":"1411408.00"}},null,null,"TOTAL",{"$f":"SUM(U9:U10)","v":{"v":136266,"d":"136266.00"}},{"$f":"SUM(V9:V10)","v":{"v":153596,"d":"153596.00"}}]
[null,7,"(अ)गृह सम्पति से आय : (1) स्वंय के उपयोग में    -शून्य",{"$nulls":7},"(2) प्राप्त किराया रु.",null,{"$f":"Deductions!E9","v":{"v":0,"d":"0.00"}}]
[null,null,"(ब) घटायें ",null,"  किराये का 30%",null,null," गृह ऋण पर ब्याज ",null,null," गृहकर  ",null,"  योग 7(ब) ",{"$nulls":6},"DIFFERENCE",{"$f":"U11-V11","v":{"v":-17330,"d":"-17330.00"}}]
[{"$nulls":4},{"$f":"IF(OR($P$3=\"1\",$P$3=\"2\"),ROUND((M12-K14)*0.3,0),0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF($P$3=\"1\",IF((Salary!$S$30+Deductions!E12)>200000,200000,(Salary!$S$30+Deductions!E12)),0)","v":{"v":29000,"d":"29000.00"}},null,null,{"$f":"IF(OR($P$3=\"1\",$P$3=\"2\"),Deductions!E10,0)","v":{"v":0,"d":"0.00"}},null,{"$f":"E14+H14+K14","v":{"v":29000,"d":"29000.00"}}]
[null,null,"                                                         शेष -/+ (7(अ) एवं योग 7(ब) का)       ",{"$nulls":12},"रु.",{"$f":"M12-M14","v":{"v":-29000,"d":"-29000.00"}},null,null,{"$f":"IF(U11<V11,\"OLD REGIME IS BEST OPTION FOR YOU\",\"NEW REGIME IS BEST FOR YOU\")","v":"OLD REGIME IS BEST OPTION FOR YOU"}]
[null,8,"                                                              कुल शेष -/+ (6एवं 7)       ",{"$nulls":12},"रु.",{"$f":"Q11+Q15","v":{"v":1382408,"d":"1382408.00"}}]
[null,9,"बचत खाते पर ब्याज ",{"$nulls":12},"रु.",{"$f":"Deductions!E7+Deductions!E8","v":{"v":0,"d":"0.00"}}]
[null,10,"अन्य आय ",{"$nulls":12},"रु.",{"$f":"Deductions!E6","v":{"v":0,"d":"0.00"}},{"$nulls":4},1]
[null,11,"सकल आय                                                            योग (8+9+10)",{"$nulls":12},"रु.",{"$f":"Q16+Q17+Q18","v":{"v":1382408,"d":"1382408.00"}}]
[null,12,"घटाइये कटौतियाँ:- धारा  US 80C, 80CCC,80CCD (1)"]
[null,null,"(A) अधिकतम सीमा 1,50,000/- (धारा  80CCE ] (धारा 80CCD (2)) के अलावा "]
[null,null,"(i)","राज्य बीमा  (SI)",{"$nulls":3},"रु.",{"$f":"IF($P$3=\"1\",Salary!$O$30,0)","v":{"v":84000,"d":"84000.00"}},"(x)","सरकारी पेंशन योजना में अंशदान  ECPF\nअधिकतम वेतन का 10% {धारा 80CCD(1) }",null,null,"रु.",{"$f":"IF('Gen Info'!$C$11=\"NO\",0,IF($P$3=\"2\",0,IF(Deductions!N31=\"YES\",Deductions!Q32,Salary!$M$30)))","v":{"v":120656,"d":"120656.00"}}]
[null,null,"(ii)","जीवन बीमा प्रीमियम(LIC)",{"$nulls":3},"रु.",{"$f":"IF($P$3=\"1\",Salary!$T$30+Deductions!E13,0)","v":{"v":5628,"d":"5628.00"}},"(xi)","पेंशन प्लान हेतु अंशदान (धारा 80CCC)",null,null,"रु.",{"$f":"IF($P$3=\"1\",Deductions!Q9,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",{"$nulls":3},"रु.",{"$f":"IF($P$3=\"1\",Deductions!E17,0)","v":{"v":0,"d":"0.00"}},"(xii)","राष्ट्रीय बचत पत्र पर अदत ब्याज ",null,null,"रु.",{"$f":"IF($P$3=\"1\",Deductions!E18,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(iv)","लोक भविष्य निधि (PPF)",{"$nulls":3},"रु.",{"$f":"IF($P$3=\"1\",Deductions!E19,0)","v":{"v":0,"d":"0.00"}},"(xiii)","टयूशन फीस",null,null,"रु.",{"$f":"IF($P$3=\"1\",Deductions!E15,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(v)","राष्ट्रीय बचत स्कीम (NSS)",{"$nulls":3},"रु.",{"$f":"IF($P$3=\"1\",Deductions!E20,0)","v":{"v":0,"d":"0.00"}},"(xiv)","इक्विटी लिंक सेविंग स्कीम",null,null,"रु.",{"$f":"IF($P$3=\"1\",Deductions!Q18,0)","v":{"v":0,"d":"0.00"}},{"$nulls":5},"GPF 2004 में जमा बोनस को 80C में लाभ लेने हेतु जोड़ना है तो YES अन्यथा NO का चयन करें"]
[null,null,"(vi)",{"$f":"IF('Gen Info'!C11=\"NO\",\"सामान्य प्रावधायी  निधि (GPF)\",\"जीपीएफ 2004\")","v":"जीपीएफ 2004"},{"$nulls":3},"रु.",{"$f":"IF(AND($P$3=\"1\",'Gen Info'!C11=\"NO\"),Salary!$M$30,IF(AND(Assesment!$P$3=\"1\",'Gen Info'!C11=\"YES\",U29=\"YES\"),Salary!N30,0))","v":{"v":0,"d":"0.00"}},"(xv)","स्थगित वार्षिकी (Defferred Annuty)",null,null,"रु.",{"$f":"IF($P$3=\"1\",Deductions!Q19,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"(vii)","सामूहिक बीमा प्रीमियम (G.Ins.)",{"$nulls":3},"रु.",{"$f":"IF($P$3=\"1\",Salary!$V$30,0)","v":{"v":220,"d":"220.00"}},"(xvi)","पी.एल.आई. ¼PLI)",null,null,"रु.",{"$f":"IF($P$3=\"1\",Deductions!E14,0)","v":{"v":14000,"d":"14000.00"}}]
[null,null,"(viii)","यू. एल. आई. पी./वार्षिक प्लान",{"$nulls":3},"रु.",{"$f":"IF($P$3=\"1\",Deductions!E16,0)","v":{"v":0,"d":"0.00"}},"(xvii)","अन्य जमाराशि (धारा 80 सी के अन्तर्गत) ",null,null,"रु.",{"$f":"IF($P$3=\"1\",Deductions!Q8,0)","v":{"v":0,"d":"0.00"}},{"$nulls":5},"NO"]
[null,null,"(ix)","गृह ऋण किस्त ¼HBA Premium)",{"$nulls":3},"रु.",{"$f":"IF($P$3=\"1\",Deductions!E11+Salary!$R$30,0)","v":{"v":30000,"d":"30000.00"}},"(xviii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"रु.",{"$f":"IF($P$3=\"1\",Deductions!E21,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"योग  [(i) से  (xviii)]",{"$nulls":10},"रु.",{"$f":"SUM(I22:I30)+SUM(O22:O30)","v":{"v":254504,"d":"254504.00"}}]
[null,null,"                        अधिकतम कटौती की राशि 1.50 लाख रुपए तक",{"$nulls":12},"रु.",{"$f":"IF(O31<150001,ROUND(O31,0),150000)","v":{"v":150000,"d":"150000.00"}}]
[null,null,"(B) घटाइये- धारा 80CCD(2) नियोक्ता द्वारा पेंशन अंशदान की राशि (अधिकतम वेतन का 10% पृथक से छूट)",{"$nulls":12},"रु.",{"$f":"IF(AND('Gen Info'!C11=\"Yes\"),Salary!$M$30,0)","v":{"v":120656,"d":"120656.00"}}]
[null,null,"(C) घटाइये -धारा 80 CCD(1B) नवीन पेंशन योजना में अतिरिक्त अंशदान (अधिकतम रू. 50,000)",{"$nulls":12},"रु.",{"$f":"IF($P$3=\"1\",Deductions!Q10,0)","v":{"v":50000,"d":"50000.00"}}]
[null,null,"योग 12(A+B+C)      ",{"$nulls":12},"रु.",{"$f":"SUM(Q32:Q34)","v":{"v":320656,"d":"320656.00"}}]
[null,13," अन्य कटौतियाँ"]
[null,null,1,"धारा 80 D ,चिकित्सा बीमा प्रीमियम (स्वयं,पति/पत्नी व बच्चों के लिए रू 25000, माता-पिता के लिए रू 25000,सीनियर सिटीजन रू 50000)",{"$nulls":11},"रु.",{"$f":"IF($P$3=\"1\",Master!R74,0)","v":{"v":0,"d":"0.00"}}]
[null,null,2,"धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80%या अधिक विकलांगता 125,000)   ",{"$nulls":11},"रु.",{"$f":"IF($P$3=\"1\",Deductions!Q12,0)","v":{"v":0,"d":"0.00"}}]
[null,null,3,"धारा 80DDB विशिष्ट रोंगों के उपचार हेतु कटौती (अधिकतम रू 40,000, सीनियर सिटीजन हेतु रू 100,000)","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","/kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½","रु.",{"$f":"IF($P$3=\"1\",Master!R76,0)","v":{"v":0,"d":"0.00"}}]
[null,null,4,"धारा 80E उच्च शिक्षा हेतु लिए ऋण का ब्याज ","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","/kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt","रु.",{"$f":"IF($P$3=\"1\",Deductions!Q14,0)","v":{"v":0,"d":"0.00"}}]
[null,null,5,"धारा 80G धर्मार्थ संस्थाओं आदि को दिये दान ( क श्रेणी में 100 प्रतिशत एवं ख श्रेणी में 50 प्रतिशत)","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","/kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½","रु.",{"$f":"IF($P$3=\"1\",Deductions!Q15+Salary!$W$30,0)","v":{"v":0,"d":"0.00"}}]
[null,null,6,"धारा 80U स्थाई रूप से शारीरिक असमर्थतता की दशा में (अधिकतम 75,000 तथा  अधिनियम 1995के अनुसार 125,000)","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","/kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½","रु.",{"$f":"IF($P$3=\"1\",Deductions!Q16,0)","v":{"v":0,"d":"0.00"}}]
[null,null,7,"धारा 80 TTA बचत खाते पर अधिकतम ब्याज रू. 10,000  ","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","/kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA)","रु.",{"$f":"IF($P$3=\"1\",Master!R80,0)","v":{"v":0,"d":"0.00"}}]
[null,null,8,"धारा 80 TTB वरिष्ठ नागरिकों को सभी ब्याज पर अधिकतम 50000रू.","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","/kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)","रु.",{"$f":"IF($P$3=\"1\",Master!R81,0)","v":{"v":0,"d":"0.00"}}]
[null,null,9,"धारा 80 GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान ","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","/kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku","रु.",{"$f":"IF($P$3=\"1\",Deductions!Q17,0)","v":{"v":0,"d":"0.00"}}]
[null,null,"कुल योग 13 ( 1 से 9 तक ) ",{"$nulls":12},"रु.",{"$f":"SUM(Q37:Q45)","v":{"v":0,"d":"0.00"}}]
[null,14,"कुल कटौती (12+13)",{"$nulls":12},"रु.",{"$f":"Q35+Q46","v":{"v":320656,"d":"320656.00"}}]
[null,15,"कर योग्य आय(11-14))",{"$nulls":12},"रु.",{"$f":"Q19-Q47","v":{"v":1061752,"d":"1061752.00"}}]
[null,16,"कुल आय की राशि को सम्पूर्ण करना ( दस के गुणक में ) धारा 288A",{"$nulls":12},"रु.",{"$f":"ROUND(Q48,-1)","v":{"v":1061750,"d":"1061750.00"}}]
[null,17," आयकर की गणना  उपरोक्त कॉलम 15 के आधार पर "]
[null,null,"1.OLD REGIME",{"$nulls":9},"2.NEW REGIME",null,null,{"$f":"IF($Q$51=\"OLD REGIME\",\"1\",\"2\")","v":"1"},{"$f":"Q2","v":"OLD REGIME"}]
[null,null,"एक व्यक्ति कर दाता",null,null,"वरिष्ठ नागरिक (60 से 80 वर्ष तक)",{"$nulls":3},"80 वर्ष या अधिक आयु",null,null,"0    - 2,50,000 ",null,{"v":0,"d":"0%"},null,{"$f":"IF($P$51=\"1\",\"\",IF($P$51=\"1\",Master!R90,Master!S90))","v":""}]
[null,null,"250000 तक ",null,"Nil","3,00,000 तक",null,null,"Nil",{"$nulls":3},"2,50,001 - 5,00,000",null,{"v":0.05,"d":"5%"},"रु.",{"$f":"IF($P$51=\"1\",Master!R91,Master!S91)","v":0}]
[null,null,"2,50,001-5,00,000",null,{"v":0.05,"d":"5%"},"3,00,001-5,00,000",null,null,{"v":0.05,"d":"5%"},"5,00,000 तक",null,"Nil","5,00,001 -  7,50,000",null,{"v":0.1,"d":"10%"},"रु.",{"$f":"IF($P$51=\"1\",Master!R92,Master!S92)","v":12500}]
[null,null,"5,00,001-10,00,000",null,{"v":0.2,"d":"20%"},"5,00,001-10,00,000",null,null,{"v":0.2,"d":"20%"},"5,00,001-10,00,000",null,{"v":0.2,"d":"20%"},"7,50,001 - 10,00,000",null,{"v":0.15,"d":"15%"},"रु.",{"$f":"IF($P$51=\"1\",Master!R93,Master!S93)","v":100000}]
[null,null,"10,00,000 से अधिक",null,{"v":0.3,"d":"30%"},"10,00,000 से अधिक",null,null,{"v":0.3,"d":"30%"},"10,00,000 से अधिक",null,{"v":0.3,"d":"30%"},"10,00,001- 12,50,000",null,{"v":0.2,"d":"20%"},"रु.",{"$f":"IF($P$51=\"1\",Master!R94,Master!S94)","v":18525}]
[{"$nulls":12},"12,50,001- 15,00,000",null,{"v":0.25,"d":"25%"},"रु.",{"$f":"IF($P$51=\"1\",\"\",IF($P$51=\"1\",Master!R95,Master!S95))","v":""}]
[{"$nulls":12}," Above 15,00,000",null,{"v":0.3,"d":"30%"},"रु.",{"$f":"IF($P$51=\"1\",\"\",IF($P$51=\"1\",Master!R96,Master!S96))","v":""}]
[null,null,"(1) योग आयकर ",{"$nulls":12},"रु.",{"$f":"SUM(Q53:Q58)","v":{"v":131025,"d":"131025.00"}}]
[null,null,"(2) छूट घारा 87(।) (2.50 लाख से 5.00 लाख तक की कर योग्य आय पर आयकर की छूट अधिकतम रू. 12500 तक)   ",{"$nulls":12},"रु.",{"$f":"IF(Q49>500000,0,IF(Q59<12501,Q59,12500))","v":{"v":0,"d":"0.00"}}]
[null,null,"(3) शेष आयकर (1-2) ",{"$nulls":12},"रु.",{"$f":"Q59-Q60","v":{"v":131025,"d":"131025.00"}}]
[null,null,"(4) शिक्षा उपकर 2% एवं उच्च शिक्षा के लिए अधिभार 2%  (योग 4%)  ",{"$nulls":12},"रु.",{"$f":"ROUND(Q61*0.04,0)","v":{"v":5241,"d":"5241.00"}}]
[null,null,"                                                             कुल आयकर (3+4)",{"$nulls":12},"रु.",{"$f":"SUM(Q61:Q62)","v":{"v":136266,"d":"136266.00"}}]
[null,18,"                                                             घटाइये :- राहत धारा 89 के तहत ",{"$nulls":12},"रु.",{"$f":"IF(Deductions!Q20=\"\",0,Deductions!Q20)","v":{"v":0,"d":"0.00"}}]
[null,19,"                                                            कुल शेष आयकर",{"$nulls":12},"रु.",{"$f":"Q63-Q64","v":{"v":136266,"d":"136266.00"}}]
[null,20,"स्रोत पर आयकर कटौती\n का विवरण",null,null,"सितम्बर 2021\nतक  रूपये",{"$nulls":3},"दिसम्बर 2021\nतक  रूपये",null,"जनवरी 2022","फरवरी 2022",null,"टी .डी.एस.एरियर आदि से\nरूपये","TDS योग"]
[{"$nulls":5},{"$f":"SUM(Salary!X10:X16)","v":50000},{"$nulls":3},{"$f":"SUM(Salary!X17:X19)","v":49000},null,{"$f":"SUM(Salary!X20)","v":18500},{"$f":"SUM(Salary!X21)","v":19000},null,{"$f":"SUM(Salary!$X$22:$X$29)","v":0},{"$f":"SUM(F67,J67,L67,M67,O67)","v":{"v":136500,"d":"136500.00"}}]
[null,{"$f":"IF($Q$65>$P$67,\"Income Tax Payable\",IF($Q$65<$P$67,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Refundable"},{"$nulls":13},"रु.",{"$f":"IF($Q$65>$P$67,$Q$65-$P$67,$P$67-$Q$65)","v":{"v":234,"d":"234.00"}}]
[null,null,"हस्ताक्षर कार्मिक "]
[{"$nulls":14},"Programmed by Hans Raj Joshi"]

{"sheet":"Master","index":7,"n_rows":100,"n_cols":57,"rows_kept":100,"hidden":true,"merged":[[0,0,0,18],[1,15,2,16],[1,17,2,17],[1,21,1,25],[1,26,1,30],[1,33,2,33],[2,21,2,23],[2,24,2,25],[2,26,2,27],[3,11,3,14],[3,26,3,27],[4,2,5,2],[4,3,5,3],[4,15,4,17],[4,26,4,27],[5,26,5,27],[6,26,6,27],[8,26,8,29],[8,40,8,41],[9,26,9,27],[10,26,10,27],[10,34,10,35],[11,26,11,27],[11,35,12,36],[12,26,12,27],[13,26,13,27],[14,26,14,27],[15,26,15,27],[16,21,16,22],[18,9,18,11],[18,12,18,14],[18,21,18,22],[19,2,19,3],[19,4,19,6],[20,1,20,3],[20,4,20,6],[21,1,21,3],[21,4,21,6],[22,1,22,3],[22,4,22,6],[23,1,23,3],[23,4,23,6],[24,4,24,6],[25,2,25,3],[25,4,25,6],[25,17,25,20],[26,2,26,3],[26,4,26,6],[26,16,26,18],[27,2,27,6],[27,11,27,12],[27,16,27,18],[29,17,29,18],[30,17,30,18],[39,0,39,15],[40,1,40,2],[40,16,40,17],[41,1,41,15],[42,1,42,15],[43,1,43,15],[44,0,46,0],[44,1,44,10],[44,13,44,15],[44,16,45,17],[45,1,45,10],[45,13,45,15],[46,1,46,10],[46,13,46,15],[47,1,47,15],[48,0,50,0],[48,1,48,8],[48,9,48,10],[48,13,48,15],[48,16,50,17],[49,1,50,2],[49,3,49,5],[49,6,49,8],[49,9,49,10],[49,13,49,15],[50,3,50,5],[50,6,50,8],[50,9,50,10],[50,13,50,15],[51,1,51,15],[52,1,52,15],[53,1,53,15],[54,1,54,15],[55,1,55,15],[56,0,71,0],[56,1,56,17],[57,1,57,17],[58,2,58,5],[58,9,58,13],[58,16,67,17],[59,2,59,5],[59,9,59,13],[60,2,60,5],[60,9,60,13],[61,2,61,5],[61,9,61,13],[62,2,62,5],[62,9,62,13],[63,2,63,5],[63,9,63,13],[64,2,64,5],[64,9,64,13],[65,2,65,5],[65,9,65,13],[66,2,66,5],[66,9,66,13],[67,1,67,13],[68,1,68,15],[69,1,69,15],[70,1,70,15],[71,1,71,15],[72,1,72,17],[73,1,73,15],[74,1,74,15],[75,1,75,15],[76,1,76,15],[77,1,77,15],[78,1,78,15],[79,0,80,0],[79,1,79,15],[80,1,80,13],[81,1,81,15],[82,1,82,15],[83,1,83,15],[84,1,84,15],[85,1,85,15],[86,9,86,16],[87,1,87,10],[87,13,87,16],[88,1,88,3],[89,4,89,8],[89,9,89,12],[89,13,89,14],[90,0,90,1],[90,4,90,6],[90,9,90,10],[90,13,90,14],[91,0,91,1],[91,4,91,6],[91,9,91,10],[91,13,91,14],[92,0,92,1],[92,4,92,6],[92,9,92,10],[92,13,92,14],[93,0,93,1],[93,4,93,6],[93,9,93,10],[93,13,93,14],[94,0,94,1],[94,4,94,6],[94,8,94,9],[94,13,94,14],[95,13,95,14],[96,14,96,16],[97,6,97,16],[99,1,99,15]]}
["Master Sheet"]
[{"$nulls":4},"EMPLOYEE TYPE",null,{"$f":"Salary!N6","v":"NPS"},null,{"$f":"'Gen Info'!F8","v":"1975-01-01"},{"$f":"'Gen Info'!C11","v":"Yes"},null,"Bonus",{"$f":"'Pay & Allowances'!L9","v":"No"},"Bonus months",{"$f":"'Pay & Allowances'!N9","v":6}," EMPLOYEE FROM MEDICAL DEP.,JUDICIARY DEP.POLICE CONSTABLE OR CLASS IV(L-1 TO L-4)",null,false,"HITKARI NIDHI",{"$f":"IFERROR(IF(OR(E3=\"All India Services\",E3=\"State Service\"),500,250),0)","v":500},"अन्य भत्ते",{"$nulls":5},"RGHS",{"$nulls":6},"RGHS FOR NPS"]
[null,{"$f":"'Gen Info'!C5","v":"HANS RAJ JOSHI"},null,{"$f":"'Gen Info'!C6","v":"Principal"},{"$f":"'Gen Info'!C7","v":"State Service"},null,{"$f":"'Gen Info'!F7","v":"L-16"},{"$f":"'Gen Info'!F5","v":"RJGA199412341234"},{"$f":"'Gen Info'!C9","v":"XXXXX1234X"},null,"HRA exemption",{"$f":"IF(M2=\"No\",0,ROUND((6774*O2/12),0))","v":0},{"$f":"ROUND(L3*50%,0)","v":0},{"$f":"L3-M3","v":0},{"$f":"IF(Deductions!P36=25%,1,2)","v":2},{"$nulls":3},"LIC SALARY",{"$f":"Deductions!Q7","v":469},"10(14)+16(iii)",{"$nulls":3},"deduction",null,"PAY RANGE",null,"2019-04-01","2020-04-01","ded","DIFFERENCE",null,null,{"$f":"CONCATENATE('Gen Info'!$E$6&\" OF THE \"&'Gen Info'!$F$9&\" \"&'Gen Info'!$F$10)","v":"OFFICE OF THE PRINCIPAL GOVT SENIOR SECONDARY SCHOOL 13DOL,SRI GANGANAGAR"}]
[null,{"$f":"AH10","v":78000},null,null,"HRA",null,"CCA","MARCH CCA","CPF",null,"SURRENDER","surrender  2021-22",{"$nulls":8},{"$f":"SUM('Pay & Allowances'!H12,'Pay & Allowances'!I12)","v":0},null,"2017-10-01","2018-03-01",{"$f":"IF(Salary!$D$11<23001,1450,IF(Salary!$D$11<28001,1625,IF(Salary!$D$11<38501,2100,IF(Salary!$D$11<51501,2850,IF(Salary!$D$11<62001,3575,IF(Salary!$D$11<72001,4200,IF(Salary!$D$11<80001,4800)))))))","v":4800},{"$f":"IF(Salary!$D$11<116001,6150,IF(Salary!$D$11<167001,8900,10500))","v":6150},"UP TO   18000",null,242,265,{"$f":"IF($G$2=\"OPS\",IF(Salary!$AD$6<18001,265,IF(Salary!$AD$6<33501,440,IF(Salary!$AD$6<54001,658,875))),\"\")","v":""},{"$f":"AD4-AC4","v":23},null,135," SALARY STATEMENT FOR FINANCIAL YEAR 2021-22"]
[null,null,"Salary","DA17% FROM JULY 28%",{"$f":"'Pay & Allowances'!C9","v":"Yes"},null,{"$f":"'Pay & Allowances'!C12","v":"No "},{"$f":"G7","v":0},{"$nulls":3},"month","pay","da","total","DEDUCTION",{"$nulls":6},500,1450,null,null,"18001 TO 33500",null,402,440,null,{"$f":"AD5-AC5","v":38},null,220]
[null,"Month",null,null,{"$f":"'Pay & Allowances'!E9","v":{"v":0.09,"d":"9%"}},{"$f":"IF('Pay & Allowances'!E9=18%,\"Y\",\"Z\")","v":"Z"},{"$f":"'Pay & Allowances'!E12","v":"KOTA"},null,"GROSS SALARY",null,"ITAX",{"$f":"IF('Pay & Allowances'!G9=\"Yes\",'Pay & Allowances'!$I$9,\"\")","v":10},{"$f":"IF(L6=\"\",0,IF(ISNA(ROUND(VLOOKUP($L$6,Master!$A$8:$D$19,3,0)/2,0)),0,ROUND(VLOOKUP($L$6,Master!$A$8:$D$19,3,0)/2,0)))","v":40150},{"$f":"IF(M6=\"\",\"\",IF(OR($L$6=4,$L$6=5,$L$6=6),ROUND(M6*17%,0),ROUND(M6*28%,0)))","v":11242},{"$f":"SUM(M6:N6)","v":51392},"RPMF","GPF1","GPF2","NPS/GPF","SI","Govt.NPS",null,650,1625,null,null,"33501 TO 54000",null,602,658,null,{"$f":"AD6-AC6","v":56},null,330]
[null,"march",{"$f":"Salary!D10","v":78000},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N$15=\"YES\"),0,ROUND($C$7*17%,0))","v":13260},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N15=\"YES\"),0,IF($F$6=\"Z\",ROUND($C7*($E$6-1%),0),IF($F$6=\"y\",ROUND($C7*($E$6-2%),0)))),0)","v":6240},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N15=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(AH10>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L10","v":97500},null,{"$f":"Deductions!C25","v":3000},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH10>0),IF(AH10<=18000,265,IF(AH10<=33500,440,IF(AH10<=54000,658,875))),0)","v":0},{"$f":"IF(C7>80000,\"6150\",IF(C7>72000,\"4800\",IF(C7>62000,\"4200\",IF(C7>51500,\"3575\",IF(C7>38500,\"2850\",IF(C7>28500,\"2100\",IF(C7>23100,\"1625\",IF(C7>17700,\"1450\",\"0\"))))))))","v":"4800"},{"$f":"IF(C7>167000,\"10500\",IF(C7>116000,\"8900\",Q7))","v":"4800"},{"$f":"IF($G$2=\"NPS\",ROUND((C7+D7)*10%,0),R7)","v":9126},{"$f":"AE10","v":7000},{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S7,0)","v":0},null,1100,2100,null,null,"54001 & ABOVE",null,800,875,null,{"$f":"AD7-AC7","v":75},null,440]
[4,"april",{"$f":"Salary!D11","v":78000},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!N16=\"YES\"),0,ROUND(C8*17%,0))","v":13260},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N16=\"YES\"),0,IF($F$6=\"Z\",ROUND($C8*($E$6-1%),0),IF($F$6=\"y\",ROUND($C8*($E$6-2%),0)))),0)","v":6240},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N16=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(C8>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L11","v":97500},null,{"$f":"Deductions!D25","v":3000},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH11>0),IF(AH11<=18000,265,IF(AH11<=33500,440,IF(AH11<=54000,658,875))),0)","v":0},{"$f":"IF(C8>80000,\"6150\",IF(C8>72000,\"4800\",IF(C8>62000,\"4200\",IF(C8>51500,\"3575\",IF(C8>38500,\"2850\",IF(C8>28500,\"2100\",IF(C8>23100,\"1625\",IF(C8>17700,\"1450\",\"0\"))))))))","v":"4800"},{"$f":"IF(C8>167000,\"10500\",IF(C8>116000,\"8900\",Q8))","v":"4800"},{"$f":"IF($G$2=\"NPS\",ROUND((C8+D8)*10%,0),R8)","v":9126},{"$f":"AE10","v":7000},{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S8,0)","v":0},null,1450,2850,{"$nulls":10},"ACP MONTH","pay after acp"]
[5,"may",{"$f":"Salary!D12","v":78000},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!N17=\"YES\"),0,ROUND(C9*17%,0))","v":13260},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N17=\"YES\"),0,IF($F$6=\"Z\",ROUND($C9*($E$6-1%),0),IF($F$6=\"y\",ROUND($C9*($E$6-2%),0)))),0)","v":6240},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N17=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(C9>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L12","v":97500},null,{"$f":"Deductions!E25","v":4000},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH12>0),IF(AH12<=18000,265,IF(AH12<=33500,440,IF(AH12<=54000,658,875))),0)","v":0},{"$f":"IF(C9>72000,\"4800\",IF(C9>62000,\"4200\",IF(C9>51500,\"3575\",IF(C9>38500,\"2850\",IF(C9>28500,\"2100\",IF(C9>23100,\"1625\",IF(C9>17700,\"1450\",\"0\")))))))","v":"4800"},{"$f":"IF(C9>167000,\"10500\",IF(C9>116000,\"8900\",IF(C9>80000,\"6150\",Q9)))","v":"4800"},9126,{"$f":"AE10","v":7000},{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S9,0)","v":0},null,2100,3575,null,null,"SI PREMIUM FROM SALARY",{"$nulls":5},"MONTH","BASIC",{"$f":"'Pay & Allowances'!J6","v":0},{"$f":"IF(OR('Pay & Allowances'!J6=\"\",'Pay & Allowances'!M6=\"\"),\"\",'Pay & Allowances'!$M$6)","v":""},null,"L-1",1,null,"CADER"]
[6,"june",{"$f":"Salary!D13","v":78000},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!N18=\"YES\"),0,ROUND(C10*17%,0))","v":13260},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N18=\"YES\"),0,IF($F$6=\"Z\",ROUND($C10*($E$6-1%),0),IF($F$6=\"y\",ROUND($C10*($E$6-2%),0)))),0)","v":6240},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N18=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(C10>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L13","v":97500},null,{"$f":"Deductions!F25","v":4000},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH13>0),IF(AH13<=18000,265,IF(AH13<=33500,440,IF(AH13<=54000,658,875))),0)","v":0},"4800","4800",9126,{"$f":"AE10","v":7000},{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S10,0)","v":0},null,3300,4200,null,null,"PAY RANGE",null,"2018-03-01","2020-03-01",{"$f":"IF(Deductions!F31=\"YES\",Deductions!H32,IF(Salary!$AD$6<22001,800,IF(Salary!$AD$6<28501,1200,IF(Salary!$AD$6<46501,2200,IF(Salary!$AD$6<72001,3000,5000)))))","v":7000},{"$f":"ROW(AF10)-7","v":3},"2020-03-01",{"$f":"IF($AI$9=ROW(AG10)-7,'Pay & Allowances'!$M$6,'Pay & Allowances'!$F$5)","v":78000},"march basic","2021-03-01",{"$f":"AH10","v":78000},"L-2",2,null,"All India Services"]
[7,"july",{"$f":"Salary!D14","v":80300},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!N19=\"YES\"),0,ROUND(C11*28%,0))","v":22484},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N19=\"YES\"),0,IF($F$6=\"Z\",ROUND($C11*$E$6,0),IF($F$6=\"y\",ROUND($C11*$E$6,0)))),0)","v":7227},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N19=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(C11>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L14","v":110011},null,{"$f":"Deductions!H25","v":12000},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH11>0),IF(AH14<=18000,265,IF(AH14<=33500,440,IF(AH14<=54000,658,875))),IF(AND($G$2=\"NPS\",Deductions!$F$35=\"YES\",Deductions!$H$36=7,AH11>0),IF(AH14<=18000,135,IF(AH14<=33500,220,IF(AH14<=54000,350,440))),0))","v":0},"4800","6150",10278,{"$f":"T10","v":7000},{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S11,0)","v":0},null,4100,4800,null,null,"UPTO 22000",null,500,800,null,{"$f":"ROW(AF11)-7","v":4},"2020-04-01",{"$f":"IF($AI$9=ROW(AG11)-7,'Pay & Allowances'!$M$6,AH10)","v":78000},{"$nulls":3},"L-3",3,null,"State Service"]
[8,"august",{"$f":"Salary!D15","v":80300},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!N20=\"YES\"),0,ROUND(C12*28%,0))","v":22484},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N20=\"YES\"),0,IF($F$6=\"Z\",ROUND($C12*$E$6,0),IF($F$6=\"y\",ROUND($C12*$E$6,0)))),0)","v":7227},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N20=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(C12>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L15","v":110011},null,{"$f":"Deductions!I25","v":12000},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH12>0),IF(AH15<=18000,265,IF(AH15<=33500,440,IF(AH15<=54000,658,875))),IF(AND($G$2=\"NPS\",Deductions!$F$35=\"YES\",Deductions!$H$36<=8,Deductions!$H$36>2,AH12>0),IF(AH15<=18000,135,IF(AH15<=33500,220,IF(AH15<=54000,350,440))),0))","v":440},"4800","6150",10278,7000,{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S12,0)","v":0},null,5200,6150,null,null,"22001 TO 28500",null,700,1200,null,5,"2020-05-01",{"$f":"IF($AI$9=ROW(AG12)-7,'Pay & Allowances'!$M$6,AH11)","v":78000},null,"DEFFERD RELEASE PAY",null,"L-4",4,null,"Subordinate"]
[9,"september",{"$f":"Salary!D16","v":80300},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!N21=\"YES\"),0,ROUND(C13*28%,0))","v":22484},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N21=\"YES\"),0,IF($F$6=\"Z\",ROUND($C13*$E$6,0),IF($F$6=\"y\",ROUND($C13*$E$6,0)))),0)","v":7227},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N21=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(C13>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L16","v":110011},null,{"$f":"Deductions!J25","v":12000},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH13>0),IF(AH16<=18000,265,IF(AH16<=33500,440,IF(AH16<=54000,658,875))),IF(AND($G$2=\"NPS\",Deductions!$F$35=\"YES\",Deductions!$H$36<=9,Deductions!$H$36>2,AH13>0),IF(AH16<=18000,135,IF(AH16<=33500,220,IF(AH16<=54000,350,440))),0))","v":440},"4800","6150",10278,7000,{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S13,0)","v":0},null,5700,8900,null,null,"28501TO 46500",null,1300,2200,null,6,"2020-06-01",{"$f":"IF($AI$9=ROW(AG13)-7,'Pay & Allowances'!$M$6,AH12)","v":78000},{"$nulls":3},"L-5",5,null,"Ministrial"]
[10,"october",{"$f":"Salary!D17","v":80300},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!N22=\"YES\"),0,ROUND(C14*31%,0))","v":24893},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N22=\"YES\"),0,IF($F$6=\"Z\",ROUND($C14*$E$6,0),IF($F$6=\"y\",ROUND($C14*$E$6,0)))),0)","v":7227},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N22=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(C14>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L17","v":112420},null,{"$f":"Deductions!K25","v":12000},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH14>0),IF(AH17<=18000,265,IF(AH17<=33500,440,IF(AH17<=54000,658,875))),IF(AND($G$2=\"NPS\",Deductions!$F$35=\"YES\",Deductions!$H$36<=10,Deductions!$H$36>2,AH14>0),IF(AH17<=18000,135,IF(AH17<=33500,220,IF(AH17<=54000,350,440))),0))","v":440},"4800","6150",10519,7000,{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S14,0)","v":0},null,6200,10500,null,null,"46501 TO 72000",null,1800,3000,null,7,"2020-07-01",{"$f":"IF($AI$9=ROW(AG14)-7,'Pay & Allowances'!$M$6,MROUND(AH13*103%,100))","v":80300},null,"BASIC",null,"L-6",6,null,"Class IV"]
[11,"november",{"$f":"Salary!D18","v":80300},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!N23=\"YES\"),0,ROUND(C15*31%,0))","v":24893},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N23=\"YES\"),0,IF($F$6=\"Z\",ROUND($C15*$E$6,0),IF($F$6=\"y\",ROUND($C15*$E$6,0)))),0)","v":7227},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N23=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(C15>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L18","v":112420},null,{"$f":"Deductions!L25","v":18500},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH15>0),IF(AH18<=18000,265,IF(AH18<=33500,440,IF(AH18<=54000,658,875))),IF(AND($G$2=\"NPS\",Deductions!$F$35=\"YES\",Deductions!$H$36<=11,Deductions!$H$36>2,AH15>0),IF(AH18<=18000,135,IF(AH18<=33500,220,IF(AH18<=54000,350,440))),0))","v":440},"4800","6150",10519,7000,{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S15,0)","v":0},{"$nulls":5},"ABOVE 72000",null,3000,5000,null,8,"2020-08-01",{"$f":"IF($AI$9=ROW(AG15)-7,'Pay & Allowances'!$M$6,AH14)","v":80300},null,"MARCH R PAY",null,"L-7",7]
[12,"december",{"$f":"Salary!D19","v":80300},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!N24=\"YES\"),0,ROUND(C16*31%,0))","v":24893},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N24=\"YES\"),0,IF($F$6=\"Z\",ROUND($C16*$E$6,0),IF($F$6=\"y\",ROUND($C16*$E$6,0)))),0)","v":7227},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N24=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(C16>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L19","v":112420},null,{"$f":"Deductions!M25","v":18500},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH16>0),IF(AH19<=18000,265,IF(AH19<=33500,440,IF(AH19<=54000,658,875))),IF(AND($G$2=\"NPS\",Deductions!$F$35=\"YES\",Deductions!$H$36<=12,Deductions!$H$36>2,AH16>0),IF(AH19<=18000,135,IF(AH19<=33500,220,IF(AH19<=54000,350,440))),0))","v":440},"4800","6150",10519,7000,{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S16,0)","v":0},{"$nulls":5},"MAXIMUM",null,4000,7000,null,9,"2020-09-01",{"$f":"IF($AI$9=ROW(AG16)-7,'Pay & Allowances'!$M$6,AH15)","v":80300},null,"DA",null,"L-8",8]
[1,"january",{"$f":"Salary!D20","v":80300},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!N25=\"YES\"),0,ROUND(C17*31%,0))","v":24893},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N25=\"YES\"),0,IF($F$6=\"Z\",ROUND($C17*$E$6,0),IF($F$6=\"y\",ROUND($C17*$E$6,0)))),0)","v":7227},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N25=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(C17>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L20","v":112420},null,{"$f":"Deductions!N25","v":18500},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH17>0),IF(AH20<=18000,265,IF(AH20<=33500,440,IF(AH20<=54000,658,875))),IF(AND($G$2=\"NPS\",Deductions!$F$35=\"YES\",Deductions!$H$36>=1,Deductions!$H$36<>2,AH17>0),IF(AH20<=18000,135,IF(AH20<=33500,220,IF(AH20<=54000,350,440))),0))","v":440},"4800","6150",10519,7000,{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S17,0)","v":0},"CM CORONA RELIEF",null,2,"cader","Pay Leval",{"$nulls":5},10,"2020-10-01",{"$f":"IF($AI$9=ROW(AG17)-7,'Pay & Allowances'!$M$6,AH16)","v":80300},null,"HRA",null,"L-9",9]
[2,"february",{"$f":"Salary!D21","v":80300},{"$f":"IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!N26=\"YES\"),0,ROUND(C18*31%,0))","v":24893},{"$f":"IF($E$5=\"Yes\",IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N26=\"YES\"),0,IF($F$6=\"Z\",ROUND($C18*$E$6,0),IF($F$6=\"y\",ROUND($C18*$E$6,0)))),0)","v":7227},null,{"$f":"IFERROR(IF(AND('Pay & Allowances'!$L$12=\"YES\",'Pay & Allowances'!$N26=\"YES\"),0,IF($G$5=\"Yes\",IF('Pay & Allowances'!$E$12=\"\",0,IF(C18>23100,VLOOKUP($G$6,$R$20:$T$24,2,0),VLOOKUP($G$6,$R$20:$T$24,3,0))),0)),0)","v":0},null,{"$f":"Salary!L21","v":112420},null,{"$f":"Deductions!O25","v":19000},{"$nulls":4},{"$f":"IF(AND($G$2=\"OPS\",AH18>0),IF(AH21<=18000,265,IF(AH21<=33500,440,IF(AH21<=54000,658,875))),IF(AND($G$2=\"NPS\",Deductions!$F$35=\"YES\",Deductions!$H$36>=1,AH18>0),IF(AH21<=18000,135,IF(AH21<=33500,220,IF(AH21<=54000,350,440))),0))","v":440},"4800","6150",10519,7000,{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S18,0)","v":0},{"$nulls":3},{"$f":"'Gen Info'!C7","v":"State Service"},{"$f":"VLOOKUP('Gen Info'!$F$7,AL9:AM32,2,0)","v":16},{"$nulls":5},11,"2020-11-01",{"$f":"IF($AI$9=ROW(AG18)-7,'Pay & Allowances'!$M$6,AH17)","v":80300},null,"CCA",null,"L-10",10]
[3,"MARCH SUR",{"$f":"C18","v":80300},{"$nulls":6},"arrear1",null,null,"arrear2",{"$nulls":7},{"$f":"IF(AND('Gen Info'!$C$10=\"YES\",$G$2=\"NPS\"),Master!S19,0)","v":0},"cm corona relief",{"$nulls":9},12,"2020-12-01",{"$f":"IF($AI$9=ROW(AG19)-7,'Pay & Allowances'!$M$6,AH18)","v":80300},{"$nulls":3},"L-11",11]
[null,null,"वेतन (PAY+DA)",null,{"$f":"ROUND(SUM(Salary!D10:D21,Salary!D28,Salary!E10:E21,Salary!E28),0)","v":1199357},null,null,{"$f":"ROUND(HRA!$D$22,0)","v":1199357},null,"राशि ","TDS",{"$f":"IF(J2=\"Yes\",\"NPS\",\"GPS\")","v":"NPS"},"राशि ","TDS",{"$f":"IF(J2=\"Yes\",\"NPS\",\"GPF\")","v":"NPS"},null,null,"JAIPUR(U)",1000,620,null,"month","deduction",{"$nulls":8},13,"2021-01-01",{"$f":"IF($AI$9=ROW(AG20)-7,'Pay & Allowances'!$M$6,AH19)","v":80300},{"$nulls":3},"L-12",12]
["A","HRA RECEIVED",null,null,{"$f":"Salary!F30","v":82776},null,null,{"$f":"HRA!E22","v":82776},null,{"$f":"'Pay & Allowances'!C17","v":0},{"$f":"'Pay & Allowances'!D17","v":0},{"$f":"'Pay & Allowances'!E17","v":0},{"$f":"'Pay & Allowances'!F17","v":0},{"$f":"'Pay & Allowances'!G17","v":0},{"$f":"'Pay & Allowances'!H17","v":0},null,null,"JODHPUR",620,320,null,"2020-03-01",{"$nulls":3},"IF(C8>167000,\"10500\",IF(C8>116000,\"8900\",Q8",{"$nulls":5},14,"2021-02-01",{"$f":"IF($AI$9=ROW(AG21)-7,'Pay & Allowances'!$M$6,AH20)","v":80300},{"$nulls":3},"L-13",13]
[null,"10% of SALARY(PAY+DA)",null,null,{"$f":"ROUND(E20*10%,0)","v":119936},null,null,{"$f":"ROUND(HRA!$D$22*10%,0)","v":119936},{"$nulls":3},"GOVT NPS",null,null,"GOVT NPS",null,"March","AJMER",620,320,null,"sep",{"$nulls":15},"L-14",14]
[null,"RENT PAID ANNUALY",null,null,{"$f":"HRA!F5","v":0},null,null,{"$f":"HRA!F5","v":0},{"$nulls":3},{"$f":"IF(AND('Gen Info'!C11=\"YES\",'Gen Info'!C10=\"YES\"),Master!L21,0)","v":0},null,null,{"$f":"IF(AND('Gen Info'!C11=\"YES\",'Gen Info'!C10=\"YES\"),Master!O21,0)","v":0},null,"April","BIKANER",620,320,null,"oct",{"$nulls":15},"L-15",15]
["B","Rent paid ( Annual )-10% of Salary received ( Basic + DA )",null,null,{"$f":"$E$23-$E$22","v":-119936},null,null,{"$f":"H23-H22","v":-119936},{"$nulls":8},"May","KOTA",620,320,null,"nov",{"$nulls":15},"L-16",16]
["C","40% OF PAY",{"$f":"HRA!J9","v":"NON METRO"},null,{"$f":"IF($C$25=\"METRO\",ROUND(E20*50%,0),ROUND(E20*40%,0))","v":479743},null,null,{"$f":"ROUND(HRA!$D$22*40%,0)","v":479743},{"$nulls":13},"dec",{"$nulls":15},"L-17",17]
[null,null,"HRA rent receipt req",null,{"$f":"$E$21+$E$22","v":202712},null,null,{"$f":"H22+H21","v":202712},{"$nulls":9},"80CCD(1B)",{"$nulls":3},"jan",{"$nulls":15},"L-18",18]
[null,null,"HRA exemption",null,{"$f":"IF($E$24>0,MIN($E$21,$E$24,$E$25),0)","v":0},null,null,{"$f":"IF($H$24>0,MIN($H$21,$H$24,$H$25),0)","v":0},{"$nulls":8},"SUM OF 80C",null,null,{"$f":"H59+H60+H61+H62+H63+H64+H65+H66+H67+P60+P61+P62+P63+P64+P65+P66+P67+R70","v":{"v":254504,"d":"254504.00"}},null,"feb",{"$nulls":15},"L-19",19]
[null,{"$f":"IF('Gen Info'!C11=\"Yes\",\"NPS\",\"OPS\")","v":"NPS"},"DA ARREAR",{"$nulls":4},"surrender 2020-21 arrear",null,"month",{"$f":"IF('Pay & Allowances'!G9=\"YES\",'Pay & Allowances'!I9,\"\")","v":10},"total",{"$nulls":4},"80CCD(1B) ADDITIONAL",null,null,{"$f":"IF(Deductions!K10>50000,50000,Deductions!K10)","v":{"v":50000,"d":"50000.00"}},{"$nulls":17},"L-20",20]
[null,null,"MONTH","PAY","DIFF 3%",null,null,"PAY","DA5%",null,"total","GPF/nps","CASH","Govt.NPS","GPF2004",null,"80CCD 1",{"$f":"R70","v":{"v":120656,"d":"120656.00"}},"80C EXCEED 1.5LAC",{"$f":"IF(G2=\"OPS\",0,IF(T27>150000,T27-150000,0))","v":{"v":104504,"d":"104504.00"}},{"$nulls":17},"L-21",21,{"$nulls":17},4]
[null,7,"2021-07-01",{"$f":"C11","v":80300},{"$f":"ROUND(D30*31%,0)-ROUND(D30*28%,0)","v":2409},null,null,{"$f":"IF($K$28=B30,ROUND(D30/2,0),0)","v":0},{"$f":"ROUND(H30*3%,0)","v":0},null,{"$f":"E30+I30","v":2409},{"$f":"IF($B$28=\"OPS\",K30,ROUND(K30*10%,0))","v":241},0,{"$f":"IF(AND('Gen Info'!$C$11=\"YES\",'Gen Info'!$C$10=\"YES\"),Master!L30,0)","v":0},{"$f":"IF($G$2=\"NPS\",K30-L30,0)","v":2168},null,null,"REVISED 80CCD1",null,{"$f":"IFERROR(SUM(R29)-Deductions!Q31,0)","v":{"v":120656,"d":"120656.00"}},{"$nulls":17},"L-22",22]
[null,8,"2021-08-01",{"$f":"D30","v":80300},{"$f":"ROUND(D31*31%,0)-ROUND(D31*28%,0)","v":2409},null,null,{"$f":"IF($K$28=B31,ROUND(D31/2,0),0)","v":0},{"$f":"ROUND(H31*3%,0)","v":0},null,2409,{"$f":"IF($B$28=\"OPS\",K31,ROUND(K31*10%,0))","v":241},0,{"$f":"IF(AND('Gen Info'!$C$11=\"YES\",'Gen Info'!$C$10=\"YES\"),Master!L31,0)","v":0},{"$f":"IF($G$2=\"NPS\",K31-L31,0)","v":2168},null,{"$f":"IF(N31=\"YES\",Master!T31,0)","v":0},"80CCD(1B) SPLIT FROM 80CCD1",null,{"$f":"IF(OR('Gen Info'!C11=\"NO\",T27<150000),0,IF(R29>=T29,MIN((50000-T28),T29),MIN(R29,50000-T28)))","v":{"v":0,"d":"0.00"}},null,null,"T29>50000,50000-T28,U29",{"$nulls":14},"L-23",23]
[null,9,"2021-09-01",{"$f":"D31","v":80300},2409,null,null,0,0,null,2409,241,0,{"$f":"IF(AND('Gen Info'!$C$11=\"YES\",'Gen Info'!$C$10=\"YES\"),Master!L32,0)","v":0},2168,{"$nulls":22},"L-24",24]
[null,10]
[null,11]
[null,12]
[null,null,"TOTAL(7/19-12/19)",null,{"$f":"SUM(E30:E35)","v":7227},null,null,{"$f":"SUM(H30:H35)","v":0},0,null,7227,723,0,0,6504]
[null,1,"2022-01-01",{"$f":"D30","v":80300},{"$nulls":3},0,{"$f":"ROUND(H37*5%,0)","v":0},null,{"$f":"E37+I37","v":0},0,{"$f":"K37-L37","v":0},{"$f":"IF(AND('Gen Info'!$C$11=\"YES\",'Gen Info'!$C$10=\"YES\"),Master!L37,0)","v":0}]
[null,2,"2022-02-01",{"$f":"D31","v":80300},{"$nulls":3},0,0,null,{"$f":"E38+I38","v":0},0,{"$f":"K38-L38","v":0},{"$f":"IF(AND('Gen Info'!$C$11=\"YES\",'Gen Info'!$C$10=\"YES\"),Master!L38,0)","v":0},{"$nulls":3},"OLD","NEW"]
[null,null,"TOTAL(1/20-2/20)",null,{"$f":"SUM(E37:E38)","v":0},null,null,{"$f":"SUM(H37:H38)","v":0},0,null,0,0,0,0]
["vk;dj x.kuk izi= o\"kZ 2019&2020¼dj fu/kkZj.k o\"kZ 2020&2021½",{"$nulls":15},{"$f":"#REF!","v":{"$error":"#REF!"}},"OLD REGIME","NEW REGIME"]
[1,"uke deZpkjh %",{"$nulls":7}," in %",{"$nulls":5},"PAN :",{"$f":"Deductions!L23","v":0}]
[2,"vk; %  o\"kZ&2019&20 esa izkIr dqy osru ¼ dj ;ksX; lqfo/kkvksa ds eqY; lfgr ½",{"$nulls":14},"#-",{"$f":"IF('Gen Info'!$C$11=\"NO\",SUM(Salary!$L$30,$U$4),IF(AND('Gen Info'!$C$11=\"YES\",'Gen Info'!C10=\"YES\"),SUM(Salary!$L$30,$U$4),SUM(Salary!$L$30,Salary!$M$30,$U$4)))","v":{"v":1461408,"d":"1461408.00"}},{"$f":"IF('Gen Info'!$C$11=\"NO\",SUM(Salary!$L$30,$U$4),IF(AND('Gen Info'!$C$11=\"YES\",'Gen Info'!D10=\"YES\"),SUM(Salary!$L$30,$U$4),SUM(Salary!$L$30,Salary!$M$30,$U$4)))","v":{"v":1461408,"d":"1461408.00"}}]
[3,"x`g fdjk;k] /kkjk 10¼13&A½ ds vUrxrZ ,oa /kkjk 10¼14½ds vUrxrZ vU; Hkrs tks dj eqDÙk gSA",{"$nulls":14},"#-",{"$f":"-SUM(HRA!$J$5,'Pay & Allowances'!$H$12)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[4,"                                                              'ks\"k ¼2&3½",{"$nulls":14},"#-",{"$f":"$R$42+$R$43","v":{"v":1461408,"d":"1461408.00"}},{"$f":"$R$42+$R$43","v":{"v":1461408,"d":"1461408.00"}}]
[5," ¼i½euksjatu Hkrk /kkjk 16 ¼ii½ ds vUrxrZ ¼ vf/kdre lhek : 5000 ½",{"$nulls":11},{"$f":"IF('Pay & Allowances'!$I$12>5000,5000,'Pay & Allowances'!$I$12)","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"v":0,"d":"0.00"}]
[null," ¼ii½ O;o;k; dj /kkjk 16 ¼iii½ ds vUrxrZ ",{"$nulls":11},{"$f":"'Pay & Allowances'!J12","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"v":0,"d":"0.00"}]
[null," ¼iiI½ LVs.MMZ fMMsD'ku (Standard Deduction)  50]000 ¼vf/kdre½",{"$nulls":11},{"$f":"MIN($R$44,50000)","v":{"v":50000,"d":"50000.00"}},null,null,"#-",{"$f":"-SUM(N45:P47)","v":{"v":-50000,"d":"-50000.00"}},{"v":0,"d":"0.00"}]
[6,"                                                           'ks\"k ¼4&5½",{"$nulls":14},"#-",{"$f":"R44+R47","v":{"v":1411408,"d":"1411408.00"}},{"$f":"S44-S45-S46-S47","v":{"v":1461408,"d":"1461408.00"}}]
[7,"¼v½x`g lEifr ls vk;%¼1½ Loa; ds mi;ksx esa &'kwU;",{"$nulls":7},"¼2½ izkIr fdjk;k #-",{"$nulls":3},{"$f":"Deductions!E9","v":{"v":0,"d":"0.00"}}]
[null,"¼c½ ?kVk;sa ",null," fdjk;s dk 30%",null,null," x`g _.k ij C;kt",null,null," x`gdj ",{"$nulls":3},"  ;ksx 7¼c½"]
[{"$nulls":3},{"$f":"ROUND((N49-J51)*0.3,0)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"IF((Salary!S30+Deductions!E12)>200000,200000,(Salary!S30+Deductions!E12))","v":{"v":29000,"d":"29000.00"}},null,null,{"$f":"Deductions!E10","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"D51+G51+J51","v":{"v":29000,"d":"29000.00"}}]
[null,"                                                          'ks\"k &@$¼7¼v½ ,oa ;ksx 7¼c½ dk½  ",{"$nulls":14},"#-",{"$f":"N49-N51","v":{"v":-29000,"d":"-29000.00"}},{"$f":"N49-D51-J51","v":{"v":0,"d":"0.00"}}]
[null,"                                                             dqy 'ks\"k &@$¼6,oa 7½",{"$nulls":14},"#-",{"$f":"R48+R52","v":{"v":1382408,"d":"1382408.00"}},{"$f":"S48+S52","v":{"v":1461408,"d":"1461408.00"}}]
[8,"cpr [kkrs ij C;kt",{"$nulls":14},"#-",{"$f":"Deductions!$E$7+Deductions!$E$8","v":{"v":0,"d":"0.00"}},{"$f":"Deductions!$E$7+Deductions!$E$8","v":{"v":0,"d":"0.00"}}]
[9,"vU; vk;",{"$nulls":15},{"$f":"Deductions!$E$6","v":{"v":0,"d":"0.00"}},{"$f":"Deductions!$E$6","v":{"v":0,"d":"0.00"}}]
[10,"ldy vk;                                                            ;ksx ¼8$9½",{"$nulls":14},"#-",{"$f":"R53+R54+R55","v":{"v":1382408,"d":"1382408.00"}},{"$f":"S53+S54+S55","v":{"v":1461408,"d":"1461408.00"}}]
[11,"?kVkb;s dVkSSfr;k¡ %& /kkjk US 80C, 80CCC,80CCD (1)"]
[null,"(A) vf/kdre lhek 1]50]000@& ¼/kkjk 80CCE ½ ] ¼/kkjk 80CCD (2), ds vykok"]
[null,"(i)","jkT; chek ¼SI)",{"$nulls":3},"#-",{"$f":"Salary!O30","v":{"v":84000,"d":"84000.00"}},"(x)","ljdkjh isa'ku ;kstuk esa va'knku ECPF\nvf/kdre osru dk 10%¼/kkjk 80ccd½",{"$nulls":4},"#-",{"$f":"IF(AND($G$2=\"NPS\",Deductions!$N$31=\"YES\"),T30,IF($G$2=\"NPS\",Salary!$M$30,0))","v":{"v":120656,"d":"120656.00"}}]
[null,"(ii)","thou chek izhfe;e ¼LIC)",{"$nulls":3},"#-",{"$f":"Salary!T30+Deductions!E13","v":{"v":5628,"d":"5628.00"}},"(xi)","isa'ku Iyku gsrq va'knku¼/kkjk 80ccc½",{"$nulls":4},"#-",{"$f":"Deductions!Q9","v":{"v":0,"d":"0.00"}}]
[null,"(iii)","jk\"Vªh; cpr i= ¼NSC)",{"$nulls":3},"#-",{"$f":"Deductions!E17","v":{"v":0,"d":"0.00"}},"(xii)","jk\"Vªh; cpr i= ij vnr C;kt",{"$nulls":4},"#-",{"$f":"Deductions!E18","v":{"v":0,"d":"0.00"}}]
[null,"(iv)","yksd Hkfo\"; fuf/k ¼PPF)",{"$nulls":3},"#-",{"$f":"Deductions!E19","v":{"v":0,"d":"0.00"}},"(xiii)","V;w'ku Qhl ",{"$nulls":4},"#-",{"$f":"Deductions!E15","v":{"v":0,"d":"0.00"}}]
[null,"(v)","jk\"Vªh; cpr Ldhe ¼NSS)",{"$nulls":3},"#-",{"$f":"Deductions!E20","v":{"v":0,"d":"0.00"}},"(xiv)","bfDoVh fyad lsfoax Ldhe",{"$nulls":4},"#-",{"$f":"Deductions!Q18","v":{"v":0,"d":"0.00"}}]
[null,"(vi)","lkekU; izko/kk;h fuf/k ¼GPF)/GPF2004",{"$nulls":3},"#-",{"$f":"IF($G$2=\"OPS\",Salary!M30,IF(Assesment!U29=\"YES\",Salary!N30,0))","v":{"v":0,"d":"0.00"}},"(xv)","LFkfxr okf\"kZdh ¼Defferred Annuty)",{"$nulls":4},"#-",{"$f":"Deductions!Q19","v":{"v":0,"d":"0.00"}}]
[null,"(vii)","lkewfgd chek izhfe;e ¼G.Ins.)",{"$nulls":3},"#-",{"$f":"Salary!V30","v":{"v":220,"d":"220.00"}},"(xvi)","ih-,y-vkbZ- ¼PLI)",{"$nulls":4},"#-",{"$f":"Deductions!E14","v":{"v":14000,"d":"14000.00"}}]
[null,"(viii)",";w- ,y- vkbZ- ih-@okf\"kZd Iyku",{"$nulls":3},"#-",{"$f":"Deductions!E16","v":{"v":0,"d":"0.00"}},"(xvii)","vU; tekjkf'k ¼/kkjk 80 lh ds vUrxZr½",{"$nulls":4},"#-",{"$f":"Deductions!Q8","v":{"v":0,"d":"0.00"}}]
[null,"(ix)","x`g _.k fdLr ¼HBA Premium)",{"$nulls":3},"#-",{"$f":"Salary!R30+Deductions!E11","v":{"v":30000,"d":"30000.00"}},"(xviii)","lqdU;k le`f) ;kstuk esa tek jkf'k",{"$nulls":4},"#-",{"$f":"Deductions!E21","v":{"v":0,"d":"0.00"}}]
[null,";ksx ( i ls xviii )",{"$nulls":12},"#-",{"$f":"SUM(H59:H67)+SUM(P59:P67)","v":{"v":254504,"d":"254504.00"}}]
[null,"                        vf/kdre dVkSrh dh jkf'k 1-50 yk[k #i, rd",{"$nulls":14},"#-",{"$f":"IF(P68<150001,ROUND(P68,0),150000)","v":{"v":150000,"d":"150000.00"}},{"v":0,"d":"0.00"}]
[null,"(B) ?kVkb;s& /kkjk 80CCD(2) fu;ksDrk }kjk isa'ku va'knku dh jkf'k ¼vf/kdre osru dk 10%) i`Fkd ls NwV",{"$nulls":15},{"$f":"IF($G$2=\"NPS\",Salary!M30,0)","v":{"v":120656,"d":"120656.00"}},{"$f":"R70","v":{"v":120656,"d":"120656.00"}}]
[null,"(C) ?kVkb;s & /kkjk 80CCD (1B) uohu isa'ku ;kstuk esa vfrfjDr va'knku ¼vf/kdre :- 50]000)",{"$nulls":14},"#-",{"$f":"Deductions!Q10","v":{"v":50000,"d":"50000.00"}},{"v":0,"d":"0.00"}]
[null,";ksx 11(A+B+C)      ",{"$nulls":14},"#-",{"$f":"SUM(R69:R71)","v":{"v":320656,"d":"320656.00"}},{"$f":"SUM(S69:S71)","v":{"v":120656,"d":"120656.00"}}]
[null," vU; dVkSfr;k¡"]
[12,"1-/kkjk 80 D ,fpfdRlk chek izhfe;e ¼Lo;a]ifr@iRuh o cPpksa ds fy, : 25000] ekrk&firk ds fy, : 25000]lhfu;j flVhtu : 50000½",{"$nulls":14},"#-",{"$f":"IF(Deductions!$Q$11=\"\",0,IF($M$89=1,MIN(Deductions!$Q$11,25000),MIN(Deductions!$Q$11,50000)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[13,"2- /kkjk 80DD fodykax vkfJrksa ds fpfdRlk mipkj ¼vf/kdre 75]000 rFkk 80% ;k vf/kd fodykaxrk 125]000½",{"$nulls":14},"#-",{"$f":"Deductions!$Q$12","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[14,"3- /kkjk 80DDB fof'k\"V jksaxksa ds mipkj gsrq dVkSrh ¼vf/kdre : 40]000] lhfu;j flVhtu gsrq : 100]000½",{"$nulls":14},"#-",{"$f":"IF(Deductions!$Q$13=\"\",0,IF(Master!$M$89=1,MIN(Deductions!$Q$13,40000),MIN(Deductions!$Q$13,100000)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[15,"4- /kkjk 80E mPp f'k{kk gsrq fy, _.k dk C;kt",{"$nulls":14},"#-",{"$f":"Deductions!$Q$14","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[16,"5- /kkjk 80G /kekZFkZ laLFkkvksa vkfn dks fn;s nku ¼ d Js.kh esa 100 izfr'kr ,oa [k Js.kh esa 50 izfr'kr½",{"$nulls":14},"#-",{"$f":"Deductions!$Q$15+Salary!$W$30","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[17,"6- /kkjk 80U LFkkbZ :i ls 'kkjhfjd vleFkZrrk dh n'kk esa ¼vf/kdre 75]000 rFkk  vf/kfu;e 1995ds vuqlkj 125]000½",{"$nulls":14},"#-",{"$f":"Deductions!$Q$16","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[18,"7- /kkjk 80 TTA cpr [kkrs ij vf/kdre C;kt :- 10]000 194(IA) ",{"$nulls":14},"#-",{"$f":"IF(Deductions!$E$7=\"\",0,IF($M$89=1,MIN(Deductions!$E$7,10000),0))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[null,"8- /kkjk 80 TTB ofj\"B ukxfjdksa dks lHkh C;kt ij vf/kdre 50000:- /kkjk194(IA)",{"$nulls":15},{"$f":"IF(Deductions!$E$8=\"\",0,IF($M$89=1,0,MIN(Deductions!$E$8,50000)))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[19,"9- /kkjk 80 GGA vuqeksfnr oSKkfud] lkekftd] xzkeh.k fodkl vkfn gsrq fn;k x;k nku",{"$nulls":14},"#-",{"$f":"Deductions!$Q$17","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[null,"dqy ;ksx  ¼ 12 ls 19 rd ½",{"$nulls":14},"#-",{"$f":"SUM($R$74:$R$82)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(S74:S82)","v":{"v":0,"d":"0.00"}}]
[20,"dqy dVkSrh ( 11 + 12 TO19)",{"$nulls":14},"#-",{"$f":"$R$72+$R$83","v":{"v":320656,"d":"320656.00"}},{"$f":"S72+S83","v":{"v":120656,"d":"120656.00"}}]
[21,"dj ;ksX; vk; ( 10 - 13 )",{"$nulls":14},"#-",{"$f":"$R$56-$R$84","v":{"v":1061752,"d":"1061752.00"}},{"$f":"S56-S84","v":{"v":1340752,"d":"1340752.00"}}]
[15,"dqy vk; dh jkf'k dks lEiw.kZ djuk ¼ nl ds xq.kd esa ½ /kkjk 288A",{"$nulls":14},"#-",{"$f":"ROUND($R$85,-1)","v":{"v":1061750,"d":"1061750.00"}},{"$f":"ROUND($S$85,-1)","v":{"v":1340750,"d":"1340750.00"}}]
[{"$nulls":9},{"$f":"Assesment!C49","v":"कुल आय की राशि को सम्पूर्ण करना ( दस के गुणक में ) धारा 288A"}]
[null,"OLD REGIME",{"$nulls":11},"NEW REGIME",{"$nulls":3},"OLD REGIME","NEW REGIME"]
[null,",d O;fDr dj nkrk",{"$nulls":8},"category for tax calculation",null,1,{"$nulls":3},"AMOUNT",{"$f":"$R$86","v":{"v":1061750,"d":"1061750.00"}},{"$f":"$S$86","v":{"v":1340750,"d":"1340750.00"}}]
[null,null,"AMOUNT",null,"ofj\"B ukxfjd ¼60 ls 80 o\"kZ rd½",{"$nulls":4},"80 o\"kZ ;k vf/kd vk;q",{"$nulls":3},"0    - 2,50,000 ",null,{"v":0,"d":"0%"},{"$f":"IF($S$89>250000,250000,$S$89)","v":250000},null,{"$f":"ROUND($Q$90*$P$90,0)","v":{"v":0,"d":"0.00"}}]
["2,50,000 rd",null,{"$f":"IF($R$89>250000,250000,$R$89)","v":250000},0,"3,00,000 rd",null,null,{"$f":"IF($R$89>300000,300000,$R$89)","v":300000},0,{"$nulls":4},"2,50,001 - 5,00,000",null,{"v":0.05,"d":"5%"},{"$f":"IF($S$89>500000,250000,IF($S$89>250000,$S$89-250000,0))","v":250000},{"$f":"IF($M$89=1,$C$91*$D$91,IF($M$89=2,$H$91*$I$91,$L$91*$M$91))","v":{"v":0,"d":"0.00"}},{"$f":"ROUND($Q$91*$P$91,0)","v":{"v":12500,"d":"12500.00"}}]
["2,50,001-5,00,000",null,{"$f":"IF($R$89>500000,250000,IF($R$89>250000,$R$89-250000,0))","v":250000},{"v":0.05,"d":"5%"},"3,00,001-5,00,000",null,null,{"$f":"IF($R$89>500000,200000,IF($R$89>300000,$R$89-300000,0))","v":200000},{"v":0.05,"d":"5%"},"5,00,000 rd",null,{"$f":"IF($R$89>500000,500000,$R$89)","v":500000},0,"5,00,001 -  7,50,000",null,{"v":0.1,"d":"10%"},{"$f":"IF($S$89>750000,250000,IF($S$89>500000,$S$89-500000,0))","v":250000},{"$f":"IF($M$89=1,$C$92*$D$92,IF($M$89=2,$H$92*$I$92,$L$92*$M$92))","v":{"v":12500,"d":"12500.00"}},{"$f":"ROUND($Q$92*$P$92,0)","v":{"v":25000,"d":"25000.00"}}]
["5,00,001-10,00,000",null,{"$f":"IF($R$89>1000000,500000,IF($R$89>500000,$R$89-500000,0))","v":500000},{"v":0.2,"d":"20%"},"5,00,001-10,00,000",null,null,{"$f":"IF($R$89>1000000,500000,IF($R$89>500000,$R$89-500000,0))","v":500000},{"v":0.2,"d":"20%"},"5,00,001-10,00,000",null,{"$f":"IF($R$89>1000000,500000,IF($R$89>500000,$R$89-500000,0))","v":500000},{"v":0.2,"d":"20%"},"7,50,001 - 10,00,000",null,{"v":0.15,"d":"15%"},{"$f":"IF($S$89>1000000,250000,IF($S$89>750000,$S$89-750000,0))","v":250000},{"$f":"IF($M$89=1,$C$93*$D$93,IF($M$89=2,$H$93*$I$93,$L$93*$M$93))","v":{"v":100000,"d":"100000.00"}},{"$f":"ROUND($Q$93*$P$93,0)","v":{"v":37500,"d":"37500.00"}}]
["10,00,000 ls vf/kd",null,{"$f":"IF($R$89>1000000,IF($R$89>1000000,$R$89-1000000,0),0)","v":61750},{"v":0.3,"d":"30%"},"10,00,000 ls vf/kd",null,null,{"$f":"IF($R$89>1000000,IF($R$89>1000000,$R$89-1000000,0),0)","v":61750},{"v":0.3,"d":"30%"},"10,00,000 ls vf/kd",null,{"$f":"IF($R$89>1000000,IF($R$89>1000000,$R$89-1000000,0),0)","v":61750},{"v":0.3,"d":"30%"},"10,00,001- 12,50,000",null,{"v":0.2,"d":"20%"},{"$f":"IF($S$89>1250000,250000,IF($S$89>1000000,$S$89-1000000,0))","v":250000},{"$f":"IF($M$89=1,$C$94*$D$94,IF($M$89=2,$H$94*$I$94,$L$94*$M$94))","v":{"v":18525,"d":"18525.00"}},{"$f":"ROUND($Q$94*$P$94,0)","v":{"v":50000,"d":"50000.00"}}]
["TOTAL",null,{"$f":"SUM(C91:C94)","v":1061750},{"$nulls":4},{"$f":"SUM(H91:H94)","v":1061750},{"$nulls":3},{"$f":"SUM(L91:L94)","v":1061750},null,"12,50,001- 15,00,000",null,{"v":0.25,"d":"25%"},{"$f":"IF($S$89>1500000,250000,IF($S$89>1250000,$S$89-1250000,0))","v":90750},null,{"$f":"ROUND($Q$95*$P$95,0)","v":{"v":22688,"d":"22688.00"}}]
[{"$nulls":13}," Above 15,00,000",null,{"v":0.3,"d":"30%"},{"$f":"IF($S$89>1500000,IF($S$89>1500000,$S$89-1500000,0),0)","v":0},null,{"$f":"ROUND(Q96*P96,0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":14},"TOTAL TAX",null,null,{"$f":"SUM(R91:R95)","v":{"v":131025,"d":"131025.00"}},{"$f":"SUM(S91:S96)","v":{"v":147688,"d":"147688.00"}}]
[{"$nulls":6},"NwV ?kkjk 87¼A½ ¼2-50 yk[k ls 5-00 yk[k rd dh dj ;ksX; vk; ij vk;dj dh NwV vf/kdre :- 12500 rd½",{"$nulls":10},{"$f":"IF($R$85<=500000,IF($R$97<12500,$R$97,12500),0)","v":{"v":0,"d":"0.00"}},{"$f":"IF($S$85<=500000,IF($S$97<12500,$S$97,12500),0)","v":{"v":0,"d":"0.00"}}]
[{"$nulls":15},"NET TAX",null,{"$f":"R97-R98","v":{"v":131025,"d":"131025.00"}},{"$f":"S97","v":{"v":147688,"d":"147688.00"}}]
[null,"¼2½ NwV ?kkjk 87¼A½ ¼2-50 yk[k ls 5-00 yk[k rd dh dj ;ksX; vk; ij vk;dj dh NwV vf/kdre :- 12500 rd½"]

{"sheet":"NSC INTT","index":8,"n_rows":28,"n_cols":21,"rows_kept":28,"merged":[[1,0,1,20],[2,0,3,0],[2,1,2,20],[3,1,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[3,19,3,20],[13,1,13,7],[14,1,16,1],[14,2,14,7],[14,10,14,12],[14,13,14,14],[15,2,15,3],[15,4,15,5],[15,6,15,7],[16,9,16,18]]}
[]
["NSC INTEREST CALCULATION\n(GIVE AMOUNT, PERIOD-WISE)"]
["PURCHASE PERIOD","Time of Purchase of NSC-(VIII Issue)"]
[null,"During 2012-13",null,"During 2013-14 to 2015-16",null,"During 01-04-2016 to30-09-2016",null,"During 01-10-2016 to31-03-2017",null,"During 01-04-2017 to30-06-2017",null,"During 01-07-2017 to31-12-2017",null,"During 01-01-2018 to30-09-2018",null,"During 01-10-2018 to30-06-2019",null,"During 01-07-2019 to11-12-2019",null,"During 12-12-2019 to31-03-2020"]
["Period (in years)","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest","Amount","Interest"]
["1st year",null,{"$f":"B6*8.78%","v":{"v":0,"d":"0.00"}},100,{"$f":"D6*8.68%","v":8.68},null,{"$f":"F6*8.1%","v":0},null,{"$f":"H6*8%","v":{"v":0,"d":"0.00"}},null,{"$f":"J6*7.9%","v":{"v":0,"d":"0.00"}},null,{"$f":"L6*7.8%","v":{"v":0,"d":"0.00"}},null,{"$f":"N6*7.6%","v":{"v":0,"d":"0.00"}},100,{"$f":"P6*8%","v":{"v":8,"d":"8.00"}},100,{"$f":"R6*7.9%","v":{"v":7.9,"d":"7.90"}},100,{"$f":"T6*7.9%","v":{"v":7.9,"d":"7.90"}}]
["2nd year",null,{"$f":"B7*9.56%","v":{"v":0,"d":"0.00"}},null,{"$f":"D7*9.43%","v":{"v":0,"d":"0.00"}},null,{"$f":"F7*8.76%","v":0},null,{"$f":"H7*8.64%","v":{"v":0,"d":"0.00"}},5000,{"$f":"J7*8.52%","v":{"v":426,"d":"426.00"}},null,{"$f":"L7*8.41%","v":{"v":0,"d":"0.00"}},100,{"$f":"N7*8.18%","v":8.18},null,{"$f":"P7*8.64%","v":{"v":0,"d":"0.00"}},null,{"$f":"R7*8.52%","v":{"v":0,"d":"0.00"}},null,{"$f":"T7*8.52%","v":{"v":0,"d":"0.00"}}]
["3rd year",null,{"$f":"B8*10.4%","v":{"v":0,"d":"0.00"}},null,{"$f":"D8*10.25%","v":{"v":0,"d":"0.00"}},null,{"$f":"F8*9.46%","v":0},100,{"$f":"H8*9.33%","v":9.33},100,{"$f":"J8*9.2%","v":{"v":9.2,"d":"9.20"}},null,{"$f":"L8*9.06%","v":{"v":0,"d":"0.00"}},null,{"$f":"N8*8.8%","v":{"v":0,"d":"0.00"}},null,{"$f":"P8*9.33%","v":{"v":0,"d":"0.00"}},null,{"$f":"R8*9.2%","v":{"v":0,"d":"0.00"}},null,{"$f":"T8*9.2%","v":{"v":0,"d":"0.00"}}]
["4th year",null,{"$f":"B9*11.31%","v":{"v":0,"d":"0.00"}},100,{"$f":"D9*11.14%","v":11.14},100,{"$f":"F9*10.23%","v":{"v":10.23,"d":"10"}},null,{"$f":"H9*10.08%","v":{"v":0,"d":"0.00"}},null,{"$f":"J9*9.92%","v":{"v":0,"d":"0.00"}},null,{"$f":"L9*9.77%","v":{"v":0,"d":"0.00"}},null,{"$f":"N9*9.47%","v":{"v":0,"d":"0.00"}},null,{"$f":"P9*10.08%","v":{"v":0,"d":"0.00"}},null,{"$f":"R9*9.33%","v":{"v":0,"d":"0.00"}},null,{"$f":"T9*9.92%","v":{"v":0,"d":"0.00"}}]
["5th year",100,{"$f":"B10*12.3%","v":{"v":12.3,"d":"12.30"}},null,{"$f":"D10*12.11%","v":{"v":0,"d":"0.00"}},null,{"$f":"F10*11.06%","v":0},null,{"$f":"H10*10.88%","v":{"v":0,"d":"0.00"}},null,{"$f":"J10*10.71%","v":{"v":0,"d":"0.00"}},null,{"$f":"L10*10.53%","v":{"v":0,"d":"0.00"}},null,{"$f":"N10*10.19%","v":{"v":0,"d":"0.00"}},null,{"$f":"P10*10.88%","v":{"v":0,"d":"0.00"}},null,{"$f":"R10*10.74%","v":{"v":0,"d":"0.00"}},null,{"$f":"T10*10.7%","v":{"v":0,"d":"0.00"}}]
["Total",null,{"$f":"SUM(C6:C10)","v":{"v":12.3,"d":"12.30"}},null,{"$f":"SUM(E6:E10)","v":19.82},null,{"$f":"SUM(G6:G10)","v":{"v":10.23,"d":"10"}},null,{"$f":"SUM(I6:I10)","v":9.33},null,{"$f":"SUM(K6:K10)","v":{"v":435.2,"d":"435.20"}},null,{"$f":"SUM(M6:M10)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(O6:O10)","v":8.18},null,{"$f":"SUM(Q6:Q10)","v":{"v":8,"d":"8.00"}},null,{"$f":"SUM(S6:S10)","v":{"v":7.9,"d":"7.90"}},null,{"$f":"SUM(U6:U10)","v":{"v":7.9,"d":"7.90"}}]
[]
[]
[null,"Time of Purchase of NSC-(IX Issue)"]
[null,"Year for which interest accuues","When Investment made",{"$nulls":7},"INTEREST ACCURED ON NSC",null,null,{"$f":"SUM(C11,E11,G11,I11,K11,M11,O11,Q11,S11,S11,U11,D28,F28,H28,)","v":598.72}]
[null,null,"Before April 1,2012",null,"During 2012-13",null,"On or after 01-04-2013"]
[null,null,"Amount","Interest","Amount","Interest","Amount","Interest",null,"NOTE :- Fill amount of purchased NSC in respective period "]
[null,"1st year",100,{"$f":"C18*8.89%","v":8.89},null,{"$f":"E18*9.1%","v":0},null,{"$f":"G18*8.99%","v":0}]
[null,"2nd year",200,{"$f":"C19*9.68%","v":19.36},null,{"$f":"E19*9.93%","v":0},null,{"$f":"G19*9.8%","v":0}]
[null,"3rd year",null,{"$f":"C20*10.54%","v":0},null,{"$f":"E20*10.83%","v":0},null,{"$f":"G20*10.68%","v":0}]
[null,"4th year",null,{"$f":"C21*11.48%","v":0},null,{"$f":"E21*11.81%","v":0},null,{"$f":"G21*11.64%","v":0}]
[null,"5th year",100,{"$f":"C22*12.5%","v":12.5},null,{"$f":"E22*12.89%","v":0},null,{"$f":"G22*12.69%","v":0}]
[null,"6th year",null,{"$f":"C23*13.61%","v":0},null,{"$f":"E23*14.06%","v":0},null,{"$f":"G23*13.83%","v":0}]
[null,"7th year",null,{"$f":"C24*14.82%","v":0},null,{"$f":"E24*15.34%","v":0},100,{"$f":"G24*15.08%","v":15.079999999999998}]
[null,"8th year",100,{"$f":"C25*16.13%","v":16.13},null,{"$f":"E25*16.74%","v":0},null,{"$f":"G25*16.43%","v":0}]
[null,"9th year",null,{"$f":"C26*17.57%","v":0},null,{"$f":"E26*18.26%","v":0},null,{"$f":"G26*17.91%","v":0}]
[null,"10th year",null,{"$f":"C27*19.13%","v":0},null,{"$f":"E27*19.92%","v":0},null,{"$f":"G27*19.52%","v":0}]
[null,"Total",null,{"$f":"SUM(D18:D27)","v":56.879999999999995},null,{"$f":"SUM(F18:F27)","v":0},null,{"$f":"SUM(H18:H27)","v":15.079999999999998}]

{"sheet":"RULES","index":9,"n_rows":129,"n_cols":2,"rows_kept":129,"merged":[[0,0,0,1]]}
["                  Brief detail of Information and RULES for(Rates,Deductions,Exemption etc.)                                                                             ( Mini Ready Reckoner)"]
[null,"  Select and click any rule to know the brief detail about the taxation Rules & Informations."]
[1,"New Tax  Rates  for Financial-Year 2020-21, Assessment Year 2021-2022 in Old and New Regime"]
[2,"Some  Exempted Receipts / Special allowances &  Perquisite which are not chargable to tax in Old regime"]
[3,"Some Exempted Income ( to be shown while Return filing) "]
[4,"T A X   R U L E S  &  O T H E R   U S E F U L   I N F O R M A T I O N S"]
["I","HRA exemption-u/s 10(13A)"]
["II","Standard deduction u/s 16 (1a) instead of Transport allowance and Medical Reimbursement"]
["III","Reimbursement of Medical bills "]
["IV"," u/s(5) LTA  Exemption "]
["V","Deduction u/s 24  and Relief u/s 80EE or 80EEA on interest on housing loan."]
["VI","u/s 80CCE & 80CCD Maximum Exemption "]
["VII","Rajiv Gandhi Equity Savings Scheme "]
["VIII","u/s 80D Medical Insurance"]
["IX","u/s 80DD Deduction in respect of medical treatment of handicapped dependents"]
["X","u/s 80DDB Deduction in respect of medical treatment for specified ailments or diseases"]
["XI","u/s 80E Interest repayment on education loan"]
["XII","u/s 80G Donations given for certain charities "]
["XIII","u/s 80GG If Assesse is not getting  HRA,  but living in rented house,"]
["XIV","u/s 80U If assesse have a permanent physical disability "]
["XV","u/s 80TTA/80TTB Deduction on interest Income."]
[5," KNOW MORE about DEDUCTION under Section 80-C"]
["a","Qualifying Investments u/s 80CCE"]
["b","Provident Fund (PF) & Voluntary Provident Fund (VPF) "]
["c","Life Insurance Premiums & Unit linked Insurance Plan (ULIP)"]
["d","Public Provident Fund (PPF):"]
["e","National Savings Certificate (NSC):"]
["f","Home Loan Principal Repayment & Stamp Duty and Registration Charges for a home "]
["g","Tuition  fees  for 2 children "]
["h","Equity Linked Savings Scheme (ELSS)"]
["i","5-Yr bank fixed deposits (FDs)  or 5-Yr post office time deposit (POTD)"]
["j","Pension Funds or Pension Policies "]
["k","Sukanya Samridhi Account"]
["l","Infrastructure Bonds: NABARD rural bonds:"]
["m","Senior Citizen Savings Scheme 2004 (SCSS)"]
[6,"Allowed Deductions & Exemptions under New Income Tax Regime "]
[null,"         TAX  RATES  as per Old Regime --   for Financial Year 2020-21 & Assesment Year 2021-22  "]
[null,"                                                For Individual (MALE & FEMALE)  ASSESSE  "]
[null,"   Net Income Range                                                   Income Tax Rates"]
[null,"  Up to ₹ 2,50,000                                                                    NIL"]
[null,"  ₹ 2,50,001 to ₹ 5,00,000                                       5% on Total Income (-) ₹ 2,50,000"]
[null,"  ₹ 5,00,001 to ₹ 10,00,000                                ₹12,500+20% of Total Income (-) ₹5,00,000"]
[null,"  More than ₹ 10.00,000                                   ₹1,12,500+30% of Total Income (-) ₹10,00,000"]
[null,"Note- (u/s 87A- A rebate upto ₹ 12500/-  for assessee with Income range upto ₹ 5,00,00 will be available in Both Old & New Regime) )"]
[null,"     For SENIOR CITIZEN  ASSESSE (Above 60 Year ) attaining the age during the year "]
[null,"       Net Income Range                                              Income Tax Rates"]
[null,"    Up to  ₹3,00,000                                                           NIL"]
[null,"    ₹3,00,001 to 5,00,000                                                            5% of Total Income(-) ₹3,00,000"]
[null,"    ₹5,00,001 to 10,00,000                                         ₹10,000 +20% of Total Income (-) ₹5,00,000"]
[null,"    More than ₹10.00,000                                       ₹1,10,000 +30% of Total Income (-) ₹10,00,000"]
[null,"Note- (u/s 87A- A rebate upto ₹ 10000/-  for assessee with Income range upto ₹ 5,00,000)"]
[null,"    For VERY SENIOR CITIZEN  ASSESSE (Above 80 Year ) attaining the age during the year "]
[null,"      Net Income Range                                              Income Tax Rates"]
[null,"    Up to ₹5,00,000                                                           NIL"]
[null,"    ₹5,00,001 to ₹10,00,000                                         20% of Total Income (-) ₹10,00,000"]
[null,"    More than ₹10,00,000                                         ₹1,00,000 +30% of Total Income (-) ₹10,00,000"]
["Back ↑    ","Note: 1. Education and Health Cess is 4% of income tax from all Assesse. (as per Finance Act 2018)                                                                                                                                                           .        2. Surcharge on income tax @10% for income above ₹50 Lakh & 15% for income above ₹1crore  "]
[null,"           TAX  RATES as per New Regime -  for financial Year 2020-21 & Assesment Year 2021-22  ( The new scheme is optional in nature )"]
[null,"For Individual (>60Yrs)., Sr. Citizen (60+Yrs.) & Very Sr. Citizen (80+Yrs.) ASSESSE  "]
[null,"Up to – 250000 – Nil"]
[null,"  ₹ 2,50,001 to ₹ 5,00,000                                                 5% on Total Income (-) ₹2,50,000 "]
[null,"  ₹ 5,00,001 to ₹ 7,50,000                                   ₹12,500+10% of Total Income (-) ₹5,00,000"]
[null,"  ₹ 7,50,001 to ₹ 10,00,000                                 ₹37,500+15% of Total Income (-) ₹7,50,000"]
[null,"  ₹ 10,00,001 to ₹ 12,50,000                               ₹75,000+20% of Total Income (-) ₹10,00,000"]
[null,"  ₹ 12,50,001 to ₹ 15,00,000                            ₹1,25,000+25% of Total Income (-) ₹12,50,000"]
[null,"  ₹ 15,00,001 & above                                    ₹1,87,500+30% of Total Income (-) ₹15,00,000"]
["Back ↑    ","Note- (u/s 87A- A rebate upto ₹ 12500/-  for assessee with Income range upto ₹ 5,00,00 will be available in Both Old & New Regime) )"]
[]
[null," Some  Exempted Receipts /Special allowances &  Perquisite which are not chargable to tax are  "]
[null," Exempted Receipts - 1.  L.T.A (as per Rule)                                                            "]
["Back ↑    ","Special allowances Exempted u/s 10(14)                                                                                                                                                                                                                                                                      1. Uniform Allowance (granted to meet the expenditure incurred on purchase or maintenance of uniform to be worn during performance of Official Duty)                                                                                            2. Helper Allowance ( granted to meet exependiture incurred on helper for performance of official duty)                                                                                                                                                                                 3. Academic Allowance (granted for encouraging academic, research & training pursuits) including Newspaper, Generals etc.)                                                                                                                              4. Children Education Allowance ( ₹100 P.M. per child / (₹300 for hostel expenditure) Max of 2 children)                                                                                                                                                             5. Convayance allowance ( granted to meet the expenditure incurred on convayance, while performing official duty.                                                                                                                                                 .   ( Expenditure incured for covering journey between office and residence is not treated as expenditure in performance of official duty. ) "]
[null," Deduction available u/s -16                                                                                                                                                                                                                                                                          1.Standard deduction of  Rs. 50000/- is granted to all salaried employee.whenever Transport allowance and Medical reimbursement are abolished                                                                                                      2. Entertainment allowance (for Govt Employees) Max  ₹5000/-                                                                                                                                                                                                                           3. Professional tax - Professional tax paid by employeer is deducted from Gross salary."]
[null," Perquisite not chargable to tax"]
[null," Free food and beverage 1. Food and non-alcoholic beverages provided in working hours in remote area or an offshore instalation are exempted to tax                                                                                                                                    2. Tea, coffee or non-alcoholic beverages and snaks in working hours are tax free perquisites.                                                                                                                                                                                                                                                            3. Meals (Lunch and / or dinner) in office hours is not taxable. If cost to the employeris  ₹50 (or Less) per meal.  "]
[null," Some Exempted Income are ( to be shown while Return filing) "]
[null,"         1.  Withdrawal / Maturity / Interest received from PF,PPF,Sukanya Samridhi Account, Life Insurance policy, Agriculture. (Max up to ₹5000/- )"]
[null,"         2    Long Term Capital Gain From Shares"]
[null,"         3.   Interest on Saving Bank & Post Office A/c up to  ₹ 10,000/- ( Sec-80TTE) for Individual "]
[null,"         4.   Interest on Saving Bank & Post Office A/c, FD, RD etc up to  ₹ 50,000/- (Sec-80TTE) for Sr. Citizen "]
[null,"Please Note :"]
[null,"(i) Interest earned from all sources are to be included. All interest income (including saving Bank A/C (above ₹10,000 for Individual & ₹50,000 for Sr. Citizen )"]
["Back ↑    ","(II) As per clarification from IT department, all perquisites such as rent-free accommodation, company provided car, free or concessional education facilities, employee stock option plan, free club membership, company provided credit card, gift vouchers, meal coupons, hotel stay beyond 15 days, are fully taxable. "]
["Back ↑    ","T A X   R U L E S  &  O T H E R   U S E F U L   I N F O R M A T I O N S  for"]
["I"," House Rent Allowance exemption-10(13A) = Least amount of anyone (i) 40% of Salary (50%, if house situated in Mumbai, Calcutta, Delhi or Madras)                                                                                                                                                                                                                                   .                                                                                                             or (ii) Actual HRA Recived                                                                                                                                                                                                                                                        .                                                                                                             or (iii) Rent paid minus 10% of salary * Salary= Basic + DA (if part of retirement benefit) + Turnover based Commission                                              Note i. Fully Taxable, if HRA is received by an employee who is living in his own house or if he does not pay any rent                                                                                                                                                          ii. It is mandatory for employee to report PAN of the landlord to the employer if rent paid is more than ₹ 1,00,000 [Circular No. 08 /2013 dated 10th October, 2013]. (In case the landlord does not have PAN, employee should submit a declaration stating the same along with the landlord’s details.)"]
["II       ","Standard deduction of  ₹50000/- is allowed to all salaried employee. In Finace act 2019 standard deduction of Rs. 50,000/- has allowed to all salaried employees.                                              But Transport allowance  & Medical Reimburement are abolished. Whenever an exemption of  up to ₹3200/- per month is cotinue for disabled employees (Blind and Handicapped employees) .                                                                                                                                                                                                                                                                                                                                                                                                        Transport Allowance is granted to an employee to meet expenditure on commuting between place of residence and place of duty"]
["III","Reimbursement of Medical bills has withdrawan and not allowed from finance act 2018. Now it has become a part of Standard deduction of Rs. 50,000/-"]
["IV"," u/s(5) LTA is exempt to the tune of economy class Train/ Air /Recognised public Transport fare for the family to any destination in India, by the shortest route.                                                                                                                   LTA can be claimed twice in a block of 4 calendar year. The current block is from 01.01.2018 to 31.12.2021. For claim, it is must to provide originals tickets etc."]
["   V(a) New Change"," u/s 24 and 80 EE/ 80EEA There is an Exemption for interest on housing loan.(for Self occupied Residence). If the loan was taken before Apr 1, 1999 exemption is limited to ₹30,000/- per year. If the loan was taken after Apr 1, 1999 exemption is limited to ₹2,00,000/- per year if the house is self-occupied;                                                                                                                                                                 \nThis exemption is available on accrual basis, which means if interest has accrued, you can claim exemption, irrespective of whether you've paid it or not.                                                                  80EE - In finance bill 2016 (an additional rebate of ₹.50.000/- was given to those assesse, who purchase self ocupied single house and loan has sanctioned between 01/04/2016 to 31/03/2018 with maximum value of ₹ 50 Lacs and sanctioned home loan up to 35 Lacs.). The deduction is allowed untill the loan is repaid.                                                                                                                              Sec 80EEA - In Finance bill 2019 ( a new rebate for purchase first house has been introduced to extend the tax benefit upto Rs. 1,50,000/- for affordable house of stamp duty valued up to               Rs. 45 Lacs and loan sanctioned during the period 01/04/2019 to 31/03.2021)                                                                                                                                            "]
["      (b)","If you have rented out your house, Whole the interest will be eligible for deduction. (after deducting property tax and standard maintenance expenses from rent recived). But maximum interest allowed for deduction is 2,00,000/- only and rest of interest will be adjust while filing of ITR as carryforward of losses."]
["VI","u/s 80CCE- Maximum Exemption up to  ₹1,50,000/-  Investments up to ₹1.5 lac in PF, VPF, PPF, Employee contribution in NPS,Insurance Premium, Housing loan principal repayment, NSC, ELSS, long term bank Fixed Deposit, Post Office Term Deposit, etc. are deductible from the taxable income. There is no limit on individual items, (for example) all 1.5 lac can be invested in NSC or PPF etc.  "]
["VII                                                                                                                                                                     ","u/s 80CCD(1):  Contribution to NPS (by Employee) The Finance Act, 2015 provides that, The contribution made by the employee to the NPS will be subject to the limit of ₹1,50,000.(Sec 80CCE)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Section 80CCD (2):  Contribution to NPS (by Employer) - Contribution made by the Central Government or any other employer to NPS shall be excluded while computing the limit of Rs1,50,000 Deduction available for the amount paid or deposited by the employer of the assessee in a pension scheme notified or as may be notified by the Central Government subject to a maximum of 10% of salary in the financial year.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Section 80CCD(1B): Additional depoisiting to New Pension Scheme (NPS) account in Banks/PO  - It will provide an additional deduction of upto ₹ 50,000 over and above the limit of ₹ 1.50 lakh in respect of contributions made to NPS account.\n\n\n"]
["VIII","u/s 80CCG - Rajiv Gandhi Equity Savings Scheme exemption has been abolished in Fianance Act 2017. "]
["IX     ","u/s 80D Medical Insurance Premiums+ Critical Insurance cover Premiuma +Health checkup+ CGHS/ SGHS contributions                                                                                                                                (Mediclaim Insurance & Critical illness Cover from health Insurance Co. or Life Insurance Co. with contribution in CGHS/SGHS & Preventive Health Check upto INR.5000/-) for Self Family & Parents <60 Yrs. or Sr. Citizen. For Very Sr. Citizen abobe 80 Yrs. Expenses on medical treatment.                                                                                                                                                                                                                                                                                           Premium & Health checkup  is exempt up to                                                                                                                                                                                                                                                                                                               1.₹. 25000/- for Self & Family less than 60Yrs.                                                                                                                                                                                                                                                                                 2.₹ 50000/- for Self, Family & Parents below 60 Yrs  (25000/-+25000/-)                                                                                                                                                                                                                               3. ₹ 75000/ for Self, Family & Parents Sr. Citizen –  (25000/-+50000/-)                                                                                                                                                                                                                                                                  4. ₹ 50000/- sr. Citizen above 60 Yrs Self & Family                       "]
["X    ","u/s 80DD Deduction in respect of medical treatment of handicapped dependents is limited to ₹75,000/- per year if the disability is less than 80% and Rs1,25,000/- per year if the disability is more than 80%"]
["XI      ","u/s 80DDB Deduction in respect of medical treatment for specified ailments or diseases for the assesse or dependent can be claimed up to ₹40,000/- per year. If the person being treated is a senior citizen (Age 60+), the exemption can go up to ₹1,00,000/- but any amount received under Medical Insurance Policy will be reduced from the amount of deduction allowed.                                     The Diseases and ailments specified under rule 11DD are.                                                                                                                                                                                                                         (1) Neurological diseases being demetia, dystonia musculorum deformans, motor neuron disease, ataxia, chorea, hemiballismus, aphasia and parkisons disease, (2) cancer, (3) AIDS, (4)Chronic renal failure, (5) hemophilia, and (6) thalassaemia.                                                                                                                                                                                                                                                                                  Note:The assessee will be required to obtain a prescription/Certificate from a specialist doctor whether from Govt or Pvt. for the purpose of availing this deduction. "]
["XII","u/s 80E Interest repayment on education loan (taken for higher education from a university of self & dependents) is completely tax exempt"]
["XIII","u/s 80G Donations given for certain charities are tax exempt.NGO,Trust etc. are exempt to the tune of 50%, whereas Govt funds are 100%.                                                                                                                                                               u/s 80GGA - Donations for scientific, social or statistical research or rural development programme or for carrying out an eligible project or scheme or National Urban Poverty Eradication Fund u/s                                                               80GGC -Donation to any political party/electoral trust   "]
["XIV         New","u/s 80GG If you are not getting  HRA, but living in rented house, an exemption is available. This will be calculated as minimum of (25% of total income or rent paid - 10% of total income or ₹ 60,000/- per year)"]
["XV","u/s 80U who suffers from not less than 40 per cent of any disability is eligible for deduction to the extent of ₹ 75,000/- and in case of severe disability to the extent of ₹ 1,25,000/-"]
["XVI","u/s 80TTA/80TTB introduced through Finance Act, 2012. Section 80TTA provides a deduction of up to ₹10,000 on income from interest on saving bank accounts to Individual asessee and                                                                                                                                                                                                                                                                                                      Sec 80TTB introduced through Finance Act, 2018. Which provides a deduction of up to ₹50,000 on income from interest Income from bank & Post Offices ( Savings,FD, RD, MIS,SCSS etc. ) to Sr. Citizen asessee "]
["Back ↑    ","                                       KNOW MORE about DEDUCTION under Section 80-C and chapter VIA "]
[null,"Section 80C of the Income Tax Act allows certain investments and expenditure to be deduct from total income - One must plan investments well and spread it out across the various instruments specified under this section to avail maximum tax benefit. There are no sub-limits and is irrespective of how much you earn and under which tax bracket you fall. Most of the Income Tax payee try to save tax by saving under Section 80C of the Income Tax Act.  However, it is important to know the Section in total. so that one can make best use of the options available for deduction under income tax Act. One important point to note that one can not only save tax by undertaking the specified investments, but some expenditure which you normally incur can also give you the tax exemptions.\n\n\n\n\n"]
["Back ↑    ","                                         Qualifying Investments u/s 80CCE are"]
["a","Provident Fund (PF) & Voluntary Provident Fund (VPF) PF is automatically deducted from your salary. your contribution [12% of Basic] (i.e., employee’s contribution) is counted towards section 80C investments. You also have the option to contribute additional amounts through voluntary contributions (VPF). Current rate of interest is 8.5% per annum (p.a.) and is tax-free.\n\n\n\n\n"]
["b","Life Insurance Premiums: Any amount that you pay towards life insurance premium in Life Insurance Corporation (LIC) or any other Insurance CO.for yourself, your spouse or your children can also be included in Section 80C deduction. If you are paying premium for more than one insurance policy, all the premiums will be included. also premium paid for ULIP will also be treated as Premium paid for Life Insurance Policies.                                                                                                                                                                                                                        Unit linked Insurance Plan : ULIP stands for Unit linked Saving Schemes. ULIPs cover Life insurance with benefits of equity investments.They have attracted the attention of investors and tax-savers not only because they help us save tax but they also perform well to give decent returns in the long-term.\nIMP : Total Amount Received at Maturity, Survival Benefits, , Withdrawl in Insurance Policies is Tax Free and fully exempteed u/s 10(10D)."]
["c","Public Provident Fund (PPF): Among all the assured returns small saving schemes, Public Provident Fund (PPF) is one of the best. Current rate of interest is 8% tax-free and the normal maturity period is 15 years Minimum amount of contribution is ₹500 and maximum is ₹1,50,000.(New Change) from Finance Act  2014\n\n"]
["d","National Savings Certificate (NSC): National Savings Certificate (NSC) is a 5-Yr small savings instrument eligible for section 80C tax benefit. Rate of interest is  8.58% compounded half-yearly, i.e. If you invest ₹100, it becomes ₹150.90 after five years. The interest accrued every year is liable to tax (i.e. to be included in your taxable income) but the interest is also deemed to be reinvested and thus eligible for section 80C deduction."]
["e","Home Loan Principal Repayment & Stamp Duty and Registration Charges for a home Loan The Equated Monthly Installment (EMI) that you pay every month to repay your home loan consists of two components – Principal and Interest.The principal component of the EMI qualifies for deduction under Sec 80C. Even the interest component can save you significant income tax – but that would be under Section 24 of the Income Tax Act. The amount you pay as stamp duty when you buy a house, and the amount you pay for the registration of the documents of the house can be claimed as deduction under section 80C in the year of purchase of the house.\n\n"]
["f","Tuition  fees  for 2 children  Apart form the above major investments expenses for children’s education (Only Tution Fee (for which you need receipts)), can be claimed as deductions under Sec 80C.\n\n\n\n\n"]
["g","Equity Linked Savings Scheme (ELSS): There are some mutual fund (MF) schemes specially created for offering you tax savings, and these are called Equity Linked Savings Scheme, or ELSS. The investments that you make in ELSS are eligible for deduction under Sec 80C.\n\n"]
["h","5-Yr bank fixed deposits (FDs): Tax-saving fixed deposits (FDs) of scheduled banks with tenure of 5 years are also entitled for section 80C deduction.                                                                                             5-Yr post office time deposit (POTD) scheme: POTDs are similar to bank fixed deposits. Although available for varying time duration like one year, two year, three year and five year, only 5-Yr post-office time deposit (POTD) – which currently offers 7.5 per cent rate of interest –qualifies for tax saving under section 80C. Effective rate works out to be 7.71% per annum (p.a.) as the rate of interest is compounded quarterly but paid annually. The Interest is entirely taxable.\n\n\n\n"]
["i","Pension Funds or Pension Policies – Section 80CCC: This section – Sec 80CCC – stipulates that an investment in pension funds is eligible for deduction from your income. Section 80CCC investment limit is clubbed with the limit of Section 80C – it means that the total deduction available for 80CCC and 80C is ₹1.5 Lakh.This also means that your investment in pension funds upto ₹1.5 Lakh can be claimed as deduction u/s 80CCC. However, as mentioned earlier, the total deduction u/s 80C and 80CCC can not exceed  ₹1.5 Lakh.\n\n\n"]
["j","Infrastructure Bonds: These are also popularly called Infra Bonds. These are issued by infrastructure companies, and not the government. The amount that you invest in these bonds can also be included in Sec 80C deductions.                                                                                                                                                                \nNABARD rural bonds: There are two types of Bonds issued by NABARD (National Bank for Agriculture and Rural Development): NABARD Rural Bonds and Bhavishya Nirman Bonds (BNB). Out of these two, only NABARD Rural Bonds qualify under section 80C.\n\n"]
["k","Senior Citizen Savings Scheme 2004 (SCSS): A recent addition to section 80C list, Senior Citizen Savings Scheme (SCSS) is the most lucrative scheme among all the small savings schemes but is meant only for senior citizens. Current rate of interest is 9% per annum payable quarterly. Please note that the interest is payable quarterly instead of compounded quarterly. Thus, unclaimed interest on these deposits won’t earn any further interest. Interest income is chargeable to tax.\n\n\n\n"]
["l","Sukanya Samridhi Account : Contribution made in a financial year in Sukanya Samriddhi Account will also be eligible for income tax exemption under Section 80C up to a maximum of ₹ 1,50,000/-  "]
[]
["Back ↑    ","Allowed Deductions & Exemptions under New Income Tax Regime "]
[null,"1. Deduction under sub-section (2) of section 80CCD (employer contribution on account of employee in notified pension scheme) if added in Gross salary"]
[null,"2.Transport Allowance granted to Divyang Employee for commute between place of residence and duty"]
[]
[null,"The income tax Exemption on following incomes still available in the new regime "]
[null,"·         Death-cum-retirement benefit"]
[null,"·         Commutations of pensions"]
[null,"·         Leave encashment on retirement"]
[null,"·         Amount received on VRS up to Rs 5 lakh"]
[null,"·         Employee Provident Fund money"]
[null,"·         Money received as scholarship for education"]
[null,"·         Cash received as awards constituted in public interest"]
[null,"·         Short-term withdrawals and maturity amount from the National Pension Scheme"]