You need to export the Form 16 to Excel in order to upload it on the department portal.
To export data to VAT-16 template
1. Copy the excel template to the Tally.ERP 9 installed folder.
2. Go to Gateway of Tally > Display > Statutory Reports > VAT > VAT Form 16.
3. Press Ctrl+E to view the Export Report screen.
4. Press Backspace to provide the relevant details.
5. Enter the remarks in the field VAT Form 16 Remarks. Based on the data being exported, the number of rows to be added in the template is displayed in Box 8 and 10.
o Open the template, and add the rows for box 8 and 10.
o Save the template and close.
6. Press Enter to export the data to template.
The description of VAT-16 is given below:
Field Name |
Description |
||||||||||||||||||
1. Period (Month)* |
Period appears in the format shown below:
As VAT-15 has to be filed every quarter, VAT-16 need not be filed for June, September, December and March. Note: If Form 16 report period is set to last month of the quarter, values will not be exported to VAT-16 template. |
||||||||||||||||||
Year* |
Displays the year based on the Form 16 report period. |
||||||||||||||||||
1.1 Name of the person* |
Displays the Mailing Name entered in the Company Creation screen. |
||||||||||||||||||
1.2 Address of the person* |
Displays the Address entered in the Company Creation screen. |
||||||||||||||||||
1.3 E-mail Id* |
Displays the E-mail entered in the Company Creation screen. |
||||||||||||||||||
1.4 Telephone No* |
Displays the Telephone no. entered in the Company Creation screen. |
||||||||||||||||||
1.5 TIN* |
Displays the TIN entered in 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. |
||||||||||||||||||
2. Details of Taxable Purchases |
|||||||||||||||||||
Value of Imports |
Displays the net assessable value of purchases with Imports selected as the nature of transaction. |
||||||||||||||||||
Value of Interstate purchases |
Displays the net assessable value of interstate purchases. Displays the net assessable value of purchases recorded with the following nature of transactions: ● Interstate Purchase - E1 ● Interstate Purchase Exempt - E1 ● Interstate Purchase - E2 ● Interstate Purchase - Against Form C ● Interstate Purchase - Taxable ● Interstate Purchase - Zero Rated ● Interstate Purchase High Seas ● Interstate Purchase - Tax Free ● Interstate Purchase - Works contract ● Interstate Purchase Deemed Export ● Interstate Purchase Exempt ● Interstate Purchase Exempt - With Form C |
||||||||||||||||||
Value of intra State Purchases |
|||||||||||||||||||
Purchases u/s 19 |
Displays the net assessable value of purchases with Purchases - Schedule H Items (u/s 19(1)) selected as the nature of transaction. |
||||||||||||||||||
Purchases u/s 20 |
Displays the net assessable value of purchases with Purchase From Unregistered Dealer selected as the nature of transaction. |
||||||||||||||||||
Purchases from Exempted units |
Displays the net assessable value of purchases with the following nature of transaction: ● Purchase Exempt ● Purchase Exempt - Capital Goods (when ledger is grouped under Fixed Assets) ● Non Creditable Purchase - Special Goods (when Party Entity/Org. Type is set to Exempted Unit or in party master the Type of Exemption is set to Exempted Unit). |
||||||||||||||||||
From Taxable Persons |
Displays the net assessable value of purchases made from taxable persons with the following nature of transactions: In VAT Details screen of party ledger, the Type of Dealer must be set to Taxable Person. ● Purchase Taxable ● Purchase - Works contract ● Purchase Taxable - Capital Goods In the VAT Details screen of party ledger, the Type of Exemption can be set to any option other than Exempted Unit. ● Non Creditable Purchase - Special Goods (when Party Entity/Org. Type is set to Not Applicable). |
||||||||||||||||||
From Non Taxable Persons |
Displays the net assessable value of purchases made from other than taxable persons with the following nature of transactions: In VAT Details screen of party ledger, the Type of Dealer must be set to any dealer type other than Taxable Person. ● Purchase Taxable ● Purchase - Works contract ● Purchase Taxable - Capital Goods In the VAT Details screen of party ledger, the Type of Exemption can be set to any option other than Exempted Unit. ● Non Creditable Purchase - Special Goods (when Party Entity/Org. Type is set to Retail). |
||||||||||||||||||
VAT on Purchases |
|||||||||||||||||||
Actual ITC |
Displays the net assessable value of purchases made with the following nature of transactions: ● Purchase Taxable ● Purchase - Works contract ● Purchase Taxable - Capital Goods In the VAT Details screen of party ledger, the Type of Exemption can be set to any option other than Exempted Unit. |
||||||||||||||||||
Notional ITC |
Displays the debit value entered for notional tax credit in journal voucher. To account for notional tax credit 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment to view the Stat Adjustment Details screen and set the options as given below: o Select Type of duty/tax as VAT. o Select the Increasing Notional Input Tax, as the Nature of adjustment. 3. Debit the notional tax ledger. Enter the tax Rate and Assessable Value. Note: Group the notional tax ledger under Duties & Taxes. Select the Type of duty/tax set to VAT, and set the option Use for Notional ITC to Yes. 4. Credit the expense ledger. 5. Press Ctrl+A to accept. |
||||||||||||||||||
ITC b/f |
Displays: ● Tax credit of previous period only if, Form 16 report with excess tax credit in the previous period, was saved. ● Opening balances of VAT, additional tax and notional tax ledgers, if the Form 16 report with excess tax credit in the previous period, was not saved. |
||||||||||||||||||
3. Details of Taxable Sales |
|||||||||||||||||||
Value of Exports out of India |
Displays the net assessable value of sales with Deemed Export or Exports selected as the nature of transaction. |
||||||||||||||||||
Value of inter state sales |
Displays the net assessable value of sales made with the following nature of transactions: ● Interstate Sales - Works contract ● Interstate Sales - Against Form C ● Interstate Sales - Taxable ● Interstate Sales Exempt - With Form C |
||||||||||||||||||
Value of intra state sales |
|||||||||||||||||||
To Taxable Persons |
Displays the net assessable value of sales made to taxable persons with Sales - Works contract or Sales Taxable selected as the nature of transaction. In VAT Details screen of party ledger, the Type of Dealer must be set to Taxable Person. |
||||||||||||||||||
To Non Taxable Persons |
Displays the net assessable value of sales made to other than taxable persons with Sales - Works contract or Sales Taxable selected as the nature of transaction. In VAT Details screen of party ledger, the Type of Dealer must be set to dealer type, other than Taxable Person. |
||||||||||||||||||
VAT on Sales (Output Tax) |
Displays the net output VAT of sales with Sales - Works contract or Sales Taxable selected as the nature of transaction. |
||||||||||||||||||
4. Details of Tax Payable |
|||||||||||||||||||
Output Tax |
Displays auto calculated value. |
||||||||||||||||||
ITC (during the month and b/f) |
Displays auto calculated value. |
||||||||||||||||||
Net Tax Payable/Excess ITC |
Displays auto calculated value. |
||||||||||||||||||
5. Details of Tax Paid |
|||||||||||||||||||
a. Advance tax in cash at ICCs during the month |
Displays the debit value entered for advance tax in journal voucher. To account for advance tax paid 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment to view the Stat Adjustment Details screen, and set the options as given below: o Select Type of duty/tax as VAT. o Select the Reducing Tax Liability, as the Nature of adjustment. o Select Advance Tax Paid in Additional Details section. 3. Debit the VAT ledger. Enter the tax Rate, Surcharge Rate and Assessable Value. 4. Debit the surcharge ledger. Enter the tax Rate, Surcharge Rate and Assessable Value. 5. Credit the ledger grouped under Current Assets. 6. Press Ctrl+A to accept. |
||||||||||||||||||
b. Advance tax that has been deducted during return period from lumpsum advance tax deposited by you in HDFC A/c for the clearance of vehicles at ICCs ( This figure has been made available in your login for your convenience). |
Displays the debit value entered for advance tax deduction in journal voucher. To account for advance tax deducted 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment to view the Stat Adjustment Details screen, and set the options as given below: o Select Type of duty/tax as VAT. o Select the Reducing Tax Liability, as the Nature of adjustment. o Select Advance Tax Deducted in Additional Details section. 3. Debit the VAT ledger. Enter the tax Rate, Surcharge Rate and Assessable Value. 4. Debit the surcharge ledger. Enter the tax Rate, Surcharge Rate and Assessable Value. 5. Credit the ledger grouped under Current Assets. 6. Press Ctrl+A to accept. |
||||||||||||||||||
c. TDS (if any) |
Displays the debit value entered for VAT and additional tax in journal voucher. To account for TDS adjustment 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment to view the Stat Adjustment Details screen, and set the options as given below: o Select Type of duty/tax as VAT. o Select the Decrease of Output Tax, as the Nature of adjustment. o Select TDS Adjustments in Additional Details section. 3. Debit the VAT and additional tax ledgers. Enter the tax Rate and Assessable Value. 4. Credit the ledger grouped under Current Assets. 5. Press Ctrl+A to accept. |
||||||||||||||||||
d. Tax deposited in Treasury |
Displays the VAT and additional tax amount entered in tax payment voucher. For additional tax ledger, select Surcharge as the Payment Type. |
||||||||||||||||||
e. Total Tax Paid (a+b+c+d) |
Displays auto calculated value. |
||||||||||||||||||
6. Bifurcation of Tax Paid |
|||||||||||||||||||
6.1 89% of VAT payable excluding surcharge under head 0040 in Challan VAT-2 (Fig in Col 5d *100/110*89%) |
Displays auto calculated value. |
||||||||||||||||||
6.2 80% of Surcharge payable under head 0040 in Challan VAT-2 (Fig in Col 5d *10/110*80%) |
Displays auto calculated value. |
||||||||||||||||||
6.3 11% of VAT payable excluding surcharge payable under Punjab Municipal Fund in VAT 2-A (Fig in Col 5d *100/110*11%) |
Displays auto calculated value. |
||||||||||||||||||
6.4 20% of Surcharge payable under PMIDF in VAT-2B (Fig in Col 5d *10/110*20%) |
Displays auto calculated value. |
||||||||||||||||||
7. Details of Tax Deposited in Treasury |
|||||||||||||||||||
Mode of Payment (dropdown values- cash/cheque or DD/e-payment) |
Displays: ● Cash if cash ledger is selected in the tax payment voucher. ● Cheque/DD or E-Payment, based on the Transaction Type selected in Bank Allocations screen of tax payment voucher. |
||||||||||||||||||
Instrument No |
Displays the Instrument No. entered for the payment voucher in the Stat Payment Details screen of Tax Payment Reconciliation screen. |
||||||||||||||||||
CIN No./BIN |
Displays the Challan No./BIN entered for the payment voucher in the Stat Payment Details screen of Tax Payment Reconciliation screen. |
||||||||||||||||||
Date (dd/mm/yyyy) |
Displays the Deposit Date entered for the payment voucher in the Stat Payment Details screen of Tax Payment Reconciliation screen. |
||||||||||||||||||
Bank/Treasury Name |
Displays the Name of the Bank entered for the payment voucher in the Stat Payment Details screen of Tax Payment Reconciliation screen. |
||||||||||||||||||
VAT Amount |
Displays the total amount of VAT and additional tax entered in tax payment voucher. |
||||||||||||||||||
PMF Amount |
Displays auto calculated value. |
||||||||||||||||||
PMIDF Amount |
Displays auto calculated value. |
||||||||||||||||||
Total Amount |
Displays auto calculated value. |
||||||||||||||||||
8. Breakup of Intra State Taxable Sale and Purchases |
|||||||||||||||||||
Sales |
|||||||||||||||||||
Rate of Tax (A) |
Displays tax rates. |
||||||||||||||||||
Value of Sales (B) |
Displays net assessable value of sales attracting tax rates provided in Rate of Tax (A) column, recorded with the following nature of transactions: ● Sales - Works contract ● Sales Taxable |
||||||||||||||||||
Others |
Displays net assessable value of sales attracting tax rates other than the rates mentioned in Rate of Tax (A) column, recorded with the following nature of transactions: ● Sales - Works contract ● Sales Taxable |
||||||||||||||||||
VAT (including surcharge) (C= B*(A+10% of A)) |
Displays auto calculated value. |
||||||||||||||||||
Declared goods @ 4.5% (without surcharge) |
Displays the net assessable value of sale of declared goods attracting 4.5% tax rate, recorded with the following nature of transactions: In VAT Details screen of stock item, ● The Type of goods is set to Declared Goods. ● The Tax rate is entered as 4.5%. ● Sales - Works contract ● Sales Taxable |
||||||||||||||||||
Declared goods @ 5% (without surcharge) |
Displays the net assessable value of sale of declared goods attracting 5% tax rate, recorded with the following nature of transactions: In VAT Details screen of stock item, ● The Type of goods is set to Declared Goods. ● The Tax rate is entered as 5%. ● Sales - Works contract ● Sales Taxable |
||||||||||||||||||
Other declared goods (without surcharge) |
Displays the net assessable value of sale of declared goods attracting tax rates other than 4.5% and 5%, recorded with the following nature of transactions: In VAT Details screen of stock item, ● The Type of goods is set to Declared Goods. ● The Tax rate entered is other than 4.5% or 5%. ● Sales - Works contract ● Sales Taxable |
||||||||||||||||||
Total |
Displays auto calculated value. |
||||||||||||||||||
Excess Due To Rounding Off |
This field is currently left blank. |
||||||||||||||||||
Purchases |
|||||||||||||||||||
Rate of Tax (D) |
Displays tax rates. |
||||||||||||||||||
Value of Purchases (E) |
Displays net assessable value of purchases attracting tax rates provided in Rate of Tax (D) column, recorded with the following nature of transactions: ● Purchase Taxable ● Purchase - Works contract ● Purchase Taxable - Capital Goods In the VAT Details screen of party ledger, the Type of Exemption can be set to any option other than Exempted Unit. |
||||||||||||||||||
Others |
Displays net assessable value of purchases attracting tax rates other than the rates mentioned in Rate of Tax (D) column, recorded with the following nature of transactions: ● Purchase Taxable ● Purchase - Works contract ● Purchase Taxable - Capital Goods In the VAT Details screen of party ledger, the Type of Exemption can be set to any option other than Exempted Unit. |
||||||||||||||||||
VAT (including surcharge) (F= E*(D+10% of D)) |
Displays auto calculated value. |
||||||||||||||||||
Declared goods @ 4.5% (without surcharge) |
Displays the net assessable value of purchase of declared goods attracting 4.5% tax rate, recorded with the following nature of transactions: In VAT Details screen of stock item, ● The Type of goods is set to Declared Goods. ● The Tax rate is entered as 4.5%. ● Purchase Taxable ● Purchase - Works contract ● Purchase Taxable - Capital Goods In the VAT Details screen of party ledger, the Type of Exemption can be set to any option other than Exempted Unit. |
||||||||||||||||||
Declared goods @ 5% (without surcharge) |
Displays the net assessable value of purchases of declared goods attracting 5% tax rate, recorded with the following nature of transactions: In VAT Details screen of stock item, ● The Type of goods is set to Declared Goods. ● The Tax rate is entered as 5%. ● Purchase Taxable ● Purchase - Works contract ● Purchase Taxable - Capital Goods In the VAT Details screen of party ledger, the Type of Exemption can be set to any option other than Exempted Unit. |
||||||||||||||||||
Other declared goods (without surcharge) |
Displays the net assessable value of purchase of declared goods attracting tax rates other than 4.5% and 5%, recorded with the following nature of transactions: In VAT Details screen of stock item, ● The Type of goods is set to Declared Goods. ● The Tax rate entered is other than 4.5% or 5%. ● Purchase Taxable ● Purchase - Works contract ● Purchase Taxable - Capital Goods In the VAT Details screen of party ledger, the Type of Exemption can be set to any option other than Exempted Unit. |
||||||||||||||||||
Total |
Displays auto calculated value. |
||||||||||||||||||
Excess Due To Rounding Off |
This field is currently left blank. |
||||||||||||||||||
9. Value of Branch Transfer |
Displays the net assessable value of purchases recorded with the following nature of transactions: ● Interstate Branch Transfer Outward ● Interstate Consignment Transfer Outward |
||||||||||||||||||
10. Rate wise Details of Taxable Inter State Sales |
|||||||||||||||||||
Rate of Tax |
Displays the rate of tax charged in sale invoice recorded with the following nature of transactions: ● Interstate Sales - Works contract ● Interstate Sales - Against Form C ● Interstate Sales - Taxable ● Interstate Sales Exempt - With Form C |
||||||||||||||||||
Amount |
Displays the net assessable value of sales (corresponding to the tax displayed in Rate of Tax column) recorded with the following nature of transactions: ● Interstate Sales - Works contract ● Interstate Sales - Against Form C ● Interstate Sales - Taxable ● Interstate Sales Exempt - With Form C |
||||||||||||||||||
CST |
Displays the CST charged on sales (corresponding to the tax displayed in Rate of Tax column) recorded with the following nature of transactions: ● Interstate Sales - Works contract ● Interstate Sales - Against Form C ● Interstate Sales - Taxable ● Interstate Sales Exempt - With Form C |
||||||||||||||||||
11. CST Payable |
Displays the amount of CST payable displayed in Form 16 report. |
||||||||||||||||||
Remarks |
Displays the Remarks entered in Export Report screen of Form 16 report. |
||||||||||||||||||
'Exporting Data to e- VAT Form 16 (Punjab)' has been shared with
