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
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.
Column Name |
Description |
Tax Invoice No. (201A) |
Displays the voucher number of tax invoice or retail invoice. |
Date (dd/mm/yyyy or dd-mon-yyyy) |
Displays the voucher date of tax invoice or retail invoice. |
Name |
Displays the name of the party ledger selected in Party's A/c Name option or in Party Details screen. |
R.C. No |
Displays the VAT TIN predefined for the selected party ledger or entered in Party Details screen. |
Goods with HSN |
Displays the Commodity Code predefined for stock item selected in the invoice. |
Value of goods |
Displays the assessable value for taxable:
|
Tax |
Displays the VAT charged in sales invoice. |
Additional Tax |
Displays the additional tax charged in sales invoice. |
Total |
Displays auto-calculated value. |