Monday, February 8, 2010

TAX CALCULATION FY 09-10 FORMULA SHORT CUTS EXCEL(+NUMBER TO TEXT


on Monday, February 8, 2010

Tax Calculation now made easy by Simple Tax India,Tax calculation is difficult Job for normal persons but it is difficult for Professionals persons Like me also ,its difficult to write the lengthy formula again and again.or even if we are coping the same from some other Excel sheet then also we have to find out the old file and required cell in the file.So I thought there should be excel command in one go to calculate Tax on woman ,sr citizen and for other also.so with the help from CA Yogesh Gupta ,I have developed a Excel Add-in which will create short cuts to calculate Tax in one command ,no need to copy or type lengthy Formula again and again.


Features of the utility

  1. To calculate tax on resident Woman with command "Ctrl+shift+W" and following formula fill be shown in the selected excel Cell
  2. =ROUND(IF(E10>500000,ROUND(E10-500000,-1)*0.3+51000,IF(E10>300000,ROUND(E10-300000,-1)*0.2+11000,IF(E10>190000,ROUND(E10-190000,-1)*0.1,0))),0)
  3. To calculate tax on Resident Sr Citizen with command "Ctrl+shift+S" and following formula fill be shown in the selected excel Cell.
  4. =ROUND(IF(E11>500000,ROUND(E11-500000,-1)*0.3+46000,IF(E11>300000,ROUND(E11-300000,-1)*0.2+6000,IF(E11>240000,ROUND(E11-240000,-1)*0.1,0))),0)
  5. To calculate tax on Male with command "Ctrl+shift+M" and following formula fill be shown in the selected excel Cell.
  6. =ROUND(IF(E9>500000,ROUND(E9-500000,-1)*0.3+54000,IF(E9>300000,ROUND(E9-300000,-1)*0.2+14000,IF(E9>160000,ROUND(E9-160000,-1)*0.1,0))),0)
    E10 here means cell immediate top cell in same column ,one row above
  7. Spell Figures into words in Indian as well as in other styles( excel function)


How to Install

  1. Download a Small File of just 40KB(Download short cuts for tax calculation 09-10 FY)  ,unzip the file and save it in your hard disk at any place permanently (do not change location there after, otherwise all the formula results for spell will be lost )
  2. Now Open any excel file 
  3. Go to tools >Add-ins>Browse
  4. Browse the location ,where you have placed the Downloaded File,select the file(if file is not shown at the location ,then browser window select Type of File "All Files"
  5. After selection ,click ok .
  6. A new add-in will be shown in Excel Add-ins List named as Taxcal0910
  7. Thats all ,this is one time process ,no need to do it again and again ,No macro problem ,activate macro or deactivate macro etc.
How it works 
  1. Install Add-ins first ,as shown above.
  2. type your total taxable Income.
  3. In Next row under same column ,Type command 
    1. Ctrl+shift+M for male /other person tax calculation
    2. Ctrl+shift+W for woman tax calculation
    3. Ctrt +Shift+S for Resident Senior citizen.
  4. Tax value will be shown.(in this calculator taxable income has been rounded Off to multiple of  10 and Tax has been R.off in rupees.
  5. To use Spell word type" =spell(cell number or any figure)",figure will be converted in to words.suppose you have typed "=spell(100) " then it will be shown as Rupee One hindered Only "
Benefits
  • Short Cut for tax calculation for Individual
  • Convert Figures Into Word
Hope you will found all things in order ,if not then kindly left your comment below.
Read more: INCOME TAX CALCULATION FY 10-11 EXCEL ADD IN PLUS SPELL FIGURE ADDIN | SIMPLE TAX INDIA-TDS RATE INCOME TAX RATE