# COGS of batch/beer including duty? **URL:** \ **Category:** Help & advice\ **Created:** [26 March 2025 08:46 UTC](https://community.breww.com/t/cogs-of-batch-beer-including-duty/5733 "2025-03-26T08:46:53Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![gijs-van-wiechen](https://community.breww.com/user_avatar/community.breww.com/gijs-van-wiechen/32/434_2.png) [@gijs-van-wiechen](https://community.breww.com/u/gijs-van-wiechen)\ **Post date:** [26 March 2025 08:46 UTC](https://community.breww.com/t/cogs-of-batch-beer-including-duty/5733/1 "2025-03-26T08:46:53Z")
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 ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [26 March 2025 09:48 UTC](https://community.breww.com/t/cogs-of-batch-beer-including-duty/5733/2 "2025-03-26T09:48:40Z")
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](https://breww-community.fra1.digitaloceanspaces.com/original/2X/8/8064ede7493d2b89828246fa02bbda1847f5777e.png) ---
**Author:** ![gijs-van-wiechen](https://community.breww.com/user_avatar/community.breww.com/gijs-van-wiechen/32/434_2.png) [@gijs-van-wiechen](https://community.breww.com/u/gijs-van-wiechen)\ **Post date:** [26 March 2025 09:53 UTC](https://community.breww.com/t/cogs-of-batch-beer-including-duty/5733/3 "2025-03-26T09:53:13Z")
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) ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [26 March 2025 10:15 UTC](https://community.breww.com/t/cogs-of-batch-beer-including-duty/5733/4 "2025-03-26T10:15:11Z")
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 is 😉 You can upload the exported file (keep it a small dataset to make it quicker) and ask it to convert the data for you. Or to provide the actual formula so you can create a template in Excel for regular use. ![Screenshot 2025-03-26 at 10.10.08](https://breww-community.fra1.digitaloceanspaces.com/original/2X/e/e9832bf7002b285ba90701144b341ec41f0f83c4.png) You can also of course post a feature request for a dedicated report. ---
**Author:** ![stu-mckinlay](https://community.breww.com/letter_avatar_proxy/v4/letter/s/ba8739/32.png) [@stu-mckinlay](https://community.breww.com/u/stu-mckinlay)\ **Post date:** [27 March 2025 13:48 UTC](https://community.breww.com/t/cogs-of-batch-beer-including-duty/5733/5 "2025-03-27T13:48:16Z")
Would love this too, Gijs. Let me know if you put in a request as we will upvote it. ---
**Author:** ![gijs-van-wiechen](https://community.breww.com/user_avatar/community.breww.com/gijs-van-wiechen/32/434_2.png) [@gijs-van-wiechen](https://community.breww.com/u/gijs-van-wiechen)\ **Post date:** [27 March 2025 14:03 UTC](https://community.breww.com/t/cogs-of-batch-beer-including-duty/5733/6 "2025-03-27T14:03:48Z")
Hey Stu, it is already there in request section ---
**Author:** ![matt-cousins](https://community.breww.com/user_avatar/community.breww.com/matt-cousins/32/3876_2.png) [@matt-cousins](https://community.breww.com/u/matt-cousins)\ **Post date:** [27 March 2025 14:13 UTC](https://community.breww.com/t/cogs-of-batch-beer-including-duty/5733/7 "2025-03-27T14:13:37Z")
([Margin by beer / batch / product](https://community.breww.com/t/margin-by-beer-batch-product/5738)) ---
**Author:** ![stu-mckinlay](https://community.breww.com/letter_avatar_proxy/v4/letter/s/ba8739/32.png) [@stu-mckinlay](https://community.breww.com/u/stu-mckinlay)\ **Post date:** [27 March 2025 14:20 UTC](https://community.breww.com/t/cogs-of-batch-beer-including-duty/5733/8 "2025-03-27T14:20:35Z")
Cheers… I’ve voted 👍