Gross Margin¶
Menu Location: Reports > Finance > Gross Margin Report
Last Updated: 2026-11-02
Overview¶
The Gross Margin report shows what you made on the goods you sold versus what those goods cost you. Boxes and add-ons are counted together, per delivery week and per box type, so you can see margin week by week and which box products are carrying the profit.
Costs are valued at the price that was in effect in each order's delivery week, not today's menu price. Changing a price today does not rewrite last month's margin.
Two cost bases are shown side by side:
- Ideal - what the goods would have cost if you bought exactly what shipped.
- Purchasing - what the goods actually cost buying by the whole case, which is how you have to buy them.
The gap between the two is the Overage: money tied up in case leftovers you had to buy but did not ship.
Primary Features¶
- Pick a From / To delivery week range and click Generate Report.
- By Week table: one row per delivery week plus a Grand Total row, showing both cost bases and both margins.
- By Box Type table: revenue and ideal margin for each box product across the whole range.
- CSV button on each table to export that table to a spreadsheet.
- Every column header explains itself on hover, including how the number is calculated.
The Date Range¶
The page opens on the current delivery week. Widen the range with the From and To week pickers at the top and click Generate Report.
If the From week is later than the To week, the two are swapped automatically, so you do not have to fix the order yourself.
By Week Table¶
Columns¶
- Week - the delivery week (the weekly cycle the order was delivered in).
- Orders - how many orders were delivered that week. Cancelled orders are not counted anywhere on this page.
- Product Revenue - what customers paid for goods: box charges plus add-on charges. Delivery fees and tax are left out, since they carry no cost of goods.
- Ideal COGS - cost of goods if you bought exactly what shipped. For each item: units delivered multiplied by (case price divided by case size), using the cost that was live that delivery week.
- Purchasing COGS - cost of goods buying by the case. Each item's demand for the week is rounded up to whole cases, then multiplied by the case price.
- Overage - Purchasing COGS minus Ideal COGS. The money tied up in case leftovers.
- Ideal Margin - Product Revenue minus Ideal COGS.
- Ideal % - Ideal Margin divided by Product Revenue.
- Real Margin - Product Revenue minus Purchasing COGS.
- Real % - Real Margin divided by Product Revenue.
A Grand Total row at the bottom sums the whole range. If there are no orders in the range, a message tells you to widen the weeks.
By Box Type Table¶
This table covers the whole selected range, grouped by the box assigned to each order.
- Box Type - the box product. Orders with no box set are grouped under (no box assigned).
- Orders - orders of this box type delivered in the selected weeks.
- Product Revenue - box plus add-on charges for these orders.
- Ideal COGS - cost of what shipped: units delivered multiplied by unit cost, at each delivery week's cost.
- Ideal Margin - Product Revenue minus Ideal COGS.
- Ideal % - Ideal Margin divided by Product Revenue.
Rows are sorted by revenue, highest first.
Purchasing cost and overage are not shown per box type. Cases are bought once per item for the whole store, not per box, so the overage cannot be split cleanly between box types. Use the By Week table for the overage figure.
Common Use Cases¶
Check whether a week made money. Open the report on the current week, or set a range, and read Real Margin: revenue after paying for the whole cases you had to buy.
See the cost of buying by the case. Compare Ideal COGS with Purchasing COGS for a week. The difference is the overage. A large overage on an item usually means its case size is far bigger than weekly demand.
Compare box products. Use the By Box Type table to see which boxes bring in revenue and which carry a healthy ideal margin.
Review a past period without price drift. Because costs come from the price that was live each week, re-running an old range gives the same margin it gave at the time, even if the menu price has changed since.
Troubleshooting¶
The page is empty or shows "No orders found in this range". Widen the week range. The default is only the current delivery week, and cancelled orders are excluded.
Ideal COGS looks too high or too low for an old week. Costs come from the menu price snapshots saved when each week began. If an item had no saved snapshot for that week, the current live menu price is used as a fallback.
Overage looks large for a particular week. That is usually real: an item sold fewer units than its case size, so a full case was bought for a partial case of demand. Look at items with case sizes much larger than weekly demand.
Purchasing totals do not match what I paid my supplier. The report estimates purchasing from your case price and case size on the menu, rounded up to whole cases. It does not read supplier invoices.
Recent Updates¶
2026-11-02 - Fixed the By Box Type table collapsing into a single row. It now breaks out each box product correctly, so orders with no box set still group under (no box assigned).
2026-10-31 - Gross Margin report added under Reports > Finance. Boxes and add-ons combined, ideal versus whole-case purchasing costs, valued at each week's historical case price, with per-week and per-box-type breakdowns and CSV export. Column headers explain themselves on hover.