{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Master Data","GA55","COMPUTATION","Form No. 16"],"not_rendered":{"images":2,"external_links":2,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Master Data","index":0,"n_rows":18,"n_cols":19,"rows_kept":18,"merged":[[1,1,1,4],[2,1,2,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4]]}
[]
[null,"MASTER DATA",{"$nulls":15},"L-1","CDEO"]
[null,"PENSION STATEMENT OF THE FINANCIAL YEAR-2022-23",{"$nulls":15},"L-2","DEEO"]
[null," नाम  :","HEERALAL JAT","PPO No.  :",1088877,{"$nulls":12},"L-3","ADEO"]
[null,"MOBILE NUMBER  :",9251356291,"TAN No.  :","JPRC05652D",{"$nulls":12},"L-5","APC"]
[null,"PAN No. :","ABCDE5555H","बैंक खाता संख्या :","51XXXXXXXXX96",{"$nulls":12},"L-6","CBEO"]
[null,"Treasury :","BIKANER","Branch  :","Pali",{"$nulls":12},"L-7","ACBEO-1"]
[null,"Financial Year  :","2022-23","AssessmentYear :","2023-24","परम पूज्य गुरुदेव वासुदेव जी महाराज "]
[{"$nulls":3},"वरिष्ठ नागरिक","60 से 80 वर्ष तक"]
[null,"01 March 2022 Basic Pension (B.P.) (मूल पेंशन) :",{"v":46550,"d":"46,550"},"Commutation (C) :",15516,{"$nulls":12},"L-9","PEEO"]
[{"$nulls":17},"L-13","Head Master"]
[null,"You Tube Video Link",null,"Present By :",{"$nulls":13},"L-14","Lecturer"]
[null,"https://youtu.be/wmRCNVvVD9k",null,"HEERALAL JAT  (Sr. Teacher)",{"$nulls":13},"L-15","Sr. Teacher"]
[{"$nulls":3},"MGGS   BAR (PALI)",{"$nulls":13},"L-16","Teacher L-2"]
[{"$nulls":3},"Chandawal Nagar, Sojat, Dist.- PALI",{"$nulls":13},"L-17","Teacher L-1"]
[null,"https://youtu.be/wmRCNVvVD9k",null,"heeralaljatchandawal@gmail.com",{"$nulls":13},"L-18","Prabodhak"]
[{"$nulls":17},"L-19","PTI - 1"]
[{"$nulls":17},"L-20","PTI - II"]

{"sheet":"GA55","index":1,"n_rows":24,"n_cols":22,"rows_kept":24,"merged":[[0,1,0,17],[1,0,1,2],[1,3,1,4],[1,5,1,7],[1,8,1,10],[1,11,1,13],[1,14,1,17],[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,12],[2,13,2,14],[2,15,2,17],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[3,19,3,21],[22,2,22,4],[22,11,22,17],[23,2,23,4],[23,11,23,17]]}
[null,{"$f":"IF(AND('Master Data'!B3=\"\"),\"\",'Master Data'!B3)","v":"PENSION STATEMENT OF THE FINANCIAL YEAR-2022-23"}]
[" Name :-",null,null,{"$f":"UPPER(IF(AND('Master Data'!C4=\"\"),\"\",'Master Data'!C4))","v":"HEERALAL JAT"},null,"PPO No.  :",null,null,{"$f":"UPPER(IF(AND('Master Data'!E4=\"\"),\"\",'Master Data'!E4))","v":"1088877"},null,null,"MOBILE NUMBER :",null,null,{"$f":"UPPER(IF(AND('Master Data'!C5=\"\"),\"\",'Master Data'!C5))","v":"9251356291"}]
["PAN No. :-",null,{"$f":"UPPER(IF(AND('Master Data'!C6=\"\"),\"\",'Master Data'!C6))","v":"ABCDE5555H"},null,"TAN No : ",null,{"$f":"UPPER(IF(AND('Master Data'!E5=\"\"),\"\",'Master Data'!E5))","v":"JPRC05652D"},null,"Treasury :",null,{"$f":"UPPER(IF(AND('Master Data'!C7=\"\"),\"\",'Master Data'!C7))","v":"BIKANER"},null,null,"Bank A/C. :",null,{"$f":"UPPER(IF(AND('Master Data'!E6=\"\"),\"\",'Master Data'!E6))","v":"51XXXXXXXXX96"}]
["S.N.","Month","Basic (B)","Commutation  (C)","Red Pension","DA","IR","Additional","Med Allw","DH Allw","Other Allw","Arrear","Total Allowance (TA)","TDS\n(INCOME TAX)","Recovery","Other","Total Deduction (TD)","Net Amount",null,"https://youtu.be/V585dbXugiI"]
[{"$nulls":4},"(B-C)",{"$nulls":12},"(TA-TD)"]
[1,"2022-03-01",{"$f":"IFERROR(IF(AND('Master Data'!C10=\"\"),\"\",'Master Data'!C10),\"\")","v":46550},{"$f":"IFERROR(IF(AND('Master Data'!E10=\"\"),\"\",'Master Data'!E10),\"\")","v":15516},{"$f":"IFERROR(IF(B6=\"\",\"\",IF(C6=\"\",\"\",IF(D6=\"\",\"\",SUM(C6-D6)))),\"\")","v":31034},{"$f":"IFERROR(IF(AND(C6=\"\"),\"\",ROUND(C6*31%,0)),\"\")","v":14431},{"$nulls":6},{"$f":"IFERROR(IF(AND(B6=\"\",C6=\"\",E6=\"\",F6=\"\"),\"\",SUM(E6:L6)),\"\")","v":45465},{"$nulls":3},{"$f":"IFERROR(IF(AND(B6=\"\",M6=\"\"),\"\",SUM(N6:P6)),\"\")","v":0},{"$f":"IFERROR(IF(AND(B6=\"\",M6=\"\",Q6=\"\"),\"\",SUM(M6-Q6)),\"\")","v":45465},{"$nulls":3},"SHEET PASSWORD"]
[2,"2022-04-01",{"$f":"IFERROR(IF(AND(C6=\"\"),\"\",C6),\"\")","v":46550},{"$f":"IFERROR(IF(AND(D6=\"\"),\"\",D6),\"\")","v":15516},{"$f":"IFERROR(IF(B7=\"\",\"\",IF(C7=\"\",\"\",IF(D7=\"\",\"\",SUM(C7-D7)))),\"\")","v":31034},{"$f":"IFERROR(IF(AND(C7=\"\"),\"\",ROUND(C7*34%,0)),\"\")","v":15827},{"$f":"IFERROR(IF(AND(G6=\"\"),\"\",G6),\"\")","v":""},"","","","",{"$f":"IFERROR(IF(AND(C6=\"\",C7=\"\"),\"\",ROUND(C6*3%,0))*3,\"\")","v":4191},{"$f":"IFERROR(IF(AND(B7=\"\",C7=\"\",E7=\"\",F7=\"\"),\"\",SUM(E7:L7)),\"\")","v":51052},"",{"$f":"IFERROR(IF(AND(O6=\"\"),\"\",O6),\"\")","v":""},{"$f":"IFERROR(IF(AND(P6=\"\"),\"\",P6),\"\")","v":""},{"$f":"IFERROR(IF(AND(B7=\"\",M7=\"\"),\"\",SUM(N7:P7)),\"\")","v":0},{"$f":"IFERROR(IF(AND(B7=\"\",M7=\"\",Q7=\"\"),\"\",SUM(M7-Q7)),\"\")","v":51052},{"$nulls":3},"Pansioner$2023"]
[3,"2022-05-01",{"$f":"IFERROR(IF(AND(C7=\"\"),\"\",C7),\"\")","v":46550},{"$f":"IFERROR(IF(AND(D7=\"\"),\"\",D7),\"\")","v":15516},31034,{"$f":"IFERROR(IF(AND(C8=\"\"),\"\",ROUND(C8*34%,0)),\"\")","v":15827},{"$f":"IFERROR(IF(AND(G7=\"\"),\"\",G7),\"\")","v":""},{"$f":"IFERROR(IF(AND(H7=\"\"),\"\",H7),\"\")","v":""},{"$f":"IFERROR(IF(AND(I7=\"\"),\"\",I7),\"\")","v":""},{"$f":"IFERROR(IF(AND(J7=\"\"),\"\",J7),\"\")","v":""},{"$f":"IFERROR(IF(AND(K7=\"\"),\"\",K7),\"\")","v":""},null,46861,{"$f":"IFERROR(IF(AND(N7=\"\"),\"\",N7),\"\")","v":""},{"$f":"IFERROR(IF(AND(O7=\"\"),\"\",O7),\"\")","v":""},{"$f":"IFERROR(IF(AND(P7=\"\"),\"\",P7),\"\")","v":""},0,46861]
[4,"2022-06-01",46550,15516,31034,15827,"","","","","",null,46861,"","","",0,46861]
[5,"2022-07-01",46550,15516,31034,15827,"","","","","",null,46861,"","","",0,46861]
[6,"2022-08-01",46550,15516,31034,15827,"","","","","",null,46861,"","","",0,46861]
[7,"2022-09-01",46550,15516,31034,15827,"",{"$f":"IFERROR(IF(AND(H11=\"\"),\"\",H11),\"\")","v":""},"","","",null,46861,"","","",0,46861]
[8,"2022-10-01",46550,15516,31034,{"$f":"IFERROR(IF(AND(C13=\"\"),\"\",ROUND(C13*38%,0)),\"\")","v":17689},"","","","","",{"$f":"IFERROR(IF(AND(C13=\"\",C12=\"\"),\"\",ROUND(C6*4%,0))*3,\"\")","v":5586},54309,"","","",0,54309]
[9,"2022-11-01",46550,15516,31034,{"$f":"IFERROR(IF(AND(C14=\"\"),\"\",ROUND(C14*38%,0)),\"\")","v":17689},"","","","","",null,48723,"","","",0,48723]
[10,"2022-12-01",46550,15516,31034,17689,"","","","","",null,48723,"","","",0,48723]
[11,"2023-01-01",46550,15516,31034,17689,"","","","","",null,48723,"","","",0,48723]
[12,"2023-02-01",46550,15516,31034,17689,"","","","","",null,48723,"","","",0,48723]
[13,{"$nulls":3},"",{"$nulls":7},"",{"$nulls":3},"",""]
[14,{"$nulls":3},"",{"$nulls":7},"",{"$nulls":3},{"$f":"IFERROR(IF(AND(B19=\"\",M19=\"\"),\"\",SUM(N19:P19)),\"\")","v":""},{"$f":"IFERROR(IF(AND(B19=\"\",M19=\"\",Q19=\"\"),\"\",SUM(M19-Q19)),\"\")","v":""}]
[15,{"$nulls":11},"",{"$nulls":3},"",""]
[null,"TOTAL  F",{"$f":"IF(AND($D$2=\"\",$C$3=\"\",$I$2=\"\"),\"\",SUM(C6:C20))","v":558600},{"$f":"IF(AND($D$2=\"\",$C$3=\"\",$I$2=\"\"),\"\",SUM(D6:D20))","v":186192},372408,197838,0,0,0,0,0,9777,580023,0,0,0,0,580023]
[]
[null,null,{"$f":"UPPER(IF(AND('Master Data'!C4=\"\"),\"\",'Master Data'!C4))","v":"HEERALAL JAT"}]
[null,null,"Signature "]

{"sheet":"COMPUTATION","index":2,"n_rows":65,"n_cols":29,"rows_kept":65,"merged":[[0,0,0,14],[1,2,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10],[1,11,1,14],[2,1,2,2],[2,3,2,7],[2,9,2,11],[2,13,2,14],[3,1,3,12],[4,1,4,12],[5,1,5,12],[6,0,8,0],[6,1,6,9],[6,10,6,12],[6,13,7,14],[7,1,7,9],[7,10,7,12],[8,1,8,9],[8,10,8,12],[9,1,9,12],[10,1,10,3],[10,4,10,5],[10,6,10,7],[10,9,10,14],[11,1,11,3],[11,4,11,5],[11,6,11,7],[11,9,11,12],[12,1,12,12],[13,0,26,0],[13,1,13,14],[14,1,14,14],[15,2,15,4],[15,8,15,10],[15,13,25,14],[16,2,16,4],[16,8,16,10],[17,2,17,4],[17,8,17,10],[18,2,18,4],[18,8,18,10],[19,2,19,4],[19,8,19,10],[20,2,20,4],[20,8,20,10],[21,2,21,4],[21,8,21,10],[22,2,22,4],[22,8,22,10],[23,2,23,4],[23,8,23,10],[24,2,24,4],[24,8,24,10],[25,1,25,10],[26,1,26,12],[27,0,40,0],[27,1,27,14],[28,1,28,12],[29,1,29,12],[30,1,30,12],[31,1,31,12],[32,1,32,12],[33,1,33,12],[34,1,34,12],[35,1,35,12],[36,1,36,12],[37,1,37,12],[38,1,38,12],[39,1,39,12],[40,1,40,12],[41,1,41,12],[42,1,42,12],[43,1,43,12],[44,0,57,0],[44,1,44,14],[45,1,45,4],[45,5,45,8],[45,9,45,12],[46,1,46,3],[46,5,46,7],[46,9,46,11],[47,1,47,3],[47,5,47,7],[47,9,47,11],[48,1,48,3],[48,5,48,7],[48,9,48,11],[49,1,49,3],[49,5,49,7],[49,9,49,11],[50,1,50,3],[50,5,50,7],[50,9,50,11],[51,1,51,3],[51,5,51,7],[51,9,51,11],[52,1,52,3],[52,5,52,7],[52,9,52,11],[53,1,53,12],[54,1,54,12],[55,1,55,12],[56,2,56,12],[57,1,57,12],[58,1,58,12],[59,1,59,12],[60,0,61,0],[60,1,61,3],[60,4,60,6],[60,7,60,8],[60,10,60,11],[60,12,60,13],[61,4,61,6],[61,7,61,8],[61,10,61,11],[61,12,61,13],[62,0,62,12],[64,11,64,13]]}
[{"$f":"IF(AND('Master Data'!B3=\"\"),\"\",'Master Data'!B3)","v":"PENSION STATEMENT OF THE FINANCIAL YEAR-2022-23"}]
[null,null,"आयकर गणना प्रपत्र वर्ष -",null,null,{"$f":"IF(AND('Master Data'!C8=\"\"),\"\",'Master Data'!C8)","v":"2022-23"},null,"( कर निर्धारण वर्ष)  - ",null,{"$f":"IF(AND('Master Data'!E8=\"\"),\"\",'Master Data'!E8)","v":"2023-24"},null,"Old Tax Regime"]
[1,"नाम :-",null,{"$f":"UPPER(IF(AND('Master Data'!C4=\"\"),\"\",'Master Data'!C4))","v":"HEERALAL JAT"},{"$nulls":4},"पीपीओ न. :-",{"$f":"UPPER(IF(AND('Master Data'!E4=\"\"),\"\",'Master Data'!E4))","v":"1088877"},null,null,"PAN :",{"$f":"UPPER(IF(AND('Master Data'!C6=\"\"),\"\",'Master Data'!C6))","v":"ABCDE5555H"}]
[2,"आय : वर्ष  2022-23  में प्राप्त कुल आय ( कर योग्य मूल्यों सहित ) ",{"$nulls":11},"रु.",{"$f":"IF('GA55'!M21=\"\",\"\",'GA55'!M21)","v":580023}]
[3," धारा  10(14) के अंतर्गत भत्ते  तथा अन्य भत्ते जो कर मुक्त है I",{"$nulls":11},"रु.",{"$nulls":5},"SHEET PASSWORD"]
[4,"शेष ( 2-3) ",{"$nulls":11},"रु.",{"$f":"SUM(O4-O5)","v":580023},{"$nulls":4},"Pansioner$2023"]
[5,"  (i) मनोरंजन भत्ता धारा  16  (ii) के अंतर्गत ",{"$nulls":8},0]
[null," (ii) व्यवसाय कर  धारा  16  (iii) के अंतर्गत ",{"$nulls":8},0]
[null," (iii) स्टैण्डर्ड डीडेक्सन (Standard Deduction)  50,000  (अधिकतम )",{"$nulls":8},{"$f":"IF($L$2=\"Old Tax Regime\",50000,0)","v":50000},null,null,"रु.",{"$f":"SUM(K7:M9)","v":50000}]
[6,"                                                      शेष ( 4-5) ",{"$nulls":11},"रु.",{"$f":"SUM(O6-O9)","v":530023}]
[7,"बचत खाते पर ब्याज : ",null,null,1000,null,"अन्य स्रोत से आय :",null,0]
[8,"एफडी व अन्य आय पर प्राप्त ब्याज राशि ",null,null,0,null,"Bonds से प्राप्त ब्याज ",null,0,"योग (8 + 9)  ",{"$nulls":3},"रु.",{"$f":"E11+E12+I11+I12","v":1000}]
[9,"सकल आय ",{"$nulls":11},"रु.",{"$f":"O10+O12","v":531023}]
[10,"घटाए कटोतियाँ :- धारा  US 80C, 80CCC,80CCD (1)  "]
[null,"(A) अधिकतम सीमा 1,50,000/- (धारा 80CCE), धारा 80CCD(2), तथा धारा 80CCD(1B) के अतिरिक्त"]
[null,"(i)","राज्य बीमा (SI)",null,null,"रु.",0,"(xi)","राष्ट्रीय बचत पत्र पर अदत ब्याज ",null,null,"रु.",0]
[null,"(ii)","L.I.C.",null,null,"रु.",0,"(xii)","टियुशन फ़ीस",null,null,"रु.",0]
[null,"(iii)","राष्ट्रीय बचत पत्र (NSC)",null,null,"रु.",0,"(xiii)","इक्विटी लिंक सेविंग स्कीम ",null,null,"रु.",0]
[null,"(iv)","लोक भविष्य निधि (PPF)",null,null,"रु.",0,"(xiv)","स्थगत वार्षिकी (Defferred Annuty)",null,null,"रु.",0]
[null,"(v)","राष्ट्रीय बचत पत्र स्कीम (NSS)",null,null,"रु.",0,"(xv)","पी.एल.आई . (PLI)",null,null,"रु.",0]
[null,"(vi)","सामान्य प्रावधायी निधि  GPF)",null,null,"रु.",0,"(xvi)","म्यूच्यूअल फण्ड   ",null,null,"रु.",0]
[null,"(vii)","सामूहिक बीमा प्रीमियम  (G.Ins.)",null,null,"रु.",0,"(xvii)","सुकन्या समृद्धि योजना में जमा राशि",null,null,"रु.",0]
[null,"(viii)","यू एल आई पी / वार्षिक प्लान ",null,null,"रु.",0,"(xviii)","अन्य व फिक्स डिपोजिट  (5 वर्ष हेतु )",null,null,"रु.",0]
[null,"(ix)","गृह ऋण किस्त (HBA Premium)",null,null,"रु.",0,"(xix)"," अन्य राशि जो धारा 80 C के अंतर्गत छुट",null,null,"रु.",0]
[null,"(x)","जीवन बीमा  (Extra LIC)",null,null,"रु.",0,"(xx)","SCSS",null,null,"रु.",0]
[null,"योग  ( i से xx )",{"$nulls":9},"रु.",{"$f":"SUM(G16:G25)+SUM(M16:M25)","v":0}]
[null,"अधिकतम कटोती राशि 1.50 लाख तक :- ",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",IF(M26<150001,ROUND(M26,0),150000),0)","v":0}]
[11,"अन्य कटोतियाँ"]
[null,"1. धारा 80 D चिकित्सा बीमा प्रीमियम  (स्वयं पति पत्नि व बच्चों के लिए रु. 25,000 माता - पिता के लिए रु. 25,000 , सीनियर सिटीजन रु. 50,000 )",{"$nulls":11},"रु.",0]
[null,"2. धारा 80DD विकलांग आश्रितों के चिकित्सा उपचार (अधिकतम 75,000 तथा 80% या अधिक विकलांगता ( 1,25,000)",{"$nulls":11},"रु.",0]
[null,"3. धारा  80DDB विशिष्ट रोगों के उपचार हेतु छुट  (अधिकतम रु. 40,000, सीनियर सिटीजन हेतु रु. 1,00,000)",{"$nulls":11},"रु.",0]
[null,"4. धारा  80E उच्च शिक्षा हेतु लिए गए ऋण का ब्याज ",{"$nulls":11},"रु.",0]
[null,"5. धारा  80EE (First time home boyer who has taken a loan from a recognized financial institution) ",{"$nulls":11},"रु.",0]
[null,"6. धारा  80EEA भारत में पहली बार घर खरीदने पर अतिरिक्त कर कटोती में छुट  1,50,000 तक ",{"$nulls":11},"रु.",0]
[null,"7. धारा  80EEB निजी इस्तेमाल के लिए इलेक्ट्रॉनिक वाहनों पर चुकाए गए ब्याज पर छुट  1,50,000 तक ",{"$nulls":11},"रु.",0]
[null,"8. धारा 80G धर्मार्थ संस्थाओ आदि को दिए दान ( क श्रेणी में  100 प्रतिशत एव ख श्रेणी में 50 प्रतिशत)   (केंद्र एव राज्य सरकार के फण्ड में )",{"$nulls":11},"रु.",0]
[null,"9. धारा 80U स्थाई रूप से शारीरिक असमर्थता की दशा में  (अधिकतम  75,000 तथा अधिनियम 1995 के अनुसार 1,25,000)",{"$nulls":11},"रु.",0]
[null,"10. धारा 80 TTB बचत खाते पर अधिकतम ब्याज पर 50,000 194(IA)  ,  ( वरिष्ठ नागरिकों के लिए ब्याज पर छुट 50000 तक )",{"$nulls":11},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",IF(E11>50000,50000,E11),0)","v":1000}]
[null,"11. धारा 80 GGA अनुमोदित वैज्ञानिक, सामाजिक, ग्रामीण विकास आदि हेतु दिया गया दान ",{"$nulls":11},"रु.",0]
[null,"12. धारा 80 GGC राजनैतिक दलों को दान के रूप में (आय का अधिकतम 10%)",{"$nulls":11},"रु.",0]
[null,"कुल योग 11 ( 1 से 12 तक )",{"$nulls":11},"रु.",{"$f":"SUM(O29:O40)","v":1000}]
[12,"कुल कटोती ( 10+ 11)",{"$nulls":11},"रु.",{"$f":"O27+O41","v":1000}]
[13,"कर योग्य आय ( 9 - 12 )",{"$nulls":11},"रु.",{"$f":"(O13-O42)","v":530023}]
[14,"कुल आय की राशि को सम्पूर्ण करना ( दस के गुणांक में ) धारा  288A",{"$nulls":11},"रु.",{"$f":"ROUND(O43,-1)","v":530020}]
[15,"आयकर की गणना उपर्युक्त कॉलम  15 के आधार पर "]
[null,"सामान्य नागरिक ",{"$nulls":3},"वरिष्ठ नागरिक (60 से 80 वर्ष तक)",{"$nulls":3},"80 वर्ष या अधिक आयु "]
[null,"Up to Rs. 2,50,000",null,null,{"v":0,"d":"0%"},{"$f":"IF($L$2=\"Old Tax Regime\",\"Up to Rs. 3,00,000\",\"Up to Rs. 2,50,000\")","v":"Up to Rs. 3,00,000"},null,null,{"v":0,"d":"0%"},{"$f":"IF($L$2=\"Old Tax Regime\",\"\",\"Up to Rs. 2,50,000\")","v":""},null,null,{"v":0,"d":"0%"},"रु.",0]
[null,"2,50,001  to  5,00,000",null,null,{"v":0.05,"d":"5%"},{"$f":"IF($L$2=\"Old Tax Regime\",\"3,00,001 to 5,00,000\",\" 2,50,001 to  5,00,000\")","v":"3,00,001 to 5,00,000"},null,null,{"v":0.05,"d":"5%"},{"$f":"IF($L$2=\"Old Tax Regime\",\"Up to Rs. 5,00,000\",\"2,50,001 to  5,00,000\")","v":"Up to Rs. 5,00,000"},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\"0%\",\"5%\")","v":"0%"},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",ROUND(IF(O44<=300000,0,IF(O44>=500000,10000,IF(O44<=500000,0+(O44-300000)*0.05))),0),ROUND(IF(O44<300001,0,IF(O44>500000,10000,((O44-300000)*0.05))),0))","v":10000}]
[null,{"$f":"IF($L$2=\"Old Tax Regime\",\"5,00,001 to 10,00,000\",\"5,00,001  to  7,50,000\")","v":"5,00,001 to 10,00,000"},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\"20%\",\"10%\")","v":"20%"},{"$f":"IF($L$2=\"Old Tax Regime\",\"5,00,001 to 10,00,000\",\"5,00,001  to  7,50,000\")","v":"5,00,001 to 10,00,000"},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\"20%\",\"10%\")","v":"20%"},{"$f":"IF($L$2=\"Old Tax Regime\",\"5,00,001 to 10,00,000\",\"5,00,001  to  7,50,000\")","v":"5,00,001 to 10,00,000"},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\"20%\",\"10%\")","v":"20%"},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",ROUND(IF(O44<=500000,0,IF(O44>=1000000,100000,IF(O44<=1000000,(O44-500000)*0.2,\"0\"))),0),ROUND(IF(O44<500001,0,IF(O44>750000,25000,((O44-500000)*0.1))),0))","v":6004}]
[null,{"$f":"IF($L$2=\"Old Tax Regime\",\"Above  10,00,000\",\" 7,50,001 to  10,00,000\")","v":"Above  10,00,000"},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\"30%\",\"15%\")","v":"30%"},{"$f":"IF($L$2=\"Old Tax Regime\",\"Above  10,00,000\",\" 7,50,001 to  10,00,000\")","v":"Above  10,00,000"},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\"30%\",\"15%\")","v":"30%"},{"$f":"IF($L$2=\"Old Tax Regime\",\"Above  10,00,000\",\" 7,50,001 to  10,00,000\")","v":"Above  10,00,000"},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\"30%\",\"15%\")","v":"30%"},"रु.",{"$f":"IF($L$2=\"Old Tax Regime\",ROUND(IF(O44>1000000,(O44-1000000)*0.3,\"0\"),0),ROUND(IF(O44<750001,0,IF(O44>1000000,37500,((O44-750000)*0.15))),0))","v":0}]
[null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"10,00,001 to  12,50,000\")","v":" "},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"20%\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"10,00,001 to  12,50,000\")","v":" "},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"20%\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"10,00,001 to  12,50,000\")","v":" "},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"20%\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"रु.\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\"\",ROUND(IF(O44<1000001,0,IF(O44>1250000,50000,((O44-1000000)*0.2))),0))","v":""}]
[null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"12,50,001 to  15,00,000\")","v":" "},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"25%\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"12,50,001 to  15,00,000\")","v":" "},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"25%\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"12,50,001 to  15,00,000\")","v":" "},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"25%\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"रु.\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\"\",ROUND(IF(O44<1250001,0,IF(O44>1500000,62500,((O44-1250000)*0.25))),0))","v":""}]
[null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"Above Rs. 15,00,000\")","v":" "},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"30%\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"Above Rs. 15,00,000\")","v":" "},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"30%\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"Above Rs. 15,00,000\")","v":" "},null,null,{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"30%\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\" \",\"रु.\")","v":" "},{"$f":"IF($L$2=\"Old Tax Regime\",\"\",ROUND(IF(O44<1500001,0,(O44-1500000)*0.3),0))","v":""}]
[null,"(1) योग आयकर ",{"$nulls":11},"रु.",{"$f":"SUM(O47:O53)","v":16004},{"$nulls":13},{"$f":"ROUND(IF(O44<250001,0,IF(O44>500000,12500,((O44-250000)*0.05))),0)+ROUND(IF(O44<500001,0,IF(O44>750000,25000,((O44-500000)*0.1))),0)+ROUND(IF(O44<750001,0,IF(O44>1000000,37500,((O44-750000)*0.15))),0)+ROUND(IF(O44<1000001,0,IF(O44>1250000,50000,((O44-1000000)*0.2))),0)+ROUND(IF(O44<1250001,0,IF(O44>1500000,62500,((O44-1250000)*0.25))),0)+ROUND(IF(O44<1500001,0,(O44-1500000)*0.3),0)","v":15502}]
[null,"(2) छुट धारा 87(A)  (5 लाख की कर योग्य आय पर आयकर की छुट अधिकतम रु. 12500/- तक)",{"$nulls":11},"रु.",{"$f":"IF(O44>500000,0,IF(O54<12500,O54,12500))","v":0}]
[null,"(3) शेष आयकर  (1-2)",{"$nulls":11},"रु.",{"$f":"O54-O55","v":16004}]
[null,"4)","शिक्षा एवं चिकित्सा उपकर  4% (आयकर पर )",{"$nulls":10},"रु.",{"$f":"ROUND((O56*0.04),0)","v":640}]
[null,"                                                             कुल आयकर  (3-4)",{"$nulls":11},"रु.",{"$f":"SUM(O56:O57)","v":16644}]
[16," घटाइये :-   राहत धारा  89 के तहत  ",{"$nulls":11},"रु.",0]
[17,"कुल शेष आयकर ",{"$nulls":11},"रु.",{"$f":"O58-O59","v":16644}]
[18,"आयकर कटौती \n का विवरण ",null,null,"सितम्बर  2022\nतक कुल राशि ",null,null,"अक्टूम्बर 22 से दिसम्बर 22\nतक कुल राशि ",null,"जनवरी 2023\nराशि ","फरवरी 2023\nराशि ",null,"टी.डी.एस. \nकी राशि ",null,"कुलयोग कॉलम 19 "]
[{"$nulls":4},{"$f":"SUM('GA55'!N6:N12)","v":0},null,null,{"$f":"SUM('GA55'!N13:N15)","v":0},null,{"$f":"'GA55'!N16","v":""},{"$f":"'GA55'!N17","v":""},null,{"$f":"SUM('GA55'!N18:N19)","v":0},null,{"$f":"SUM(E62,H62,J62,K62,M62)","v":0}]
[{"$f":"IF(O60>O62,\"Income Tax Payable\",\"Income Tax Refundable\")","v":"Income Tax Payable"},{"$nulls":12},"रु.",{"$f":"IF(O60>O62,SUM(O60-O62),SUM(O62-O60))","v":16644}]
[]
[{"$nulls":11},"हस्ताक्षर कार्मिक "]

{"sheet":"Form No. 16","index":3,"n_rows":138,"n_cols":18,"rows_kept":138,"merged":[[0,1,0,11],[1,1,1,11],[2,1,2,11],[3,1,3,11],[4,1,4,5],[4,6,4,11],[5,1,5,5],[5,6,5,11],[6,1,6,5],[6,6,6,11],[7,1,7,3],[7,4,7,5],[7,6,7,8],[7,9,7,11],[8,1,8,3],[8,4,8,5],[8,6,8,8],[8,9,8,11],[9,1,9,5],[9,6,9,7],[9,8,9,11],[10,2,10,5],[10,6,11,7],[10,8,10,9],[10,10,10,11],[11,2,11,3],[11,8,11,9],[11,10,11,11],[12,1,12,11],[13,2,13,4],[13,6,13,8],[13,9,13,11],[14,2,14,4],[14,6,14,8],[14,9,14,11],[15,2,15,4],[15,6,15,8],[15,9,15,11],[16,2,16,4],[16,6,16,8],[16,9,16,11],[17,2,17,4],[17,6,17,8],[17,9,17,11],[18,1,18,4],[18,6,18,8],[18,9,18,11],[19,1,19,11],[20,1,20,11],[21,1,22,1],[21,2,22,3],[21,4,21,11],[22,6,22,8],[22,9,22,11],[23,2,23,3],[23,6,23,8],[23,9,23,11],[24,2,24,3],[24,6,24,8],[24,9,24,11],[25,2,25,3],[25,6,25,8],[25,9,25,11],[26,2,26,3],[26,6,26,8],[26,9,26,11],[27,2,27,3],[27,6,27,8],[27,9,27,11],[28,2,28,3],[28,6,28,8],[28,9,28,11],[29,2,29,3],[29,6,29,8],[29,9,29,11],[30,2,30,3],[30,6,30,8],[30,9,30,11],[31,2,31,3],[31,6,31,8],[31,9,31,11],[32,2,32,3],[32,6,32,8],[32,9,32,11],[33,2,33,3],[33,6,33,8],[33,9,33,11],[34,2,34,3],[34,6,34,8],[34,9,34,11],[35,2,35,3],[35,6,35,8],[35,9,35,11],[36,2,36,3],[36,4,36,11],[37,1,37,11],[38,1,38,11],[39,1,40,1],[39,2,40,3],[39,4,39,11],[40,4,40,5],[40,6,40,7],[40,8,40,9],[40,10,40,11],[41,2,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[41,10,41,11],[42,2,42,3],[42,4,42,5],[42,6,42,7],[42,8,42,9],[42,10,42,11],[43,2,43,3],[43,4,43,5],[43,6,43,7],[43,8,43,9],[43,10,43,11],[44,2,44,3],[44,4,44,5],[44,6,44,7],[44,8,44,9],[44,10,44,11],[45,2,45,3],[45,4,45,5],[45,6,45,7],[45,8,45,9],[45,10,45,11],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[46,10,46,11],[47,2,47,3],[47,4,47,5],[47,6,47,7],[47,8,47,9],[47,10,47,11],[48,2,48,3],[48,4,48,5],[48,6,48,7],[48,8,48,9],[48,10,48,11],[49,2,49,3],[49,4,49,5],[49,6,49,7],[49,8,49,9],[49,10,49,11],[50,2,50,3],[50,4,50,5],[50,6,50,7],[50,8,50,9],[50,10,50,11],[51,2,51,3],[51,4,51,5],[51,6,51,7],[51,8,51,9],[51,10,51,11],[52,2,52,3],[52,4,52,5],[52,6,52,7],[52,8,52,9],[52,10,52,11],[53,2,53,3],[53,4,53,11],[54,1,54,11],[55,1,55,11],[56,2,56,4],[56,6,56,9],[56,10,56,11],[57,1,57,2],[57,3,57,5],[57,6,57,11],[58,3,58,7],[58,8,58,11],[59,1,59,11],[60,1,60,11],[61,1,61,2],[61,3,61,4],[61,5,61,11],[62,1,62,2],[62,3,62,4],[62,5,62,11],[63,1,63,2],[63,3,63,4],[63,6,63,11],[64,1,64,11],[65,1,65,11],[66,1,66,5],[66,6,66,7],[66,8,69,9],[66,10,80,11],[67,1,67,5],[67,6,67,7],[68,1,68,5],[68,6,68,7],[69,1,69,5],[69,6,69,7],[70,1,70,5],[70,6,73,7],[70,8,70,9],[71,1,71,5],[71,8,74,9],[72,1,72,5],[73,1,73,3],[74,1,74,3],[74,6,74,7],[75,1,75,5],[75,6,76,7],[75,8,75,9],[76,1,76,5],[76,8,79,9],[77,1,77,2],[77,3,77,5],[77,6,77,7],[78,1,78,2],[78,3,78,5],[78,6,78,7],[79,1,79,2],[79,3,79,5],[79,6,79,7],[80,1,80,5],[80,8,80,9],[81,1,81,5],[81,8,84,9],[81,10,81,11],[82,1,82,5],[82,6,84,7],[83,1,83,4],[84,1,84,4],[85,1,85,4],[85,6,85,7],[85,8,85,9],[86,1,86,9],[86,10,86,11],[87,1,87,11],[88,1,88,11],[89,1,89,5],[89,6,89,7],[89,8,89,9],[89,10,89,11],[90,1,103,1],[90,3,103,3],[90,4,90,5],[90,6,90,7],[90,8,101,9],[90,10,101,11],[91,4,91,5],[91,6,91,7],[92,4,92,5],[92,6,92,7],[93,4,93,5],[93,6,93,7],[94,4,94,5],[94,6,94,7],[95,4,95,5],[95,6,95,7],[96,4,96,5],[96,6,96,7],[97,4,97,5],[97,6,97,7],[98,4,98,5],[98,6,98,7],[99,4,99,5],[99,6,99,7],[100,4,100,5],[100,6,100,7],[101,4,101,5],[101,6,101,7],[102,4,102,5],[102,6,102,7],[102,8,102,9],[102,10,103,11],[103,4,103,5],[103,6,103,7],[103,8,103,9],[104,8,104,10],[105,1,105,11],[106,1,106,5],[106,6,106,7],[106,8,106,9],[106,10,106,11],[107,2,107,5],[107,6,107,7],[107,8,107,9],[107,10,117,11],[108,2,108,5],[108,6,108,7],[108,8,108,9],[109,2,109,5],[109,6,109,7],[109,8,109,9],[110,2,110,5],[110,6,110,7],[110,8,110,9],[111,2,111,5],[111,6,111,7],[111,8,111,9],[112,2,112,5],[112,6,112,7],[112,8,112,9],[113,2,113,5],[113,6,113,7],[113,8,113,9],[114,2,114,5],[114,6,114,7],[114,8,114,9],[115,2,115,5],[115,6,115,7],[115,8,115,9],[116,2,116,5],[116,6,116,7],[116,8,116,9],[117,2,117,5],[117,6,117,7],[117,8,117,9],[118,2,118,5],[118,6,118,7],[118,8,118,9],[118,10,118,11],[119,1,119,9],[119,10,119,11],[120,1,120,3],[120,4,120,9],[120,10,120,11],[121,1,121,9],[121,10,121,11],[122,1,122,9],[122,10,122,11],[123,1,123,9],[123,10,123,11],[124,1,124,9],[124,10,124,11],[125,1,125,9],[125,10,125,11],[126,1,126,9],[126,10,126,11],[127,1,127,9],[127,10,127,11],[128,1,128,9],[128,10,128,11],[129,1,129,9],[129,10,129,11],[130,1,130,11],[131,2,131,4],[131,6,131,9],[131,10,131,11],[132,1,132,2],[132,3,132,5],[132,6,132,11],[133,3,133,7],[133,8,133,11],[134,1,134,11],[135,1,135,2],[135,3,135,4],[135,5,135,11],[136,1,136,2],[136,3,136,4],[136,5,136,11],[137,1,137,2],[137,3,137,4],[137,6,137,11]]}
[null,"FORM NO. 16"]
[null,"[(See Rule 31(1)(a)]"]
[null,"PART-A"]
[null,"Certificate under section 203 of the income-tax act, 1961 for Tax deducted at source on Salary."]
[null,"Name and address of the Employer",{"$nulls":4},"Name and adress of the Employee"]
[{"$nulls":6},{"$f":"'Master Data'!C4","v":"HEERALAL JAT"}]
[]
[null,"PAN of the Deductor",null,null,"TAN of  the Deductor",null,"PAN of the Employee",null,null,"Employee Ref No."]
[{"$nulls":6},{"$f":"'Master Data'!C6","v":"ABCDE5555H"},null,null,{"$f":"'Master Data'!E6","v":"51XXXXXXXXX96"}]
[null,"CIT (TDS)",{"$nulls":4},"Assess. Year",null,"Peroid with the Employer"]
[null,"Adress","The Commissioner of Income Tax, Pali",{"$nulls":3},"2023-24",null,"From",null,"To"]
[null,"City","PALI",null,"PIN Code",306401,null,null,"01-4-2022",null,"31-03-2023"]
[null,"Summary of amount paid/credited and tax deducted at source thereon in respect of the employee"]
[null,"Quarters","Receipt Numbers of original quarterly statements of TDS under sub-secion (3) of section 200",null,null,"Amount paid/ credited","Amount of tax deducted (Rs.)",null,null,"Amount of tax deposited/ remitted (Rs.)",{"$nulls":7},"SHEET PASSWORD"]
[null,"1st ",{"$nulls":4},{"$f":"SUM('GA55'!N6:N8)","v":{"v":0,"d":"Rs. 0"}},null,null,{"$f":"G15+F15","v":{"v":0,"d":"Rs. 0"}},{"$nulls":7},"Pansioner$2023"]
[null,"2nd ",{"$nulls":4},{"$f":"SUM('GA55'!N9:N11)","v":{"v":0,"d":"Rs. 0"}},null,null,{"$f":"G16+F16","v":{"v":0,"d":"Rs. 0"}}]
[null,"3rd  ",{"$nulls":4},{"$f":"SUM('GA55'!N12:N14)","v":{"v":0,"d":"Rs. 0"}},null,null,{"v":0,"d":"Rs. 0"}]
[null,"4th ",{"$nulls":4},{"$f":"SUM('GA55'!N15:N19)","v":{"v":0,"d":"Rs. 0"}},null,null,{"v":0,"d":"Rs. 0"}]
[null,"TOTAL (Rs.)",{"$nulls":3},{"$f":"SUM(F15:F18)","v":{"v":0,"d":"Rs. 0"}},{"$f":"SUM(G15:G18)","v":{"v":0,"d":"Rs. 0"}},null,null,{"$f":"SUM(J15:J18)","v":{"v":0,"d":"Rs. 0"}}]
[null,"I. Details of tax deducted and deposited in the Central Government account through book adjustment"]
[null,"(The Deductor to provide payment-wise details of tax deducted and deposited with respect to the deductee)"]
[null,"S.N.","Tax Deposited in respect of the deductee (Rs)",null,"Book identification number (BIN)"]
[{"$nulls":4},"Receipt numbers of form No. 24G","DDO serial number in Form No. 24G","Date of transfer voucher (dd/mm/yyyy)",null,null,"Status of matching with Form No. 24G"]
[null,1,{"$f":"'GA55'!N6","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},{"$f":"IF(E24>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,2,{"$f":"'GA55'!N7","v":""},{"$nulls":6},{"$f":"IF(E25>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,3,{"$f":"'GA55'!N8","v":""},{"$nulls":6},"-"]
[null,4,{"$f":"'GA55'!N9","v":""},{"$nulls":6},"-"]
[null,5,{"$f":"'GA55'!N10","v":""},{"$nulls":6},"-"]
[null,6,{"$f":"'GA55'!N11","v":""},{"$nulls":6},"-"]
[null,7,{"$f":"'GA55'!N12","v":""},{"$nulls":6},"-"]
[null,8,{"$f":"'GA55'!N13","v":""},{"$nulls":6},"-"]
[null,9,{"$f":"'GA55'!N14","v":""},{"$nulls":6},"-"]
[null,10,{"$f":"'GA55'!N15","v":""},{"$nulls":6},"-"]
[null,11,{"$f":"'GA55'!N16","v":""},{"$nulls":6},"-"]
[null,12,{"$f":"'GA55'!N17","v":""},{"$nulls":6},"-"]
[null,13,{"$f":"'GA55'!N18+'GA55'!N19","v":{"v":0,"d":"Rs. 0"}},{"$nulls":6},"-"]
[null,"Total",{"$f":"SUM(C24:D36)","v":{"v":0,"d":"Rs. 0"}}]
[null,"II. Details of Tax deducted and deposited in Central Government Account through Challan. "]
[null,"(The deducter to provide payment-wise details of tax deducted and deposited with respect to the deductee)"]
[null,"S.N.","Tax Deposited in respect on of the deductee (Rs)",null,"Challan identification number (CIN)"]
[{"$nulls":4},"BSR code of the Bank Branch",null,"Date on which tax deposited (dd/mm/yyyy)",null,"Challan Serial Number",null,"Status of matching with OLTAS"]
[null,1,{"$nulls":8},{"$f":"IF(C42>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,2,{"$nulls":8},{"$f":"IF(C43>\"0\",\"Yes\",\"-\")","v":"-"}]
[null,3,{"$nulls":8},"-"]
[null,4,{"$nulls":8},"-"]
[null,5,{"$nulls":8},"-"]
[null,6,{"$nulls":8},"-"]
[null,7,{"$nulls":8},"-"]
[null,8,{"$nulls":8},"-"]
[null,9,{"$nulls":8},"-"]
[null,10,{"$nulls":8},"-"]
[null,11,{"$nulls":8},"-"]
[null,12,{"$nulls":8},"-"]
[null,"Total",{"$f":"SUM(C42:D53)","v":0}]
[null,":: 2 ::"]
[null,"Verification"]
[null,"I",{"$f":"B6&\",\"","v":","},null,null,"Son/Daughter of ",{"$nulls":4},"working in the "]
[null,"capacity of ",{"$nulls":4},"(designation) do hereby certify that a sum of "]
[null,"Rs. -",{"$f":"J19","v":0},{"$f":"IF(OR(LEN(FLOOR(C59,1))=13,FLOOR(C59,1)<=0),\"Out of range\",PROPER(SUBSTITUTE(CONCATENATE(CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),1,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),2,1)+1,\"\",CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),3,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),2,1))>1,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),3,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),2,1))=0,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),3,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(C59>=10^9,\" billion \",\"\"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),4,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),5,1)+1,\"\",CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),6,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),5,1))>1,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),6,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),5,1))=0,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),6,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),4,3))>0,\" million \",\"\"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),7,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),8,1)+1,\"\",CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),9,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),8,1))>1,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),9,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),8,1))=0,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),9,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\")),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),7,3)),\" thousand \",\"\"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),10,1)+1,\"\",\"one hundred \",\"two hundred \",\"three hundred \",\"four hundred \",\"five hundred \",\"six hundred \",\"seven hundred \",\"eight hundred \",\"nine hundred \"),CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\"),IF(VALUE(MID(TEXT(INT(C59),REPT(0,12)),11,1))=0,CHOOSE(MID(TEXT(INT(C59),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\"),\"\"))),\"  \",\" \")&IF(FLOOR(C59,1)>1,\" Rupees\",\" Rupees\"))&IF(ISERROR(FIND(\".\",C59,1)),\"\",\" and \"&PROPER(IF(LEN(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2))=1,CHOOSE(1*LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2),\"ten\",\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\")&\" Paise\",\"\")&CONCATENATE(CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1)+1,\"\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"ten\",\"eleven\",\"twelve\",\"thirteen\",\"fourteen\",\"fifteen\",\"sixteen\",\"seventeen\",\"eighteen\",\"nineteen\"),\"twenty\",\"thirty\",\"forty\",\"fifty\",\"sixty\",\"seventy\",\"eighty\",\"ninety\"),IF(VALUE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),11,1))>1,CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"-one\",\"-two\",\"-three\",\"-four\",\"-five\",\"-six\",\"-seven\",\"-eight\",\"-nine\")&\" Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)=\"01\",\"one Paise\",IF(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),1)=\"0\",CHOOSE(MID(TEXT(INT(LEFT(TRIM(MID(SUBSTITUTE('[2]16 NO.'!$B$62,\".\",REPT(\" \",255)),255,200)),2)),REPT(0,12)),12,1)+1,\"\",\"one\",\"two\",\"three\",\"four\",\"five\",\"six\",\"seven\",\"eight\",\"nine\")&\" Paise\",\"\")))))))","v":"Out of range"},{"$nulls":4},"(in words) has been deducted "]
[null,"and deposited to the credit of the Central Govt.. I further certify that the information given above is true, complete and correct "]
[null,"and is based on the books of account, documents, TDS statement, TDS deposited and other available records."]
[null,"Place",null,{"$f":"G7","v":0}]
[null,"Date",null,{"$f":"TODAY()","v":"2023-01-16"},null,"Signature of person responsible for deduction of tax"]
[null,"Designation",null,{"$f":"D58","v":0},null,"Full name :",{"$f":"B6","v":0}]
[null,"PART- B (Annexure)"]
[null,"DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
[null,"1. Gross salary"]
[null,"(a) Salary as per provisions contained in section 17(1)",{"$nulls":4},{"$f":"COMPUTATION!O4","v":{"v":580023,"d":"Rs. 580,023.00"}}]
[null,"(b) Value of perquisites u/s 17(2) (as per Form No. 12BA, wherever applicable)"]
[null,"(c) Profits in lieu of salary under section 17(3) (as per Form No. 12BA, wherever applicable)",{"$nulls":4},0]
[null,"(d) Total  (a+b+c)",{"$nulls":6},{"$f":"G68+G69+G70","v":{"v":580023,"d":"Rs. 580,023.00"}}]
[null,"2. Less: Allowance to the extent exempt u/s 10 House Rent Allowance"]
[null,"Allowance"]
[{"$nulls":5},{"$f":"E74","v":0}]
[null,"US10 (14)",{"$nulls":3},0,{"$f":"F74+F75","v":0}]
[null,"3. Balance (1 - 2)",{"$nulls":6},{"$f":"I71-G75","v":{"v":580023,"d":"Rs. 580,023.00"}}]
[null,"4. Deductions: U/s 16"]
[null,"(a)",null,"Standard Deduction (u/s 16 (ia)",null,null,{"$f":"COMPUTATION!K9","v":{"v":50000,"d":"Rs. 50,000.00"}}]
[null,"(b)",null,"Entertainment allowance",null,null,{"$f":"COMPUTATION!K7","v":0}]
[null,"(c)",null,"Tax on employment",null,null,{"$f":"COMPUTATION!K8","v":0}]
[null,"5. Aggregate of 4 (a) and (b)",{"$nulls":6},{"$f":"G79+G80+G78","v":{"v":50000,"d":"Rs. 50,000.00"}}]
[null," Income chargeable under the head \"salaries\" (3-5)",{"$nulls":8},{"$f":"I76-I81","v":{"v":530023,"d":"Rs. 530,023.00"}}]
[null,"6. Add: Any other income reported by employee "]
[null,"FD व  अन्य स्रोत से प्राप्त ब्याज तथा Bond से प्राप्त ब्याज ",{"$nulls":3},{"$f":"COMPUTATION!I12+COMPUTATION!E12","v":0}]
[null,"अन्य स्रोत से आय :",{"$nulls":3},{"$f":"COMPUTATION!I11","v":0}]
[null,"Saving Bank A/C interest",{"$nulls":3},{"$f":"COMPUTATION!E11","v":1000},{"$f":"F84+F85+F86","v":{"v":1000,"d":"Rs. 1,000.00"}},null,{"$f":"F84+F85+F86","v":{"v":1000,"d":"Rs. 1,000.00"}}]
[null,"7. Gross total income ",{"$nulls":8},{"$f":"K82+I86","v":{"v":531023,"d":"Rs. 531,023.00"}}]
[null,"8. Deductions under Chapter VI A"]
[null,"(A) Section 80C, 80CCC and 80CCD"]
[null,"(a) Section 80C",{"$nulls":6},"Gross Amount",null,"Deductible Amount"]
[null,"A",1,"(A)",{"$f":"COMPUTATION!C21","v":"सामान्य प्रावधायी निधि  GPF)"},null,{"$f":"COMPUTATION!G21","v":0}]
[null,null,2,null,"State Insurance",null,{"$f":"COMPUTATION!G16","v":0}]
[null,null,3,null,"Gr. Acc. Insurance",null,{"$f":"COMPUTATION!G22","v":0}]
[null,null,4,null,"LIC + ULIP + PLI",null,{"$f":"COMPUTATION!G17+COMPUTATION!G25+COMPUTATION!G23+COMPUTATION!M22","v":0}]
[null,null,5,null,"PPF",null,{"$f":"COMPUTATION!G19","v":0}]
[null,null,6,null,"Home Loan Installment (Capital)",null,{"$f":"COMPUTATION!G24","v":0}]
[null,null,7,null,"Equity link saving schame + Defferred Annuty",null,{"$f":"COMPUTATION!M20+COMPUTATION!M21","v":0}]
[null,null,8,null,"Pension Plan (US80ccc+US 80CCD)(1)",null,{"$f":"COMPUTATION!M16+COMPUTATION!M17","v":0}]
[null,null,9,null,"Tution Fee",null,{"$f":"COMPUTATION!M19","v":0}]
[null,null,10,null,"NSC + Interest on NSC",null,{"$f":"COMPUTATION!G20+COMPUTATION!M18","v":0}]
[null,null,11,null,"Sukanya Samridhi A/C",null,{"$f":"COMPUTATION!M24","v":0}]
[null,null,12,null,"Fixed Deposit above 5 years",null,{"$f":"COMPUTATION!M25","v":0}]
[null,null,13,null,"Mutual Fund",null,{"$f":"COMPUTATION!M23","v":0},null,{"$f":"SUM(G91:H104)","v":0},null,{"$f":"IF(I103<=150000, I103, 150000)","v":0}]
[null,null,14,null,"SCSS",null,{"$f":"COMPUTATION!M25","v":0},null,"Total Deducation :"]
[{"$nulls":8},"………………… 3"]
[null,":: 3 ::"]
[null,"(B) Other Sections (e.g. 80E, 80G etc.) under Chapter VIA",{"$nulls":4},"Gross Amount",null,"Qualifying amount",null,"Deductible Amount"]
[null,1,"U/S 80D",{"$nulls":3},{"$f":"COMPUTATION!O29","v":0},null,{"$f":"G108","v":0}]
[null,2,"U/S 80DD",{"$nulls":3},{"$f":"COMPUTATION!O30","v":0},null,{"$f":"G109","v":0}]
[null,3,"U/S 80DDB",{"$nulls":3},{"$f":"COMPUTATION!O31","v":0},null,0]
[null,4,"U/S 80E",{"$nulls":3},{"$f":"COMPUTATION!O32","v":0},null,0]
[null,5,"U/S 80EE",{"$nulls":3},{"$f":"COMPUTATION!O33","v":0},null,0]
[null,6,"U/S 80EEA",{"$nulls":3},{"$f":"COMPUTATION!O34","v":0},null,{"$f":"G113","v":0}]
[null,7,"U/S 80EEB",{"$nulls":3},{"$f":"COMPUTATION!O35","v":0},null,0]
[null,8,"U/S 80G",{"$nulls":3},{"$f":"COMPUTATION!O36","v":0},null,{"$f":"G115","v":0}]
[null,9,"U/S 80GGC",{"$nulls":3},{"$f":"COMPUTATION!O40","v":0},null,0]
[null,10,"U/S 80GGA",{"$nulls":3},{"$f":"COMPUTATION!O39","v":0},null,0]
[null,11,"U/S 80U",{"$nulls":3},{"$f":"COMPUTATION!O37","v":0},null,0]
[null,12,"US 80TTB [Exempt Saving Bank Int. Max. RS. 50,000/-]",{"$nulls":3},{"$f":"COMPUTATION!O38","v":{"v":1000,"d":"Rs. 1,000.00"}},null,{"$f":"G119","v":{"v":1000,"d":"Rs. 1,000.00"}},null,{"$f":"ROUND(SUM(I108:J119),0)","v":{"v":1000,"d":"Rs. 1,000.00"}}]
[null,"9. Aggregate of deductible amount under chapter VIA ",{"$nulls":8},{"$f":"ROUND((K103+K119),0)","v":{"v":1000,"d":"Rs. 1,000.00"}}]
[null,"10. Total income (7-9)",null,null,"(Roundup Figures of Rs 10)",{"$nulls":5},{"$f":"ROUND((K87-K120),-1)","v":{"v":530020,"d":"Rs. 530,020.00"}}]
[null,"11. Tax on total income",{"$nulls":8},{"$f":"COMPUTATION!O54","v":{"v":16004,"d":"Rs. 16,004.00"}}]
[null,"12. Rebate U/s 87 A (Taxable Income below Rs. 5,00,000/-)",{"$nulls":8},{"$f":"COMPUTATION!O55","v":0}]
[null,"13. Tax payable (11-12)",{"$nulls":8},{"$f":"K122-K123","v":{"v":16004,"d":"Rs. 16,004.00"}}]
[null,"14. Education & Health cess @ 4% (on tax computed at S.No. 13)",{"$nulls":8},{"$f":"COMPUTATION!O57","v":{"v":640,"d":"Rs. 640.00"}}]
[null,"15. Tax payable (13+14) [Round off U/s 288 B]",{"$nulls":8},{"$f":"K124+K125","v":{"v":16644,"d":"Rs. 16,644.00"}}]
[null,"16. Less:- Relief under section 89 (Attach Form 10E)",{"$nulls":8},{"$f":"COMPUTATION!O59","v":0}]
[null,"17. Tax payable (15-16)",{"$nulls":8},{"$f":"K126-K127","v":{"v":16644,"d":"Rs. 16,644.00"}}]
[null,"18. Tax deducted at source u/s 192 (1)",{"$nulls":8},{"$f":"COMPUTATION!O62","v":0}]
[null,{"$f":"IF(K128>K129,\"Income Tax Payable\",IF(K128<K129,\"Income Tax Refundable\",\"Income Tax Payble/Refundable\"))","v":"Income Tax Payable"},{"$nulls":8},{"$f":"IF(K128>K129,K128-K129,K129-K128)","v":{"v":16644,"d":"Rs. 16,644.00"}}]
[null,"Verification"]
[null,"I",{"$f":"B6&\",\"","v":","},null,null,"Son/Daughter of ",{"$f":"IF(G57=\"\",\"\",G57)","v":""},{"$nulls":3},"working in the "]
[null,"capacity of ",null,{"$f":"D58","v":0},null,null,"(designation) do hereby certify that a sum of "]
[null,"Rs.",{"$f":"K129","v":0},{"$f":"D59","v":"Out of range"},{"$nulls":4},"(in words) has beeen deducted and "]
[null,"deposited to the  credit of the Central Government. I further certify that the information given above is true, complete and correct and is based on the books of account, documents, TDS statement, TDS deposited and other available records."]
[null,"Place",null,{"$f":"D62","v":0}]
[null,"Date",null,{"$f":"TODAY()","v":"2023-01-16"},null,"Signature of person responsible for deduction of tax"]
[null,"Designation",null,{"$f":"D133","v":0},null,"Full name :",{"$f":"B6","v":0}]