Payroll Report - Run, View, Automate
Available in: Professional subscriptions only
The Outlet-level Payroll report in Avero will help you stay informed about, and in front of, your labor costs. The outlet level payroll feature will give you detailed information about each employee's hours worked, pay earned and tip information.
In this article, the following topics will be discussed:
Running a Payroll Report
Payroll is located under the Labor heading in Avero. By default, this report will show you an outlet's employees' hours worked and subsequent pay yesterday.
This information is pulled directly from your POS (if labor is integrated) or time clock system.
Like every Avero report, the Payroll report has a unique Report Generator to help you filter your results. Once you've made your choices, hit the Go button. For instructions on how to utilize the Report Generator, reference this article.
Avero reflects the Job Classes as they are defined in your POS (if labor is integrated into your POS) or time clock system. These are also tied to departments, such as Front of House or Back of House.
Viewing the Payroll Report
Due to the nature of the data in the report, the Payroll report will not include a visualization. However, you will see the data displayed in a table. When viewing the table report, keep the following in mind:
- You will see all Employees listed out (with their respective job classes) that worked during the time range selected.
- Hours, Hourly Rate, and Total Pay for each employee will allow you to see who your most costly employees are, which employees have accrued the most Overtime, and which Businesses have the highest payroll.
- You will also see a column for declared tips and credit card tips for your tipped employees.
Please note: Not all POS and time clock systems support all of these data types.
How Labor Data is Displayed
Because time is not a base 10, viewing the time data and calculations can be confusing.
Clock in and Clock out times are displayed as Time in the HH:MM format, note the colon, not a decimal point. The colon indicates time vs a number, so 4:00 or 16:00 would indicate 4pm (depending on your time format setup, accessible in your User Profile).
Rate and Pay will be displayed as Dollars, preceded by a $ (or currency indicator for non-US currency) and showing two decimal points. If you export to excel the dollar signs will not be present, just a currency number.
Hours calculations, such as Regular Hours, Total Hours, Overtime Hours, will be displayed as a Decimal number so it can be easily multiplied by rate for pay calculations. So 8.15 will indicate 8.15 hours, not 8 hours and 15 minutes. 8.15 hours would be equal to 8 hours and 9 minutes
Rounding - some POS solutions have the option within your POS to set automatic rounding (say if at least 7.5 minutes out of a 15 minute period has been worked it round up to 15 minutes). Avero pulls data as it is represented in the POS and performs no rounding. If you notice a rounding of minutes in hours calculations, view your POS Labor Setup.
Set this up to run automatically every pay period:
Set up an Email Schedule...
Click the Envelope to set up an email schedule.
...Or Pin it to your Dashboard.
Click the Speedometer to add to your Dashboard. (hint: make sure you've chosen a trended or dynamic date type).
Please sign in to leave a comment.