Workyard offers you the ability to export your time data for team members from Workyard to Sage 50. Making payroll a breeze!
How it works
If you want to use Workyard's integrations, the first step is to contact us to let us know that you would like to use the Sage 50 integration. Our team will configure your account to produce the appropriate file format to ensure a successful integration. After your account has been configured, you can proceed with the following steps to complete the process.
Exporting your Payroll File
Navigate to the Timecards
To begin the process, log in to your Workyard account and navigate to the Timecards page.
Click on Export
3. Select the Date range, Team members, and Integration
4. Click Start Export
Once you have completed all the required fields, click Start Export to begin the export process.
5. Export for Sage 50
A pop-up will appear asking if you'd like to proceed, then click 'Go to file export'
6. Workyard File Exporter
A new page called the Workyard File Exporter will open. From here, you'll be asked to enter a Target ID for any employees included in your export. The target ID represents the unique identifier ( Employee ID) from Sage 50 that you would like to map Workyard data to.
7. Save Changes
Click on the Save Changes once you have entered the Target IDs. Your Target IDs will be stored and used again on your next export.
8. Pay Item Codes
You can also enter the pay item codes from Sage 50 for regular, overtime, or double time. Entering payroll codes is optional.
9. Download File
Once you've completed all your mappings, click the Download File button in the top right-hand corner.
10. Edit previously Mapped Records
To edit any previously mapped records, click on the Mapped Records button. From here, you can access lists of employees you have previously mapped and make any edits.
11. Download file into your Sage 50 application
12. Go to Sage 50 Accounting
File -> Select Import/Export
13. Go to "Time/Expense" -> "Import"
14. Click on "Options"
15. Select "First Row Contains Headings" -> Under "Import/Export File" go and find the Sage 50 file you just downloaded
16. Select "Ok" then this screen should pop up:
17. Navigate to your "Time Ticket list" and then make sure the "Date Range" matches the dates for the imported time cards