Annexure 201 B

The Gujarat Commercial Tax Department has provided five excel templates for Annexure 201B. 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 201B 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 201B 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 201B report period, the From and To dates are displayed here. These dates can be changed from Form 201B report, if required.

6.     Press Enter to export data.

The data gets exported to the e-return template.

Pre-requisites for generating Annexure 201B

Nature of Transaction

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

●      For capital goods, in the ledger master:

o      Select Fixed Assets as the group.

o      Set Is VAT/CST Applicable to Applicable.

o      Enable the option Set/Alter VAT Details.

o      Select Purchase Taxable - Capital Goods as the Nature of transaction.

Tax Rates

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

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

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

●      For Nature of Transaction, Purchase Taxable - Capital Goods, only 4%, 5% and 12.5% tax rates are considered.