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