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

Thread: General record keeping

  1. #1
    Join Date
    Sep 2011
    Location
    Mount Pleasant, PA.
    Posts
    25

    General record keeping

    I currently am not having issues filling out any of the required forms but looking at the record keeping requirements we are probably a little lacking.

    Does anyone have some generic spreadsheets that you use to keep track of things that you would be willing to share? I know it's an open ended request but I just learned of a PA law that requires a form and signatures for "beer" removed from inventory for sale. Not a PA form but something that we are required to do on our own.

    Even a list of things that you guys keep track of might be a good idea and I can create the spreadsheets and forms myself.

    This is one of the few things that no prior experience in the brewing industry concerns me.

    Any help or direction would be great!

    Thanks,

    Shawn

  2. #2
    Join Date
    Nov 2010
    Location
    Seven Points, TX
    Posts
    49
    I would be interested in this information as well. We will be opening up soon and this is one of the things on my list to work on.

  3. #3
    Join Date
    Feb 2009
    Location
    Chicago, IL, US
    Posts
    180
    We are still waiting on our state license, but I've put together a packet of excel sheets to keep track of all the TTBs requirements. Not sure if it will all be acceptable, but I did my best to go through their required record keeping and create forms for everything. We intend to print the sheets out and have them in binders so we can sign them etc.

    Shoot me your email and I'd be happy to share.

    Also includes brewing sheets, etc.
    Beejay
    Pipeworks Brewing Company

  4. #4
    Join Date
    Feb 2009
    Location
    Chicago, IL, US
    Posts
    180
    Actually, here are links so anyone can download 'em.

    These are all done in open office, but can be opened in Microsoft word as well. Also note that each file has multiple sheets in it. There are probably some redundancies, but I was just trying to be thorough.

    https://docs.google.com/open?id=0B71...A0MTNhNjVhNmVj
    https://docs.google.com/open?id=0B71...IxM2UxMTYxMDQ0
    https://docs.google.com/open?id=0B71...dmZTA4NGJlNGIx

    After you click each link, you have to click download near the top left of the screen. Any feedback on edits would be appreciated as well.

    Cheers
    Beejay
    Pipeworks Brewing Company

  5. #5
    Join Date
    Feb 2010
    Location
    Blowing Rock NC
    Posts
    73
    send your e-mail and I will send you the sheets I use. I have fed brewers report, daily record, inventory and malt use and brew schedule for planning and ordering grain and hops. great spreadsheets.

  6. #6
    Join Date
    Nov 2010
    Location
    Seven Points, TX
    Posts
    49
    My Email is damon@cedarcreekbrewery.com Thanks guys

  7. #7
    Join Date
    Sep 2011
    Location
    Mount Pleasant, PA.
    Posts
    25
    Quote Originally Posted by Ray Hodge
    send your e-mail and I will send you the sheets I use. I have fed brewers report, daily record, inventory and malt use and brew schedule for planning and ordering grain and hops. great spreadsheets.
    Thanks!

    info@helltownbrewing.com

  8. #8
    Join Date
    Mar 2006
    Location
    Hardy, VA
    Posts
    151
    I'll check them out too, por favor

    gottberg.brewery@gmail.com

    Cheers!

    el

  9. #9
    Join Date
    May 2011
    Posts
    17
    Me too please
    Rayness76@gmail.com
    Rich Nesheim
    Triplehorn Brewing Co.
    Woodinville, WA

  10. #10
    Join Date
    Nov 2011
    Location
    Chestertown, Maryland
    Posts
    350
    Ray, I'd love a copy too... thanks in advance.

    kshertz@me.com

  11. #11
    kyle.carbaugh Guest

    As would I

    Would much appreciate a copy of the spreadsheets as well

    kyle@wileybrewing.com

  12. #12
    Join Date
    Feb 2009
    Posts
    6
    I would like to get those too...please.

    Thanks!

    marc@squaretimber.com
    Marc Bru
    Square Timber Brewing Company
    Pembroke, Ontario, Canada

  13. #13
    Join Date
    Oct 2002
    Posts
    5
    Ray,

    Would you mind sending one more?

    Thank You

    bob@twistedpinebrewing.com

  14. #14
    Join Date
    Jul 2010
    Posts
    288
    FYI, zipped spreadsheets will post directly to the forum. Zip it up and post it. Saves answering all these emails and creates a permanent archive.
    Shouldn't you be brewing beer?
    HK

  15. #15
    Join Date
    Nov 2010
    Location
    Seven Points, TX
    Posts
    49
    Did anyone else get these yet? Not to rush anyone, I just have not seen them in my inbox and wanted to make sure the spam monster didn't eat them.

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
  •