{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tax Computation & CTC Structure","Welcome","PaySlip"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":65,"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":"Tax Computation & CTC Structure","index":0,"n_rows":65,"n_cols":12,"rows_kept":65,"cut":false,"hidden":true,"merged":[[62,1,62,6],[57,4,57,5],[55,4,55,5],[56,4,56,5],[0,8,0,12],[1,1,1,6],[2,2,2,6],[3,2,3,6],[54,4,54,5],[29,1,29,3],[29,4,29,6],[46,1,46,3],[46,4,46,6],[14,8,15,12],[24,8,24,12],[33,4,33,5]]}
[null,null,null,null,null,null,null,null,"Controls and Dashboard"]
[null,"Tax Computation and Salary Structure Financial Year  2021-2022",null,null,null,null,null,null,"Particulars","Applicable","Status","Rates"]
[null,"Employee Name",null,null,null,null,null,null,"PF Applicable","Yes","PF on Basic"]
[null,"Designation",null,null,null,null,null,null,"ESIC Applicable","Yes"]
[null,"Sex","Male",null,null,"Location","Delhi",null,"Gratuity Applicable","Yes"]
[null,"Effective From","2021-04-01",null,null,"Effective Till","2022-03-31",null,"Bonus Applicable","Yes","Not Paid"]
[null,"Annual CTC (INR)",0,null,null,"Net [Gross-(P.E.T.)]",{"$f":"ROUND(Gross_Monthly-D22-IF(C23>0,Gross_Monthly*J9,0)-D62,0)","v":0},null,"Performance Incentive","Yes","Not Paid"]
[null,"Fixed Components","Annual","Monthly ","Prorata","Exempt/Bills","Taxable",null,"Variable Pay","Yes","Not Paid"]
[null,"Basic Salary + DA",{"$f":"ROUND(Annual_CTC*40%,0)","v":0},{"$f":"ROUND(C9/12,0)","v":0},{"$f":"ROUND(C9/12/(DAY(EOMONTH($C$6,0)))*(DAY(EOMONTH($C$6,0))-(DAY($C$6)-1))+C9/12*(DATEDIF(($C$6-(DAY($C$6)-1)),(((DAY(EOMONTH($G$6,0)))-(DAY($G$6)))+$G$6),\"m\")-1)+C9/12/(DAY(EOMONTH($G$6,0)))*(DAY($G$6)),0)","v":0},0,{"$f":"MAX((E9-F9),0)","v":0},null,"Employee ESI",7.4999999999999997E-3,"Employer ESI",4.7500000000000001E-2]
[null,"HRA",{"$f":"ROUND(Basic*50%,0)","v":0},{"$f":"ROUND(C10/12,0)","v":0},{"$f":"ROUND(C10/12/(DAY(EOMONTH($C$6,0)))*(DAY(EOMONTH($C$6,0))-(DAY($C$6)-1))+C10/12*(DATEDIF(($C$6-(DAY($C$6)-1)),(((DAY(EOMONTH($G$6,0)))-(DAY($G$6)))+$G$6),\"m\")-1)+C10/12/(DAY(EOMONTH($G$6,0)))*(DAY($G$6)),0)","v":0},{"$f":"G58","v":0},0,null,"Tax Regime","Old"]
[null,"Conveyance Allowance",0,0,{"$f":"ROUND(C11/12/(DAY(EOMONTH($C$6,0)))*(DAY(EOMONTH($C$6,0))-(DAY($C$6)-1))+C11/12*(DATEDIF(($C$6-(DAY($C$6)-1)),(((DAY(EOMONTH($G$6,0)))-(DAY($G$6)))+$G$6),\"m\")-1)+C11/12/(DAY(EOMONTH($G$6,0)))*(DAY($G$6)),0)","v":0},0,0]
[null,"Special Allowance",0,0,{"$f":"ROUND(C12/12/(DAY(EOMONTH($C$6,0)))*(DAY(EOMONTH($C$6,0))-(DAY($C$6)-1))+C12/12*(DATEDIF(($C$6-(DAY($C$6)-1)),(((DAY(EOMONTH($G$6,0)))-(DAY($G$6)))+$G$6),\"m\")-1)+C12/12/(DAY(EOMONTH($G$6,0)))*(DAY($G$6)),0)","v":0},0,0,null,null,null,"akumar@121"]
[null,"Uniform Reimbursement",0,{"$f":"ROUND(C13/12,0)","v":0},{"$f":"ROUND(C13/12/(DAY(EOMONTH($C$6,0)))*(DAY(EOMONTH($C$6,0))-(DAY($C$6)-1))+C13/12*(DATEDIF(($C$6-(DAY($C$6)-1)),(((DAY(EOMONTH($G$6,0)))-(DAY($G$6)))+$G$6),\"m\")-1)+C13/12/(DAY(EOMONTH($G$6,0)))*(DAY($G$6)),0)","v":0},0,{"$f":"MAX((E13-F13),0)","v":0}]
[null,"Medical Allowance",0,{"$f":"ROUND(C14/12,0)","v":0},0,0,{"$f":"MAX((E14-F14),0)","v":0}]
[null,"LTA Reimbursement",{"$f":"IF(Annual_CTC>0,60000,0)","v":0},{"$f":"ROUND(C15/12,0)","v":0},0,{"$f":"E15","v":0},{"$f":"MAX((E15-F15),0)","v":0},null,"How to Use This sheet"]
[null,"Car Reimbursement",{"$f":"IF(Annual_CTC>0,96000,0)","v":0},0,0,{"$f":"E16","v":0},0]
[null,"Driver Reimbursement",{"$f":"IF(Annual_CTC>0,60000,0)","v":0},0,0,0,0]
[null,"Professional Development",0,0,0,0,0,null,"→  Type your CTC in Annual_CTC Yellow Color cell and Press enter"]
[null,"Entertainment Reimbursement",0,0,0,0,0,null,"→  Correct the selection of Particulars As applicable \"Yes\" \"No\" (if any) From Dashboard"]
[null,"Gross Salary Total",{"$f":"SUM(C9:C19)","v":0},{"$f":"SUM(D9:D19)","v":0},{"$f":"SUM(E9:E19)","v":0},{"$f":"SUM(F9:F19)","v":0},{"$f":"SUM(G9:G19)","v":0},null,"→  Modify Dates,  Allowance name and Annual Amount if required"]
[null,"Retiral and Other benefits",null,null,null,null,null,null,"→  Make your Income Tax saving Planning accordingly + HRA Rent"]
[null,{"$f":"IF(PF_Ap<>\"No\",\"Provident Fund @ 12%\",\"PF Not Applicable\")","v":"Provident Fund @ 12%"},{"$f":"ROUND(D22*12,0)","v":0},{"$f":"ROUND(IF(PF_Ap=\"No\",0,IF(PF_Ap=\"LIMITED\",IF(PF_WAGES=\"PF on Basic\",MIN(monthly_basic,15000),MIN(SUM(monthly_basic,D11:D19),15000)),IF(PF_WAGES=\"PF on Basic\",monthly_basic,SUM(monthly_basic,D11:D19))))*12%,0)","v":0},{"$f":"ROUND(C22/12/(DAY(EOMONTH($C$6,0)))*(DAY(EOMONTH($C$6,0))-(DAY($C$6)-1))+C22/12*(DATEDIF(($C$6-(DAY($C$6)-1)),(((DAY(EOMONTH($G$6,0)))-(DAY($G$6)))+$G$6),\"m\")-1)+C22/12/(DAY(EOMONTH($G$6,0)))*(DAY($G$6)),0)","v":0},null,null,null,"→  Add other income e.g. Saving, previous Employer Salary etc"]
[null,{"$f":"IF(ESI_Ap=\"No\",\"ESI Not Applicable\",\"Employee's State Insurance @ \"&TEXT(L9,\".00%\"))","v":"Employee's State Insurance @ 4.75%"},{"$f":"ROUND(MAX(IF(ESI_Ap=\"Yes\",IF(Gross_Monthly<=21000,Gross_Annual*L9,0),0),0),0)","v":0},{"$f":"ROUND(C23/12,0)","v":0},0,null,null,null,"→  Add Loss/Income From House Property"]
[null,"Company Mediclaim",0,0,0]
[null,"Statutory Bonus",0,0,0,null,{"$f":"IF(bonus_paid=\"Paid\",E25,0)","v":0},null,"© Akumar 2021-2022"]
[null,"Variable Pay",0,0,0,null,{"$f":"IF(var_paid=\"Paid\",E26,0)","v":0}]
[null,"Gratuity",{"$f":"IF(Gratuity_Ap=\"Yes\",ROUND($C$9*4.81%,0),0)","v":0},0,0,null,0]
[null,"Grand Total - CTC",{"$f":"ROUND(SUM(C22:C27)+C20,0)","v":0},{"$f":"ROUND(SUM(D22:D27)+D20,0)","v":0},{"$f":"ROUND(SUM(E22:E27)+E20,0)","v":0},{"$f":"ROUND(SUM(F22:F27)+F20,0)","v":0},{"$f":"ROUND(SUM(G22:G27)+G20,0)","v":0}]
[null,{"$f":"ROUND(Annual_CTC-C28,0)","v":0}]
[null,"Investments U/S 80 C",null,null,"Investments / Deductions other Sections",null,null,null,null,null,null,"Conveyance Allowance"]
[null,"Current Employer - PF",null,{"$f":"+E22","v":0},"80D   Medicalim Insurance (Self)",null,0,null,null,null,null,"Special Allowance"]
[null,"Pervious Employer - PF",null,0,"80D   Medicalim Insurance (Parents)",null,0,null,null,null,null,"Other Allowance"]
[null,"Voluntary Provident Fund  - VPF",null,0,"80E   Interest on Education Loan",null,0,null,null,null,null,"Medical Allowance"]
[null,"Life Insurance Premiums - LIP",null,0,"80EEB  Purchase Electric Vehicle",null,0,null,null,null,null,"LTA Reimbursement"]
[null,"Public Provident Fund - PPF",null,0,"80U   Self Handicapped",null,0,null,null,null,null,"Car Reimbursement"]
[null,"Children Education Tuition Fees - CEF",null,0,"80DD   Handicapped dependent",null,0,null,null,null,null,"Driver Reimbursement"]
[null,"Pension Funds – Section 80CCC",null,0,"80DDB Treatment of specified ailments",null,0,null,null,null,null,"Washing Reimbursement"]
[null,"Bank fixed deposits (5-Yr) - FD",null,0,"80CCD(1b) NPS Contribution (Employee)",null,0,null,null,null,null,"Uniform Reimbursement"]
[null,"Unit linked Insurance Plan - ULIP",null,0,"80CCD2 NPS Contribution (Employer)",null,0,null,null,null,null,"Professional Development"]
[null,"Home Loan Principal Repayment - HLP",null,0,"80TTA  Deduction (General)",null,0,null,null,null,null,"Entertainment Reimbursement"]
[null,"Equity Linked Savings Scheme - ELSS",null,0,"80TTB  Deduction (Senior Citizen)",null,0,null,null,null,null,"Child Education Allowance"]
[null,"National Savings Certificate - NSC",null,0,"Section-16(ia) Standard Deduction",null,{"$f":"MIN(G28,50000)","v":0},null,null,null,null,"Hostel Allowance"]
[null,"Other Investments",null,0,"Section-16(ii) Entertainment Allowance",null,0]
[null,"Stamp Duty and Registration Charges for a home",null,0,"Section-16(iii) Professional Tax",null,0]
[null,"Grand Total",null,{"$f":"SUM(D31:D44)","v":0},"Grand Total",null,{"$f":"SUM(G31:G44)","v":0}]
[]
[null,"Tax Computation",null,null,"HRA Calculation"]
[null,"Gross Salary",null,{"$f":"G28","v":0},"Monthly Rent",null,0]
[null,"Less: Previous Employer Professional Tax",null,0,"Rent Location"]
[null,"Any other taxable Income",null,0]
[null,"Interest of Housing Loan Section - 24B",null,0,null," From"]
[null,"Chapter VI-A and Section 16",null,{"$f":"MIN(D45,150000)+G45","v":0},null,"To"]
[null,"Taxable Income",null,{"$f":"MAX(ROUND(D48+D51-D52-D49+D50,-1),0)","v":0}]
[null,"Income Tax Liability",null,{"$f":"ROUND(IF(OR(C5=\"Male\",C5=\"Female\"),IF(D53<=250000,0,IF(D53<=500000,(D53-250000)*5%,IF(D53<=1000000,(D53-500000)*20%+12500,(D53-1000000)*30%+112500))),0)+IF(C5=\"SC\",IF(D53<=300000,0,IF(D53<=500000,(D53-300000)*5%,IF(D53<=1000000,(D53-500000)*20%+10000,(D53-1000000)*30%+110000))),0),0)","v":0}," Prorated Annual Rent",null,{"$f":"IFERROR(ROUND((G48*12)/12/(DAY(EOMONTH($G$51,0)))*(DAY(EOMONTH($G$51,0))-(DAY($G$51)-1))+(G48*12)/12*(DATEDIF(($G$51-(DAY($G$51)-1)),(((DAY(EOMONTH($G$52,0)))-(DAY($G$52)))+$G$52),\"m\")-1)+(G48*12)/12/(DAY(EOMONTH($G$52,0)))*(DAY($G$52)),0),0)","v":0}]
[null,"Less: Rebate 87A",null,{"$f":"ROUND(IF(D53<=500000,MIN(12500,D54),0),0)","v":0}," 1.Actual HRA",null,{"$f":"E10","v":0}]
[null,"Sub Total",null,{"$f":"D54-D55","v":0}," 2.Rent-10% Basic",null,{"$f":"IF(Basic>0,MAX(IF(G48>0,ROUND(G54-(ROUND((C9)/12/(DAY(EOMONTH($G$51,0)))*(DAY(EOMONTH($G$51,0))-(DAY($G$51)-1))+(C9)/12*(DATEDIF(($G$51-(DAY($G$51)-1)),(((DAY(EOMONTH($G$52,0)))-(DAY($G$52)))+$G$52),\"m\")-1)+(C9)/12/(DAY(EOMONTH($G$52,0)))*(DAY($G$52)),0)*10%),0),0),0),0)","v":0}]
[null,"Surcharge",null,{"$f":"ROUND(IF(AND(C5<>\"SC\"),IF(D53<=5000000,0,IF(D53<=5195890,(D53-5000000)*70%,IF(D53<=10000000,D56*10%,IF(D53<=10214700,(D53-10000000)*70%+281250,IF(D53<=20000000,D56*15%,IF(D53<=20930000,(D53-20000000)*70%+871875,IF(D53<=50000000,D56*25%,IF(D53<=53017830,(D53-50000000)*70%+3703125,D56*37%)))))))),0),0)+ROUND(IF(AND(C5=\"SC\"),IF(D53<=5000000,0,IF(D53<=5195530,(D53-5000000)*70%,IF(D53<=10000000,D56*10%,IF(D53<=10214510,(D53-10000000)*70%+281000,IF(D53<=20000000,D56*15%,IF(D53<=20929600,(D53-20000000)*70%+871500,IF(D53<=50000000,D56*25%,IF(D53<=53017320,(D53-50000000)*70%+3702500,D56*37%)))))))),0),0)","v":0},{"$f":"IF(G49=\"Non-Metro\",\" 3.40% of Basic\",\" 3.50% of Basic\")","v":" 3.50% of Basic"},null,{"$f":"IF(G56>0,IF(G49=\"Non-Metro\",ROUND((ROUND((C9)/12/(DAY(EOMONTH($G$51,0)))*(DAY(EOMONTH($G$51,0))-(DAY($G$51)-1))+(C9)/12*(DATEDIF(($G$51-(DAY($G$51)-1)),(((DAY(EOMONTH($G$52,0)))-(DAY($G$52)))+$G$52),\"m\")-1)+(C9)/12/(DAY(EOMONTH($G$52,0)))*(DAY($G$52)),0)*40%),0),ROUND((ROUND((C9)/12/(DAY(EOMONTH($G$51,0)))*(DAY(EOMONTH($G$51,0))-(DAY($G$51)-1))+(C9)/12*(DATEDIF(($G$51-(DAY($G$51)-1)),(((DAY(EOMONTH($G$52,0)))-(DAY($G$52)))+$G$52),\"m\")-1)+(C9)/12/(DAY(EOMONTH($G$52,0)))*(DAY($G$52)),0)*50%),0)),0)","v":0}]
[null,"Health and Education Cess @ 4%",null,{"$f":"ROUND((D56+D57)*4%,0)","v":0}," Least of Above is exempt",null,{"$f":"MIN(G55:G57)","v":0}]
[null,"Total Tax",null,{"$f":"D58+D57+D56","v":0}]
[null,"Already Deducted",null,0," Taxable HRA",null,{"$f":"MAX((G55-G58),0)","v":0}]
[null,"Balance Tax",null,{"$f":"MAX((D59-D60),0)","v":0}]
[null,"Monthly Tax",null,{"$f":"ROUND(D61/(DATEDIF(Effectivedate,G6,\"m\")+1),0)","v":0}]
[null,"This Sheet structured By Akumar, if you have any query OR need any paid assistance :-\nMailto: ajityadav121@gmail.com   WhatsApp or Call: +919654421288"]
[]
[null,"Click here to visit Our Excel Academy: 99Excel.Com",null,"Click here to visit Our Payroll Institute: iptm.org.in",null,null,"Click here to visit Our Payroll Blog: payrollpedia.org"]

{"sheet":"Welcome","index":1,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,0,21,7],[5,1,5,8],[18,1,18,8],[0,0,2,11],[3,1,3,8],[4,1,4,8]]}
["Your excel Macro is disable!\n Please enable Excel Macro (Steps below) and re-open the same"]
[]
[]
["è","1. Click the Microsoft Office Button      , and then click Excel Options."]
["è","2. Click Trust Center, click Trust Center Settings, and then click Macro Settings."]
["è","3. Click the options, Enable all macros (not recommended, potentially dangerous code can run) "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["è","4. Click the OK option , again OK and  exit excel with save."]
[]
[]
["Watch Video How to Enable Macros in Excel",null,null,null,null,null,null,null,"https://youtu.be/cq_qkS2koRw"]

{"sheet":"PaySlip","index":2,"n_rows":96,"n_cols":21,"rows_kept":96,"cut":false,"hidden":true,"merged":[[2,20,3,20],[4,20,5,20],[19,9,19,10],[20,9,20,10],[21,1,21,3],[21,5,21,6],[21,9,21,10],[22,1,22,3],[22,5,22,6],[22,9,22,10],[10,2,10,4],[10,5,10,8],[13,12,13,13],[13,14,13,15],[14,1,14,6],[14,7,14,8],[14,9,14,12],[14,13,14,17],[11,2,11,4],[11,5,11,8],[10,10,10,11],[12,2,12,4],[11,10,11,11],[13,2,13,3],[1,1,1,17],[2,1,2,17],[3,1,4,17],[2,19,3,19],[4,19,5,19],[9,2,9,4],[9,5,9,8],[9,10,9,11],[9,12,9,13],[5,13,5,17],[7,2,7,4],[7,5,7,8],[7,10,7,11],[7,12,7,13],[8,2,8,4],[8,5,8,8],[8,10,8,11],[8,12,8,13],[13,5,13,8],[13,10,13,11],[12,5,12,7],[15,1,15,4],[15,5,15,6],[15,9,15,10],[15,13,17,14],[15,15,15,17],[16,1,16,3],[16,5,16,6],[16,9,16,10],[16,15,16,17],[12,12,12,13],[19,1,19,3],[19,5,19,6],[20,1,20,3],[20,5,20,6],[32,1,32,17],[33,1,33,17],[17,1,17,3],[17,5,17,6],[17,9,17,10],[17,15,17,17],[18,1,18,3],[18,5,18,6],[18,9,18,10],[23,1,23,3],[23,5,23,6],[23,9,23,10],[24,1,24,3],[24,5,24,6],[24,9,24,10],[25,1,25,3],[25,5,25,6],[25,9,25,10],[36,1,36,3],[36,5,36,6],[36,13,37,14],[36,15,37,17],[37,1,37,3],[37,5,37,6],[34,1,34,6],[34,7,34,8],[34,9,34,12],[34,13,34,17],[35,1,35,4],[35,5,35,6],[35,13,35,14],[35,15,35,17],[40,1,40,3],[40,5,40,6],[40,13,40,14],[40,15,40,17],[41,1,41,3],[41,5,41,6],[41,13,41,14],[41,15,41,17],[38,1,38,3],[38,5,38,6],[38,13,39,14],[38,15,39,17],[39,1,39,3],[39,5,39,6],[44,15,44,17],[45,1,45,3],[45,5,45,6],[45,13,45,17],[42,1,42,3],[42,5,42,6],[42,13,42,14],[42,15,42,17],[43,1,43,3],[43,5,43,6],[43,13,43,14],[43,15,43,17],[46,1,46,3],[46,5,46,6],[46,13,46,14],[47,1,47,3],[47,5,47,6],[47,13,47,14],[44,1,44,3],[44,5,44,6],[44,13,44,14],[50,13,50,14],[51,13,51,14],[53,1,53,3],[53,5,53,6],[53,9,53,11],[53,13,53,17],[47,15,47,17],[48,1,48,3],[48,5,48,6],[48,13,48,14],[48,15,48,17],[49,13,49,14],[57,1,57,3],[57,15,57,17],[58,1,58,3],[58,5,58,6],[58,15,58,17],[59,1,59,3],[59,5,59,6],[59,15,59,17],[54,1,54,3],[54,9,54,11],[54,15,54,17],[55,2,55,4],[55,14,55,17],[56,2,56,4],[56,15,56,17],[62,1,62,3],[62,5,62,6],[62,15,62,17],[63,1,63,3],[63,5,63,6],[63,15,63,17],[60,1,60,3],[60,5,60,6],[60,15,60,17],[61,1,61,3],[61,5,61,6],[61,15,61,17],[66,1,66,3],[66,5,66,6],[66,15,66,17],[67,1,67,3],[67,5,67,6],[67,15,67,17],[64,1,64,3],[64,5,64,6],[64,9,64,11],[64,15,64,17],[65,1,65,3],[65,5,65,6],[65,15,65,17],[72,15,72,17],[74,13,74,17],[86,3,86,6],[87,3,87,6],[68,1,68,4],[68,5,68,6],[68,15,68,17],[69,1,70,3],[69,5,70,6],[69,15,69,17],[70,7,71,7],[71,15,71,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pay Month","2021-04-30"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fin Year","2021 - 2022"]
[null,{"$f":"IF(U5=\"FNF\",\"FNF \"&\"Payslip for the Month of \"&TEXT(U2,\"MMMM YYYY\"),\"Payslip for the Month of \"&TEXT(U2,\"MMMM YYYY\"))","v":"Payslip for the Month of April 2021"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PaySlip Type","Payroll"]
[]
[]
[null,null,"Code",null,null,"",null,null,null,null,"Date of Joining",null,null,null,null,"EOD",":",{"$f":"DAY(EOMONTH(monthnamepayslip,0))","v":30}]
[null,null,"Name",null,null,{"$f":"'Tax Computation & CTC Structure'!C3","v":0},null,null,null,null,"Bank A/c No.",null,"",null,null,"LOP",":",8]
[null,null,"Department",null,null,null,null,null,null,null,"PAN",null,null,null,null,"EL",":"]
[null,null,"Designation",null,null,{"$f":"'Tax Computation & CTC Structure'!C4","v":0},null,null,null,null,"Sex",null,{"$f":"'Tax Computation & CTC Structure'!C5","v":"Male"},null,null,"CL",":",0]
[null,null,"Location",null,null,{"$f":"'Tax Computation & CTC Structure'!G5","v":"Delhi"},null,null,null,null,"Payable Days",null,25,null,null,"PL",":",0]
[null,null,null,null,null,null,null,null,null,null,"Bank Name",null,null,null,null,null,null,0]
[null,null,{"$f":"IF(U5=\"FNF\",\"Date of Leaving\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(U5=\"FNF\",\"FNF Settlement\",\"\")","v":""},null,{"$f":"IF(U5=\"FNF\",NOW(),\"\")","v":""}]
[null,"Standard Earnings",null,null,null,null,null,"Actual Earnings",null,"Deductions",null,null,null,"Total"]
[null,{"$f":"'Tax Computation & CTC Structure'!B9","v":"Basic Salary + DA"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!D9","v":0},null,{"$f":"B16","v":"Basic Salary + DA"},{"$f":"ROUND(F16/$R$8*paydaysp,0)","v":0},"PF",null,null,{"$f":"IF(PF_Ap=\"Yes\",ROUND(I16*12%,0),0)","v":0},"GROSS PAY\nGROSS DED.\nNET PAY",null,{"$f":"SUM($I$16:$I$27)","v":0}]
[null,{"$f":"'Tax Computation & CTC Structure'!B10","v":"HRA"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!D10","v":0},null,{"$f":"B17","v":"HRA"},0,"ESIC",null,null,{"$f":"IF(ESI_Ap=\"Yes\",ROUND(IF(SUM(F16:G25)>21000,0,SUM(I16:I26)*1.75%),0),0)","v":0},null,null,{"$f":"SUM($M$16:$M$27)","v":0}]
[null,{"$f":"'Tax Computation & CTC Structure'!B11","v":"Conveyance Allowance"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!D11","v":0},null,"Conveyance Allowance",0,"ITAX",null,null,{"$f":"'Tax Computation & CTC Structure'!D62","v":0},null,null,{"$f":"P16-P17","v":0}]
[null,{"$f":"'Tax Computation & CTC Structure'!B12","v":"Special Allowance"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!D12","v":0},null,"Special Allowance",0,"PTAX",null,null,0]
[null,{"$f":"'Tax Computation & CTC Structure'!B14","v":"Medical Allowance"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!D14","v":0},null,{"$f":"B20","v":"Medical Allowance"},0]
[null,{"$f":"'Tax Computation & CTC Structure'!B15","v":"LTA Reimbursement"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!D15","v":0},null,{"$f":"B21","v":"LTA Reimbursement"},0]
[null,{"$f":"'Tax Computation & CTC Structure'!B16","v":"Car Reimbursement"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!D16","v":0},null,{"$f":"B22","v":"Car Reimbursement"},0]
[null,{"$f":"'Tax Computation & CTC Structure'!B17","v":"Driver Reimbursement"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!D17","v":0},null,{"$f":"B23","v":"Driver Reimbursement"},0]
[null,{"$f":"'Tax Computation & CTC Structure'!B18","v":"Professional Development"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!D18","v":0},null,{"$f":"B24","v":"Professional Development"},0]
[null,{"$f":"'Tax Computation & CTC Structure'!B19","v":"Entertainment Reimbursement"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!D19","v":0},null,{"$f":"B25","v":"Entertainment Reimbursement"},0]
[]
[]
[null,null,null,null,null,null,"Net Pay",{"$f":"ROUND(IFERROR(P18,0),0)","v":0},{"$f":"akumars(H28)","v":"No Rupees Only"}]
[]
[]
[]
[]
[null,{"$f":"\"Income Tax Worksheet for the month of \"&TEXT(U2,\"MMMM YYYY\")","v":"Income Tax Worksheet for the month of April 2021"}]
[null,"April 2020 - March 2021"]
[null,"Taxable Earnings",null,null,null,null,null,"Deduction U/C VI-A",null,"Investments U/S 80 C",null,null,null,"HRA Calculation"]
[null,{"$f":"B16","v":"Basic Salary + DA"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!E9","v":0},null,"80D-Self",{"$f":"medis","v":0},"PF",null,null,{"$f":"'Tax Computation & CTC Structure'!D31+'Tax Computation & CTC Structure'!D32+'Tax Computation & CTC Structure'!D33","v":0},"Rent Paid",null,{"$f":"'Tax Computation & CTC Structure'!G48","v":0}]
[null,{"$f":"B17","v":"HRA"},null,null,null,{"$f":"P42-P45","v":0},null,"80D-Parents",{"$f":"medps","v":0},"PPF",null,null,{"$f":"PPF","v":0},"From",null,{"$f":"'Tax Computation & CTC Structure'!G51","v":"00:00:00"}]
[null,{"$f":"B18","v":"Conveyance Allowance"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!G11","v":0},null,"80DD",{"$f":"usdd","v":0},"EMI",null,null,{"$f":"'Tax Computation & CTC Structure'!D40+'Tax Computation & CTC Structure'!D44","v":0}]
[null,{"$f":"B19","v":"Special Allowance"},null,null,null,{"$f":"'Tax Computation & CTC Structure'!G12","v":0},null,"80E",{"$f":"usE","v":0},"LIP",null,null,{"$f":"'Tax Computation & CTC Structure'!D34","v":0},"To",null,{"$f":"'Tax Computation & CTC Structure'!G52","v":"00:00:00"}]
[null,null,null,null,null,null,null,"80G",0,"NSC",null,null,{"$f":"'Tax Computation & CTC Structure'!D42","v":0}]
[null,null,null,null,null,null,null,"80U",{"$f":"usU","v":0},"ULIP",null,null,{"$f":"'Tax Computation & CTC Structure'!D39","v":0},"Metro OR Non-Metro",null,{"$f":"'Tax Computation & CTC Structure'!G49","v":0}]
[null,null,null,null,null,null,null,"80DDB",{"$f":"usddb","v":0},"SHARES",null,null,0,"1.Actual HRA",null,{"$f":"'Tax Computation & CTC Structure'!G55","v":0}]
[null,null,null,null,null,null,null,"80EE",0,"CEF",null,null,{"$f":"'Tax Computation & CTC Structure'!D36","v":0},"2.Rent-10% Basic",null,{"$f":"'Tax Computation & CTC Structure'!G56","v":0}]
[null,null,null,null,null,null,null,"80EEA",0,"OTHER",null,null,{"$f":"'Tax Computation & CTC Structure'!D43","v":0},{"$f":"'Tax Computation & CTC Structure'!E57","v":" 3.50% of Basic"},null,{"$f":"'Tax Computation & CTC Structure'!G57","v":0}]
[null,null,null,null,null,null,null,"80EEB",0,"ELSS",null,null,{"$f":"'Tax Computation & CTC Structure'!D41","v":0},"Least of Above is exempt",null,{"$f":"MIN(P42:R44)","v":0}]
[null,null,null,null,null,null,null,null,null,"FD",null,null,{"$f":"'Tax Computation & CTC Structure'!D38","v":0},"RFA Calculation"]
[null,null,null,null,null,null,null,null,null,"80CCC",null,null,{"$f":"'Tax Computation & CTC Structure'!D37","v":0},"Rent Paid"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"From"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"To"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Taxable RFA Value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Furniture Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Taxable Furniture Perk"]
[]
[null,"Gross Salary",null,null,null,{"$f":"SUM(F36:G51)","v":0},null,"Total Deduction u/c VI-A",{"$f":"SUM(I36:I52)","v":0},"Total Investment u/s 80 C",null,null,{"$f":"SUM(M36:M52)","v":0},"Loan Receovery"]
[null,"Deductions",null,null,null,null,null,"Any Other Income ",null,"Any Other Exemptions",null,null,null,"Loan Amount",null,0]
[null,null,"Professional Tax",null,null,null,0,null,null,null,null,null,null,"Loan Date","2020-04-01"]
[null,null,"Pre.Emp.Professional Tax",null,null,null,0,"INT_OTHERS",{"$f":"'Tax Computation & CTC Structure'!D52","v":0},"Encashment Exemption",null,null,0,"Less: Paid",null,0]
[null,"Any Other Income",null,null,null,null,{"$f":"I72","v":0},"80TTA",0,"Gratuity Exemption",null,null,0,"Balance",null,0]
[null,"Chapter VI-A and 80 C",null,null,null,{"$f":"I54+(MIN(M54,150000))","v":0},null,null,null,"LTA Exemption",null,null,0,"Receovery:"]
[null,"Taxable Income",null,null,null,{"$f":"ROUND(F54-G56-G57-F59+G58,-1)-'Tax Computation & CTC Structure'!G42","v":0},null,null,null,null,null,null,null,"Apr",null,0]
[null,"Income Tax Liability",null,null,null,{"$f":"'Tax Computation & CTC Structure'!D56","v":0},null,null,null,null,null,null,null,"May",null,0]
[null,"Surcharge",null,null,null,{"$f":"'Tax Computation & CTC Structure'!D57","v":0},{"$f":"IF(#REF!=\"2014-2015\",ROUND(IF(N12=\"S\",ROUND(IF(G60>10000000,IF((G60-10000000)<(0.1*G61+(G61-2820000)),G60-(10000000+(G61-2820000)),0.1*G61),0),0),(IF(G60>10000000,IF((G60-10000000)<(0.1*G61+(G61-2825000)),(G60-(10000000+(G61-2825000))),0.1*G61),0))),0),0)+IF(#REF!=\"2013-2014\",IF(N12=\"S\",ROUND(IF(G60>10000000,IF((G60-10000000)<(0.1*G61+(G61-2825000)),G60-(10000000+(G61-2825000)),0.1*G61),0),0),IF(G60>10000000,IF((G60-10000000)<(0.1*G61+(G61-2830000)),G60-(10000000+(G61-2830000)),0.1*G61))))+IF(#REF!=\"2008-2009\",ROUND(IF(G60>1000000,((G61)*10%),0),0),0)+IF(#REF!=\"2007-2008\",ROUND(IF(G60>1000000,IF((G60-1000000)<(0.1*G61+(G61-250000)),G60-(1000000+(G61-250000)),0.1*G61),0),0),0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,"Jun",null,0]
[null,"Sub Total",null,null,null,{"$f":"F61+F62","v":0},null,null,null,null,null,null,null,"Jul",null,0]
[null,"Education Cess",null,null,null,{"$f":"ROUND(F63*4%,0)","v":0},null,null,null,null,null,null,null,"Aug",null,0]
[null,"Net Tax",null,null,null,{"$f":"F64+F63","v":0},null,null,null,"Total Exemptions",null,null,{"$f":"SUM(M57:M61)","v":0},"Sep",null,0]
[null,"Previous Employer Tax",null,null,null,0,null,null,null,null,null,null,null,"Oct",null,0]
[null,"Tax deducted till last month",null,null,null,0,null,null,null,null,null,null,null,"Nov",null,0]
[null,"Tax to be deducted",null,null,null,{"$f":"ROUND(F65-F66-F67,0)","v":0},null,null,null,null,null,null,null,"Dec",null,0]
[null,"Tax deduction for this month",null,null,null,{"$f":"'Tax Computation & CTC Structure'!D62","v":0},null,null,null,null,null,null,null,"Jan",null,0]
[null,"Revised Tax/month",null,null,null,0,null,null,null,null,null,null,null,"Feb",null,0]
[null,null,null,null,null,null,null,"Total Other Income"]
[null,null,null,null,null,null,null,null,{"$f":"I57-I58+I59","v":0},null,null,null,null,"Mar",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(P60:R72)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Month"]
[null,null,null,null,null,null,null,"2021-04-30"]
[null,null,null,null,null,null,null,"2021-05-31"]
[null,null,null,null,null,null,null,"2021-06-30"]
[null,null,null,null,null,null,null,"2021-07-31"]
[null,null,null,null,null,null,null,"2021-08-31"]
[null,null,null,null,null,null,null,"2021-09-30"]
[null,null,null,null,null,null,null,"2021-10-31"]
[null,null,null,null,null,null,null,"2021-11-30"]
[null,null,null,null,null,null,null,"2021-12-31"]
[null,null,null,null,null,null,null,"2022-01-31"]
[null,null,null,null,null,null,null,"2022-02-28"]
[null,null,null,null,null,null,null,"2022-03-31"]