Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Thread: BREWER'S REPORT OF OPERATIONS-spreadsheet?

  1. #1
    Join Date
    Nov 2002
    Location
    Polson, Montana, USA
    Posts
    1,089

    BREWER'S REPORT OF OPERATIONS-spreadsheet?

    Howdy Hi all,
    Has anyone created a spreadsheet that eases the agony of completing the TTB Brewer's Report of Operations? If so, are you willing to share?!?! PLEASE!!!!!!

    Thanks anyway,
    Dave

  2. #2
    Join Date
    Jan 2003
    Location
    Thorold, Ontario, Canada
    Posts
    17

    Smile

    Hi,

    I used to have a great one that was built using Quatro Pro, when I was Head Brewer at Alcatraz in Indianapolis. If you send me your e-mail, I'll see if I can locate it and forward it to you, if you have access to that software.

    Mike

  3. #3
    Join Date
    Jan 2005
    Location
    Tulalip, WA, USA
    Posts
    39

    TTB Forms

    Check out www.ttb.gov and pay.gov
    Forms 5130.9 & 5000.24 can both be done online.
    It even checks your math for you.

    Steffan
    Aldergrove Brewery
    Tulalip WA USA

  4. #4
    Join Date
    Oct 2005
    Location
    Woburn, MA
    Posts
    27

    Brewers Report of Operations

    I have an Excel spread sheet that has Brewers Report as well as State of Massachusetts state filings calculated from production and sales figures. The spreadsheet requires lots of explanation, but I am happy to share with anyone interested. Just send me a PM, and I'll give the details.

    Cheers,
    Mike
    Michael Labbe
    Brewery Engineer
    Lord Hobo Brewing Company
    5 Draper Street
    Woburn, MA 01801

  5. #5
    Join Date
    Feb 2003
    Location
    Boise, ID
    Posts
    233

    Brewers Quarterly Report

    Hi Dave, I have an excel program for this report. I just got it from a brewery I used to work at, it is on a floppy disc. I haven't gotten a chance to use it yet, but I am assuming it still works- just plug in the numbers and it does the rest. Give us a call, and I'll try to remember to check it out in the meantime.....

    Paul Thomas
    Bitter Root Brewing

  6. #6
    Join Date
    Sep 2003
    Location
    Jonesborough, TN, 37659
    Posts
    26

    Bro

    Hey Dave,
    I have one I made in Wordperfect if you are interested.
    Michael

  7. #7
    Join Date
    Dec 2005
    Location
    charleston, sc
    Posts
    93
    Any one still interesting in sharing their spreadsheet? I don't like ours and I am no good at creating spreadsheets. Thanks in advance!
    COAST Brewing Company
    SC Brewer's Association

  8. #8
    Join Date
    Oct 2002
    Posts
    17
    Bump. Would like someone's spreadsheet. brewops at gmail.com

  9. #9
    Join Date
    Feb 2003
    Location
    Boise, ID
    Posts
    233
    I forgot all about mine. It is buried in a box somewhere from my last desk. If I ever find it, I'll see about getting to a CD. So I am not a good source for this at the moment.
    Paul Thomas
    Brewer
    Sockeye Brewing
    www.sockeyebrew.com

  10. #10
    Join Date
    Mar 2011
    Location
    Hamilton, NY
    Posts
    37

    Thumbs up Report of Operations

    I know this has been posted before and maybe in this exact phrashing, but does anyone have an excel sheet to help ease the pain of filling out the Brewers Report of Operations? It would be greatly appreciated! Thank you!

    Cheers
    ~Matt
    Cheers,

    Matt Whalen
    www.goodnaturebrewing.com

  11. #11
    Join Date
    Feb 2010
    Location
    Blowing Rock NC
    Posts
    74
    send me your e-mail and I will share teh one i made.

  12. #12
    Join Date
    Apr 2008
    Posts
    51
    Quote Originally Posted by Ray Hodge
    send me your e-mail and I will share teh one i made.
    tannnick at gmail dot com

    Thank you!

  13. #13
    Join Date
    Sep 2010
    Posts
    80
    Hi Ray,

    Not sure if you are still giving out a spreadsheet to help do the Brewers Report of Operations but if you do, I'd be extremely grateful if you could forward a copy of that to me. First time filling it out and it's a bear. Send me your address and I'll mail you a pint glass for the help .

    kasksakiabrewingcompany @ gmail dot com
    Jared Kueker
    Kaskaskia Brewing Company

  14. #14
    Join Date
    Oct 2009
    Posts
    45
    Spreadsheet? Why not just fill it out online at pay.gov or ttb.gov (i forget where I do that right now, long day)? You just fill it out like a spreadsheet and it shows errors, foolproof and easy.

  15. #15
    Join Date
    Sep 2010
    Posts
    80
    I was struggling with the online form because it seems to be adding up some of the columns and showing I produced way more than I actually did and the wording on this thing is horrible. For example, I only produced 4 barrels of beer and kegged off 2 of those barrels (yes I know, tiny amount but it's our first test batches). In 2b, I put 4 barrels produced by fermentation. 2 of those barrels we transferred to brite tanks and then kegged so I put 2 under 6c (beer recieved from cellar - bulk) and 2 under 9d (Racked to keg). So then it adds up my total to 8 bbls instead of the 4 I produced. I remember reading in another post about this same exact issue I'm having so I was hoping somebody had a spreadsheet that could make this a bit less painless. I am actually starting to think I need to get rid of the 2 under 6c but at this point, I will probably just call the ttb and ask them to explain the definitions.

    Cheers,
    Jared Kueker
    Kaskaskia Brewing Company

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •