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/Sale Bill/Cash Memorandum etc.)
Displays the type of purchase based on the method in which the transaction has been recorded.
Type of Purchase
Transaction
Tax Invoice
Displays Tax Invoice if the purchases are recorded by:
●Setting the option Is Purchase against Restrictive Tax Invoice? to No, in Statutory Details screen of purchase invoice for the following nature of transactions:
oPurchase - Works contract
oPurchase Taxable
oPurchase Taxable - Capital Goods
●Selecting the following nature of transactions:
oInterstate Purchase - Against Form C
oInterstate Purchase - E1
oInterstate Purchase - Taxable
Restricted Tax Invoice
Displays Restricted Tax Invoice if the purchases are recorded by setting the option Is Purchase against Restrictive Tax Invoice? to Yes, in Statutory Details screen of purchase invoice for the following nature of transactions:
●Purchase - Works Contract
●Purchase - Capital Goods
●Purchase Taxable
●Purchase - Zero Rated
●Purchase Exempt
●Purchase Deemed Export
Cash Memorandum
Displays Cash Memorandum when cash/bank ledger is selected in Party's A/c Name field of purchase invoice for the following nature of transactions:
●Purchase - Zero Rated
●Purchase Deemed Export
●Purchase Exempt
●Purchase - Zero Rated
●Purchase Deemed Export
●Purchase Exempt
Stock Transfer
Displays Stock Transfer for purchases recorded with the following nature of transaction:
●Interstate Branch Transfer Inward
●Interstate Consignment Transfer Inward
●Branch Transfer Inward
●Consignment Transfer Inward
Sales Bill
Displays Sales Bill when:
●Other than cash/bank ledger is selected in purchases recorded with the following nature of transactions:
oPurchases Non-Creditable - Special Goods
oPurchase From Unregistered Dealer
oPurchase From Composition Dealer
oPurchase Others
oInterstate Purchase - E2
oInterstate Purchase - Zero Rated
oInterstate Purchase Deemed Export
oInterstate Purchase Exempt
oInterstate Purchase Exempt - With Form C
oInterstate Purchase Exempt - E1
oImport
●Other than cash/bank ledger is selected and the option Is Purchase against Restrictive Tax Invoice? is set to No in purchase invoice for the following nature of transactions:
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.
Type of Purchase
Transaction
Tax Invoice
Displays Tax Invoice if the purchases are recorded by:
●Setting the option Is Purchase against Restrictive Tax Invoice? to No, in Statutory Details screen of purchase invoice for the following nature of transactions:
oPurchase - Works contract
oPurchase Taxable
oPurchase Taxable - Capital Goods
●Selecting the following nature of transactions:
oInterstate Purchase - Against Form C
oInterstate Purchase - E1
oInterstate Purchase - Taxable
Restricted Tax Invoice
Displays Restricted Tax Invoice if the purchases are recorded by setting the option Is Purchase against Restrictive Tax Invoice? to Yes, in Statutory Details screen of purchase invoice for the following nature of transactions:
●Purchase - Works Contract
●Purchase - Capital Goods
●Purchase Taxable
●Purchase - Zero Rated
●Purchase Exempt
●Purchase Deemed Export
Cash Memorandum
Displays Cash Memorandum when cash/bank ledger is selected in Party's A/c Name field of purchase invoice for the following nature of transactions:
●Purchases Non-Creditable - Special Goods
●Purchase From Unregistered Dealer
●Purchase From Composition Dealer
●Purchase Others
●Interstate Purchase - E2
●Interstate Purchase - Zero Rated
●Interstate Purchase Deemed Export
●Interstate Purchase Exempt
●Interstate Purchase Exempt - With Form C
●Interstate Purchase Exempt - E1
●Import
●Purchase - Zero Rated
●Purchase Deemed Export
●Purchase Exempt
Stock Transfer
Displays Stock Transfer for purchases recorded with the following nature of transaction:
●Interstate Branch Transfer Inward
●Interstate Consignment Transfer Inward
●Branch Transfer Inward
●Consignment Transfer Inward
Sales Bill
Displays Sales Bill when:
●Other than cash/bank ledger is selected in purchases recorded with the following nature of transactions:
oPurchases Non-Creditable - Special Goods
oPurchase From Unregistered Dealer
oPurchase From Composition Dealer
oPurchase Others
oInterstate Purchase - E2
oInterstate Purchase - Zero Rated
oInterstate Purchase Deemed Export
oInterstate Purchase Exempt
oInterstate Purchase Exempt - With Form C
oInterstate Purchase Exempt - E1
oImport
●Other than cash/bank ledger is selected and the option Is Purchase against Restrictive Tax Invoice? is set to No in purchase invoice for the following nature of transactions:
oPurchase - Zero Rated
oPurchase Deemed Export
oPurchase Exempt
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 OF TAX
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 (assessable value + VAT).
CATEGORY
Displays the category based on the nature of transactions.
Nature of Transactions
Name of the Category
Branch Transfer Inward
Consignment Transfer Inward
Purchases effected through agents/Branches
Non Creditable Purchase - Special Goods
Inclusive of Tax (sales bill / cash Memo)
Imports
Import
Purchase From Composition Dealer
Purchase from COT Dealer
Purchase Exempt
Interstate Purchase Exempt
Interstate Purchase Exempt - E1
Interstate Purchase Exempt - With Form C
Exempt
Interstate Branch Transfer Inward
Interstate Consignment Transfer Inward
Stock-receipts from head office/branches/principals outside the state