Annexure IV provides the list of local sales transactions recorded in the reporting period, including sales returns. It is filed along with Form I on a monthly basis.
The transactions with following nature of transactions are captured in Annexure IV:
● Sales Taxable
● Sales - Works contract
● Sales Exempt
Credit note transactions with Change in Consideration as Nature of return are also captured in this annexure.
To view Annexure IV
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > VAT Form I .
2. Select Annexure Ready and press Enter .
3. Select Annexure IV and press Enter to view the list of sales transactions.
To export Annexure IV data to excel
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > VAT Form I .
2. Select Annexure Ready and press Enter .
3. Select Annexure IV and press Enter .
4. Click E : Export .
5. Press Enter to export data.
Different fields in the Annexure IV excel template are explained below:
|
Field Name |
Description |
||||||||||||||||||||||||
|
sno |
Displays the serial numbers for sales transactions listed in the annexure. |
||||||||||||||||||||||||
|
buyertin |
Displays the TIN of the buyer, as recorded in the VAT TIN No. field of VAT Details screen in ledger master of the party selected in the sales transaction. |
||||||||||||||||||||||||
|
invoiceno |
Displays the voucher number of the sales transaction recorded for local sales. |
||||||||||||||||||||||||
|
invoicedate |
Displays the voucher date of the sales transaction recorded for local sales. |
||||||||||||||||||||||||
|
salesvalue |
Displays the assessable value of the commodity selected in the sales transaction, including expense/income values configured for assessable value calculation. This will be consolidated value for all commodities and tax rates in the sales transaction. |
||||||||||||||||||||||||
|
outputtax |
Displays the amount of tax applicable on assessable value in the sales transaction. |
||||||||||||||||||||||||
|
Grosstotal |
Displays the sum of sales value and output tax for the respective sales transaction. |
||||||||||||||||||||||||
|
category |
Displays the category of buyer depending on Type of Dealer option selected for the party. The category list is predefined in the excel template, the Type of Dealer and corresponding category are supported. R - Regular, U - Unregistered, C - Consumer
|
||||||||||||||||||||||||
|
saletype |
Displays the type of transaction using the predefined list of types. LS is displayed for sales and SR for sales return. |
||||||||||||||||||||||||
|
UnregName |
Displays the name of buyer, in case of sales made to unregistered dealers. |
||||||||||||||||||||||||
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > VAT Form I .
2. Select Annexure Ready and press Enter .
3. Select Annexure IV and press Enter .
4. Press Ctrl+P .
5. Enter the details and set the option Print with Returns/Additions to Yes if you want to print all the transactions of adjustments made for returns or additions.
6. Press Enter to print the annexure.
Different fields in the printed Annexure IV are explained below:
|
Field Name |
Description |
||||||||||||||||||||
|
Registration Number |
Displays the VAT TIN number of the dealer filing the returns, as recorded in the TIN field in Company VAT Details screen. |
||||||||||||||||||||
|
Tax Period |
Displays start and end dates of the period for which Form I report is generate respectively in DD/MM/YY format. |
||||||||||||||||||||
|
Sl. No. (1) |
Displays the serial numbers for sales transactions listed in the Annexure. |
||||||||||||||||||||
|
TIN (2) |
Displays the TIN of the buyer, as recorded in the VAT TIN No. field of VAT Details screen in ledger master of the party selected in the sales transaction. |
||||||||||||||||||||
|
Name of the dealer (3) |
Displays the name of the buyer, as recorded in the Name field in the ledger master of the party selected in the sales transaction. |
||||||||||||||||||||
|
Invoice No (4) |
Displays the voucher number of the sales transaction recorded for local sales. |
||||||||||||||||||||
|
Date (5) |
Displays the voucher date of the sales transaction recorded for local sales. |
||||||||||||||||||||
|
Sales Value (6)
|
Displays the assessable value of the commodity selected in the sales transaction, including expense/income values configured for assessable value calculation. This will be consolidated value for all commodities and tax rates in the sales transaction. |
||||||||||||||||||||
|
Output Tax (7) |
Displays the amount of tax applicable on assessable value in the sales transaction. |
||||||||||||||||||||
|
Total Sales value
|
Displays the sum of sales value and output tax for the respective sales transaction. |
||||||||||||||||||||
|
Category (9) |
Displays the category of buyer depending on Type of Dealer option selected for the party. The category list is predefined by the department. R - Regular, U - Unregistered, C - Consumer
|
||||||||||||||||||||
|
Sales Type (10) |
Displays the type of transaction using the predefined list of types. LS is displayed for sales and SR for sales return. |
||||||||||||||||||||
|
Total Local sales to registered dealer (A) |
Displays the total value of local sales made to registered dealers in reporting period, which is, the sum of all transactions with category as R . |
||||||||||||||||||||
|
Total Local sales to unregistered dealers/consumers (B) |
Displays the total value of local sales made to unregistered dealers and consumers in reporting period, which is, the sum of all transactions with category as U and C . |
||||||||||||||||||||
|
Total Local sales C = (A)+(B) |
Displays the sum of local sales made to registered and unregistered dealers in reporting period. |
||||||||||||||||||||
|
Total Sales Returns from registered dealer (D) |
Displays the total value of sales returns from registered dealers in the reporting period. |
||||||||||||||||||||
|
Total sales returns from unregistered dealers/consumers (E) |
Displays the total value of sales returns from unregistered dealers in the reporting period. |
||||||||||||||||||||
|
Total Sales Returns F = (D)+(E) |
Displays the total value of sales returns from both registered and unregistered dealers in the reporting period. |
Last updated for Release 5.5.3
