Integrating your Guardhouse payroll to Sage 50 is one of the quickest ways to save you hundreds of hours across the working year and remove human error leading to payroll issues.
There is only one additional item to setup in Guardhouse outside of the traditional payroll setup before you can start transferring your Paysheet file to Sage 50.
Employee matching
You’ll need to place the Employee Reference Number from the staff members Sage 50 profile into the Employee ID Section of the staff profile within Guardhouse.
Payment Reference
Navigate to Organisation, Company, Payrates, Pay Categories.
In each pay and leave category, you must match the Reference ID with the Payment Reference in your Sage 50 account.
Exporting a Sage 50 Payroll file
Once it is time to export payroll, in Paysheets, select all staff using the select all button next to the Search Bar then click Export. At the bottom of the list, you will see the “Sage 50 Detail Hours Export"
Select that and Guardhouse will generate a .csv file with all your payroll information in the correct format to import into Sage 50.
Sage 50 Detail Hours .csv Export
Guardhouse will group all hours worked under each Pay Reference (Description in Sage 50) into a line item on its export per staff member.
It will do this for all pay rates, allowances and leave that is approved on Timesheets and ready for Export.
