Margin by product report
The Margin by product report shows, for each product you sold in a period, how many you sold, what they sold for, what they cost you and the margin you made. If your account has more than one site, you can also split each product by the site that fulfilled the sale or by that site's site group. If you run more than one business from a single Breww account, grouping by site group gives you quantity, cost and margin per product for each business.
Find it under Reporting → Pre-built Sales reports → Margin & profitability.
Running the report
Choose a date range, set the options below, then press Run report. The report covers invoiced orders in the period, and the credit notes issued in it.
| Option | What it does |
|---|---|
| Which date would you like to filter on? | Choose whether an order falls in the period by its Invoice date (the default) or its Delivery dispatch date. Credit notes are always included by their own date. |
| Cost basis | Cost each sale at its actual cost, or at the target costs you have set. See Cost basis on margin reports. |
| Group by | Show one row for each product, or split each product by fulfillment site or site group. See "Grouping by fulfillment site or site group" below. This option shows when your account has more than one site. |
| Include additional invoice charges in product value? | Adds additional charges on your invoices, such as delivery charges, to the value of the products sold, spread in proportion to the value of each product. Non-revenue charges, such as refundable container deposits, are never included. |
| Remove credit note totals from the "Total value" | Takes the credit notes issued in the period off each product's Total value. |
| Remove returned products from the 'Qty sold'? | Takes products returned from a delivery off Qty sold, and their cost off the production and packaging cost columns. |
| Stock transfer orders to include | Choose whether invoiced stock transfer orders count as sales in the report. |
Reading the results
Each row shows:
- Product - the product sold.
- Qty sold - the quantity sold in the period.
- Total value - the value of those sales, adjusted for additional invoice charges and credit notes if you enabled those options.
- Total volume sold - the volume of drink in the products sold. The heading uses your own drink name, for example "Total volume of beer sold".
- Production costs, Packaging costs and Duty costs - what the products sold cost you.
- Total cost - the three cost columns added together.
- Margin - the total value less the total cost, as a percentage of the total value.
When Group by is Product and Cost basis is Actual costs, each row also has a button in its Actions column that opens the COGS by stock item and utility/other cost report for that product, showing which stock items and utility/other costs make up its cost.
Grouping by fulfillment site or site group
Group by has three options:
| Option | What you get |
|---|---|
| Product | One row for each product. This is the default. |
| Product and fulfillment site | One row for each product at each site that fulfilled sales of it, with a Fulfillment site column after Product. |
| Product and site group | One row for each product in each site group, with a Site group column after Product. |
A product's rows sit together, in site or site group name order. A product only gets a row for a site or site group that has sales or credit notes for it in the period.
If each of your businesses is a site group, group by Product and site group. Each row then shows how much of that product one business sold, what it cost and the margin it made.
Which site a sale belongs to
A sale belongs to the fulfillment site on its order, the site the order was fulfilled from. Where the stock was produced or packaged makes no difference: if you brew at one site and sell the stock from another, the sale and its cost appear against the site it was sold from. How does Breww pick the site to use for an order explains how an order gets its fulfillment site and how to change it.
Product and site group uses the site group each fulfillment site belongs to now.
Sales from a site you have since deleted still appear under that site's name.
Credit notes
A credit note is shown against the fulfillment site, or site group, of its original invoice, so each site's figures reflect its own credits. This applies even when the original invoice is dated before the report's period.
A credit note that was not raised from an invoice has no site to follow. Its product lines appear on a separate row for that product, labelled No fulfillment site or No site group.
Additional invoice charges
This section only applies when Include additional invoice charges in product value? is enabled. With it disabled, a product's rows across its sites or site groups always add up to its row when grouped by Product.
An additional charge sits on the invoice as a whole, so Breww spreads it across the products sold. How far it is spread depends on Group by:
- Product - each customer's charges in the period are spread across everything that customer bought in the period, whichever site fulfilled it.
- Product and fulfillment site - each customer's charges are spread only across what that customer bought from the same site as the invoice carrying the charge.
- Product and site group - each customer's charges are spread only across what that customer bought from sites in the same site group. A charge can still be shared between two sites in the same group.
In every case the spread is in proportion to the value of each product.
For example, a customer buys product X from site A for 100 and product Y from site B for 100 in the same period. The invoice from site B also carries a delivery charge of 20.
| Group by | Product X | Product Y | Total |
|---|---|---|---|
| Product | 110 | 110 | 220 |
| Product and fulfillment site | 100 (site A) | 120 (site B) | 220 |
Grouped by Product, both products share the charge because the same customer bought both. Grouped by Product and fulfillment site, the whole charge stays with site B, where it was invoiced. The report's total is 220 either way.
So with additional invoice charges included, expect the following:
- A product's Total value across its sites or site groups may not add up to its value when grouped by Product, and each row's Margin follows its own value. Quantity, volume and costs always add up.
- The total for the whole report is normally the same in all three options.
- The one exception is a charge on an invoice from a site, or site group, where that customer bought no products in the period, such as an invoice with a delivery charge and no product lines. There is nothing at that site to spread it across, so it is left out when grouping by site or site group. Grouping by Product still includes it, spread across that customer's sales from your other sites.
If a product's value looks different between the grouping options, run the report with Include additional invoice charges in product value? disabled. The product's rows then add up to its row when grouped by Product, so any difference you saw came from the additional charges.
Drilling into the cost of a product
The Actions column, and its button to open the COGS by stock item and utility/other cost report, only shows when Group by is Product. That report does not split its figures by site, so its breakdown would not match a row for a single site or site group. To see what a product's cost is made of, run the report grouped by Product and use the button from there.
Stock transfer orders
Stock transfer orders between your sites are controlled by Stock transfer orders to include, whichever grouping you choose. When they are included, a stock transfer order counts against the site the stock was transferred from.
Related
- Cost basis on margin reports - costing your sales at target instead of actual.
- COGS by stock item and utility/other cost report - which stock items and utility/other costs make up the cost of what you sold.
- Setting up multiple businesses within a single Breww account - site groups, and running more than one business in one account.
- Differences between product-level and invoice-level reports - why product and invoice reports can show different sales values.