On this page:
Annexure V provides the list of local purchase transactions recorded in the reporting period, including purchase returns. It is filed along with Form I on a monthly basis.
The transactions with following nature of transactions are captured in Annexure IV:
● Purchase Taxable
● Purchase - Works contract
● Purchase Exempt
● Purchase From Composition Dealer
● Purchase From Unregistered Dealer
Debit note transactions with Change in Consideration as Nature of return are also captured in this annexure.
To view Annexure V
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > VAT Form I .
2. Select Annexure Ready and press Enter .
3. Select Annexure V and press Enter to view the list of purchase transactions.
To export Annexure V 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 V and press Enter .
4. Click E : Export .
5. Press Enter to export data.
Different fields in the Annexure V excel template are explained below:
|
Field Name |
Description |
||||||||||||||||||||||||||||||||||
|
sno |
Displays the serial numbers for sales transactions listed in the annexure. |
||||||||||||||||||||||||||||||||||
|
sellertin |
Displays the TIN of the seller, as recorded in the VAT TIN No. field of VAT Details screen in ledger master of the party selected in the purchase transaction. |
||||||||||||||||||||||||||||||||||
|
invoiceno |
Displays the voucher number of the purchase transaction recorded for local purchases. |
||||||||||||||||||||||||||||||||||
|
invoicedate |
Displays the voucher date of the purchase transaction recorded for local purchases. |
||||||||||||||||||||||||||||||||||
|
purchasevalue |
Displays the assessable value of the commodity selected in the purchase transaction, including expense/income values configured for assessable value calculation. This will be consolidated value for all commodities and tax rates in the purchase transaction. |
||||||||||||||||||||||||||||||||||
|
inputtax |
Displays the amount of input tax applicable on assessable value in the purchase transaction. |
||||||||||||||||||||||||||||||||||
|
Grosstotal |
Displays the sum of purchase value and input tax for the respective purchase transaction. |
||||||||||||||||||||||||||||||||||
|
category |
Displays the category of seller 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 listed below. R - Regular, U - Unregistered
|
||||||||||||||||||||||||||||||||||
|
purchasetype |
Displays the type of transaction using the predefined list of types. LP is displayed for purchase and PR for purchase return. |
||||||||||||||||||||||||||||||||||
|
UnregName |
Displays the name of buyer, in case of purchases made from 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 V 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 V 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 with 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 seller, as recorded in the VAT TIN No. field of VAT Details screen in ledger master of the party selected in the purchase transaction |
||||||||||||||||||||||||||||||||||
|
Name of the dealer (3) |
Displays the name of the seller, as recorded in the Name field in the ledger master of the party selected in the purchase transaction. |
||||||||||||||||||||||||||||||||||
|
Invoice No (4) |
Displays the voucher number of the purchase transaction recorded for local purchases. |
||||||||||||||||||||||||||||||||||
|
Date (5) |
Displays the voucher date of the purchase transaction recorded for local purchases. |
||||||||||||||||||||||||||||||||||
|
Purchase Value (6) (Rs.) |
Displays the assessable value of the commodity selected in the purchase transaction, including expense/income values configured for assessable value calculation. This will be consolidated value for all commodities and tax rates in the purchase transaction. |
||||||||||||||||||||||||||||||||||
|
Input Tax (7) |
Displays the amount of input tax applicable on assessable value in the purchase transaction. |
||||||||||||||||||||||||||||||||||
|
Total Purchase value (Invoice value (col.6+col.7) (Rs.) (8) |
Displays the sum of purchase value and input tax for the respective purchase transaction. |
||||||||||||||||||||||||||||||||||
|
Category (9) |
Displays the category of seller depending on Type of Dealer option selected for the party. The category list is predefined in the excel template, the Type of Dealer. R - Regular, U - Unregistered
|
||||||||||||||||||||||||||||||||||
|
Purchase Type (10) |
Displays the type of transaction using the predefined list of types. LP is displayed for purchase and PR for purchase return. |
||||||||||||||||||||||||||||||||||
|
Total Local Purchases from registered dealer (A) |
Displays the total value of local purchases made from registered dealers in reporting period, which is, the sum of all transactions with category as R . |
||||||||||||||||||||||||||||||||||
|
Total Local Purchases from unregistered dealers (B) |
Displays the total value of local purchases made from unregistered dealers in reporting period, which is, the sum of all transactions with category as U . |
||||||||||||||||||||||||||||||||||
|
Total Local Purchases C = (A)+(B) |
Displays the sum of local purchases made to registered and unregistered dealers in reporting period. |
||||||||||||||||||||||||||||||||||
|
Total Local Purchases Returns to registered dealer (D) |
Displays the total value of purchase returns to registered dealers in the reporting period. |
||||||||||||||||||||||||||||||||||
|
Total Local Purchases Returns from unregistered dealers (E) |
Displays the total value of purchase returns to unregistered dealers in the reporting period. |
||||||||||||||||||||||||||||||||||
|
Total Local Purchases F = (D)+(E) |
Displays the total value of purchase returns made to both registered and unregistered dealers in the reporting period. |
||||||||||||||||||||||||||||||||||
Last updated for Release 5.5.3
