Payroll Report

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
• Viewing the Payroll Report

 

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.

Job Class 

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).

Why don't the tip values here match the Tips report?

Both the Tips report and the Payroll report include a value for CC Tips. While the total value will always match, the breakdown by employee might not.

For Service reports, we assign one server to each check despite the fact that several individuals might be involved with it. For example, one employee might open it and a different employee might close it. This assignment varies depending on your POS, but typically we assign the employee that closes the check as the server. In this module, all the tips for a transaction are associated with the single employee assigned as the server.

 

The Payroll report works differently. We build this report using data of punch-in and punch-outs. Unlike a check, it is not possible that multiple employees are involved with punches. We're not confronted with having to assign one employee or another. When using the CC Tips for payroll, pooling calculations, or similar use cases, the Payroll report is the definitive answer.