r/winemaking • u/Fabulous_Koala_7848 • 1d ago
Free tool I built to calculate SPR bands and HMRC Alcohol Duty returns
Hey everyone,
Like a lot of you, I get an absolute headache every month trying to accurately track running production totals, map out Small Producer Relief (SPR) bands, and translate everything into the exact box orders HMRC asks for.
To make my own life easier, I built a web utility called Duty Sorted to calculate the math automatically. I’ve made a standalone version of the calculator 100% free and un-gated for the community—no sign-up or card required:
👉 [\[Link to your free calculator page\]](https://dutysorted.co.uk/spr-calculator/)
To show you how it breaks down messy edge cases, here is an example of it calculating a 5.5% draught beer batch (1,000 litres) for a producer nearing the threshold:
Tax Type Code: 356 (Beer from 3.5 to 8.4 percent, eligible for draught relief)
Pure Alcohol: 55.0000 litres
Full Rate: £19.45 per litre of pure alcohol
Duty Due: £1,069.75 (rounded down to the penny)
It even triggers alerts if your annual production crosses the 4,500 hl limit so you know exactly when SPR stops applying.
If you're a small cider maker, brewery, or distillery filing these monthly, I hope this saves you some spreadsheet math this month.
Check it out and let me know if you notice any weird edge cases with your specific tax codes—I want to keep updating it and making it better for the trade! 🍻
1
u/Friendly_Permit_7557 1d ago
oh nice, a tool that actually handles the draught relief calc properly instead of making you cross-reference three different PDFs and a prayer
my husband runs a tiny cidery and the SPR band tracking alone has me wanting to throw his laptop out the window during filing season. bookmarked this for next month
the 4,500 hl alert is smart, that's the kind of thing that sneaks up on you when you're too busy actually making the stuff to watch the running totals