Sage 50 (UK) & Sage50 integration including Exporting Timesheets

Updated over a week ago

You can use this guide for any specific instructions for using Sage 50 in Workforce. For any specific Sage 50 questions, it is best to speak with Sage 50 Support first.


Add Sage 50 to your Workforce account by going to Settings > Integrations > Payroll Integrations:

In the top right corner, click on + New Payroll Integration:

Click on Show more at the bottom, select Sage 50 and then click Save:

Importing Staff


There isn't an automatic import or report that can be imported from Sage 50 to Workforce, but there are a few ways you can add your staff to Workforce; by manually adding them, importing by Excel or you can ask your staff to fill in their details by sending them an invitation to Workforce's Employee Onboarding.

Go to Workforce > Staff:

On the right, click on + Add Staff:

In the pop-up window, select the option that you want to use for adding your staff:

  • Add Manually: just add in their information yourself.

  • Employee Onboarding: click on this article for further information.

  • Importing from Excel (CSV): download the Template and add your staff details, and then import into Workforce. Click on this article for further information.

When you're importing by Excel, add into the sheet in the Employee ID column, the employee's Employee Reference number from Sage 50.
If you're adding manually or from Onboarding, you'll need to add this to each employee's profile in Workforce. This is how Workforce matches the employee to Sage 50 when you export your Timesheets later, so it's important to have it setup from the start.

Go to Workforce > Staff > click on an employee's name to go into their profile and then click on the Payroll tab. Add the Employee Reference to the Employee ID field and click Update to save:


In Sage50 (the first column):

Payroll Configuration

In Sage 50

Check that Pay Elements are set up to appear in Timesheet Entry:

  • Company > Pay Elements > Edit

  • Check that Include in Timesheet Entry checkbox is selected

  • Ensure all other settings are correct > OK

  • You can also add Deductions that need to be included when you import your timesheets from Workforce by selecting Deductions > select relevant deductions > Edit > select the Include in Timesheet Entry checkbox

  • Select OK to finish

Now you can create an Import Template:

  • Select the required employees > Payroll > Timesheet Entry

  • Create Template > Save > Close

Download a Pay Element Report to match in Workforce:

  • In Sage 50 select Reports > Company > Payment Type > keep open or save a copy to reference


Now you'll need to match the Earning Rules in Workforce to the Pay Elements:

  • Compliance > Custom Award Rules

  • If you just pay staff one rate, click on Regular Hours and at the bottom, in the Export name enter of the Pay Element reference number that you have for this in Sage 50. Use the Report in Sage 50 to confirm the exact number.

  • If you use overtime, you can create a new rule by clicking on + New Award Rule in the top right corner and then entering the Export Name as the overtime Pay Element reference number from Sage 50.

  • The import does not recognise slashes in the Pay Element name, i.e. Time and 1/2. If you do have pay elements that contain slashes you will need to change the name in Sage 50.

Exporting from

Once you've approved all your Timesheets and you're ready to export, go to Timesheets > Weekly/Fortnightly (check you're on the correct pay period) > click the Preview & Export button:

You'll then go through to the Timesheet Export Preview page. If there are any errors in your Timesheets, this will be flagged so you can fix before exporting.

When you are ready to export click Export to Payroll Software again within the Preview page:

When you click the button, a file will be downloaded to your computer. The file has the extension .csv . Save this somewhere on your computer where you can easily find it again.

Importing into Sage 50

  • Click on File > Data Import > Import Sage Payroll Data

  • Then click Next > Timesheets Payments > Next

  • Select Browse > locate the file you downloaded from Workforce > Finish

  • Select Print to print or save the Import Results window > Close. You can send us a copy of this to the Support details at the bottom if you receive any errors and need assistance.

You can then process your payroll in Sage 50 the same way you normally would. At the end, confirm that the Gross Payment matches the Gross payment expected in Workforce.

Did this answer your question?