Congratulations on your retirement, Smith.
 

Your idea of compiling your previous employee's W-2 in Excel is an excellent choice. I'll discuss more information regarding this below.
 

To achieve your goal, you'll have to ensure the accuracy of the employees' W-2s details and amounts for the boxes. Then, manually enter and gather those entries in Excel. After that, purchase a blank W-2 form and input the required details to fulfill it using the data you've generated in Excel.

You can coordinate with your previous worker to secure correct information such as their full name, address, and Social Security number. Then, submit the form manually to the IRS.
 

Moreover, you can contact the IRS directly if you have more questions about handling W-2s for your closed business. They can provide further assistance or insights regarding this matter.
 

Additionally, I'm adding this article that can supply you with the complete rules and regulations of the IRS for W-2 filings: Understand the IRS regulations for filing 1099s and W-2s.

Should you have further queries about managing your W-2s, hit the Reply button so we can help you out. Take care and enjoy your retirement.