We are relatively new to Breww and have been grappling with the way to handle retail sales through our brewery shop and taproom. As suggested we have been raising invoices to the shop & tap to take stock from our bonded at zero cost for beer duty purposes. We use EposNow for our POS system and have been raising separate invoices through Xero for these sales. This creates the potential problem of duplicating invoice numbers within Xero so to try and combat this we have been reserving a bank of numbers in Xero purely for these invoices. This is all a bit of a hack and not ideal to manage. It would be interesting to hear how others manage this.
As an alternative approach would it be possible to create a non-bonded location for the shop & taproom and transfer stock to there taking care of the beer duty requirement, then put sales through Breww allocating the stock from the shop & tap stock (i.e. duty paid)?
Yes, your alternative approach is definitely a possibility. In addition to this, we have integrations available with Square and Zettle, where invoices can be automatically brought into Breww (and synced with Xero) and stock to be automatically taken from your non-bonded site.
Is there any intention to set up an integration with EposNow?
Yes, we’re going to start building our EposNow integration very soon.
I don’t have an exact date for you, but this is high on our list, so it shouldn’t be too long
Do you think Stripe would be in the pipeline? It would be great to use Stripe terminal and not another payment gateway as we already use Stripe for WooCommerce.
Yes, potentially. We’re working on our payment platform at the moment and hope to add Stripe Terminal to that but I can’t say for sure at this stage. If we can support Stripe Terminal, this will almost certainly come with a later release.
Would you also be looking for a POS platform that’s built into Breww to input orders in a more-POS-like way? Or is the current order entry screen all good, you’d just like to take in-person payments with it?
Yes, a POS platform would be great. To then use Stripe terminal device like Square or Zettle. Having the ability to have a Stripe button for customers to pay their invoices would be great too!
Hi There. Just wondering if there was any update of the possibility of EposNow integration?
I’m afraid we don’t have an update on EposNow. It is certainly an integration we want to build, but we just haven’t gotten around to it yet. I’ve created a formal feature request for it, here, which you can vote for. If you make sure you’re ‘watching’ the post, you’ll be notified when there’s an update (you can ‘watch’ the post by scrolling to the bottom and clicking ‘Tracking’ and changing it to ‘Watching’).
Forgive me for jumping onto this thread but I hope our issues will help others who are interested in the Bar/Tap room set-up.
We have a tap room where we sell our beer from our Brite tanks. We also do small pack and send kegs out to customers. Both the small pack and kegs are taken from the Brites (BBT).
So we take the easy route and ‘sell’ our beer (for free) to the tap room once it is in the BBTs, carbonated and conditioned (ie ready for drinking). This deals with duty for the whole tank, meaning when we drop beer to small packs or kegs, we have already paid duty,
So far so good! Not economically smart but easier for us to handle and less open for mistakes. We do use Xero and Square but find dealing with the INV numbers and endless duplication of sales is too time consuming, so keep the tap room sales (via Square) separate from the brewery side in Breww.
What I’d like to figure out is a way to drop kegs from the BBT’s in the tap room and still run them through Breww for tracking purposes’, keeping all the customers’ details within Breww. I realise this is a bit of ‘wanting best of both worlds’, but is it possible? Do I need to set up the tap-room as a second site, sell the beer from the brewery to the tap, and then distribute kegs from the tap room ‘site’?
Hi Simon, great idea. Hopefully, others will benefit from this too. You will have to correct me if I have misunderstood, but it sounds like you rack pints and kegs directly from a BBT but only want to track the kegs individually, not the pints.
This is a slightly tricky one, but the only way I think you could do this without tracking pints would be to manage each Brite tank after its volume was fully sold. Then you could rack the required kegs from it and track them. You would then sell the whole rest of the Brite tank volume, knowing it’s gone into pints.
Let me know if that covers the issue you are having.
Thanks for the response but in our case this solution wouldn’t work. For example, in a month we may be serving pints from the Brite to the tap room, and half way through the month we get an order for a keg for instance. We drop the beer from the BBT to the keg for the sale. I’d like then to be able to track this keg as it leaves the brewery and eventually returns. If I simply increase my keg stock by ‘filling’ a keg and process it this way, I end up paying duty twice…once on the BBT and then again on the keg, Does that help clarify?
Ah, I see! In this circumstance, there is not really a workaround I can suggest. The problem is essentially that to be able to work with kegs you rack from BBT and Pints in the taproom; you would have to track both in Breww, meaning reconnecting the taproom sales, as Breww cannot partially track what happens to the volume from the Brite tank.
You are correct in that if you create a stock adjustment to sell a keg, you would be charged duty on this sale, you could get around that by performing a duty adjustment to account for that, but that would be extra work. I would also suggest this leaves you open to overpaying duty if anything is missed. The other downside would be that your production and sales figures reported would be false, as you would have told Breww that an additional volume had been created and sold from that batch.
Hmm, maybe the work around is not to sell the BBT to the tap room, but rather rack he BBT volume into ‘ghost’ kegs and sell these one at a time to the tap room as beer is pulled from the taps (ie every 50L pulled, sell another ghost 50L keg). Then Breww would have a stock of ‘kegs’ that could be sold externally too?
Yes, that could work. If you’re happy to have these ‘ghost’ kegs in Breww and don’t think they would cause confusion within your team, then this would be an option.
Looking at the best way to set up our tap / shop in Breww, from reading this thread it seems setting it up as a separate ‘location’ in Breww is the way forward. Can anyone help answer a few questions I have around this?
Can we direct web-shop sales (shopify) to be fulfilled from this location only?
If we can, i’d like available stock shown on the webshop to still sync from main site, rather than the shop/tap location?
I guess it would need reconciling by generating a bulk order / sale every now and again against our stock take? otherwise stock will just pile up in this location.
Also here looking for info on how to use Breww for a tap room set-up.
I can see the community descriptions of their particular workarounds but is there a helpfile or overview or anything describing how a tap room product usage can be managed in Breww?
I can see the first poster says “as suggested he’s…” but can’t find where those suggestions are, please point me in the right direction.
We have integrations with Shopify POS and also Stripe. Considering setting up the draught options (pintA, halfB etc etc) as POS options which then places the order and manages payment in Breww but don’t want to go down that route if there is a different/better way using either locations or invoicing so tap stock duty paid etc.
Following the the other two most recent posts, I also would like to understand how to operate taproom/bar sales within Breww using the Square integration.
We use Shopify for our webshop with no issue but we use Square for our retail sales at markets and on our mobile bar, which is where we are having issues.
The smallpack sales at markets are easily tracked and can be product mapped, however I have recently traded at an event and now have 132 transactions that I cannot map to anything and therefore are showing as exceptions in my integration. Previously I would sell the keg to ourselves through an invoice on Breww and charge £0, but this was before we integrated Square and previously it wouldn’t pull through any of the transactions to Breww. As Breww is now pulling through these transactions, I would like to be able transfer the kegs used to another “site” (resulting in duty needing to be paid), then be able to create a product type such as “Beer name - Pint”/“Beer name - Half Pint”, which I can product map. Therefore paying duty on the keg that has been transferred to the other location, but being able to manage the transactions without exceptions.
My main questions are:
- After creating a new site, how do you move kegs to that site, ensuring duty is paid on the bonded site?
- Can you create products for draught items, to enable product mapping and how would you go about this? (I would like to be able to track sales based on this if possible)
Thanks in advance,
No problem. We have an article on Taproom & POS management in Breww which goes into this in some depth, so it would be well worth a read. Essentially we, in general, would still recommend selling it to the taproom and using service products to track individual sales. There are a couple of bits which are pretty relevant to your question in that article, but essentially the section on Handling served drinks (pints, wine by the glass, etc) explains how we recommend handling served drinks in Breww with POS.
If you choose to go about this by transferring keg stock between sites and creating draught products, you can do this, and there is a comment thread at the bottom of that article that goes through this setup. In terms of how you would go about moving stock, we again handily have an article on How do I move products to a different location? which should cover everything you need to know.
If you still have any questions, please let us know, and we will be more than happy to help.