{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["New Regime Form 16"],"read":"whole","date_system":"1900"}

{"sheet":"New Regime Form 16","index":0,"n_rows":153,"n_cols":12,"rows_kept":153,"merged":[[0,0,0,11],[1,0,153,0],[1,1,1,11],[2,1,2,11],[3,1,3,11],[4,1,4,11],[5,1,5,11],[6,1,6,11],[7,1,7,11],[8,1,8,8],[8,9,8,10],[9,1,9,6],[9,7,9,11],[10,1,13,6],[10,7,11,11],[12,7,13,11],[14,1,14,3],[14,4,14,6],[14,7,14,11],[15,1,15,3],[15,4,15,6],[15,7,15,11],[16,4,18,6],[16,7,16,9],[16,10,16,11],[17,7,17,8],[17,10,18,11],[18,7,18,8],[20,1,20,2],[20,3,20,5],[20,6,20,7],[20,8,20,10],[21,1,21,2],[21,3,21,5],[21,6,21,7],[21,8,21,10],[22,1,22,2],[22,3,22,5],[22,6,22,7],[22,8,22,10],[23,1,23,2],[23,3,23,5],[23,6,23,7],[23,8,23,10],[24,1,24,2],[24,3,24,5],[24,6,24,7],[24,8,24,10],[25,1,25,2],[25,3,25,5],[25,6,25,7],[25,8,25,10],[26,1,26,11],[27,2,27,4],[27,5,27,11],[28,2,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[29,5,29,6],[29,7,29,8],[29,9,29,10],[30,2,30,4],[30,7,30,8],[30,9,30,10],[31,2,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[32,2,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[33,2,33,4],[34,2,34,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[40,2,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[41,2,41,4],[41,5,41,6],[41,7,41,8],[41,9,41,10],[42,2,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[43,2,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[45,1,45,11],[46,2,46,4],[46,5,46,11],[47,2,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[48,5,48,6],[48,7,48,8],[48,9,48,10],[49,2,49,4],[49,7,49,8],[49,9,49,10],[50,2,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[51,2,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[52,2,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[53,2,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[54,2,54,4],[54,5,54,6],[54,7,54,11],[55,1,55,11],[56,2,56,4],[56,7,56,9],[57,1,57,3],[58,1,58,5],[59,1,60,11],[61,1,61,2],[62,1,62,11],[63,1,63,11],[64,1,64,11],[65,1,65,11],[66,1,66,7],[67,1,67,11],[68,1,68,11],[69,1,69,11],[70,1,70,11],[71,1,71,11],[72,1,72,5],[75,1,75,11],[76,1,76,11],[77,10,77,11],[83,10,83,11],[86,1,86,7],[87,1,87,7],[88,10,88,11],[103,1,103,4],[104,9,104,10],[105,7,105,8],[105,9,105,10],[106,3,106,5],[106,7,106,8],[106,9,106,10],[107,3,107,5],[107,7,107,8],[107,9,107,10],[108,3,108,5],[108,7,108,8],[108,9,108,10],[109,3,109,5],[109,7,109,8],[109,9,109,10],[110,3,110,5],[110,7,110,8],[110,9,110,10],[111,3,111,5],[111,7,111,8],[111,9,111,10],[112,1,112,6],[112,7,112,8],[112,9,112,10],[115,7,115,8],[115,9,115,10],[118,9,118,10],[119,3,119,5],[119,7,119,8],[119,9,119,10],[120,3,120,5],[120,7,120,8],[120,9,120,10],[121,3,121,5],[121,7,121,8],[121,9,121,10],[122,3,122,5],[122,7,122,8],[122,9,122,10],[123,3,123,5],[123,7,123,8],[123,9,123,10],[124,3,124,5],[124,7,124,8],[124,9,124,10],[125,1,126,6],[126,7,126,8],[126,9,126,10],[127,1,127,6],[127,7,127,8],[127,9,127,10],[129,1,129,6],[137,1,138,6],[138,9,138,10],[140,9,140,10],[141,1,141,11],[142,2,142,4],[142,7,142,9],[143,1,143,3],[144,1,144,11],[149,6,149,11],[150,6,150,11],[151,2,151,5],[151,7,151,8],[151,9,151,10],[152,2,152,5],[152,7,152,8],[152,9,152,10]]}
[]
[null,"FORM NO.16"]
[null,"(As New Tax Regime)"]
[null,"[See rule 31 (1) (a)]"]
[null,"Part A"]
[null,"Certificate under section 203 of the Income Tax Act, 1961 for tax deducted"]
[null,"at source from income chargeable under the head “ Salaries “"]
[null,"Calculation as per"]
[{"$nulls":9},"Tax Payer Age Group:-",null,"Below 60 Years"]
[null,"Name and address of the employer",{"$nulls":5},"Name and Designation of the employee"]
[null,"Office: Govt. Sr. School GORDHANPURA (DDO Code :-12345)",{"$nulls":5},"PARMANAND MEGHWAL"]
[]
[{"$nulls":7},"GSSS GORDHANPURA"]
[]
[null,"PAN of the Deducter",null,null,"TAN of the Deducter",null,null,"PAN of the Employee"]
[]
[null,"TDS Circle where annual",{"$nulls":5},"PERIOD",null,null,"Assessment Year"]
[null,"return / statement under",{"$nulls":5},"FROM",null,"TO","2026-27"]
[null,"section 206 is to be filed",{"$nulls":5},"2025-04-01",null,"2026-03-31"]
[null,"Smmary of amount Paid/credited and tax Deducted at source thereon in respect of the Employee"]
[null,"Quarter(s)",null,"Receipt Numbersof Original Quaterly Statements of TDS Under Sub-Section (3) of Section 200",null,null,"Amount Paid cridited",null,"Amount of Tax Deducted (Rs)",null,null,"Amount of Tax Deposited / Remitted (Rs)"]
[null,"Quarter 1",{"$nulls":6},0,null,null,{"$f":"I22","v":0}]
[null,"Quarter 2",{"$nulls":6},0,null,null,{"$f":"I23","v":0}]
[null,"Quarter 3",{"$nulls":6},0,null,null,0]
[null,"Quarter 4",{"$nulls":6},0,null,null,0]
[null,"Total",{"$nulls":4},0,null,{"$f":"SUM(I22:K25)","v":0},null,null,{"$f":"SUM(L22:L25)","v":0}]
[null,"I.DETAILS TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT THROUGH BOOK ADJUSTMENT"]
[null,"S.No","Tax Deposited In Respect",null,null,"Book Identification Number (BIN)"]
[null,null,"of the deducter",null,null,"Receipt Numbers of",null,"DDO Serial No in",null,"Date Of Transfer",null,"Status of Maching"]
[{"$nulls":3},"(Rs)",null,"Form No.24G",null,"Form No.24G",null,"Form No.24G",null,"with Form.No 24G"]
[{"$nulls":9},"(dd/mm/yyyy)"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,"Total (Rs)",0]
[]
[null,"II.DETAILS TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT THROUGH BOOK CHALLAN"]
[null,"S.No","Tax Deposited In Respect",null,null,"Book Identification Number (CIN)"]
[null,null,"of the deducter",null,null,"BRS Code of the",null,"Date on Which",null,"Challana Serial",null,"Status of Maching"]
[{"$nulls":3},"(Rs)",null,"Bank Branch",null,"Tax Deposited",null,"Number",null,"with Form.No 24G"]
[{"$nulls":7},"(dd/mm/yyyy)"]
[null,1,0,{"$nulls":8},0]
[null,2,0,{"$nulls":8},0]
[null,3,0,{"$nulls":8},0]
[null,4,0,{"$nulls":8},0]
[null,"Total (Rs)",0]
[null,"Verification"]
[null,"I,",{"$nulls":3},"Son/Doughter of",{"$nulls":4},"Working In the Capacity Of"]
[{"$nulls":4},"(Designation) do hereby certify that a sum of Rs.",{"$nulls":5},"(in words)"]
[{"$nulls":6},"has beeen deducted at source and paid to the credit of the Central Government."]
[null,"I further certify that the information given above is true and correct based on the book of accounts, documents and TDS Statements, TDS Deposited and other available records."]
[]
[null,"Notes :"]
[null,"1. Government deductors to fill information in item I if tax is paid without production of an income-tax challan and in item II if tax ."]
[null,"is paid accompanied by an income-tax challan"]
[null,"2. Non-Government deductors to fill information in item II."]
[null,"3. The deductor shall furnish the address of the Commissioner of Income-tax (TDS) having jurisdiction as regards TDS"]
[null,"statements of the assessee."]
[null,"4. If an assessee is employed under one employer only during the year, certificate in Form No. 16 issued for the quarter ending on"]
[null,"31st March of the financial year shall contain the details of tax deducted and deposited for all the quarters of the financial year."]
[null,"5. If an assessee is employed under more than one employer during the year, each of the employers shall issue Part"]
[null,"A of the certificate in Form No. 16 pertaining to the period for which such assessee was employed with each of the employers."]
[null,"Part B (Annexure) of the certificate in Form No.16 may be issued by each of the employers or the last employer at the"]
[null,"option of the assessee."]
[null,"6. In items I and II, in column for tax deposited in respect of deductee, furnish total amount of TDS and education cess.\""]
[]
[null,"Part B"]
[null,"DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
[null,"1. Gross Salary *"]
[null,null,"( a ) Salary as per provisions contained in section 17 (1)",{"$nulls":6},{"v":1325000,"d":"₹ 1,325,000.00"}]
[null,null,"( b ) Value of perquisites under section 17 (2)"]
[null,null,"(as per Form No. 12 BA, wherever applicable)",{"$nulls":6},{"v":0,"d":"₹ 0.00"}]
[null,null,"( c ) Profits in lieu of Salary under section 17 (3)"]
[null,null,"(as per Form No. 12 BA, wherever applicable)",{"$nulls":6},{"v":0,"d":"₹ 0.00"}]
[null,null,"( d ) Total",{"$nulls":7},{"$f":"SUM(J79+J80+J82)","v":{"v":1325000,"d":"₹ 1,325,000.00"}}]
[]
[null,"2. Less : Allowance to the extent exempt under section 10"]
[null,"a) HRA {U/s 10 (13-A)}",{"$nulls":7},{"v":0,"d":"₹ 0.00"}]
[null,"b) Other"]
[null,"3. Balance (1-2)",{"$nulls":7},{"$f":"SUM(J87:J88)","v":{"v":0,"d":"₹ 0.00"}},{"$f":"SUM(K84-J89)","v":{"v":1325000,"d":"₹ 1,325,000.00"}}]
[]
[null,"4. Deductions :"]
[null,null,"(a) Standard deduction",{"$nulls":3},"Rs.",{"v":75000,"d":"₹ 75,000.00"},null,{"v":75000,"d":"₹ 75,000.00"}]
[null,null,"(b) Entertainment allowance",{"$nulls":3},"Rs.",{"v":0,"d":"₹ 0.00"}]
[null,null,"(c) Tax on Employment",{"$nulls":3},"Rs.",0]
[null,"5. Aggregate of 4 (a to c)",{"$nulls":7},{"$f":"SUM(J92:J94)","v":{"v":75000,"d":"₹ 75,000.00"}}]
[]
[null,"6. Income chargeable under the Head ‘Salaries’(3-5)",{"$nulls":7},{"$f":"SUM(K89-J95)","v":{"v":1250000,"d":"₹ 1,250,000.00"}}]
[]
[null,"7. Add. : Any other income reported by the employee"]
[null,null,"Less:- Loss From House Properties",{"$nulls":6},0]
[]
[null,"8. Gross total income (6+7)",{"$nulls":9},{"$f":"SUM(J97+J100)","v":{"v":1250000,"d":"₹ 1,250,000.00"}}]
[]
[null,"9. Deductions Under Chapter VIA"]
[null,"A.","Sections 80C,80CC and 80CCD",{"$nulls":4},"Gross Amount",null,"Qualifying Amt.",null,"Deductible Amt."]
[null,"(a)","Sections 80C,80CC and 80CCD(1)"]
[null,1,"(i)","--",null,null,"Rs.",0,null,0,null,0]
[null,2,"(ii)","--",null,null,"Rs.",0,null,0,null,0]
[null,3,"(iii)","--",null,null,"Rs.",0,null,0,null,0]
[null,4,"(iv)","--",null,null,"Rs.",0,null,0,null,0]
[null,5,"(v)","--",null,null,"Rs.",0,null,0,null,0]
[null,6,"(vi)","--",null,null,"Rs.",0,null,0,null,0]
[null,"Aggregate amount deductible under the three sections i.e.80C, 80CCC and 80CCD (Max. 1.50 Lac)",{"$nulls":5},{"$f":"SUM(H107:I112)","v":0},null,{"$f":"SUM(J107:K112)","v":0},null,{"$f":"SUM(L107:L112)","v":0}]
[]
[]
[null,"(b)","Section 80CCD (1B)",{"$nulls":3},"Rs.",0,null,{"$f":"MIN(H116, 50000)","v":0},null,{"$f":"J116","v":0}]
[]
[null,"B.","Other Sections ( e.g. 80E, 80G, 80TTA etc) Under Chapter VIA"]
[{"$nulls":7},"Gross Amount",null,"Qualifying Amt.",null,"Deductible Amt."]
[null,1,"(i)","80CCD2",null,null,"Rs.",0,null,{"$f":"H120","v":0},null,{"$f":"J120","v":0}]
[null,2,"(ii)","--",null,null,"Rs.",0,null,{"$f":"H121","v":0},null,{"$f":"J121","v":0}]
[null,3,"(iii)","--",null,null,"Rs.",0,null,0,null,0]
[null,4,"(iv)","--",null,null,"Rs.",0,null,0,null,0]
[null,5,"(v)","--",null,null,"Rs.",0,null,0,null,0]
[null,6,"(vi)","--",null,null,"Rs.",0,null,0,null,0]
[null,"Aggregate amount deductible under the three sections i.e.80E, 80G, 80TTA"]
[{"$nulls":7},{"$f":"SUM(H120:I125)","v":0},null,{"$f":"SUM(J120:K125)","v":0},null,{"$f":"SUM(L120:L125)","v":0}]
[null,"10. Aggregate of deductible amount under chapter VI-A (A+B)",{"$nulls":5},{"$f":"SUM(H116+H127)","v":{"v":0,"d":"₹ 0.00"}},null,{"$f":"SUM(J116+J127)","v":{"v":0,"d":"₹ 0.00"}},null,{"$f":"SUM(L116+L127)","v":{"v":0,"d":"₹ 0.00"}}]
[]
[null,"11. Total Taxable Income (8-10 ) Nearest Decimal Figure (U/s 288A)",{"$nulls":9},{"$f":"SUM(L102-L128)","v":{"v":1250000,"d":"₹ 1,250,000.00"}}]
[]
[null,"12. Tax on total Income",{"$nulls":9},{"$f":"(IF(L130>400000, (MIN(L130,800000)-400000)*0.05, 0) +\n  IF(L130>800000, (MIN(L130,1200000)-800000)*0.1, 0) +\n  IF(L130>1200000, (MIN(L130,1600000)-1200000)*0.15, 0) +\n  IF(L130>1600000, (MIN(L130,2000000)-1600000)*0.2, 0) +\n  IF(L130>2000000, (MIN(L130,2400000)-2000000)*0.25, 0) +\n  IF(L130>2400000, (L130-2400000)*0.3, 0))","v":{"v":67500,"d":"₹ 67,500.00"}}]
[null,"13. Rebate U/S 87a (Max 60000) Or Marginal Relief (U/S 15 BAC)",{"$nulls":9},{"$f":"IF(L130<=1200000,\n   (IF(L130>400000, (MIN(L130,800000)-400000)*0.05,0) +\n    IF(L130>800000, (MIN(L130,1200000)-800000)*0.1,0) +\n    IF(L130>1200000, (MIN(L130,1600000)-1200000)*0.15,0) +\n    IF(L130>1600000, (MIN(L130,2000000)-1600000)*0.2,0) +\n    IF(L130>2000000, (MIN(L130,2400000)-2000000)*0.25,0) +\n    IF(L130>2400000, (L130-2400000)*0.3,0)),\n\n   IF(L130<=1270588,\n      MAX(0,\n          (IF(L130>400000, (MIN(L130,800000)-400000)*0.05,0) +\n           IF(L130>800000, (MIN(L130,1200000)-800000)*0.1,0) +\n           IF(L130>1200000, (MIN(L130,1600000)-1200000)*0.15,0) +\n           IF(L130>1600000, (MIN(L130,2000000)-1600000)*0.2,0) +\n           IF(L130>2000000, (MIN(L130,2400000)-2000000)*0.25,0) +\n           IF(L130>2400000, (L130-2400000)*0.3,0)\n          ) - (L130-1200000)\n      ),\n      0\n   )\n)","v":{"v":17500,"d":"₹ 17,500.00"}}]
[null,"14. Tax Payable on total income (12-13)",{"$nulls":9},{"$f":"SUM(L132-L133)","v":{"v":50000,"d":"₹ 50,000.00"}}]
[null,"15.Education & Health Cess 4%",{"$nulls":9},{"$f":"L134 * 0.04","v":{"v":2000,"d":"₹ 2,000.00"}}]
[null,"16. Tax payable (14+15)",{"$nulls":9},{"$f":"SUM(L134:L135)","v":{"v":52000,"d":"₹ 52,000.00"}}]
[null,"17. Relife Under Section 89 (attach details)",{"$nulls":9},{"v":0,"d":"₹ 0.00"}]
[null,"18. Tax payable (16-17)"]
[{"$nulls":11},{"$f":"SUM(L136-L137)","v":{"v":52000,"d":"₹ 52,000.00"}}]
[null,"19.Tax Deducted at source U/S 192",{"$nulls":9},{"$f":"L26","v":{"v":0,"d":"₹ 0.00"}}]
[null,"20. Tax payable / refundable (17-18)",{"$nulls":7},{"$f":"IF(L139>L140, \"Tax Payable\", IF(L139<L140, \"Refund\", \"No Tax Due\"))","v":"Tax Payable"},null,{"$f":"ABS(L139-L140)","v":{"v":52000,"d":"₹ 52,000.00"}}]
[null,"Verification"]
[null,"I,",{"$nulls":3},"Son/Doughter of",{"$nulls":4},"Working In the Capacity Of"]
[{"$nulls":4},"(Designation) do hereby certify that the information given above is true correct based on the"]
[null,"book of accounts, documents and TDS Statements, TDS Deposited and other available records."]
[]
[]
[]
[]
[{"$nulls":6},"Signature & Seal of the person responsible"]
[{"$nulls":6},"for deduction of tax"]
[null,"Place:",{"$f":"H13","v":"GSSS GORDHANPURA"},{"$nulls":4},"Full Name :"]
[null,"Date:","2026-06-12",{"$nulls":4},"Designation :"]