Show & Hide Timesheet Columns

Have more questions? Submit a request

In this article, we will:

 

Filter_Timesheets_6.2.gif

 

To show or hide any column in your Timesheets:

1. Click the drop-down under Show/Hide Columns.

2. Be sure there is a green check next to any columns you would like to view. 

  • If there is a column you would not want to see, make sure the box is unchecked.

3. Click Apply and your Timesheets will adjust according to your selections. 

 

FIlter_Timesheets_6.1.gif

 

Timesheet Columns Defined:

Role
  • With the Role column, you can view timesheets grouped by role to see labor totals more easily. When grouping by role, timecards with no role will appear under the group name "No Role"
  • Roles appear on a timecard in several ways:

    • Default Role of an Employee: This is the role assigned to the employee in Job Details. When no role is added to the schedule or a manually-added timecard with no role, the role will default to the assigned role in their Job profile.
      • "Default Role" is determined by the role that appears first in their assigned roles. If multiple roles exist for an employee, their "default role" refers to the role displayed first.
    • Scheduled Shift Role: This is the role that was assigned to the shift on the schedule. When an employee clocks into this scheduled shift, this is the role that will be displayed on their timecard— even if this role is not assigned in their Job profile.
      • If no role was created for the shift, the role on the timecard will either be empty or will display the employee's default role, if one is assigned.
    • Manual Input on Timecard: When a timecard is manually added, the role can be selected when adding the timecard.
      • If no role is selected, the role will display the employee's default role or, if no role is assigned, this field will be empty.
    • PTO: Role is not used and cannot be added when PTO is approved for an employee.

    The role can be added or changed when selecting an employee's individual timecard.

Wage
  • The wage column displays the employee's assigned wage in their Job Profile. The wage column will display the employee's hourly wage rate or their annual salary, depending on their wage type. If an employee does not have an assigned wage, this column will be empty.

    • The wage displayed is either: their Default Wage, which may or may not be assigned to a specific role OR It is the wage assigned to a specific role.
Time Card
  • The Time Card column displays the clock-in and clock-out times of the employee. If the employee has clocked in and the shift is in progress, only the clock-in time will be displayed.

  • This column does not display breaks.

  • This column may display "No-Show" to indicate the employee was scheduled and did not clock in for their shift.

Issues
  • This column displays an exclamation point columns.png to indicate that there is an issue with the timecard (ex: Missed break, over-scheduled time, over time, missing clock out, no-show)
Scheduled
  • This column displays the total of the published scheduled hours for this employee.

  • Scheduled totals are calculated off the published scheduled hours and mandatory break settings. Under "Breaks & Compliance", there is the option to "Subtract unpaid breaks from scheduled hours and wage forecast". When enabling this setting, the Scheduled totals will change based on mandatory break settings. (Enabled "Optional" Breaks do not affect this column)

  • Example: An employee is scheduled for a 9-hour shift. Their Scheduled total appears as "9.00". Under Breaks & Compliance, the owner has enabled a mandatory 1-hr unpaid break every 9 hours. When "Subtract unpaid breaks from scheduled hours and wage forecast" is enabled, the Scheduled total changes to "8.00".

Actual
  • Actual Hours represent the entire time the employee was present that day until clock-out. Unpaid breaks are not deducted from this time.
Actual vs. Scheduled
  • This column displays the Actual Hours minus the Scheduled Hours.

  • If the Scheduled total is "8.00" and the Actual is "9.00", this cell will equal "1.00".

Total Paid
  • Total Paid Hours reflect the entire time from clock-in to clock-out. Unpaid breaks are taken out of this time. This includes all hours that the employee will be paid for: PTO, Holiday Pay, Overtime, and Double Overtime.

  • These settings under Settings: Breaks & Compliance also impact Total Paid calculations—

Regular
  • Regular Hours are all hours worked which did not qualify as Overtime or PTO hours.
Unpaid Break
  • The decimal total of the employee's Unpaid Break totals.

  • At this time, there is no column for "Paid Breaks". Paid Breaks are not included in this column.

Est. Overtime
  • Estimated Overtime is calculated based on Hours Worked, Overtime Settings, and the Workweek Settings.

    These Overtime Settings affect how Est. Overtime is calculated—

    • Daily Overtime: Typically means premium pay at one and one-half (1-1/2) times regular pay rates for time actually worked beyond eight (8) hours or more. This may vary depending on state or local labor laws.
    • Weekly Overtime: The U.S. Federal government and all U.S. states define weekly overtime as any hour worked over 40 hours, paid out to the employee at 1.5 x the Regular Rate of Pay.
    • 7th Day Overtime Requirements: This law varies by state but generally states Employers must pay a 1.5x hourly rate for any hours worked on the 7th Consecutive Day (within a workweek). These hours will appear in the "Est. Overtime" column.
      • 7th Day Double OT Requirements: This law specifically applies to California. On the 7th consecutive day of work (within a workweek), any hours worked over 8 hours must be paid at 2x the hourly rate. These hours will appear under the "Double OT" column.
    • Holiday Pay: Any hours worked as holiday pay will not count towards overtime calculation.
    • "Track Overtime Across Multiple Locations": if an employee works at multiple locations, this will affect the totals in the header column of est. overtime
    • "Calculate overtime for any salaried employees below $35,568"

    When Daily & Weekly OT are enabled, hours counted towards daily overtime will not contribute to weekly OT calculations

  • Overtime is calculated based on the Workweek Settings NOT Payroll Period.

Double OT
  • Employers must pay double time after 12 hours in a day. (Only visible for applicable states)

  • California Locations also have a "7th Consecutive Day" rule that states on the 7th consecutive day of work (within the workweek) Employers must pay Double Overtime for any hours worked over 8 hours.

SOH (Spread of Hours)
  • Click here for more info
  • Under the spread of hours rule, a non-exempt worker whose workday is longer than ten hours must receive an extra hour of pay at the basic minimum hourly rate, in addition, to pay for the actual hours worked. (Only certain states require this)

  • Workers will only be granted 1 hour for the Spread of Hours rule on a given day.

Split
  • A split shift is a work schedule that is interrupted by non-paid and non-working time periods established by the employer.

  • Enable Split calculations on Timesheets by selecting "Pay my employees for any split shift requirements [$X] an hour" in Overtime settings.

  • Workers will only be granted 1 hour for the Split rule on a given day.

Est. Wages
  • Estimated Wages is the monetary value owed to the employee based on Total Paid Hours,

  • Est. Overtime, and Penalty Hours multiplied by the Hourly Wage Rate. For salaried employees/managers, their daily earnings will be reflected based on a 364-day year. This value does not include tips.

Cash Tips
  • If enabled under time-tracking, Employees can declare cash tips at the end of their shift. This information can be added or edited in the employee's individual timecard.
Credit Tips
  • Credit tips can be manually added or edited in an employee's timecard by the account owner or manager.

  • Credit tips can be imported depending on POS Partner.

Blue
  • Blue Laws also called Sunday closing laws, are rules in certain states that ban Sunday activities or place restrictions on employment and alcohol sales activities. It requires employers to pay an increased amount for working on Sunday. (Only certain states require this)
FFCRA - Paid/Sick/Others/Child
  • As of 02/18/2022:
    Customers will no longer be able to enroll users in FFCRA policies and FFCRA will historically remain in HB for documentation purposes, but no longer be available for use. Why: The Families First Coronavirus Response Act (FFCRA) has expired and is no longer in effect.
Holiday Pay
  • Holiday Pay is enabled in Overtime settings. Holiday Pay Rates must be set by the Account Owner or Manager. Any time card added for a date set as a Holiday will display their total in the "Holiday Pay" column versus the "Regular" column or "Overtime" column.

  • In order to be categorized as "Holiday Pay", the timecard must start on the day assigned as Holiday Pay. All hours worked for that timecard will be counted towards Holiday Pay (even if it continues into a non-Holiday).

  • If the timecard begins the day before the Holiday begins but continues into the assigned Holiday, no hours will be counted towards Holiday Pay
  • The "Start of Day" for the Holiday is dictated by "Start of Workday" settings in Overtime.
PTO
  • PTO reports the amount of Paid Time-Off approved for the employee on that date.

  • Approved Unpaid Time Off is not displayed on the timesheets.

  • Est. wages for PTO hours may include a blended wage rate if the employee works roles with different wage rates during the pay period.
Was this article helpful?
1 out of 6 found this helpful