Annexure 201 A

The Gujarat Commercial Tax Department has provided five excel templates for Annexure 201A. Each template has specified number of rows to provide transaction details. Based on the number of transactions recorded during a particular return period, the required template can be selected for exporting data from Tally.ERP 9.

To export data to Annexure 201A template

1.     Copy the required excel template to the Tally.ERP 9 installed folder.

2.     Go to Gateway of Tally > Display > Statutory Reports > VAT > Form 201.

3.     Select Annexure Ready and press Enter.

4.     Select Form 201A and press Enter.

5.     Click E: Export to display the Export Report screen. From the list of excel templates displayed for selection, select the required template based on the number of transactions recorded during a particular return period. Ensure the excel template is available in the Export Location.

Based on the Form 201A report period, the From and To dates are displayed here. These dates can be changed from Form 201A report, if required.

6.     Enable the option Include retail invoices also if details of transactions recorded in retail invoices are also to be exported to template. If this option is disable, transaction details of tax invoices gets exported.

7.     Press Enter to export data.

The data gets exported to the e-return template.

Pre-requisites for generating Annexure 201A

Voucher Type

In the sales voucher type, set the option Is Tax Invoice to:

●      Yes, to consider it as tax invoice.

●      No, to consider it as retail invoice.

Nature of Transaction

The invoice should be recorded with the Nature of Transactions, Sales Taxable and Sales - Works Contract.

Tax Rates

The sales invoice must be recorded with any of the following tax rates:

●      For Nature of Transaction, Sales Taxable, any tax rate can be used.

●      For Nature of Transaction, Sales - Works Contract, only 1%, 4%, 5% and 12.5% tax rates are considered.