Enhanced Reporting Excel Tool
This macro-enabled Excel template automatically generates an enhanced reporting compatible file (pipe-delimited .txt file) for uploading to Retirement Online. It can be used for hiring and enrolling, regular reporting, and submitting adjustments.
Please do not use this tool until you have completed your transition to enhanced reporting and are Gold Certified.
Who this tool is for
Employers who manually report and need to hire in retirees or large numbers of optional employees.
Employers who upload a file in Retirement Online and:
- Used a template (such as a .prn or Excel file) to generate their file in legacy reporting.
- Do not use a third-party payroll provider.
- Are not supported by a CPA firm.
- Do not have an in-house IT department or software to generate their enhanced file.
What you can do with this tool
- Hire new employees and retirees.
- Enroll new mandatory members.
- Submit job data changes.
- Submit a regular or adjustment report.
The Excel Tool & Guides
- Enhanced Reporting Excel Tool
Note: To ensure the tool works correctly, you must download the file and open it in Excel.
Do not attempt to use the file in a web browser. - Enhanced Reporting Excel Tool Guide
- Enhanced Reporting Excel Tool Instructions for Transactions 1 & 2
- Enhanced Reporting Excel Tool Instructions for Transactions 3 & 4
- File Format Guides:
- File Format Guide for Transactions 1, 2, 3 & 4
- File Format Guide for Transaction 5 (Retroactive Earnings)
- Errors and Warnings:
If You Need Help
If you have questions about your enhanced report or for help using the Enhanced Reporting Excel Tool, use our help desk form (select Enhanced Reporting/Gold Certification from the dropdown).
You can also call 866-805-0990 (press 1 to access the employer menu, then follow the prompts).