The Controllable P&L gives a high-level view of revenue and expenses by combining data from sales entries, invoices, and inventory adjustment in a customizable data range.
Some Key Formulas
Cost % of Sales = (COGS by Category Type) / (Sales by Category Type)
Cost of Goods Sold = Starting Inventory + Purchases - Ending Inventory
Sales = All Sales Lines set to a Category Type AND Included in Reporting
You can adjust the filters up top to show your preferred time period and whether you want to sort by Accounting Code or alphabetically. You can also adjust whether it's displayed as [me] categories or your accounting system categories.
To read more about how you can view data from multiple restaurants at the same time, go here: P&L Side-by-Side Comparison
What’s on the MarginEdge Controllable P&L?
INCOME
This data comes directly from your POS system. It is configured on the Accounting > Sales Mapping page.
The top of the report shows your income broken down by Category Type. If you need to change which sales show up in which Category Type and which sales lines are included, that is set on the Sales Mapping page.
COGS
This data comes from invoices and inventory adjustments. How they are reported is set on the Accounting > Categories page.
The middle section shows the Cost of Goods Sold (COGS) for the date range subdivided by Category Type Food, Beer, Wine, Liquor, NA Bev and Retail. The Categories that are included in each Category Type and which Categories are included or excluded from the report are set on the Accounting > Categories page. This may also include any custom Categories you have created.
Also shown here is the cost % for each Category which is calculated by dividing the COGS for the Category and dividing it by the corresponding Category Type income from the first section.
EXPENSES
Showing Net Vs. Gross Sales in MarginEdge
This data also comes from invoices and inventory adjustments, but only includes items under Category Type "Other".
The bottom of the report shows expenses, which include any Categories that are set to Category Type "other". The Cost % for expenses is calculated by dividing the total expenses by the total sales (not by Category Type "sales").
LABOR*
This is the summarized category-level data of wage data from your POS system plus any salaried employee costs you've entered into [me].
Note: Only users with the Payroll Manager or Shift Reviewer role are able to see labor data on the P&L.
*This feature is only available via certain POS integrations. Learn more here.
CALCULATIONS
There is a summary value below each section, and here's what factors into each subtotal and total.
- Total income is the sum of the total sales
- Total COGS is the sum of all Category Type COGS
- Gross Profit = Total Income - Total COGS
- Total Expenses = Expenses + Labor
- Controllable Profit = Gross Profit - Total Expenses.
Exporting the P&L
You can choose to export the view you have as either a PDF or a CSV file.
Note that it may be slightly confusing on the CSV to see multiple line items that appear to state the same thing. Rest assured these values are not duplicated, but are simply subtotals that are utilized in the calculations. It's a bit easier to see what's going on in the PDF than in the CSV because the lines are indented.
PDF:
CSV: