{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","Software Tax Calculator","Simple Tax Calculator","Information & Rules exmpt,Ded","Income HP","Ex All - OS","Subscription"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":7,"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":"Home","index":0,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[7,5,7,6],[8,1,8,9],[9,1,9,9],[11,3,11,9],[12,1,12,9],[13,4,13,5],[13,6,13,7],[13,8,13,9],[35,1,35,9],[36,1,36,9],[37,4,37,6],[38,1,38,2],[38,8,38,9],[39,1,39,9],[40,1,40,10],[63,1,63,4],[2,5,5,7],[44,1,45,9],[49,1,50,9],[16,1,18,9]]}
[]
[]
[null,null,null,null,null,"      Version 12.1 for                                   Financial year 2017- 18        Assessment Year 2018-19 "]
[]
[]
[]
[]
[null,null,null,null,null,"by B.P.CHOUDHARY "]
[null,"                                          CA Associate                                                                                                        "]
[null,"Automatic selection of Assessee status, Income from House property with relief of Section 80EE.                                                                        Computation of Income Tax "]
[null,null,"                 with Ready reconer - For latest infromations & rules of the Taxation, Exemptions, deduction etc."]
[null,null,null,"                              Calculate your Tax in less than 5 Minutes"]
[null,"A simple Tax Calculator on excel sheet to compute the tax and understand related rule.                                                                                                                                                      Once you enter the amount in blank cells. other cells will calculate data & tax automatically.                                                                                                                                                                                                                                         Calculate your Income tax in calculation sheet & print  the computation and other calculation sheet ."]
[null,"Introduction","Software Tax Calculator ","Simple Tax Calculator","Informations & Rules                              (Tax rates, exemptions/deductions)",null," Income from House Property",null,"Exempted Allowance & income from other source"]
[null,"Latest Modified Version (as a software/simple) for Financial Year 2017-18, Assessment Year 2018-19 ."]
[null,"Now calculate the Income tax in very simple way with less time & less efforts also know all current applicable rules.  "]
[null,"A clubed calculator of two type of calculaor \"Software Calculator and Simple Excel Calculator\" in same work book.                                                                     You can use anyone or both as per your suitability.Simple calculator is hyperlinked with information and Rules to clear and understand all related aspects.  .                                                                                            "]
[]
[]
[null,"Since last 16 Years I am rendering my services in field of Taxation and having a lots of satisfied clients all over the India."]
[null,"Assosiated with India's wellknown company, My corporation.in (Winner of Leaders Award 2015 as \"Startup Consulting Enterprise of the Year (Finance))\"."]
[null,"Providing all taxation related services in nominal charges"]
[null,"Services to Companies and officies"]
[null,"1. Presentation/Seminar on any taxation matter.      2. Setup Help Desk "]
[null,"3. Payroll Management with Taxation and CA services (in very nominal amount of ₹ 100 per empolyee Per month)"]
[null,"4. Outsourcing of any CA services, Preparation of form-16 , Collection of declaration and final documents for caculate TDS and Tax Liabilities etc."]
[null,"Return Filing Services for Individuals"]
[null,"Business (Company/Firm) Formation Services - Pvt Ltd co. One person co. Public Ltd. Co., LLP, Partnership, Section 8 Co. "]
[null,"Tax and Management Services - Income Tax , TDS,  Service Tax , VAT / Sales tax , Excise Return.  Work Contract etc."]
[null,"Compliances - Returns, Audit & ROC, Annual Filling"]
[null,"Other allied Services"]
[null,"Apply for 1.  PAN    2. TAN       3. Service Tax Registration        4. VAT/Central Sales Tax Registration    5. Digital Signature    6. DIN "]
[null,"               7.  ISO certification    8. Trade Mark and Copy right     9. Food Licence Registration     10. Import Export Code(IEC)"]
[null,"Customise Insurance solutions - General - Mediclaim , Personal Accident Cover(Group/Individuals/family), other General Product "]
[]
[null,"If you find any inconsistency, correction or amendments in Calculator, please let me know, I will try to fix it at the earliest. "]
[null,"Please send a detailed e-mail at taxationseva@gmail.com"]
[null,null,null,null,"9811302497, 9211125587"]
[null,"                  For our Services - Visit",null,"https://www.mycorporation.in/",null,"Other Calculators and Taxation related matters- Visit",null,null,"http://www.taxationseva.com/"]

{"sheet":"Software Tax Calculator","index":1,"n_rows":131,"n_cols":10,"rows_kept":131,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,6,0,10],[1,1,1,4],[1,6,1,10],[2,3,2,4],[2,9,2,10],[3,3,3,4],[3,9,3,10],[4,3,4,4],[4,9,4,10],[5,2,5,4],[5,8,5,10],[7,1,7,2],[10,1,10,2],[13,1,13,2],[15,1,15,2],[17,1,17,2],[19,1,19,2],[20,1,20,2],[86,1,86,3],[88,1,88,3]]}
[null,"software                                      VERSION 12.1                                                                                     .                                       As per Budget 2017                                                  .     for the Financial Yr 2017 -18 / Assessment yr 2018 -19"]
[null,"      Enter the Amount & informations in                                                                                                                                        .    Other cells will calculate data & Tax automatically.             "]
[null,"  CALCULATION OF INCOME TAX  ","D.O.B","00/00/0000",null,null,"COMPUTATION OF INCOME TAX  ",null,"D.O.B : ",{"$f":"D3","v":"00/00/0000"}]
[null,"Write your Full Name and Address","ASSESSE","MALE",null,null," for Financial Year 2017-18, Assessment Year 2018-19 ",null,"ASSESSE :",{"$f":"D4","v":"MALE"}]
[null,null,"PAN",null,null,null,{"$f":"\" NAME : \"&UPPER(B5)","v":" NAME : "},null,"PAN :",{"$f":"UPPER(D5)","v":""}]
[null,null,"PHONE :                                                                                                                                           ",null,null,null,{"$f":"\" ADDRESS : \"&UPPER(B6)","v":" ADDRESS : "},null,{"$f":"C6","v":"PHONE :                                                                                                                                           "}]
[null,"  1. Gross Annual Income/Salary (include all allowances & Perks)",null,null,{"$f":"SUM(C7)","v":0},null,"  1.   Gross Annual Income",null,null,{"$f":"E7","v":0}]
[null,"  2. Less: Allowances exempt u/s 10 &17( for Service Period ) ",null,null,{"$f":"IF(C10=0,SUM(D78+SUM(D83:D86,D88,D90:D92)),C10)","v":0},null,"  2.   Allowances exempt - u/s 10 & 17",null,null,{"$f":"E8","v":0}]
[null,null,null,null,null,null,"  3.   Deduction u/s 16 -Tax on Employement/ Entertainment allowance ",null,null,{"$f":"E11","v":0}]
[null,"                OR - Total Allowances exemption  u/s 10 &17                                       .   (if Detail of Basic, HRA & other heads etc. are not available)",0,null,null,null,"  4.   Income under the head salaries",null,null,{"$f":"E14","v":0}]
[null,"  3. Deduction u/s 16",null,null,{"$f":"C12+D13","v":0},null,"  5.   Interest received in saving account",null,null,0]
[null,"    (i) Professionsal Tax / tax on Employment (u/s 16(ii)) ",0,null,null,null,"  6.   Any other income from other sources",null,null,0]
[null,"    (ii) Entertainment Allowance (for Govt Servent only) ",0,{"$f":"IF(C13>=5000,5000,IF(C13<5000,C13))","v":0},null,null,"  7.   Income from house property",null,null,{"$f":"E18","v":0}]
[null,"  4.  Income under the head salaries",null,null,{"$f":"E7-(E8+E11)","v":0},null,"  8.   Gross Total Income",null,null,{"$f":"E20","v":0}]
[null,"  5.  Interst received from saving A/c (Bank/Post Post Office) ",0,null,{"$f":"C15","v":0},null,"  9.   Deduction under chapter VI A ",null,null,{"$f":"E21","v":0}]
[null,"  6.  Add: Any other income from other sources ",null,null,{"$f":"SUM(C94:C97)","v":0},null,"       Deduction under Sec  80CCE ",null,{"$f":"D123","v":0}]
[null,null,null,null,null,null,{"$f":"\"    \"&B99","v":"    80C - PF & VPF Contribution"},{"$f":"C99","v":0}]
[null," 7. Income from house property ",null,null,{"$f":"E122","v":0},null,"    80C - Life Insurance premiums",0]
[null,null,null,null,null,null,"    80C - N.S.C (Investment + accrued Int first five year)",0]
[null," 8.  Gross Total Income",null,null,{"$f":"SUM(E14+E15+E16+E18)","v":0},null,"    80C - Home. Loan (Principal Repayment)",0]
[null," 9.  Less: Deduction under chapter VI A ",null,null,{"$f":"0-SUM(D123,D127:D129,C22:C24,C126)","v":0},null,"    80CCC -Pension  Plan",{"$f":"C124","v":0}]
[null,null,{"$f":"SUM(C105:C108,C130)","v":0},null,null,null,"    80CCD1 - New Pension Secheme (Employee Contribution) ",{"$f":"C125","v":0}]
[null,"      Section 80TTA- Interest received in Saving Account",{"$f":"MIN(IF(C15=\"\",0,C15),C15,10000)","v":0},null,null,null,"    80CCD2 -New Pension Scheme- Employer Contribution    ",null,{"$f":"C126","v":0}]
[null,"      Section 80EE- Relief on Home Loan Interest ",{"$f":"E112","v":0},null,null,null,"    80CCG -Rajiv Gandhi Equity Scheme",null,{"$f":"D127","v":0}]
[null," 10.  Total Income"," ",null,{"$f":"IF(J43>0,\"Trial Version Expired\",SUM(E20+E21))","v":0},null,"    80D - Medical Insurance premiums+Health Check",null,{"$f":"E128","v":0}]
[null," 11.  Total Taxable Income (Round off to nearest 10 rupees)",null,null,{"$f":"ROUND(E25,-1)","v":0},null,"    80G    Donation to approved fund",null,{"$f":"C130","v":0}]
[null," 12.  Tax on Total Income ",null,null,{"$f":"IF(D4=\"FEMALE\",E46,IF(D4=\"SR. CITIZEN\",E47,IF(D4=\"VERY SR. CITIZEN\",E48,E45)))","v":"0"},null,{"$f":"\"    \"&B105","v":"    Section 80DD"},null,{"$f":"C106","v":0}]
[null," 13.   Rebate U/S - 87A",null,null,{"$f":"IF(E25<=250000,0,IF(E25>350000,0,IF(E25>250000,IF(E27<2500,E27,2500),0)))","v":0},null,{"$f":"\"    \"&B106","v":"    Section 80E"},null,{"$f":"C105","v":0}]
[null," 14.  Total Tax after rebate",null,null,{"$f":"IF(E27-E28>0,E27-E28,0)","v":0},{"$f":"ROUNDUP(F30,0)","v":0},"    80TTA- Interest received in Saving Account",null,{"$f":"C23","v":0}]
[null," 15. Surcharge on Total Taxable Income",null,null,{"$f":"MIN(C42:C43)","v":0},{"$f":"0.02*(E29+E30)","v":0},"    80EE - Addnl Interest benefit on home loan",null,{"$f":"C24","v":0}]
[null," 16.  Add - Education Cess & Secondary and higher education Cess ",null,null,{"$f":"IF(E29=\"0\",\"0\",SUM(F29,F32))","v":0},{"$f":"0.01*(E30+E29)","v":0},"    10.  Total Income",null,null,{"$f":"E25","v":0}]
[null," 17.  Total Tax Payable",null,null,{"$f":"SUM(E29:E31)","v":0},{"$f":"ROUNDUP(F31,0)","v":0},"    11.  Total Taxable Income (Round off to nearest 10 rupees)",null,null,0]
[null," 18.  Tax Deduction at Source",0,null,{"$f":"IF(J43>0,\"Trial Version Expired\",C33)","v":0},null,"    12.  Tax on Total Income ",null,null,"0"]
[null," 19. Advance tax paid",0,null,{"$f":"C34","v":0},null,"    13.   Rebate U/S 87A",null,null,0]
[null," 20.  Balance Tax Payable / Refundable",{"$f":"IF(E35>0,\"Payable\",IF(E35<1,\"Refundable\"))","v":"Refundable"},null,{"$f":"IF(J43>0,\"For Original click here\",E32-(E33+E34))","v":0},null,"    14.  Total tax after rebate",null,null,0]
[null,null,null,null,null,null,"    15. Surcharge on Total Taxable Income",null,null,0]
[null,null,null,null,null,null,"    16.  Education Cess & SHEC (2%+1%)",null,null,0]
[null,null,null,null,null,null,"    17.  Total Tax Payable",null,null,0]
[null,null,null,null,null,null,"    18.  Tax Deduction at Source",null,null,0]
[null,null,null,null,null,null,"    19. Advance Tax paid",null,null,0]
[null,null,null,null,null,null,"    20.  Balance Tax",{"$f":"C35","v":"Refundable"},null,0]
[null,"Surcharge",{"$f":"IF(E25>5000000,E27*10%,IF(E25>10000000,E27*15%,0))","v":0}]
[null,null,{"$f":"IF(E25-5000000>0,(E25-5000000)*70%,0)","v":0},null,null,null,"2017-08-30",null,{"$f":"TODAY()","v":"2017-02-14"},{"$f":"I43-G43","v":-197}]
[]
[null,"50% 0F Basic Salary",{"$f":"C80*0.5","v":0},"M",{"$f":"IF(E26>1000000,(E26-1000000)*30%+(112500),IF(E26>500000,(E26-500000)*20%+(12500),IF(E26>250000,(E26-250000)*5%,\"0\")))","v":"0"}]
[null,"40% 0f Basic Salary",{"$f":"C80*0.4","v":0},"F",{"$f":"IF(E26>1000000,(E26-1000000)*30%+(112500),IF(E26>500000,(E26-500000)*20%+(12500),IF(E26>250000,(E26-250000)*5%,\"0\")))","v":"0"}]
[null,null,{"$f":"IF(E26>1000000,E27*10%,0)","v":0},"S CIT",{"$f":"IF(E26>1000000,(E26-1000000)*30%+(110000),IF(E26>500000,(E26-500000)*20%+(10000),IF(E26>300000,(E26-300000)*5%,\"0\")))","v":"0"}]
[null,null,{"$f":"IF(E26-1000000>0,(E26-1000000)*70%,0)","v":0},"VSCIT",{"$f":"IF(E26>1000000,(E26-1000000)*30%+(100000),IF(E26>500000,(E26-500000)*20%,\"0\"))","v":"0"}]
[null,null,"MALE","FEMALE","SR. CITIZEN","VERY SR. CITIZEN"]
[]
[]
[null,"Metro","          Uniform Allowance"]
[null,"Non Metro","          Helper Allowance"]
[null,null,"          Washing Allowance"]
[null,null,"          Academic Allowance"]
[null,"MALE","          Research or Training All"]
[null,"FEMALE","            Interest from - Fixed Deposit(FD)"]
[null,"SR CITIZEN","            Interest from - Recuring Deposit(RD)"]
[null,"VERY SR CITIZEN","            Interest on N.S.C.(Accrued/ Recd )"]
[null,null,"            Interest from Post Office M.I.S (6 yrs.)  "]
[null,null,"            Interest on Saving Bonds"]
[null,"       Section 80CCD-Additional cont in NPS"]
[null,"       Section 80DD ","       80C - PF & VPF Contribution"]
[null,"       Section 80DDB","       80C - Life Insurance premiums "]
[null,"       Section 80E","       80C - PPF a/c Contribution "]
[null,"       Section 80GG","       80C - N.S.C (Investment + accrued Int first five year) "]
[null,"       Section 80GGA","       80C - Home. Loan (Principal Repayment )  "]
[null,"       Section 80GGA","       80C -Tuition  fees  for 2 children "]
[null,"       Section80GGC","       80C - E.L.S.S(Mutual Fund)"]
[null,"       Section 80U","       80C - FD (5 Years and above)"]
[null,null,"       80C - Tax Savings Infrastructure Bonds "]
[null,null,"       80C - Other Investments"]
[null,null,"Self Ocupied"]
[null,null,"Let Out"]
[null,null,"Both"]
[]
[]
[null,null,null,{"$f":"IF(D81<=0,0,MIN(D80:D82))","v":0}]
[null,"             City of Residence (Select applicable City)","Metro"]
[null,"             Basic Salary (Basic+DA+Commision)",0,{"$f":"IF(C79=\"Metro\",C45,C46)","v":0}]
[null,"             Rent Paid",0,{"$f":"C81-C80*0.1","v":0}]
[null,"             H.R.A received",0,{"$f":"C82","v":0}]
[null,"          Transport Allowances (u/s 10(14)) ",0,{"$f":"IF(C83>=19200,19200,IF(C83<19200,C83))","v":0}]
[null,"          Children Education Allowance (u/s 10(14))",0,{"$f":"MIN(IF(C84=\"\",0,C84),C84,2400)","v":0},{"$f":"SUM(D84:D85)","v":0}]
[null,"          Children Hostel Allowance (u/s 10(14))",0,{"$f":"MIN(IF(C85=\"\",0,C85),C85,7200)","v":0}]
[null,"          Medical Bills Reimbursement (u/s 17(2))",0,{"$f":"MIN(IF(C86=\"\",0,C86),C86,15000)","v":0}]
[null,"     Enter the exempted LTA allowance (in cell) as per rule (if applicable)  "]
[null,"          LTA (u/s 10(5) with rule 2B)",0,{"$f":"C88","v":0}]
[null,"        Select applicable allowance from Drop Down List"]
[null,"Uniform Allowance",0,0]
[null,"Helper Allowance",0,0]
[null,"Washing Allowance",0,0]
[]
[null,"Interest from - Fixed Deposit(FD)",0]
[null,"Interest from - Recuring Deposit(RD)",0]
[null,"Interest on N.S.C.(Accrued/ Recd )",0]
[null,"Other Sources",0]
[]
[null,"80C - PF & VPF Contribution",0,{"$f":"SUM(C123:C125)","v":0}]
[null,"80C - Life Insurance premiums",0]
[null,"80C - N.S.C (Investment + accrued Int first five year)",0]
[null,"80C - Home. Loan (Principal Repayment)",0]
[null,"80C - Tuition  fees  for 2 children",0]
[]
[null,"Section 80DD",0,{"$f":"SUM(D130+C130+C105+#REF!)","v":{"$error":"#REF!"}}]
[null,"Section 80E",0]
[]
[null,"SELF OCCUPIED"]
[null,"Housing Loan Sanction date",{"$f":"D109-E109","v":5841},"2016-04-01","2000-04-04"]
[null,"Value of the residential house Property",null,{"$f":"IF(C109<=0,1,0)","v":0},0]
[null,"Housing loan Sanctioned Amount ",null,{"$f":"IF(E113>=250000,50000,E113-200000)","v":-200000},0]
[null,"Amount claimed u/s 80 EE ",{"$f":"IF(E111<=3500000,1,0)","v":1},{"$f":"IF(E110<=5000000,1,0)","v":1},{"$f":"IF(D112=0,0,IF(C112=0,0,IF(D110=0,0,IF(D111<=0,0,D111))))","v":0}]
[null,"Housing Loan Interest paid (Self occupied property)",null,null,0]
[null,"LET OUT"]
[null,"            Annual Letable value",null,null,0]
[null,"            Unrealised Rent ",null,null,0]
[null,"Municipal Tax Paid",null,null,0]
[null,"Net Annual value",null,null,{"$f":"E115-(E116+E117)","v":0}]
[null,"Less : Repairs and Maintenance (30% of annual value)",null,null,{"$f":"E118*30%","v":0}]
[null,"Interest paid during the year",null,null,0]
[null,"Income (Loss) from house property",null,{"$f":"IF(E113>=200000,\"-200000\",IF(E113<200000,0-E113))","v":0},{"$f":"(E118-E119)-E120","v":0}]
[null,null,null,null,{"$f":"E121+D121","v":0}]
[null,"`",{"$f":"SUM(C99:C103)","v":0},{"$f":"IF(D99>150000,150000,D99)","v":0}]
[null,"       80CCC -Pension  Plan",0]
[null,"       80CCD- New Pension Secheme -Employee Contribution  ",0]
[null,"       80CCD- New Pension Scheme- Employer Contribution    ",0,{"$f":"IF(C127>=50000,50000,C127)","v":0}]
[null,"       80CCG -Rajiv Gandhi Equity Scheme",0,{"$f":"IF(C7>=1000000,0,MIN(IF(D126=\"\",0,D126)*50%,25000))","v":0}]
[null,"       80D - Medical Insurance premiums+Health Check",0,{"$f":"IF(C128>=25000,25000,IF(C128<25000,C128))","v":0},{"$f":"SUM(D128:D129)","v":0}]
[null,"       80D - Medical Insurance premiums (for Parents)",0,{"$f":"IF(C129>=30000,30000,IF(C129<30000,C129))","v":0}]
[null,"       80G  Donation to approved fund(as per applicability 50%/100%)  ",0,{"$f":"SUM(D128+D129)","v":0}]
[null,null,{"$f":"SUM(C105:C108)","v":0}]

{"sheet":"Simple Tax Calculator","index":2,"n_rows":119,"n_cols":10,"rows_kept":119,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,6,0,10],[1,1,1,4],[1,6,1,9],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,2,5,4],[5,8,5,9],[7,1,7,2],[18,1,18,3],[20,1,20,3],[24,1,24,2],[27,1,27,2],[29,1,29,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,3],[38,1,38,2],[69,1,69,4],[70,1,70,4],[79,1,79,3],[56,2,63,2]]}
[null,"Simple                                           VERSION 12.1                       .                                                                                with Hyper links of Rules                                            .                         for the Financial Yr 2017 -18/ Assessment yr 2018 -19"]
[null,"                          - for Inputs the amount & informations                                                                                                           Other cells will calculate data & tax automatically.       "]
[null,"  CALCULATION OF INCOME TAX  ","D.O.B","00/00/0000",null,null,"  COMPUTATION OF INCOME TAX          ",null,"D.O.B",{"$f":"D3","v":"00/00/0000"}]
[null,"Write your Full Name and Address","ASSESSE","MALE",null,null," for the Financial Yr 2017-18, Assessment yr 2018-19 ",null,"ASSESSE",{"$f":"D4","v":"MALE"}]
[null,null,"PAN",null,null,null,{"$f":"\" NAME : \"&UPPER(B5)","v":" NAME : "},null,"PAN",{"$f":"UPPER(D5)","v":""}]
[null,null,"PHONE :                                                                                                                                              ",null,null,null,{"$f":"\" ADDRESS : \"&UPPER(B6)","v":" ADDRESS : "},null,{"$f":"C6","v":"PHONE :                                                                                                                                              "}]
[null,"  1. Gross Annual Income/Salary (include all allowances & Perks)",0,null,{"$f":"SUM(C7)","v":0},null,"  1.   Gross Annual Income/Salary ",null,null,{"$f":"E7","v":0}]
[null,"  2. Less: Allowances exempt u/s 10 &17( for Service Period ) ",null,null,{"$f":"SUM(D9+SUM(D14:D24))","v":0},null,"  2.   Allowances exempt - u/s 10 & 17",null,null,{"$f":"E8","v":0}]
[null,"  Calculate H.R.A. Exemption(U/S 10(13A) (if Detail of Basic & HRA is available)",null,{"$f":"IF(D12<=0,0,MIN(D11:D13))","v":0},null,null,"         H.R.A. Exemption -u/s10(13A) ",{"$f":"D9","v":0}]
[null,"             City of Residence (Select applicable City)","Metro",null,null,null,"         Transport Allowances  - u/s 10(14) ",{"$f":"D14","v":0}]
[null,"             Basic Salary (Basic+DA+Commision)",0,{"$f":"IF(C10=\"Metro\",C87,C88)","v":0},null,null,"         Children Education Allowance - u/s 10(14)",{"$f":"D15","v":0}]
[null,"             Rent Paid",0,{"$f":"C12-C11*0.1","v":0},null,null,"          Medical Bills Reimbursement  - u/s 17(2)",{"$f":"D18","v":0}]
[null,"             H.R.A received",0,{"$f":"C13","v":0},null,null,"          LTA Exemption  - u/s 10(5)",{"$f":"D20","v":0}]
[null,"          Transport Allowances (u/s 10(14)) ",0,{"$f":"IF(C14>=19200,19200,IF(C14<19200,C14))","v":0},{"$f":"MIN(IF(C15=\"\",0,C15),C15,3600)","v":0},null,{"$f":"B22","v":"          Helper Allowance"},{"$f":"D22","v":0}]
[null,"          Children Education Allowance (u/s 10(14))",0,{"$f":"SUM(D16:D17)","v":0},{"$f":"MIN(IF(C15=\"\",0,C15),C15,1200)","v":0},null,{"$f":"B23","v":"          Academic Allowance"},{"$f":"D23","v":0}]
[null,"         No of Children studying in School (Non Hostel)",0,{"$f":"E15*C16","v":0},null,null,"  3. Deduction u/s 16 - Professional Tax/Tax on Employement",{"$f":"C26","v":0},null,{"$f":"E25","v":0}]
[null,"         No of Children studying in School (Hostel)",0,{"$f":"E14*C17","v":0},null,null,"                                   Entertainment allowance",{"$f":"D27","v":0}]
[null,"          Medical Bills Reimbursement (u/s 17(2))",0,{"$f":"MIN(IF(C18=\"\",0,C18),C18,15000)","v":0},null,null,"  4.   Income under the head salaries",null,null,{"$f":"E28","v":0}]
[null,"     Enter the exempted LTA allowance (in cell) as per rule (if applicable)  ",null,null,null,null,"  5.   Interest received in saving account",null,null,0]
[null,"          LTA (u/s 10(5) with rule 2B)",0,{"$f":"C20","v":0},null,null,"  6.   Any other income from other sources",null,null,0]
[null,"        Select applicable exempted allowance from Drop Down List",null,null,null,null,"  7.   Income from house property",null,null,{"$f":"D35","v":0}]
[null,"          Helper Allowance",0,0,null,null,"  8.   Gross Total Income",null,null,{"$f":"E36","v":0}]
[null,"          Academic Allowance",0,0,null,null,"  9.   Deduction under chapter VI A ",null,null,{"$f":"E37","v":0}]
[null,"   OR - Total Allowances exemption  u/s 10 &17                                       .  (if Detail of Basic, HRA & other heads etc. are not available)",0,0,null,null,"       Deduction under Sec  80CCE (Max Rs.1,50,000/-)",null,{"$f":"D39","v":0}]
[null,"  3. Deduction u/s 16",null,null,{"$f":"C26+D27","v":0},null,{"$f":"B40","v":"       80C - PF & VPF Contribution"},0]
[null,"       (i) Professionsal Tax / tax on Employment (u/s 16(ii)) ",0,null,null,null,"       80C - Life Insurance premiums ",0]
[null,"      (ii) Entertainment Allowance ( for Govt Servent only) (u/s 16(iii))",0,{"$f":"IF(C27>=5000,5000,IF(C27<5000,C27))","v":0},null,null,"       80C -Tuition  fees  for 2 children ",0]
[null,"  4.  Income under the head salaries",null,null,{"$f":"E7-(E8+E25)","v":0},null,"       80C - FD (5 Years and above)",0]
[null,"  5.  Interst received from saving A/c (Bank/Post Post Office) ",0,null,{"$f":"C29","v":0},null,"       80C - Home. Loan (Principal Repayment )  ",0]
[null,"  6.  Add: Any other income from other sources (Select Souces from Drop Down List)",null,null,{"$f":"SUM(C31:C34)","v":0},null,"       80CCC -Pension  Plan",{"$f":"C45","v":0}]
[null,"            Interest from - Fixed Deposit(FD)",0,null,null,null,"       80CCD1 - New Pension Secheme (Employee Contribution) ",{"$f":"C46","v":0}]
[null,"            Interest from Post Office M.I.S (6 yrs.)  ",0,null,null,null,"       80CCD2 -New Pension Scheme- Employer Contribution    ",null,{"$f":"C47","v":0}]
[null,"            Interest on Saving Bonds",0,null,null,null,"       80CCG -Rajiv Gandhi Equity Scheme",null,{"$f":"D48","v":0}]
[null,"            Other Sources",0,null,null,null,"       80D - Medical Insurance premiums+Health Check -Self",null,0]
[null," 7. Income from house property (Go to B66)",null,{"$f":"E79","v":0},null,null,"       80D - Medical Insurance / Expend. (V.Sr.Cit) - Parents",null,0]
[null," 8.  Gross Total Income",null,null,{"$f":"SUM(E28+E29+E30+D35)","v":0},null,"       80G    Donation to approved fund",null,0]
[null," 9.  Less: Deduction under chapter VI A ",null,null,{"$f":"0-SUM(D39,D48:D50,C51:C56)","v":0},null,{"$f":"B52","v":"       Section 80CCD (Adnl cont in NPS)"},null,0]
[null,"Select Applicable heads from drop down list",null,null,null,null,"       Section 80GG",null,0]
[null,"       a 1.  Deduction under Sec  80CCE (Max Rs.1,50,000/-)",null,{"$f":"IF(D40>150000,150000,D40)","v":0},null,null,"       Section 80U",null,0]
[null,"       80C - PF & VPF Contribution",0,{"$f":"SUM(C40:C46)","v":0},null,null,"       80TTA- Interest received in Saving Account",null,0]
[null,"       80C - Life Insurance premiums ",0,null,null,null,"    10.  Total Income",null,null,{"$f":"E57","v":0}]
[null,"       80C -Tuition  fees  for 2 children ",0,null,null,null,"    11.  Total Taxable Income (Round off to nearest 10 rupees)",null,null,0]
[null,"       80C - FD (5 Years and above)",0,null,null,null,"    12.  Tax on Total Income ",null,null,"0"]
[null,"       80C - Home. Loan (Principal Repayment )  ",0,null,null,null,"    13.   Rebate U/S 87A",null,null,0]
[null,"       80CCC -Pension  Plan",0,null,null,null,"    14.  Total tax after rebate",null,null,0]
[null,"       80CCD1 - New Pension Secheme -Employee Contribution  ",0,null,null,null,"    15. Surcharge on Tatal Taxable Income ",null,null,{"$f":"E62","v":0}]
[null,"       80CCD2 - New Pension Scheme- Employer Contribution    ",0,null,null,null,"    16.  Education Cess @ 3% ",null,null,0]
[null,"       80CCG -Rajiv Gandhi Equity Scheme",0,{"$f":"IF(D39>=1000000,0,MIN(IF(C48=\"\",0,C48)*50%,25000))","v":0},null,null,"    17.  Total Tax Payable",null,null,0]
[null,"       80D - Medical Insurance premiums+Health Check",0,{"$f":"IF(C49>=25000,25000,IF(C49<25000,C49))","v":0},null,null,"    18.  Relief u/s 89,90 and 91",null,null,0]
[null,"       80D - Medical Insurance / Expenses (V Sr.Citizen) (for Parents)",0,{"$f":"IF(C50>=30000,30000,IF(C50<30000,C50))","v":0},null,null,"    19. Tax Payable",null,null,0]
[null,"       80G  Donation to approved fund (as per applicability 50%/100%)  ",0,{"$f":"SUM(D49+D50)","v":0},null,null,"    20.  Tax Deduction at Source",null,null,0]
[null,"       Section 80CCD (Adnl cont in NPS)",0,{"$f":"SUM(D51+C51+C52+#REF!)","v":{"$error":"#REF!"}},null,null,"    21.  Advance Tax",null,null,0]
[null,"       Section 80GG",0,null,null,null,"    22.  Balance Tax",{"$f":"C69","v":"Refundable"},null,0]
[null,"       Section 80U",0]
[null,"       Section 80TTA- Interest received in Saving Account",{"$f":"MIN(IF(C29=\"\",0,C29),C29,10000)","v":0}]
[null,"       Section 80EE Relief on Housing Loan Interest",{"$f":"C85","v":0}]
[null," 10.  Total Income"," ",null,{"$f":"IF(D86>0,\"Trail Version Expired\",SUM(E36+E37))","v":0}]
[null," 11.  Total Taxable Income (Round off to nearest 10 rupees)",null,null,{"$f":"ROUND(E57,-1)","v":0}]
[null," 12.  Tax on Total Income ",null,null,{"$f":"IF(D4=\"FEMALE\",E88,IF(D4=\"SR CITIZEN\",E89,IF(D4=\"VERY SR CITIZEN\",E90,E87)))","v":"0"}]
[null," 13.   Rebate U/S - 87A",null,null,{"$f":"IF(E58<=250000,0,IF(E58>350000,0,IF(E58>300000,2500,IF(E58>50000,E59))))","v":0},{"$f":"ROUNDUP(F61,0)","v":0}]
[null," 14.  Total Tax after rebate",null,null,{"$f":"IF(E59-E60>0,E59-E60,0)","v":0},{"$f":"0.02*(E61+E62)","v":0}]
[null," 15. Surcharge on Tatal Taxable Income ",null,null,{"$f":"MIN(G91:G92)","v":0},{"$f":"0.01*(E61+E62)","v":0}]
[null," 16.  Add - Education Cess @ 3%(Sec-2%+Hsec-1%)",null,null,{"$f":"IF(E61=\"0\",\"0\",SUM(F60,F63))","v":0},{"$f":"ROUNDUP(F62,0)","v":0}]
[null," 17.  Total Tax Payable",null,null,{"$f":"SUM(E61:E63)","v":0}]
[null," 18. Relief u/s 89,90 and 91",0,null,{"$f":"0-C65","v":0}]
[null,"19. Tax Payable",null,null,{"$f":"IF(D86>0,\"Trail Version Expired\",SUM(E64:E65))","v":0}]
[null," 20.  Tax Deduction at Source",0,null,{"$f":"C67","v":0}]
[null," 21.  Advance Tax Paid",0,null,{"$f":"C68","v":0}]
[null," 22.  Balance Tax Payable / Refundable",{"$f":"IF(E69>0,\"Payable\",IF(E69<1,\"Refundable\"))","v":"Refundable"},null,{"$f":"IF(D86>0,\"For Original click here\",E66-SUM(E67:E68))","v":0}]
[null,"          Calculation of Income from house property "]
[null," Loan taken ( before 31st March 2013) Or After 1st Apr 13 but let out "]
[null," Accommodation Status -  SELF OCCUPIED /  LET OUT","Let Out"]
[null,"            Annual Letable value",0,{"$f":"IF(C72=\"Self Ocupied\",\"0\",C73)","v":0}]
[null,"            Unrealised Rent ",0,{"$f":"IF(C72=\"Self Ocupied\",\"0\",C74)","v":0}]
[null,"Less-Taxes Paid to Local Authority  ",0,{"$f":"IF(C72=\"Self Ocupied\",\"0\",C75)","v":0}]
[null,"            Net Annual Value",{"$f":"C73-(C74+C75)","v":0},{"$f":"IF(C72=\"Self Ocupied\",\"0\",C76)","v":0}]
[null,"Less-Repair & Collection Charges(30% of Net Annual Value) ",{"$f":"C76*30%","v":0},{"$f":"IF(C72=\"Self Ocupied\",\"0\",C77)","v":0}]
[null,"Less-Interest on Housing Loan",0,{"$f":"IF(C72=\"Self Ocupied\",C91,C78)","v":0}]
[null,"Net Income / Loss from House Property",{"$f":"IF(C72=\"Self Ocupied\",(D76-D77-D78),(C76-C77)-D78)","v":0},{"$f":"IF(C84>=200000,\"-200000\",IF(C84<200000,0-C84))","v":0},{"$f":"C79+D79","v":0}]
[null,"( Loan taken After 1st April 2013 for self occulpied Home)"]
[null,"Housing loan sanction Date","2016-04-01",{"$f":"E81-C81","v":0},"2016-04-01"]
[null,"Value of the Residential House Property",0,{"$f":"IF(D81<=0,1,0)","v":1}]
[null,"Home Loan Amount sanctioned",0,{"$f":"IF(C84>=250000,50000,C84-200000)","v":-200000}]
[null,"Interst Paid",0,{"$f":"IF(C82<=5000000,1,0)","v":1},{"$f":"IF(C83<=3500000,1,0)","v":1}]
[null,"Relief u/s 80EE",{"$f":"IF(D84=0,0,IF(E84=0,0,IF(D82=0,0,IF(D83<=0,0,D83))))","v":0}]
[null,"2017-08-30",{"$f":"TODAY()","v":"2017-02-14"},{"$f":"C86-B86","v":-197}]
[null,"50% 0F Basic Salary",{"$f":"C11*0.5","v":0},"M",{"$f":"IF(E58>1000000,(E58-1000000)*30%+(112500),IF(E58>500000,(E58-500000)*20%+(12500),IF(E58>250000,(E58-250000)*5%,\"0\")))","v":"0"}]
[null,"40% 0f Basic Salary",{"$f":"C11*0.4","v":0},"F",{"$f":"IF(E58>1000000,(E58-1000000)*30%+(112500),IF(E58>500000,(E58-500000)*20%+(12500),IF(E58>250000,(E58-250000)*5%,\"0\")))","v":"0"}]
[null,null,{"$f":"IF(E58>1000000,E59*10%,0)","v":0},"S CIT",{"$f":"IF(E58>1000000,(E58-1000000)*30%+(110000),IF(E58>500000,(E58-500000)*20%+(10000),IF(E58>300000,(E58-300000)*5%,\"0\")))","v":"0"}]
[null,null,{"$f":"IF(E58-1000000>0,(E58-1000000)*70%,0)","v":0},"VSCIT",{"$f":"IF(E58>1000000,(E58-1000000)*30%+(100000),IF(E58>500000,(E58-500000)*20%,\"0\"))","v":"0"}]
[null,null,{"$f":"IF(C78>=200000,\"200000\",IF(C78<200000,C78))","v":0},null,null,null,{"$f":"IF(E57>5000000,E59*10%,IF(E57>10000000,E59*15%,0))","v":0}]
[null,null,null,null,null,null,{"$f":"IF(E57-5000000>0,(E57-5000000)*70%,0)","v":0}]
[]
[null,"Metro","          Uniform Allowance"]
[null,"Non Metro","          Helper Allowance"]
[null,null,"          Washing Allowance"]
[null,null,"          Academic Allowance"]
[null,"MALE","          Research or Training All"]
[null,"FEMALE","            Interest from - Fixed Deposit(FD)"]
[null,"SR CITIZEN","            Interest from - Recuring Deposit(RD)"]
[null,"VERY SR CITIZEN","            Interest on N.S.C.(Accrued/ Recd )"]
[null,null,"            Interest from Post Office M.I.S (6 yrs.)  "]
[null,null,"            Interest on Saving Bonds"]
[null,"       Section 80CCD (Adnl cont in NPS)","       80C - PF & VPF Contribution"]
[null,"       Section 80DD  ","       80C - Life Insurance premiums "]
[null,"       Section 80DDB","       80C - PPF A/C Contribution "]
[null,"       Section 80E","       80C - N.S.C (Investment + accrued Int first five year) "]
[null,"       Section 80GG","       80C - Home. Loan (Principal Repayment )  "]
[null,"       Section 80GGA","       80C -Tuition  fees  for 2 children "]
[null,"       Section 80GGA","       80C - E.L.S.S(Mutual Fund)"]
[null,"       Section80GGC","       80C - FD (5 Years and above)"]
[null,"       Section 80U","       80C - Tax Savings Infrastructure Bonds "]
[null,null,"       80C Sukanya Samridhi Account"]
[null,null,"       80C - Other Investments"]
[]
[null,null,"Self Ocupied"]
[null,null,"Let Out"]
[null,null,"Both"]
[null,"Housing Loan Interest"]

{"sheet":"Information & Rules exmpt,Ded","index":3,"n_rows":117,"n_cols":2,"rows_kept":117,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1]]}
["Auto Income Tax Calculator                                                                                                                                                                                                                                     by B.P.Choudhary  "]
["                                                  Version 12.0 for the Financial year 2017- 18, ASSESSMENT YEAR 2018-19                                                       .                      "]
["                  Brief detail of Information and RULES for(Rates,Deductions,Exemption etc.)                                                                             ( Mini Ready Reckoner)"]
[null," Follow theTax Rules & Informations (where applicable). "]
[1,"New Tax  Rates  for Financial-Year 2017-18, Assessment Year  2018-2019"]
[2,"Some  Exempted Receipts / Special allowances &  Perquisite which are not chargable to tax"]
[3,"Some Exempted Income ( to be shown while Return filing) "]
[4,"T A X   R U L E S  &  O T H E R   U S E F U L   I N F O R M A T I O N S"]
["I","HRA exemption-u/s 10(13A)"]
["II","Transport allowance"]
["III","Reimbursement of Medical bills "]
["IV"," u/s(5) LTA  Exemption "]
["V"," u/s 24  and 80EE Exemption for interest on housing loan."]
["VI","u/s 80CCE & 80CCD Maximum Exemption "]
["VII","Rajiv Gandhi Equity Savings Scheme "]
["VIII","u/s 80D Medical Insurance"]
["IX","u/s 80DD Deduction in respect of medical treatment of handicapped dependents"]
["X","u/s 80DDB Deduction in respect of medical treatment for specified ailments or diseases"]
["XI","u/s 80E Interest repayment on education loan"]
["XII","u/s 80G Donations given for certain charities "]
["XIII","u/s 80GG If Assesse is not getting  HRA,  but living in rented house,"]
["XIV","u/s 80U If assesse have a permanent physical disability "]
["XV","u/s 80TTA Deduction on interest on saving bank accounts."]
[5," KNOW MORE about DEDUCTION under Section 80-C"]
["a","Qualifying Investments u/s 80CCE"]
["b","Provident Fund (PF) & Voluntary Provident Fund (VPF) "]
["c","Life Insurance Premiums & Unit linked Insurance Plan (ULIP)"]
["d","Public Provident Fund (PPF):"]
["e","National Savings Certificate (NSC):"]
["f","Home Loan Principal Repayment & Stamp Duty and Registration Charges for a home "]
["g","Tuition  fees  for 2 children "]
["h","Equity Linked Savings Scheme (ELSS)"]
["i","5-Yr bank fixed deposits (FDs)  or 5-Yr post office time deposit (POTD)"]
["j","Pension Funds or Pension Policies "]
["k","Sukanya Samridhi Account"]
["l","Infrastructure Bonds: NABARD rural bonds:"]
["m","Senior Citizen Savings Scheme 2004 (SCSS)"]
[6,"I M P O R T A N T -  A D V I S ES"]
[null," As per budget proposals of 2017 - TAX  RATES  For Financial Year 2017-18 & Assesment Year 2018-19  "]
[null,"                                                For MALE ASSESSE  "]
[null,"   Net Income Range                                                   Income Tax Rates"]
[null,"  Up to ₹ 2,50,000                                                                    NIL"]
[null,"  ₹ 2,50,001 to ₹ 5,00,000                                       5% on Total Income (-) ₹ 2,50,000"]
[null,"  ₹ 5,00,001 to ₹ 10,00,000                                ₹12,500+20% of Total Income (-) ₹5,00,000"]
[null,"  More than ₹ 10.00,000                                   ₹1,12,500+30% of Total Income (-) ₹10,00,000"]
[null,"Note- (u/s 87A- A rebate upto ₹ 2500/-  for assessee with Income range upto ₹ 3,50,00 )"]
[null,"                                     For  FEMALE  ASSESSE ( same tax slab as Male Assesse)"]
[null,"     Net Income Range                                                 Income Tax Rates"]
[null,"   Up to ₹2,50,000                                                           NIL"]
[null,"   ₹250,001 to ₹5,00,000                                            5% of Total Income (-) ₹2,50,000"]
[null,"   ₹5,00,001 to ₹10,00,000                                   ₹12,500 + 20% of Total Income (-) ₹5,00,000"]
[null,"   More than ₹10.00,000                                     ₹1,12,500 + 30% of Total Income (-) ₹10,00,000"]
[null,"Note- (u/s 87A- A rebate upto ₹2500/-  for assessee with Income range upto ₹ 3,50,000)"]
[null,"     For SENIOR CITIZEN  ASSESSE (Above 60 Year ) attaining the age during the year "]
[null,"       Net Income Range                                              Income Tax Rates"]
[null,"    Up to  ₹3,00,000                                                           NIL"]
[null,"    ₹3,00,001 to 5,00,000                                                            5% of Total Income(-) ₹3,00,000"]
[null,"    ₹5,00,001 to 10,00,000                                         ₹10,000 +20% of Total Income (-) ₹5,00,000"]
[null,"    More than ₹10.00,000                                       ₹1,10,000 +30% of Total Income (-) ₹10,00,000"]
[null,"Note- (u/s 87A- A rebate upto ₹ 2500/-  for assessee with Income range upto ₹ 3,50,000)"]
[null,"    For VERY SENIOR CITIZEN  ASSESSE (Above 80 Year ) attaining the age during the year "]
[null,"      Net Income Range                                              Income Tax Rates"]
[null,"    Up to ₹5,00,000                                                           NIL"]
[null,"    ₹5,00,001 to ₹10,00,000                                         20% of Total Income (-) ₹10,00,000"]
[null,"    More than ₹10,00,000                                         ₹1,00,000 +30% of Total Income (-) ₹10,00,000"]
[null,"Note: 1. Education Cess is 2% & Secondary and Higher education Cess is 1% of income tax from all Assesse.                                                                                                                                                            .        2. Surcharge on income tax @10% for income above ₹50 Lakh & 15% for income above ₹1crore  "]
[null," Some  Exempted Receipts /Special allowances &  Perquisite which are not chargable to tax are  "]
[null," Exempted Receipts - 1.  Medical Reimbursement (Max ₹15000/- Per annum)    2.  L.T.A (as per Rule)                                                            "]
[null,"Special allowances Exempted u/s 10(14)                                                                                                                                                                                                                                                                      1. Uniform Allowance (granted to meet the expenditure incurred on purchase or maintenance of uniform to be worn during performance of Official Duty)                                                                     2. Helper Allowance ( granted to meet exependiture incurred on helper for performance of official duty)                                                                                                                                                   3. Academic Allowance (granted for encouraging academic, research & training pursuits) including Newspaper, Generals etc.)                                                                                                              4. Children Education Allowance ( ₹100 P.M. per child / (₹300 for hostel expenditure) Max of 2 children)                                                                                                                                                   5. Convayance allowance ( granted to meet the expenditure incurred on convayance, while performing official duty.                                                                                                                                 .   ( Expenditure incured for covering journey between office and residence is not treated as expenditure in performance of official duty. ) "]
[null," Deduction available u/s -16                                                                                                                                                                                                                                                                          1. Entertainment allowance (for Govt Employees) Max  ₹5000/-                                                                                                                                                                                                                           2. Professional tax - Professional tax paid by employee is deducted from Gross salary."]
[null," Perquisite not chargable to tax"]
[null," Free food and beverage 1. Food and non-alcoholic beverages provided in working hours in remote area or an offshore instalation are exempted to tax                                                                                                                                    2. Tea, coffee or non-alcoholic beverages and snaks in working hours are tax free perquisites.                                                                                                                                                                                                                                                            3. Meals (Lunch and / or dinner) in office hours is not taxable. If cost to the employeris  ₹50 (or Less) per meal.  "]
[null," Some Exempted Income are ( to be shown while Return filing) "]
[null,"         1.  Withdrawal / Maturity / Interest received from PF,PPF,Sukanya Samridhi Account, Life Insurance policy, Agriculture. (Max up to ₹5000/- )"]
[null,"         2    Long Term Capital Gain From Shares"]
[null,"         3.   Dividend on shares in companies"]
[null,"         4.   Interest on Saving Bank & Post Office A/c up to  ₹ 10,000/- ( Sec-80TTE)"]
[null,"Please Note :"]
[null,"(i) Interest earned from all sources are to be included. All interest (including saving Bank A/C (above ₹10,000), FD income are fully taxable)."]
[null,"(II) As per clarification from IT department, all perquisites such as rent-free accommodation, company provided car, free or concessional education facilities, employee stock option plan, free club membership, company provided credit card, gift vouchers, meal coupons, hotel stay beyond 15 days, are fully taxable. "]
[null,"T A X   R U L E S  &  O T H E R   U S E F U L   I N F O R M A T I O N S  for"]
["I"," House Rent Allowance exemption-10(13A) = Least amount of anyone (i) 40% of Salary (50%, if house situated in Mumbai, Calcutta, Delhi or Madras)                                                                                                                                                                                                                                   .                                                                                                             or (ii) Actual HRA Recived                                                                                                                                                                                                                                                        .                                                                                                             or (iii) Rent paid minus 10% of salary * Salary= Basic + DA (if part of retirement benefit) + Turnover based Commission                                              Note i. Fully Taxable, if HRA is received by an employee who is living in his own house or if he does not pay any rent                                                                                                                                                          ii. It is mandatory for employee to report PAN of the landlord to the employer if rent paid is more than ₹ 1,00,000 [Circular No. 08 /2013 dated 10th October, 2013]. (In case the landlord does not have PAN, employee should submit a declaration stating the same along with the landlord’s details.)"]
["II       ","Transport allowance is exempt up to ₹1600/- per month during the month (₹ 3,200 per month for blind and handicapped employees) .                                                                                                                                                      Transport Allowance is granted to an employee to meet expenditure on commuting between place of residence and place of duty"]
["III","Reimbursement of Medical bills(on producing of Bills) are exempt for self and dependent family, up to ₹15,000/- per annum "]
["IV"," u/s(5) LTA is exempt to the tune of economy class Train/ Air /Recognised public Transport fare for the family to any destination in India, by the shortest route.                                                                                                                   LTA can be claimed twice in a block of 4 calendar yea₹ The current block is from 01.01.2014 to 31.12.2017. For claim, it is must to provide originals tickets etc."]
["   V(a) New Change","u/s 24 and 80 EE There is an Exemption for interest on housing loan.(for Self occupied Residence). If the loan was taken before Apr 1, 1999 exemption is limited to ₹30,000/- per year. If the loan was taken after Apr 1, 1999 exemption is limited to ₹2,00,000/- per year if the house is self-occupied; There is no limit if the house is rented out\nThis exemption is available on accrual basis, which means if interest has accrued, you can claim exemption, irrespective of whether you've paid it or not..                                                                                                                                         80EE In finance bill 2016 (an additional rebate of ₹.50.000/- was given to those assesse, who purchase self ocupied single house after 01/04/2016 with maximum value of ₹ 60 Lacs and sanctioned home loan up to 35 Lacs.)                         "]
["      (b)","If you have rented out your house, Whole the interest will be eligible for deduction. (after deducting property tax and standard maintenance expenses from rent recived)."]
["VI","u/s 80CCE- Maximum Exemption up to  ₹1,50,000/-  Investments up to ₹1.5 lac in PF, VPF, PPF, Employee contribution in NPS,Insurance Premium, Housing loan principal repayment, NSC, ELSS, long term bank Fixed Deposit, Post Office Term Deposit, etc. are deductible from the taxable income. There is no limit on individual items, (for example) all 1.5 lac can be invested in NSC or PPF etc.  "]
["VII    ","u/s 80CCD(1):  The Finance Act, 2015 provides that contribution made by the Central Government or any other employer to NPS shall be excluded while computing the limit of Rs1,50,000.The contribution by the employee to the NPS will be subject to the limit of ₹1,50,000.                                                                                                                                                                                                                                                                                                                                                Section 80CCD: Additional Contribution to New Pension Scheme (NPS) - It will provide an additional deduction of upto ₹ 50,000 over and above the limit of ₹ 1.50 lakh in respect of contributions made to NPS under Section 80CCD(1).                                                                                                                                                                                                                                                                                                                                                                                                                      Section 80CCD (2):  Contribution to Pension Account (by Employer) - Deduction available for the amount paid or deposited by the employer of the assessee in a pension scheme notified or as may be notified by the Central Government subject to a maximum of 10% of salary in the financial year\n\n"]
["VIII","u/s 80CCG - Rajiv Gandhi Equity Savings Scheme exemption available for investment in stock markets (direct equity). Avaialble only for those with gross income less than 12 lacs and only for first time investors in stock market. Exemption available at 50% of investment subject to maximum of ₹50,000/- invested. Investments are locked-in for three years"]
["IX     ","u/s 80D Medical Insurance Premium (such as Mediclaim & Critical illness Cover with contribution in CGHS & Preventive Health Check up Upto INR.5000/-) Premium is exempt up to INR.55,000/ per year (₹25,000/- for self,spouse and children ) (₹25,000/- or ₹30,000/- for Parents) If Parents are Senior Citizen (above 60 years of age), Exempted premium up to ₹30,000/0 oterwise upto ₹.25,000/-.                               For Very Senior Citizen (Age 80+) - (In case of no Mediclaim) Any payment made on account of Medical expenditure in respect of very senior citizens will be allowed as deduction u/s 80D of a maximum of ₹30,000/-"]
["X    ","u/s 80DD Deduction in respect of medical treatment of handicapped dependents is limited to ₹75,000/- per year if the disability is less than 80% and Rs1,25,000/- per year if the disability is more than 80%"]
["XI      ","u/s 80DDB Deduction in respect of medical treatment for specified ailments or diseases for the assesse or dependent can be claimed up to ₹40,000/- per year. If the person being treated is a senior citizen (Age 60-80Yrs), the exemption can go up to ₹60,000/-. If the person is very senior citizen (Age 80+), the exemption can go up to ₹ 80,000/- but any amount received under Medical Insurance Policy will be reduced from the amount of deduction allowed. The Diseases and ailments specified under rule 11DD are.                                                                                                                                                                                                            (1) Neurological diseases being demetia, dystonia musculorum deformans, motor neuron disease, ataxia, chorea, hemiballismus, aphasia and parkisons disease, (2) cancer, (3) AIDS, (4)Chronic renal failure, (5) hemophilia, and (6) thalassaemia.                                                                                                                                                                                                                                                                                  Note:The assessee will be required to obtain a prescription/Certificate from a specialist doctor whether from Govt or Pvt. for the purpose of availing this deduction. "]
["XII","u/s 80E Interest repayment on education loan (taken for higher education from a university of self & dependents) is completely tax exempt"]
["XIII","u/s 80G Donations given for certain charities are tax exempt.NGO,Trust etc. are exempt to the tune of 50%, whereas Govt funds are 100%. "]
["XIV         New","u/s 80GG If you are not getting  HRA, but living in rented house, an exemption is available. This will be calculated as minimum of (25% of total income or rent paid - 10% of total income or ₹ 60,000/- per year)"]
["XV","u/s 80U who suffers from not less than 40 per cent of any disability is eligible for deduction to the extent of ₹ 75,000/- and in case of severe disability to the extent of ₹ 1,25,000/-"]
["XVI","u/s 80TTA introduced through Finance Act, 2012. Section 80TTA provides a deduction of up to ₹10,000 on your income from interest on saving bank accounts."]
[null,"                                       KNOW MORE about DEDUCTION under Section 80-C and chapter VIA "]
[null,"Section 80C of the Income Tax Act allows certain investments and expenditure to be deduct from total income - One must plan investments well and spread it out across the various instruments specified under this section to avail maximum tax benefit. There are no sub-limits and is irrespective of how much you earn and under which tax bracket you fall. Most of the Income Tax payee try to save tax by saving under Section 80C of the Income Tax Act.  However, it is important to know the Section in total. so that one can make best use of the options available for deduction under income tax Act. One important point to note that one can not only save tax by undertaking the specified investments, but some expenditure which you normally incur can also give you the tax exemptions.\n\n\n\n\n"]
[null,"                                         Qualifying Investments u/s 80CCE are"]
["a","Provident Fund (PF) & Voluntary Provident Fund (VPF) PF is automatically deducted from your salary. your contribution [12% of Basic] (i.e., employee’s contribution) is counted towards section 80C investments. You also have the option to contribute additional amounts through voluntary contributions (VPF). Current rate of interest is 8.5% per annum (p.a.) and is tax-free.\n\n\n\n\n"]
["b","Life Insurance Premiums: Any amount that you pay towards life insurance premium in Life Insurance Corporation (LIC) or any other Insurance CO.for yourself, your spouse or your children can also be included in Section 80C deduction. If you are paying premium for more than one insurance policy, all the premiums will be included. also premium paid for ULIP will also be treated as Premium paid for Life Insurance Policies.                                                                                                                                                                                                                        Unit linked Insurance Plan : ULIP stands for Unit linked Saving Schemes. ULIPs cover Life insurance with benefits of equity investments.They have attracted the attention of investors and tax-savers not only because they help us save tax but they also perform well to give decent returns in the long-term.\nIMP : Total Amount Received at Maturity, Survival Benefits, , Withdrawl in Insurance Policies is Tax Free and fully exempteed u/s 10(10D)."]
["c","Public Provident Fund (PPF): Among all the assured returns small saving schemes, Public Provident Fund (PPF) is one of the best. Current rate of interest is 8% tax-free and the normal maturity period is 15 years Minimum amount of contribution is ₹500 and maximum is ₹1,50,000.(New Change) from Finance Act  2014\n\n"]
["d","National Savings Certificate (NSC): National Savings Certificate (NSC) is a 5-Yr small savings instrument eligible for section 80C tax benefit. Rate of interest is  8.58% compounded half-yearly, i.e. If you invest ₹100, it becomes ₹150.90 after five years. The interest accrued every year is liable to tax (i.e. to be included in your taxable income) but the interest is also deemed to be reinvested and thus eligible for section 80C deduction."]
["e","Home Loan Principal Repayment & Stamp Duty and Registration Charges for a home Loan The Equated Monthly Installment (EMI) that you pay every month to repay your home loan consists of two components – Principal and Interest.The principal component of the EMI qualifies for deduction under Sec 80C. Even the interest component can save you significant income tax – but that would be under Section 24 of the Income Tax Act. The amount you pay as stamp duty when you buy a house, and the amount you pay for the registration of the documents of the house can be claimed as deduction under section 80C in the year of purchase of the house.\n\n"]
["f","Tuition  fees  for 2 children  Apart form the above major investments expenses for children’s education (Only Tution Fee (for which you need receipts)), can be claimed as deductions under Sec 80C.\n\n\n\n\n"]
["g","Equity Linked Savings Scheme (ELSS): There are some mutual fund (MF) schemes specially created for offering you tax savings, and these are called Equity Linked Savings Scheme, or ELSS. The investments that you make in ELSS are eligible for deduction under Sec 80C.\n\n"]
["h","5-Yr bank fixed deposits (FDs): Tax-saving fixed deposits (FDs) of scheduled banks with tenure of 5 years are also entitled for section 80C deduction.                                                                                             5-Yr post office time deposit (POTD) scheme: POTDs are similar to bank fixed deposits. Although available for varying time duration like one year, two year, three year and five year, only 5-Yr post-office time deposit (POTD) – which currently offers 7.5 per cent rate of interest –qualifies for tax saving under section 80C. Effective rate works out to be 7.71% per annum (p.a.) as the rate of interest is compounded quarterly but paid annually. The Interest is entirely taxable.\n\n\n\n"]
["i","Pension Funds or Pension Policies – Section 80CCC: This section – Sec 80CCC – stipulates that an investment in pension funds is eligible for deduction from your income. Section 80CCC investment limit is clubbed with the limit of Section 80C – it means that the total deduction available for 80CCC and 80C is ₹1.5 Lakh.This also means that your investment in pension funds upto ₹1.5 Lakh can be claimed as deduction u/s 80CCC. However, as mentioned earlier, the total deduction u/s 80C and 80CCC can not exceed  ₹1.5 Lakh.\n\n\n"]
["j","Infrastructure Bonds: These are also popularly called Infra Bonds. These are issued by infrastructure companies, and not the government. The amount that you invest in these bonds can also be included in Sec 80C deductions.                                                                                                                                                                \nNABARD rural bonds: There are two types of Bonds issued by NABARD (National Bank for Agriculture and Rural Development): NABARD Rural Bonds and Bhavishya Nirman Bonds (BNB). Out of these two, only NABARD Rural Bonds qualify under section 80C.\n\n"]
["k","Senior Citizen Savings Scheme 2004 (SCSS): A recent addition to section 80C list, Senior Citizen Savings Scheme (SCSS) is the most lucrative scheme among all the small savings schemes but is meant only for senior citizens. Current rate of interest is 9% per annum payable quarterly. Please note that the interest is payable quarterly instead of compounded quarterly. Thus, unclaimed interest on these deposits won’t earn any further interest. Interest income is chargeable to tax.\n\n\n\n"]
["l","Sukanya Samridhi Account : Contribution made in a financial year in Sukanya Samriddhi Account will also be eligible for income tax exemption under Section 80C up to a maximum of ₹ 1,50,000/-  "]
[null,"I M P O R T A N T -  A D V I S ES"]
[null," Mostly people gives estimated declaration at year starting to minimise their Tax Liabilities but could not save up to last and face heavy burden in last months. Many of us start looking for investment avenues only in February or March, just before the Financial Year is getting over. This is a big mistake! One, you would end up investing your money without putting proper thought to it. And secondly, you would end up losing the interest / appreciation for the whole year. Instead, decide where you want to make the investments, and start investing right from the beginning of the financial year – from April. so it is advisable to save from start on monthly basis through Bank ECS as a SIP . This way, you would not only make informed decisions, but would also earn the interest for the full year from April to March. \n\n\n"]
[null," C A L L   M  E    F O R   P R E S E N T A T I O N   :  B. P. C H O U D A R Y         P h :  9 8 1 1 3 0 2 4 9 7, 9 2 1 1 1 2 5 5 8 7 or M a i l  "]
[null,"                                                                                                                                                                                                                                  TOP"]

{"sheet":"Income HP","index":4,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,7],[2,1,2,7],[3,1,3,7],[4,1,4,6],[5,1,5,6],[6,1,6,6],[7,1,7,6],[9,1,9,7],[10,1,10,6],[11,1,11,6],[12,1,12,6],[13,1,13,6],[14,1,14,6],[15,1,15,6],[17,1,17,6],[18,1,18,6]]}
[]
[null,"for print purpose only                                                                                                  Income from House Property with software Calculator"]
[null," Income from house property"]
[null,"FOR SELF OCCUPIED PROPERTY",null,null,null,null,null,null,null,"Note: If date is coming different from sanctioned date"]
[null,"  Housing Loan Sanction date",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E109","v":"2000-04-04"},null,"ç Write Date in software window as 01 APRIL 2016"]
[null,"  Value of the residential house Property",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E110","v":0}]
[null,"  Housing loan Sanctioned Amount ",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E111","v":0}]
[null,"  Housing Loan Interest paid (Self occupied property)",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E113","v":0}]
[]
[null,"FOR LET OUT PROPERTY"]
[null,"  Annual Letable value",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E115","v":0}]
[null,"  Unrealised Rent ",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E116","v":0}]
[null,"  Municipal Tax Paid",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E117","v":0}]
[null,"  Net Annual value",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E118","v":0}]
[null,"  Repairs and Maintenance (30% of annual value)",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E119","v":0}]
[null,"  Interest paid during the year",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E120","v":0}]
[]
[null,"  Income from house property",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E122","v":0}]
[null,"  Interest Rebate u/s 80 EE ",null,null,null,null,null,{"$f":"'Software Tax Calculator'!E112","v":0}]

{"sheet":"Ex All - OS","index":5,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,1,1,6],[2,1,2,6],[3,1,3,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,6],[13,1,13,6],[14,1,14,5],[15,1,15,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,6],[20,1,20,6],[21,1,21,5],[22,1,22,5],[23,1,23,5],[24,1,24,5]]}
[]
[null,"for print purpose only                                                            Calculation in Software calculator"]
[null,"Allowances exempt u/s 10 & 17"]
[null,"1. HRA exemption ",null,null,null,null,{"$f":"'Software Tax Calculator'!D78","v":0},null,"HRA Exemption","    (i) (40% (50% for metros) of salary",null,null,null,{"$f":"'Software Tax Calculator'!D80","v":0}]
[null,"2. Transport Allowances",null,null,null,null,{"$f":"'Software Tax Calculator'!D83","v":0},null,"Least Amount of","or (ii)Actual HRA Recived",null,null,null,{"$f":"'Software Tax Calculator'!D82","v":0}]
[null,"3. Children Education Allowance",null,null,null,null,{"$f":"'Software Tax Calculator'!D84","v":0},null,"anyone","or (iii) Rent paid - 10% of ( Basic+DA)",null,null,null,{"$f":"'Software Tax Calculator'!D81","v":0}]
[null,"4. Children Hostel Allowance",null,null,null,null,{"$f":"'Software Tax Calculator'!C85","v":0}]
[null,"5. Medical Bills Reimbursement",null,null,null,null,{"$f":"'Software Tax Calculator'!D86","v":0}]
[null,"6. LTA ",null,null,null,null,{"$f":"'Software Tax Calculator'!C88","v":0}]
[null,{"$f":"\"7. \"&'Software Tax Calculator'!B90","v":"7. Uniform Allowance"},null,null,null,null,{"$f":"'Software Tax Calculator'!D90","v":0}]
[null,{"$f":"\"8. \"&'Software Tax Calculator'!B91","v":"8. Helper Allowance"},null,null,null,null,{"$f":"'Software Tax Calculator'!D91","v":0}]
[null,{"$f":"\"9. \"&'Software Tax Calculator'!B92","v":"9. Washing Allowance"},null,null,null,null,{"$f":"'Software Tax Calculator'!D92","v":0}]
[]
[null,"HRA exemption Calculation"]
[null,"     City of Resedence",null,null,null,null,{"$f":"'Software Tax Calculator'!C79","v":"Metro"}]
[null,"     Basic Salary",null,null,null,null,{"$f":"'Software Tax Calculator'!C80","v":0}]
[null,"     Rent Paid",null,null,null,null,{"$f":"'Software Tax Calculator'!C81","v":0}]
[null,"     HRA received",null,null,null,null,{"$f":"'Software Tax Calculator'!C82","v":0}]
[null,"     HRA exemption u/s 10 (13A)",null,null,null,null,{"$f":"'Software Tax Calculator'!D93","v":0}]
[]
[null,"Income from other sources"]
[null,{"$f":"\"        \"&'Software Tax Calculator'!B94","v":"        Interest from - Fixed Deposit(FD)"},null,null,null,null,{"$f":"'Software Tax Calculator'!C94","v":0}]
[null,{"$f":"\"        \"&'Software Tax Calculator'!B95","v":"        Interest from - Recuring Deposit(RD)"},null,null,null,null,{"$f":"'Software Tax Calculator'!C95","v":0}]
[null,{"$f":"\"        \"&'Software Tax Calculator'!B96","v":"        Interest on N.S.C.(Accrued/ Recd )"},null,null,null,null,{"$f":"'Software Tax Calculator'!C96","v":0}]
[null,{"$f":"\"        \"&'Software Tax Calculator'!B97","v":"        Other Sources"},null,null,null,null,{"$f":"'Software Tax Calculator'!C97","v":0}]

{"sheet":"Subscription","index":6,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,1,8,3],[1,1,2,1]]}
[null,"                 Auto IncomeTax Calculator Version 12.1"]
[null,"This calculator 12.1 is a  for individuals and Professional/Official. You can compute you tax liability & know related rules. but print of computation sheet is restricted                                                                                                         If you require version calculator to maintain data forever or print computation sheet for professional/Offical use.                                                                                                                                                                                                                                                  Kindly subscribe with a nominal subscription of ₹ 500/- only                                                 Free Form-16 Preparation calculator for prepare form-16 of Assessment year 2017-18"]
[]
[null,"For subscription                                                                                                                                                                                                                                                                Deposit Cash in any of the following account                                                                                         or                                                                                                                                                                                                                                                                                   Transfer through internet banking:  NAME : BIJENDER PAL CHOUDHARY                                  Type of Account - Saving                                                                        "]
[null,"(1)  A/c No –  182401500851 - ICICI Bank - Branch, R K PURAM - IFSC Code ICIC0001824"]
[null,"(2)  A/c No - 011104000089274 - IDBI Bank - Branch, Siri Fort - IFSC Code IBKL0000010  "]
[null,"(3)  A/C N0 - 29280100009041 - Bank of Baroda -Branch, Munirka - IFSC Code BARBOMUNIRK   or paytm at 9211125587  "]
[null,"after subscription mail at bpchoudhary@gmail.com or taxationseva@gmail.com for send Original version"]
[null,"visit us at:   http://www.taxationseva.com"]