The details of sales recorded by selecting the Nature of Transactions , Interstate Sales - E1 and Interstate Sales - E2 are displayed in Annexure 28 :
To view Annexure 28
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX .
2. Click A : Annexures .
3. Select Annexure 28 .
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-28 : 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 at the To (blank for end) field of Export Report screen. |
|
Annexure - 28 Worksheet |
|
|
Lorry Receipt/Railway Receipt/Transport document Number |
Displays the Lorry/Railway Rcpt No. entered in the Statutory Details screen of sales invoice. |
|
Lorry Receipt/Railway Receipt/Transport document Date |
Displays the date entered for Lorry/Railway Rcpt No. in the Statutory Details screen of sales invoice. |
|
Name of the seller from whom goods where purchased |
Displays the Name of Seller entered in the Statutory Details screen of sales invoice. |
|
Address of the seller from whom goods where purchased |
Displays the Address of Seller entered in the Statutory Details screen of sales invoice. |
|
TIN of Seller |
Displays the TIN of Seller entered in the Statutory Details screen of sales invoice. |
|
Purchase Invoice No. |
Displays the Supplier inv. no. entered in the Statutory Details screen of sales invoice. |
|
Purchase Invoice Date |
Displays the date entered for Supplier inv. no . in the Statutory Details screen of sales invoice |
|
Value of goods purchased |
Displays the amount entered as Goods Purchased Value in Purchase Details screen of sales invoice. |
|
Name of the carrier |
Displays the name of carrier entered in the Statutory Details screen of sales invoice. |
|
Address of the carrier |
Displays the Address of carrier entered in the Statutory Details screen of sales invoice. |
|
Date of endorsement on the transport document |
Displays the Date of Endorsement entered in the Statutory Details screen of sales invoice |
|
Date of landing of goods in the place of the dealer effecting the transit sale |
Displays the date of land of goods entered in the Statutory Details screen of sales invoice. |
|
Transit sale Invoice No. |
Displays the voucher or invoice number of the sales invoice. |
|
Transit sale Invoice Date |
Displays the voucher or invoice date of the sales invoice. |
|
Value of goods sold in transit |
Displays the assessable value of each item selected in the invoice. |
|
Name of the buyer |
Displays the name of the party ledger selected in the invoice. |
|
TIN of buyer |
Displays the VAT TIN predefined for the party ledger selected in the invoice. TIN is 11 digits long. |
|
Address of the buyer |
Displays the Address predefined in the party ledger master or entered in the Party Details screen of purchase invoice. |
|
Date of landing of goods in the place of the TRANSIT buyer |
Displays the date entered for receiving of goods by transit buyer in the Statutory Details screen of sales invoice. |
