Hi, Might be missing it, but looking for a total COGS report of a batch of beer/products that includes Duty (as some of it is exported and does not require duty to be paid). Thanks for the help

You could use one of the margin reports in “Pre-built Sales reports”. These will include the exact amount of duty paid. [Screenshot 2025-03-26 at 09.46.06]

yeah those are not what I am looking for as it is not batch/beer specific - so I need to start exporting to get the info needed. I would love to have a Margin by beer or batch or product (joining up all customers)

The only thing I could suggest for now is exporting “Margin by customer and product” and then, in Excel, grouping by product to give you an average for all the customers who’ve purchased (essentially removing the customers from the report). I’m not an Excel wizz, and if you’re not either, Chat GPT …

Would love this too, Gijs. Let me know if you put in a request as we will upvote it.

Hey Stu, it is already there in request section

COGS of batch/beer including duty?

Help & advice

matt-cousins 27 March 2025 14:13 7

(Margin by beer / batch / product)

Topic		Replies	Views
Reporting beer duty paid on products sold to a particular customer Help & advice	1	228	21 September 2023
Export your monthly Beer Duty breakdown into CSV/Excel Ideas & feature requests idea-completed	9	520	21 September 2023
Complete batch - invoice data export Ideas & feature requests	5	254	27 July 2021
Compare costs to produce batches of the same beer over time Ideas & feature requests	15	639	12 February 2024
Margin by beer / batch / product report Ideas & feature requests	0	50	26 March 2025

COGS of batch/beer including duty?

Related topics