Physical and e-VAT Annexure IV (Puducherry)

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.

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

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
(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

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.