Differences between product-level and invoice-level reports

There are several pre-built sales reports in Breww that you can access from our Reporting suite. These reports enable you to assess your sales data quickly and report on a specified date range.

There are two different categories that our sales reports fall into, product-level reports and invoice-level reports. These reports have key differences to consider when determining which sales report would work best for you. To determine whether a report is product or invoice level, you'll want to look at each line in the report, is each line representing an invoice line/product/aggregation of invoice lines or is it representing the whole invoice?

Product-level reports

Examples include Sales revenue/Litres sold by beer report and Products sold (order lines) reports.

Product-level reports take the sale value of the order line calculating the report, which doesn't include invoice-level charges/discounts such as delivery charges or credit notes applied. This is because a charge/discount on the invoice total doesn't have any reflection on the value of each product on order itself, which is where this report is drawing its data from. The sale value of product does include discounts/increases applied to the product directly, be it on the invoice or via a price book.

Invoice-level reports

Examples include the Total sales by customer and Sales (orders/invoices) reports.

Unlike product-level reports, Breww is looking at the total value of the invoice here. As invoice-level charges/discounts are applied to the invoice as a whole, these will be included in these reports.

There is one exception: non-revenue invoice-level charges are excluded from invoice-level revenue figures. In practice, this means container deposits from a deposit scheme that's set not to count deposit charges as revenue. The deposit is still charged to your customer and still included in the order's total, but it isn't reported as revenue.