{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["General Instruction","Monthwise Income Details","Tax Calculation Old Regime","New Regime"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"General Instruction","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,1,19,1]]}
[]
[null,"Please enable Macros for using this utility"]
[]
[null,"Enabling Macros in Excel:\n--------------------------\nMicrosoft Excel 2007\n----------\n1. Security Warning : Macros have been disabled - Click on \"Option\".\n2. Select 'Enable this content' and click'Ok'\n\n-------------------------\nMicrosoft Excel 2010, 2013 and 2016\n-----------------------------------\n1. Security Warning : Macros have been disabled - Click on 'Enable Content'.\n--------------------------------------------------------\n"]

{"sheet":"Monthwise Income Details","index":1,"n_rows":21,"n_cols":15,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,0,2,14],[19,1,19,6],[18,1,18,6],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[20,7,20,8],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,3,14],[18,7,18,8],[19,7,19,8],[18,10,18,14],[19,10,23,14]]}
[]
[]
["MONTH WISE SELF-DECLARATION FROM INCOME TAX DECLARATION AT SOURCE F.Y. 2021-22"]
[null,"Month","Pay","G.P.","D.A.","H.R.A.","C.C.A.","T.A.","Other Allowances","Gross Total","Deductions"]
[null,null,null,null,null,null,null,null,null,null,"P.F./NPS","G.I.S.","SSS/LIC","H.B.L.","Total Deduction"]
[null,"March",null,null,null,null,null,null,null,{"$f":"SUM(C6:I6)","v":0},null,null,null,null,{"$f":"SUM(K6:N6)","v":0}]
[null,"April",null,null,null,null,null,null,null,{"$f":"SUM(C7:I7)","v":0},null,null,null,null,{"$f":"SUM(K7:N7)","v":0}]
[null,"May",null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"June",null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"July",null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"August",null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"September",null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"October",null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"November",null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"December",null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"January",null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"February",null,null,null,null,null,null,null,0,null,null,null,null,0]
[null,"Total",{"$f":"SUM(C6:C17)","v":0},{"$f":"SUM(D6:D17)","v":0},{"$f":"SUM(E6:E17)","v":0},{"$f":"SUM(F6:F17)","v":0},0,0,0,0,0,0,0,0,0]
["a)","Remuneration",null,null,null,null,null,0,null,null,"Remarks"]
["b)","Other Arrears/ Income up to 31-03-2022",null,null,null,null,null,0]
[null,"Grand Total (With Gross Salary)                            ",null,null,null,null,null,{"$f":"SUM(J18+H19+H20)","v":0}]

{"sheet":"Tax Calculation Old Regime","index":2,"n_rows":75,"n_cols":5,"rows_kept":75,"cut":false,"hidden":false,"merged":[[2,2,2,4],[3,2,3,4],[43,3,43,4],[45,3,45,4],[9,3,9,4],[8,3,8,4],[20,3,20,4],[27,3,27,4]]}
["Sheet_Type","SDF_OLD_REGIME"]
["Version",2]
[null,null,"SELF DECLARATION FORM FOR INCOME TAX DEDUCTION AT SOURCES FOR F.Y. 2021-22"]
[null,null,"To be filled by Employee opting \"Old Tax Regime\""]
[null,null,1,"Assessment Year","2022-23"]
[null,null,2,"Tax Regime","Old"]
[null,null,3,"Name and Employee No."]
[null,null,4,"Date of Birth"]
[null,null,5,"Residential Address"]
[]
[null,null,6,"Designation"]
[null,null,7,"Department"]
[null,null,8,"Permanent Account Number"]
[null,null,9,"Mobile No."]
[null,null,10,"Present Basic Pay"]
[null,null,11,"Anticipated Annual Gross Salary and Allowance including D.A, H.R.A, Adhoc D.A and arrear of pay etc. during the year",{"$f":"'Monthwise Income Details'!H21","v":0}]
[null,null,12,"Add: Value of rent free accommodation(10% of salary*)"]
[null,null,13,"Less: H.R.A (The excess of rent paid over 10%  of the salary on production of house rent receipt)"]
[null,null,14,"Standard Deduction (Rs. 50,000 max.)",{"$f":"MIN(50000,SUM(E16+E17-E18))","v":0}]
[null,null,15,"Income chargeable under the salary ",{"$f":"E16+E17-E18-E19","v":0}]
[null,null,16,"Add: Other Income Allowance"]
[null,null,"(a)","Examination Remuneration, Royalty Honorarium and testing charges etc."]
[null,null,"(b)","N.S.C/Mutual fund interest and any other income."]
[null,null,"(c)","Tuition fees reimbursement."]
[null,null,17,"Total Income ",{"$f":"E20+E22+E23+E24","v":0}]
[null,null,18,"Deduction U/s 24for HBL Interest"]
[null,null,19,"Gross Total Income ",{"$f":"E25-E26","v":0}]
[null,null,20,"Deduction Under Chapter VI-A (80C)"]
[null,null,"(a)","G.P.F./C.P.F./N.P.S.",0]
[null,null,"(b)","S.S.S. (LIC)",0]
[null,null,"(c)","G.I.S.",{"$f":"'Monthwise Income Details'!L18","v":0}]
[null,null,"(d)","N.S.C."]
[null,null,"(e)","N.S.C. Interest"]
[null,null,"(f)","H.B. Loan",{"$f":"'Monthwise Income Details'!N18","v":0}]
[null,null,"(g)","Jeevan Dhara and other annually plan of LIC"]
[null,null,"(h)","N.S.C., U.T.I. /Other"]
[null,null,"(i)","Infrastructure Bond "]
[null,null,"(j)","Tuition Fees"]
[null,null,"(k)","Units of Mutual Fund (ELSS)"]
[null,null,"(l)","Term Deposit in Schedule Bank for  years or more"]
[null,null,"(m)","Others "]
[null,null,"(n)","Section 80CCC"]
[null,null,null,"Total (a to n)",{"$f":"MIN(150000,SUM(E29:E42))","v":0}]
[null,null,null,"(Aggregate amount of deduction U/s 80C, 80CCC & 80CCD cannot exceed Rs. 1,50,000/-)"]
[null,null,"(o)","Section 80 CCD (1B) (cannot exceed Rs. 50000)"]
[null,null,null,"Total amount of (a to n ) and (o) cannot exceed Rs. 2,00,000/-) "]
[null,null,"(p)","Section 80D"]
[null,null,"(q)","Section 80DD"]
[null,null,"(r)","Section 80DDB"]
[null,null,"(s)","Section 80G",0]
[null,null,"(t)","Section 80GG"]
[null,null,"(u)","Section 80E"]
[null,null,"(v)","Section 80EE A"]
[null,null,"(w)","Section 80EE B"]
[null,null,"(x)","Section 80TTA/80TTB"]
[null,null,"(y)","Section  80U"]
[null,null,21,"Total Deduction",{"$f":"SUM(E43+MIN(50000,SUM(E45))+SUM(E47:E56))","v":0}]
[null,null,22,"Net Taxable Income ",{"$f":"E27-MIN(E57,E27)","v":0}]
[null,null,23,"Tax on Total Income",{"$f":"Total_Tax_Old(E58,IF(ISBLANK(E8),TODAY(),E8),E5)","v":0}]
[null,null,24,"Add: Health & Education Cess @4 %",{"$f":"ROUND((4/100)*E59,0)","v":0}]
[null,null,25,"Total Tax Payable",{"$f":"SUM(E59+E60)","v":0}]
[null,null,26,"Less: Rebate u/s 89"]
[null,null,27,"Tax Payable after Rebate u/s 89",{"$f":"E61-E62","v":0}]
[]
[]
[]
[]
[]
[null,null,null,"(Signature of the Employee)"]
[null,null,null,"Name: __________________________________"]
[null,null,null,"Designation:_____________________________"]
[null,null,null,"Department: _____________________________"]
[null,null,null,"Date: ___________________________________          "]
[]
[null,null,null,"Signature of H.O.D________________________"]

{"sheet":"New Regime","index":3,"n_rows":42,"n_cols":5,"rows_kept":42,"cut":false,"hidden":false,"merged":[[8,3,8,4],[9,3,9,4],[19,3,19,4],[3,2,3,4],[2,2,2,4]]}
["Sheet_Type","SDF_NEW_REGIME"]
["Version",1]
[null,null,"SELF DECLARATION FORM FOR INCOME TAX DEDUCTION AT SOURCES FOR F.Y. 2021-22"]
[null,null,"To be filled by Employee opting \"New Tax Regime\""]
[null,null,1,"Assessment Year","2022-23"]
[null,null,2,"Tax Regime","New"]
[null,null,3,"Name and Employee No."]
[null,null,4,"Date of Birth"]
[null,null,5,"Residential Address"]
[]
[null,null,6,"Designation"]
[null,null,7,"Department"]
[null,null,8,"Permanent Account Number"]
[null,null,9,"Mobile No."]
[null,null,10,"Present Basic Pay"]
[null,null,11,"Anticipated Annual Gross Salary and Allowance including D.A, H.R.A, Adhoc D.A and arrear of pay etc. during the year",{"$f":"'Monthwise Income Details'!H21","v":0}]
[null,null,12,"Add: Value of rent free accommodation(10% of salary*)"]
[null,null,13,"Less: Transport Allowance granted to Divyang Employee"]
[null,null,15,"Income chargeable under the salary ",{"$f":"E16+E17-E18","v":0}]
[null,null,16,"Add: Other Income Allowance"]
[null,null,"(a)","Examination Remuneration, Royalty Honorarium and testing charges etc."]
[null,null,"(b)","N.S.C/Mutual fund interest and any other income."]
[null,null,"(c)","Tuition fees reimbursement."]
[null,null,17,"Total Income ",{"$f":"E19+E21+E22+E23","v":0}]
[null,null,19,"Gross Total Income ",{"$f":"E24","v":0}]
[null,null,21,"Total Deduction",{"$f":"0","v":0}]
[null,null,22,"Net Taxable Income ",{"$f":"E25-MIN(E26,E25)","v":0}]
[null,null,23,"Tax on Total Income",{"$f":"Total_Tax(E27,E8,E5)","v":0}]
[null,null,24,"Add: Health & Education Cess @4 %",{"$f":"ROUND((4/100)*E28,0)","v":0}]
[null,null,25,"Total Tax Payable",{"$f":"SUM(E28+E29)","v":0}]
[null,null,26,"Less: Rebate u/s 89"]
[null,null,27,"Tax Payable after Rebate u/s 89",{"$f":"E30-E31","v":0}]
[]
[]
[]
[]
[]
[null,null,null,"(Signature of the Employee)"]
[null,null,null,"Name: ____________________________________"]
[null,null,null,"Designation:________________________________"]
[null,null,null,"Department: _______________________________"]
[null,null,null,"Date: ____________________________                                                     Signature of H.O.D"]