Exporting Data to e-VAT Form VAT 10 (Rajasthan)

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

1.1   Turnover under section 8(3) [Works Contract EC]

This part is to be filled only by EC holding Works Contract dealers who have received payment from awarder in return period.  Such dealers have to enter details of EC and payment received from awarder against works contract in the return period. For each EC entries have to be recorded in a separate row.

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.

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.

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

Tax Rate* -c

Displays the tax rate (various tax rates including 13%), as selected in the transaction (stock item or sales ledger). If tax rate recorded in the transaction is not predefined in the Microsoft 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 Microsoft 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.

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 Microsoft Excel template, this column is marked Other . 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 Microsoft 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 Microsoft 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.

Tax Rate – c:

Displays the tax rate (various tax rates including 13%), as defined for the stock item selected in the transaction. In case the tax rate assigned to the item is not predefined in the Microsoft Excel template, this column is marked Other .

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 Other 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 Microsoft 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.

Tax Rate – c

Displays the tax rate (various tax rates including 13%), as defined for the stock items returned. In case the tax rate assigned to the item is not predefined in the Microsoft Excel template, this column is marked Other . 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 Microsoft 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 T ax 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 Microsoft 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.

Tax Rate – c

Displays the tax rate (various tax rates including 13%), as defined for the stock items returned. In case the tax rate assigned to the item is not predefined in the Microsoft Excel template, this column is marked Other . 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 Microsoft 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 Other 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 Microsoft 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.

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.

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.

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.

Details* @ - c1

Displays the tax rate (various tax rates including 13%), as defined for the stock item selected in the transaction. In case the tax rate assigned to the item is not predefined in the Microsoft Excel template, this column is marked Other . 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 Microsoft 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.

Details of transactions(1.1 To 1.4)*:

Displays the reason for reversal of tax for the commodity.

Tax Rate - c

Displays the tax rate (various tax rates including 13%), as defined for the stock item selected in the transaction. In case the tax rate assigned to the item is not predefined in the Microsoft Excel template, this column is marked Other . 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 Microsoft 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 Microsoft 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.

Tax Rate* - c

Displays the tax rate (various tax rates including 13%), as defined for the stock item selected in the transaction. In case the tax rate assigned to the item is not predefined in the Microsoft Excel template, this column is marked Other . 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 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 Microsoft 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.

Tax Rate* - c

Displays the tax rate (various tax rates including 13%), as defined for 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 Microsoft Excel template, this column is marked Other . 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 Microsoft 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 of all tax rates, including 13%, 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.

Details of Sales* - a1

Displays the interstate sales type liable to be taxed. As each interstate transaction is required to be categorised based on CST tax type. The list of interstate sales type are given below with nature of transaction to be selected for each sales type.

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 Microsoft 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 , Interstate Sales Exempt - E1 , and Interstate Sales Exempt - With Form C as nature of transactions and by selecting the declaration form.

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.

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.

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 Microsoft 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 Microsoft Excel template.

Description for Interest / CIN/GRN

Displays the description recorded for deposit of interest.

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.

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 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 t he 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 Microsoft Excel template.

Description

Displays the description recorded in the payment transaction, if any.