The Form VAT III excel template provided for filing returns has provision to capture details of all VAT annexures in specific sheets of the excel file. When Form VAT III is saved and exported, information related to all annexures is also exported to the same file.
To export data to VAT_III template
1. Copy the excel template to the Tally.ERP 9 installed folder.
2. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form III. The Form III report appears.
3. Press Ctrl+E to export the data to the template. Based on the Form III report period, the From and To dates are displayed here. These dates can be changed from Form III report, if required.
4. Press Ctrl+A to export data.
The data gets exported to the e-return template.
|
Field Name |
Description |
||
|
TIN |
Displays the TIN entered in the Company VAT Details screen of Statutory & Taxation features. |
||
|
PAN |
Displays the PAN/Income tax no. entered in the Company Operations Alteration screen of Statutory & Taxation features. |
||
|
Financial Year |
Displays the year based on the period of Form III report. |
||
|
Period From and To |
Displays the dates of Form III report period. |
||
|
Return Type |
Displays the Type of Return selected in the Export Report screen of Form III. |
||
|
Filing Date |
Displays the system date. |
||
|
4 Turnover, Taxable Turnover of sales and computation of Output tax |
|||
|
A. Total turnover of sale received/receivable |
Displays: ● Gross assessable value of local and interstate taxable sales. Displays the gross assessable value of sales recorded with the following nature of transactions: ● Sales - Taxable ● Sales - Works Contract ● Interstate Sales - Taxable ● Interstate Sales - Against Form C ● Interstate Sales - E1 ● Interstate Sales - Works contract ● Net assessable value of all exempt sales. Displays the net assessable value of sales recorded with the following nature of transactions: ● Deemed Export ● Sales High Seas ● Exports ● Branch Transfer Outward ● Consignment Transfer Outward ● Sales Zero Rated ● Sales Exempt ● Interstate Branch Transfer Outward ● Interstate Consignment Transfer Outward ● Interstate Sales Exempt - E1 ● Interstate Sales - E2 ● Interstate Sales - Zero Rated ● Interstate Sales Exempt ● Interstate Deemed Export ● Interstate Sales Exempt - With Form C |
||
|
B. Deductions (from the above sale) |
|||
|
1. Sales of Exempted Goods under rule 4(1)(b) |
Displays the net assessable value of sales with Sales Exempt selected as the nature of transaction. |
||
|
2. Sale on which no tax is leviable under rule 4(1)(a) |
Displays the net assessable value of sales with Sales Zero Rated selected as the nature of transaction. |
||
|
3. Sales in the course of Inter-state trade under 4(1)(c) |
Displays the gross assessable value of interstate sales. Displays the gross assessable value of sales recorded with the following nature of transactions: ● Interstate Sales - Against Form C ● Interstate Sales - E1 ● Interstate Sales - E2 ● Interstate Sales - Taxable ● Interstate Sales - Zero Rated ● Interstate Sales Exempt ● Interstate Sales Exempt - E1 ● Interstate Sales Exempt - With Form C ● Interstate Sales - Works Contract |
||
|
4. Sales in the course of import into/Export out of India under 4(1)(c) |
Displays the net assessable value of sales with Exports, Sales High Seas, Deemed Export and Interstate Deemed Export selected as the nature of transaction. |
||
|
5. Value of goods transferred or dispatched (stock transferred) under -4(1)(e) |
Displays the net value of sales with Interstate Branch Transfer Outward and Interstate Consignment Transfer Outward selected as the nature of transaction. |
||
|
6. Value of goods sent for sale to local agents under 4(1)(f). |
Displays the net value of sales with Branch Transfer Outward and Consignment Transfer Outward selected as the nature of transaction. |
||
|
7. The amount of sale of goods returned within the prescribed time under 4(1)(d) |
Displays the value of credit note with Sales - Works contract and Sales Taxable selected as the nature of transaction. Displays sales returns recorded within six months from the original invoice date. |
||
|
8. Sum allowed as cash discount in the bill / tax invoice under 2(ad). |
Displays the value entered for discount ledger in sales, with Sales - Works contract and Sales Taxable selected as the nature of transaction. In the discount ledger grouped under expense or income, the option Type of Ledger? must be set to Discount. |
||
|
Total of B (1) to (8) |
Displays auto calculated value. |
||
|
4C. Taxable Turnover of sales (A-B) |
Displays auto calculated value. |
||
|
5A. Rate wise bifurcation (sales&o/p tax). Value.Tax. |
Tax% |
Value |
Tax |
|
(5)A.1. Sales taxable @ 1% |
Displays the rate of tax defined in the sales ledger or stock item. |
Displays net assessable value of sales taxable at 1%. Displays the assessable value of sales recorded with: ● Sales Taxable as the nature of transaction ● Stock item or sales ledger predefined with 1% tax rate. |
Displays the tax amount of sales taxable at 1%. Displays the amount entered for VAT ledger for sales recorded with: ● Sales Taxable as the nature of transaction ● Stock item or sales ledger predefined with 1% tax rate. |
|
(5)A.2. Sales taxable @ 5% |
Displays the rate of tax defined in the sales ledger or stock item. |
Displays net assessable value of sales taxable at 5%. Displays the assessable value of sales recorded with: ● Sales Taxable as the nature of transaction ● Stock item or sales ledger predefined with 5% tax rate. |
Displays the tax amount of sales taxable at 5%. Displays the amount entered for VAT ledger for sales recorded with: ● Sales Taxable as the nature of transaction ● Stock item or sales ledger predefined with 5% tax rate. |
|
(5)A.3. Sales taxable @ 12.5% |
Displays the rate of tax defined in the sales ledger or stock item. |
Displays net assessable value of sales taxable at 12.5%. Displays the assessable value of sales recorded with: ● Sales Taxable as the nature of transaction ● Stock item or sales ledger predefined with 12.5% tax rate. |
Displays the tax amount of sales taxable at 12.5%. Displays the amount entered for VAT ledger for sales recorded with: ● Sales Taxable as the nature of transaction ● Stock item or sales ledger predefined with 12.5% tax rate. |
|
(5)A.4. Sale of goods specified in schedule 'C' (give rate wise) |
Displays the rate of tax defined in the sales ledger or stock item. |
Displays net assessable value of sales taxable at any other rate. Values are displayed based on tax rates with highest transaction value. Displays the assessable value of sales recorded with: ● Sales Taxable as the nature of transaction ● Stock item or sales ledger predefined with any tax rate other than 1%, 5% and 12.5%. |
Displays the tax amount of sales taxable at any other rate. Tax amount are displayed based on tax rates with highest transaction value. Displays the amount entered for VAT ledger for sales recorded with: ● Sales Taxable as the nature of transaction ● Stock item or sales ledger predefined with any tax rate other than 1%, 5% and 12.5%. |
|
5B. Total Sales taxable |
Displays auto calculated value. |
||
|
5C. Sale of Capital goods and Industrial inputs claimed under entry (23) & (53) resp. of Sch. ‘B’ and included taxable @4% sales |
Capital Goods |
Industrial inputs |
|
|
Displays the value of sales with: ● Sales Taxable selected as the nature of transaction. ● Sales ledger or stock items, which are predefined with the following settings: o Tax rate is set to 5%. o Schedule is selected as Schedule B. o Type of goods is selected as Capital Goods. |
Displays the value of sales with: ● Sales Taxable selected as the nature of transaction. ● Sales ledger or stock items, which are predefined with the following settings: o Tax rate is set to 5%. o Schedule is selected as Schedule B. o Type of goods is selected as Industrial inputs. |
||
|
6. Turnover of purchases |
|||
|
i. Imports from outside |
Displays the net assessable value of purchases with Imports selected as the nature of transaction in the Exempted column. |
||
|
ii. Interstate Purchases |
Displays the net value of purchases recorded with the following nature of transactions in the Taxable column based on the tax rate: ● Interstate Purchase - Against Form C ● Interstate Purchase - Taxable ● Interstate Purchase - E1 Displays the net value of purchases recorded with the following nature of transactions in the Exempted column based on the tax rate: ● Interstate Purchase Exempt ● Interstate Purchase Exempt - With Form C ● Interstate Purchase Exempt - E1 ● Interstate Purchase - E2 ● Interstate Purchase - Zero Rated ● Interstate Purchase Deemed Export |
||
|
iii Consignment Transfer |
Displays the net assessable value of purchases with Branch Transfer Inward, Interstate Branch Transfer Outward, Interstate Consignment Transfer Outward and Consignment Transfer Inward selected as the nature of transaction in the Exempted column. |
||
|
iv Local purchases from registered dealers against Invoice |
|||
|
iva) Tax |
Displays the gross assessable value of purchases recorded by setting the option Purchase Against Restricted Tax Invoice? to No, in Statutory Details screen of purchase invoice for the following nature of transactions in the Taxable column based on the tax rate: ● Purchase - Works contract ● Purchase Taxable ● Purchase Taxable - Capital Goods |
||
|
ivb) Restricted Tax |
Displays the net assessable value of purchases recorded by setting the option Purchase Against Restricted Tax Invoice? to Yes, in Statutory Details screen of purchase invoice. Displays the net assessable value of purchases recorded with the following nature of transactions in the Taxable column based on the tax rate: ● Purchase - Works Contract ● Purchase - Capital Goods ● Purchase Taxable Displays the net assessable value of purchases recorded with the following nature of transactions in the Exempted column: ● Purchase - Zero Rated ● Purchase Exempt ● Purchase Deemed Export |
||
|
v. Local purchase |
Displays the net assessable value of purchases with Purchase From Composition Dealer and Purchase From Unregistered Dealer selected as the nature of transaction. The consolidated value of such purchases are displayed in Exempted column. |
||
|
vi. Other |
Displays the net assessable value of purchases with Purchases - Others, Non Creditable Purchase - Special Goods, Purchase - Zero Rated, Purchase Exempt, and Purchase Deemed Export selected as the nature of transaction. The value is displayed in Exempted column. |
||
|
Total |
Displays auto calculated value. |
||
|
7. Input Tax Credit |
|||
|
a. Total admissible input tax on purchases covered under item 6(iv) above |
Displays auto calculated value. |
||
|
b.i. ITC admissible on account of op. stock held on appointed date/date of registration |
Displays the debit value entered for VAT ledger in journal voucher for input tax on opening stock. To account for increase in input tax 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Increasing Input Tax as the Nature of Adjustment. o Select Opening Stock for Additional Details. 3. Debit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 4. Credit the ledger grouped under Current Assets. 5. Press Ctrl+A to save. |
||
|
ii. ITC admissible on Capital goods |
Displays the debit value entered for VAT ledger in journal voucher for input tax on capital goods. To account for each installment of input tax on capital goods 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Input Tax Credit Admitted On Capital Goods as the Nature of Adjustment. 3. Debit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 4. Credit the ledger grouped under Current Assets. 5. Press Ctrl+A to save. |
||
|
iii. ITC carried over from previous tax period |
Displays auto calculated value. |
||
|
iv. Entry tax paid, if any. |
Displays the debit value of VAT entered in journal voucher recorded for entry tax adjustment. To adjust the entry tax against input VAT 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Increasing Input Tax as the Nature of Adjustment. o Select Entry Tax Paid for Additional Details. 3. Debit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 4. Credit the ledger grouped under Current Assets. 5. Press Ctrl+A to save. |
||
|
v. 75% of net tax liability under the Net Present Value Compulsory Payment Scheme 2005 |
Displays the debit value of VAT entered in journal voucher recorded for compulsory payment scheme. To account for compulsory payment scheme 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Increasing Input Tax as the Nature of Adjustment. o Select ITC on Net Present Value Scheme for Additional Details. 3. Debit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 4. Credit the ledger grouped under Current Assets. 5. Press Ctrl+A to save. |
||
|
Total of b(i) to b(v) |
Displays auto calculated value. |
||
|
Total ITC of 7(a) & (b) |
Displays auto calculated value. |
||
|
7.c. Reverse Credit on account of |
|||
|
i. Goods (purchases) returned within the prescribed time |
Displays the value of debit note recorded with Purchase - Works contract, Purchase Taxable - Capital Goods and Purchase Taxable selected as the nature of transaction. Displays the purchase returns recorded within six months, from the original invoice date. |
||
|
ii. On stock transfer 4% on section 6(iii) |
Displays the credit value entered for VAT ledger in journal voucher to reverse the tax credit on stock transfer. To record reverse credit on stock transfer 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Reversal of Input Tax as the Nature of Adjustment. o Select Stock Transfer for Additional Details. 3. Debit the purchase ledger. 4. Credit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 5. Press Ctrl+A to save. |
||
|
iii. Apportionment for manufacturing of exempt goods |
Displays the credit value entered for VAT ledger in journal voucher to reverse the tax credit on manufacture of exempt goods. To reverse tax credit on manufacture of exempt goods 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Reversal of Input Tax as the Nature of Adjustment. o Select Manufacturing of Exempt Goods for Additional Details. 3. Debit the purchase ledger. 4. Credit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 5. Press Ctrl+A to save. |
||
|
iv. any of the contingencies covered under sub-section (2), (3) & (5) & 6 of Section 9 |
Displays the credit value entered for VAT ledger in journal voucher to reverse the tax credit on contingencies. To reverse tax credit on contingencies 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Reversal of Input Tax as the Nature of Adjustment. o Select Contingencies Covered U/S 9 Sub Sec 2, 3, 5 & 6 for Additional Details. 3. Debit the purchase ledger. 4. Credit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 5. Press Ctrl+A to save. |
||
|
v. Others |
Displays the credit value entered for VAT ledger in journal voucher to reverse the tax credit on any other transactions. To reverse tax credit on any other transactions 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Reversal of Input Tax as the Nature of Adjustment. o Select Others for Additional Details. 3. Debit the purchase ledger. 4. Credit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 5. Press Ctrl+A to save. |
||
|
Total Reduction (7.c.(i) to 7.c(v)) |
Displays auto calculated value. |
||
|
8. Total Input Tax Credit (7(a) & 7(b)--7(c)) |
Displays auto calculated value. |
||
|
9. Amount of tax payable |
Displays auto calculated value. |
||
|
Amount of tax refundable |
Displays the credit value entered for VAT ledger in journal voucher to account for VAT refund. To account for VAT refund 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Refund of Input Tax as the Nature of Adjustment. 3. Debit the ledger grouped under Current Assets. 4. Credit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 5. Press Ctrl+A to save. |
||
|
Amount of tax carried forward |
Displays auto calculated value. |
||
|
10. Outstanding Liability to be set off against excess ITC, if any, under |
|||
|
i. Goa VAT Act |
Displays the credit value entered for VAT ledger in journal voucher to account for VAT liability. To account for VAT liability 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Decrease of Input Tax as the Nature of Adjustment. o Select Set Off Against Excess ITC Under Goa VAT Act for Additional Details. 3. Debit the expense ledger. 4. Credit the input VAT ledger. 5. Enter the tax Rate and Assessable Value in VAT Details screen. 6. Press Ctrl+A to accept. |
||
|
ii. Goa Sales Tax Act |
Displays the credit value entered for VAT ledger in journal voucher to account for sales tax liability. To account for sales tax liability 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Decrease of Input Tax as the Nature of Adjustment. o Select Set Off Against Excess ITC Under Goa Sales Tax Act for Additional Details. 3. Debit the expense ledger. 4. Credit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 5. Press Ctrl+A to save. |
||
|
iii. Goa Tax on Entry of Goods Act |
Displays the credit value entered for VAT ledger in journal voucher to account for entry tax. To account for entry tax 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Decrease of Input Tax as the Nature of Adjustment. o Select Set Off Against Excess ITC Under Goa Tax on Entry of Goods Act for Additional Details. 3. Debit the expense ledger. 4. Credit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 5. Press Ctrl+A to save. |
||
|
iv. Central Sales Tax Act |
Displays the credit value entered for VAT ledger in journal voucher to account for CST dues. To account for CST dues 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Decrease of Input Tax as the Nature of Adjustment. o Select Against CST for Additional Details. 3. Debit the CST ledger. 4. Credit the input VAT ledger. Enter the tax Rate and Assessable Value in VAT Details screen. 5. Press Ctrl+A to save. |
||
|
Total |
Displays auto calculated value. |
||
|
11. Net amount of tax refundable/carried forward |
Displays auto calculated value. |
||
|
12. No and date of receipted Challans under which payments are made and TDS Certificates attached to this return in proof of payment |
|||
|
Challan No., Challan Date, Period From and Period To, Amount |
Displays the challan details entered in Stat Payment Details screen, for each tax payment voucher in Tax Payment Reconciliation screen. |
||
|
B. No. and date of TDS Certificates ( Form VAT VII) |
This field is left blank. |
||
Last updated for Release 5.5.3
'Exporting e-VAT Form VAT III (Goa)' has been shared with
