Anyone know of a reasonable software product for a tiny brewery? The Orchastratedbeer looks cool, but way too much for us.
(or if someone has an excel spreadsheet to share…)
The sample they have on the website gives you a good road map for making your own spreadsheet.
http://www.ttb.gov/beer/brewer_report.shtml
I would start by re-creating the form in Excel, and then linking the cells as it shows on the sample. If you’re using Excel for Inventory Management, just add a tap to your existing workbook. Then you can pull in the info rather than manually entering it / risking a typo.
+1. You should be able to set up your Excel sheets with (ideally) a single page of inputs. The more you have to change, the less useful/flexible your sheet is, and the more likely you’ll make mistakes.
Beer Run Software:
http://www.beerrunsoftware.com/
I think this is Quick Books AdOn.
I do not know the pricing thou.
If you find out, Let me know.
I have Beer Run pricing from the CBC.
Not sure if it is cool to post the exact details in the forum or not. But for less than 1000 BBLs a year, it is ultimately about $4k a year to use.
Thank you.
$4000/year?
I guess it depends on your size, but I feel like a fairly small brewery might put this cash to better use on a bright tank or more hops.
Excel can do everything you need, if you have a strong grasp of accounting. The more heavy-lifting a program does, the less knowledge you need. You really, really need to keep close track of your finances if you’re a small brewery on a tight budget. I’d say if you really have no idea how accounting is done in manufacturing, Orchestrated Beer is worth the money.
But, one must be fairly proficient in excel. I do OK, but certainly not well enough to suit my needs. One reason I was hoping someone would share a spreadsheet they ahve created. I have some friends int he accounting department at work, and two guys seem very willing to help. Of course it will cost me a couple growlers. But really, that’s a good deal. They are coming over this weekend, to take my haphazard spreadsheets, and turn them into one cohesive product.
I love brewing beer, and I love it when a complete strangers orders a second of the beer we brew. But, the business side of this is not for me. Probably why we will never grow past our 1bbl system.
I could help you out with spreadsheets as well, if you need more help.