Physical and e-VAT Annexure IV (Puducherry)

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.

On this page

Export Annexure IV to excel

Print Annexure IV

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

Nature of Transactions	Category of Transactions (Regular Dealer)	Category of Transactions (Unregistered Dealer)	Category of Transactions (Composite Dealer)	Category of Transactions (Consumer)
Sales - Works Contract	R	U	C	R
Sales Exempt	R	U	C	R
Sales Taxable	R	U	C	R

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.

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

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)
(Rs.)

Output Tax (7)

Displays the amount of tax applicable on assessable value in the sales transaction.

Total Sales value (Invoice value) (col.6+col.7) (Rs.) (8)

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

Nature of Transactions	Category of Transactions (Regular Dealer)	Category of Transactions (Unregistered Dealer)	Category of Transactions (Composite Dealer)	Category of Transactions (Consumer)
Sales - Works Contract	R	U	C	R
Sales Exempt	R	U	C	R
Sales Taxable	R	U	C	R

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