PAN application form for Non- resident Form 49AA in Excel with auto fill function

Central Board of Direct Taxes issued notification (NotificationNo. 56/2011/ F.No.133 /48/2011 – SO (TPL)) on 17^th November 2011 to make the necessary amendment in rule no. 114 of the Income tax rules 1962. The necessary changes were made in the PAN application procedure and the following new forms were introduced:

Form49A: to be used by Indian Citizen, Hindu Undivided Families (HUF), Companies, Firm [including Limited Liability Partnership (LLP)], Trust, Association of Person, Body of Individuals, formed or registered in India and

( to download 49A click here )

Form 49AA: to be used by Individuals not being a Citizen of India, LLP, Companies, Firm, Trust, Association of Person, Body of Individuals, formed or registered outside India.

These changes are effective from 1^st November 2011.

New Tax Rates Applicable for Individuals for Financial Year 2012-13 - Tax calculator in Excel

New Tax rates for Individual applicable for the Financial Year 2012-13 (Assessment Year 2013-14) are as follows:

(i)   The rates of income-tax in the case of every individual (other than those mentioned in (ii) and (iii) below) or Hindu undivided family or every association of persons or body of individuals , whether incorporated or not, or every artificial juridical person referred to in sub-clause (vii) of clause (31) of section 2 of the Income-tax Act (not being a case to which any other Paragraph of Part III applies) are as under :—

Income	Tax Rate
Upto Rs. 2,00,000	Nil
Rs. 2,00,001 to Rs. 5,00,000	10 per cent.
Rs. 5,00,001 to Rs. 10,00,000	20 per cent.
Above Rs. 10,00,000	30 per cent.

Revised Schedule VI format in Excel

Ministry of Corporate Affairs Revised the Schedule VI of the Companies Act 1956 in which the companies have to report the financial statements. The Revised Schedule VI is applicable for the financial year starting from 1st April 2011 and later years. Revised schedule VI is announced by the Ministry through its notification dated 28th February 2011. 

The format of Revised Schedule VI with the other required disclosure requirement in Excel is provided to enable the preparation of Financial statements. 

New PAN Correction Form in Excel with auto fill option

The Data in the PAN card and the data in the income tax database can be updated or changed. To update these data PAN Correction form is to be submitted with the supporting documents to TIN facility center. This PAN Correction form in excel is a easy to prepare form with auto fill function.

New form 49A Pan application in Excel with auto fill function

The Central Board of Direct Taxes (‘CBDT’) has amended the Income-tax Rules, 1962 (‘the Rules’) by notifying Income-tax (7th Amendment) Rules, 2011 in respect of application for allotment of Permanent Account Number (‘PAN’) with effect from 1 November 2011.

As per the amended rules there will be two separate PAN application forms as under:

·Form 49A: To be used by Indian Citizen, Hindu Undivided Families (HUF), Companies, Firm [including Limited Liability Partnership (LLP)], Trust, Association of Person, Body of Individuals, formed or registered in India.

Month wise allocation of AMC charges auto calculation in Excel

When an amc income is booked or billed for more than one accounting period, this should be allocated proportionately to the different accounting periods. The excel sheet provided will enable you to automatically allocate the amount to respective period based on the period of coverage of the AMC.  

Annual Return Schedule V - Part II of Companies Act - 1956 in Excel with auto fill function

As per Section 159 of the companies Act, annual return is to be filed with the ROC with in 60 days of Annual General Meeting. The format of annual return is prescribed in Schedule V of the Act.

The excel utility helps you in preparing the annual return as per Schedule V.
Fill up the details in the "details" sheet.