Office of the New York State Comptroller’s Seal

NYS Comptroller

Thomas P. DiNapoli

Retirement Online

Online Availability:

Mon, Wed & Fri: 7:00 am to 10:00 pm EST/EDT

Tue & Thu: 7:00 am to 6:00 pm EST/EDT

Sat & Sun: 6:00 am to 11:00 pm EST/EDT

Sign In

Enhanced Reporting Excel Tool

Enhanced Reporting Excel ToolThis macro-enabled Excel template automatically generates an enhanced reporting compatible file (pipe-delimited txt file) for uploading to Retirement Online. It may 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 used a template (such as a prn file) for legacy reporting.
  • Manual reporters who need to hire in retirees or large numbers of optional employees.
  • Employers without a third-party payroll provider or in-house IT department that generate all or part of their enhanced file.

What you can do with this tool

  • Hire new employees and retirees.
  • Enroll new members.
  • Submit job data changes.
  • Submit a regular report and/or adjustments for locations that don’t have software that automatically generates the file.
  • Submit a regular report and/or adjustments locations that do not wish to manually report all employees.

↑ Return to Top

The Excel Tool & Instructions

↑ Return to Top

Contact Us

Call your transition coach: 844-619-9614 | Monday – Friday, 8:30 am – 4:00 pm

  • When prompted, choose option 1 to be connected to employer resources.
  • You will then be asked for your location code followed by the pound “#” sign.
  • After you enter this code, you will begin to hear our traditional options for employer related questions. At this point, you can dial your transition group code and be connected to a Gold Certification transition coach. This is a special code that was provided on your transition plan. It is not listed as an option on the Help Desk line.

Send an email: NYSLRSGoldCertification@osc.ny.gov