How to transfer employee contact information into the ACA Excel spreadsheets
Description
Cause
Resolution
[BCB:1:Backup warning:ECB]


[BCB:5:Third-party support:ECB]

  1. In Sage 50, click File and choose Select Import/Export.
  2. Highlight Payroll in the left pane.
  3. Select Employee List in the right pane.
  4. Click the Export button.
  5. In the Employee List window, click the Fields tab.
  6. Click the Show None button to deselect all fields.
  7. Check the Show box for Employee First Name, Employee Last Name, Address-Line One, Address-Line Two, City, State, Zip, Employee Social Security # and Employee E-mail.
  8. Click the Options tab.
  9. Under the Import/Export File heading make note of the directory where it saves the exported file.
  10. Under Export Options, click the Include Headings box.
  11. Click Save.
  12. When the Save As window opens, change the current Template Name.
  13. Click Save.
  14. Click OK to export.
  15. Browse to the directory where it saved the exported file.
  16. Open the file and copy and paste the employee information into the appropriate columns in the ACA spreadsheet.
    • If you have trouble copying and pasting, delete the two gray sample rows and try copying again

To obtain a copy of the ACA spreadsheet, see Can I complete the 1094/1095 ACA (Affordable Care Act) forms in the program?

[BCB:161:Chat 50 US:ECB]
Steps to duplicate
Related Solutions