Actually, not accounting. I am a chemical engineer by training, currently doing product development.
The beers are actually named after some of my dairy goats. Yes, I did have a goat named Lotus 1-2-3, a product of Vipassana Meditation and XHTML. The spreadsheet started out as a way to manage my brewing season, which typically runs from November to April. This year I managed to sneak in a few summer brew dates. It allows me to take advantage of bulk grain and hop buys where it makes sense, repitching of yeast cake or planning on freezing yeasts.
A guided tour:
The first page is my scheduling page where I list the recipes and potential brew dates.
The second page is my grain needs. Column B has the total needs for the recipes, which I import from BeerSmith by saving the shopping list as a .csv file and then copying and pasting the numbers over. From there the program takes into account the usage and inventory on hand to calculate out what I need to buy. I do my recipes in metric, but purchase in lbs (an artifact of living in the US), so there is that translation that takes place. I typically round up small amounts to the nearest 1/4 lb for ease of purchasing. Amounts over 1 lb, get rounded up to the nearest lb and are used for figuring out an order if I decide to order on-line.
The third sheet is the same for hops. The columns over on the far right can be ignored, as they are my playing around with doing various SMASH recipes, which I may slip into the schedule this year.
Fourth and fifth are yeast and additives (which I included sugars because it oddly struck me to do it here instead of on the grain page).
The sixth page tracks purchases and current inventory on-hand.
The seventh does the same for usage, breaking it down by recipe, Figures are entered in from my BeerSmith brew sheet that I print out.
The supplier summary sheet was just a way to try and summarize if it made sense to order on-line versus purchase locally. This year, since I am buying base grains in bulk, all my grain purchases are local.
The last sheet contains bulk packaging figures for a number of on-line suppliers. It allows for price averaging of various sized packages for extract and base grains.
Due to the way I figured pricing on materials, it is a rolling average price. I am looking at ways to make it a FIFO type of system, but have not had the time to do time weighted tracking of costs yet. I may never get around to that, as it really is not too important to me. I also break down the price per bottle, mostly for SWMBO, who is always challenging me while she is sucking down a beer (OK, you spend 9 hrs a day at work, 2 hrs commuting, 2 to 3 hrs taking care of goats, is it really worth spending this time on brewing). Actually, she supports my brewing habit as much as she supports my farming addiction, so I cannot complain.
-- Old Goat