The Gujarat Commercial Tax Department has provided five excel templates for Annexure 201B. Each template has a specific 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. Click A: Annexures.
4. Select Form 201B and press Enter.
5. Press Ctrl+E to view 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.
● 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.
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.
Column Name |
Description |
Tax Invoice No. |
Displays the Supplier Invoice No. entered in the purchase transaction. |
Date (dd/mm/yyyy or dd-mon-yyyy) |
Displays the Date entered against Supplier Invoice No. in the purchase transaction. |
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 the Party Details screen. |
Goods with HSN |
Displays the commodity code predefined for stock item selected in invoice. |
Value of goods |
Displays the assessable value for taxable: ● Local purchase transactions. ● Value calculated after deducting labour charges for works contract. |
Tax |
Displays the VAT calculated in purchase invoice. |
Additional Tax |
Displays the additional tax calculated in purchase invoice. |
Total |
Displays auto-calculated value. |