What does the livestock tally spreadsheet track?

It tracks date, property or paddock, livestock type, breed or class, opening head, animals in, animals out, closing head, average live weight, price per head, stock value, notes, issue flag, target weight, weight status and mortality rate %.

Who is this template best for?

It suits a station hand, farm manager, rural bookkeeper or small farm owner who needs a simple daily stock movement register without moving straight into specialised livestock software.

Can I use it for cattle and sheep?

Yes. The sheet is set up for multiple livestock types, so you can record cattle, sheep or other stock lines side by side and keep the breed or class consistent through the Reference Data sheet.

How does the template help with stock value?

You enter average live weight and price per head, and the spreadsheet gives you a stock value line. That makes it easier to compare mobs and to see where a movement or valuation issue needs checking.

What should I do if the closing head looks wrong?

Check the opening head, births or purchases in, and sales, deaths or losses out on the same line first. If the total still does not make sense, use the notes and issue flag to trace the problem before the week rolls on.

When should I move from this spreadsheet to software?

Move on when you need live integration, more advanced reporting, joined-up animal history or multiple users updating the same data at once. If you are only doing weekly or monthly counts, this spreadsheet is usually enough.

Inventory & Purchasing

Livestock Tally Excel - Free Template

Track herd and flock movements, weights, stock value, mortality and issue flags in one livestock tally spreadsheet.

2026-07-14

281 Downloads

4.8/5 Average rating

Download template

Screenshot 1: Livestock Tally tab - Excel template livestock tally excel spreadsheet australia

This livestock tally Excel spreadsheet is a daily herd and flock register for counting movements, weights, stock value and mortality in one place. It includes a tally sheet, reference data, a summary dashboard and instructions.

Use it to keep on top of opening head, births, purchases, sales, deaths and closing head across paddocks or properties. The dashboard then rolls up the numbers so you can see stock value, mortality rate and issue flags at a glance.

It suits a station hand, farm manager, rural bookkeeper or family operation that needs a clean record of livestock movement without mucking around with a full farm system.

The key benefits of this Excel template

Tracks daily herd and flock movements across properties and paddocks.
Calculates closing head from opening head, inflows and outflows.
Shows stock value in AUD using head count and price per head.
Flags issues quickly when movement, weight or mortality looks off.
Helps you spot mortality trends before they turn into a bigger loss.
Gives you a simple summary for cattle, sheep and other livestock types.
Keeps a dated record that is easy to reconcile after muster, sale or culling.

Step-by-step guide

Enter each movement on the Livestock Tally sheet. Add the date, property or paddock, livestock type, class and head counts.
Check the opening head, animals in, animals out and closing head fields. This helps you spot a tally error straight away.
Fill in live weight, price per head and notes for each line. That gives you a quick stock value and context for the movement.
Use the Reference Data sheet to keep your drop-down lists tidy. That makes entry faster and keeps livestock types and classes consistent.
Review the Summary Dashboard after each muster or sale run. Use it to compare totals, issue flags and mortality across the period.
Follow the Instructions sheet if someone else needs to take over. It keeps the process the same from week to week.

Screenshot 2: Reference Data tab - Excel template livestock tally excel spreadsheet australia — Figure 2: Worksheet "Reference Data"

What is included

Daily movement register with date, location, livestock type and breed or class.

Headcount columns for opening stock, stock in, stock out and closing stock.

Live weight, price per head and stock value fields.

Issue Flag, Weight Status and Mortality Rate % checks.

Reference Data sheet for list management and cleaner data entry.

Summary Dashboard for quick review of totals and problem lines.

Instructions sheet for simple handover and repeat use.

How this livestock tally spreadsheet helps on the farm

This spreadsheet is built for the people who actually count stock: a station hand after a muster, a farm manager checking a paddock move, or a rural bookkeeper chasing a clean record before month end. If you have 4 mobs of cattle moving through 6 paddocks, or 500 sheep split across a drought feed lot and a holding yard, the tally stops the numbers drifting.

When you need it most

The pressure points are familiar: after a sale yard consignment, at weaning, during tagging, or when you are checking losses after bad weather. A cattle property with 120 head, 8 born or purchased in and 5 sold, dead or lost out needs a clean closing head of 123 before the next muster. That is where a proper reconciliation matters.

What you can see at a glance

The Livestock Tally sheet gives you date, property or paddock, livestock type, breed or class, opening head, movements, closing head, live weight, price per head and a notes field. The Summary Dashboard then rolls those lines up so you can check cash flow pressure from sales timing, spot a weak mob, or compare cattle versus sheep performance without digging through pages of notes.

Why a spreadsheet beats loose notes

With a paper tally book, one missed line can leave you 12 head out by the end of the week. In this file, the same line can carry a 215.00 kg average live weight and a $2,150.00 stock value, so you are not just counting heads — you are tracking value.

Screenshot 3: Summary Dashboard tab - Excel template livestock tally excel spreadsheet australia — Figure 3: Worksheet "Summary Dashboard"

What the ATO expects if livestock is part of your business

If livestock is part of a business, the record-keeping side matters just as much as the counting. The ATO expects you to keep records for 5 years, including stock movement records, invoices, sale dockets and anything that supports your tax return.

Business records and stock values

For tax, livestock usually feeds into trading stock or farming income records, not just a notebook tally. If you sell 18 steers at $1,450 each, that is $26,100 in income, and the record needs to line up with sale dockets and your stock on hand at year end.

GST, ABN and invoicing

If you are registered for GST, the 10% rate applies to taxable sales and you need proper tax invoices with your ABN, the words Tax Invoice, the date, and GST shown separately when the total is over $82.50. If your livestock turnover hits $75,000 a year, GST registration is required; for a not-for-profit it is $150,000.

Why timing and structure matter

Most small farms and rural operators report on a quarterly BAS, so the tally helps you back up the sales and purchases that feed into that lodgement. A sole trader can use the spreadsheet to support income tax and stock movement records, while a Pty Ltd farm business registered with ASIC can use it alongside the balance sheet and profit and loss, especially where stock on hand changes sharply after weaning or drought culling.

Where livestock tallies go wrong and what it costs

The biggest mistakes are usually simple, but they cost real money. If you overcount by 6 calves at $650 each, you have $3,900 of stock value that is not actually there, and that can throw out your profit and loss as well as your year-end reconciliation.

Wrong head counts and bad timing

A common problem is entering the sale after the animals have already left the paddock, or forgetting the deaths from a bad week of weather. On a 340-head sheep mob, missing 12 sold or lost out and then carrying the old closing head forward can make every later figure wrong, including the mortality rate.

Price errors and valuation drift

If one mob is written at $175 per head and another at $228 per head, a small data-entry slip can move the stock value by thousands. On 86 head, a $50 error per head is a $4,300 mistake, and that is before you look at how it affects gross margin on the livestock enterprise.

Issue flags are there for a reason

The Issue Flag and Mortality Rate % fields are not decoration. If 18 animals are lost from a 510-head mob, that is 3.53%, which is a number worth checking against drought, predator pressure, transport stress or a counting mistake before you rely on the figure in the dashboard.

The other trap is poor notes. A line that says only mustered tells you nothing three months later, whereas routine muster, shearing prep or sale yard consignment gives you enough context to explain the movement when you are back in the books.

Screenshot 4: Instructions tab - Excel template livestock tally excel spreadsheet australia — Figure 4: Worksheet "Instructions"

How to make livestock tallying a weekly habit

To make this stick, tie it to something you already do. Most farms have a weekly muster, feed run or sale check, so that is the time to update the spreadsheet rather than leaving it for the end of the month.

Set a fixed update routine

Do the entry on the same day every week, then spend 10 minutes checking opening head against closing head. That is enough time to catch a mob that moved from 74 to 68 without a note, which is far easier than untangling it 3 weeks later.

Use the workbook to keep it clean

Copy the last row structure forward so the next line stays consistent.
Use the Reference Data sheet to standardise livestock types, breeds and paddocks.
Let the dashboard flag odd numbers before you sign off the week.

If you get to the point where you need mob history, weight gain curves, join records or serialised ear-tag tracking, you have probably outgrown a spreadsheet. That is the point to move to farm software such as Xero add-ons, MYOB or a proper livestock management system, while still keeping this file as a simple backup and checking tool.

Frequently asked questions about this template

It tracks date, property or paddock, livestock type, breed or class, opening head, animals in, animals out, closing head, average live weight, price per head, stock value, notes, issue flag, target weight, weight status and mortality rate %.
It suits a station hand, farm manager, rural bookkeeper or small farm owner who needs a simple daily stock movement register without moving straight into specialised livestock software.
Yes. The sheet is set up for multiple livestock types, so you can record cattle, sheep or other stock lines side by side and keep the breed or class consistent through the Reference Data sheet.
You enter average live weight and price per head, and the spreadsheet gives you a stock value line. That makes it easier to compare mobs and to see where a movement or valuation issue needs checking.
Check the opening head, births or purchases in, and sales, deaths or losses out on the same line first. If the total still does not make sense, use the notes and issue flag to trace the problem before the week rolls on.
Move on when you need live integration, more advanced reporting, joined-up animal history or multiple users updating the same data at once. If you are only doing weekly or monthly counts, this spreadsheet is usually enough.