This utility application is designed to assist users in merging TDS GL data with their Revenue Register records, converting 26AS text files to Excel format, and facilitating the reconciliation of financial records. To ensure the application functions correctly, it is crucial that all input files adhere to the specified formats.
Revenue Register Format The Revenue Register file should be an Excel (.xlsx) file with the following column headers:
- Invoice No. - Text
- Cust Code - Text
- Customer Name - Text
- SAP Doc No - Text
- TDS/TCS - Number
Please ensure all above numeric fields are formatted as numbers. above fields are required by the tool for matching process. The blank template could be downloaded in Section 1 of the tool.
The SAP Exported TDS GL File should also be in Excel (.xlsx) format, containing relevant transaction data.
The 26AS file must be uploaded in text (.txt) format as downloaded from the government portal.
- Download the blank Revenue Register template from the application.
- Fill in your Revenue Register data according to the specified format.
- Upload your filled Revenue Register and the SAP Exported TDS GL File in the application.
- Follow on-screen instructions for each section to process your files.
- For 26AS to Excel conversion, upload the 26AS text file directly without alteration.
- Processed TDS GL Excel File: This file is generated by the application in Section 1. It should not be modified externally to ensure data integrity during reconciliation.
- 26AS Excel File: Generated in Section 2 from the uploaded text file. Ensure the file remains unaltered to maintain data accuracy.
- Upload Files: Begin by uploading the Processed TDS GL Excel file and the 26AS Excel file using the designated file uploaders.
- Initiate Matching: Once both files are uploaded, click the 'Match Records' button to start the reconciliation process. The application will attempt to match records based on deductor details and transaction amounts, considering a predefined tolerance level for discrepancies.
- Review Matched Records: After the matching process completes, the application will display matched and unmatched records. Review these records to identify any discrepancies or mismatches.
- Download Matched Data: For further analysis or record-keeping, you can download the matched data as an Excel file directly from the application.
- Verify the accuracy of all data in your original TDS GL and 26AS files before uploading them for reconciliation.
- Pay close attention to the reconciliation summary and matched records for any anomalies or unexpected mismatches.
- Use the downloaded matched data for detailed analysis and to make any necessary adjustments in your financial records.
Ensure all files are free from formatting errors before uploading.
The application provides detailed instructions for each utility. Refer to these instructions for specific requirements and steps. Support
For support or further assistance, please contact shubham.shinde@jsw.in