--- title: Sage 50 Payroll Export description: Sage Payroll Export --- [Skip to content](https://university.guardhousehq.com/sage-payroll-export#main-content) English Show submenu for translations [![Text\_gradient gold-1-2](https://university.guardhousehq.com/hs-fs/hubfs/Text_gradient%20gold-1-2.png?width=225&height=30&name=Text_gradient%20gold-1-2.png)](https://university.guardhousehq.com/?hsLang=en) Open main navigation Close main navigation - English Show submenu for translations - [Contact Support](mailto:support@guardhousehq.com) [Contact Support](mailto:support@guardhousehq.com) How can we help you? - There are no suggestions because the search field is empty. 1. [Guardhouse Knowledge Base](https://university.guardhousehq.com/?hsLang=en) 2. [Payroll Integrations](https://university.guardhousehq.com/payroll-integrations?hsLang=en) # Sage 50 Payroll Export ## Importing payroll into Sage 60 #### 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. ![](https://university.guardhousehq.com/hs-fs/hubfs/Knowledge%20Base%20Import/-jxVMVP3shjZxfs5ZtABo8HNzYPUYbXJvA.png?width=670&height=339&name=-jxVMVP3shjZxfs5ZtABo8HNzYPUYbXJvA.png) **Payment Reference** Navigate to Organisation, Company, Payrates, Pay Categories.  ![](https://university.guardhousehq.com/hs-fs/hubfs/image-png-Dec-18-2025-03-39-14-2766-PM.png?width=1256&height=731&name=image-png-Dec-18-2025-03-39-14-2766-PM.png) In each pay and leave category, you must match the Reference ID with the Payment Reference in your Sage 50 account.  ![](https://university.guardhousehq.com/hs-fs/hubfs/image-png-Dec-18-2025-03-40-38-2107-PM.png?width=1221&height=571&name=image-png-Dec-18-2025-03-40-38-2107-PM.png) **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. ![](https://university.guardhousehq.com/hs-fs/hubfs/image-png-Dec-18-2025-03-42-18-6645-PM.png?width=1354&height=844&name=image-png-Dec-18-2025-03-42-18-6645-PM.png) **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. ![](https://university.guardhousehq.com/hs-fs/hubfs/image-png-Dec-18-2025-04-04-14-2772-PM.png?width=971&height=326&name=image-png-Dec-18-2025-04-04-14-2772-PM.png)           - [Dashboard](https://university.guardhousehq.com/dashboard?hsLang=en) - [Schedule](https://university.guardhousehq.com/schedule?hsLang=en) - [Timesheets](https://university.guardhousehq.com/timesheets?hsLang=en#main-content) - [Timesheets v1](https://university.guardhousehq.com/timesheets?hsLang=en#timesheets-v1) - [Timesheets v2](https://university.guardhousehq.com/timesheets?hsLang=en#timesheets-v2) - [Paysheets](https://university.guardhousehq.com/paysheets?hsLang=en#main-content) - [Payroll Extracts](https://university.guardhousehq.com/paysheets?hsLang=en#payroll-extracts) - [allowance/s](https://university.guardhousehq.com/paysheets?hsLang=en#allowance-s) - [Invoicing](https://university.guardhousehq.com/invoicing?hsLang=en#main-content) - [New Zealand](https://university.guardhousehq.com/invoicing?hsLang=en#new-zealand) - [Reports](https://university.guardhousehq.com/reports?hsLang=en#main-content) - [Staff Reports](https://university.guardhousehq.com/reports?hsLang=en#staff-reports) - [Incidents](https://university.guardhousehq.com/incidents?hsLang=en) - [Company Settings](https://university.guardhousehq.com/company-settings?hsLang=en#main-content) - [Timeclock](https://university.guardhousehq.com/company-settings?hsLang=en#timeclock) - [Onboarding](https://university.guardhousehq.com/company-settings?hsLang=en#onboarding) - [Integrations](https://university.guardhousehq.com/company-settings?hsLang=en#integrations) - [Payroll](https://university.guardhousehq.com/payroll?hsLang=en#main-content) - [Allowances & Deductions](https://university.guardhousehq.com/payroll?hsLang=en#allowances-deductions) - [Customers](https://university.guardhousehq.com/customers?hsLang=en#main-content) - [Customer Portal](https://university.guardhousehq.com/customers?hsLang=en#customer-portal) - [Sites](https://university.guardhousehq.com/sites?hsLang=en) - [Tours & Patrols](https://university.guardhousehq.com/tours-patrols?hsLang=en) - [Staff](https://university.guardhousehq.com/staff?hsLang=en) - [Subcontractor](https://university.guardhousehq.com/subcontractor?hsLang=en#main-content) - [Subcontactor Sharing](https://university.guardhousehq.com/subcontractor?hsLang=en#subcontactor-sharing) - [Frequently Asked Questions](https://university.guardhousehq.com/frequently-asked-questions?hsLang=en) - [Getting Started](https://university.guardhousehq.com/getting-started?hsLang=en) - [Holidays](https://university.guardhousehq.com/holidays?hsLang=en) - [Documents](https://university.guardhousehq.com/documents?hsLang=en) - [Leave / Unavailability](https://university.guardhousehq.com/leave-unavailability?hsLang=en) - [Guardhouse Support Topics](https://university.guardhousehq.com/guardhouse-support-topics?hsLang=en) - [Invoicing Integrations](https://university.guardhousehq.com/invoicing-integrations?hsLang=en) - [Payroll Integrations](https://university.guardhousehq.com/payroll-integrations?hsLang=en) - [Product Updates](https://university.guardhousehq.com/product-updates?hsLang=en) - [Release Notes](https://university.guardhousehq.com/release-notes?hsLang=en) - [Webinars](https://university.guardhousehq.com/webinars?hsLang=en) - [Xero](https://university.guardhousehq.com/xero?hsLang=en) - [Guides for Guards](https://university.guardhousehq.com/guides-for-guards?hsLang=en) - [API Integration](https://university.guardhousehq.com/api-integration?hsLang=en) - [Integrations](https://university.guardhousehq.com/integrations?hsLang=en) - [Tablet Clock-in/Clock-out](https://university.guardhousehq.com/tablet-clock-in-clock-out?hsLang=en) [![Text\_gradient gold-1-2](https://university.guardhousehq.com/hs-fs/hubfs/Text_gradient%20gold-1-2.png?width=150&height=20&name=Text_gradient%20gold-1-2.png "Text_gradient gold-1-2")](https://guardhousehq.com) [mailto:support@guardhousehq.com](mailto:support@guardhousehq.com) Copyright © 2025, Guardhouse