{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Buwa","blank sample"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":2,"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":"Buwa","index":0,"n_rows":137,"n_cols":23,"rows_kept":137,"cut":false,"hidden":false,"merged":[[33,16,33,17],[0,0,0,1],[0,2,0,4],[0,15,0,17],[1,0,1,4],[1,10,1,19],[15,0,15,2],[15,16,15,17],[17,18,17,19],[16,16,16,17],[18,2,18,3],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,13],[18,14,18,15],[18,18,18,19],[19,18,19,19],[16,1,16,15],[17,2,17,3],[17,7,17,8],[17,9,17,10],[17,11,17,13],[17,14,17,15],[18,16,18,17],[19,16,19,17],[20,2,20,3],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,13],[20,14,20,15],[20,18,20,19],[19,2,19,3],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,13],[19,14,19,15],[20,16,20,17],[21,18,21,19],[22,2,22,3],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,13],[22,14,22,15],[22,18,22,19],[21,2,21,3],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,13],[21,14,21,15],[21,16,21,17],[22,16,22,17],[24,2,24,3],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,13],[24,14,24,15],[24,18,24,19],[23,2,23,3],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,13],[23,14,23,15],[23,16,23,17],[24,16,24,17],[26,2,26,3],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,13],[26,14,26,15],[26,18,26,19],[25,2,25,3],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,13],[25,14,25,15],[25,16,25,17],[26,16,26,17],[28,2,28,3],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,13],[28,14,28,15],[28,18,28,19],[27,2,27,3],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,13],[27,14,27,15],[27,16,27,17],[28,16,28,17],[30,2,30,3],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,13],[30,14,30,15],[30,18,30,19],[29,2,29,3],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,13],[29,14,29,15],[29,16,29,17],[30,16,30,17],[32,2,32,3],[32,5,32,6],[32,7,32,8],[32,9,32,10],[32,11,32,13],[32,14,32,15],[32,18,32,19],[31,2,31,3],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,13],[31,14,31,15],[31,16,31,17],[32,16,32,17],[35,5,35,6],[35,7,35,11],[35,13,35,14],[38,0,38,13],[33,2,33,3],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,13],[33,14,33,15],[47,0,47,2],[47,3,47,6],[47,7,47,13],[48,0,48,2],[48,3,48,6],[48,7,48,13],[39,0,39,13],[40,0,40,13],[41,0,41,13],[42,0,42,5],[42,6,42,13],[43,0,46,5],[43,6,46,13],[49,0,49,5],[50,0,50,1],[50,2,50,4],[50,5,50,6],[50,7,50,13],[51,0,51,1],[51,2,51,4],[51,5,51,6],[51,7,51,13],[49,11,49,12],[54,0,54,1],[54,2,54,4],[54,5,54,6],[54,7,54,13],[55,0,55,1],[55,2,55,4],[55,5,55,6],[55,7,55,13],[52,0,52,1],[52,2,52,4],[52,5,52,6],[52,7,52,13],[53,0,53,1],[53,2,53,4],[53,5,53,6],[53,7,53,13],[56,0,56,13],[57,0,57,13],[58,1,58,4],[58,8,58,13],[59,5,59,7],[59,8,62,13],[60,1,60,4],[60,5,60,7],[61,1,61,4],[61,5,61,7],[62,1,62,4],[62,5,62,7],[63,1,63,4],[63,5,63,7],[72,1,72,4],[72,5,72,7],[72,8,72,13],[63,8,63,13],[64,1,64,4],[64,5,64,7],[64,8,67,13],[65,2,65,4],[65,5,65,7],[66,2,66,4],[66,5,66,7],[67,1,67,4],[67,5,67,7],[73,1,73,4],[73,5,73,7],[73,8,73,13],[68,8,68,13],[69,1,69,4],[69,5,69,7],[69,8,71,13],[70,1,70,4],[70,5,70,7],[71,1,71,4],[71,5,71,7],[68,1,68,4],[68,5,68,7],[82,1,82,4],[82,5,82,7],[82,8,82,9],[82,10,82,13],[83,1,83,4],[83,5,83,7],[83,8,83,9],[83,10,83,13],[74,1,74,4],[81,1,81,4],[77,1,77,3],[79,1,79,3],[74,5,81,13],[76,1,76,3],[75,1,75,3],[78,1,78,3],[80,1,80,3],[86,2,86,4],[86,5,86,7],[86,8,86,9],[86,10,86,13],[87,2,87,4],[87,5,87,7],[87,8,87,9],[87,10,87,13],[84,1,84,4],[84,5,84,7],[84,8,84,9],[84,10,84,13],[85,1,85,4],[85,5,85,7],[85,8,85,9],[85,10,85,13],[90,1,90,4],[90,5,90,7],[90,8,90,9],[90,10,90,13],[91,1,91,4],[91,5,91,7],[91,8,91,9],[91,10,91,13],[88,2,88,4],[88,5,88,7],[88,8,88,9],[88,10,88,13],[89,2,89,4],[89,5,89,7],[89,8,89,9],[89,10,89,13],[95,1,95,13],[96,5,96,7],[96,8,96,9],[96,10,96,13],[97,5,97,7],[97,8,97,9],[97,10,97,13],[92,1,92,4],[92,5,92,7],[92,8,92,9],[92,10,92,13],[93,1,93,13],[94,1,94,13],[100,5,100,7],[100,8,100,9],[100,10,100,13],[101,5,101,7],[101,8,101,9],[101,10,101,13],[98,5,98,7],[98,8,98,9],[98,10,98,13],[99,5,99,7],[99,8,99,9],[99,10,99,13],[104,1,104,4],[104,5,104,7],[104,8,104,9],[104,10,104,13],[105,1,105,4],[105,5,105,7],[105,8,105,9],[105,10,105,13],[102,1,102,4],[102,5,102,7],[102,8,102,9],[102,10,102,13],[103,1,103,4],[103,5,103,7],[103,8,103,9],[103,10,103,13],[108,1,108,4],[108,5,108,7],[108,8,108,9],[108,10,108,13],[109,1,109,4],[109,5,109,7],[109,8,109,9],[109,10,109,13],[106,1,106,4],[106,5,106,7],[106,8,106,9],[106,10,106,13],[107,1,107,4],[107,5,107,7],[107,8,107,9],[107,10,107,13],[128,0,128,13],[129,0,129,3],[129,4,129,6],[129,7,129,13],[130,0,130,13],[131,0,131,13],[110,1,110,4],[110,5,110,7],[110,8,110,9],[110,10,110,13],[111,0,111,13],[112,0,112,9],[136,0,136,1],[136,2,136,4],[136,5,136,8],[136,9,136,13],[132,0,132,13],[133,0,135,4],[133,5,134,8],[133,9,134,13],[135,5,135,8],[135,9,135,13],[28,20,28,21],[27,20,27,21],[30,20,30,21],[29,20,29,21],[32,20,32,21],[31,20,31,21],[33,20,33,21],[17,16,17,17],[17,20,17,21],[19,20,19,21],[18,20,18,21],[20,20,20,21],[22,20,22,21],[21,20,21,21],[24,20,24,21],[23,20,23,21],[26,20,26,21],[25,20,25,21],[33,18,33,19],[31,18,31,19],[29,18,29,19],[27,18,27,19],[25,18,25,19],[23,18,23,19]]}
["Name",null,"Shubharaj Buwa, Associate Professor, Political Science",null,null,"FY","2016-04-01","2017-03-01",null,"Gender","M","AY",null,"2017-18","PAN","AEGPB6763H",null,null,"Bank A/c No.",20070193136]
["Basic Salary as on 1/4/2016",null,null,null,null,{"$f":"D4","v":46440},"Grade pay",9000,"CLA",300]
["Sr. No.","Month","Increments","Basic","Grade pay","Total - Basic + Grade pay","DA%","DA","HRA%","HRA","CLA","TA","Principal allowance","Gross","GPF","PT","IT","Cess","TD","NET","Bank amount","Date deposited","Difference"]
[1,"Mar",null,46440,{"$f":"$H$2","v":9000},{"$f":"D4+E4","v":55440},119,{"$f":"ROUND((F4*(G4/100)),0)","v":65974},30,{"$f":"ROUND((F4*($I$4/100)),0)","v":16632},{"$f":"$J$2","v":300},2400,0,{"$f":"F4+H4+J4+K4+L4+M4","v":140746},6000,200,20000,0,{"$f":"SUM(O4:R4)","v":26200},{"$f":"N4-S4","v":114546},114546,"2016-04-02",{"$f":"T4-U4","v":0}]
[2,"Apr",null,{"$f":"D4+C5","v":46440},{"$f":"$H$2","v":9000},55440,119,65974,30,{"$f":"ROUNDUP((F5*($I$4/100)),0)","v":16632},{"$f":"$J$2","v":300},2400,0,{"$f":"F5+H5+J5+K5+L5+M5","v":140746},6000,200,20000,0,26200,114546,114546,"2016-05-02",0]
[3,"May",null,{"$f":"D5+C6","v":46440},9000,55440,119,65974,30,{"$f":"ROUND((F6*($I$6/100)),0)","v":16632},300,0,0,138346,6000,200,20000,0,26200,112146,112146,"2016-06-02",0]
[4,"Jun",null,46440,9000,55440,119,65974,30,{"$f":"ROUND((F7*($I$6/100)),0)","v":16632},300,2400,0,140746,6000,200,20000,0,26200,114546,114546,"2016-07-01",0]
[5,"Jul",{"$f":"MROUND(F7*3%,10)","v":1660},{"$f":"D7+C8","v":48100},9000,57100,119,67949,30,17130,300,2400,0,144879,6000,200,null,0,6200,138679,null,null,138679]
[6,"Aug",null,48100,9000,57100,119,67949,30,17130,300,2400,0,144879,6000,200,null,0,6200,138679,null,null,138679]
[7,"Sep",null,48100,9000,57100,119,67949,30,17130,300,2400,0,144879,6000,200,null,0,6200,138679,null,null,138679]
[8,"Oct",null,48100,9000,57100,119,62647,30,17130,300,2400,0,139577,6000,200,null,0,6200,133377,null,null,133377]
[9,"Nov",null,48100,9000,57100,119,62647,30,17130,300,2400,0,139577,6000,200,null,0,6200,133377,null,null,133377]
[10,"Dec",null,48100,9000,57100,119,67949,30,17130,300,2400,0,144879,6000,200,null,0,6200,138679,null,null,138679]
[11,"Jan",null,48100,9000,57100,119,67949,30,17130,300,2400,0,144879,6000,200,null,0,6200,138679,null,null,138679]
[12,"Feb",null,48100,9000,57100,119,67949,30,17130,300,2400,0,144879,6000,300,null,0,6300,138579,null,null,138579]
[null,null,null,{"$f":"SUM(D4:D15)","v":570560},{"$f":"SUM(E4:E15)","v":108000},{"$f":"SUM(F4:F15)","v":678560},null,{"$f":"SUM(H4:H15)","v":796884},null,{"$f":"SUM(J4:J15)","v":203568},3600,26400,{"$f":"SUM(M4:M15)","v":0},1709012,72000,2500,{"$f":"SUM(Q4:R15)","v":80000},null,154500,1554512]
[null,"Details of DA, Increment, Basic, Grade Pay, HRA, CLA or TA arrears ,GPF and Other income received during this financial year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K111","v":182791}]
[null,"Sr no","Date ",null,"DA and Salary arrears - amount","Details",null,"Date",null,"GPF",null,"Date",null,null,"Other income",null,"Details",null,"Date",null,"Income tax deducted (other than monthly deduction)"]
[null,1,"2016-04-02",null,29352,"6% D.A Arrears",null,null,null,null,null,"2016-05-03",null,null,15554,null,"Exam"]
[null,2,"2016-04-26",null,60013,"6th Pay arrears last installment"]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,null,"Total",null,{"$f":"SUM(E19:E28)","v":89365},null,null,null,null,{"$f":"SUM(J19:J33)","v":0},null,null,null,null,{"$f":"SUM(O19:O33)","v":15554},null,null,null,null,null,{"$f":"SUM(U19:U33)","v":0}]
[]
[null,null,null,null,"Date of birth","1970-07-17",null,"Approximate age (years)",null,null,null,null,null,{"$f":"(TODAY()-F36)/365","v":46.07123287671233}]
[]
[]
["FORM NO.16"]
["{See rule 31(1)(a)}"]
["PART A"]
["Certificate under section 203 of the Income tax Act, 1961 for tax deducted at source on salary."]
["Name and Address of the employer",null,null,null,null,null,"Name and designation of the employee"]
["G. E. Society's, Dr. T. K. Tope Arts & Commerce Night College, Parel, Mumbai: 12.",null,null,null,null,null,{"$f":"C1","v":"Shubharaj Buwa, Associate Professor, Political Science"}]
[]
[]
[]
["PAN / GIR NO.",null,null,"TAN No. of the Deductor",null,null,null,"PAN No. of the Employee"]
[null,null,null,"MUMG09044A",null,null,null,{"$f":"P1","v":"AEGPB6763H"}]
["CIT (TDS) The Commissioner of Income Tax (TDS) Room No. 900A, 9th Floor, K.G. Mittal Ayurvedic Hospital Building,\nCharni Road, Mumbai – 400002\n",null,null,null,null,null,"Assessment Year",{"$f":"N1","v":"2017-18"},"Period","From","2016-04-01","To",null,"2017-03-31"]
["Quarter ",null,"Receipt Numbers of original statements of TDS under sub-section(3) of section 200",null,null,"Amount of tax deducted in respect deducted in respect of employee",null,"Amount of tax deposited/remitted in respect of the employee"]
["Quarter 1"]
["Quarter 2"]
["Quarter 3"]
["Quarter 4"]
["Total"]
["PART B (Refer Note 1)"]
["DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
[1,"Gross Salary",null,null,null,null,null,null,{"$f":"SUM(F59:H62)","v":1798377}]
[null,"(a) Salary as per provision contained in section 17 (1)",null,null,null,{"$f":"N16+E34","v":1798377}]
[null,"(b) Value of perquisites under section 17(2) (as per Form No. 12 BA, whereever applicable)",null,null,null,0]
[null,"(c) Profits in lieu of Salary under section 17(3) (as per Form No. 12BA, whereever applicable)",null,null,null,0]
[null,"(d) Total",null,null,null,{"$f":"SUM(F60:H62)","v":1798377}]
[2,"Less:Allowance to the extent exempt under section 10",null,null,null,null,null,null,{"$f":"F67","v":26400}]
[null,"Allowances"]
[null,"TA",{"$f":"L16","v":26400}]
[null,"Other",0,null,null,{"$f":"SUM(C66:E67)","v":26400}]
[]
[3,"Balance (1-2)",null,null,null,null,null,null,{"$f":"I59-I64","v":1771977}]
[4,"Deductions:"]
[null,"(a)   Entertainment allowance   ",null,null,null,0]
[null,"(b)   Tax on Employment    ",null,null,null,{"$f":"P16","v":2500}]
[5,"Aggregate of 4(a) and (b )",null,null,null,null,null,null,{"$f":"SUM(F71:H72)","v":2500}]
[6,"Income chargeable under head 'salaries' (3-5)",null,null,null,null,null,null,{"$f":"I69-I73","v":1769477}]
[7,"Add: Any other income reported by the employee"]
[null,"Other income",null,null,{"$f":"O34","v":15554}]
[null,"House rent received",null,null,82500]
[null,"Std. ded @ 30% of annual value",null,null,{"$f":"E77*30/100","v":24750}]
[null,"Housing loan interest (other than 1st home)",null,null,258990]
[null,"Income from let out property",null,null,{"$f":"E77-E78-E79","v":-201240}]
[null,"Housing loan interest - self occupied home"]
[]
[8,"Gross total income (6+7)",null,null,null,null,null,null,null,null,{"$f":"I74+E76+E80","v":1583791}]
[9,"Deductions under Chapter VIA"]
[null,"(A) Sections 80C, 80CCC and 80CCD"]
[null,"(a) Sections 80C",null,null,null,null,null,null,"Gross Amount",null,"Deductible Amount"]
[null,"(i)","LIC",null,null,null,null,null,{"$f":"5941+(2552*12)+5736","v":42301},null,{"$f":"I87","v":42301}]
[null,"(ii)","PPF",null,null,null,null,null,0,null,{"$f":"IF(I88<100000,I88,100000)","v":0}]
[null,"(iii)","Housing loan principal",null,null,null,null,null,107970,null,{"$f":"I89","v":107970}]
[null,"(v)","GPF",null,null,null,null,null,{"$f":"O16+J34","v":72000},null,{"$f":"I90","v":72000}]
[null,"(b) Sections 80D Medical Insurance",null,null,null,null,null,null,0,null,{"$f":"I91","v":0}]
[null,"(c) Sections 80TTA  Savings a/c int. upto 10,000 to be deducted",null,null,null,null,null,null,0,null,{"$f":"IF(I92>10000, 10000,I92)","v":0}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I87:J92)","v":222271},null,{"$f":"IF(I93>150000,150000,I93)+K92+K91","v":150000}]
["Note:","1. Aggregate amount deductible under section 80C shall not exceed one lakh fifty thousand rupees."]
[null,"2. Aggregate amount deductible under the three sections, i.e. 80C, 80CCC and 80 CCD, shall not exceed one lakh fifty thousand rupees."]
[null,"(B) Other sections (for e.g.,80E, 80G etc.) under Chapter VIA"]
[null,"I.   Under section 88 (Please specify)",null,null,null,"Gross Amount",null,null,"Qualifying Amount",null,"Deductible Amount"]
[null,"     (a)","Section"]
[null,"     (b)","Section"]
[null,"     (c)","Section"]
[null,"     (d) ","Section"]
[null,"     (e)","Section"]
[null,"Total",null,null,null,{"$f":"SUM(F98:H102)","v":0},null,null,null,null,{"$f":"SUM(K98:N102)","v":0}]
[10,"Aggregate of deductible amounts under Chapter VI-A",null,null,null,{"$f":"K93+K103","v":150000},null,null,null,null,{"$f":"K93","v":150000}]
[11,"Total Income (8 - 10)",null,null,null,null,null,null,null,null,{"$f":"K83-K104","v":1433791}]
[12,"Tax on Total Income",null,null,null,null,null,null,null,null,{"$f":"IF(K105<500001,TAX(K1,K105)-2000,TAX(K1,K105))","v":255137.3}]
[13,"Education cess @ 3%                                                                                                                                                                                            (tax at S.No. 12 )",null,null,null,null,null,null,null,null,{"$f":"K106*3%","v":7654.1189999999997}]
[14,"Tax payable (12 + 13)",null,null,null,null,null,null,null,null,{"$f":"ROUND(K106+K107,0)","v":262791}]
[15,"Relief under section 89 (attach details)",null,null,null,null,null,null,null,null,0]
[16,"Total Income Tax deducted at source",null,null,null,null,null,null,null,null,{"$f":"Q16+U34","v":80000}]
[16,"Tax payable / refundable (14 - 15)",null,null,null,null,null,null,null,null,{"$f":"K108-K109-K110","v":182791}]
["DETAILS OF TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT"]
["(The Employer is to provide transaction-wise details of tax deducted and deposited)"]
["Sr. No.","TDS Rs.","Surcharge               Rs.","Education Cess                          Rs.","Total Tax deposited                        Rs.",null,"Cheque / DD No.                                         (if any)","B S R Code of Bank Branch","Date of which tax deposited (dd/mm/yy)","Transfer Voucher / Challan Identification No."]
[1,{"$f":"Q4","v":20000},0,{"$f":"R4","v":0},{"$f":"SUM(B115+C115+D115)","v":20000}]
[2,20000,0,{"$f":"R5","v":0},{"$f":"SUM(B116+C116+D116)","v":20000}]
[3,20000,0,0,20000]
[4,20000,0,0,20000]
[5,0,0,0,0]
[6,0,0,0,0]
[7,0,0,0,0]
[8,0,0,0,0]
[9,0,0,0,0]
[10,0,0,0,0]
[11,0,0,0,0]
[12,{"$f":"Q15","v":0},{"$f":"S35","v":0},0,0]
[13,{"$f":"U34","v":0},0,0,0]
[null,{"$f":"SUM(B115:B127)","v":80000},{"$f":"SUM(C115:C127)","v":0},0,80000]
["I  Prin. V. B. Rokade,  Son  of  Shri. Baliram S. Rokade  working in the capacity of   PRINCIPAL (designation)"]
["do hereby certify that a sum of   ",null,null,null,{"$f":"E128","v":80000},null,null,{"$f":"SpellNumber(E130)","v":"Eighty  Thousand  Rupees and Zero Paise"}]
["has  been  deducted at source and paid  to  the credit  of  the Central Government. "]
["I further certify that the information given above is true and correct based on the books of account documents "]
["and other available records."]
["Place: Parel, Mumbai: 12",null,null,null,null,"Signature of the person responsible for deduction of tax"]
[]
[null,null,null,null,null,"Full Name",null,null,null,"Prin. V. B. Rokade"]
["Date: ",null,null,null,null,"Designation",null,null,null,"Principal"]

{"sheet":"blank sample","index":1,"n_rows":137,"n_cols":23,"rows_kept":137,"cut":false,"hidden":false,"merged":[[16,1,16,15],[16,16,16,17],[17,2,17,3],[17,7,17,8],[17,9,17,10],[17,11,17,13],[17,14,17,15],[17,16,17,17],[0,0,0,1],[0,2,0,4],[0,15,0,17],[1,0,1,4],[1,10,1,19],[15,0,15,2],[15,16,15,17],[17,18,17,19],[17,20,17,21],[18,2,18,3],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,13],[18,14,18,15],[18,16,18,17],[18,18,18,19],[18,20,18,21],[19,2,19,3],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,13],[19,14,19,15],[19,16,19,17],[19,18,19,19],[19,20,19,21],[20,16,20,17],[20,18,20,19],[20,20,20,21],[21,2,21,3],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,13],[21,14,21,15],[21,16,21,17],[20,2,20,3],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,13],[20,14,20,15],[21,18,21,19],[21,20,21,21],[22,2,22,3],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,13],[22,14,22,15],[22,16,22,17],[22,18,22,19],[22,20,22,21],[23,2,23,3],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,13],[23,14,23,15],[23,16,23,17],[23,18,23,19],[23,20,23,21],[24,16,24,17],[24,18,24,19],[24,20,24,21],[25,2,25,3],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,13],[25,14,25,15],[25,16,25,17],[24,2,24,3],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,13],[24,14,24,15],[25,18,25,19],[25,20,25,21],[26,2,26,3],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,13],[26,14,26,15],[26,16,26,17],[26,18,26,19],[26,20,26,21],[27,2,27,3],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,13],[27,14,27,15],[27,16,27,17],[27,18,27,19],[27,20,27,21],[28,16,28,17],[28,18,28,19],[28,20,28,21],[29,2,29,3],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,13],[29,14,29,15],[29,16,29,17],[28,2,28,3],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,13],[28,14,28,15],[29,18,29,19],[29,20,29,21],[30,2,30,3],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,13],[30,14,30,15],[30,16,30,17],[30,18,30,19],[30,20,30,21],[31,2,31,3],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,13],[31,14,31,15],[31,16,31,17],[31,18,31,19],[31,20,31,21],[33,18,33,19],[33,20,33,21],[35,5,35,6],[35,7,35,11],[35,13,35,14],[38,0,38,13],[32,16,32,17],[32,18,32,19],[32,20,32,21],[33,2,33,3],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,13],[33,14,33,15],[33,16,33,17],[32,2,32,3],[32,5,32,6],[32,7,32,8],[32,9,32,10],[32,11,32,13],[32,14,32,15],[47,0,47,2],[47,3,47,6],[47,7,47,13],[48,0,48,2],[48,3,48,6],[48,7,48,13],[39,0,39,13],[40,0,40,13],[41,0,41,13],[42,0,42,5],[42,6,42,13],[43,0,46,5],[43,6,46,13],[51,0,51,1],[51,2,51,4],[51,5,51,6],[51,7,51,13],[52,0,52,1],[52,2,52,4],[52,5,52,6],[52,7,52,13],[49,0,49,5],[49,11,49,12],[50,0,50,1],[50,2,50,4],[50,5,50,6],[50,7,50,13],[55,0,55,1],[55,2,55,4],[55,5,55,6],[55,7,55,13],[56,0,56,13],[57,0,57,13],[53,0,53,1],[53,2,53,4],[53,5,53,6],[53,7,53,13],[54,0,54,1],[54,2,54,4],[54,5,54,6],[54,7,54,13],[58,1,58,4],[58,8,58,13],[59,5,59,7],[59,8,62,13],[60,1,60,4],[60,5,60,7],[61,1,61,4],[61,5,61,7],[62,1,62,4],[62,5,62,7],[63,1,63,4],[63,5,63,7],[63,8,63,13],[64,1,64,4],[64,5,64,7],[64,8,67,13],[65,2,65,4],[65,5,65,7],[66,2,66,4],[66,5,66,7],[71,1,71,4],[71,5,71,7],[72,1,72,4],[72,5,72,7],[72,8,72,13],[73,1,73,4],[73,5,73,7],[73,8,73,13],[67,1,67,4],[67,5,67,7],[68,1,68,4],[68,5,68,7],[68,8,68,13],[69,1,69,4],[69,5,69,7],[69,8,71,13],[70,1,70,4],[70,5,70,7],[82,1,82,4],[82,5,82,7],[82,8,82,9],[82,10,82,13],[83,1,83,4],[83,5,83,7],[83,8,83,9],[83,10,83,13],[74,1,74,4],[75,1,75,3],[76,1,76,3],[77,1,77,3],[78,1,78,3],[79,1,79,3],[80,1,80,3],[81,1,81,4],[86,2,86,4],[86,5,86,7],[86,8,86,9],[86,10,86,13],[87,2,87,4],[87,5,87,7],[87,8,87,9],[87,10,87,13],[84,1,84,4],[84,5,84,7],[84,8,84,9],[84,10,84,13],[85,1,85,4],[85,5,85,7],[85,8,85,9],[85,10,85,13],[90,1,90,4],[90,5,90,7],[90,8,90,9],[90,10,90,13],[91,1,91,4],[91,5,91,7],[91,8,91,9],[91,10,91,13],[88,2,88,4],[88,5,88,7],[88,8,88,9],[88,10,88,13],[89,2,89,4],[89,5,89,7],[89,8,89,9],[89,10,89,13],[95,1,95,13],[96,5,96,7],[96,8,96,9],[96,10,96,13],[97,5,97,7],[97,8,97,9],[97,10,97,13],[92,1,92,4],[92,5,92,7],[92,8,92,9],[92,10,92,13],[93,1,93,13],[94,1,94,13],[100,5,100,7],[100,8,100,9],[100,10,100,13],[101,5,101,7],[101,8,101,9],[101,10,101,13],[98,5,98,7],[98,8,98,9],[98,10,98,13],[99,5,99,7],[99,8,99,9],[99,10,99,13],[104,1,104,4],[104,5,104,7],[104,8,104,9],[104,10,104,13],[105,1,105,4],[105,5,105,7],[105,8,105,9],[105,10,105,13],[102,1,102,4],[102,5,102,7],[102,8,102,9],[102,10,102,13],[103,1,103,4],[103,5,103,7],[103,8,103,9],[103,10,103,13],[108,5,108,7],[108,8,108,9],[108,10,108,13],[109,1,109,4],[109,5,109,7],[109,8,109,9],[109,10,109,13],[106,1,106,4],[106,5,106,7],[106,8,106,9],[106,10,106,13],[107,1,107,4],[107,5,107,7],[107,8,107,9],[107,10,107,13],[136,0,136,1],[136,2,136,4],[136,5,136,8],[136,9,136,13],[80,5,80,7],[132,0,132,13],[133,0,135,4],[133,5,134,8],[133,9,134,13],[135,5,135,8],[135,9,135,13],[128,0,128,13],[129,0,129,3],[129,4,129,6],[129,7,129,13],[130,0,130,13],[131,0,131,13],[110,1,110,4],[110,5,110,7],[110,8,110,9],[110,10,110,13],[111,0,111,13],[112,0,112,9],[108,1,108,4]]}
["Name",null,null,null,null,"FY","2016-04-01","2017-03-01",null,"Gender","M","AY",null,"2017-18","PAN",null,null,null,"Bank A/c No."]
["Basic Salary as on 1/4/2016",null,null,null,null,{"$f":"D4","v":10000},"Grade pay",9000,"CLA",300]
["Sr. No.","Month","Increments","Basic","Grade pay","Total - Basic + Grade pay","DA%","DA","HRA%","HRA","CLA","TA","Principal allowance","Gross","GPF","PT","IT","Cess","TD","NET","Bank amount","Date deposited","Difference"]
[1,"Mar",null,10000,{"$f":"$H$2","v":9000},{"$f":"D4+E4","v":19000},119,{"$f":"ROUND((F4*(G4/100)),0)","v":22610},30,{"$f":"ROUND((F4*($I$4/100)),0)","v":5700},{"$f":"$J$2","v":300},2400,0,{"$f":"F4+H4+J4+K4+L4+M4","v":50010},6000,200,null,0,{"$f":"SUM(O4:R4)","v":6200},{"$f":"N4-S4","v":43810},null,"2016-04-02",{"$f":"T4-U4","v":43810}]
[2,"Apr",null,{"$f":"D4+C5","v":10000},{"$f":"$H$2","v":9000},19000,119,22610,30,{"$f":"ROUNDUP((F5*($I$4/100)),0)","v":5700},{"$f":"$J$2","v":300},2400,0,{"$f":"F5+H5+J5+K5+L5+M5","v":50010},6000,200,null,0,6200,43810,null,"2016-05-02",43810]
[3,"May",null,{"$f":"D5+C6","v":10000},9000,19000,119,22610,30,{"$f":"ROUND((F6*($I$6/100)),0)","v":5700},300,0,0,47610,6000,200,null,0,6200,41410,null,"2016-06-02",41410]
[4,"Jun",null,10000,9000,19000,119,22610,30,{"$f":"ROUND((F7*($I$6/100)),0)","v":5700},300,2400,0,50010,6000,200,null,0,6200,43810,null,"2016-07-01",43810]
[5,"Jul",{"$f":"MROUND(F7*3%,10)","v":570},{"$f":"D7+C8","v":10570},9000,19570,119,23288,30,5871,300,2400,0,51429,6000,200,null,0,6200,45229,null,null,45229]
[6,"Aug",null,10570,9000,19570,119,23288,30,5871,300,2400,0,51429,6000,200,null,0,6200,45229,null,null,45229]
[7,"Sep",null,10570,9000,19570,119,23288,30,5871,300,2400,0,51429,6000,200,null,0,6200,45229,null,null,45229]
[8,"Oct",null,10570,9000,19570,119,62647,30,5871,300,2400,0,90788,6000,200,null,0,6200,84588,null,null,84588]
[9,"Nov",null,10570,9000,19570,119,62647,30,5871,300,2400,0,90788,6000,200,null,0,6200,84588,null,null,84588]
[10,"Dec",null,10570,9000,19570,119,23288,30,5871,300,2400,0,51429,6000,200,null,0,6200,45229,null,null,45229]
[11,"Jan",null,10570,9000,19570,119,23288,30,5871,300,2400,0,51429,6000,200,null,0,6200,45229,null,null,45229]
[12,"Feb",null,10570,9000,19570,119,23288,30,5871,300,2400,0,51429,6000,300,null,0,6300,45129,null,null,45129]
[null,null,null,{"$f":"SUM(D4:D15)","v":124560},{"$f":"SUM(E4:E15)","v":108000},{"$f":"SUM(F4:F15)","v":232560},null,{"$f":"SUM(H4:H15)","v":355462},null,{"$f":"SUM(J4:J15)","v":69768},3600,26400,{"$f":"SUM(M4:M15)","v":0},687790,72000,2500,{"$f":"SUM(Q4:R15)","v":0},null,74500,613290]
[null,"Details of DA, Increment, Basic, Grade Pay, HRA, CLA or TA arrears ,GPF and Other income received during this financial year",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"K111","v":43649}]
[null,"Sr no","Date ",null,"DA and Salary arrears - amount","Details",null,"Date",null,"GPF",null,"Date",null,null,"Other income",null,"Details",null,"Date",null,"Income tax deducted (other than monthly deduction)"]
[null,1,"2016-04-02",null,0,"6% D.A Arrears",null,null,null,null,null,"2016-05-03",null,null,0,null,"Exam"]
[null,2,"2016-04-26",null,0,"6th Pay arrears last installment"]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,null,"Total",null,{"$f":"SUM(E19:E28)","v":0},null,null,null,null,{"$f":"SUM(J19:J33)","v":0},null,null,null,null,{"$f":"SUM(O19:O33)","v":0},null,null,null,null,null,{"$f":"SUM(U19:U33)","v":0}]
[]
[null,null,null,null,"Date of birth","2016-07-02",null,"Approximate age (years)",null,null,null,null,null,{"$f":"(TODAY()-F36)/365","v":7.9452054794520555E-2}]
[]
[]
["FORM NO.16"]
["{See rule 31(1)(a)}"]
["PART A"]
["Certificate under section 203 of the Income tax Act, 1961 for tax deducted at source on salary."]
["Name and Address of the employer",null,null,null,null,null,"Name and designation of the employee"]
["G. E. Society's, Dr. T. K. Tope Arts & Commerce Night College, Parel, Mumbai: 12.",null,null,null,null,null,{"$f":"C1","v":0}]
[]
[]
[]
["PAN / GIR NO.",null,null,"TAN No. of the Deductor",null,null,null,"PAN No. of the Employee"]
[null,null,null,"MUMG09044A",null,null,null,{"$f":"P1","v":0}]
["CIT (TDS) The Commissioner of Income Tax (TDS) Room No. 900A, 9th Floor, K.G. Mittal Ayurvedic Hospital Building,\nCharni Road, Mumbai – 400002\n",null,null,null,null,null,"Assessment Year",{"$f":"N1","v":"2017-18"},"Period","From","2016-04-01","To",null,"2017-03-31"]
["Quarter ",null,"Receipt Numbers of original statements of TDS under sub-section(3) of section 200",null,null,"Amount of tax deducted in respect deducted in respect of employee",null,"Amount of tax deposited/remitted in respect of the employee"]
["Quarter 1"]
["Quarter 2"]
["Quarter 3"]
["Quarter 4"]
["Total"]
["PART B (Refer Note 1)"]
["DETAILS OF SALARY PAID AND ANY OTHER INCOME AND TAX DEDUCTED"]
[1,"Gross Salary",null,null,null,null,null,null,{"$f":"SUM(F59:H62)","v":687790}]
[null,"(a) Salary as per provision contained in section 17 (1)",null,null,null,{"$f":"N16+E34","v":687790}]
[null,"(b) Value of perquisites under section 17(2) (as per Form No. 12 BA, whereever applicable)",null,null,null,0]
[null,"(c) Profits in lieu of Salary under section 17(3) (as per Form No. 12BA, whereever applicable)",null,null,null,0]
[null,"(d) Total",null,null,null,{"$f":"SUM(F60:H62)","v":687790}]
[2,"Less:Allowance to the extent exempt under section 10",null,null,null,null,null,null,{"$f":"F67","v":26400}]
[null,"Allowances"]
[null,"TA",{"$f":"L16","v":26400}]
[null,"Other",0,null,null,{"$f":"SUM(C66:E67)","v":26400}]
[]
[3,"Balance (1-2)",null,null,null,null,null,null,{"$f":"I59-I64","v":661390}]
[4,"Deductions:"]
[null,"(a)   Entertainment allowance   ",null,null,null,0]
[null,"(b)   Tax on Employment    ",null,null,null,{"$f":"P16","v":2500}]
[5,"Aggregate of 4(a) and (b )",null,null,null,null,null,null,{"$f":"SUM(F71:H72)","v":2500}]
[6,"Income chargeable under head 'salaries' (3-5)",null,null,null,null,null,null,{"$f":"I69-I73","v":658890}]
[7,"Add: Any other income reported by the employee"]
[null,"Other income",null,null,{"$f":"O34","v":0}]
[null,"House rent received",null,null,0]
[null,"Std. ded @ 30% of annual value",null,null,{"$f":"E77*30/100","v":0}]
[null,"Housing loan interest (other than 1st home)",null,null,0]
[null,"Income from let out property",null,null,{"$f":"E77-E78-E79","v":0}]
[null,"Housing loan interest - self occupied home ",null,null,0]
[]
[8,"Gross total income (6+7)",null,null,null,null,null,null,null,null,{"$f":"I74+E76+E80+E81","v":658890}]
[9,"Deductions under Chapter VIA"]
[null,"(A) Sections 80C, 80CCC and 80CCD"]
[null,"(a) Sections 80C",null,null,null,null,null,null,"Gross Amount",null,"Deductible Amount"]
[null,"(i)","LIC",null,null,null,null,null,0,null,{"$f":"I87","v":0}]
[null,"(ii)","PPF",null,null,null,null,null,0,null,{"$f":"IF(I88<100000,I88,100000)","v":0}]
[null,"(iii)","Housing loan principal",null,null,null,null,null,0,null,{"$f":"I89","v":0}]
[null,"(v)","GPF",null,null,null,null,null,{"$f":"O16+J34","v":72000},null,{"$f":"I90","v":72000}]
[null,"(b) Sections 80D Medical Insurance",null,null,null,null,null,null,null,null,{"$f":"I91","v":0}]
[null,"(c) Sections 80TTA  Savings a/c int. upto 10,000 to be deducted",null,null,null,null,null,null,0,null,{"$f":"IF(I92>10000, 10000,I92)","v":0}]
[null,"Total",null,null,null,null,null,null,{"$f":"SUM(I87:J92)","v":72000},null,{"$f":"IF(I93>150000,150000,I93)+K92+K91","v":72000}]
["Note:","1. Aggregate amount deductible under section 80C shall not exceed one lakh fifty thousand rupees."]
[null,"2. Aggregate amount deductible under the three sections, i.e. 80C, 80CCC and 80 CCD, shall not exceed one lakh fifty thousand rupees."]
[null,"(B) Other sections (for e.g.,80E, 80G etc.) under Chapter VIA"]
[null,"I.   Under section 88 (Please specify)",null,null,null,"Gross Amount",null,null,"Qualifying Amount",null,"Deductible Amount"]
[null,"     (a)","Section"]
[null,"     (b)","Section"]
[null,"     (c)","Section"]
[null,"     (d) ","Section"]
[null,"     (e)","Section"]
[null,"Total",null,null,null,{"$f":"SUM(F98:H102)","v":0},null,null,null,null,{"$f":"SUM(K98:N102)","v":0}]
[10,"Aggregate of deductible amounts under Chapter VI-A",null,null,null,{"$f":"K93+K103","v":72000},null,null,null,null,{"$f":"K93","v":72000}]
[11,"Total Income (8 - 10)",null,null,null,null,null,null,null,null,{"$f":"K83-K104","v":586890}]
[12,"Tax on Total Income",null,null,null,null,null,null,null,null,{"$f":"IF(K105<300000,0,IF(K105<500001,TAX(K1,K105)-5000,TAX(K1,K105)))","v":42378}]
[13,"Education cess @ 3%                                                                                                                                                                                            (tax at S.No. 12 )",null,null,null,null,null,null,null,null,{"$f":"K106*3%","v":1271.3399999999999}]
[14,"Tax payable (12 + 13)",null,null,null,null,null,null,null,null,{"$f":"ROUND(K106+K107,0)","v":43649}]
[15,"Relief under section 89 (attach details)",null,null,null,null,null,null,null,null,0]
[16,"Total Income Tax deducted at source",null,null,null,null,null,null,null,null,{"$f":"Q16+U34","v":0}]
[16,"Tax payable / refundable (14 - 15)",null,null,null,null,null,null,null,null,{"$f":"K108-K109-K110","v":43649}]
["DETAILS OF TAX DEDUCTED AND DEPOSITED INTO CENTRAL GOVERNMENT ACCOUNT"]
["(The Employer is to provide transaction-wise details of tax deducted and deposited)"]
["Sr. No.","TDS Rs.","Surcharge               Rs.","Education Cess                          Rs.","Total Tax deposited                        Rs.",null,"Cheque / DD No.                                         (if any)","B S R Code of Bank Branch","Date of which tax deposited (dd/mm/yy)","Transfer Voucher / Challan Identification No."]
[1,{"$f":"Q4","v":0},0,{"$f":"R4","v":0},{"$f":"SUM(B115+C115+D115)","v":0}]
[2,0,0,{"$f":"R5","v":0},{"$f":"SUM(B116+C116+D116)","v":0}]
[3,0,0,0,0]
[4,0,0,0,0]
[5,0,0,0,0]
[6,0,0,0,0]
[7,0,0,0,0]
[8,0,0,0,0]
[9,0,0,0,0]
[10,0,0,0,0]
[11,0,0,0,0]
[12,{"$f":"Q15","v":0},{"$f":"S35","v":0},0,0]
[13,{"$f":"U34","v":0},0,0,0]
[null,{"$f":"SUM(B115:B127)","v":0},{"$f":"SUM(C115:C127)","v":0},0,0]
["I  Prin. V. B. Rokade,  Son  of  Shri. Baliram S. Rokade  working in the capacity of   PRINCIPAL (designation)"]
["do hereby certify that a sum of   ",null,null,null,{"$f":"E128","v":0},null,null,{"$f":"SpellNumber(E130)","v":"Zero Rupees and Zero Paise"}]
["has  been  deducted at source and paid  to  the credit  of  the Central Government. "]
["I further certify that the information given above is true and correct based on the books of account documents "]
["and other available records."]
["Place: Parel, Mumbai: 12",null,null,null,null,"Signature of the person responsible for deduction of tax"]
[]
[null,null,null,null,null,"Full Name",null,null,null,"Prin. V. B. Rokade"]
["Date: ",null,null,null,null,"Designation",null,null,null,"Principal"]