Exporting VAT Form 13 (Assam)

This topic explains how to export the government prescribed VAT form and the fields in VAT Form 13.

To export data to VAT Form 13 template

1. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form 13 .

2. Press Ctr+E to export the government prescribed VAT form.

3. Select the Type of Return .

4. Enter the Name , Status/Designation , Place , and Date .

5. Enter the Date of Original Return if filing a revised return.

6. Press Enter to export the data to template. The data gets exported to relevant fields of Form 13 and annexure G, GG, H, I, J, K, L, M and N.

Note: The Form 13 template (Excel file) downloaded from the department Web site should be renamed to Form13Monthly.xls and stored in the location to which the file would be exported from Tally.ERP 9.

Form Description - Form VAT 13 (Assam)

A brief explanation about the form fields is given below:

Field Name

Description

TIN

Displays the TIN which was already entered in the template downloaded by dealer from the portal .

Tax Period

Displays the period which was already entered in the template downloaded by dealer from the portal .

Name and style of the business

Displays the name and the nature of business which were already entered in the template downloaded by dealer from the portal.

Address

Displays the company address which was already entered in the template downloaded by dealer from the portal.

Name of the goods dealt in

Displays the name of the goods the company mostly dealt in. This  was already entered in the template downloaded by dealer from the portal.

PART A                              PURCHASES IN THE MONTH (INPUT) Value excluding Tax Tax Claimed

6. (a) Non-Creditable Exempt Purchase/Receipt

Displays the net assessable value (purchase - purchase returns) of transactions recorded in purchase invoice and debit note in Value Excluding VAT column.

Stock items must be predefined with the following settings:

The Schedule selected is other than fourth schedule in the item master.

The following Nature of Transaction are considered:

Purchase Exempt

Branch Transfer Inward

Consignment Transfer Inward

Non Creditable Purchase - Special Goods

Labour Charges Paid

(6) (b) Non-creditable Interstate Purchase/Receipt

Displays the net assessable value of interstate purchases. These purchases are not liable to tax and the input tax credit can not be availed on these purchases.

The value is the net value of returns and adjustments made using debit notes and credit notes.

The following Nature of Transaction are used:

Interstate Branch Transfer Inward

Interstate Consignment Transfer Inward

Interstate Purchase - Against Form C

Interstate Purchase Deemed Export

Interstate Purchase - E1

Interstate Purchase - E2

Interstate Purchase Exempt

Interstate Purchase Exempt - E1

Interstate Purchase - Taxable

Interstate Purchase - Tax Free

Interstate Purchase - Zero Rated

Import

Purchase High Seas

Interstate Purchase Exempt - With Form C

(6) (c) Non-creditable Schedule IV Purchase/Receipt

Displays the values of transactions recorded by selecting stock items predefined with Schedule as Fourth Schedule for the nature of transaction Purchase Exempt , and Non Creditable Purchase - Special Goods .

6(d) Schedule IV Purchase/Receipt creditable under section 10(1A)

This field is left blank. (As per the recent rule of Section 10 (1A).)

7(a) 1% Rate Purchase

Displays the gross value (purchase assessable and taxable value) of purchase  transactions recorded by selecting goods classified under all schedules except Schedule IV. The assessable value is displayed in Value Excluding VAT (A) column and the input VAT is displayed in Tax Claimed (B) column. The value of tax is considered as input tax credit and it is displayed in PART E .

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 1% at the item or stock group level.

The following Nature of Transaction are considered:

o Purchase Taxable (Tax rate set as 1%)

o Purchase Works Contract (Tax rate set as 1%)

o Purchase Taxable - Capital Goods (Tax rate set as 1%)

(7) (b) 14.5% Rate Purchase

Displays the gross value (purchase assessable and taxable value) of purchase  transactions recorded by selecting goods classified under all schedules except Schedule IV. The assessable value is displayed in Value Excluding VAT (A) column and the input VAT is displayed in Tax Claimed (B) column. The value of tax is considered as input tax credit and it is displayed in PART E .

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 14.5% at the item or stock group level.

The following Nature of Transaction are considered:

o Purchase Taxable (Tax rate set as 14.5%)

o Purchase Works Contract (Tax rate set as 14.5%)

o Purchase Taxable - Capital Goods (Tax rate set as 14.5%)

(7) (c) 15% Rate Purchase

Displays the gross value (purchase assessable and taxable value) of purchase  transactions recorded by selecting goods classified under all schedules except Schedule IV. The assessable value is displayed in Value Excluding VAT (A) column and the input VAT is displayed in Tax Claimed (B) column. The value of tax is considered as input tax credit and it is displayed in PART E .

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 15% at the item or stock group level.

The following Nature of Transaction are considered:

o Purchase Taxable (Tax rate set as 15%)

o Purchase Works Contract (Tax rate set as 15%)

o Purchase Taxable - Capital Goods (Tax rate set as 15%)

(8) 4% Rate Purchases

Displays the gross value (purchase assessable and taxable value) of purchase transactions  recorded by selecting stock items attracting 4% tax rate.

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 4% at the item or stock group level.

The following Nature of Transaction are considered:

o Purchase Taxable (Tax rate set as 4%)

o Purchase Works Contract (Tax rate set as 4%)

o Purchase Taxable - Capital Goods (Tax rate set as 4%)

(9) 5% Rate Purchase

Displays the gross value (purchase assessable and taxable value) of purchase transactions  recorded by selecting stock items attracting 5% tax rate.

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 5% at the item or stock group level.

The following Nature of Transaction are considered:

o Purchase Taxable (Tax rate set as 5%)

o Purchase Works Contract (Tax rate set as 5%)

o Purchase Taxable - Capital Goods (Tax rate set as 5%)

(10) (a) 13.5% Rate Purchases

Displays the gross value (purchase assessable and taxable value) of purchase transactions  recorded by selecting stock items attracting 13.5% tax rate.

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 13.5% at the item or stock group level.

The following Nature of Transaction are considered:

o Purchase Taxable (Tax rate set as 13.5%)

o Purchase Works Contract (Tax rate set as 13.5%)

o Purchase Taxable - Capital Goods (Tax rate set as 13.5%)

(10) (b) 20% Rate Purchases

Displays the gross value (purchase assessable and taxable value) of purchase transactions  recorded by selecting stock items attracting 20% tax rate.

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 20% at the item or stock group level.

The following Nature of Transaction are considered:

o Purchase Taxable (Tax rate set as 20%)

o Purchase Works Contract (Tax rate set as 20%)

o Purchase Taxable - Capital Goods (Tax rate set as 20%)

(10) (c) 30% Rate Purchases

Displays the gross value (purchase assessable and taxable value) of purchase transactions  recorded by selecting stock items attracting 30% tax rate.

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 30% at the item or stock group level.

The following Nature of Transactions are considered:

o Purchase Taxable (Tax rate set as 30%)

o Purchase Works Contract (Tax rate set as 30%)

o Purchase Taxable - Capital Goods (Tax rate set as 30%)

(10) (d) 2% Rate Purchases

Displays the gross value (purchase assessable and taxable value) of purchase transactions  recorded by selecting stock items attracting 2% tax rate.

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 2% at the item or stock group level.

The following Nature of Transaction are considered:

o Purchase Taxable (Tax rate set as 2%)

o Purchase Works Contract (Tax rate set as 2%)

o Purchase Taxable - Capital Goods (Tax rate set as 2%)

(10) (e) 6% Rate Purchases

Displays the gross value (purchase assessable and taxable value) of purchase transactions  recorded by selecting stock items attracting 6% tax rate.

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 6% at the item or stock group level.

The following Nature of Transaction are considered:

o Purchase Taxable (Tax rate set as 6%)

o Purchase Works Contract (Tax rate set as 6%)

o Purchase Taxable - Capital Goods (Tax rate set as 6%)

(10) (f) 0.75% Rate Purchases

Displays the gross value (purchase assessable and taxable value) of purchase transactions  recorded by selecting stock items attracting 0.75% tax rate.

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 0.75% at the item or stock group level.

The following Nature of Transaction are considered:

o Purchase Taxable (Tax rate set as 0.75%)

o Purchase Works Contract (Tax rate set as 0.75%)

o Purchase Taxable - Capital Goods (Tax rate set as 0.75%)

(10) (g) 7.5% Rate Purchases

Displays the gross value (purchase assessable and taxable value) of purchase transactions  recorded by selecting stock items attracting 7.5% tax rate.

Stock items must be predefined with the following settings:

o The Schedule is selected as any schedule except Schedule IV in the item master.

o Tax rate is defined as 7.5% at the item or stock group level.

The following Nature of Transaction are considered:

o Purchase Taxable (Tax rate set as 7.5%)

o Purchase Works Contract (Tax rate set as 7.5%)

o Purchase Taxable - Capital Goods (Tax rate set as 7.5%)

(11) Total Amount of input tax

Displays the auto calculated value of total input tax on taxable purchases.

PART C                             SALES IN THE MONTH (OUTPUT)

(12) Exempt Sales

Displays the net assessable value transactions recorded by selecting stock items under Schedule I in sales invoice and credit note. The amount is displayed in Value Excluding Tax (A) column.

Stock items must be predefined with the following settings:

o The Schedule selected is other than Fourth Schedule in the item master.

The Nature of Transaction is selected as Sales Exempt .

(13) Zero Rate Sales - International Exports

Displays the net assessable values of sales recorded with Exports as the nature of transactions. The amount is displayed in Value Excluding Tax (A) column.

(14) Zero Rate Sales - Other (CST Sales)

Displays the net assessable values of transactions recorded in sales invoice and credit note by selecting Interstate Sales Zero Rated as the Nature of Transaction . The amount is displayed in Value Excluding Tax (A) column.

T he following Nature of Transaction and Forms to Receive are considered:

Interstate Branch Transfer Outward

Interstate Consignment Transfer Outward

Interstate Labour Charges Collected

Interstate Sales - Against Form C

Interstate Sales Exempt - With Form C

Interstate Sales - E1

Interstate Sales - E2

Interstate Sales Exempt

Interstate Sales Exempt - E1

Interstate Sales - Taxable

Interstate Sales - Tax Free

Interstate Sales - Works Contract

Interstate Deemed Export

Interstate Sales - Zero Rated

o Not Applicable

o Exempted/Concession by Notification

o Diplomatic Missions, U.N, UNICEF, WHO & Foreign Aid)

o SEZ / STP / EHTP

(15) Other Exempt Sales

This field is left blank. (As per the current validation method in Assam Commercial Tax Dept.).

(16) Tax Due on Purchase of goods

Displays the value of journal voucher recorded by selecting the nature of adjustment as Tax on URD Purchase .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (a) 1% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 1% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (b) 2% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 2% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (c) 4% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 4% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (d) 5% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 5% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (e) 9% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 9% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (f) 12% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 12% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (g) 12.5% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 12.5% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (g) 13.5% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 13.5% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (h) 16.5% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 16.5% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (i) 22% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 22% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (j) 14.5% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 14.5% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(16) (k) 27.5% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 27.5% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(17) 1% Rate Sales

Displays the gross value of sales transaction recorded by selling stock items attracting 1% tax rate.

The gross assessable value and VAT are displayed in VAT Excluding Tax (A) and Tax Due (B) columns respectively.

The following Nature of Transaction are considered:

o Sales Taxable (Tax rate set as 1%)

o Sales - Works Contract (Tax rate set as 1%)

o Sales Taxable - On Going (Tax rate set as 1%)

(18) 2% Rate Sales

Displays the gross value of sales transaction recorded by selling stock items attracting 2% tax rate.

The gross assessable value and VAT are displayed in VAT Excluding Tax (A) and Tax Due (B) columns respectively.

The following Nature of Transaction are considered:

o Sales Taxable (Tax rate set as 2%)

o Sales - Works Contract (Tax rate set as 2%)

o Sales Taxable - On Going (Tax rate set as 2%)

(19) 0.75% Rate Sales

Displays the gross value of sales transaction recorded by selling stock items attracting 0.75% tax rate.

The gross assessable value and VAT are displayed in VAT Excluding Tax (A) and Tax Due (B) columns respectively.

The following Nature of Transaction are considered:

o Sales Taxable (Tax rate set as 0.75%)

o Sales - Works Contract (Tax rate set as 0.75%)

o Sales Taxable - On Going (Tax rate set as 0.75%)

(20) 14.5% Rate Sales

Displays the gross value of sales transaction recorded by selling stock items attracting 14.5% tax rate.

The gross assessable value and VAT are displayed in VAT Excluding Tax (A) and Tax Due (B) columns respectively.

The following Nature of Transaction are considered:

o Sales Taxable (Tax rate set as 14.5%)

o Sales - Works Contract (Tax rate set as 14.5%)

o Sales Taxable - On Going (Tax rate set as 14.5%)

(21) 15% Rate Sales

Displays the gross value of sales transaction recorded by selling stock items attracting 15% tax rate.

The gross assessable value and VAT are displayed in VAT Excluding Tax (A) and Tax Due (B) columns respectively.

The following Nature of Transactions are considered:

o Sales Taxable (Tax rate set as 15%)

o Sales - Works Contract (Tax rate set as 15%)

o Sales Taxable - On Going (Tax rate set as 15%)

(22) 5% Rate Sales

Displays the gross value of sales transaction recorded by selling stock items attracting 5% tax rate.

The gross assessable value and VAT are displayed in VAT Excluding Tax (A) and Tax Due (B) columns respectively.

The following Nature of Transaction are considered:

o Sales Taxable (Tax rate set as 5%)

o Sales - Works Contract (Tax rate set as 5%)

o Sales Taxable - On Going (Tax rate set as 5%)

(23) 0.5% Rate Sales

Displays the gross value of sales transaction recorded by selling stock items attracting 0.5% tax rate.

The gross assessable value and VAT are displayed in VAT Excluding Tax (A) and Tax Due (B) columns respectively.

The following Nature of Transaction are considered:

o Sales Taxable (Tax rate set as 0.5%)

o Sales - Works Contract (Tax rate set as 0.5%)

o Sales Taxable - On Going (Tax rate set as 0.5%)

(23) (a) 6% Rate Purchase

Displays the details of journal voucher recorded for purchase tax liability at 6% tax rate .

The VAT amount credited in the voucher appears in Tax Due (B) column.

The assessable value entered in the sub screen displayed on selecting the VAT ledger is displayed in Value Excluding Tax (A) column.

(23) (b) 6% Rate Sales

Displays the gross value of sales transaction recorded by selling stock items attracting 6% tax rate.

The gross assessable value and VAT are displayed in VAT Excluding Tax (A) and Tax Due (B) columns respectively.

The following Nature of Transaction are considered:

o Sales Taxable (Tax rate set as 6%)

o Sales - Works Contract (Tax rate set as 6%)

o Sales Taxable - On Going (Tax rate set as 6%)

(23) (c) 7.5% Rate Sales

Displays the gross value of sales transaction recorded by selling stock items attracting 1% tax rate.

The gross assessable value and VAT are displayed in VAT Excluding Tax (A) and Tax Due (B) columns respectively.

The following Nature of Transaction are considered:

o Sales Taxable (Tax rate set as 7.5%)

o Sales - Works Contract (Tax rate set as 7.5%)

o Sales Taxable - On Going (Tax rate set as 7.5%)

(24) Output Tax

Displays auto calculated value

PART D                            SALES IN THE MONTH

22 (a) (i) .5% Rate Sales (Fourth Schedule)

Displays the gross value of sales transactions recorded by selecting stock items attracting .5% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (a) (ii) 1% Rate Sales (Fourth Schedule)

Displays the gross value of sales transactions recorded by selecting stock items attracting 1% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (b) 2% Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 2% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (c ) (i) 4% Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 4% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (c ) (ii) 5% Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 5% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22(d) 9% Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 9% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (e) 12% Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 12% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (f) 12.5% Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 12.5% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (g) (1) (16.5%) Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 16.5% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (g) (2) 20% Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 20% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22(h) (2) 22% Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 22% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (i) (1) 27.5% Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 27.5% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (i) (2) 25% Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 25% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (j) (1) 30% Rate Sales (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 30% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (j) (2) 6% Sale (Fourth Schedule)

Displays the gross value of transactions recorded by selecting stock items attracting 6% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively.

22 (j) (3) Tax due [(1) –(2)]

This field is left blank.

22 (k) Pre-owned cars (Rs.3,000/- per car)

Displays the taxable amount of sales transactions recorded for cars upto 1000cc when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Type of Goods set as Pre-Owned cars (Upto 1000 cc) .

o Calculation Type for VAT rate set as On Quantity

o Tax Rate per unit is specified as 3000.

22 (l) Pre-Owned Cars (Rs.10, 000/- per car)

Displays the taxable amount of sales transactions recorded for cars above 1000cc when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Type of Goods set as Pre-Owned cars (Above 1000 cc) .

o Calculation Type for VAT rate set as On Quantity

o Tax Rate per unit is specified as 10000.

22 (l) (1) Pre-Owned Cars (Rs.6000/- per car)

Displays the taxable amount of sales transactions recorded for cars upto 1000cc, calculated based on the new rate of Rs. 6,000 when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Type of Goods set as Pre-Owned cars (Upto 1000 cc) .

o Calculation Type for VAT rate set as On Quantity

o Tax Rate per unit is specified as 6000.

22 (m) Tax paid Sales

This field is currently left blank.

22 (n) 14.5% Rate Sales (Fourth Schedule)

Displays the values of sales  transactions recorded by selecting stock items attracting 14.5% tax rate for the following nature of transactions:

Sales Taxable

Sales - Works Contract

Sales Taxable - On Going

The gross assessable value and VAT are displayed in Value Excluding TAX (A) and Tax Due (B) columns respectively

Stock items must be predefined with the following settings:

The Schedule is selected as Fourth Schedule in the item master.

Tax rate is defined as 14.5% at the item or stock group level.

Sales Taxable has to be selected as the Nature of Transaction .

22 (o) 29% Rate Sales or Rs 14 per litre

Displays the taxable amount of sales transactions recorded for petrol. In case of transactions recorded based on value, the assessable value and tax amount will be displayed. For transactions recorded based on quantity, only the tax amount will be displayed when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Calculation Type for VAT rate set as On Quantity , if the petrol rate is Rs.14 per litre. Tax Rate is specified as 14.

o Calculation Type for VAT rate set as On Value if the rate is 29%. Tax Rate is specified as 29.

o Type of goods specified as Petrol and Other Motor Spirits .

22 (p) 20% rate sales or 8.75 per litre whichever is higher

Displays the taxable amount of sales transactions recorded for diesel. In case of transactions recorded based on value, the assessable value and tax amount will be displayed. For transactions recorded based on quantity, only the tax amount will be displayed when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Calculation Type for VAT rate set as On Quantity , if the diesel rate is Rs.8.75 per litre. Tax Rate is specified as 8.75.

o Calculation Type for VAT rate set as On Value if the rate is 20%. Tax Rate is specified as 20.

o Type of goods specified as Diesel .

22 (q)(1) Filter cigarettes exceeding 75mm Rs. 1600 per thousand sticks.

Displays the taxable amount for transactions recorded in sales invoice for filter cigarettes more than 75mm length when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Calculation Type for VAT rate set as On Quantity .

o Tax Rate is specified per stick as 1.60 (as per the rate Rs. 1,600 per thousand sticks)

o Type of goods specified as Filter Cigarettes .

22 (q)(1a) Filter cigarettes exceeding 75mm Rs. 1850 per thousand sticks.

Displays the taxable amount for transactions recorded in sales invoice for filter cigarettes more than 75mm in length when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Calculation Type for VAT rate set as On Quantity .

o Tax Rate is specified per stick as 1.85 (as per the rate Rs. 1,850 per thousand sticks)

o Type of goods specified as Filter Cigarettes .

22(q)(2)Filter cigarettes exceeding 70mm but not exceeding 75mm Rs.1225 per thousand sticks

Displays the taxable amount for transactions recorded in sales invoice for filter cigarettes more than 70mm but not exceeding 75 mm in length when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Calculation Type for VAT rate set as On Quantity .

o Tax Rate is specified per stick as 1.225 (as per the rate Rs. 1,225 per thousand sticks)

o Type of goods specified as Filter Cigarettes .

22(q)(2a)Filter cigarettes exceeding 70mm but not exceeding 75mm Rs.1450 per thousand sticks

Displays the taxable amount for transactions recorded in sales invoice for filter cigarettes more than 70mm but not exceeding 75 mm in length when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Calculation Type for VAT rate set as On Quantity .

o Tax Rate is specified per stick as 1.45 (as per the rate Rs. 1,450 per thousand sticks).

o Type of goods specified as Filter Cigarettes .

22(q)(3)Filter cigarettes exceeding 65mm but not exceeding 70mm Rs.810 per thousand sticks

Displays the taxable amount for transactions recorded in sales invoice for filter cigarettes more than 65mm but not exceeding 70 mm in length when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Calculation Type for VAT rate set as On Quantity .

o Tax Rate is specified per stick as 0.81 (as per the rate Rs. 810 per thousand sticks).

o Type of goods specified as Filter Cigarettes .

22(q)(3a)Filter cigarettes exceeding 65mm but not exceeding 70mm Rs.975 per thousand sticks

Displays the taxable amount for transactions recorded in sales invoice for filter cigarettes more than 65mm but not exceeding 70 mm in length when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Calculation Type for VAT rate set as On Quantity .

o Tax Rate is specified per stick as 0.975 (as per the rate Rs. 975 per thousand sticks).

o Type of goods specified as Filter Cigarettes .

22(q) (4) Filter cigarettes exceeding 60 mm but not exceeding 65 mm Rs.550 per thousand sticks.

Displays the taxable amount for transactions recorded in sales invoice for filter cigarettes more than 60mm but not exceeding 65 mm in length when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Calculation Type for VAT rate set as On Quantity .

o Tax Rate is specified per stick as 0.55 (as per the rate Rs. 550 per thousand sticks).

o Type of goods specified as Filter Cigarettes .

22(q) (4a) Filter cigarettes exceeding 60 mm but not exceeding 65 mm Rs.775 per thousand sticks.

Displays the taxable amount for transactions recorded in sales invoice for filter cigarettes more than 60mm but not exceeding 65 mm in length when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Calculation Type for VAT rate set as On Quantity .

o Tax Rate is specified per stick as 0.775 (as per the rate Rs. 775 per thousand sticks).

o Type of goods specified as Filter Cigarettes .

22(q) (5) Other than filter cigarettes not exceeding 65 mm Rs.750 per thousand sticks.

Displays the taxable amount for transactions recorded in sales invoice for filter cigarettes not exceeding 65 mm in length when:

The following nature of transactions are selected:

o Sales Taxable

o Sales - Works Contract

o Sales Taxable - On Going

The stock item master has:

o Calculation Type for VAT rate set as On Quantity .

o Tax Rate is specified per stick as 0.75 (as per the rate Rs. 750 per thousand sticks)

o Type of goods specified as Cigarettes Other Than Filter .

22(q)(6) Cigarettes not falling in any place of the above Rs.1600 per thousand sticks

Displays the taxable amount for transactions recorded in sales invoice for filter cigarettes that do not belong to any of the lengths mentioned in Fourth Schedule .

The stock item master has:

o Calculation Type for VAT rate set as On Quantity .

o Tax Rate is specified per stick as 1.60 (as per the rate Rs.1,600 per thousand sticks)

o Type of goods specified as Cigarettes - Other Lengths

Note: If you are migrating data from Release 5.4.2 or 5.4.3 or 5.4.4 to the latest release, then the Type of goods should be changed from Cigarettes Other Than Filter to Cigarettes - Other Lengths for the stock items which do not belong to any of the lengths mentioned in Fourth Schedule . This correction is required to capture the value in this box as per the latest template provided by the department.

22(q)(6a) Cigarettes not falling in any place of the above Rs.1850 per thousand sticks

Displays the taxable amount for transactions recorded in sales invoice for filter cigarettes that do not belong to any of the lengths mentioned above.

The stock item master has:

o Calculation Type for VAT rate set as On Quantity .

o Tax Rate is specified per stick as 1.85 (as per the rate Rs.1,850 per thousand sticks)

o Type of goods specified as Cigarettes - Other Lengths

(23) Output Tax

Displays auto calculated value. This is the aggregate value of output VAT due on all Schedule IV sales on which output VAT is charged.

PART E                            TAX CALCULATIONS

(24) Output tax [Part C (21)+ Part D (23)]

Displays auto calculated value.

(25) (1) Add : adjustment to output tax, if any (specify)

Displays the adjustment towards increase in output tax adjusted using debit note and journal voucher.

For debit note, Change in Consideration or Change in Nature is selected as Nature of Return

For a journal voucher,

o VAT is selected as Type of duty/tax .

o Increase of Output Tax is selected as Nature of Adjustment .

(25) (1) Less : adjustment to output tax, if any (specify)

Displays the adjustments towards increase in output tax adjusted using credit note and journal voucher.

For credit note, the following Nature of Return can be selected as:

o Not Applicable (Goods sold return)

o Cancelled

o Change in Nature

o Change in Consideration

o Others

For a journal voucher,

o VAT is selected as Type of Duty/Tax .

o Decrease of Output Tax is selected as Nature of Adjustment and Additional Details is NOT set to TDS Adjustments.

(26) Total Output tax [(24)+/-(25)]

Displays auto calculated value.

(27) Input tax credit on purchases

Displays auto calculated value.

(28) (a) (1) Add : adjustment to input tax, if any (specify)

Displays all the adjustments towards increase in input tax made in credit note and journal voucher.

For  credit note, Change in Consideration or Change in Nature is selected as the Nature of Return .

For a journal voucher,

o VAT is selected as Type of Duty/Tax .

o Increase of Input Tax and Adjustment of Capital Goods are considered as Nature of Adjustment .

(28) (a) (1) Less : adjustment to input tax, if any (specify)

Displays all the adjustments towards decrease in input tax made in debit note and journal voucher.

For debit note, the following Nature of Return can be selected:

o Change in Nature

o Change in Consideration

For a journal voucher,

o VAT is selected as Type of Duty/Tax .

o Tax on URD Purchase is selected as the Nature of Adjustment . The value is not captured when the VAT ledger is debited with the nature of adjustment is selected as Tax on URD Purchase .

o Input Tax Credit Admitted On Capital Goods is selected as the Nature of Adjustment .

o Increasing Input Tax is selected as the Nature of Adjustment .

(28) (b) Add: ITC balance brought forward from previous period

Displays the value of excess input credit brought forward in VAT Computation report for a particular return period.

(29) Net Input tax credit [(27)+/-(28)]

Displays auto-calculated value.

(30) (a) Tax payable [(26) – (29)]

Displays auto-calculated value.

(30) (a) ITC balance carried forward to next period [ (29)-(26)]

Displays auto-calculated value.

(31) (a) Interest payable

Displays debit value of expenses entered in journal voucher to account for interest dues .

(31) (b) Penalty payable

Displays debit value of expenses entered in journal voucher to account for penalty .

(32) Aggregate amount payable

Displays auto-calculated value.

TAX INFORMATION

(32) Tax Paid

Displays the VAT payment voucher total.

(33) Sales Tax Deducted

Displays value of journal voucher recorded for TDS adjustment .

(34) Adjustment against CST liability

Displays the value debited against CST liability.

In the journal voucher entry,

Select VAT as the Type of Duty/ Tax .

Select Decrease of Input Tax as the Nature of Adjustment .

Additional Details : Against CST

(35) Tax Balance (Negative Amount denotes Excess Paid)

Displays auto calculated value.

(36) Refund Claim

Displays value of journal voucher recorded for refund .

Declaration

Displays the Name , Status/Designation and Date entered in VAT Return 13 Exporting screen of Form VAT 13 report.

All your local sales are against retail invoice or not?

This option is not supported.

Last updated for Release 5.5.3