Step 1:-
- Open the E-TDS-XL template.
- Enabled Macro: Go to the security warning bar at the top of the Excel sheet and click "Enable Content" to run the macros.
- Click on"I agree".
- Click to 'Start'.
Step 2:-
- Select form type, financial year, quarter, and return type
- Click on "Create data entry sheets".
Step 3:-
Fill in the specified sheet, or use the copy and paste option.
- Deductors details:- "Deductor details" typically refer to information about the entity or person who deducts tax at source, commonly known as TDS (Tax Deducted at Source) or TCS (Tax Collected at Source).
- Deductee details:-"Deductee" refers to the person or entity from whom tax is deducted at source (TDS).
- Challan details:- A challan is a form or a document that is used to make a payment, often to a government agency. In the context of tax payments in India, a challan is used to deposit various types of taxes, including income tax, corporate tax, and other direct taxes.
Step 4:-
- Go to the Instructions sheet & click to 'start'.
- "Right-click" anywhere in the sheet.
- Click on 'Verify & Export to ETDs format' in the pop-up menu. Verifying data in Excel is a crucial step in ensuring accuracy and integrity in your database.
Step 8:-
- Asked do you want to run validation before exporting.
- Click on ‘Yes’
Step 9:-
- Verification finished
- Asked if you wish to export.
- Click on ‘Yes’
Step 10:-
- Finished exporting
- Asked if you wish to validate using FVU stands for "File Validation Utility."
- Click on ‘Yes’
Step 11:-
- Asked whether you have downloaded the CSI (Challan Status Enquiry) file from the ITD portal if you haven't downloaded CSI (Challan Status Enquiry) click on 'Cancel'. Your cursor will automatically move to the ID Portal. From where you have to download the CSI (Challan Status Enquiry) file.
- Click on 'Ok' and browse the CSI (Challan Status Enquiry) file. (This file contains details about the challans such as the Challan Identification Number (CIN), amount, date of deposit, and bank branch where the tax was deposited.)
Step 12:-
Select CSI file and >> Click to 'Open'.
Step 13:-
Click on ‘OK’ for the error message in FVU validation.
Step 14:-
- Go to the error sheet
- Go to column number 'C'
- Single-click on the row number as per your error file. When you click on the row number your cursor will automatically move to the error row.
Step 15:-
As you click on the row number, the cursor will automatically move to the highlighted challan record number in the deductee sheet.
Step 16:-
Go to Column number 'J' >> Enter the correct amount of total income tax deducted as per Column number 'N' (the rate at which tax was deducted/collected).
Step 17:-
- Go to the Instructions sheet & click to 'start'.
- "Right-click" anywhere in the sheet.
- Click on 'Verify & Export to ETDs format' in the pop-up menu. Verifying data in Excel is a crucial step in ensuring accuracy and integrity in your database.
Step 18:-
Verify and Export to ETDS-ZIP Template.
Step 19:-
Asked whether you have downloaded the CSI file from ITD portal >> Click on 'Ok' and browse the CSI file.
Step 20:-
- Select CSI file and
- Click to 'Open'.
Step 21:-
Click on ‘OK’, 27A and FVU file generated and saved on the given path.
Step 22:-
Now will get the FVU and 27A files. Need to submit the files on the Income tax e-filing portal or the nearest TIN-FC Center.
Comments
0 comments
Please sign in to leave a comment.