General record keeping

[Helltown]

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

[CedarCreek]

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.

[beejay]

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]

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

[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.

[CedarCreek]

My Email is damon@cedarcreekbrewery.com Thanks guys

[Helltown]

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

[el_mocoso]

I'll check them out too, por favor

gottberg.brewery@gmail.com

Cheers!

el

[Rich_Ness]

Me too please
Rayness76@gmail.com

[ChesterBrew]

Ray, I'd love a copy too... thanks in advance.

kshertz@me.com

[kyle.carbaugh]

Would much appreciate a copy of the spreadsheets as well

kyle@wileybrewing.com

[cleave]

I would like to get those too...please.

Thanks!

marc@squaretimber.com

[pk2pk]

Ray,

Would you mind sending one more?

Thank You

bob@twistedpinebrewing.com

[HinduKush]

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.

[CedarCreek]

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.