The details of local sales returns in the return period are captured in Annexure B1.
Annexure B1 displays transaction where,
● The nature of transaction selected in Sales Taxable.
● The VAT TIN number of the party is 11 digits long and starts with 09.
To view Annexure B1
● Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT 24 > Annexure Ready.
● Press Enter
To export the Annexure
1. Select Annexure B1, and press Enter.
2. Click E: Export button. Ensure that excel template is available in the Export Location.
3. Press Enter to export.
The various fields in the excel template are described below:
Field Name |
Description |
DealerTin |
Displays the VAT Tin number of the dealer filing the returns, as recorded in the TIN field in Company VAT Details screen. |
FinancialYear |
Displays the financial year of the company for which the tax returns are being filed, in YYYY-YYYY format. |
TaxPeriod |
Displays the tax return period based on the option selected in Periodicity of e-Return field in Company VAT Details screen. The options provided are 1 for yearly, 2 for monthly and 3 for quarterly e-returns. |
Month |
Displays the month for which returns are filed, if monthly is selected as the e-return periodicity. Numbers are displayed from 1 to 12 for each month of the year. In case returns are not filed monthly, 0 is displayed. |
Quarter |
Displays the quarter for which returns are field, if quarterly is selected as the e-return periodicity. The option 1st Quarter is displayed for the period April-June and so on. In case returns are not filed quarterly, 0 is displayed. |
InvoiceNo |
Displays the invoice number of the original sales transaction against which the return are recorded, as the number displayed in No. field in the sales invoice/voucher with Nature of transaction as Sales Taxable. |
InvoiceDate |
Displays the date of the original sales transaction against which the return are recorded, as the date entered in the sales invoice/voucher with Nature of transaction as Sales Taxable in the return period. |
CommodityCode |
Displays the Commodity Code assigned to the item selected in the sales return transaction. When there are multiple commodities in a transaction, each one is captured in different row. |
CommodityQty |
Displays the quantity or weight of commodity selected in the specified transaction. In case of accounting transaction (without item details) Quantity is set as 0. |
TaxableGoods |
Displays the assessable value of respective commodity in the credit note transaction recorded for sales return. |
VAT Charged |
Displays the tax amount applicable for respective commodity in the credit note transaction recorded for sales return. |
SAT Charged |
Displays the additional tax amount applicable for respective commodity in the credit note transaction recorded for sales return. |
Total Invoice Value |
Displays the total value for the respective commodity in the credit note transaction recorded for sales return. |
VenodorCustomerTIN |
Displays the TIN of the customer returning the goods, as recorded in the VAT TIN No. field in VAT Details screen of party ledger master. |
Unit |
Displays the unit of measurement used for the respective commodity in the credit note transaction recorded for sales return. |
Credit Note No |
Displays the voucher number of the credit note transaction recorded for sales return. |
Credit Note Date |
Displays the voucher date of the credit note transaction recorded for sales return. |
Debit Note No |
Displays the voucher number of the debit note issued by the customer requesting a credit note for sales return. |
Debit Note Date |
Displays the voucher date of the debit note issued by the customer requesting a credit note for sales return. |
Vat/NON VAT-(V/NV) |
Displays the option V for sales return of taxable goods, and the option NV for non-taxable goods. |