Category: 80DDB

Categories
80C Deductions 80DDB Excel VBA Dashboard Gratuity House Rent Allowance (HRA) Human Resource (HR) India Payroll Payroll Provident Fund (PF)

Income tax calculation sheet for the financial year 2019-20 [AY 2020-21] Automated Salary Tax Calculator along 15+ other Features

Click here to download automatic Complete Payroll Calculator in Excel. This Excel Software have includes most likely all part of Payroll Calculation. It’s Includes following Feature:-

  • You can calculate Cost to company CTC Automatic once you put total ctc.
  • You can restructuring of allowances and CTC components as per your need.
  • Income Tax  to be calculate automatic.
  • You can set your investment Declaration / Proofs Planing as per requirement.
  • This sheet will calculate House rent allowance ( HRA Rent Exemption calculation) under section 10(13A) automatic as per your rent paid and selected location.
  • You can customize your structure like add / less : PF (Employees’ Provident Fund), Employment State Insurance ( ESIC), Gratuity, Mediclaim, any other benefit, Bonus, Minwages.
  • You can control to deduct PF on Basic OR PF on Allowances or PF on min wages of PF or you can select No if you are not eligible for pf deduction.
  • You can Se-off loss / income from house property u/s 24(b) as per Income Tax Act.
  • You can add reimbursement components as per bills planing to get more benefit in tax.
  • This sheet will give you Net payment Automatically as per your change.
  • Best part of this software is that, you can generate  your salary pay slip from CTC in one click and change payslip in excel as per needs.
  • We have added logo on slip so that you can change it.
  • You can generate any month salary slip from excel format in one click even you can generate full and final slip.
  • Free download
  • Paid Support Available at :
  • Email: ajityadav121@gmail.com
  • Call/WhatsApp: +91 9654421288

Click here to Download Automated Excel Sheet to calculate cost to company (CTC), Income Tax Calculation for financial year 2019-20 along with all investment planning (Deduction U/C VI-A)  and all Major Exemptions allowed + reimbursement  in Salary.

This sheet will allowed to planning your tax saving, make salary structure as per your choice and know the Net in hand Automatically.

Thanks!

Categories
80DDB India Payroll Payroll

Specified diseases and ailments for the purpose of deduction under section 80DDB.

[ 11DD ](1) For the purposes of section 80DDB, the following shall be the eligible diseases or ailments :-

(i) Neurological Diseases where the disability level has been certified to be of 40% and above:—

(a) Dementia

(b) Dystonia Musculorum Deformans

(c) Motor Neuron Disease

(d) Ataxia

(e) Chorea

(f) Hemiballismus

(g) Aphasia

(h) Parkinsons Disease

(ii) Malignant Cancers

(iii) Full Blown Acquired Immuno-Deficiency Syndrome (AIDS)

(iv) Chronic Renal failure

(v) Hematological disorders

(i) Hemophilia

(ii) Thalassaemia

(2) The certificate in respect of the diseases or ailments specified in sub-rule (1) shall be issued by the following specialists working in a Government hospital

(a) for diseases or ailments mentioned in clause (i) of sub-rule (1) – a Neurologist having a Doctorate of Medicine (D.M.) degree in Neurology or any equivalent degree, which is recognised by the Medical Council of India

(b) for diseases or ailments mentioned in clause (ii) of sub-rule (1) – an Oncologist having a Doctorate of Medicine (D.M.) degree in Oncology or any equivalent degree which is recognised by the Medical Council of India

(c) for diseases or ailments mentioned in clause (iv) of sub-rule (1) – a Nephrologist having a Doctorate of Medicine (D.M.) degree in Nephrology or a Urologist having a Master of Chirurgiae (M.Ch.) degree in Urology or any equivalent degree, which is recognised by the Medical Council of India;

(d) for diseases or ailments mentioned in clause (v) of sub-rule (1) – a specialist having a Doctorate of Medicine (D.M.) degree in Hematology or any equivalent degree, which is recognised by the Medical Council of India

Provided that where in respect of any diseases or ailments specified in sub-rule (1), no specialist has been specified or where the specialist specified is not posted in the Government hospital in which the patient is receiving the treatment, such certificate, with prior approval of the Head of that hospital, may be issued by any other specialist working full-time in that hospital and having a post-graduate degree in General or Internal Medicine, which is recognised by the Medical Council of India.

(3) The certificate from the prescribed authority to be furnished along with the return of income shall be in Form No. 10-I

Click here to download notification