# Beer excise duty in Australia

**URL:** <https://community.breww.com/t/beer-excise-duty-in-australia/1973>\
**Category:** Ideas & feature requests\
**Tags:** idea-completed\
**Created:** [16 January 2023 05:37 UTC](https://community.breww.com/t/beer-excise-duty-in-australia/1973 "2023-01-16T05:37:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![joan-odonnell](https://community.breww.com/user_avatar/community.breww.com/joan-odonnell/32/1305_2.png) [@joan-odonnell](https://community.breww.com/u/joan-odonnell)\
**Post date:** [16 January 2023 05:37 UTC](https://community.breww.com/t/beer-excise-duty-in-australia/1973/1 "2023-01-16T05:37:51Z")

</div>

In short, could you arrange that the Product ABV field be available data in the report called “Products sold (order lines) data explorer input options”?

In Australia, Excise payable is calculated on the total volume of alcohol sold not on individual products. Each month, we total up all types of products sold, and apply the excise calculation to work out the litres of alcohol (LALs), then apply appropriate code and rate for the particular type of alcohol and size/type of vessels.

To calculate the Lals we need the ABV on each product sold.

FYI the LALs calc is =(TRUNC(SUM(ABV-1.15)%\*(Total Volume),1))

FYI the rate/codes and types are listed here on the ATO website ([https://www.ato.gov.au/business/excise-on-alcohol/lodging,-paying-and-rates---excisable-alcohol/excise-duty-rates-for-alcohol/](https://www.ato.gov.au/business/excise-on-alcohol/lodging,-paying-and-rates---excisable-alcohol/excise-duty-rates-for-alcohol/))

This would reduce our reporting effort in Oz.

---

<div class="post-metadata">

**Author:** ![luke](https://community.breww.com/user_avatar/community.breww.com/luke/32/3636_2.png) [@luke](https://community.breww.com/u/luke)\
**Post date:** [19 January 2023 16:14 UTC](https://community.breww.com/t/beer-excise-duty-in-australia/1973/2 "2023-01-19T16:14:42Z")

</div>

Thanks for the suggestion, Joan. For most products, this should be fairly simple to add, but how would you like the ABV to show for a mixed-pack of multiple beers at differing ABVs. Would a “weighted ABV” work?

For example, if you had a mixed pack of:

- 3 x 440ml cans of 4% ABV
- 3 x 440ml cans of 5% ABV

This would have a weighted ABV of 4.5%.

A more complex example would be a mixed pack of:

- 2 x 440ml cans of 4% ABV
- 4 x 440ml cans of 5% ABV

Resulting in a weighted ABV of 4.67%

If ABVs calculated in this way showed as the ABV for mixed-pack products, would this work for you?

---

<div class="post-metadata">

**Author:** ![joan-odonnell](https://community.breww.com/user_avatar/community.breww.com/joan-odonnell/32/1305_2.png) [@joan-odonnell](https://community.breww.com/u/joan-odonnell)\
**Post date:** [31 January 2023 21:51 UTC](https://community.breww.com/t/beer-excise-duty-in-australia/1973/3 "2023-01-31T21:51:35Z")

</div>

Hi Luke, I replied privately with examples. regards Joan

---

<div class="post-metadata">

**Author:** ![max](https://community.breww.com/user_avatar/community.breww.com/max/32/232_2.png) [@max](https://community.breww.com/u/max)\
**Post date:** [6 December 2023 11:40 UTC](https://community.breww.com/t/beer-excise-duty-in-australia/1973/5 "2023-12-06T11:40:19Z")

</div>

Great news - Australian excise duty calculations are now live! 🎉

You can read more in our guide below:

> [@Australian Beer Excise Duty](https://community.breww.com/t/australian-beer-excise-duty/3548):
>
> Breww can quickly and accurately calculate beer excise duty for Australian breweries. To run your report for a given month, simply click the Excise duty tab on the left-hand menu and enter the date range you’d like to report on. Breww will then generate your excise duty totals, showing you the LALs and excise amount owed per tariff. You’ll also see a high-level breakdown showing the total quantity and volume of each beer, container type and ABV combination that became both payable and reclaimab…

But please let us know your thoughts and feedback, and we hope this helps save you hours every month!

---

<div class="post-metadata">

**Author:** ![max](https://community.breww.com/user_avatar/community.breww.com/max/32/232_2.png) [@max](https://community.breww.com/u/max)\
**Post date:** [13 December 2023 11:41 UTC](https://community.breww.com/t/beer-excise-duty-in-australia/1973/6 "2023-12-13T11:41:02Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.