Skip to content
farmsorted

Reconcile the season’s milk income for the accountant

Milk income is paid a month behind, with step-ups, retro payments and deductions on top, so the year’s total rarely matches what went into the bank. Sorting it out at year end in a rush is how income lands in the wrong year.

The Milk cheque reconciler totals the year’s milk statements, matches each payment to the bank deposits in the Xero export you send and lists retentions, back payments and queries still open at 30 June.

When · Scheduled
Mid June, ahead of the end of the financial year
You get
Milk income by month for the financial year; payments matched to the bank; open queries and amounts owed; summary for the bookkeeper and accountant
Approval level
Recommend. Suggests an action. You do it. You can change it.
Useful for
Dairy

What it reads

  • Every milk statement for the financial year
  • Bank deposits from the processor, from a Xero export you send
  • Open queries with the processor
  • Your contract’s payment timing

What you get

  • Milk income by month, as invoiced and as paid
  • Each statement matched to a deposit, with any gaps
  • Open queries and amounts still owed at 30 June
  • A summary for the bookkeeper and accountant

When it stops and asks you

  • A deposit doesn’t match any statement
  • A retro payment covers the old and new financial years
  • Some milk was supplied under a sharemilking split

How often

Once a year in June

Who uses it

OwnersThe farm officeAdvisors and consultants

On other farms

  • Dairy: For sharemilkers, it splits income by the share in the agreement so both parties’ figures match.

What it uses

Live

Inbound email

Forward invoices, kill sheets, NVDs, soil tests and emails from your stock agent to your own farm address. The team reads each one, sums it up and suggests who handles it.

The last one makes it better, but it works without it.

Nothing official leaves the farm without your yes.This job runs at Recommend: suggests an action. You do it. You can change that any time.

See the guardrails

The conversation

How the job plays out, step by step.

2 agents on it

Started 6:00am · Scheduled

Start to done
3 min
Agent actions
6
Needed you
1×
[AGENT NAME]For the Milk cheque reconciler

On schedule · 6:00am

15 June: year-end milk income reconciliation

Milk cheque reconciler

Totalled 11 statements and matched each to a deposit

Milk cheque reconciler

Listed the open items at year end

Year’s milk income so far: [amount] across 11 statements, 10 matched to the bank. Open at 30 June: May’s payment, the [month] deduction query, and the retro step-up announced but not paid. Send the summary to [bookkeeper] so it’s in before the accountant asks?

[AGENT NAME] · 6:00am

Approved

Send it.

You · 6:02am

Milk cheque reconciler → Bookkeeper

Passed the reconciliation and open items to the bookkeeper

Done · 6:03am4 saved

  • Milk income by month, as invoiced and as paidSaved
  • Each statement matched to a deposit, with any gapsSaved
  • Open queries and amounts still owed at 30 JuneSaved
  • A summary for the bookkeeper and accountantSaved

Behind the scenes

  1. 6:00am

    Trigger On schedule

    15 June: year-end milk income reconciliation

  2. 6:00am+13 sec

    Milk cheque reconciler works on it · 3 steps

    Totalled 11 statements and matched each to a deposit

    • documents.readstatements Jul to May
    • Xero export you sent: processor deposits
    • 10 matched, May deposit not yet in
  3. 6:00am+10 sec

    Milk cheque reconciler works on it · 2 steps

    Listed the open items at year end

    • Query on the [month] deduction open
    • Retro step-up for [month] announced, not yet paid
  4. 6:00am+2 sec

    [AGENT NAME] messages you

    “Year’s milk income so far: [amount] across 11 statements, 10 matched to the bank. Open at 30 June: May’s payment, the [month] deduction query, and the retro step-up announced but not paid. Send the summary to [bookkeeper] so it’s in before the accountant asks?”

  5. 6:02am+3 min

    You approve

    “Send it.”

  6. 6:03am+8 sec

    → Bookkeeper picks it up

    Passed the reconciliation and open items to the bookkeeper

    • reports.draftFY milk income summary
  7. 6:03am+3 sec

    Milk cheque reconciler Done

    Financial year milk income checked against the bank export; three open items listed with amounts; summary with the bookkeeper for the accountant

An example with made-up data. Names and figures in [brackets] are placeholders.

The agent behind it

Milk cheque reconcilerDairy

The Milk cheque reconciler checks every milk statement against your vat records: litres, fat, protein, step-ups and deductions.

What it won’t do

  • Send a query to the processor without asking first
  • Change the vat records to match the statement
  • Give financial advice on your contract

More jobs the Milk cheque reconciler does.

Put [AGENT NAME] to work on your farm.

We’re taking a small number of pilot farms in Australia. Start with one or two agents and add more as you go.

Pilot farms wanted

Want to try it out?

Join the pilot, or book a demo and we’ll walk you through this job on a farm like yours. You text the team from your phone. Some connections are still being built, and we’ll tell you which.

  • Inbound email
  • Nothing to install

Free report

Getting started with AI.

A free practical guide for Australian farms and agribusinesses

Where AI actually helps on a farm, what it needs from you, the risks to watch, and a 90-day plan to start small.

  • Where it actually helps
  • What it needs from you
  • Risks and guardrails
  • Working out the return
Book a demoJoin the pilot