Edit: We now have a 2021 Version Available!
you have chickens? Do you like spreadsheets? Then I have the Egg Laying Spreadsheet for you! No really, joking pitch aside, I have created this free chicken tracker and egg production spreadsheet for you. You can scroll to the bottom of the directions to get your free egg laying and chicken production spreadsheet if you aren’t into reading about the spreadsheet. There is also a link copy that shows you what it looks like with data.
Who is this chicken tracker and egg laying spreadsheet for?
Both the home hobbyist, the small farmer, and geek extraordinaire.
Truth time: I made this chicken egg production spreadsheet for myself because I am a geek and wanted to know if my chickens ever broke even, cost-wise, when I sell their excess eggs (Spoiler: I’d keep the chickens anyway). I love tracking all types of things, but I just cannot do it on paper. I like using Google Sheets because they are free and easily accessible from my phone. Right now I am offering the chicken tracker and egg production spreadsheet only as a Google Sheet. However, if you desperately need this Egg Laying Spreadsheet in an excel format let me know in the comments. If there is enough interest I’ll convert it for you.
I envision a number of enhancements for 2019! But I wanted to get it out there for other people to use this year and give me feedback about what else they might want to see.
Here is what the Egg Laying Spreadsheet contains:
- At a glance chart (auto fills)
- Summary statistics, example: average eggs per hen, eggs per month (autofills)
- Chicken Log
- Egg Log
- Expense Tracking (optional)
- Income Tracking (optional)
Best Part! You enter you expenses, income, and eggs in each sheet and the statistics and charts automatically update! Booyah!
Egg Laying Spreadsheet Dashboard
My day job is in Business Intelligence so I know people need a variety of ways to digest data. For visual learners the Egg Laying spreadsheet starts with some at-a-glance charts. First you can see how your monthly profit is going and how your running year-to-date profit is headed. Trust me, the fake data you see below is nothing like my actual profit… Which is well below zero this year.
My favorite part are the egg spreadsheets. Even if you have no interest in profit and loss you can see your total eggs, egg size, and color all compared!
Chicken Summary Statistics
Need more numbers? Average eggs per hen? Year-to-date profit on your chickens? Then the Summary Statistics page in the Egg Laying Spreadsheet is all for you. All items automatically populate from the items you enter in the next few sheets.
This is the main portion of the spreadsheet. It started as a place to keep information about all of our new chicks but has evolved to meet a variety of your needs. The whole spreadsheet links from knowing when your chicks start laying, if they died or were sold, and other notes. The key fields that need to be filled in correctly for the Egg Laying Spreadsheet to work:
- Laying Date
- Death/Sale date if applicable
This is the fun spreadsheet! I simply pull this sheet up on my phone when I collect eggs and put in the numbers. It is pretty simple, just put how many eggs of each type and color in the appropriate slots. The totals will auto-calculate for you and update the summaries and charts as you go. I have left what exactly goes in sizes and colors up to you. I tend to put cream eggs with white and tan eggs with brown, etc. but that decision is up to the individual chicken owner. Pro-tip: you can put in total eggs, and skip color and sizes but you will lose you size and color charts.
Expense & Income Tracker
For those chicken owners that want to get a little more into the numbers the expense and income sheets exist. I have some suggested categories for chicken owners, but in reality you can put whatever you want. I am hoping to add more statistics and charts based on the categories in the future. Some examples I am considering: Cost of each egg per amount of feed, Average Carton Price, etc.
If you are a hobbyist and just want to look at how many eggs you have, you can skip these pages or fill out the bare minimum:
Categories that must be filled out are marked with an asterisk *. Filling those columns in is all that is required to use the Chicken Egg Tracking Spreadsheet. I really want feedback from you about what else you might want this spreadsheet to do. Please let me know in the comments and if you found it useful then please share this on social media.
Empty Chicken Tracker You Can Use This sheet will prompt you to make a clean copy ready for you to fill in with your information.
Example Chicken Tracker and Egg Laying Spreadsheet with Data Use this sheet to view how you might want to fill your in
I spent a lot of time creating something I thought might be of value to you, chicken owners, and would like to have your feedback. Please let me know in the comments what other items you might want to see in the spreadsheet. I’ll see about future enhancements for later this year!
41 thoughts on “Egg Laying and Chicken Tracking Spreadsheet 2018”
Woah! This is EGGactly what I was looking for! Actually, it’s even MORE than what I was looking for. I also want to learn where I’m at by the end of the year, so this tracker is absolutely perfect. I would love a workable excel file, please.
WOW!!! THANK YOU for sharing this labor of love with us! My 11 year old daughter LOVES our flock, treats them like royalty, and she has recently decided to sell some of their eggs to save up for a horse. I thought it would be a great opportunity to teach her about record keeping, accounting, inventory, sales, business, responsibility, accountability, so on, and etc.! Your amazing spreadsheet will be such a great help for her…and myself, in this endeavor. This grateful father is extremely appreciative! Thank you!
So glad you found this. Make sure to grab the newest sheet:
First of all, THANK YOU for this!! I have been trying to find a good way to track for our new homestead. We bought it in September 2019 and decided to start with layers our first year in the Spring 2020. This tracker gave me a great starting point, but I found I wanted to dive in a little deeper, and look at our expenses broken down by expense type (chicken feed, bedding, medicine, supplies, brooder/coop materials, pullets, misc.) to see how much we were spending in each area. I also added a pie chart for this information. I would be MORE THAN HAPPY to share a copy of the changes/additions with you to share on here since you so graciously shared your versions for free!! :) I think I may use this as a starting point for my overall homestead tracking too. Super excited! Thank you again!!
I would love to see a copy! You can send it directly to bganskopp at gmail. So glad this gave you a good start.
Copy has been shared. :)
I am a beginner in poultry farming and have been searching for a template that will help me get it right first time with regards to account recording. I found your template GREAT and will be grateful if you could it with me.
I too would be very interested in how you divided the categories down more specifically. Do you suppose I could get a version of that?
Thank you this is awesome.
No problem. Had a few bugs, but it seems to be in working order now.
Brianna – thank you for sharing this. I would love to speak with you. We have started a chicken project at our community development projects in Uganda to help our villages become self-sustaining. We started the project two years ago, but need to develop metrics reporting and track chickens purchased, eggs produced, eggs sold, chickens sold, chickens that die adn then manage the income coming in to help replicate this to 7 other communities we are trying to build. We need to be able to take something like this and help it grow to help them become self-sustaining. something that they can learn to use too. would you be able to connect through email and then a phone call? This could be a huge and such meaningful impact to our nonprofit!
Please feel free to email me: firstname.lastname@example.org
please sir thanks for share is important experience.plss can you help me with the spreadsheet so i can take my own record too. thank you
Click the link above and make your own copy! It is free for use.
wow,it good for small operations surely,but little more explanations about financial approach and more dashboards r needed to cater performances and homework sheets so as to take better decisions in poultry farming business,so as to attain profitability at all levels.
First of all, thank you for sharing your Chicken and Egg Production spreadsheet. I have been filling it out for just over 1 week and getting to know how it works. You obviously put a lot of time and effort into this project.
In the spirit of helpful suggestions, I would like to offer an observation on my usage. On the Summary Statistics sheet, Summary by Month, Capacity, Avg Eggs per Hen in column H, I get an error code “#DIV/0!” from Jan-Aug as my first year hens did not start laying eggs until Sep. So the formula is Total Eggs Laid (0) / Laying Hens (0) which leads to the “#DIV/0!” error code. I don’t know the proper code, but I would think some change could be made to trap the 0/0 situation and display “0” Avg Eggs per Hen instead of an error code. I realize this is nothing more than a presentation issue, but I hate seeing error codes on any spreadsheet. My hens started laying in Sep, and the formula calculates and displays correctly from that point on.
Again, thank you for sharing your spreadsheet.
Thanks, I’ll get that corrected in the new version for next year.
If I bought several bags of feed at the end of last year does it means i am going to get some “free” feed this year? Similarly if I buy feed this year that lasts a few months, than I will be getting $$$ expense in that month & loss while will be having zero expense and all profit in the following months? I would rather want to track how much feed they eat in different weather or kind of foraging. Looks like need another column as “feed spent” rather than just “purchased”.
It really depends on how you do your accounting model. For example I do a model where each year all costs and all money accrued are counted. Some people do all costs and all money received are counted. I did my model, but I can look into adding a feature for following feed ratios over time. I had thought about it before which is why you can put in the amount of food. I’ll add it to my ongoing update list! Thanks for the suggestion.
Your spreadsheet looks awesome. Are business owners allowed to use it or is it personal/hobby use only?
It is free to anyone to use! We also have an updated 2019 version
Your spreadsheet looks awesome. Does it have a column for birds sold? Or did I overlook that? I am looking for a workable spreadsheet for my small poultry business. Is yours available to use for this pupose? Thank you
Yep! Free for any use except reselling it as your own!
Just found this and love it!! Looking forward to seeing what you have in store for 2019!
Love this! So sad I just now found it, but it’s been nice to use this month! Do you think you’ll have 2019’s posted before the end of the year?
I was a little late but it is up now!
How I can obtain this sheet
Just click on the link and it will prompt you to make a copy for your own use!
Hi, Iam looking for a egg laying and expense sheet. I don’t have a computer to print out. I would have to write in on a daily basis to keep track of everything. Also need one for raising broilers as well. Could you help me out? I would appreciate it very much. I would be willing to buy a printed copy of each from you.
I don’t have a means to print it at the moment. Sorry! Maybe run to your local library? You could print it there. If enough people ask I’ll make a pdf that would be easier to print.
This is wonderful!!!
I love this! I’ve been searching for something for a while now and this is just what I wanted and more! Thank you so very much.
Been messing with it a lot lately. 2019 is going to be even better!
Thank you very much for this. I had been looking for an app that would allow me to track eggs, but only a couple I could find and they were not really what I was looking for.
This looks like exactly what I need :)
Please give us some feedback if you try it! I have been using it all summer and have a lot of modifications planned for 2019!
Looks cool, but I don’t know how to simply add data…
Click on the link and it should prompt you to make a copy to your google drive. That will be your copy to keep and you can enter data at will!
Thank you so much for creating this, I can’t wait to try it!
Always remember too what Joel Saladin says, “every dollar you don’t have to earn is worth a dollar thirty because you don’t pay taxes on it”. We would buy at least 2 dozen organic eggs a week without our chickens! So looking forward to tracking all this!
I hope you find it useful!