This topic explains the pre-requisites for generating Annexure B, and the procedure to print and export Annexure B.
Nature of Transaction
The invoice should be recorded with the following nature of transactions:
● Branch Transfer Inward
● Consignment Transfer Inward
● Imports
● Interstate Branch Transfer Inward
● Interstate Consignment Transfer Inward
● Interstate Purchase - Against Form C
● Interstate Purchase - E1
● Interstate Purchase - E2
● Interstate Purchase - Taxable
● Interstate Purchase - Zero Rated
● Interstate Purchase Deemed Export
● Interstate Purchase Exempt
● Interstate Purchase Exempt - E1
● Purchase - Works contract
● Purchase - Zero Rated
● Purchase Deemed Export
● Purchase Exempt
● Purchase From Composition Dealer
● Purchase From Unregistered Dealer
● Purchase Taxable - Capital Goods
● Purchase Others
● Purchase Others-Exempt
To print Annexure B in word format
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form III.
2. Select Annexure Ready and press Enter.
3. Select Annexure B and press Enter.
4. Press Ctrl+P to view the Print Report screen. Based on the Form III report period, the From and To dates are displayed here. These dates can be changed from e-VAT Annexures report, if required.
5. Enter the Name, Status/Designation, Place and Date.
6. Press Enter to print.
Description of Annexure B when printed in word format.
Column Name |
Description |
(i) Name of the Purchasing dealer |
Displays the Mailing Name entered in the Company Creation screen. |
(ii) TIN |
Displays the TIN entered in the Company VAT Details screen. |
(iii)(2) Name and address of the seller |
Displays the name and address of the party predefined in the party ledger or entered in the Party Details screen of the invoice. |
(iii)(3) TIN |
Displays the VAT TIN predefined for the party ledger or entered in Party Details screen of the invoice. |
(iii)(4) Type of Purchase/stock transfer document received ( For e.g.tax invoice restrictive tax invoice/sales bill/cash memorandum etc.) |
Displays the type of purchase based on the method in which the transaction has been recorded. |
(iii)(5) Tax invoice Restrictive tax invoice/Sales bill/Cash memorandum /Transfer note No. |
Displays the Supplier Invoice No. entered in the purchase invoice. |
(iii)(6) Date of such document |
Displays the supplier invoice Date entered in the purchase invoice. |
(iii)(7) Description of Commodity |
Displays the Commodity name predefined for the stock item selected in the invoice. |
(iii)(8) Rate of tax charged if any |
Displays the rate of tax charged for each stock item in the invoice. |
(iii)(9) Value of goods |
Displays the assessable value of the stock items selected in the invoice. |
(iii)(10) Amount of tax charged |
Displays the VAT amount charged in the invoice. |
(iii)(11) Total amount |
Displays the total invoice value. |
(iii)(12) Category of Purchase/stock transfer received |
Displays the category based on the nature of transactions. |
To export data to Annexure B template
1. Copy the excel template to the Tally.ERP 9 installed folder.
2. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form III.
3. Select Annexure Ready and press Enter.
4. Select Annexure B and press Enter.
5. Click E: Export to view the Export Report screen. Based on the Form III report period, the From and To dates are displayed. These dates can be changed from e-VAT Annexures report, if required.
6. Press Enter to export data.
Description of Annexure B when exported to excel template of e-annexure.
Column Name |
Description |
SELLER_TIN |
Displays the VAT TIN predefined for the party ledger or entered in Party Details screen of the invoice. |
SELLER_NAME |
Displays the name of the party predefined in the party ledger or entered in the Party Details screen of the invoice. |
SELLER_ADDRESS |
Displays the address of the party predefined in the party ledger or entered in the Party Details screen of the invoice. |
TYPE_OF_PURCHASE |
Displays the type of purchase based on the method in which the transaction has been recorded. |
INVOICE_NO |
Displays the Supplier Invoice No. entered in the purchase invoice. |
INVOICE_DATE |
Displays the supplier invoice Date entered in the purchase invoice. |
COMMODITY_DESCRIPTION |
Displays the Commodity name predefined for the stock item selected in the invoice. |
RATE |
Displays the rate of tax charged for each stock item in the invoice. |
VALUE |
Displays the assessable value of the stock items selected in the invoice. |
TAX |
Displays the VAT amount charged in the invoice. |
TOTAL |
Displays the total invoice value. |
CATEGORY |
Displays the category based on the nature of transactions. |