| How can I transfer employee contact information from Sage 50 into the Aatrix ACA Excel spreadsheets? |
Resolution | [BCB:1:Backup warning:ECB] [BCB:5:Third-party support:ECB]
- In Sage 50 click File and choose Select Import/Export.
- Highlight Payroll in the left pane.
- Select Employee List in the right pane.
- Click the Export button
- In the Employee List window click the Fields tab.
- Click the Show None button to deselect all fields.
- 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.
- Click the Options tab
- Under the Import/Export File heading make note of the directory where the exported file will be saved.
- Under Export Options click the Include Headings box.
- Click Save.
- When the Save As window opens, change the current Template Name.
- Click Save.
- Click OK to export.
- Browse to the directory where file was exported.
- 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] |
|