The payroll feature within Loop hr includes a series of downloads that can be exported and easily shared with your payroll provider. These include a Payroll Summary (as seen below). Payroll Adjustments (a report of all attendance adjustments for the pay period, sick, overtime etc.). If you pay commissions/bonuses in arrears, you will find the Offset Adjustments report (useful for any adjustments between the time you last processed payroll and the end of that period).
Loop HR payroll export is available in the final step of processing payroll and anytime thereafter.
You can export data in Excel or CSV format.
[1] Click the 3 dots
[2] Click Export
[3] Select the report to export
[4] Click to download
The data is collated into columns (expand the columns to see the full headings). The export can easily be edited to include additional information (such as tips) or you can remove information that you deem unnecessary for your payroll provider.
Here is an example export with an explanation of each column below:
| Name | The employee’s name as recorded within Loop hr |
| Base Pay Hourly Rate | A quick reference to the basic hourly rate as per the employee profile (no matter if a higher rate is paid during the pay period). |
| Base Salary | The basic salary for the period – if the employee is on Whichever is Higher commission and has achieved the higher value this field will appear blank |
| Service Commission | If the employee has achieved service commission it shows here |
| Performance Bonus | If the employee has achieved their Performance Bonus it shows here |
| Personal Bonus | If the employee has achieved their Personal Bonus it will show here |
| Super Bonus | If the employee has achieved their Super Bonus it will show here |
| Team Bonus | If the employee is eligible for Team Bonus it will show here |
| Retail Commission | If the employee is eligible for Retail Commission it will show here |
| Holiday Commission | If the employee is eligible for Holiday Commission it will show here |
| Offset Adjustments | If you pay bonuses/commissions in arears this column shows the financial total of payments and/or deductions from the offset period (details will be found in the Offset Adjustments export) |
| Regular Adjustments | Financial total of payments and/or deductions from the current pay period (details of variation in hours in the Payroll Adjustments export) |
| Total Pay | The total gross value of pay (a total of all the columns) |
| Total Hours (paid for the period) | A total of all paid hours in the current period (work hrs holiday hrs etc.) NB. Fixed salary staff deductions for sickness, the hours recorded in Loop hr are not included in this figure if the pay was deducted |
| Sick Hours | Sick hours recorded from the offset and current pay period |
| Overtime | Relating to paid hours only (not Banked hours) worked in addition to regular work hours |
| Holiday hours | The number of hours being paid for holiday commission |
| Holiday Commission Hourly Rate | The rate paid as an average of employee income (or the top up of base pay) over the past 52 weeks (or as much data available up to 52 weeks) |
| Hourly Rate of Pay | A calculation from Total Pay divided by the Total Hours |
| Notes | Throughout the Loop hr payroll process, notes can be made relating to adjustments, the notes feed through per employee line. |
Details of the calculations made to achieve these final figures are shown through the payroll process.
Use the supporting export files to share details of hours and values relating to each adjustment.
For further support queries go to the navigation panel within Loop hr and select Help & Support > LiveChat.
Back to knowledge base index
Just