Excel spreadsheet for tracking expenses and income from chickens

[Lookin4GoodLife]

Thank you for doing this each year. It has been a real help to us. If I wanted to keep track of how many dozen eggs by size (small, med, lg,etc.) how would I go about adding that and keeping the over all dozen count accurate? I must admit, however, that I am not Excel competent at all.

Might be a challenge if you're not Excel competent, but I think the easiest thing would be to add an extra sheet. Run the date down column 1. Use columns 2, 3 & 4 for S, M & L eggs. Use column 5 to total them for that date. Then go back to the main sheet and point the total for the date to that date in your new sheet. Using an additional sheet will do the least damage to the main spreadsheet if something goes wrong, just my opinion of course.

 

[matinee]

I would love to have a copy

 

[Farmgirl1878]

I’d love a copy too! [email protected]

 

[aart]

I would love to have a copy

I’d love a copy too! [email protected]

The 2018 Always Free Chicken Tracker Spreadsheet is available for your downloading pleasure. Just click the linked text above, enable editing and save a copy to your computer. If you use Google Sheets, simply upload the file to your Google Drive and Google will do the conversion for you.

Please follow my blog: Stewart Creek Somethings

 

[L S]

My wife, the wonderful woman that she is, created a nifty and handy Excel spreadsheet for me to track income and expenses for my chickens. It includes columns for tracking egg production and sales, feed expenses, and tracks hatch rates, (it does way more, but I can't list it all). It has multiple reports, and tracks by month and year total. If anyone would like a copy let me know and I will send it to you. If you have any ideas for improving it, let me know those too and I will see if I can get her to update the spreadsheet in a little while. I had her add in a lot of features we won't use yet, but I wanted to be able to use them in the future.


ETA: It is a new year 2011. My wife changed the year on the tracker and fixed a bug we had. Enjoy the tool.

ETA: It is now 2012. I am going to paste some instructions that were buried in one of the later posts and I will add the link below for the 2012 dated version. I have not gotten my wife to add the "how died" section for chicken losses. Hoping to sweet talk her this year into doing that for me. enjoy and feel free to pass this around and let people know it exists.

The form does everything for you so data entry is the key to making it work correctly. Just open the current month tab you are working on. I will go through each section.
The first section is the date, be sure and use the number under the date column. In Excel it numbers the lines and these are the first numbers you see. Don't use those, use the "date" column numbers (all these hints are from mistakes I have made, lol).
The next column is "laying hens, quantity" just enter the number of hens you have that are of laying age. This will automatically be carried down for the whole month so if you lose some hens in the middle of the month just enter the new number of hens on that day. The program adjusts you numbers accordingly (I had raccoons killing hens all month one month last year.)
The next column is"production", this is easy just put the eggs collected under each column. I had my wife make different sections for different colored eggs, just so I could see how my chickens were laying. The production calculator doesn't care where you put them just so you enter the number of eggs collected on that day in one of the three columns.
the next column grouping is "Income" further broken down into "eggs sold" I just add up the amount I sold so 2 doz eggs go for $5. I enter a 2 in the "dozen" column and 5 in the "$" column. This will also take decimal points so if you are selling 18 packs you can enter 4.5 in the "dozen" column and 11.25 in the "$" column.
the "chickens sold" works the same way. You could even use this for meat chickens if you are just selling carcasses.
Under "Expenses" the important one is "feed purchased" you have a "pounds" and "$"" column. I put these in as I open a new bag of food. This way I can credit the charge to that month. So I am using around 300# of food every month during the Winter so I have five separate line items with 50 under "pounds" and 8.89 under "$" column (this also lets me account for the feed price change. mine changes with the price of corn so I paid $8.89 to $11 last month.) The other expenses just put in the number of the total cost of the items.

Now results, the computer and program automatically compile this information every time you make a new entry into the spreadsheet. At the bottom of the page you have some averages specific to that month.
the "Average productivity" section:
"laying hens per day" average number of laying hens for the day.
"Eggs collected per day" total number of eggs collected every day divided by the number of days in the month
"percent productivity" is the number of eggs collected per day divided by the number of hens laying. So if every chicken laid an egg every day of the month it would be 100%.
"pounds feed per egg" is the number of eggs collected divided by the amount of feed in pounds that you fed the chickens. If you free range this number varies drastically by the season.
"feed cost per egg" is the amount you paid for feed only that month divided by the number of eggs collected. I then multiply this by 12 to see what my feed costs are per dozen eggs.

the "Monthly Financial Summary" section:
"income" takes all the money collected from the eggs sold column and chickens sold column and adds them up.
"Expenses" adds all your expenses together except you flock purchases.
"Flock purchases" adds the amount you spent on live chicks and/or hatching eggs.
"Net" takes you Income and subtracts the Expenses and Flock purchases from it.

The "Hatching eggs" section:
"hatch rate" takes the number of live chicks that survived to hatch and divides it by the number of eggs you started with in the incubator. If you are over 70% here you are doing great.
"cost per live chick" takes the amount you paid for the eggs (you placed in the incubator) and divides it by the number of live chicks that hatched.

There is also a summary tab that gives you this information for the entire year. As you go through more months your annual summary will change accordingly. It works pretty slick. Any more questions let me know,
Raisin

.https://docs.google.com/open?id=0B7DYHxGoNHhrNzcyYjdiYWMtNTk5NS00Y2I3LWI4YzAtMjE3MDBjODVmYzBm

My wife, the wonderful woman that she is, created a nifty and handy Excel spreadsheet for me to track income and expenses for my chickens. It includes columns for tracking egg production and sales, feed expenses, and tracks hatch rates, (it does way more, but I can't list it all). It has multiple reports, and tracks by month and year total. If anyone would like a copy let me know and I will send it to you. If you have any ideas for improving it, let me know those too and I will see if I can get her to update the spreadsheet in a little while. I had her add in a lot of features we won't use yet, but I wanted to be able to use them in the future.


ETA: It is a new year 2011. My wife changed the year on the tracker and fixed a bug we had. Enjoy the tool.

ETA: It is now 2012. I am going to paste some instructions that were buried in one of the later posts and I will add the link below for the 2012 dated version. I have not gotten my wife to add the "how died" section for chicken losses. Hoping to sweet talk her this year into doing that for me. enjoy and feel free to pass this around and let people know it exists.

The form does everything for you so data entry is the key to making it work correctly. Just open the current month tab you are working on. I will go through each section.
The first section is the date, be sure and use the number under the date column. In Excel it numbers the lines and these are the first numbers you see. Don't use those, use the "date" column numbers (all these hints are from mistakes I have made, lol).
The next column is "laying hens, quantity" just enter the number of hens you have that are of laying age. This will automatically be carried down for the whole month so if you lose some hens in the middle of the month just enter the new number of hens on that day. The program adjusts you numbers accordingly (I had raccoons killing hens all month one month last year.)
The next column is"production", this is easy just put the eggs collected under each column. I had my wife make different sections for different colored eggs, just so I could see how my chickens were laying. The production calculator doesn't care where you put them just so you enter the number of eggs collected on that day in one of the three columns.
the next column grouping is "Income" further broken down into "eggs sold" I just add up the amount I sold so 2 doz eggs go for $5. I enter a 2 in the "dozen" column and 5 in the "$" column. This will also take decimal points so if you are selling 18 packs you can enter 4.5 in the "dozen" column and 11.25 in the "$" column.
the "chickens sold" works the same way. You could even use this for meat chickens if you are just selling carcasses.
Under "Expenses" the important one is "feed purchased" you have a "pounds" and "$"" column. I put these in as I open a new bag of food. This way I can credit the charge to that month. So I am using around 300# of food every month during the Winter so I have five separate line items with 50 under "pounds" and 8.89 under "$" column (this also lets me account for the feed price change. mine changes with the price of corn so I paid $8.89 to $11 last month.) The other expenses just put in the number of the total cost of the items.

Now results, the computer and program automatically compile this information every time you make a new entry into the spreadsheet. At the bottom of the page you have some averages specific to that month.
the "Average productivity" section:
"laying hens per day" average number of laying hens for the day.
"Eggs collected per day" total number of eggs collected every day divided by the number of days in the month
"percent productivity" is the number of eggs collected per day divided by the number of hens laying. So if every chicken laid an egg every day of the month it would be 100%.
"pounds feed per egg" is the number of eggs collected divided by the amount of feed in pounds that you fed the chickens. If you free range this number varies drastically by the season.
"feed cost per egg" is the amount you paid for feed only that month divided by the number of eggs collected. I then multiply this by 12 to see what my feed costs are per dozen eggs.

the "Monthly Financial Summary" section:
"income" takes all the money collected from the eggs sold column and chickens sold column and adds them up.
"Expenses" adds all your expenses together except you flock purchases.
"Flock purchases" adds the amount you spent on live chicks and/or hatching eggs.
"Net" takes you Income and subtracts the Expenses and Flock purchases from it.

The "Hatching eggs" section:
"hatch rate" takes the number of live chicks that survived to hatch and divides it by the number of eggs you started with in the incubator. If you are over 70% here you are doing great.
"cost per live chick" takes the amount you paid for the eggs (you placed in the incubator) and divides it by the number of live chicks that hatched.

There is also a summary tab that gives you this information for the entire year. As you go through more months your annual summary will change accordingly. It works pretty slick. Any more questions let me know,
Raisin

.https://docs.google.com/open?id=0B7DYHxGoNHhrNzcyYjdiYWMtNTk5NS00Y2I3LWI4YzAtMjE3MDBjODVmYzBm

I am very interested in exploring your document but it doesn't seem to be available. can you share with me please?

 

[L S]

the file says it has been trashed. cN anyone that has a copy share with me?

 

[Molpet]

the file says it has been trashed. cN anyone that has a copy share with me?

try this https://stewartcreeksomethings.com/chicken-tracker/

 

[L S]

try this https://stewartcreeksomethings.com/chicken-tracker/

I was able to download a copy. Thank you so much. Now I will have to spend some time investigating this document. It looks fantastic!

 

[Betsy57]

https://stewartcreeksomethings.com/chicken-tracker/
I rec'd an email from Raizin and his wife is working on the 2019 edition

 

[raizin]

I am very interested in exploring your document but it doesn't seem to be available. can you share with me please?

The spreadsheet can be downloaded from my blog. The link is in my profile. Once you're the blog, look for the Chicken Tracker link at the top of the home page.