Daily Payroll Control Report

This report displays daily payroll and sales data for the selected payroll period. This enables managers to view the payroll and sales totals for any day during the period. The report displays both scheduled and actual payroll data as well as forecasted and actual sales data. With this report, managers will be able to track a location’s performance with respect to its ability to meet daily forecasted sales and payroll targets. Managers’ information will only be included for authorized users.

Menu Paths: Net-Chef > Labor: Reports > Daily Payroll Control
Menu Paths: Net-Chef > Reports: Labor > Daily Payroll Control

Report Controls

Begin/End Date: Calendar widgets; defaults to dates for the current period but can select any dates.

Funnel (Filters): Any report column

Printer (Export): PDF, Excel, CSV formats

Report Columns:

Click any column header to sort by the data in that column.

Date, Weekday – The date and day for which the sales and payroll data were recorded.
Forecasted Sales – The “Total Forecasted Sales” value saved in the Sales Forecasting screen for the Weekday.
Actual Sales – Total Net Sales for the Weekday.
Variance (Sales) = [ Actual Sales – Forecasted Sales ]; calculated only for days where both elements are present.
Period to Date (Sales Var.) = Sum of the values in the Variance (Sales) column for each previous date in the payroll period up to and including the date for the given record.
Scheduled Payroll – The total value of Scheduled shifts for the day/location.
Actual Payroll – The Actual value of shifts worked for the day/location.
Variance (Payroll) = [ Scheduled Payroll – Actual Payroll ]; calculated only for days where both elements are present.
Period to Date (Payroll Var.) = Sum of the values in the Variance (Payroll) column for each previous date in the payroll period up to and including the date for the given record.
Variance % = [ (Variance {Payroll} ÷ Variance {Sales}) x 100 ]; calculated only for days where both elements are present.
Scheduled Payroll % = [ (Scheduled Payroll ÷ Forecasted Sales) x 100 ]; calculated only for days where both elements are present.
Actual Payroll % = [ (Actual Payroll ÷ Actual Sales) x 100 ]; calculated only for days where both elements are present.
Variance (Payroll %) = [ Scheduled Payroll % – Actual Payroll % ]; calculated only for days where both elements are present.