The details of transactions recorded for interstate sales returns of goods (listed under Schedule 1 and 2) is displayed in Annexure-23 .
The transactions that fulfill the following prerequisites will be displayed in Annexure 23 :
● The Nature of Transaction selected is Interstate Sales - Against Form C and Interstate Sales - Taxable .
● In party ledger master,
o The State selected is other than Tamil Nadu .
o The VAT TIN is 11 digits long and it does not start with 33.
o The Type of Dealer selected is Regular .
● In the stock item master,
o Commodity Code is defined.
o First Schedule or Second Schedule is selected in the Schedule option.
● Transactions are recorded in credit note.
The xml file can be uploaded successfully only if all the aforementioned prerequisites are fulfilled. XML file can be generated either from the annexure screen or from the exported excel template.
To view Annexure 23
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX .
2. Click A : Annexures .
3. Select Annexure 23 .
4. Press Ctrl+E to export.
5. Specify the period and press Enter to export the data.
The XML file will be created in the Tally.ERP 9 application folder. In case of excel template, the data is exported to excel template and the xml is generated after validating the data. The different fields in the excel template are described below:
The excel template contains three worksheets:
● Help : This sheet provides details on different elements of the excel sheet and do’s and don’ts.
● Basic Details : This sheet will record the company and period information.
● Annexure-23 : This sheet will record the transaction details for the period.
Field Name |
Description |
Basic Details Worksheet |
|
Dealer TIN |
Displays TIN entered in Company VAT Details screen of Statutory & Taxation features. TIN number is not mandatory and is not validated while filing returns. |
Tax Period From |
Displays the starting date of return period of the report which was entered in the From (blank for beginning) field of Export Report screen. |
Tax Period To |
Displays the ending date of return period of report which was entered at the To (blank for end) field of Export Report screen. |
Annexure - 23 Worksheet |
|
Schedule |
Displays the schedule number based on the Schedule predefined in the stock item or sales ledger. Note: The items with the revised tax rate of 25% and 34% are included in the details exported to the annexure. |
Type |
Displays the Type based on the Nature of Transaction selected in the sales invoice. On selecting the Nature of Transaction , ● Interstate Sales - Against Form C , the Type appears as Against Form C . ● Interstate Sales - Taxable , the Type appears as Without Form C . |
Buyer TIN |
Displays the VAT TIN predefined for the party ledger selected in the invoice. TIN is 11 digits long and it starts with 33. |
Name of Buyer |
Displays the name of the party ledger selected in the invoice. |
Buyer Address |
Displays the address predefined in the party ledger master or entered in the Party Details screen of credit note. |
Buyer State |
Displays the state predefined in the party ledger or selected in the Party Details screen of the credit note. State name is mandatory for filing returns. |
Seller Invoice No. |
Displays the invoice or voucher number of the credit note. |
Seller Invoice Date |
Displays the invoice or voucher date of the credit note. |
Commodity Code |
Displays the Commodity Code predefined in the VAT Details screen. |
Sales Value net of CST (Rs.) |
Displays the assessable value of each commodity in the invoice. This includes all other expenses like freight, discount and so on which affect the sale value. |
CST Tax Rate (%) |
Displays the Tax Rate predefined in the VAT Details screen. |
CST Tax Paid (Rs.) |
Displays the CST amount entered for each commodity in the original sales invoice. |
Date of Return |
Displays the voucher/invoice date of credit note. |
Value of Goods Returned (Rs.) |
Displays the assessable value of each commodity in the credit note. |
Tax amount refunded (Rs.) |
Displays the tax amount entered in the credit note. |
Credit/Debit Note No. |
Displays the voucher number of the credit/debit note transaction recorded for return of goods from the interstate buyer. |
Credit/Debit Note Date |
Displays the date of the credit/debit note transaction recorded for return of goods from the interstate buyer. The date should be within 6 months of invoice date. |
Details of Total Sale Value of Schedule I and Schedule II for Against Form C |
Displays the invoice value of credit note recorded using Interstate Sales Against Form C as the Nature of Transaction with rate-wise breakup. |
Details of Total Sale Value of Schedule I and for Without Form C |
Displays the invoice value of credit note recorded by selecting stock items predefined as First Schedule goods using Interstate Sales Taxable as the Nature of Transaction with rate-wise breakup. |
Details of Total Sale Value of Schedule II for Without Form C |
Displays the invoice value of credit note recorded by selecting stock items predefined as Second Schedule goods using Interstate Sales Taxable as the Nature of Transaction . |
last updated for Release 5.5.7