To export data to EVAT Withheld template,
Go to Gateway of Tally > Display > Statutory Reports > VAT > E-VAT Forms > E-VAT Return
The EVAT Withheld option will display the Export Report screen. Press Backspace to make changes export location, Output File Name etc.
Language: By default it is set to Restricted (ASCII)
Format: By default set to ASCII (Comma Delimited)
Export Location: By default Tally.ERP 9 folder path will be displayed. Enter the file location path to where the excel file to be exported.
Output File Name: By default the file name is displayed as VAT 3_Return_Online.xls.
Open Exported Folder: To open the folder to which the file is exported, set this option to Yes .
Type of Return: Select Original or Revised as per the type of return that needs to be exported to the template.
Entity Type: Select Branch or Head office depending on the Entity Type.
From and To Period: Enter the From and To date of the Tax period.
The Export Files screen will be displayed with list of Annexures. Select the option - All to export data to the respective annexures, else select the required annexures one by one.
Select End of List and press Enter.
A dialogue box appears with a message as shown. Click OK.
The dialogue box appears with the request to replace the file. Click Yes. The data gets exported to the respective worksheets of the template.
Navigate to the Export Location path and open the template - VAT 3_Return_Online.xls. The template with the exported data displays as shown:
For each annexure chosen for exporting data from Tally.ERP 9 to template - VAT 3_Return_Online.xls the .csv file will get generated. Follow the steps given below to import the .csv files and validate the data.
In A_Basic_Info worksheet, click NEXT button
In B_General_Rated_Sales_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - General_Rated_Sales and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.
In C_Other_Rated_Sales_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - Other_Rated_Sales and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.
In D_Zero_Rated_Sales_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data.
For Section D1, select the file - Zero_Rated_Sales_SecD1 and click Open button to import the data. The required number of rows will get automatically during the import process.
For Section D2, select the file - Zero_Rated_Sales_SecD2 and click Open button to import the data. The required number of rows will get automatically during the import process.
After data import, click NEXT button.
In E_Exempted_Sales_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - Exempted_Sales and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.
In F_General_Rated_Purchases_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - General_Rated_Purchases and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.
In G_Other_Rated_Purchases_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - Other_Rated_Purchases and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.
In H_Zero_Rated_Purchases_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - Zero_Rated_Purchases and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.
In I_Exempted_Purchases_Dtls worksheet, click IMPORT CSV button and navigate to the path provided in Export Location field for exporting data. Select the file - Exempted_Purchases and click Open button to import the data. The required number of rows will get automatically during the import process. After data import, click NEXT button.
In J_VAT_Imported_Services_Dtls worksheet, click NEXT button.
In K_VAT_Payment_Credits worksheet, click NEXT button.
In L_Sales_M_Purchases worksheet, click NEXT button.
In N_VAT_Due worksheet, click VALIDATE button.
The errors found while validating data will be captured in the second worksheet - Errors. Once the errors are corrected, click VALIDATE button in N_VAT_Due worksheet. Once the data gets successfully validated, the message appears as shown:
Click Yes. A dialogue box will be displayed with the path of the .zip file.
The PIN entered in the Company Operations Alteration screen of F11: Features > Statutory & Taxation features is captured here.
The Return Type selected in the Type of Return field of Export Report screen is captured here.
The Entity Type selected in the Entity Type field of Export Report screen is captured here.
The date entered in the From (blank for beginning) field of Export Report screen is captured here.
The date entered in the To (blank for end) field of Export Report screen is captured here.
The details of entries recorded using VAT/Tax class - Sales @ 16% is captured here.
The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Sales @ 16% is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.
The name of purchaser entered in the Buyers field of Party Details screen is captured here.
The Device No. entered for the device type - ETR, ESD or EFP in entries recorded using VAT/Tax class - Sales @ 16% is captured here.
The invoice date is captured here in dd/mm/yyyy format.
The invoice number is captured here.
The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Sales @ 16% is captured here.
The assessable value of entries recorded using VAT/Tax class - Sales @ 16% is captured here. The value of additional ledgers enabled to Use for Assessable Value Calculation is also captured here. If the invoice is recorded with exempt and taxable sales (of VAT/Tax class - Sales @ 16%) the assessable value of only the taxable sale is displayed here.
The original invoice number entered in the Original Invoice No. of Credit and Debit Note while recording returns and de-escalations is captured here.
The original invoice date entered in the Original Invoice Dt. field of Credit and Debit Note while recording returns and de-escalations is captured here.
The details of entries recorded using VAT/Tax class - Sales @ 12% is captured here.
The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Sales @ 12% is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.
The name of purchaser entered in the Buyers field of Party Details screen is captured here.
The Device No. entered for the device type - ETR, ESD or EFP in entries recorded using VAT/Tax class - Sales @ 12% is captured here.
The invoice date is captured here in dd/mm/yyyy format.
The invoice number is captured here.
The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Sales @ 12% is captured here.
The assessable value of entries recorded using VAT/Tax class - Sales @ 12% is captured here. The value of additional ledgers enabled to Use for Assessable Value Calculation is also captured here. If the invoice is recorded with exempt and taxable sales (of VAT/Tax class - Sales @ 12%) the assessable value of only the taxable sale is displayed here.
The original invoice number entered in the Original Invoice No. of Credit and Debit Note while recording returns and de-escalations is captured here.
The original invoice date entered in the Original Invoice Dt. field of Credit and Debit Note while recording returns and de-escalations is captured here.
For sales recorded using VAT/Tax class -
Sales - Zero Rated, the Type of Sale will be displayed as Local.
Sales to Diplomatic Missions & U.N. Etc., Sales - Zero Rated (Foreign Aid) and Sales - Zero Rated (Others), the Type of Sale will be displayed as Exemption.
The PIN defined in the Party Ledger master selected while recording the sales entries is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.
The name of purchaser entered in the Buyers field of Party Details screen is captured here.
The Device No. entered for the device type - ETR in entries recorded using VAT/Tax class - Sales - Zero Rated, Sales to Diplomatic Missions & U.N. Etc., Sales - Zero Rated (Foreign Aid) and Sales - Zero Rated (Others) is captured here.
The invoice date is captured here in dd/mm/yyyy format.
The invoice number is captured here.
The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Sales - Zero Rated, Sales to Diplomatic Missions & U.N. Etc., Sales - Zero Rated (Foreign Aid) and Sales - Zero Rated (Others) is captured here.
The information entered in the Exemption Certificate No. field of entries recorded using VAT/Tax class - Sales - Zero Rated, Sales to Diplomatic Missions & U.N. Etc., Sales - Zero Rated (Foreign Aid) and Sales - Zero Rated (Others) is captured here.
The assessable value of entries recorded using VAT/Tax class - Sales - Zero Rated, Sales to Diplomatic Missions & U.N. Etc., Sales - Zero Rated (Foreign Aid) and Sales - Zero Rated (Others) is captured here.
This field will be blank as PIN will not be provided in the purchaser (importer) ledger master.
The name of purchaser entered in the Buyers field of Party Details screen is captured here.
The Device No. entered for the device type - ETR in entries recorded using VAT/Tax class - Exports is captured here.
The invoice date is captured here in dd/mm/yyyy format.
The invoice number is captured here.
The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Exports is captured here.
The information entered in the Export Entry No. field of entries recorded using VAT/Tax class - Exports is captured here.
The information entered in the Port of Discharge field of Party Details screen for entries recorded using VAT/Tax class - Exports is captured here.
The information entered in the Country To field of Party Details screen for entries recorded using VAT/Tax class - Exports is captured here.
The assessable value of entries recorded using VAT/Tax class - Exports is captured here.
The details of entries recorded using VAT/Tax class - Sales - Exempt is captured here.
The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Sales - Exempt is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.
The name of purchaser entered in the Buyers field of Party Details screen is captured here.
The Device No. entered for the device type - ETR, ESD or EFP in entries recorded using VAT/Tax class - Sales - Exempt is captured here.
The invoice date is captured here in dd/mm/yyyy format.
The invoice number is captured here.
The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Sales - Exempt is captured here.
The assessable value of entries recorded using VAT/Tax class - Sales - Exempt is captured here.
For purchases recorded using VAT/Tax class -
Purchases @ 16%, the Type of Purchases will be displayed as Local.
Purchases - Imports @ 16%, the Type of Purchases will be displayed as Import.
The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Purchases @ 16% and Purchases - Imports @ 16% is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.
The name of supplier entered in the Supplier field of Party Details screen is captured here.
The invoice date is captured here in dd/mm/yyyy format.
The invoice number is captured here.
The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Purchases @ 16% and Purchases - Imports @ 16% is captured here.
The description entered in the Customs Entry No. field of entries recorded using VAT/Tax class - Purchases - Imports @ 16% is captured here.
The assessable value of entries recorded using VAT/Tax class - Purchases @ 16% and Purchases - Imports @ 16% is captured here.
The original invoice number entered in the Original Invoice No. of Debit and Credit note while recording returns and de-escalations is captured here.
The original invoice date entered in the Original Invoice Dt. field of Debit and Credit Note while recording returns and de-escalations is captured here.
The purchases recorded using VAT/Tax class - Purchases @ 12% is captured here with Type of Purchases as Local.
The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Purchases @ 12% is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.
The name of supplier entered in the Supplier field of Party Details screen is captured here.
The invoice date is captured here in dd/mm/yyyy format.
The invoice number is captured here.
The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Purchases @ 12% is captured here.
The assessable value of entries recorded using VAT/Tax class - Purchases @ 12% is captured here. The value of additional ledgers enabled to Use for Assessable Value Calculation is also captured here. If the invoice is recorded with exempt and taxable purchases (of VAT/Tax class - Purchases @ 12%) the assessable value of only the taxable purchase is displayed here.
The information entered in the Original Invoice No. of Debit while recording returns and de-escalations is captured here.
The information entered in the Original Invoice Dt. field of Debit Note while recording returns and de-escalations is captured here.
For purchases recorded using VAT/Tax class -
Purchases - Zero Rated, the Type of Purchases will be displayed as Local.
Imports, the Type of Purchases will be displayed as Import.
The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Purchases - Zero Rated is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.
The name of supplier entered in the Supplier field of Party Details screen is captured here.
The invoice date is captured here in dd/mm/yyyy format.
The invoice number is captured here.
The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Purchases - Zero Rated and Imports is captured here.
The description entered in the Customs Entry No. field of entries recorded using VAT/Tax class - Imports is captured here.
The assessable value of entries recorded using VAT/Tax class - Purchases - Zero Rated and Imports is captured here.
The details of purchases recorded using VAT/Tax class - Purchases - Exempt is captured here with Type of Purchases as Local.
The PIN defined in the Party Ledger master selected while recording entries using VAT/Tax class - Purchases - Exempt is captured here. In case of transactions where cash/bank ledger is used or PIN is not defined in the selected party master, the PIN Number entered in Party Details screen is captured here.
The name of supplier entered in the Supplier field of Party Details screen is captured here.
The invoice date is captured here in dd/mm/yyyy format.
The invoice number is captured here.
The description entered in the Brief Desc for VAT field of entries recorded using VAT/Tax class - Purchases - Exempt is captured here.
The assessable value of entries recorded using VAT/Tax class - Purchases - Exempt is captured here.
This Annexure will be blank.
This Annexure will be blank.
Based on the transactions recorded, the values will be automatically captured here.