Annexure-16 displays the values of journal voucher recorded for reversal of TDS.
To add the required number of rows to the template for exporting data
1. Copy the excel template Offline_Return_version_1.5 to the Tally.ERP 9 installation folder.
2. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT III .
3. Press Ctrl+E to view the Export Report screen. Based on the Form VAT III report period, the quarter for which the return is being filed is displayed.
4. Select the Type of Return as Original or Revised . The type of return selected here gets considered for all annexures.
5. Set the option Show number of rows to add to Yes and press Enter to view the Form VAT III Excel Template Validations screen.
o Add the number of rows, as shown in this screen, for Annexure 16, to capture the details in the template while exporting data.
o Press Ctrl+A to accept.
6. Press Enter to export data to the template. The relevant details are captured in Annexure 16 sheet of the template.
To export data to Annexure 16 sheet of the template
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT III .
2. Click A : Annexures .
3. Select Annexure-16 and press Enter .
4. Click E : Export to view the Export Report screen. Based on the Form VAT III report period, the From and To dates are displayed here. These dates can be changed from the e-VAT Annexures report, if required. Ensure that the required number of rows are added to the template before exporting data.
5. Press Enter to export data.
The description of the fields in Annexure 16 is given below:
Field |
Description |
Sl. No. |
Displays the serial number of transactions. |
Name and Address of the Employer or Person who Deducted the Tax |
Displays the Name of the Dealer entered in the Statutory Details screen of journal voucher (displayed on enabling the option Provide VAT Details ). |
TIN of the Dealer from Whom TDS Deducted |
Displays the TIN of Dealer entered in the Statutory Details screen of journal voucher (displayed on enabling the option Provide VAT Details ). |
Amount of Payment on Which TDS Deducted |
Displays the Value on which TDS deducted entered in the Statutory Details screen of journal voucher (displayed on enabling the option Provide VAT Details ). |
Date of Payment |
Displays the Date of Payment entered in the Statutory Details screen of journal voucher (displayed on enabling the option Provide VAT Details ). |
Amount of TDS |
Displays the debit value of VAT ledger entered in journal voucher recorded for TDS adjustments. To account for TDS adjustment 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal . 2. Click J : Stat Adjustment . In the VAT Details screen, o Select VAT as the Type of duty/tax . o Select Reducing Tax Liability as the Nature of Adjustment . o Select TDS Adjustment for Additional Details . 3. Debit the output VAT ledger. Enter the relevant information in VAT Details screen. 4. Credit the expense ledger. 5. Press Ctrl+A to save. |
Challan Number |
Displays the Challan No. entered in the Statutory Details screen of journal voucher (displayed on enabling the option Provide VAT Details ). |
Challan Date on which TDS Deposited |
Displays the Challan Date entered in the Statutory Details screen of journal voucher (displayed on enabling the option Provide VAT Details ). |
Total Amount of the Challan |
Displays the Total Challan Amount entered in the Statutory Details screen of journal voucher (displayed on enabling the option Provide VAT Details ). |
'e-VAT Annexure-16 (Uttarakhand)' has been shared with