Annexure-1C displays the list of local taxable purchase and purchase returns of fuel for which tax credit is claimed.
● In the invoice:
o The party selected must be predefined as Regular dealer in the party master, or the Nature of Transaction must be selected as Purchase Taxable.
o Tax rate must be defined in the accounting or inventory masters.
● In accounting or inventory masters, the Type of goods must be selected as Fuel.
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 1C, to capture the details in the template while exporting annexure data.
o Press Ctrl+A to accept.
6. Press Enter to export data to the template. The relevant details are captured in Annexure 1C sheet of the template.
To export data only to Annexure 1C sheet of the template
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT III.
2. Click A: Annexures.
3. Select Annexure-1C 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 1C is given below:
Field |
Description |
Sr. No. |
Displays the serial number of transactions. |
Date Of Invoice Issued By Regd. Selling Dealer |
Displays the supplier invoice Date entered in the purchase invoice. |
TIN Of Regd. Selling Dealer |
Displays the VAT TIN predefined for the party ledger or as entered in the Party Details screen of the invoice. |
Invoice No |
Displays the Supplier Invoice No. entered in the purchase invoice. |
Sale Value (before tax) |
Displays the assessable value of the stock items selected in the invoice. |
Rate of tax charged in percentage |
Displays the rate of tax charged for each stock item in the invoice. If the stock items selected in a single invoice attract: ● Different VAT rates, then each stock item appears in a separate row. ● Same rate, then the values are consolidated and displayed in a single row. |
Amount of tax charged |
Displays auto calculated value. |
Name of goods purchased |
Displays the Commodity name predefined for the stock item selected in the invoice. If the stock items selected in a single invoice are predefined with: ● Different commodities, then each stock item appears in a separate row. ● Same commodity, then the values are consolidated and displayed in a single row. |
'e-VAT Annexure-1C (Uttarakhand)' has been shared with