How can I transfer employee contact information from Sage 50 into the Aatrix 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 the exported file will be saved.
  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 file was exported.
  16. Open the file and copy and paste the employee information into the appropriate columns in the ACA spreadsheet.

Note: To obtain a copy of the ACA spreadsheet, see Article ID 71466: DocLink: Can I complete the 1094/1095 ACA (Affordable Care Act) forms in the program?.


[BCB:161:Chat 50 US:ECB]
Defect ID
Steps to duplicate
Related Articles