Homebrewers Association | AHA Forum

General Category => Going Pro => Topic started by: micsager on April 12, 2013, 03:08:35 pm

Title: BROP software for a 1bbl brewery
Post by: micsager on April 12, 2013, 03:08:35 pm
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...........)
Title: Re: BROP software for a 1bbl brewery
Post by: kylekohlmorgen on April 12, 2013, 05:09:18 pm
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.
Title: Re: BROP software for a 1bbl brewery
Post by: nateo on April 12, 2013, 07:27:16 pm
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.
Title: Re: BROP software for a 1bbl brewery
Post by: Thirsty_Monk on April 13, 2013, 01:17:33 am
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.
Title: Re: BROP software for a 1bbl brewery
Post by: anthony on April 14, 2013, 06:44:24 am
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.
Title: Re: BROP software for a 1bbl brewery
Post by: Thirsty_Monk on April 14, 2013, 02:22:06 pm
Thank you.
Title: Re: BROP software for a 1bbl brewery
Post by: kylekohlmorgen on April 16, 2013, 11:22:31 am
$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.
Title: Re: BROP software for a 1bbl brewery
Post by: nateo on April 16, 2013, 01:17:35 pm
$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.
Title: Re: BROP software for a 1bbl brewery
Post by: micsager on April 16, 2013, 02:32:35 pm
$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. 
Title: Re: BROP software for a 1bbl brewery
Post by: nateo on April 16, 2013, 03:30:08 pm
I could help you out with spreadsheets as well, if you need more help.