Milk Check Reconciliation Worksheet
Reconciling a milk check means starting from your own numbers and arriving at the buyer's total. When the two agree, you can stop. When they do not, the point where they split tells you what to ask. This walk-through builds the worksheet one column at a time and shows how to use it.
Set up the columns
Take one sheet or spreadsheet with a row for each part of the check. Wisconsin Extension describes a check as a settlement statement reflecting volume, component composition, quality measures, minimum formula prices, pool accounting, premiums and deductions. Your worksheet mirrors that, with two columns for each row: "my number" and "check number," and a third for the difference.
Rows, in order:
- Pounds shipped
- Butterfat pounds
- Protein pounds
- Other solids pounds
- Butterfat, protein and other solids value (pounds times announced price)
- Somatic cell adjustment or quality payment
- Producer price differential value
- Premiums, one row each
- Deductions, one row each
- Advances and prior adjustments
- Net check
A worked example with made-up numbers
Illustrative round numbers only. Suppose a farm ships 500,000 pounds with 4.0 percent butterfat, 3.2 percent protein and 5.7 percent other solids. Butterfat pounds are 500,000 times 0.04, which is 20,000. Protein pounds are 16,000. Other solids pounds are 28,500. Each is multiplied by the announced price per pound for the month, taken from the AMS Announcement of Class and Component Prices. Add the three values.
Next the PPD. It is stated per hundredweight, so convert pounds: 500,000 pounds is 5,000 hundredweight. Multiply by the PPD, which can be positive or negative, as the dairy producer price differential guide explains. A negative PPD reduces the check and is not an error.
Then add the premiums and subtract the deductions. Penn State Extension points out that the mid-month advance is a partial payment, not a cost, so treat it in row 10 so that it does not distort the deductions. Your net check should equal the sum.
Find the split
Work down the rows and stop at the first that disagrees:
- Pounds differ: compare slips to the statement day by day.
- Component pounds differ: the percentages differ. Ask for the lab report and the sampling dates.
- Value differs but pounds match: the price per pound differs. Compare with the published announcement for the right month and order.
- PPD value differs: check the PPD posted by your order's market administrator.
- Premium difference: compare with the written schedule.
- Deduction difference: compare with last month, per hundredweight, using the milk check premiums and deductions guide.
Do not be surprised by a small rounding difference. AMS rounds component prices to the nearest one hundredth of a cent and class prices to the nearest cent, so a few dollars of variation can come from rounding alone.
Compute the mailbox price
When the sheet agrees, calculate the mailbox price with the Farm Credit East method: total premium and component dollars, minus all deductions, divided by total pounds, times 100. That is your price per hundredweight for the month. Keep it in a running log to see the trend, and use it in any budget. The method complements the routine in the milk check monthly audit.
When it does not reconcile
Take the sheet to your field representative and walk down it with them. Ask for source documents for any row in dispute, and write the answer and date on the sheet. If a payment was wrong, ask when it will be corrected and whether it will show as a separate line. If the explanation does not satisfy you, talk to your cooperative board or, for an order question, your market administrator. A tidy worksheet makes those conversations short.
Keep reading
- Dairy Farmer Milk Check Terms Glossary
- Milk Hauling Deduction Worksheet
- Milk Marketing Fee Tracker
- Dairy Marketing Deduction Dispute Log
Find your state: see federal order, dairy regulator, extension, cooperative and youth dairy listings in the state directory.
Sources: UW Extension, Reading the Milk Check · Farm Credit East, Understanding Your Milk Check · USDA AMS, Announcement of Class and Component Prices
General information only, not tax, legal, insurance or investment advice. Prices, programs and rules change and differ by order, handler and state: confirm with USDA, your handler or cooperative, your lender and your extension dairy specialist.