Announcement

Collapse
No announcement yet.

Keeping track of kegs

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Keeping track of kegs

    I've been in business now for almost 3 months and I'm starting to get calls to fill orders. I'm filling, selling, and self distributing about 25 kegs (have 45 in my inventory for growth). I'm using a spreadsheet (not very efficiently) and wonder if anyone can help me with a better way of keeping track of where my kegs are in and out. Thanks,

    Steve
    Battenkill Brewing Company
    Poulsbo, WA

  • #2
    Send PM with your email and I'll send you our (efficient) spreadsheet for this purpose.

    Comment


    • #3
      Numbering your kegs is a good place to start. When I started following my kegs, I wrote the keg numbers on the invoices, and kept a list of which was washed when.

      Comment


      • #4
        That's pretty close to what we do. Each has a number and you track who has what number and when you last cleaned each one. Only way to screw it up is to send out a dirty keg, in which case you've got bigger things to worry about...

        Comment


        • #5
          Thanks!

          Thanks for the great spreadsheet. It fit perfect with my operation and is in use now.

          Comment


          • #6
            I've sent it out to a bunch of people, so I figured I'd just post a link here instead of continuing to send everybody individual emails:



            It's a little complicated with array functions and stuff, but bottom line is when the keg goes out, we enter it into the main sheet. Each keg has a unique number. When a keg comes back, or gets cleaned, we record the number in the "kegs returned" sheet, which in turn updates the main sheet. Then with data filtering, we can easily see what kegs are out, where they are, and how long they've been missing. Once it's set up, it takes maybe 1/2 hour a week to keep it up to date.

            Let me know if you have questions!
            Last edited by Woolsocks; 03-01-2013, 11:05 PM.

            Comment


            • #7
              The question of charging deposits has come up off-forum. Here's a response I just sent about what we do:

              We decided not to charge deposits because people then feel entitled to keep the keg if they're willing to lose the deposit. If we charged enough deposit ($150) to cover the lost keg, we'd lose sales because people wouldn't want to lay out the deposit. Add in the accounting challenges, and it just wasn't worth it.

              Most people pay for the keg with a credit card, so we make them sign a sheet authorizing us to charge their credit card for lost, stolen, damaged, etc. kegs up to $150. We've never actually had to charge anyone's card, but we've had to threaten it a couple times. Seems to work.

              Comment


              • #8
                except some states (like PA) require a deposit by law...

                Comment


                • #9
                  keg tracking spreadsheet

                  Does anyone have the file to share? The dropbox link is no longer active.

                  Best,

                  Dan

                  Comment


                  • #10
                    Ditto,, link not working,,, If anyone has file to share,,, could you please email to kmontgomery24@yahoo.com

                    Thanks
                    Kelly Montgomery
                    Brewery In Planning

                    Comment


                    • #11
                      Here ya go

                      My file is here: https://dl.dropboxusercontent.com/u/...t%20Public.xls

                      Otherwise, check out KegID - that's what we use now.

                      Comment


                      • #12
                        We use a Symbol model CS4070 scanner to read the barcodes on the kegs. It connects to computer via USB. I then open a workbook in excel and transfer the serial numbers into the spread sheet via cut and paste. Takes maybe 10 minutes to do a few pallets worth of kegs.

                        Comment


                        • #13
                          Originally posted by Woolsocks View Post
                          My file is here: https://dl.dropboxusercontent.com/u/...t%20Public.xls

                          Otherwise, check out KegID - that's what we use now.
                          Hey Woolsocks, thanks for the file! I'm having a little trouble using it though... it seems like when I put a keg down in the returned sheet, the data doesn't show up again on the main sheet. Am I doing something wrong?

                          Comment


                          • #14
                            Barcoding Kegs

                            I like the idea of the scanner for kegs, my question is what are you using for the bar code tags on the kegs?

                            Thanks

                            Comment


                            • #15
                              I'd have to look over your shoulder - it's a pretty advanced spreadsheet. As far as barcodes, KegID recommended some "industrial" ones which are pretty tough.

                              Comment

                              Working...
                              X