To export data to Annexure 18 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 - 18 and press Enter.
5. Click E: Export button to display the Export Report screen. Ensure the excel template VAT18(CH).xls is available in the Export Location.
Note: Based on the Annexure 18 report period, the From and To dates are displayed here. These dates can be changed from Annexure 18 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.
● Interstate Sales - Against Form C
Select C Form as the Form to receive in Statutory Details screen.
● Interstate Sales - Taxable
Select C Form as the Form to receive and E1 Form as the Form to issue in Statutory Details screen.
Select C Form as the Form to receive and E2 Form as the Form to issue in Statutory Details screen.
● Interstate Sales Exempt - E1
Select C Form as the Form to receive and E1 Form as the Form to issue in Statutory Details screen.
Select F Form as the Form to receive in Statutory Details screen.
● Interstate Branch Transfer Outward
Select F Form as the Form to receive in Statutory Details screen.
● Consignment Transfer Outward
Select F Form as the Form to receive in Statutory Details screen.
● Interstate Consignment Transfer Outward
Select F Form as the Form to receive in Statutory Details screen.
Select H Form as the Form to receive in Statutory Details screen.
Select H Form as the Form to receive in Statutory Details screen.
● Exports
2. Credit note recorded with the following Nature of Return (selected in Statutory Details screen of credit note) is displayed in this annexure.
● Cancelled
● Cancelled (Prior Period)
● Change in Consideration
● Change in Consideration (Prior Period)
● Change in Consideration (Previous Year)
● Change in Nature
● Change in Nature (Prior Period)
● 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. |
Sr. No. |
Displays auto-generated serial number for each transaction. |
Date of Sale invoice/Challan (Dd/mm/yyyy) |
Displays the sales invoice date. |
Serial no of Sale Invoice/Challan |
Displays the sales invoice number. |
Sr. No. of Form VAT-36 |
Displays the Serial No. of Form VAT-36 entered in Statutory Details screen of sales invoice. |
Type of declaration form C/F/H furnished, if any, by the purchaser |
Displays the declaration form selected in Form to receive option in Statutory Details screen of sales invoice. |
No. of the declaration form furnished, if any, by the purchaser |
Displays the Form no. entered for the form selected in Form to receive option in Statutory Details screen of sales invoice. |
Date of the declaration form C furnished, if any, by the purchaser |
Displays the Date entered for the form selected in Form to receive option in Statutory Details screen of sales invoice. |
Description of goods |
Displays the Commodity Name predefined for the stock item selected in the invoice. |
Quantity of goods |
Displays the quantity entered for the stock item selected in the invoice. |
Value of goods |
Displays the assessable value of sales transactions. In an invoice, if the stock items predefined with: ● Different commodities are selected, then the value of each commodity appears in separate rows. ● Same commodity are selected, aggregate assessable value of all the stock items appears in same row. ● Same commodity with same unit of measure is selected, the aggregate assessable value of all the stock items appears in same row. ● Same commodity with different unit of measure is selected, the assessable value of each stock item appears in separate row. In case of zero rated transactions, zero is pre-filled as the assessable value. |
Name of the purchaser |
Displays the name of the party entered in the party ledger or in the Party Details screen of the invoice. |
Address of the purchaser |
Displays the address of the party entered in the party ledger or in the Party Details screen of the invoice. |
RC No of the purchaser under CST Act(*) |
Displays the CST number of the party entered in the party ledger or in the Party Details screen of the invoice. |
Name of the Transporter |
Displays the Name of transporter entered in the Statutory Details screen of the invoice. |
G.R. No. |
Displays the G.R. No. entered in the Statutory Details screen of the invoice. |
GR Date(dd/mm/yyyy) |
Displays the dt. entered for the G.R. No. in the Statutory Details screen of the invoice. |
'Annexure 18 (Chandigarh)' has been shared with
