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 > Annexure Ready.
2. Select Annexure 26.
3. Press Ctrl+E to export.
4. 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.
Field Name |
Description |
Basic Details Worksheet |
|
Dealer TIN |
Displays VAT TIN (Regular) 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. |
The details of sales recorded by selecting the Nature of Transaction as Deemed Export are displayed in Annexure 27:
To view Annexure 27
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 27.
3. Press Ctrl+E to export.
4. 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-27: This sheet will record the transaction details for the period.
Field Name |
Description |
Basic Details Worksheet |
|
Dealer TIN |
Displays VAT TIN (Regular) 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 - 27 Worksheet |
|
Name of Exporter to whom the goods were sold |
Displays the name of the party ledger selected in the sales invoice. |
TIN of exporter |
Displays the VAT TIN predefined for the party ledger selected in the sales invoice. |
Purchase order no. of the exporter |
Displays the sales order number entered in the Statutory Details screen of sales invoice. |
Purchase order date of the exporter |
Displays the date entered for Sales Order No field in the Statutory Details screen of sales invoice. |
Description of the commodity sold |
Displays the name of stock item selected in the sales invoice. |
Quantity |
Displays the quantity of goods entered in the sales invoice. |
Invoice No. |
Displays the invoice or voucher number of the sales invoice. |
Invoice Date |
Displays the invoice or voucher date of the sales invoice. |
Value of the goods sold to exporter |
Displays the assessable value of each stock item selected in the sales invoice. |
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 > Annexure Ready.
2. Select Annexure 28.
3. Press Ctrl+E to export.
4. 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.
Field Name |
Description |
Basic Details Worksheet |
|
Dealer TIN |
Displays VAT TIN (Regular) 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. |
Annexure 29 is used to file details of input VAT credit available for a particular month. It has to be filed only when there is excess input tax credit.
The details of transactions recorded by selecting the Nature of Transactions as Purchase Taxable and Sales Taxable are displayed in Annexure 29:
To view Annexure 29
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 29.
3. Press Ctrl+E to export.
4. 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-29: This sheet will record the transaction details for the period.
Field Name |
Description |
Basic Details Worksheet |
|
Dealer TIN |
Displays VAT TIN (Regular) 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 - 29 Worksheet |
|
Input Tax credit at end of previous month (Rs) |
Displays the input VAT paid during previous month on unsold goods that can be carried forward. |
Description of goods held as stock at the end of the month |
Displays the name of the unsold stock item for which input VAT is paid. |
Commodity Code |
Displays the Commodity Code entered in the stock item or stock group masters, or in the ledgers masters. |
Value (Rs) |
Displays the assessable value of each unsold commodity. |
Rate of Tax (%) |
Displays the rate of tax predefined for each commodity. |
Input Tax Credit Carried forward at the end of the month (Rs) |
Displays the input tax paid and credit carried forward for each commodity to the next return period. |
