Dairy Farm Milk Solids Tracker Excel - Free Template

1. Start on the Milk Solids Log and enter each collection or monthly record using the date, farm or block, herd ID and supplier name. Keep the entries consistent so the summary stays clean.
2. Fill in herd count, milk volume, fat %, protein % and milk solids (kg MS). If you are using the sheet properly, you should be able to compare one herd against another straight away.
3. Enter the payout rate per kg MS and check the gross milk income, GST and net income fields. This gives you a quick view of what the milk actually returned after tax.
4. Review the Monthly Summary sheet to see totals by month. Use it when you are preparing a farm meeting pack, monthly accounts or a season review.
5. Open the Dashboard to check the charts and spot movement in production or income. A quick visual check often catches a drop earlier than reading rows of figures.
6. Use the Instructions sheet if someone else is helping with the records. That keeps the process the same whether it is you, a bookkeeper or an office manager entering the data.

A milk solids tracker suits the people who live in the numbers every day: the sharemilker checking payout after the tanker runs, the office manager at a Waikato dairy unit, or the bookkeeper who has to line up milk income with the monthly accounts. If you have 320 cows and average 9.85 kg MS a cow, that is 3,152 kg MS to reconcile against the statement, so a tidy log saves real time.

The sheet is also handy at the start of the season and again through winter when performance shifts. A change from 4.8% fat and 3.7% protein to 5.0% and 3.9% can move the payout enough to matter, even before you look at feed costs.

What each sheet does

The Milk Solids Log is the data entry point, the Monthly Summary condenses the figures, and the Dashboard gives you a quick visual read. The Instructions sheet means you can hand it to someone else without losing the method.

Where this fits in the farm month

Use it when the milk statement arrives, when you are reviewing profit and loss, or when you want to see whether a block is carrying its share. A farm with two herds can keep each line separate and still compare them side by side.

For New Zealand farms, the milk income side of the workbook needs to sit neatly beside your GST records and annual accounts. If your business is registered for GST, the standard rate is 15%, and the gross income line should make it obvious what portion is tax inclusive and what portion is net.

Inland Revenue expects you to keep records for 7 years, so a monthly milk solids log is not just a nice-to-have. If you are using the figures to support a return, your source data should still be there when you need to explain a 15/01/2026 or 15/07/2026 entry years later.

How the numbers usually feed through

A payout of $9.80/kg MS on 3,152 kg MS gives gross milk income of $30,889.60 before GST. At GST 15%, that is $4,633.44 GST on the invoice side if the supply is taxable, leaving a net amount of $26,256.16 in the tracker.

Why the monthly summary matters

The summary helps when you are preparing the end of year figures for a 31 March balance date. If you are on provisional tax, you want the production and income trail to be clean before the instalments start landing.

The same year-end trail also makes it easier to set aside the levy cost, and an ACC levy estimate gives you a number to carry into the provisional tax review.

The biggest problem is mixing up volume and milk solids. If you record 5,800 litres and forget to apply fat and protein correctly, you can overstate income and end up chasing a payout figure that was never there.

Another common issue is leaving the payout rate blank or typing it inconsistently. A missing $9.75 on one month and $9.90 on the next makes the summary useless, because one bad cell can throw off the season total by hundreds of dollars.

Data entry mistakes that cost time

If you enter one herd twice, the dashboard will make it look like production jumped when it did not. On a 350-cow unit, a duplicated monthly line can distort the season total by more than 300 kg MS, which is enough to send you down the wrong track in a budget meeting.

Why messy comments create hassle

Comments like “good” or “ok” do not help when you are trying to link production to feed, weather or drying-off dates. A note such as “drying off 40 cows from 15/04/2026” gives you something you can actually use when the figures dip next month.

The easiest way to keep this spreadsheet alive is to tie it to something you already do, like the milk statement review or Monday admin. If you enter the figures every Friday after the tanker sheet arrives, you will not be trying to recreate six weeks of data on a rainy Sunday.

Three habits that keep it moving

• Copy the previous month’s rows and overwrite only the new figures, so the formatting stays intact.
• Use a fixed time each week for entry, such as 8:30am after the staff meeting or before the pay run.
• Flag odd results with conditional formatting so a low milk solids result or missing payout rate stands out immediately.

Once you are managing several herds, multiple suppliers or a full season of lines, the spreadsheet can start to creak. At that point you may still keep the tracker for review, but move the live bookkeeping into Xero or MYOB so the accounting side stays linked properly.

Once the live bookkeeping moves into Xero or MYOB, a supplier register keeps the active vendor details and account links in one place.