Consolidated Payroll Control

The Consolidated Payroll Control report provides payroll and sales data for all locations in the selected hierarchy. Payroll costs are compared to both actual and forecasted sales for the Week Ending periods selected. The information can be viewed by restaurant, by position, or by date. Managers’ information will only be included for authorized users.

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

Transactions Included: Sales Forecasts, POS Sales, Scheduled Labor, Labor Actuals

Report Controls

Hierarchy: Select the desired hierarchy level from the drop-down

Week Ending Start/Finish: 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

-><- , <-->: Click to minimize/maximize the report header

Report Columns:

Click any column header to sort by the data in that column; defaults to Location Name (Asc).

Location Name – The name of the location; “Drill Down” link; see below for details.
Forecasted Sales – The sum of actual forecasted net sales values at eligible locations within the hierarchy and for dates in selected range.
Actual Sales – The sum of actual sales at eligible locations within the hierarchy and for dates in selected range.
Variance (Sales) – The sum of sales variances at eligible locations within the hierarchy and for dates in selected range.
Scheduled Payroll – The sum of forecasted payrolls at eligible locations within the hierarchy and for dates in selected range.
Actual Payroll – This is the sum of total adjusted wages at eligible locations within the hierarchy and for dates in selected range.
Variance (Payroll) – The sum of payroll variances at eligible locations within the hierarchy and for dates in selected range.
Variance % = [ (Variance {Payroll} ÷ Variance {Sales}) x 100 ]
Scheduled Payroll % = [ (Scheduled Payroll ÷ Forecasted Sales) x 100 ]
Actual Payroll % = [ (Actual Payroll ÷ Actual Sales) x 100 ]
Variance (Payroll %) = The sum of Payroll Variance % values at eligible locations within the hierarchy and for dates in the selected range.

“Drill Down” Links:

Location Name – Opens a report with subtotals for each week within the selected date range at the selected location.
This report includes the following link:

Week Ending Date – Opens a report with subtotals for each day of the week for the selected location; equivalent of the Daily Payroll Control report for that location.

Totals label – Opens a report for each Week Ending Date within the range.

Week Ending Date – Opens a report with subtotals for each day of the selected week for all locations.

Variance (Payroll) total – Opens a report with subtotals for each position within the hierarchy.

Position Code – Opens a report with subtotals for each location for the position.