This topic explains the pre-requisites for generating Annexure A, and the procedure to print and export Annexure A.
Voucher Type
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 following nature of transactions:
● Branch Transfer Outward
● Consignment Transfer Outward
● Deemed Export
● Exports
● Interstate Branch Transfer Outward
● Interstate Consignment Transfer Outward
● Interstate Sales - Against Form C
● Interstate Sales Exempt - With Form C
● Interstate Sales - E1
● Interstate Sales - E2
● Interstate Sales - Taxable
● Interstate Sales - Zero Rated
● Interstate Sales Exempt
● Interstate Sales Exempt - E1
● Sales - Works contract
● Sales Exempt
● Sales High Seas
● Sales Taxable
● Sales Zero Rated
● Interstate Sales - Works contract
To print Annexure A 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 A and press Enter .
4. Press Ctrl+P to view the Print Report screen. Based on the Annexure A 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 .
Description of Annexure A when printed in word format.
Column Name |
Description |
|||||||||||||||||||||||||||
(i) Name of the selling 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 purchaser |
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 sales/stock transfer document issued (For e.g. Tax Invoice Restrictive Tax Invoice/Sales Bill/Cash Memorandum etc.) |
Displays the type of sale 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 sales invoice number. |
|||||||||||||||||||||||||||
(iii)(6) Date of issue |
Displays the sales invoice date. |
|||||||||||||||||||||||||||
(iii)(7) Description of Commodity |
Displays the Commodity name predefined for the stock item selected in the sales invoice. |
|||||||||||||||||||||||||||
(iii)(8) Rate of tax |
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 (assessable value + VAT) . |
|||||||||||||||||||||||||||
(iii)(12) Category of sale/stock transfer made* |
Displays the category based on the nature of transactions.
|
To export data to Annexure A 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 A 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 here. These dates can be changed from e-VAT Annexures report, if required.
6. Press Enter to export data.
Description of Annexure A when exported to excel template of e-annexure.
Column Name |
Description |
||||||||||||||||||||
PURCHASER_TIN |
Displays the VAT TIN predefined for the party ledger or entered in Party Details screen of the invoice. |
||||||||||||||||||||
PURCHASER_NAME |
Displays the name of the party predefined in the party ledger or entered in the Party Details screen of the invoice. |
||||||||||||||||||||
PURCHASER_ADDRESS |
Displays the address of the party predefined in the party ledger or entered in the Party Details screen of the invoice. |
||||||||||||||||||||
TYPE_OF_SALE |
Displays the type of sale based on the method in which the transaction has been recorded.
|
||||||||||||||||||||
INVOICE_NO |
Displays the sales invoice number. |
||||||||||||||||||||
INVOICE_DATE |
Displays the sales invoice date. |
||||||||||||||||||||
COMMODITY_DESCRIPTION |
Displays the Commodity name predefined for the stock item selected in the sales 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.
The category Inclusive of Tax (Sales bill/cash memo) is currently not supported. |
Last updated for Release 5.5.3