Need Help with the New 2009-10 Income Tax Calculator? Check Out This Useful Tool!

Hi all,

Attached is the new format as per the Union Budget 2009. Please find the attached Excel file for calculating salary income tax and for investment declaration. I hope this will help everyone. Thank you for your suggestions, keep replying. Last year's data is given below for your information.

30-04-2008, 10:40 AM
Replies: 169

Latest Income Tax Calculator 2008-09

Views: 77,924

Posted By Joseph Patrao (link updated to site home) (Search on Cite | Search on Google)

Best regards,
Joseph

Dear sir,

I am a Central Government pensioner. This form is not relevant to me. My income derives only from Pension including DA and interest on my savings (including FDs). I think I have to file the income tax in form ITR-1. But this document will be useful to arrive at the amount of income tax to be paid by me while filing the return.

Jassel

Attached file without a password.

Hello Joseph,

The tax calculator attached has been nicely comprehended in a very simple manner, which makes it very easy to understand, especially for a first-timer like me.

1. I would really appreciate if you can elaborate on fixed entries in column "H" viz. 160000, 140000, 200000, and 3000 to help me calculate my tax from a woman's perspective. (I am not that good at Excel, so please excuse).

2. Also, could you please tell me if there is a rule that the tax on a bonus has to be immediately deducted on the whole amount in one shot, i.e., in the same month of the release of the bonus? If yes, then how to calculate it?

3. Under "other exemptions," is there a limit on the total amount, or is it a part of the total deduction under chapter VI-A which cannot exceed 100000/-?

4. What is the annual professional tax, 2400 or 2500/- (Karnataka)?

5. Can a "Ltd. Company" in the ITES sector deduct ESI and PF (employee strength is 16 as of now)?

An urgent response is highly solicited.

Thank you,
Mamta Singh

And really sorry to bother you, Joseph Sir... just one last thing... can a company with an employee strength of 16 be liable to issue TDS/Form 16? If not, what are the options if they are not issuing the same?

- Mamta

Hi Joseph,

One addition - the exemption under 80E, i.e., for the interest on an educational loan for higher education is missing. I guess that needs to be added in the middle column.

1 THE AMOUNT GIVEN BY YOU HAVE NO VALUE FOR SALARY THERE IS ALWAYS A HEAD NAME LIKE …. BASIC HRA ETC. PLEASE ENTER THAT IN THE RESPECTIVE HEAD PROVISED IN THE EXCEL SHEET IN “BLUE”2I T ACT SAYS EQUAL TDS HENCE YOU WILL HAVE TO PROJECT THIS IN THE BEGINNING OF THE YEAR IF THIS IS PROFT LINKE THEN KINDLY TAKE HELP FROM A CA3 THIS V-A AND HAS LIMIT TO EACH HEAD LIKE MEDICALIM, ETC 100000 LIMIT IS FOR 80C4 THIS IS NOT 2400 OR 2500 DEPENDS ON SALARY AND NO OF MONTHS PLEASE CHECK THE KARNATAKA PT SLAB. 5 PLEASE GO THROUH THIS SITE EPFO

I am an MBA student with an HR specialization. I am working on a project comparing the best HR practices between the hospitality sector and the printing sector. Please assist me with this matter.

Thank you, Joseph, for your prompt response. I found most of my answers through your help. I wanted to clarify that the figures I mentioned in question 1) are related to the static figures provided in column H of your sheet, not basic, HRA, etc. These figures (160000 in H19, 140000 in H21, 3000 in H29) appear to be derived from the tax slab. Could you please explain where these figures are coming from?

Regards, Mamta Singh

Hi, if there is no breakup in the salary, then this must be a contract or consultation fee. Do not use this format; this is only for salaried employees. There are different tax rules for consultants.

Dear Joseph,

Thank you for the sheet; it is indeed useful. However, I have a query regarding this. What if an individual employee's salary has changed in the middle of the year, or in one month, he has experienced a loss of pay resulting in his salary being less than the normal monthly salary? Is there a provision to make this correction?

Regards,
Venkat.

Hi Joseph, kindly let me know my tax calculation for the below.

---
Would you like me to review any other aspects of the message?

Kindly update my tax calculator as per my salary structure.

Hello viewers - HAPPY NEW YEAR 2010.

I am interested in learning tricks and tactics in Excel. If anybody can suggest something best in tricks and tactics in Excel, please also suggest a tax calculator in Excel format to calculate tax for the financial year 2009-10 and AY 2010-11.

Hi, After observation of your CTC attachment sheet:

1. As per the Payment of Graduate Act, graduates are eligible after a minimum of 5 years, so CTC is not applicable.
2. LTA is considered as one month of basic salary, which may not include the monthly salary.
3. Regarding income tax eligibility, medical benefits of 15k PA, so the salary sheet only shows 1250 pm -- k.

Regarding your tax calculation, I want to know about your savings such as insurance policy savings, children's education, travel allowances, four-wheeler maintenance, driver salary if applicable, mobile bills, tax exemption bonds, etc. If you send the above details, I will calculate.

Regards

Hello,

I am working as an accountant in a medical college. I have the new Form 16 and Form 16A, including calculations. Please send the above forms. I will be thankful to you, sir.

Thank you.

I want to generate Form 16 and Form 16A for the period of 01.04.2009 to 31.03.2010, including calculations.