You can export data for any period to Annexure 23 through VAT Form 15 in Tally.ERP 9.
To export data to Annexure 24 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 - 24 and press Enter.
5. Click E: Export button to display the Export Report screen. Ensure the excel template VAT24(CH).xls is available in the Export Location.
Note: Based on the Annexure 24 report period, the From and To dates are displayed here. These dates can be changed from Annexure 24 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 purchases recorded with the following nature of transactions by selecting the applicable declaration forms are displayed in this annexure.
o Purchase Taxable
o Purchase From Unregistered Dealer
o Purchase Exempt
o Imports
o Interstate Purchases - Against Form C
Select C Form as the Form to issue in Statutory Details screen.
o Interstate Purchase - Taxable
Select C Form as the Form to issue and E1 Form as the Form to receive in Statutory Details screen.
Select C Form as the Form to issue and E2 Form as the Form to receive in Statutory Details screen.
o Interstate Purchase Exempt - With Form C
2. Debit 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 seller |
Displays the name of the party entered in the party ledger or in the Party Details screen of the invoice. |
|
Address of seller |
Displays the address of the party entered in the party ledger or in the Party Details screen of the invoice. |
|
Invoice Number |
Displays the Supplier Invoice No. entered in the invoice. |
|
Invoice Date (dd/mm/yyyy) |
Displays the Date entered for the Supplier Invoice No. in the invoice. |
|
Details of Commodity |
Displays the Commodity Name predefined for the stock item selected in the invoice. |
|
Purchase Value |
|
|
Tax Free |
Displays the value of purchases recorded by selecting: ● Purchase Exempt as the nature of transaction. ● The stock item predefined as Tax Free. Tax Rate is set to 0, and Tax Type is set to Tax Free in the VAT Details screen of stock item master. The transactions details are displayed commodity-wise. In an invoice, if the stock items predefined with: ● Different commodities are selected, then 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. |
|
Exempted |
Displays the value of purchases recorded by selecting: ● Purchase Exempt as the nature of transaction. ● The stock item predefined as Exempt. Tax Rate is set to 0, and Tax Type is set to Exempt in the VAT Details screen of stock item master. The transactions details are displayed commodity-wise. In an invoice, if the stock items predefined with: ● Different commodities are selected, then 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. |
|
Taxable |
Displays the assessable value of purchases recorded by selecting Purchase Taxable and Purchase From Unregistered Dealer as the nature of transaction. The transactions details are displayed commodity-wise. In an invoice, if the stock items predefined with: ● Different commodities are selected, then 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. |
|
Amount of Tax |
Displays the input VAT on purchases recorded by selecting Purchase Taxable, Purchase - Works Contract as the nature of transaction. The transactions details are displayed commodity-wise. In an invoice, if the stock items predefined with: ● Different commodities are selected, then the amount of VAT calculated on each commodity appears in separate rows. ● Same commodity are selected, aggregate amount of VAT calculated on all the stock items appears in same row. ● Same commodity with same unit of measure is selected, the aggregate amount of VAT calculated on all the stock items appears in same row. ● Same commodity with different unit of measure is selected, the VAT amount calculated on each stock item appears in separate row. |
|
Imports Value |
|
|
Imports Tax Free |
Displays the value of purchases recorded by selecting: ● Imports as the nature of transaction. ● The stock item predefined as Tax Free. Tax Rate is set to 0, and Tax Type is set to Tax Free in the VAT Details screen of stock item master. The transactions details are displayed commodity-wise. In an invoice, if the stock items predefined with: ● Different commodities are selected, then 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. |
|
Imports Taxable |
Currently this column is left blank. |
|
Purchase from other states |
|
|
Purchase from Other States Tax Free |
Displays the value of purchases recorded by selecting: ● Interstate Purchase Exempt as the nature of transaction. ● The stock item predefined as Tax Free. Tax Rate is set to 0, and Tax Type is set to Tax Free in the VAT Details screen of stock item master. The transactions details are displayed commodity-wise. In an invoice, if the stock items predefined with: ● Different commodities are selected, then 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. |
|
Purchase from Other States Taxable |
Displays the value of purchases recorded by selecting Interstate Purchase - Against Form C, Interstate Purchase - E1, Interstate Purchase - E2 or Interstate Purchase - Taxable as the nature of transaction. The transactions details are displayed commodity-wise. In an invoice, if the stock items predefined with: ● Different commodities are selected, then 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. |
'Annexure 24 (Chandigarh)' has been shared with
