The details of sales recorded by selecting the Nature of Transaction as Exports are displayed in Annexure 26:
To view Annexure 26
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX.
2. Click A: Annexures.
3. Select Annexure 26.
4. Press Ctrl+E to export.
5. Specify the period and press Enter to export the data.
The XML file will be created in the Tally.ERP 9 application folder. In case of excel template, the data is exported to excel template and the xml is generated after validating the data. The different fields in the excel template are described below:
The excel template contains three worksheets:
● Help: This sheet provides details on different elements of the excel sheet and do’s and don’ts.
● Basic Details: This sheet will record the company and period information.
● Annexure-26: This sheet will record the transaction details for the period.
|
Legend |
Indicates what is new in the form/annexure |
|
Indicates what has changed in the form/annexure |
|
|
Indicates what has been removed from the form/annexure |
The fields in the annexure are described below:
|
Field Name |
Description |
|
Basic Details Worksheet |
|
|
Dealer TIN |
Displays TIN entered in Company VAT Details screen of Statutory & Taxation features. |
|
Tax Period From |
Displays the starting date of return period of the report which was entered in the From (blank for beginning) field of Export Report screen. |
|
Tax Period To |
Displays the ending date of return period of report which was entered in the To (blank for end) field of Export Report screen. |
|
Annexure - 26 Worksheet |
|
|
IE code of exporter |
Displays the Export/Import Code predefined for the party ledger selected in the sales invoice. |
|
Export Invoice No. |
Displays the voucher/invoice number of sales invoice. |
|
Export Invoice Date |
Displays the voucher/invoice date of sales invoice. |
|
Purchase Order No. |
Displays the sales order number entered in the Statutory Details screen of sales invoice. |
|
Purchase Order Date |
Displays the date entered for Sales Order No field in the Statutory Details screen of sales invoice. |
|
Letter of Credit No. |
Displays the Letter of Credit entered in the Statutory Details screen of sales invoice . |
|
Letter of Credit Date |
Displays the date entered for Letter of Credit in the Statutory Details screen of sales invoice. |
|
Quantity of Goods |
Displays the quantity of goods entered in the sales invoice. |
|
Description of the commodity |
Displays the name of stock item selected in the sales invoice. |
|
Value of the goods exported |
Displays the assessable value of each stock item selected in the sales invoice. |
|
Bill of lading/Airway Bill No. |
Displays the Bill of lading/Airway bill no. entered in the Statutory Details screen of sales invoice . |
|
Bill of lading/Airway Bill Date |
Displays the date entered for Bill of lading/Airway bill no. in the Statutory Details screen of sales invoice. |
|
Name of the foreign Buyer |
Displays the name of the party ledger selected in the invoice. |
|
Country of export |
Displays the Country predefined in the party ledger master or entered in the Party Details screen of sales invoice. |
|
Customs Shipping Bill No. |
Displays the Customs shipping bill No. entered in the Statutory Details screen of sales invoice. |
|
Customs Shipping bill Date |
Displays the date entered for Customs shipping bill No. in the Statutory Details screen of sales invoice. |
|
Name of the Forwarding Agent |
Displays the Name of forwarding Agent entered in the Statutory Details screen of sales invoice. |