Profit & Loss

The Profit & Loss report compares the budget for a given period of time with the actual sales and costs, and displays the variance values and percentages. The "actual" sales values displayed are taken from the Enter Sales Transactions screen (which may be automatically populated by imported point-of-sale files). The "actual" cost values displayed come from reconciled purchases (vendor orders, commissary orders, and customer orders), purchase by invoice transactions and budgeted allocations. Sales from commissary orders and customer orders include products linked to both "Sales" GL accounts and accounts with "GL for Sales" set up.

 

Menu Paths: Net-Chef > Inventory: Reports > Profit & Loss
Menu Paths: Net-Chef > Reports: Inventory > Profit & 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.

Printer (Export): PDF, Excel, CSV formats

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

Report Columns:

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

  • P&L Grouping/P&L Substructure - The grouping/substructure with which the GL Accounts in that section are associated.
  • GL Code/Description – The GL Accounts with which the Sales and Costs are associated.
  • Actual Value
  • Sales: [ (Sum of Sales Totals – "Sales" Comps & Discounts) from the Enter 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
  • COGS: [ Beginning Inventory + Purchases + Production – Transfers Out – Production Consumption Reversal – Ending Inventory ]
  • Actual %
  • Sales: [ (Actual Sales ¸ Actual Total Net Sales) x 100 ].
  • COGS: [ (Actual Cost ¸ Actual Sales subtotal for P&L Substructure) x 100 ].
  • Budget Value – (calculated using 'Actual' or 'Budget' sales values, based on setup in Enterprise Manager)
  • Sales: [ (Actual or Budget Total Net Sales x Budget %) ÷ 100 ]
  • COGS: [ (Actual or Budget Sales subtotal for P&L Substructure x Budget %) ÷ 100 ].
  • Budget % = Budget % values entered in the Budget Setup screen, or calculated using Budget $ amount entered in the View/Edit Budget Data screen.
  • Variance Value
  • For Sales, Other Revenue, Gross Profit, and Net Profit: [ Actual Value – Budget Value ]
  • For Cost of Goods Sold, Operating Expenses, Payroll, and Other Expenses: [ Budget Value – Actual Value ]
  • Variance %
  • For Sales, Other Revenue, Gross Profit, and Net Profit: [ Actual % – Budget %]
  • For Cost of Goods Sold, Operating Expenses, Payroll, and Other Expenses: [ Budget % – Actual %]

Report Totals:

  • Total Net Sales = Sum of the Net Sales subtotals.
  • Total Cost of Goods Sold = Sum of the Cost of Goods Sold subtotals.
  • Gross Profit = [ Total Net Sales – Total Cost of Goods Sold ]
  • Total Operating Expenses = Sum of the Operating Expense subtotals.
  • Total Payroll Expenses = Sum of the Payroll subtotals.
  • Total Other Expenses = Sum of the Other Expense subtotals.
  • Net Profit = [ Gross Profit – Sum of all Expenses subtotals ]

 

 

Related Topics Link IconRelated Topics