Membership questions? Log in issues? Email info@brewersassociation.org

Author Topic: BROP software for a 1bbl brewery  (Read 5810 times)

Offline micsager

  • Senior Brewmaster
  • ******
  • Posts: 1179
BROP software for a 1bbl brewery
« on: April 12, 2013, 09:08:35 am »
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...........)

Offline kylekohlmorgen

  • Senior Brewmaster
  • ******
  • Posts: 1363
  • Saint Louis, MO
    • The South House Pilot Brewery
Re: BROP software for a 1bbl brewery
« Reply #1 on: April 12, 2013, 11:09:18 am »
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.
Twitter/Instagram: @southhousebrew

Recipes, Brett/Bacteria Experiments: http://SouthHouseBeer.com/

Offline nateo

  • Brewmaster General
  • *******
  • Posts: 2336
Re: BROP software for a 1bbl brewery
« Reply #2 on: April 12, 2013, 01: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.
In der Kürze liegt die Würze.

Offline Thirsty_Monk

  • Brewmaster General
  • *******
  • Posts: 2514
  • Eau Claire WI
    • Lazy Monk Brewing
Re: BROP software for a 1bbl brewery
« Reply #3 on: April 12, 2013, 07:17:33 pm »
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.
Na Zdravie

Lazy Monk Brewing
http://www.lazymonkbrewing.com

Offline anthony

  • Brewer
  • ****
  • Posts: 263
  • Hoppy to help!
    • Triptych
Re: BROP software for a 1bbl brewery
« Reply #4 on: April 14, 2013, 12: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.

Offline Thirsty_Monk

  • Brewmaster General
  • *******
  • Posts: 2514
  • Eau Claire WI
    • Lazy Monk Brewing
Re: BROP software for a 1bbl brewery
« Reply #5 on: April 14, 2013, 08:22:06 am »
Thank you.
Na Zdravie

Lazy Monk Brewing
http://www.lazymonkbrewing.com

Offline kylekohlmorgen

  • Senior Brewmaster
  • ******
  • Posts: 1363
  • Saint Louis, MO
    • The South House Pilot Brewery
Re: BROP software for a 1bbl brewery
« Reply #6 on: April 16, 2013, 05: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.
Twitter/Instagram: @southhousebrew

Recipes, Brett/Bacteria Experiments: http://SouthHouseBeer.com/

Offline nateo

  • Brewmaster General
  • *******
  • Posts: 2336
Re: BROP software for a 1bbl brewery
« Reply #7 on: April 16, 2013, 07:17:35 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.

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.
In der Kürze liegt die Würze.

Offline micsager

  • Senior Brewmaster
  • ******
  • Posts: 1179
Re: BROP software for a 1bbl brewery
« Reply #8 on: April 16, 2013, 08:32:35 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.

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. 

Offline nateo

  • Brewmaster General
  • *******
  • Posts: 2336
Re: BROP software for a 1bbl brewery
« Reply #9 on: April 16, 2013, 09:30:08 am »
I could help you out with spreadsheets as well, if you need more help.
In der Kürze liegt die Würze.