Easy Profit Tracking Spreadsheet for Egg Sales & Feed Purchases

After several years of wondering if I was breaking even with the egg laying flock, I decided to start tracking poultry expenses and sales this year. I created a simple spreadsheet using Google Spreadsheets, and you can access the spreadsheet by clicking HERE. I encourage you to read this article, I’ll keep it brief, I promise, but based on experience with the protein, fat, and cost calculator, I know I can address some common questions.

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.

4 Comments on “Easy Profit Tracking Spreadsheet for Egg Sales & Feed Purchases

  1. Still, a very good start! Plus you are the quality control!

    LuAnn

    Like

    • Aw thank you for taking the time to always read my posts. I appreciate the support so much. ❤ I definitely have eggcellent quality control!

      Like

  2. 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?

    Like

    • 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.

      Like

Leave a comment