{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Salary sheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Salary sheet","index":0,"n_rows":109,"n_cols":19,"rows_kept":109,"cut":false,"hidden":false,"merged":[[80,8,80,14],[81,8,81,14],[32,1,32,3],[32,8,32,14],[33,1,33,3],[39,8,39,14],[42,8,42,14],[36,8,36,14],[44,1,44,3],[37,8,37,14],[38,1,38,3],[38,8,38,14],[39,1,39,3],[40,1,40,3],[40,8,40,14],[41,1,41,3],[5,3,5,5],[30,8,30,14],[31,1,31,3],[2,1,2,15],[7,3,7,5],[30,1,30,4],[42,1,42,3],[43,1,43,3],[43,8,43,14],[53,1,53,3],[45,1,45,3],[45,8,45,14],[46,1,46,3],[47,1,47,3],[47,8,47,14],[48,1,48,3],[49,1,49,3],[49,8,49,14],[51,1,51,3],[50,1,50,3],[51,8,51,14],[54,1,54,3],[54,8,54,12],[55,1,55,3],[55,8,55,12],[56,1,56,3],[56,8,56,12],[57,1,57,3],[57,8,57,12],[58,1,58,3],[58,8,58,12],[59,1,59,3],[59,8,59,12],[67,8,67,12],[60,1,60,3],[60,8,60,12],[61,1,61,3],[61,8,61,12],[62,1,62,3],[62,8,62,12],[78,8,78,14],[79,8,79,14],[72,8,72,14],[71,1,71,3],[63,1,63,3],[63,8,63,12],[64,1,64,3],[64,8,64,12],[65,1,65,3],[65,8,65,12],[67,1,67,3],[68,8,68,14],[69,1,69,3],[70,8,70,14],[66,1,66,3],[66,8,66,12],[77,1,77,3],[73,1,73,3],[74,1,74,3],[74,8,74,14],[75,1,75,3],[76,1,76,3],[76,8,76,14],[77,8,77,14]]}
[]
[]
[null,"TAX CALCULATION ( 2019 -2020 )"]
[]
[]
[null,"Emp No",{"$nulls":5},"Date of Birth"]
[]
[null,"Employee Name",{"$nulls":5},"PAN",{"$nulls":8},24000]
[]
[null,"Salary from April 2018 to March 2019"]
[]
[null,"Sr No","Pay Compenents (Section 1)","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01","2019-01-01","2019-02-01","2019-03-01","Total"]
[null,null,"Earnings"]
[null,1,"Basic",0,{"$f":"D14","v":0},{"$f":"E14","v":0},0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(D14:O14),0)","v":0}]
[null,2,"House Rent Allowance",0,{"$f":"D15","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,3,"Transport Allowance",0,{"$f":"D16","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,4,"Academic Allowance",0,{"$f":"D17","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"86377*12","v":1036524}]
[null,5,"Medical Allowance",0,{"$f":"D18","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"ROUND(S17*5%,0)","v":51826}]
[null,6,"Leave Travel Allowance",0,{"$f":"D19","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,86377]
[null,7,"Children Education Allowance",0,{"$f":"D20","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(D20:O20),0)","v":0},null,null,{"$f":"SUM(S17:S19)","v":1174727}]
[null,8,"Bonus",0,{"$f":"D21","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,9600]
[null,9,"Other Allowance",0,{"$f":"D22","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"S18","v":51826}]
[null,null,"Total Earnings ( A )",{"$f":"SUM(D14:D22)","v":0},{"$f":"SUM(E14:E22)","v":0},0,{"$f":"SUM(G14:G22)","v":0},{"$f":"SUM(H14:H22)","v":0},0,{"$f":"SUM(J14:J22)","v":0},0,0,{"$f":"SUM(M14:M22)","v":0},0,{"$f":"SUM(O14:O22)","v":0},{"$f":"SUM(P14:P22)","v":0},null,null,150000]
[{"$nulls":18},100000]
[null,1,"Rent Paid",0,{"$f":"D25","v":0},{"$f":"E25","v":0},0,0,0,0,0,0,0,{"$f":"M25","v":0},0,{"$f":"SUM(D25:O25)","v":0},null,null,15000]
[null,null,"Metro/Non-metro (M or N)","M",{"$f":"D26","v":"M"},"M","M","M","M","M","M","M","M","M","M",null,null,null,{"$f":"S20-SUM(S21:S25)","v":848301}]
[{"$nulls":18},{"$f":"S26-500000","v":348301}]
[{"$nulls":18},{"$f":"ROUND(S27*20%,0)","v":69660}]
[{"$nulls":18},{"$f":"S28+30000","v":99660}]
[]
[null,"Income Tax Declarations- (Section 2)",{"$nulls":6},"Income Tax Computations"]
[null,"Medical Bills Submitted",null,null,0]
[null,"Leave Travel Allowance Bills Submitted",null,null,0,null,null,null,"Gross Salary ",{"$nulls":6},{"$f":"P23","v":0}]
[null,"Number of school going children",null,null,0]
[{"$nulls":8},"Conveyance Allowance",{"$nulls":6},{"$f":"P91","v":0}]
[null,null,null,"Hostel","Yes",null,null,null,"House Rent Allowance :exemption u/s 10(13A)",{"$nulls":6},{"$f":"Q99","v":0}]
[null,null,null,"No",0,null,null,null,"Leave Travel Allowance",{"$nulls":6},{"$f":"+E33","v":0}]
[{"$nulls":8},"Medical Reimbursement (Maxi Exemption 15000)",{"$nulls":6},{"$f":"E32","v":0}]
[null,"Deduction Under Section Chapter VIA",null,null,"Amount",null,null,null,"Children Education Allowance",{"$nulls":6},{"$f":"IF(E36=\"Yes\",E37,0)*300*12+(E34*100*12)","v":0}]
[null,"Employees Provident Fund",null,null,0,null,null,null,"Total:Allowances exempted",{"$nulls":6},{"$f":"SUM(P35:P39)","v":0}]
[null,"Public Provident Fund",null,null,0,null,null,null,"Gross Salary after Section 10",{"$nulls":6},{"$f":"P33-P40","v":0}]
[null,"National Saving Certificate (NSC)",null,null,0]
[null,"Tax Saving Mutual Funds(ELSS)",null,null,0,null,null,null,"Deduction U/s 16"]
[null,"Insurance Premium Paid",null,null,0,null,null,null,"Professional Tax (Sec 16 iii)",{"$nulls":6},0]
[null,"Savings in Pension Plans",null,null,0]
[null,"Tax Saving Fixed Deposit with Banks",null,null,0,null,null,null,"Income chargeable under head 'Salaries'",{"$nulls":6},{"$f":"P41-P44","v":0}]
[null,"Senior Citizens Savings Scheme",null,null,0]
[null,"National Pension System (NPS)/CPF",null,null,0,null,null,null,"Income (loss) on House property.",{"$nulls":6},0]
[null,"Children Tuition Fee",null,null,0]
[null,"Housing Loan Principal Repayment/Stamp Duty Paid",null,null,0,null,null,null,"Income from Other Sources",{"$nulls":6},0]
[null,"Others (Post Office Saving,ULIP, etc.)",null,null,0]
[null,"Total",null,null,{"$f":"SUM(E40:E51)","v":0},null,null,null,"Gross Total Income",{"$nulls":6},{"$f":"P50+P48+P46","v":0}]
[]
[null,"Other Deductions"]
[null,"Medical Insur Premium (sec 80D) For you & ur Family",null,null,0,null,null,null,"Deductions under chapter VI-A",{"$nulls":4},"Rs."]
[null,"Medical insur premium (sec 80D) For Parents",null,null,0,null,null,null,"Investments  ( Sec 80C)",{"$nulls":4},{"$f":"IF(E52>150000,150000,E52)","v":0}]
[null,"Medical treatment for handicapped dependents (Sec 80DD)",null,null,0,null,null,null,"Employer Contribution to NPS (Sec 80CCD (2)",{"$nulls":4},0]
[null,"% of disabilty of dependent/Yours",{"$nulls":6},"Rajiv Gandhi Equity Savings Scheme (Sec 80CCG)",{"$nulls":4},0]
[null,"Interest on Higher Education Loan(Sec 80E)",null,null,0,null,null,null,"Medical Insurance Premium (Sec 80D)For you & ur Family",{"$nulls":4},{"$f":"+E55","v":0}]
[null,"Rajiv Gandhi Equity Savings Scheme (RGESS) (Se 80CCG)",null,null,0,null,null,null,"Medical treatment for handicapped dependents (Sec 80DD)",{"$nulls":4},0]
[null,"Donations to charitable institutions and others (Sec 80G)",null,null,0,null,null,null,"Medical Insurance Premium (Sec 80D)For your parents",{"$nulls":4},0]
[null,"Deduction for permanent disability (80U)",null,null,0,null,null,null,"Interest on Higher Education Loan(Sec 80E)",{"$nulls":4},{"$f":"+E59","v":0}]
[null,"Total",null,null,{"$f":"SUM(E55:E62)","v":0},null,null,null,"Interest on Housing loan (Sec 80EE)",{"$nulls":4},0]
[{"$nulls":8},"Donations to charitable institutions and others (Sec 80G)",{"$nulls":4},{"$f":"+E61/2","v":0}]
[null,"Other Income",{"$nulls":6},"Deductions in respect of rents paid (Sec 80GG)",{"$nulls":4},0]
[null,"Interest income from deposit in a savings accounts(80TTA)",null,null,0,null,null,null,"Interest income from deposit in a savings accounts(80TTA)",{"$nulls":4},0]
[null,"Any Other Taxable Income (Other than interest income)",null,null,0,null,null,null,"Deduction for permanent disability (80U)",{"$nulls":4},0]
[null,"Total",null,null,0,null,null,null,"Total",{"$nulls":4},{"$f":"SUM(N56:N67)","v":0},null,{"$f":"N68","v":0}]
[{"$nulls":8},"Net taxable income",{"$nulls":6},{"$f":"P52-P68","v":0}]
[null,"Housing Loan Interest paid (Self occupied property)",null,null,0]
[{"$nulls":8},"Tax on Total Income",{"$nulls":6},{"$f":"F108","v":0}]
[{"$nulls":17},{"$f":"IF(P69<=500000,5000,0)","v":5000}]
[{"$nulls":8},"Rebate u/s 87",{"$nulls":6},0]
[]
[{"$nulls":8},"Total Tax Due",{"$nulls":6},{"$f":"P71-P73","v":0}]
[]
[{"$nulls":8},"Education Cess @3%",{"$nulls":6},{"$f":"ROUND(P75*3%,0)","v":0}]
[{"$nulls":8},"Total Tax Due",{"$nulls":6},{"$f":"P75+P77","v":0}]
[{"$nulls":8},"Less Tax Deducted Till Date"]
[{"$nulls":8},"Balance",{"$nulls":6},{"$f":"P78-P79","v":0}]
[{"$nulls":8},"Remaining Month in the Year",{"$nulls":6},12]
[{"$nulls":8},"Tax Per Month",{"$nulls":6},{"$f":"ROUND(P80/P81,0)","v":0}]
[]
[]
[]
[null,"A","Conveyance Allowance","April","May","June","July","August","Sept","Oct","Nov","Dec","Jan ","Feb","March"]
[]
[null,null,null,{"$f":"D16","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,800,{"$f":"D89","v":800},{"$f":"E89","v":800},{"$f":"F89","v":800},{"$f":"G89","v":800},{"$f":"H89","v":800},{"$f":"I89","v":800},800,800,800,800,800]
[]
[null,null,null,{"$f":"MIN(D88:D89)","v":0},{"$f":"MIN(E88:E89)","v":0},{"$f":"MIN(F88:F89)","v":0},{"$f":"MIN(G88:G89)","v":0},{"$f":"MIN(H88:H89)","v":0},{"$f":"MIN(I88:I89)","v":0},0,0,0,0,0,0,{"$f":"SUM(D91:O91)","v":0}]
[]
[null,"B","House Rent Allowance",{"$f":"D86","v":"April"},{"$f":"E86","v":"May"},{"$f":"F86","v":"June"},{"$f":"G86","v":"July"},{"$f":"H86","v":"August"},{"$f":"I86","v":"Sept"},"Oct","Nov","Dec","Jan ","Feb","March"]
[]
[null,null,null,{"$f":"D15","v":0},{"$f":"E15","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"ROUND(IF(D26=\"M\",\"50%\",\"40%\")*D14,0)","v":0},{"$f":"ROUND(IF(E26=\"M\",\"50%\",\"40%\")*E14,0)","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"ROUND(D25-(D14*10%),0)","v":0},{"$f":"ROUND(E25-(E14*10%),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"ROUND(O25-(O14*10%),0)","v":0}]
[]
[null,null,null,{"$f":"MIN(D95:D97)","v":0},{"$f":"MIN(E95:E97)","v":0},{"$f":"MIN(F95:F97)","v":0},{"$f":"MIN(G95:G97)","v":0},{"$f":"MIN(H95:H97)","v":0},{"$f":"MIN(I95:I97)","v":0},0,0,0,0,0,0,{"$f":"SUM(D99:O99)","v":0},{"$f":"IF(P99<0,0,P99)","v":0}]
[]
[]
[]
[]
[]
[null,"C","Tax Calculation",{"$f":"ROUND(IF(+P69<=250000,0,IF(+P69<=500000,(+P69-250000)*5%,IF(+P69<=1000000,((+P69-500000)*20%),IF(+P69>1000000,((+P69-1000000)*30%+0))))),0)","v":0},null,{"$f":"IF(+P69<=250000,0,IF(+P69<=500000,(+P69-250000)*5%,IF(+P69<=1000000,((+P69-500000)*20%+25000),IF(+P69>1000000,((+P69-1000000)*30%+125000)))))","v":0},null,{"$f":"IF(+P69<=500000,0,IF(+P69<=1000000,((+P69-500000)*20%+0),IF(+P69>1000000,((+P69-1000000)*30%+100000))))","v":0}]
[]
[]
[null,null,null,"1953-03-31",null,{"$f":"IF(J6>D108,D105,F105)","v":0}]
[null,null,null,"1933-03-31"]