I am planning to make an excel template. Using template if someone put the CTC than all his salary break up will be automatic calculated and best tax efficient breakup will be displayed.

If anyone has already made or tried can update and also if you have any suggetion for each breakup. Please provide.

Posted 4 years, 1 month ago by CA Pulkit Sharma

I think salary break up will be helpful for people having business since they can compute salary payable, tds, pt, PF, ESI etc. kindly share the same.

Posted 4 years, 1 month ago by Mukesh Jain CA

When is Income from Salary taxable as Income Tax Act 1961?

any salary accrued in previous year ended, whether the salary was received or not

Any amount received as salary whether the amount accrued or not

Any salary accrued or paid by current employer or former employer and was not charged to income tax earlier

Does Income received from partnership Firm as a partner is inlcuded in Salary income?

No the income received from partnership firm as a partner should not be inluded 

What are the Deductions from Salary that are allowed?

For government employees Entertainment allowances are elgibile for deduction. However deduction is subjected to minimum of 5000, Allowance received or 1/5 of salary.

For all employees profession tax paid  is deductible.

What are few allowance which if included can help Tax savings?

Medical Allowance is exempted upto 15000.

Childrens education fees upto 100 per child and hostel Expenses upto 300 per child per month.

Transport Allowances upto 800 per month

House Rent Allowance subject to certain conditions

How can I save Tax on my salary?

Plan your salary not in March(End of the year) but in beginning of year.

Ask your employer to break the CTC in most Tax efficient manner.

Invest In PF, Insurance, Pension funds etc.  These not only help saving taxes but provide security for future.

Should I file my Income Tax Return every year?

Read this!

Posted 4 years, 1 month ago by CA Pulkit Sharma

CAn anyone provide the list of all exempted or partially exempted allowances and prequisites. Sorry but running sort of time. Its required for the template.

Posted 4 years, 1 month ago by CA Pulkit Sharma

Hey pulkit, i can download the  zip file, but there is no content in it...


Posted 3 years, 10 months ago by Kavitha Ganapathy


Can you plz send me the Salary Breakup in Excel  file to my email id ASAP 


Posted 3 years, 10 months ago by Kavitha Ganapathy

You can also download the file from my file Salary Breakup in Excel, just put the CTC

Posted 2 years, 9 months ago by CA Pulkit Sharma

Your Reply:

You need to be logged in to reply.