# \#reporting **URL:** https://community.breww.com/tag/reporting/51.md [Latest](https://community.breww.com/latest.md) · [Categories](https://community.breww.com/categories.md) · [Tags](https://community.breww.com/tags.md) --- ## [New Zealand alcohol excise duty calculations are here](https://community.breww.com/t/new-zealand-alcohol-excise-duty-calculations-are-here/7307)
**Author:** [@max](https://community.breww.com/u/max)\ **Replies:** 3\ **Last updated:** [22 October 2026 00:33 UTC](https://community.breww.com/t/new-zealand-alcohol-excise-duty-calculations-are-here/7307 "2026-10-22T00:33:51Z")
We’re delighted to announce that Breww now calculates New Zealand alcohol excise duty and the Health Promotion Agency levy for you! Head to the Excise duty tab on the left-hand menu, pick the period you’re reporting on, … --- ## [New pre-built report: COGS by stock item and utility/other cost](https://community.breww.com/t/new-pre-built-report-cogs-by-stock-item-and-utility-other-cost/7450)
**Author:** [@max](https://community.breww.com/u/max)\ **Replies:** 0\ **Last updated:** [14 October 2026 10:12 UTC](https://community.breww.com/t/new-pre-built-report-cogs-by-stock-item-and-utility-other-cost/7450 "2026-10-14T10:12:05Z")
We’ve added a new COGS by stock item and utility/other cost report, so you can see exactly what your cost of goods sold is made of. You’ll find it under Reporting → Sales → Margin & profitability. Pick a period, and you… --- ## [New pre-built report: Margin by product](https://community.breww.com/t/new-pre-built-report-margin-by-product/7302)
**Author:** [@max](https://community.breww.com/u/max)\ **Replies:** 0\ **Last updated:** [14 August 2026 11:38 UTC](https://community.breww.com/t/new-pre-built-report-margin-by-product/7302 "2026-08-14T11:38:03Z")
We’ve added a new Margin by product report - a simplified version of our Margin by customer and product report! You’ll find it under Reporting → Sales → Margin & profitability. Pick a period, and you get one row per pro… --- ## [How to add a second beer duty reference number for different site](https://community.breww.com/t/how-to-add-a-second-beer-duty-reference-number-for-different-site/5409)
**Author:** [@karl-durand-oconnor](https://community.breww.com/u/karl-durand-oconnor)\ **Replies:** 4\ **Last updated:** [6 July 2026 17:54 UTC](https://community.breww.com/t/how-to-add-a-second-beer-duty-reference-number-for-different-site/5409 "2026-07-06T17:54:19Z")
I’ve followed directions on setting up second site group / site, but can’t find a way to edit beer duty reference number. Settings for Beer Duty doesn’t seem to allow for second set of credientials. --- ## [Keg QR codes print](https://community.breww.com/t/keg-qr-codes-print/6640)
**Author:** [@gabriela-celebrone](https://community.breww.com/u/gabriela-celebrone)\ **Replies:** 0\ **Last updated:** [25 March 2026 11:28 UTC](https://community.breww.com/t/keg-qr-codes-print/6640 "2026-03-25T11:28:23Z")
Hi, Any advice on how to send those out to print in Ireland? Water repellent stickers. Thanks in advance. --- ## [Returns by product and batch](https://community.breww.com/t/returns-by-product-and-batch/6435)
**Author:** [@dan-guyatt](https://community.breww.com/u/dan-guyatt)\ **Replies:** 1\ **Last updated:** [5 November 2025 10:42 UTC](https://community.breww.com/t/returns-by-product-and-batch/6435 "2025-11-05T10:42:28Z")
I’m looking for a report or data explorer ideally that shows quantites of returns by product and batch. Does this exist and can anyone tell me where to find it? Thanks --- ## [Dashboard customisation with custom KPIs & reports](https://community.breww.com/t/dashboard-customisation-with-custom-kpis-reports/979)
**Author:** [@chris-macdonald](https://community.breww.com/u/chris-macdonald)\ **Replies:** 37\ **Last updated:** [24 October 2025 08:57 UTC](https://community.breww.com/t/dashboard-customisation-with-custom-kpis-reports/979 "2025-10-24T08:57:24Z")
It would be great to be able to see the total number of Sales Order Revenue for the entire Year or per Quarter on the main dashboard page. Potentially a new dropdown for you to switch between different time periods (Yea… --- ## [Quality Control Stock Levels](https://community.breww.com/t/quality-control-stock-levels/6406)
**Author:** [@nick-colaccino](https://community.breww.com/u/nick-colaccino)\ **Replies:** 1\ **Last updated:** [17 October 2025 13:18 UTC](https://community.breww.com/t/quality-control-stock-levels/6406 "2025-10-17T13:18:23Z")
How is everyone accounting for quality control stock in their facilities? Right now, we have QC set as a “location” within our “brewery” site, but there isn’t a way to stop products in the QC “location” from being added … --- ## [Exporting a report to excel and opening in google sheets opens an old report](https://community.breww.com/t/exporting-a-report-to-excel-and-opening-in-google-sheets-opens-an-old-report/6070)
**Author:** [@oliver-hurlow](https://community.breww.com/u/oliver-hurlow)\ **Replies:** 3\ **Last updated:** [1 July 2025 08:49 UTC](https://community.breww.com/t/exporting-a-report-to-excel-and-opening-in-google-sheets-opens-an-old-report/6070 "2025-07-01T08:49:37Z")
When exporting the All Sales report for custom dates, I often find an old version of the report being loaded when opening the export. I’m using chrome, running on a chromebook, so I’m wondering if the limited excel vers… --- ## [How to fill a keg partially to ensure proper reporting?](https://community.breww.com/t/how-to-fill-a-keg-partially-to-ensure-proper-reporting/2924)
**Author:** [@landon-swanson](https://community.breww.com/u/landon-swanson)\ **Replies:** 3\ **Last updated:** [4 June 2025 10:14 UTC](https://community.breww.com/t/how-to-fill-a-keg-partially-to-ensure-proper-reporting/2924 "2025-06-04T10:14:55Z")
When we package a beer we fill kegs until the brite is empty. This often leads us with an amount of beer that we doesn’t fully fill a keg. We take the partially filled keg and serve it out of our tasting room. Is ther… --- ## [Vat Number display on sales reports and invoices](https://community.breww.com/t/vat-number-display-on-sales-reports-and-invoices/5938)
**Author:** [@jay-pollard](https://community.breww.com/u/jay-pollard)\ **Replies:** 2\ **Last updated:** [22 May 2025 06:46 UTC](https://community.breww.com/t/vat-number-display-on-sales-reports-and-invoices/5938 "2025-05-22T06:46:00Z")
Hi there, Our accountant has asked us to provide VAT numbers attached to the sales report for our quarterly VAT report. Is there a way of including that? Also some of our customers have asked for their VAT number to be… --- ## [Stock Item Usage Report](https://community.breww.com/t/stock-item-usage-report/5241)
**Author:** [@zane-hechter](https://community.breww.com/u/zane-hechter)\ **Replies:** 3\ **Last updated:** [21 May 2025 13:00 UTC](https://community.breww.com/t/stock-item-usage-report/5241 "2025-05-21T13:00:16Z")
Outside of creating a completed packaging report, is there a report or can I generate a report that will show me how much of each stock item have purchased during the year? i.e. How much malt was purchased YTD, how many … --- ## [Product list by beer](https://community.breww.com/t/product-list-by-beer/5924)
**Author:** [@ana-cardadeiro](https://community.breww.com/u/ana-cardadeiro)\ **Replies:** 4\ **Last updated:** [19 May 2025 16:06 UTC](https://community.breww.com/t/product-list-by-beer/5924 "2025-05-19T16:06:32Z")
hey, is there a way to export a list of products with their corresponding beer? for example something like Beer | Product IPA X | IPA A - Can 440ml IPA X | Keg 30L IPA X | Keg 50L … even better would be a wa… --- ## [Raw data explorer available fields](https://community.breww.com/t/raw-data-explorer-available-fields/5803)
**Author:** [@ana-cardadeiro](https://community.breww.com/u/ana-cardadeiro)\ **Replies:** 3\ **Last updated:** [9 April 2025 14:41 UTC](https://community.breww.com/t/raw-data-explorer-available-fields/5803 "2025-04-09T14:41:48Z")
Hi, how do I get a list of all data fields available in raw data explorer without having to scroll down on the dropdown list? --- ## [US State Excise Tax report](https://community.breww.com/t/us-state-excise-tax-report/5791)
**Author:** [@james-coulter](https://community.breww.com/u/james-coulter)\ **Replies:** 1\ **Last updated:** [8 April 2025 19:59 UTC](https://community.breww.com/t/us-state-excise-tax-report/5791 "2025-04-08T19:59:24Z")
Seeing if there is any support for local state excise tax? Primarily looking to get a report of products currently inventory for a specific time period, similar to “beer produced (rackings)” report. --- ## [Comparative data in reports](https://community.breww.com/t/comparative-data-in-reports/473)
**Author:** [@john-cussons](https://community.breww.com/u/john-cussons)\ **Replies:** 3\ **Last updated:** [2 April 2025 07:42 UTC](https://community.breww.com/t/comparative-data-in-reports/473 "2025-04-02T07:42:27Z")
Hi Is it planned to include the ability to add comparative data to reports. e.g. great being able to look at sales for last month or last six months but much more useful if on the same graph and table I can plot that ag… --- ## [Managing Brewery / Taproom Product Inventory and Stock Valuations](https://community.breww.com/t/managing-brewery-taproom-product-inventory-and-stock-valuations/5672)
**Author:** [@katherine-gooding](https://community.breww.com/u/katherine-gooding)\ **Replies:** 0\ **Last updated:** [10 March 2025 20:25 UTC](https://community.breww.com/t/managing-brewery-taproom-product-inventory-and-stock-valuations/5672 "2025-03-10T20:25:34Z")
Hello, I have been using Breww for a few months now. We have a tasting room in the brewery. I have been raising invoices for kegs that are pouring in the tasting room, but this process has not been working too well. Beer… --- ## [Duty for draft and take home sold through brewery bar/shop](https://community.breww.com/t/duty-for-draft-and-take-home-sold-through-brewery-bar-shop/5551)
**Author:** [@william-king](https://community.breww.com/u/william-king)\ **Replies:** 1\ **Last updated:** [6 February 2025 17:09 UTC](https://community.breww.com/t/duty-for-draft-and-take-home-sold-through-brewery-bar-shop/5551 "2025-02-06T17:09:49Z")
Just about to change from Brewman to Breww and trying to get my head around duty for sales of draft pints sold in our brewery bar and growlers filled from the same cask/keg. Thinking of creating a bonded site - Brewery … --- ## [Shopify API problem](https://community.breww.com/t/shopify-api-problem/5506)
**Author:** [@ondrej-rafaj](https://community.breww.com/u/ondrej-rafaj)\ **Replies:** 1\ **Last updated:** [28 January 2025 20:49 UTC](https://community.breww.com/t/shopify-api-problem/5506 "2025-01-28T20:49:37Z")
Got this email today, what is the best way to tackle please? --- ## [Reports and alcohol sold](https://community.breww.com/t/reports-and-alcohol-sold/5441)
**Author:** [@jay-pollard](https://community.breww.com/u/jay-pollard)\ **Replies:** 1\ **Last updated:** [17 January 2025 15:07 UTC](https://community.breww.com/t/reports-and-alcohol-sold/5441 "2025-01-17T15:07:33Z")
Hi there, I have just started with breww. I need to be able to report the amount of pure alcohol sold for excise in Denmark Ive been looking at reports for products sold or products produced but I cant seem to find th… --- ## [Edit the Complete batch](https://community.breww.com/t/edit-the-complete-batch/5387)
**Author:** [@pak-long-brian-hung](https://community.breww.com/u/pak-long-brian-hung)\ **Replies:** 1\ **Last updated:** [7 January 2025 12:19 UTC](https://community.breww.com/t/edit-the-complete-batch/5387 "2025-01-07T12:19:36Z")
Hi Breww. Can i edit the complete batch to add missing ingredients ? Hi Christopher, Thanks for posting on the community! You can add extra ingredients to a batch (complete or incomplete) by going to the batch’s page a… --- ## [Stock position correction](https://community.breww.com/t/stock-position-correction/5345)
**Author:** [@jonny-shire](https://community.breww.com/u/jonny-shire)\ **Replies:** 8\ **Last updated:** [19 December 2024 12:24 UTC](https://community.breww.com/t/stock-position-correction/5345 "2024-12-19T12:24:58Z")
Hi there! We’re going through a total stock reconciliation in January and we have some stock positions which have been managed in a slightly less than favourable way. Is there any way to manually override stock amounts … --- ## [Open and Under Receipted Purchase Orders Report](https://community.breww.com/t/open-and-under-receipted-purchase-orders-report/5025)
**Author:** [@jonny-shire](https://community.breww.com/u/jonny-shire)\ **Replies:** 6\ **Last updated:** [17 October 2024 12:09 UTC](https://community.breww.com/t/open-and-under-receipted-purchase-orders-report/5025 "2024-10-17T12:09:59Z")
I am trying to pull a daily report on Open or partially fulfilled P.O’s which includes their P.O number, Net Value, Unit Amount, Stock Type, Expected Delivery Date, Order Placed Date, Person who placed the order, and Sup… --- ## [SIBA Beerflex self bill; order references not found in Breww](https://community.breww.com/t/siba-beerflex-self-bill-order-references-not-found-in-breww/5013)
**Author:** [@max-sawyer](https://community.breww.com/u/max-sawyer)\ **Replies:** 1\ **Last updated:** [10 October 2024 09:03 UTC](https://community.breww.com/t/siba-beerflex-self-bill-order-references-not-found-in-breww/5013 "2024-10-10T09:03:01Z")
The self bill invoice from SIBA Beerflex refers to their order number (DDS), which is 7 digits long, these DDS numbers are not being found when importing/uploading the self billing invoice into Breww. I can see the DDS … --- ## [Cost Report Planned Vs packed](https://community.breww.com/t/cost-report-planned-vs-packed/4935)
**Author:** [@jared-stewart](https://community.breww.com/u/jared-stewart)\ **Replies:** 1\ **Last updated:** [23 September 2024 10:00 UTC](https://community.breww.com/t/cost-report-planned-vs-packed/4935 "2024-09-23T10:00:55Z")
Need to understand how the cost is reported, eg planned batch 2050L - Batch total 1950L - packed 1550L. will Breww take in to account the loss from batch total to packed and add cost. we need to get better with actual v… --- ## [Report of customer's sales history](https://community.breww.com/t/report-of-customers-sales-history/4917)
**Author:** [@bob-cary](https://community.breww.com/u/bob-cary)\ **Replies:** 2\ **Last updated:** [18 September 2024 11:32 UTC](https://community.breww.com/t/report-of-customers-sales-history/4917 "2024-09-18T11:32:29Z")
Hi Can anyone tell me how to pull a report that charts a customer’s sales history broken down by week or month? I just want to look at the pattern of sales to any customer, to see whether sales have increased or decre… --- ## [Reporting on Beer/Packaging Type, not Product Name](https://community.breww.com/t/reporting-on-beer-packaging-type-not-product-name/4619)
**Author:** [@oliver-hurlow](https://community.breww.com/u/oliver-hurlow)\ **Replies:** 2\ **Last updated:** [11 July 2024 16:26 UTC](https://community.breww.com/t/reporting-on-beer-packaging-type-not-product-name/4619 "2024-07-11T16:26:24Z")
I’d like to be able to report on the number of units sold each month of each beer brand by packaging type. Currently I do this by Products sold (order lines) in the Raw Data Explorer, but that pulls data by product name,… --- ## [Delivery Locations Mapped Out](https://community.breww.com/t/delivery-locations-mapped-out/4030)
**Author:** [@johanna-quinn](https://community.breww.com/u/johanna-quinn)\ **Replies:** 2\ **Last updated:** [5 March 2024 17:06 UTC](https://community.breww.com/t/delivery-locations-mapped-out/4030 "2024-03-05T17:06:50Z")
Is there a way to see all locations in our customer database on a map? We want to be able to share the map with our team so they can share where our beer is sold. --- ## [Product Stock Levels Over Time Report](https://community.breww.com/t/product-stock-levels-over-time-report/3866)
**Author:** [@adam-henderson](https://community.breww.com/u/adam-henderson)\ **Replies:** 2\ **Last updated:** [5 February 2024 13:23 UTC](https://community.breww.com/t/product-stock-levels-over-time-report/3866 "2024-02-05T13:23:07Z")
Hi, I am trying to pull some data together that shows product stock levels over time for each beer. i.e. How many kegs or cans of each beers in stock was available on xx/xx/xx. There are similar reports for inventory s… --- ## [Reporting on Total Sales Volume](https://community.breww.com/t/reporting-on-total-sales-volume/3166)
**Author:** [@oliver-hurlow](https://community.breww.com/u/oliver-hurlow)\ **Replies:** 3\ **Last updated:** [18 January 2024 09:58 UTC](https://community.breww.com/t/reporting-on-total-sales-volume/3166 "2024-01-18T09:58:48Z")
Is there an option to report on total sales volume by beer brand? I can only seem to build reports that split data by product, which becomes difficult when we have several different products using each beer. Being able … [Next page](https://community.breww.com/tag/reporting/51.md?match_all_tags=true&page=1&tags%5B%5D=reporting)