Sales and purchase annexure details are exported to the same excel template to create the respective return forms. The details posted in the annexures are aggregated to file information in form 231, 233 and CST, whichever is applicable.
Before exporting data to the template,
1. Login to the department website .
2. Click Download > Return > VAT/CST > Return Template . The Return_Template.zip file gets downloaded.
3. Extract the template Return Template (Ver 3.0.000).xlsb from the zip file.
4. Copy the extracted Microsoft Excel template to the folder in which Tally.ERP 9 is installed.
5. Enter the path of the folder in which Tally.ERP 9 is installed in the Export Location field of Export Report screen, to export the data to the template.
To export data to the template
1. Copy the excel template to the Tally.ERP 9 installed folder.
2. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form 231 or Form IIIE .
3. Press Ctrl+E to view the Export Report screen.
4. Press Backspace to provide the relevant details.
5. Press Enter to export the data to template.
The description of Purchase Annexure is given below:
|
Field Name |
Description |
|
Sheet: Header |
|
|
M.V.A.T.R.C.No. |
Displays the TIN entered in Company VAT Details screen of Statutory & Taxation features, with V as suffix. |
|
CST.R.C.No. |
Displays the Inter-state Sales Tax Number entered in Company VAT Details screen of Statutory & Taxation features, with C as suffix. |
|
Name of Dealer |
Displays the name of the dealer, as recorded in the Mailing Name field in Company Creation screen. |
|
Return Type |
Displays the Type of Return selected in Export Return screen while exporting the returns to excel template. |
|
Return Forms to be Filed |
Displays the Return Forms to be filed selected in the Export Report screen while exporting the returns to excel template. |
|
Financial Year |
Displays the financial year for which returns are filed, based on the current period |
|
Return Period |
Displays the Periodicity of Return selected in the Company VAT Details of Statutory & Taxation features. |
|
Whether First Return |
Displays Yes or No based on the selection in Is First Return? field in Export Report screen, while exporting the returns. |
|
Whether Last Return |
Displays Yes or No based on the selection in Is Last Return? field in Export Report screen, while exporting the returns. |
|
Period Covered by Return |
|
|
From Date |
Displays the beginning date of the period for which returns is generated. |
|
To Date |
Displays the last date of the period for which returns is generated. |
|
The Details submitted are true and correct to the best of my knowledge and belief |
|
|
Name of Authorised Person* |
Displays the Name of authorised person recorded in Export Report screen, while exporting the returns. |
|
Designation* |
Displays the Designation recorded in Export Report screen, while exporting the returns. |
|
Mobile No* |
Displays the Mobile/Phone No. recorded in Export Report screen, while exporting the returns. |
|
E_mail_id* |
Displays the E-mail ID recorded in Export Report screen while, exporting the returns. |
|
Sheet: Purchase Annexure |
|
|
Transaction-wise Purchases Details |
|
|
Sr. No. |
Displays the serial numbers for the number of purchase transactions in the annexure. |
|
Sales Invoice No. |
Displays the Supplier Invoice No. recorded in the purchase transaction return period. Displays the original invoice number (purchase transaction) in case of purchase return. |
|
Date of Sales Invoice |
Displays the supplier invoice date recorded in the purchase transaction. Displays the original invoice date (purchase transaction) in case of purchase return. |
|
TIN of Seller (If Any) |
Displays the TIN of the party selling the item, as recorded in the VAT TIN No. field of VAT Details screen in party master, or TIN/Sales Tax No. field in Party Details screen of the sales transaction. |
|
Taxable Value OR Value of Composition u/s 42(3), (3A), (4) |
|
|
Net Rs. |
Displays the assessable value of stock items in the purchase transaction. The net assessable value of different tax rates with Nature of Transaction set as Purchase - Taxable , Purchase - Works Contract , and Purchase Tax Free is considered. |
|
TAX (If any) Rs. |
Displays the tax calculated on assessable value in these purchase transaction. |
|
Value of Inclusive of Tax Rs. |
This column is currently left blank. |
|
Value of Composition u/s 42(1), (2) Rs. |
This column is currently left blank. |
|
Tax Free Purchases Rs. |
Displays the assessable value from tax free purchases with Purchase - Tax Free selected as the Nature of transaction . |
|
Exempted Purchases u/s 41 & 8 Rs. |
Displays the assessable value from exempt purchases with Purchase - Zero Rated and Purchase - Exempt selected as the Nature of transaction . |
|
Labour Charges Rs. |
Displays the assessable value of labour charges with Labour Charges Paid selected as the Nature of transaction OR deduction value from transactions with Purchase - Works contract as Nature of transaction . |
|
Other Charges Rs. |
Displays the value of non-appropriated ledgers, created by setting Include in assessable value calculation for as Not Applicable . These ledgers have no impact on VAT/CST calculation. |
|
Gross Total (Rs.) |
Displays gross total of the purchase invoice including assessable value and tax. |
|
Action |
This field is currently left blank. |
|
Return Form Number |
Displays the form number to which the transaction belongs from the default list provided in the template. For example , 231 / 233 for local transactions based on Returns forms to be filed selected in Company VAT Details screen. |
|
Transaction Code |
Displays the transaction code based on type of purchase, from the default list provided in template. The transaction codes provided and allocated Nature of transaction are given here . Value from transactions with unregistered dealers is consolidated transaction code-wise, before being posted to the annexure. However, the annexure display provides the option to view details voucher-wise or as consolidated. |
|
Description of Transaction type |
Displays the description of transaction type based on the Transaction Code , from the default list provided in the template. |
Last updated in release 5.5.3
