Integrating your Guardhouse payroll to BrightPay 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 1 additional item to setup in Guardhouse outside of the traditional payroll setup before you can start transferring your Paysheet file to BrightPay.


If you use Departments in BrightPay you can also set them against either a Customer or Site so they export in the Paysheet file.


 

Employee matching

You’ll need to place the Employee Works Number from the staff members BrightPay profile into the Employee ID Section of the staff profile within Guardhouse.



A screenshot of a computer Description automatically generated

 

Departments

If you use Departments, they can be matched against either a Customer or Site using Tracking Codes in Guardhouse.

To turn Tracking Codes on, first go to Organisation > Company > Payroll

Here you can choose to turn on Customer Tracking or Site Tracking

A screenshot of a computer Description automatically generated

Once you have turned on one of them, you’ll see a new Tracking Codes tab at the top of the Company Page



A screenshot of a computer Description automatically generated

You can add a Department by clicking the green Edit button and entering the Department name into the Tracking Code field.

 

Exporting a Brightpay 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 “BrightPay Payroll Export”

Select that and Guardhouse will generate a .csv file with all your payroll information in the correct format to import into BrightPay.



A screenshot of a computer Description automatically generated

 

BrightPay .csv Export 

Guardhouse will group all hours worked under each Pay Category (Description in BrightPay) into a line item on its export.

It will do this for all pay rates, allowances and leave that is approved on Timesheets and ready for Export.

 

 


See below the instructions on how to import your file into BrightPay.

You can also view this information in the BrightPay knowledge base.
https://www.brightpay.ie/docs/2022/importing-pay-data-from-a-csv-file/importing-hourly-payments-using-csv-file/


Importing Hourly Payments using CSV file



 To import hourly payments each pay period, go to Payroll > Batch > Import Pay Records from CSV File > Import Hourly Payments:



 A screenshot of a computer Description automatically generated
 

 

1) Browse to the location of your CSV File
 

2) Select the required file and click 'Open'
 

3) Your employee data will be displayed on screen. For each column, choose the payment data it represents. Ignore any columns and uncheck any rows you do not wish to be imported.
 

  • To assist with column selection, simply select 'Match Header Row'. BrightPay will try and match as many columns as it can for you
     
  • Also indicate whether you would like to replace the equivalent pay items that are already present on the employees' payslips with the new amounts being imported in by selecting/de-selecting 'Replace Existing'
     
  • Should you wish to remember your column selection for future imports, instruct BrightPay to 'Remember Columns'. BrightPay will subsequently remember the column selection used in the previous import when next importing a CSV file.
     
  • Should you wish to reset your column selection at any time, select 'Reset All Columns'.




A screenshot of a computer Description automatically generated
 

4) Click Import to complete the import of your payment information.