{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["partb-form16","Macro-disabled","Sheet3"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"partb-form16","index":0,"n_rows":73,"n_cols":12,"rows_kept":73,"cut":false,"hidden":true,"merged":[[71,5,71,7],[72,5,72,7],[71,2,71,3],[72,2,72,3],[1,1,1,7],[10,2,10,7],[51,2,51,4],[52,2,52,4],[53,2,53,4],[68,1,68,7],[69,1,69,7],[67,2,67,4],[65,2,65,4],[66,2,66,4],[63,2,63,4],[64,2,64,4],[61,2,61,4],[62,2,62,4],[59,2,59,4],[60,2,60,4],[58,2,58,4],[57,2,57,4],[55,2,55,4],[56,2,56,4],[54,2,54,4],[50,2,50,7],[48,2,48,4],[49,2,49,4],[46,2,46,4],[47,1,47,4],[44,2,44,4],[45,2,45,4],[42,2,42,4],[43,2,43,4],[40,2,40,4],[41,2,41,4],[37,2,37,7],[38,1,38,5],[39,2,39,4],[35,2,35,4],[36,2,36,4],[32,2,32,7],[33,2,33,4],[34,2,34,4],[30,2,30,4],[31,2,31,4],[28,2,28,4],[29,2,29,4],[25,2,25,4],[26,2,26,7],[27,2,27,4],[23,2,23,4],[24,2,24,4],[21,2,21,4],[22,2,22,4],[19,2,19,4],[20,2,20,4],[17,2,17,4],[18,2,18,4],[15,2,15,4],[16,2,16,4],[13,2,13,4],[14,2,14,4],[3,1,3,7],[4,2,4,7],[5,2,5,4],[11,2,11,4],[12,2,12,4],[8,2,8,4],[9,2,9,4],[6,2,6,4],[7,2,7,4]]}
[]
[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)",null,null,null,0]
[null,"(b)","Value of perquisites under section 17(2) (as per Form No. 12BA, wherever applicable)",null,null,null,0]
[null,"(c)","Profits in lieu of salary under section 17(3) (as per Form No. 12BA, wherever applicable)",null,null,null,0]
[null,"(d)","Total",null,null,null,null,{"$f":"SUM(G6:G8)","v":0}]
[null,"(e)","Reported total amount of salary received from other employer(s)",null,null,null,null,0]
[null,2,"Less: Allowances to the extent exempt under section 10"]
[null,"(a)","Travel concession or assistance under section 10(5)"]
[null,"(b)","Death-cum-retirement gratuity under section 10(10)"]
[null,"(c)","Commuted value of pension under section 10(10A)"]
[null,"(d)","Cash equivalent of leave salary encashment under section 10(10AA)"]
[null,"(e)","House rent allowance under section 10(13A)"]
[null,"(f)","Amount of any other exemption under section 10"]
[null,null,"clause …"]
[null,null,"clause …"]
[null,null,"clause …"]
[null,null,"clause …"]
[null,null,"clause …"]
[null,null,"…"]
[null,"(g)","Total amount of any other exemption under section 10",null,null,null,{"$f":"SUM(F18:F23)","v":0}]
[null,"(h)","Total amount of exemption claimed under section 10 [2(a) + 2(b) + 2(c) + 2(d) + 2(e) + 2(g)]",null,null,null,null,{"$f":"SUM(G12:G24)","v":0}]
[null,3,"Total amount of salary received from current employer [1(d)-2(h)]",null,null,null,null,{"$f":"H9-H25","v":0}]
[null,4,"Less: Deductions under section 16"]
[null,"(a)","Standard deduction under section 16(ia)"]
[null,"(b)","Entertainment allowance under section 16(ii)"]
[null,"(c)","Tax on employment under section 16(iii)"]
[null,5,"Total amount of deductions under section 16 [4(a)+4(b)+4(c)]",null,null,null,null,{"$f":"SUM(G28:G30)","v":0}]
[null,6,"Income chargeable under the head “Salaries” [(3+1(e)-5]",null,null,null,null,{"$f":"H26+H10-H31","v":0}]
[null,7,"Add: Any other income reported by the employee under as per section 192 (2B)"]
[null,"(a)","Income (or admissible loss) from house property reported by employee offered for TDS"]
[null,"(b)","Income under the head Other Sources offered for TDS"]
[null,8,"Total amount of other income reported by the employee [7(a)+7(b)]",null,null,null,null,{"$f":"G34+G35","v":0}]
[null,9,"Gross total income (6+8)",null,null,null,null,{"$f":"H32+H36","v":0}]
[null,10,"Deductions under Chapter VI-A"]
[null,null,null,null,null,null,"Gross Amount","Deductible Amount"]
[null,"(a)","Deduction in respect of life insurance premia, contributions to provident fund etc. under section 80C"]
[null,"(b)","Deduction in respect of contribution to certain pension funds under section 80CCC"]
[null,"(c)","Deduction in respect of contribution by taxpayer to pension scheme under section 80CCD (1)"]
[null,"(d)","Total deduction under section 80C, 80CCC and 80CCD(1)"]
[null,"(e)","Deductions in respect of amount paid/deposited to notified pension scheme under section 80CCD (1B)"]
[null,"(f)","Deduction in respect of contribution by Employer to pension scheme under section 80CCD (2)"]
[null,"(g)","Deduction in respect of health insurance premia under section 80D"]
[null,"(h)","Deduction in respect of interest on loan taken for higher education under section 80E"]
[null,null,null,null,null,"Gross Amount","Qualifying Amount ","Deductible Amount"]
[null,"(i)","Total Deduction in respect of donations to certain funds, charitable institutions, etc. under section 80G"]
[null,"(j)","Deduction in respect of interest on deposits in savings account under section 80TTA"]
[null,"(k)","Amount deductible under any other provision(s) of Chapter VI-A"]
[null,null,"section …"]
[null,null,"section …"]
[null,null,"section …"]
[null,null,"section …"]
[null,null,"section …"]
[null,null,"section …"]
[null,null,"section …"]
[null,"(l)","Total of amount deductible under any other provision(s) of Chapter VI-A",null,null,{"$f":"SUM(F52:F58)","v":0},{"$f":"SUM(G52:G58)","v":0},0]
[null,11,"Aggregate of deductible amount under Chapter VI-A [10(a) + 10(b) + 10(c) + 10(d) + 10(e) + 10(f) + 10(g) + 10(h) + 10(i) 10(j)+10(l)]",null,null,null,null,{"$f":"H40+H41+H42+H43+H44+H45+H46+H47+H49+H50+H59","v":0}]
[null,12,"Total taxable income (9-11)",null,null,null,null,{"$f":"H37-H60","v":0},null,null,"Rebate","Surcharge"]
[null,13,"Tax on total income",null,null,null,null,{"$f":"K62","v":0},null,null,{"$f":"IF(AND(H61>=250000,(H61<500000)),(H61-250000)*0.05)+IF(AND(H61>=500000,H61<1000000),(12500+(H61-500000)*0.2))+IF(H61>=1000000,(112500+(H61-1000000)*0.3))","v":0},{"$f":"H61-H63","v":0}]
[null,14,"Rebate under section 87A, if applicable",null,null,null,null,{"$f":"K64","v":0},null,null,{"$f":"IF(H61>350000,0,2500)","v":2500}]
[null,15,"Surcharge, wherever applicable",null,null,null,null,{"$f":"L64","v":0},null,null,{"$f":"IF(H62>2500,K63,H62)","v":0},{"$f":"IF(H61<5000001,0,IF(AND(H61>5000000,H61<10000001),L62*0.1,L62*0.15))","v":0}]
[null,16,"Health and education cess",null,null,null,null,{"$f":"(H62-H63+H64)*0.04","v":0}]
[null,17,"Tax payable (13+15+16-14)",null,null,null,null,{"$f":"H62+H64+H65-H63","v":0}]
[null,18,"Less: Relief under section 89 (attach details)",null,null,null,null,0]
[null,19,"Net tax payable (17-18)",null,null,null,null,{"$f":"H66-H67","v":0}]
[null,"Verification"]
[null,"I, ……………………………. ., son/daughter of ………………………………….. working in the capacity of ...........................…(designation) do hereby certify that the information given above is true, complete and correct and is based on the books of account, documents, TDS statements, and other available records."]
[]
[null,"Place",null,null,null,"Signature of person  responsible for deduction of tax)"]
[null,"Date",null,null,null,"Full Name ………."]

{"sheet":"Macro-disabled","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"Macros must be enabled to use this utility"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Download help file on how to enable macros"]
[null,null,null,"http://abcaus.in/macros.pdf"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}