Once you have resolved the exceptions in the transactions, you can export Form VAT 10 to required format.
Viewing Quarterly Return Form VAT 10
To view the Quarterly Return Form VAT 10
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT 10.
2. Click E: Export.
3. Enter the required details in the Exporting screen.
4. Press Enter to export.
Legend |
Indicates what is new in the form |
Indicates what has changed in the form |
|
Indicates what has been removed from the form |
This sheet provides fields to record basic details of the company and gross totals. Further, the validate button to check the data provided in the eVAT Form is also provided in this sheet of the eVAT Form excel template.
Field Name |
Description |
Registration No (TIN) |
Displays the tax payer identification number recorded in VAT TIN field of Company VAT Details screen. |
Period From |
Displays the date recorded in the From field of the Change Period screen of Form VAT 10 report. It is the starting date of the quarter for which the Form VAT 10 is being filed. |
Period To |
Displays the date recorded in the To field of the Change Period screen of Form VAT 10 report. It is the last date of the quarter for which the Form VAT 10 is being filed. |
Gross Turnover VAT |
Displays the assessable value of taxable and exempt sales captured in the Tax Liability 1, Tax Liability 2, and Turnover Not Liable for Tax sheet of the Form VAT 10 template. |
Gross Turnover CST |
Displays the assessable value of total interstate sales captured in the CST Turnover Sales sheet of the Form VAT 10 excel template. |
Gross Turnover Total |
Displays the total assessable value of local sales and interstate sales by summing the values captured in Gross Turnover VAT and Gross Turnover CST fields. |
Validate |
This button is used to check the different sheets for completeness and accuracy of data captured. |
Tax liability for turnover from works contract and composition schemes is displayed in this sheet. The information is captured in three different tables.
1.1 Turnover under section 8(3) [Works Contract EC]
Field Name |
Description |
1.1 Turnover under section 8(3) [Works Contract EC] |
|
Name of Awarder – a1 |
Displays the name recorded in the ledger of the party awarding works contract. |
TDN of Awarder - a2 |
Displays the tax deduction number recorded in the ledger of the party awarding works contract. |
Work Order No - a3 |
Displays the document number entered in the Work Order No field in the Statutory Details screen of the transaction. |
Work Order Date – a4 |
Displays the document date entered in the Date field against Work Order No field in the Statutory Details screen of the transaction. |
Total Value of Work Contract – a5 |
Displays the value entered in the Total Value of Works Contract field in Statutory Details screen of the transaction. |
EC No – a6 |
Displays the document number entered in the EC No field of the Statutory Details screen of the transaction. |
EC Date – a7 |
Displays the document date entered in the Date field against EC No in Statutory Details screen of the transaction. |
EC Issuing Authority – a8 |
Displays the authority name entered in the EC Issuing Authority field in Statutory Details screen of the transaction. |
Amount Received From Awarder – b |
Displays the total value of the works contract sales invoice. |
Rate of EC fee – c |
Displays the rate entered in the Rate of EC Fee field in Statutory Details screen of the transaction. |
Other Rate – c |
This is currently left blank. |
Amount of EC fee – d |
Displays the value entered in the Amount of EC Fee field in Statutory Details screen of the transaction. |
EC fee deposit details(By Awarder) – e |
Displays the value recorded in the EC Fee deposit By Awarder field in Statutory Details screen of the transaction. |
EC fee deposit details (By Contractor) – f |
Displays the value recorded in the EC Fee deposit By Contractor field in Statutory Details screen of the transaction. |
1.1.A Detail of purchases (to be filled in case of works contract) |
This field is currently left blank. |
1.1.A.1 Particulars of purchases made within the state against VAT Invoice |
This field is currently left blank. |
1.1.A.2 Particulars of purchases made within the state on which tax has not been paid under the Act |
This field is currently left blank. |
1.1.A.3 Particulars of purchases made from outside the State |
This field is currently left blank. |
1.1.B Turnover of taxable leftover goods |
This field is currently left blank. |
This part is to be filled only by dealers who have opted for payment of tax in lump sum for notified goods u/s 5 (Composition Schemes) and also have other taxable turnover. Lump sum amount payable in lieu of tax during return period for each class of goods is entered in separate rows with details of turnover.
The gross turnover for the return period under Composition scheme, Composition amount payable for the preceding year and Composition amount payable for the return period to be captured here.
The transactions with following conditions will be considered for this section:
● The nature of transaction is Sales – Composition.
● The composition scheme applicable to the company is selected and applicable dates defined.
Field Name |
Description |
Name of Composition Scheme |
Displays the name of the composition scheme. |
Gross Turnover for the return period under composition scheme |
Displays the gross turnover value for the return period under specific composition scheme. |
Composition amount payable for the preceding year |
Displays the details of composition amount payable for the preceding year. |
Composition amount payable for the return period |
Displays the composition amount payable for the return period. |
The fields are currently left blank.
This part is to be filled only by dealers who have opted out of section 3(2) in the return period. Such dealers have to provide the details of turnover and tax payable from the beginning of the financial year up to the date of opting out of section 3(2) as per RVAT rule 18(11).
The transactions with following conditions will be considered for this section:
● The nature of transaction is Sales – Works Contract.
The information captured in the section is described below:
Field Name |
Description |
Tax Rate – c |
Displays the tax rate selected in the transaction (stock item or sales ledger). Works contract after opting out of section 3(2) attract 0.5% tax, the same is updated in this column. If a different rate is recorded, then field is marked as Other. |
Tax Rate If Other – c |
Displays the rate other than 0.5% recorded in the transaction (if any). This field is enabled only when Tax Rate column is marked as Other. |
Commodity – a |
Displays the commodity code assigned to the stock item selected in the transaction. In case commodity code not predefined in the excel template is selected, the column will be marked as Other. |
Commodity If Other – a |
Displays other commodity recorded in the transaction (if any) by selecting the option Other is selected in Commodity column. |
Turnover – b |
Displays the assessable value of each commodity in the transaction. In case the transaction has multiple commodities, details for each are captured in a separate row in this section. |
Amount of Tax – d |
The amount of tax paid for each commodity in the transaction is automatically calculated and is displayed here using the equation d= (b*c)/100. |
In this sheet details of taxable sales and sales returns are captured.
This part is to be filled only by dealers (manufacturer or importer) who have opted to pay tax at full rate on the maximum retail price. Such dealers have to enter the details of sale price, turnover at MRP, and tax payable at MRP on goods for which dealers have opted to pay tax on the maximum retail price as per RVAT rule 18(7). The transactions with following conditions will be considered for this section:
● The nature of transaction selected is Sales Taxable.
● MRP is enabled for the stock items, MRP rate is defined and VAT is calculated on MRP
Field Name |
Description |
Tax Rate* -c |
Displays the tax rate, including 5.5%, selected in the transaction (stock item or sales ledger). If tax rate recorded in the transaction is not predefined in the excel template, then this field is marked as Other. |
Tax Rate If Others- c |
Displays any tax rate used for recording transaction other than predefined rates. This field is enabled only when Tax Rate column is marked as Other. |
Commodity* - a |
Displays the commodity code assigned to the stock item selected in the transaction. In case commodity code not predefined in the excel template is selected, this column is marked as Other. |
Commodity If Other – a |
Displays any other commodity recorded in the transaction if the option Other is selected in Commodity column. |
Turnover* - b1 |
Displays the assessable value of each commodity in the transaction. In case the transaction has multiple commodities, details for each are captured in a separate row in this section. |
Turnover at MRP* - b2 |
Displays the assessable value of each commodity at MRP rate. |
Amount Of Tax – d |
Displays the amount of tax paid for each commodity is calculated automatically using the equation d=(b2*c)/100. |
Dealers have to enter details related to turnover, tax rate including 5.5%, commodity and amount of tax payable on taxable sales.
The transactions with following conditions will be considered for this section:
● The nature of transaction selected is Sales Taxable
● Commodity Code is predefined for the stock item
Field Name |
Description |
Tax Rate/Rate on Unit/Weight/Qty./Measurement |
Displays the tax rate assigned to the stock item selected in the transaction. In case the tax rate assigned to the item is not predefined in the excel template, this column is marked Others. Further, if the item is taxed based on unit of measure, this column is marked as Sale of goods taxable at unit basis. Note: The options Other and Sale of goods taxable at unit basis are predefined in the excel template. |
Rate on Unit/Weight/Qty./Measurement |
This column is activated only if Other or Sale of goods taxable at unit basis is selected in Tax Rate/Rate on Unit/Weight/Qty./Measurement column. In case of former, the other rate will be displayed here and in case of latter the rate for each unit/quantity is displayed for the stock item. |
Unit/Weight/Qty./Measurement |
Displays the unit/weight/quantity of stock items that are grouped as rate on unit will be in this column against respective commodity. |
Commodity |
Displays the name of the commodity assigned to the transacted stock item in this column. |
Commodity If Others |
Displays any commodity that is not predefined in the excel template and commodities that are grouped as rate on unit and units captured in c1 column. |
Turnover |
Displays the assessable value of each commodity. |
Amount Of Tax |
Displays the amount of tax paid for each commodity that is calculated automatically using the equation d=(b*c)/100. |
This part is to be filled only by dealer acting as Principal. Such dealers have to enter details of tax payable by them on sales made by commission agent on behalf of principal against form VAT 36 as per RVAT rule 37. The transactions with following conditions will be considered for this section:
● The nature of transaction is Sales Taxable and the sales ledger must be predefined with Agent as the Company Nature of Business.
The information captured in different columns of this table is described below:
Field Name |
Description |
Tax Rate – c: |
Displays the tax rate, including 5.5%, assigned to the stock item selected in the transaction. In case the tax rate assigned to the item is not predefined in the excel template, this column is marked Others. |
Tax Rate If Others – c |
Displays any tax rate other than predefined rates used in the transaction. This field is enabled only when the option Others is selected in Tax Rate column. |
Commodity – a |
Displays the name of the commodity assigned to the transacted stock item. In case commodity code is not predefined in the excel template is selected, this column is marked as Other. |
Commodity If Other – a |
Displays the name of the commodity entered in case the option Other is selected in Commodity column. |
Turnover – b |
Displays the assessable value of each commodity. |
Amount of Tax – d |
Displays the amount of tax paid for each commodity is calculated automatically using the equation d=(b*c)/100. |
In this part dealers have to enter details related to turnover, tax rate, commodity and amount of tax payable on sales return of goods other than in the return period. The nature of transaction to be used is Sales Taxable.
Please ensure that such return of goods should be within a period of six months from the date of invoice thereof.
The transactions recorded using Credit Note voucher are captured in this table:
Field Name |
Description |
Tax Rate – c |
Displays the tax rate, including 5.5%, assigned to the items returned. In case the tax rate assigned to the item is not predefined in the excel template, this column is marked Others. Further, if the item is taxed based on unit of measure, this column is marked as Sale of goods taxable at unit basis. Note: The options Other and Sale of goods taxable at unit basis are predefined in the excel template. |
Rate on Unit/Weight/Qty./Measurement – c |
This column is activated only if Other or Sale of goods taxable at unit basis is selected in Tax Rate/Rate onUnit/Weight/Qty./Measurement column. In case of former the other rate will be displayed here and in case of latter the rate for each unit/quantity is displayed for the stock item. |
Unit/Weight/Qty./Measurement – b |
Displays the unit/weight/quantity of stock items that are grouped as rate on unit against respective commodity. |
Commodity - a |
Displays the name of the commodity assigned to the returned stock item. In case commodity code is not predefined in the excel template is selected, this column is marked as Other. |
Commodity If Other – a |
Displays any other commodity recorded in the transaction if the option Other is selected in Commodity column. |
Turnover – b1 |
Displays the assessable value of each commodity returned. |
Amount of Tax – d |
Displays the amount of tax for each commodity returned which was automatically calculated. |
In this part dealers have to enter details related to turnover, tax rate, commodity and amount of tax payable on sales return of goods other than in the return period. The nature of transaction to be used is Sales Taxable.
Please ensure that such return of goods should be within a period of six months from the date of invoice thereof.
The transactions recorded using Credit Note voucher are captured in this table:
Field Name |
Description |
Tax Rate – c |
Displays the tax rate, including 5.5%, assigned to the items returned. In case the tax rate assigned to the item is not predefined in the excel template, this column is marked Others. Further, if the item is taxed based on unit of measure, this column is marked as Sale of goods taxable at unit basis. Note: The options Other and Sale of goods taxable at unit basis are predefined in the excel template. |
Tax Rate If Others – c |
Displays any tax rate other than predefined rates used in the transaction. This field is enabled only when the option Others is selected in Tax Rate column. |
Rate on Unit/Weight/Qty./Measurement – c |
This column is activated only if Other or Sale of goods taxable at unit basis is selected in Tax Rate/Rate onUnit/Weight/Qty./Measurement column. In case of former the other rate will be displayed here and in case of latter the rate for each unit/quantity is displayed for the stock item. |
Unit/Weight/Qty./Measurement – b |
Displays the unit/weight/quantity of stock items that are grouped as rate on unit against respective commodity. |
Commodity - a |
Displays the name of the commodity assigned to the returned stock item. In case commodity code is not predefined in the excel template is selected, this column is marked as Other. |
Commodity If Other – a |
Displays any other commodity recorded in the transaction if the option Other is selected in Commodity column. |
Turnover – b1 |
Displays the assessable value of each commodity returned. |
Amount of Tax – d |
Displays the amount of tax for each commodity returned which was automatically calculated. |
The output VAT on sales made using Sales Taxable as the nature of transaction, is auto calculated and displayed here.
Field Name |
Description |
1.5a Tax on sales made by commission agent on behalf of principal against Form VAT 36. |
Displays total assessable value and amount of tax from table 1.5a are columns b and d respectively. |
1.7b Tax on Sales other than above (1.4+1.5-1.6) |
Displays the total turnover and tax from tables 1.4, 1.5 and 1.6 using the formula 1.4+1.5-16. |
1.7 Output Tax due |
Displays the sum of all rows in the table. |
In this sheet details of all the transaction that are exempted from tax is captured.
1.8 Turnover not liable to be Taxed
In this section exempted transaction are captured based on exemption type.
1.8.1 Turnover under Rule 22A(6) (for sub contracts)
Dealers working as subcontractors having turnover which is exempted under Rule 22A by virtue of main contractor having taken EC have to fill details of such turnover.
For each EC of contractor, entries are to be done in separate rows.
The transactions with following conditions are considered for this section.
● The nature of transaction is Sales - Works Contract
● The option Is Subcontract? is set to Yes in the Statutory Details screen of the transaction.
Field Name |
Description |
Name Of Contractor (To whom the work is awarded) |
Displays the name recorded in the ledger of the party selected in the sub contract transaction. |
TIN of Contractor |
Displays the TIN number of the party entered in the TIN of Contractor field in Statutory Details screen of the transaction. |
EC No. |
Displays the document number of exemption certificate issued to the contractor that is entered in the EC No field in the Statutory Details screen of the transaction. |
E.C Issuing Authority |
Displays the issuing authority of exemption certificate issued to the contractor that is entered in the EC Issuing Authority field in Statutory Details screen of the transaction. |
Sub Contract Agreement No. |
Displays the document number of the sub contract agreement that is recorded in the Sub Contract order no. field in Statutory Details screen of the transaction. |
Sub Contract Agreement Date |
Displays the document date of the sub contract agreement that is recorded in the Date field against Sub Contract order no. field in Statutory Details screen of the transaction. |
TDS Deducted if any |
Displays TDS deducted by the contractor for payments made that is recorded in the TDS Deducted if any field in Statutory Details screen of the transaction. |
Total Value Of Works contract |
Displays the value of the works contract recorded in the total value of the Works Contract field in Statutory Details screen of the transaction. |
Value of Sub Contract |
Displays the amount recorded in the Value of the Sub Works Contract field of Statutory Details screen. |
Amount Received From Contractor |
Displays the value of the transaction excluding TDS amount included in the voucher. |
Other Turnover not liable to be Taxed
Field Name |
Description |
1.8.2)Exempted in Schedule-I (sold within state) |
Displays the net turnover of schedule I goods (sales + sales return) in the reporting period transacted using Sales Exempt as nature of transaction is captured in this field. |
1.8.3)Fully Exempted in Schedule-II u/s 8(3) of RVAT ACT |
Displays the net turnover of Schedule II goods (Sales + Sales Returns) in reporting period transacted using Sales Exempt as nature of transaction. |
1.8.4)Sales made for promotion of SEZ or export u/s 8(4) of RVAT ACT |
Displays the net turnover of goods in reporting period transacted using Sales Zero Rated as nature of transaction when the stock item is predefined as Schedule II goods. However, for Sales Zero Rated transactions the option SEZ is selected in the Type of Exemption field in party master to notify exemption category. |
1.8.5)Sales of goods purchased & sold outside state |
Displays the net turnover recorded using the flag Change in Nature of Sales in a journal voucher. The transaction is recorded by debiting interstate sales and crediting interstate sales exempt ledgers. |
1.8.6)Turnover of goods taxable at first point which have already suffered tax |
The net turnover of taxable goods (Sales + Sales Return) that are taxed at first point of sale are captured in this column. The assessable value from sales transactions with Sales Exempt as nature of transaction are eligible for this category when the option First is selected in the Point of Sale field in voucher screen. |
1.8.7)Turnover of goods sold in the state on behalf of principal (against Form VAT 36A) |
Displays the net turnover of goods sold in the state on behalf of principal by using Sales Exempt as nature of transaction and Agent as Company Nature of Business. |
1.8.8)Amount of deductions as provided in RVAT rules (in case of works Contracts) |
Displays the net turnover from transactions with Labour Charges Collected as nature of transaction. Further, it also displays transactions with Sales - Works Contract as nature of transaction the Deduction Amount recorded in the Deduction Claimed for Tax Calculation. |
1.8.9)Sales to Exporters within the state (against FormVAT-15) |
Displays the net turnover of goods sold to exporters within the state by selecting Deemed Export as the nature of transaction. |
1.8.10)Others not liable to tax under VAT (please specify) |
Displays the net turnover of transactions recorded with Sales - Others as the nature of transaction. |
Please Specify |
Displays turnover from transaction which do not qualify to be in the above categories but are not liable to be taxed. |
1.8.11)Turnover of sales return of goods sold within the return period under RVAT |
Displays the turnover of sales return of goods sold within the return period with Sales Taxable or Sales – Works Contract as the nature of transaction. |
1.8)Total((1.8.2 to 1.8.11)+1.8.1(b)) |
Displays the value which was calculated using the formula ((1.8.2 to 1.8.11)+1.8.1(b)). |
B1)Total Turnover b (1.1+ 1.2 +1.3 + 1.4 +1.5+1.8) |
Displays the value which is automatically added turnover values from tables listed in the line description. |
Sheet: Purchase Tax Details of purchases with tax information from dealers other than registered dealer of the State are displayed in this section.
This section captures the details of journal voucher recorded by selecting the nature of adjustment as Tax on URD Purchase.
Field Name |
Description |
Details* @ - c1 |
Displays the tax rate including 5.5%, assigned to the stock item selected in the transaction. In case the tax rate assigned to the item is not predefined in the excel template, this column is marked Others. Further, if the item is taxed based on unit of measure, this column is marked as Sale of goods taxable at unit basis. |
Tax Rate if Others – c1 |
This column is activated only if Other or Sale of goods taxable at unit basis is selected in Tax Rate/Rate onUnit/Weight/Qty./Measurement column. In case of former the other rate will be displayed here and in case of latter the rate for each unit/quantity is displayed for the stock item. |
Rate on Unit/Weight/Qty./Measurement |
The unit/weight/quantity of stock items that are grouped as rate on unit will be displayed in this column against respective commodity. |
Type of tax – c3 |
Displays the tax type viz., Purchase Tax, Tax on goods as per notification 2014-23 dated 14.07.2014, Tax as per rule 22A, Tax as per rule 17A, Tax as per rule 43 (Tax on Closing Stock in case of Closure of business), and Tax as per rule 18(7A) (VAT dealers switching over to 3(2)) based on the selection in the transaction. |
Purchased from |
Displays the source of purchase viz., Purchase form outside the state or Purchase within the state based on the selection in the transaction. |
Commodity – a |
Displays the name of commodity assigned to the stock item . |
Commodity If Others – a |
Displays any commodity that is not predefined in the excel template and commodities that are grouped as rate on unit and units in Rate on Unit/Weight/Qty./Measurement column. |
Turnover – a |
Displays the assessable value of each commodity. |
Tax Amount –d |
Displays the amount of tax paid for each commodity that is calculated automatically using the equation d=(b*c)/100. |
Dealers must enter details of input tax for which credit has been availed in contravention of the provisions of section 18 with reason for reversal of tax. This includes transactions of 5.5% tax rate.
B3. REVERSE TAX
Field Name |
Description |
Tax Rate - c |
Displays the tax rate assigned to the stock item selected in the transaction. In case the tax rate assigned to the item is not predefined in the excel template, this column is marked Others. Further, if the item is taxed based on unit of measure, this column is marked as Sale of goods taxable at unit basis. |
Tax Rate if Others – c |
This column is activated only if Other or sale of goods taxable at unit basis is selected in Tax Rate/Rate onUnit/Weight/Qty./Measurement column. In case of former the other rate will be displayed here and in case of latter, the rate for each unit/quantity is displayed for the stock item. |
Rate on Unit/Weight/Qty./Measurement |
The unit/weight/quantity of stock items that are grouped as rate on unit will be displayed in this column against respective commodity. |
Commodity – a2 |
The name of commodity assigned to the stock item is displayed here. |
Commodity If Others – a2 |
Any commodity that is not predefined in the excel template and commodities that are grouped as rate on unit and units displayed in Rate on Unit/Weight/Qty./Measurement column is updated in this column. |
Turnover – b |
Displays the assessable value of each commodity. |
Tax Amount –d |
Displays the amount of tax paid for each commodity that is calculated automatically using the equation d=(b*c)/100. |
In any other case (Please specify) |
Displays the reason for reversal of tax that is not predefined in the excel template. The Turnover and Amount of Tax from all such transactions will be displayed in the respective columns in this row. |
B3) Total (1.2 to 1.5) |
Displays the value automatically from the tables listed. |
The details of local purchases and purchase of capital goods recorded by selecting the following nature of transactions are captured here:
● Purchase Taxable
● Purchase Taxable - Capital Goods
In this section local purchases are captured rate wise and commodity wise.
Field Name |
Description |
Tax Rate* - c |
Displays the tax rate including 5.5%, assigned to the stock item selected in the transaction. In case the tax rate assigned to the item is not predefined in the excel template, this column is marked Others. Further, if the item is taxed based on unit of measure, this column is marked as Sale of goods taxable at unit basis. |
Tax Rate If Others – c |
This column is activated only if Other or Sale of goods taxable at unit basis is selected in Tax Rate/Rate onUnit/Weight/Qty./Measurement column. In case of former the other rate will be displayed here and in case of latter the rate for each unit/quantity is displayed for the stock item. |
Rate on Unit/Weight/Qty./Measurement |
The unit/weight/quantity of stock items that are grouped as rate on unit will be displayed in this column against respective commodity. |
Commodity – a |
The name of commodity assigned to the stock item is displayed here. |
Commodity If Others – a |
Any commodity that is not predefined in the excel template and commodities that are grouped as rate on unit and units displayed in Rate on Unit/Weight/Qty./Measurement column is updated in this column. |
Purchase Value excluding VAT – b |
Displays the purchase value of each commodity excluding the VAT amount. |
Input Tax – d
|
Displays the amount of tax paid for each commodity calculated automatically using the equation d=(b*c)/100. |
1.1 Total |
Displays the total for purchase value and Input VAT in the table in their respective cells. |
Purchases of Capital Goods
The transactions recorded for purchase of capital goods are captured in this section.
Field Name |
Description |
Tax Rate* - c |
Displays the tax rate, including 5.5%, assigned to the stock item selected in the transaction recorded for purchase of capital goods. In case the tax rate assigned to the item is not predefined in the excel template, this column is marked Others. Further, if the item is taxed based on unit of measure, this column is marked as Sale of goods taxable at unit basis. |
Tax Rate If Others – c |
This column is activated only if Other or Sale of goods taxable at unit basis is selected in Tax Rate/Rate on Unit / Weight / Qty ./ Measurement column. In case of former the other rate will be captured here and in case of latter the rate for each unit/quantity is captured for the stock item. |
Rate on Unit/Weight/Qty./Measurement |
Displays the unit/weight/quantity of stock items that are grouped as rate on unit against respective commodity. |
Commodity – a |
Displays the name of commodity assigned to the stock item. |
Commodity If Others – a |
Displays any commodity that is not predefined in the excel template and commodities that are grouped as rate on unit and units captured in Rate on Unit/Weight/Qty./Measurement column. |
Purchase Value excluding VAT – b |
Displays the purchase value of each commodity excluding the VAT amount. |
Input Tax – d
|
Displays the amount of tax paid for each commodity (capital goods) that is calculated automatically using the equation d=(b*c)/100. |
1.2) Total |
Displays the total for purchase value and Input VAT captured in the table for purchase of capital goods in their respective cells. |
1.3) Total(1.1 to 1.2) |
Displays the purchase value and input VAT amount from table 1.1 and 1.2 in the sheet in their respective cells. |
1.4) ITC claimed in 7A by the dealer |
Displays the value in 1.3) Total(1.1 to 1.2) field. |
1.5) Purchase return (Purchased within the return period): |
Displays the assessable value and input VAT amount from the purchase return transactions recorded in this period for purchases of current period. The purchase return transactions with Purchase – Taxable, Purchase – Works Contract and Purchase Taxable – Capital Goods as nature of transaction will only be considered for this field. |
1.6) Total eligible input tax credit { Minimum of (1.3-1.5) and 1.4 } |
Displays the values in the cells of this field based on the formula given. This the minimum of difference between 1.3 and 1.5 or 1.4. |
1.7) Amount of ITC Brought forward from previous return |
Displays the ITC carried forward from last reporting period along with the assessable value. If ITC was not carried forward from previous period no values will be displayed in this field. |
1.8) Total Input Tax Credit Available (1.6+ 1.7) |
The values in cells of this field will appear automatically. |
In this sheet details of interstate sales both taxable and exempt are captured with tax type and exemption form information.
1.1 Tax Liability under CST
Commodity wise details of interstate sales transaction that create tax liability are captured in this section with tax type information.
Field Name |
Description |
Details of Sales* - a1 |
|
Tax Rate - c |
Displays the tax rate assigned to the Details of Sales selected. In case the tax rate is not assigned to Details of Sales, this column is marked Others. Further, if the item is taxed based on unit of measure, this column is marked as Tax on Weight/Unit. |
Tax Rate if Others – c |
This column is activated only if Other, Tax on Weight/Unit is selected in Tax Rate column. Further when Details of Sales is not assigned to the tax rate this column is activated and rate assigned to the commodity in the transaction is captured here. |
Unit/Weight/Qty./Measurement |
Displays the unit/weight/quantity of stock items that are grouped as rate on unit against respective commodity. |
Commodity – a2 |
Displays the name of commodity assigned to the stock item. |
Commodity If Others – a2 |
Displays any commodity that is not predefined in the excel template and commodities that are grouped as rate on unit and units captured in Unit/Weight/Qty./ Measurement column . |
Turnover – b |
Displays the assessable value of each commodity. |
Tax Amount –d |
Displays the amount of tax paid for each commodity that is calculated automatically using the equation d=(b*c)/100. |
1.1.9)Total |
Displays the total of assessable value and amount of tax captured in the table in their respective cells. |
1.1.10) Sales return of taxable goods under section 8A of CST ACT (other than return period) |
Displays the assessable value and amount of tax from sales return transactions recorded against interstate sales from previous reporting period. Sales return transactions with nature of transaction such as Interstate Sales - Taxable, Interstate Sales – Works Contract, and Interstate Sales – Against Form C are considered for capturing in this field. |
1.1)Total CST (1.1.9 -1.1.10) |
Displays the value in this field will appear automatically by added amounts from 1.19 and 1.1.10. |
1.2) Turnover not liable to tax under CST |
Displays the assessable value of Interstate transactions not liable to be taxed. |
Details of Sales |
|
1.2.1) Sales in course of Export U/s 5(3) of CST ACT, (against Form H) |
Displays the net assessable value from transactions recorded in reporting period with Deemed Export as nature of transactions and by selecting form H. |
1.2.2) Sales in course of Export U/s 5(1) of CST ACT: |
Displays the assessable value from transactions recorded in reporting period with Exports as nature of transactions. |
1.2.3) Sales outside State/Branch/Depot/ Stock/Transfer/Consignment Sale (against Form F): |
The net assessable value from transactions recorded in reporting period with Interstate Consignment Transfer Outward as nature of transactions and by selecting form F is captured here. |
1.2.4) Subsequent Inter State sales u/s 6(2) of CST ACT (against Form C and EI/ E II) |
Displays the net assessable value from transactions recorded in reporting period with Interstate Sales - E1, Interstate Sales - E2 and Interstate Sales Exempt - E1 as nature of transactions and by selecting form E1. |
1.2.5) Inter State sales under section 6(3) of CST ACT (against Form J) |
Displays the net assessable value from transactions recorded in reporting period with Interstate Sales – Zero Rated as Nature of Transactions and sales ledger predefined with Diplomatic Missions, U.N, UNICEF, WHO & Foreign Aid as the Party Entity/Org Type. |
1.2.6) Inter State sales made to SEZ under section 8(6) of CST ACT (against Form I) |
Displays the net assessable value from transactions recorded in reporting period with Interstate Sales – Zero Rated as Nature of Transactions and sales ledger predefined with SEZ / STP / EHTP by selecting Form I. |
1.2.7) Exempted Sales under CST ACT |
Displays the net assessable value from transactions recorded in reporting period with Interstate Sales - Exempted as Nature of Transactions. |
1.2.8)Other deductions, if any, (Please specify): |
Displays the net assessable value from transactions recorded in reporting period with Interstate Sales - Others as Nature of Transactions. |
1.2) Total |
Displays the value which is the sum of amounts entered in the table. |
1.3 ) Turnover of sales return of goods sold within the return period CST |
Displays the assessable value from sales return transactions recorded for interstate sales in current reporting period. Sales return transactions with nature of transaction as Interstate Sales - Taxable is considered for this transaction. |
C) Total Turnover (1.1+ 1.2+1.3) |
Displays the value that is automatically calculated using the given formula. |
Tax due and deposit details are captured in this sheet.
D –Details of Tax due and Deposit of Tax, Interest, and Late Fee
VAT and CST amounts payable for a particular period is captured in this table.
Field Name |
Description |
Payment Category(Please Select)* |
Displays the periodicity of VAT and CST payment based on the period for which the Form VAT 10 is generated. The predefined categories are Quarterly, Monthly and Thrice in a Month |
Tax Period From |
Displays the starting date of the period for which the VAT/CST is payable, i.e, the starting date of the period for which the form is generated. |
Tax Period To. |
Displays the end date of the reporting period depending on the payment category (period) and Tax Period From. |
Tax Type |
Displays the tax type depending on the tax liability for the period,( VAT and/or CST). |
Tax Due |
Displays the liability due to be paid against VAT and CST respectively. |
In this table the deposits made in the current period against tax liability is captured.
Field Name |
Description |
Tax Period From |
Displays the value automatically. |
Tax Period To |
Displays the value the automatically captured from the information recorded in the table. |
Due Date |
Displays the due date based on the Tax Period From and Tax Period To. |
Tax Type |
Displays Tax liability Type (VAT or CST) based on the Tax Type selected in the Stat Payment Details screen of payment transaction recorded for depositing tax amount. |
Tax Deposited |
Displays the voucher amount of the payment transaction recorded using Stat Payment option to deposit the tax liability amount for the period. |
Date Of Deposit |
Displays the voucher date of the payment transaction recorded for deposit of VAT/CST amount. |
Delay in Deposit
|
Displays the date of deposit later than Due Date, i.e., the number of days of delay. |
Interest Due |
Displays the interest due in case of delay in deposit of tax. |
Interest Deposited |
Displays the voucher value from the payment transaction recorded by selecting Interest as the Payment Type for VAT/CST tax type. |
Date Of Deposit Of Interest |
Displays the voucher date of the payment transaction recorded for deposit of interest. |
Mode of Deposit for Tax |
Displays the mode of deposit selected in the payment transaction. The predefined set of deposit modes are listed in the excel template. |
Description for Tax / CIN/GRN |
Displays the description recorded for the deposit of tax. |
Mode of Deposit for Interest |
Displays the mode of deposit selected in the payment transaction for deposit of interest. The predefined set of deposit modes are listed in the excel template. |
Description for Interest / CIN/GRN |
Displays the description recorded for deposit of interest. |
The details of TDS certificates received in the reporting period is captured in this sheet.
In this section Registered dealers engaged in execution of works contract have to enter details of VAT 41 received from awarder of the works contract. Awarder Name: The name of the party selected in the journal transaction recorded by selecting TDS Adjustment flag and Reduce Input Credit as the purpose is captured here.
Field Name |
Description |
VAT - 41 No |
Displays the VAT 41 number entered in the journal transaction for TDS Adjustment. |
Contract Value |
Displays the amount entered in the Contract Value field in the transaction. |
Amount received from Awarder |
Displays the amount entered in the Amount received from Awarder field of the transaction. |
TDS Amount |
Displays the value recorded in the TDS amount field in the transaction. |
Deposit Details |
|
Gross Amount of Challan/ E challan |
Displays the challan number used for deposit of TDS from the Challan number field in the transaction. |
Deposit Date |
Displays the date recorded against challan number field is captured here. |
The tax payable or tax liability created for the reporting period is captured here based on the details recorded in the various sheets of the excel template.
E: Tax Payable
Total Tax Payable/Deferred
Field Name |
Description |
1.1 Output Tax (B1.1.7(d)) |
Displays the value from total of column d (Amount of Tax) in table 1.7 Output Tax under section B in the worksheet Tax Liability 2. |
1.2 Tax collected as per sales invoice |
Displays the total sum of output tax collected in all the sales invoices. |
1.3 Output tax (maximum of 1.1 and 1.2) |
Displays the maximum of above fields 1.1 and 1.2. |
1.4 Purchase Tax/ Tax as per rule 22A/43/18(7A)/17A (B2) |
Displays the total of column d in B2 (Purchase Tax table) in worksheet Purchase Tax. |
1.5 Reverse Tax (B3) |
Displays the total of column d in B3 (Reverse Tax table) is captured here. |
1.6 Others, If any, (Specify): |
|
Other Description |
|
1.7 Total tax (1.3 to 1.6) |
Displays the sum of values in the fields 1.3 to 1.6. |
1.8 Total input tax credit available (B4.1.8) |
Displays the value from d- Input tax column of 1.8 Total Input Tax Credit Available in (B4) in Input Tax worksheet. |
1.9 Net Tax Payable (1.7 –1.8) |
Displays the value automatically computed by deducting amount in above field 1.8 from 1.7. |
1.10 Tax Deferred in Percent (under VAT) |
Displays the deferred percentage based on the amount of tax deferred. |
1.11 Tax Deferred (under VAT) |
Displays the voucher amount from the journal transaction recorded to reduce the output vat by selecting Amount of Tax Deferred flag. |
1.12 Amount Payable (+)/Creditable (1.9 - 1.11) |
Displays the value by deducting the amount in the field 1.11 from the value in 1.9. |
1.13 Exemption Fee (in case of works contract)(B 1.1d) |
Displays the value computed using the total value from column d in the table 1.1 Turnover under section 8(3) [Works Contract EC] under B1 in the worksheet Tax Liability 1. |
1.14 Composition Fee (B1.1.2 d) |
Displays the value computed based on the value from total of column d in the table 1.2 Turnover under section 5(1) of RVAT Act (Composition Schemes) under B1 in worksheet Tax Liability 1. |
1.15 Tax Payable on Turnover under section 3(2) [in case opt out of section 3(2)] (B1.1.3 d)
|
Displays the value in total of column d in the table 1.3 Turnover under section3(2) [in case opt out of section 3(2)] under B1 in worksheet Tax Liability 1. |
1.16 Total Amount Payable(+)/Creditable(- )(1.12+ 1.13+1.14+1.15) |
Displays the the sum of amounts in 1.12 + 1.13 + 1.14 + 1.15. |
1.17 Amount Deposited Under VAT |
Displays the with sum from column Tax Deposited for VAT tax type in the table 2. Details of Deposit in the worksheet Details of Tax Due. |
1.18 Amount Payable (+)/Creditable (-) (1.16 - 1.17) |
Displays the prefilled value calculated by deducting the amount in the field 1.15 from the value in 1.14. |
1.19 Tax due under CST ACT (C-1.1) |
Displays the total of column d from the table 1.1 Tax Liability under CST under C. Turnover and Liability under CST in CST Turnover Details worksheet. |
1.20 Tax Collected as per sales invoice |
Displays the CST collected as per sales invoice. CST collected as per sales invoice will be equal to Tax due under CST calculated in the above field. |
1.21 Maximum of 1.19 and 1.20 |
Displays the maximum of values in 1.19 and 1.20 fields. |
1.22 Tax Deferred in percent (Under CST) |
Displays the deferred percentage based on the amount of CST deferred. |
1.23 Tax Deferred (Under CST) |
Displays the voucher amount from the journal transaction recorded to reduce the CST by selecting Amount of Tax Deferred flag. |
1.24 Set off of Entry Tax paid (Only in case of CST for commodity like paper, Dyes and dyes stuff, Textile auxiliaries, Edible oil notified under section 8 (5) of CST ACT) |
Displays the voucher value from the journal transaction recorded using the flag Adjustment towards Entry Tax. |
1.25 CST to be deposited |
Displays the value that is automatically calculated by deducting the amounts in 1.23 and 1.25 from 1.21. |
1.26 Creditable ITC to be adjusted (1.18 if in minus) |
Displays the value in 1.18 if it is negative. But if the value in 1.18 is positive, then this field is left blank. |
1.27 CST payable (1.25 - (absolute value of 1.18 if in minus) |
Displays the value calculated from deducting the amount in 1.26 from 1.25. |
1.28 Amount Deposited Under CST |
Displays the sum from column Tax Deposited for CST tax type from the table 2. Details of Deposit in the worksheet Details of Tax Due. |
1.29 Net Tax payable / creditable (1.27 - 1.28 ) |
Displays the value that is automatically calculated by deducting the amounts in 1.28 from 1.27. |
1.30 Adjusted against Late Fee (if any) |
Displays the voucher value from the journal transaction created using Late Fees Payable flag. |
1.31 Refund claimed (if any) |
Displays the voucher total from the journal transaction recorded using Amount of Tax Deferred flag by selecting the purpose Reduce the Output. |
1.32 ITC to be carried forward for next quarter |
Displays the value only when the value in 1.29 field is negative. |
Details related to late fee payment is captured in this sheet.
Field Name |
Form Description |
Details of Late Fee |
|
Due Date of filing of Return |
Displays the date recorded in the Due date of filing field in Export Report screen of Form VAT 10. |
Date of submission of Return |
Displays the date recorded in the Date of Return Submission field in Export Report screen of Form VAT 10. |
Total Late Fees Due |
Displays the value that is automatically calculated based on the payment details recorded in Details of Tax Due sheet. |
Amount of Late Fee |
Displays the voucher total from the payment transaction recorded by selecting Late Fee as the Payment Type. |
Date of Deposit of late fee |
Displays the voucher date of the payment transaction recorded for Late Fee. |
Mode of Deposit |
Displays the mode of deposit selected in the payment transaction. The predefined set of mode of deposit are listed in the excel template. |
Description |
Displays the description recorded in the payment transaction, if any. |
Last updated for Release 5.3.4