Everything for your backyard chickens, from food to bedding.Articles may contain affiliate links. Read my disclosure policy.

Annual Egg Production Chart | FREE Custom Printable

in ,
Tracking egg production is not only fun, it's a good way to monitor the health of your flock. This free customizable egg production chart will help.


Keeping track of who lays what and how often is made simple using my Annual Egg Production Chart.

Tracking your chickens' egg production is not only fun and a great homeschooling or teaching tool for kids, it's a really good way to monitor the health of your flock.

Often a reduction in laying is the first sign that something is wrong, since laying eggs takes so much energy out of a chicken, so by keeping track of who is laying what - when - you can sometimes get a jump on anything that's gone awry.

As a former accountant, I'm a bit of a spreadsheet freak, I admit! So I created this custom chart that you can use to track your girls' egg production. It's customizable to your specific flock of chickens (or ducks!) and also printable. 

You can fill it in online and everything will automatically total by chicken or color of egg, and then by day, month and year. 

Or you can print it out and fill in the hard copies on paper.

Annual Egg Production Chart | FREE Custom Printable

My Annual Egg Production Chart Google Sheet which you will need to download and then save a copy of it in order to enter your own data.  


Download the Egg Production Chart

Newly updated for 2021 with charts/graphs at the bottom!

If you don't want to use the chart online, you can print out each month and write in the information by hand on a hard copy - but then all the totals will need to be manually calculated as well - or the data will then need to be entered into the spreadsheet at the end of the month. 

If you have children, you might want to print out the sheet for the month and have them write in how many eggs they collect each day in pencil, then either they or you can input the numbers into the spreadsheet.

To begin using the chart, first you'll want to enter your name or your farm name where the gold words are in brackets [] at the top.  

Then, down the left hand side, you have the option of setting up the categories you want to track. You can replace the [Color/Name] cell on each line with whatever you want. 

Each of your chickens' names, the egg color, the breed, etc. One per line.

If you have a small flock, you might want to enter the name of each hen to be able to count how many eggs she lays each month.

If your flock is larger and you can't match an egg to a specific chicken, you can track your egg production by egg color or breed. 

Or if you have separate flocks, you might track the eggs by coop. It's up to you. Those rows where it says [Color/Name] in gold are for you to customize with what works for you. 

(Note: you only need to type in your categories once - in January - they will auto-fill down the sheet for the remaining months.) 

If you need more lines, you can insert them easily and if there are too many lines, then go ahead and delete them. The formulas should all still work just fine.

And that's it. As you collect your eggs and type in numbers, you will get totals by day, by category, by month and for the entire year at the bottom of the chart. 


IMPORTANT: After you click on the link above and the template comes up, you'll need to click on  "Make a Copy" and save it to your computer. Then you'll be able to edit your spreadsheet.

And as you fill out your chart, remember that no chicken lays an egg every day, so there's no reason to panic if you notice one skip a day here and there.  Production also naturally slows during periods of extreme heat, during the molting season and as the shorter days of winter approach.

But you should be able to see a bit of a pattern over time - and use the chart for fun or an educational tool for your kids, if nothing else. 

Enjoy! 

And if you have any trouble using the spreadsheet, please email me at 

fresheggsdaily@gmail.com

Remember... you need to save a copy so that you can fill in!

Download the Egg Production Chart

Pin This!

Join me here
Facebook | Twitter | Instagram | YouTube
©2017 by Fresh Eggs Daily, Inc. All rights reserved.

preorder my cookbook

chewysupplements