Humble Hills Homestead
Documenting my attempt to live a full life
Easy Profit Tracking Spreadsheet for Egg Sales & Feed Purchases
Please read the instructions tab on the spreadsheet to learn how to download a copy for your personal use. I will not respond to requests to edit the document. Here is a link to the spreadsheet.
I prefer to use Google Spreadsheets because the app is on my phone so each expense or sale can immediately be recorded. This is useful for folks who aren’t great with organizing receipts, such as myself. Once you open the spreadsheet, there will be three tabs at the bottom left hand corner of the screen. Under the first tab that says “Instructions” you will find how to download the spreadsheet to edit for yourself. No need to request access, you can download your very own copy! I receive numerous requests each week for my feed calculator, and I no longer respond to them. Everything you need to know about how to download the spreadsheet is in the instruction tab of the spreadsheet itself! I promise! You can also download this as a Microsoft Excel Spreadsheet if you would prefer to use that platform.
The remaining two tabs are straight forward, one is for tracking purchases and the other is for tracking sales. Simply fill in the appropriate fields and let the spreadsheet do the hard work for you.
Unfortunately, I am not currently breaking even. I have spent a total of $722.13 on my flock this year, including feed, treats, pine shavings, and egg cartons. I have only sold $476 worth of eggs. I estimate I “saved” at least $150 on eggs for our own consumption. We typically eat 2.5 dozen eggs for breakfast and up to another dozen in other uses.
I’d love to hear how your tracking journey goes! Feel free to comment and let me know.
Humble Hills Homestead 
Still, a very good start! Plus you are the quality control!
LuAnn
LikeLike
Aw thank you for taking the time to always read my posts. I appreciate the support so much. ❤ I definitely have eggcellent quality control!
LikeLike
Thanks for sharing such detailed insights into your egg operations—it’s fascinating to see how things are progressing!
I noticed the spreadsheet details your egg sales, but Im curious about the production side of things too. Could you share how many eggs are laid compared to how many you sell?
LikeLike
I have not started tracking production unfortunately although I did estimate we have consumed around 42 dozen eggs this year and sold 122.5 dozen officially. I *usually* count my eggs each day, but sometimes I get tired and forget to count. I think for me switching to an old school counting method and posting a tracking sheet at the exit of the coop may be best for tracking, but I would definitely like to implement something in the future!
I plan on posting a little more about flock management, efficiency, and egg prices in a few weeks or so.
LikeLike
Pingback: Farm Fresh Eggs: Are they profitable? – Humble Hills Homestead
Hi! I Would love to get a copy of this, but the spreadsheet does not open even with just viewer access.
LikeLike
Thank you for commenting. Thanks to your comment I realized I had linked to the wrong copy of the spreadsheet. Please try clicking on it again and let me know if it works. You should be directed to the correct spreadsheet which will have instructions for how to downloaded it. I’ve had so many requests to edit the document I assumed it was due to the egg crisis, but now I realize it may have been an error on my part! Again, thank you for commenting and please let me know if it works.
LikeLike