Physical and e-VAT Annexure V (Puducherry)

On this page:

Export Annexure V to excel

Print Annexure V

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

Nature of Transactions

Category of Transactions (Regular Dealer)

Category of Transactions (Unregistered Dealer)

Category of Transactions (Composite Dealer)

Category of Transactions (Consumer)

Purchase - Works Contract

R

R

R

R

Purchase Exempt

R

R

R

R

Purchase from Composition Dealer

R

R

R

R

Purchase from Unregistered Dealer

U

U

U

U

Purchase Taxable

R

R

R

R

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.

To print 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 .

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

Nature of Transactions

Category of Transactions (Regular Dealer)

Category of Transactions (Unregistered Dealer)

Category of Transactions (Composite Dealer)

Category of Transactions (Consumer)

Purchase - Works Contract

R

R

R

R

Purchase Exempt

R

R

R

R

Purchase from Composition Dealer

R

R

R

R

Purchase from Unregistered Dealer

U

U

U

U

Purchase Taxable

R

R

R

R

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