You can export data for any period to Annexure 23 through VAT Form 15 in Tally.ERP 9.
The revised VAT Form 23 that include the invoice wise details of local sales and purchases are supported from release 5.1 onwards. To get these provisions and support for the latest templates, it is recommended to upgrade to release 5.1 and above.
To export data to Annexure 23 template
1. Copy the required Excel template to the Tally.ERP 9 installed folder.
2. Go to Gateway of Tally > Display > Statutory Reports > VAT > VAT Form 15 .
3. Select Annexure Ready and press Enter .
4. Select Annexure - 23 and press Enter .
5. Click E : Export button to display the Export Report screen. Ensure the excel template VAT23(CH).xls is available in the Export Location .
Note: Based on the Annexure 23 report period, the From and To dates are displayed here. These dates can be changed from Annexure 23 report, if required.
6. Enter the Name and Status/Designation of the authorised person, and the Place of business. If these details are provided in the Company VAT Details screen, the same appears automatically.
7. Enter the Date of filing return.
8. Press Enter to export data.
The data gets exported to the e-return template.
1. Details of sales recorded with the following nature of transactions by selecting the applicable declaration forms are displayed in this annexure.
o Sales Taxable
o Sales - Works Contract
o Sales Exempt
2. Credit note recorded with the following Nature of Return (selected in Statutory Details screen of debit note) is displayed in this annexure.
o Cancelled
o Cancelled (Prior Period)
o Change in Consideration
o Change in Consideration (Prior Period)
o Change in Consideration (Previous Year)
o Change in Nature
o Change in Nature (Prior Period)
o Prior Period
Description of data captured in each column of the excel template is tabulated below:
|
Column Name |
Description |
|
TIN |
Displays the TIN entered in Company VAT Details screen. |
|
TIN (*) |
Displays the TIN of the party entered in the party ledger or in the Party Details screen of the invoice. |
|
Name of purchaser |
Displays the name of the party entered in the party ledger or in the Party Details screen of the invoice. |
|
Address of purchaser |
Displays the address of the party entered in the party ledger or in the Party Details screen of the invoice. |
|
Invoice Number |
Displays the sales invoice number. |
|
Invoice Date (dd/mm/yyyy) |
Displays the sales invoice date. |
|
Details of Commodity |
Displays the Commodity Name predefined for the stock item selected in the invoice. |
|
Value of Goods |
|
|
Tax Free |
Displays the value of sales recorded by selecting: ● Sales Exempt as the nature of transaction. ● The stock item predefined as Tax Free . The transactions details are displayed commodity-wise . |
|
Exempted |
Displays the value of sales recorded by selecting: ● Sales Exempt as the nature of transaction. ● The stock item predefined as Exempt . The transactions details are displayed commodity-wise . |
|
Taxable |
Displays the assessable value of sales recorded by selecting Sales Taxable and Sales - Works Contract as the nature of transaction. The transactions details are displayed commodity-wise . |
|
Amount of Tax |
Displays the output VAT on sales recorded by selecting Sales Taxable and Sales - Works Contract as the nature of transaction. The transactions details are displayed commodity-wise . |