Skip to main content
How to setup & download payroll file for Sage 50
Matthew Davidson avatar
Written by Matthew Davidson
Updated over 6 months ago

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

  1. Navigate to the Timecards

    To begin the process, log in to your Workyard account and navigate to the Timecards page.

  2. 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

Did this answer your question?