Payroll Export

Back to knowledge base index

 

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