| How to transfer employee contact information into the 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 it saves the exported file.
- 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 it saved the exported file.
- Open the file and copy and paste the employee information into the appropriate columns in the ACA spreadsheet.
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] |
|