Consolidated Profit and Loss

The Consolidated Profit and Loss report displays the total sales, costs and profits for each physical location within the selected hierarchy.

{Note}: Locations within the hierarchy that have no relevant data (even if it is all of them) will be listed in red below the Grand Total row. When there are no physical locations associated with the selected Hierarchy, the report will display a "No Data" message.

Menu Paths: Net-Chef > Inventory: Reports > Consolidated Profit and Loss
Menu Paths: Net-Chef > Reports: Inventory > Consolidated Profit and Loss

Transactions Included: Vendor Orders, Vendor Returns, Commissary/Customer Orders, Purchases By Invoice, Location Transfers, Daily Prep, Inventory, Total Sales, Sales Paid Outs, Sales Comps and Discounts (excludes those linked to “Sales” & “Other Revenue” P&L groupings)

Report Controls

Begin/End Post Date: Drop-downs; can select Post Period dates.

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

Printer (Export): PDF, Excel, CSV formats

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

Report Columns:

{Note}: Values in this report are expressed in the location’s base currency.

Location Code – The code for the location.
Location Name – The name of the location; "Drill Down" link; see below for details.
Net Sales = [ (Sum of Sales Totals – "Sales" Comps & Discounts) from the Sales Transactions screen + total value of reconciled outgoing Commissary/Customer orders ]. Sales from Commissary/Customer orders include products linked to both "Sales" GL accounts and accounts with "GL for Sales" set up.
Cost of Goods Sold = [ Beginning Inventory + Purchases + Production – Transfers Out – Prod. Cons. Reversal - Ending Inventory ], for all products associated with the "Cost of Goods Sold" P&L Grouping.
CGS % = [ (Cost Of Goods Sold ¸ Net Sales) x 100 ]
Gross Profit = [ Net Sales – Cost Of Goods Sold ]
Operating Expenses – Sum of all transactions associated with the "Operating Expenses" P&L Grouping.
Net Operating Profit = [ Gross Profit – Operating Expenses ]
NOP % = [ (Net Operating Profit ¸ Net Sales) x 100 ]
Payroll Expenses - Sum of all expenses associated with the "Payroll" P&L Grouping
Other Expenses/(Revenues) = [ Sum of all transactions associated with the "Other Expenses" P&L Groupings - sum of all transactions associated with the "Other Revenue" P&L Groupings ]
Net Profit = [ Net Operating Profit – Other Expenses/(Revenues) - Payroll Expenses ]
NP % = [ (Net Profit ¸ Net Sales) x 100 ]

“Drill Down” Links:

Location Name – Opens a report with totals by GL Account for the selected location; equivalent of the Profit & Loss report for that location.
Grand Total label – Opens a report with totals by GL Account for all locations in the selected hierarchy.