Type search words and press enter
A new GSTR-2B API is applicable from 14th Nov 2024, which affects auto-reconciliation of GSTR-2B for Oct-24. Stay tuned for our upcoming release, TallyPrime 5.1, which supports this and makes reconciliation even smoother.
https://help.tallysolutions.com/docs/te9rel54/Tax_India/VAT/Assam/AS_Exp_Print_Frm.htm

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: e-Return 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.

Legend

Indicates what is new in the form

Indicates what has changed in the form

Indicates what has been removed from the form

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 is selected as First 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

(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 ( all any Party Entity/Org Type)

      Import

      Purchase High Seas

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

Displays the values of transactions recorded by selecting goods classified under Schedule IV in purchase invoice, debit note and credit note. The nature of transaction includes purchase exempt (Fourth Schedule), Non-Creditable Purchase Special Goods (Fourth Schedule).

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 is selected as Schedule I in the item master.

      The following Nature of Transaction are considered:

o      Sales Exempt

o      Sales Exempt - Bonded Warehouse

(13) Zero Rate Sales - International Exports

Displays the net assessable values of transactions recorded in sales invoice and credit note. The amount is displayed in Value Excluding Tax (A) column.

Exports is selected as the Nature of Transaction.

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

      Not Applicable

      Exempted/Concession by Notification

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

      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 to account for purchase tax liability.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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

Displays the gross assesable value of transactions recorded by selecting nature of transaction as Sales Tax Free (Fourth Schedule).

Stock items must be predefined with the following settings:

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

Sales Tax Free (IV Schedule) has to be selected as the Nature of Transaction.

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

Displays the values of sales  transactions recorded by selecting stock items attracting 14.5% tax rate.

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:

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

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

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

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.

The stock item ledger 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.

The stock item ledger 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.

The stock item ledger 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)

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.

The stock item ledger 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)

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.

The stock item ledger 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).

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.

The stock item ledger 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).

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.

The stock item ledger 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)

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.

The stock item ledger 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)

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.

The stock item ledger 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 Lengths

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 the total of box (21) + (23).

(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 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 scan be selected:

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.

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

Displays auto-calculated value of the net output VAT liability.

(27) Input tax credit on purchases

Displays the aggregate amount of tax paid on purchases eligible for claiming input tax credit. The value is taken from box 11.

(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 is selected as 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 scan be selected:

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      Reversal of Input Tax is selected as 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 the total amount of sales tax deducted.

(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 dtls: Against CST

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

Displays auto-calculated value.

(36) Refund Claim

This field is left blank.

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