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 the 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 > 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 Sales 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: Sales Annexure |
|
Transaction-wise Sales Details |
|
Sr. No. |
Displays the serial numbers for the number of sales transactions in the annexure. |
Invoice No. |
Displays the voucher number of the sales transaction recorded in the return period. For sales return transactions, the voucher number of sales transaction against which return is recorded is displayed. |
Date of Sale Invoice |
Displays the voucher date of the sales transaction recorded in the return period. For sales return transaction, the voucher date of sales transaction against which return is recorded is displayed. |
TIN of Purchaser (If Any) |
Displays the TIN of the party purchasing 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 sales transaction. |
TAX (If any) Rs. |
Displays the tax calculated on assessable value in the sales transaction. |
Value of Inclusive of Tax Rs. |
Displays the assessable value and tax amount from inclusive of tax sales transaction. The values are captured from transactions containing item with the option Is inclusive of duties and taxes? enabled OR the transactions recorded by enabling the option Allow entry of rate inclusive of tax for stock item? OR from transactions that are recorded using the voucher class inclusive method. |
Value of Composition u/s 42 (1), (2) Rs. |
This column is currently left blank. |
Tax Free Sales Rs. |
Displays the assessable value from tax free sales with Sales - Tax Free selected as the Nature of transaction . |
Exempted Sales u/s 41 & 8 Rs. |
Displays the assessable value from exempt sales with Sales - Zero Rated and Sales Exempt selected as the Nature of transaction . |
Labour Charges Rs. |
Displays the assessable value of labour charges with Labour Charges Collected and Interstate Labour Charges Collected selected as the Nature of transaction OR deduction value from transactions with Sales - Works contract , Interstate Sales - Works contract , and Sales - Works contract - Ongoing as Nature of transaction . |
Other Charges (Rs) |
|
Gross Total (Rs.) |
Displays gross total of the sales invoice including assessable value and tax. |
Action |
This column 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 , CST is displayed for all interstate sales transactions and 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 sales, from the default list provided in template. The transaction codes provided and allocated Nature of transaction are given here . |
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