Deposit Return Scheme (DRS)

Well. I think it should be an option - as you can register yourself as a return point - which might be applicable for bigger breweries or breweries that do a lot of on site sales (we have to pay/charge deposits on the cans we sell in our pub, takeaway and webshop as well).

I have another info session today actually - will share the info once I have an english version

2 Likes

I just realised today that when working with this make sure the deposits are customisable on client level.

As in you can select for which products the customer is liable for deposits.

2 Likes

Thanks Gijs. Previously, I had noted down the following for the rules to determine if the deposit should be applied could be:

Would this cover what you need (would you be able to fit your customers into customer groups to help ensure only the correct deposits are applied)? Or would this truly be needed at the customer level as this sounds like a lot of work for you to choose on a per-customer basis?

1 Like

It is more that you can uncheck some boxes on client level.

This occured to me as I will have at least one bar I have the agreement with not to charge for the deposits of kegs, but will have to charge the can deposits to in the future (as that is not voluntary)

I would rather not separate it out on type level as that muddles other reporting.

2 Likes

Hi Luke,

The english version of the second session is now available in the drive.

2 Likes

Hi
I’m actually at the 2 day Deposit Return Scheme conference in Glasgow at the moment. Hazel has done a good job and flagging some of the issues and needs of brewers. I would raise a couple of things that I have picked up:

  1. The VAT issue is not resolved yet and so I would suggest that in building anything you ensure that VAT can be set for the deposits separately to the main system as this may not be resolved very quickly

  2. Producing data on your own customers is one thing and what has been suggested above is very sensible and we must display and show the deposits as a seperate line item. However the issue facing us is managing our trade customers that then sell to Scotland. They may well not know (especially if they are online sellers) how much they are going to sell in Scotland so we will need to get data back from them each month how much they have sold to Scotland. We will then have to bill them for the deposits for what they have sold. So this means I think we will need a flag in the system that says this is a customer that has said they sell to Scotland. We then need to be able to add the data we receive from them to generate the deposits invoice. This data then needs to be added to the report which picks up our own customers so that we can send a combined report to Circularity Scotland.

I hope that the above makes sense and happy to be involved going forward. It would also be worth talking to SIBA who have a wealth of knowledge between Barry Watts and Jamie at Fyne Ales in Scotland

2 Likes

I’m also at the conference in Glasgow and have picked up a lot more insight into the requirements for go live which I can summarise later.

2 Likes

Hi sorry for delay in answering your questions. I think there is a bit potential to over complicate this but equally there are lots of factors to consider particularly because none of the systems are identical. It is inevitable that the Scottish and rUK systems will not be aligned (size of deposit, articles included etc). And the Netherlands is different still! I would recommend a small working group to be represented by the various schemes to see if we can get something simple enough that would be customisable as required by each geography? I have much more insight following the conference in Glasgow this week and would be happy to contribute.

2 Likes

Hi Luke,

What is the status of this project?

It is gathering momentum here. There is a hard start april 1st.

Some things I thought about:

  • We should be able to generate reports that includes the EAN codes (as this is the reference used for the registering of the DSR

  • I am currently already experiencing some logistical issues with deposits being handled as a credit note (some customers are annoyed they have a separate step in their admin, others forget they have them at all) - so a way to include these on an invoice would be a great feature.

I am also very keen in developing this with you for the dutch market (I sent quite an influential brewery your way - I am hesitant to broadcast Breww currently due to this issue).

That being said happy holidays :slight_smile:

2 Likes

Thanks for the reply, Gijs, I hope you had a good break and thanks for the recommendation - it’s very much appreciated.

This is certainly a key project for us to get to soon, but it’s not been started yet. We don’t have a specific start date for it at the moment, but don’t worry, it’s very much on the radar and will be started soon!

2 Likes

We’re also looking at how to grab the data we need to handle monthly reporting to DRS.

So far, we’ve tagged our customers who are in Scotland, so we can run a report as to what type of units were sold to them. What we’re missing is a Containers Sold report - something that shows all the individual containers and their taxable volumes sold within a filterable period. Or, additional fields in the Products Sold (order lines) report, that can add Product->Container Type->Taxable Volume, and Product->Packaged Beer->Quantity.

For things like mixed-packs and multipacks there isn’t an easy way for us, even in excel, to grab or report this information - especially if a multi-pack contains different sized cans and/or bottles - without a massive lookup table. Or, allowing us to create a duplicate multi-pack with a different product code / EAN with the deposit value applied to it. That way we can disassemble and assemble the Scotland only products as required.

The data appears to be available, various reports have bits of it, but what we need is something unified that we can schedule to be sent to our reporting person weekly or monthly.

2 Likes

I have just added the english presentation of the last session to the folder @luke

2 Likes

Thanks every for your input on this, it’s been invaluable. We’re expecting to start this project very soon and will let you know when we know more, or if we have any further questions :+1:

2 Likes

great to hear. Another presentation is in the folder @luke

2 Likes

D-day (meaning deposit day in this context) is approaching quite rapidly now - we will start implementing it from the 27th of march. Any updates on the Breww front?

2 Likes

Yes, we’re making good progress on a tool for managing this :smile:

This is a very busy month for us as we will be at BeerX on 15-16th and there’s quite a bit of prep involved as we’re a main sponsor. We’re expecting to have the first version of this tool in place before your D-day, which will allow you to automatically add bottle deposits to orders, track how many you have charged and allow you to generate the reports that you need.

We don’t expect to have “returnable” deposits completed before the end of the month, so you won’t be able to use this for your own internal keg deposits this month, but hopefully that part won’t be far behind and will build on the work we’ve done for the first part of this project.

2 Likes

Goods news, everyone, this is now deployed and ready to use :tada:

We’ll keep this feature request open until we’ve completed the final bits for managing internal keg deposit schemes, but we should be good for the Netherlands and Scottish schemes.

2 Likes

This is so superbly awesome! You won’t believe how much work this is going to save us.

Initial stuff:

  • for Internal use I “sell” my cans to our brewpub and webshop but won’t actually charge the deposit to myself (we do to customers of course) - I do need these on the report though to the authorities - If it is included in a pricebook that would be great…
  • this price book feature would also work for internal deposits you decide not to charge to specific customers
3 Likes

Thanks, Gijs, we really appreciate the positive feedback - thank you!

We can see what you’re looking for here with these extras and will see what we can do for you :+1: We’ll get back to you shortly with an update.

2 Likes

It’s your lucky day, Gijs :smile: We’ve managed to push this through for you as we know we’re going to be extra busy next week.

You can now filter on price books when setting up the rules of who should be included in the scheme. If a customer is filtered out using these rules, this will mean that they are excluded from the scheme completely (and so not included in reporting). This should work for keeping some customers out of your internal keg deposit scheme, for example. We can add other filtering options here too, if you’d find them useful?

In addition, we’ve added the ability to choose specific customers that should be included in the scheme for reporting purposes but not be charged anything on their invoices. You’ll still see a “greyed out” line where the deposit would be on the order page in Breww, so you know that they’ve been accounted for in the scheme, but the value will be £/€0.00.

2 Likes