Home » Archive

Articles Archive for March 2010

Excel tips »

[22 Mar 2010 | 4 Comments | ]

Recently one of my readers asked me the question how to convert numeric value in to word, This is an important function everybody looking for in excel but unfortunatly there is no ready to use formula, function in excel. however  microsoft provides a visual basic function script in their support section. This script is useful for spelling number in to US dollar.
Accountinghead is converted this function script for the use of indians  with the help of some VB experts.  Letus do it with easy 5 steps , by using this script you can convert …

Excel tips »

[14 Mar 2010 | One Comment | ]

Most of the accounting software has the option of automatic age calculation of pending bills. i.e., the number of days the bills have been pending. However there may be situations of calculating age wise pending details manually. Microsoft excel will calculate it for you by applying simple function.
Once you added the formula in the excel sheet ,you don’t need to change it every day  the age calculation will be done excel automatically based on current date.Let us see how this can be done.
Consider the following example for age calculation.

Now insert the todays …

Income tax »

[1 Mar 2010 | One Comment | ]

Income tax rate slab is changed in the recent budget by finance minister Pranab Mukherjee. The main highlights on income tax are.

Tax  slab revised
Surcharge is reduced to 7.5 % from 10 % for domestic company
extended income tax exemption to investment in infrastructure bonds by Rs 120,000.00
Limits for turnover over which accounts need to be audited enhanced to Rs. 60lakh for businesses and to Rs. 15 lakh for professions.