What Is The Payroll Report?

The Payroll report shows Employees’ regular, overtime, and total hours and pay. This report also shows tip information if tip pooling is enabled for your establishment. The Payroll report can be used to track daily payroll and daily tip pools. The report can be viewed by a single date or over a range of days. This article will provide a detailed overview of the Payroll report. 

Prerequisites

• If you would like to use this report, contact your Implementation Manager to enable it.

• customersuccess@arryved.com 

• For an Employee to see this report in Arryved Portal, they must be a Super Admin or an Admin with all 3 of the following Portal Permissions:

• REPORTING

• VIEW HOURS

• VIEW PAY

Limitations

• If you search for data on the report over a range of days, it will not break down the totals by date (This is the difference between this report and the Employee Time Card report). 

• This report is designed to be used after batch time, meaning the next business day after transacting. 

• This report does not divide tips by time of day (shifts) or by Venue. It only divides tips for the whole day from the entire establishment and cannot be manipulated in any way.

• It is recommended to double-check that hours are correct and make any adjustments before generating the report. 

• Go to: Arryved Portal -> Employees -> View Hours.

• MODIFY_HOURS and MANAGE EMPLOYEMENT Portal Permissions needed. 

• Tips in this report are not differentiated by type (cash, card, gift card).

• The column in the report labeled Adj. is not functional at this time. 

• Only Employees clocked in with a Tipped and Clockin Required Labor Role will be included in the tips section of this report. Labor Roles that are not tipped roles will show payroll information, but not tips. 
  

• Go to: Arryved Portal -> Employees -> Labor Roles.
  

• IMPORTANT! There needs to be at least one Tipped Labor Role clocked in at any point during the day for tips to be allocated properly. 

How It Works

1. In your Arryved Portal, navigate to Reporting.

2. Click on Operations or Favorites.

• When enabled, this report is usually placed under your Reporting Favorites, if not, it will be under Operations.

3. Click on Payroll Report. 

4. Select the date or range of days you would like to view. 

5. Click Preview or Download.

Payroll

In the Payroll report, the leftmost columns show Employee Names, Jobs (Labor Roles), the Date(s) of the report, Hours Worked in time, Hours Worked in decimal, Regular Hours vs. Overtime Hours, and Regular vs. Overtime Pay. This information can be used to complete payroll for Employees who clock in and out through Arryved Service. The bottom left of the report will show the Overtime Rule, including the calculation, that has been set for your Company’s Location. 

Tip Pooling By Day

Tip pooling by day is where tips are shared among tipped Employees with one tip pool for the entire day. Tips can be divided up evenly based on hours worked or Labor Roles can have different weighted portions of the tip pool using Arryved’s Tip Points. Reports that use tip pooling by day will allocate tips to tipped Employees in one of two ways as follows: 

Standard Calculation 

For all tipped Employees to share tips equally, Tip Points will be assigned equally across all tipped Labor Roles. (Example: all tipped roles are assigned 1 Tip Point). 

Total tips for the day: $200  | Total hours worked: 20 hours (Employees A+B+C)| Hourly tip rate of pay: $200/20 = $10 per hour

Employee A worked 6 hours

• 6 hours x $10 = $60 in tip pay

Employee B worked 6 hours

• 6 hours x $10 = $60 in tip pay

Employee C worked 8 hours

• 8 hours x $10 = $80 in tip pay

With Weighted Tip Points

Different Tip Point values can be assigned to tipped Labor Roles so that Employees can have various allotments of the tip pool based on their role. 

Total tips collected: $200

Tipped Employees clocked in:

• 1 Bartender assigned 10 TIp Points, worked 8 hours.

• 1 Barback assigned 5 Tip Points, worked 4 hours

Total Tip Points in the pool: (10x8) + (5x4) = 100 Total Tip Points

Tip rate per Tip Point: $200/100 = $2 per Tip Point

Bartender receives: $2 x 80 Points = $160

Barback receives: $2 x 20 Points = $40

Cash

It is ultimately up to the establishment on how or if they want to include cash in their tipping process. Here are the ways that cash tips can be included in the Payroll Report. 

• Individual CO: Cash tips are entered manually to each tab via the Individual CO screen in Arryved Service. Arryved Service -> STAFF -> Individual CO. 

• If the Cash Actions tool is enabled for your establishment, cash tips are instead entered under Arryved Service -> STAFF -> Tips, If using Cash Actions, you are likely not using this report. 

• $0 tab trick: In Arryved Service, create a tab with no orders ($0) close it out to exact cash. From the Individual CO screen under the STAFF tab, find the $0 tab and manually enter the cash tips for the day as the tip for that $0 tab. Those cash tips will then be added into the tip pool and distributed to the Employees. 

• Reminder: This report does not differentiate between cash, card, and gift card payments. This trick is just a way to get cash tips into the tip pool.
  

Related Articles 

Reports With Tips Overview

How To View/Edit Employee Hours