Back to Blog
breedingstallionfrozen semenbusiness

Frozen Semen Inventory Spreadsheet (Free Template)

The columns a frozen semen tank log needs, how to count doses against straws, and a free spreadsheet and PDF template: tank sheet, straw log, nitrogen log.

By 10 min read

By Brian Bickell, who raises paint and quarter horses at Bickell Ranches in Stillwater, Oklahoma.

A frozen semen inventory spreadsheet needs three sheets: a tank sheet with one row for each batch in each cane (tank, canister, cane, stallion, freeze date, straws per dose, straws on hand), a straw log with one line for every straw that comes in or goes out, and a nitrogen log for each tank's level checks and fills. The free template on this page has all three as spreadsheet files that open in Excel, Google Sheets or Numbers, and as a printable PDF for the clipboard by the tanks.

The most common frozen inventory is a number written on a piece of tape on the tank lid. It works until the first time it is wrong, and then nobody can say when it went wrong or why. Somebody pulled two straws for a thaw check and didn't write it down. A breeding used four straws and the count came off the wrong cane. Straws for a client's mare went out with the shipper and the tape still says forty.

A tank needs a ledger, not a count. The count is what you look at. The ledger is how you know the count is right.

The Columns a Tank Log Needs

The tank sheet is one row for each batch in each cane: straws from one stallion, frozen on one date, in one place in the tank. If a batch is split across two canes, it gets two rows, because when somebody goes to the tank they go to a cane.

ColumnWhy it is there
Tank, canister, caneWhere the straws physically are. The whole point of the sheet is not having to lift canes to look.
StallionBy registered name. Outside stallions and stallions that have died get the same treatment as your own.
Whose strawsBlank when they are yours. A client's name when you store straws she owns, so they are never sold or used by mistake.
Freeze dateSeparates batches from the same stallion, and is what most freezing paperwork is filed under.
Batch or lot numberThe freezing center's or your own identifier, matched to the breeding instructions.
Straw colorHow the batch is recognized in the cane when the paperwork is not at hand.
Straws per doseFrom the batch's breeding instructions. The number that turns straws into doses.
Straws on handThe count, carried forward from the straw log.
Doses on handStraws on hand divided by straws per dose, rounded down, with any straws left over written beside it.
Last counted, and by whomWhen somebody last physically checked, so an old count looks old.

The straw log is the other half: one line every time the count changes, with the date, the tank, canister and cane, the stallion and batch, what happened (in, out, discard, move, or a count fix), how many straws, to whom or from whom, the mare and breeding it was used for or the reason, the straws left in that batch afterward, and who recorded it.

The nitrogen log is a third sheet, one line per check or fill per tank.

Free Download: Frozen Semen Inventory Sheets

A printable three-page tank log: a tank sheet with one row per batch and cane, a straw log for every straw in and out, and a nitrogen log for checks and fills, each with an example row.

Free. No credit card. Unsubscribe anytime.

The spreadsheet version, free with no email: the tank sheet, the straw log and the nitrogen log, as CSV files. Open each in Excel, Google Sheets or Numbers, delete the example row, and save it in your spreadsheet's own format. Keep all three in one workbook as three tabs.

Straws and Doses

Count straws. Work out doses from them.

Straws are what is physically in the cane, and what comes in and goes out. A dose is what a mare owner books and what a breeding uses, and a dose is however many straws the batch's breeding instructions say make one insemination. That number comes with the semen, from the freezing center or the stallion owner, and it varies from stallion to stallion and from batch to batch. So it is written on every row, not assumed.

The arithmetic is one division and one rule. Doses on hand is straws on hand divided by straws per dose, rounded down: 53 straws at 4 per dose is 13 doses and 1 straw, not 13.25 doses. The leftover straw is real and gets written beside the dose count, because a straw used for a thaw check, or two leftovers from different batches, still have to be accounted for.

Every straw that leaves the tank goes on the log, including the ones nobody bred with. A straw thawed to check a batch is a straw out, logged as a discard with the reason. A cracked straw is the same. A count that only goes down on breedings is a count that is wrong by every thaw check ever done.

The Straw Log: Every Straw In and Out

Six kinds of line cover everything that happens to a straw.

  • In. Straws frozen here from a collection, bought, or brought in to store for a client. From whom, and the paperwork that came with them.
  • Out to a breeding. The mare and the date. This is the line that ties the tank to the mare's breeding record, and the one most often missed.
  • Out to someone else. Sold, shipped to another farm's vet, or sent with a mare. To whom, by name, and the shipment.
  • Discard. Thaw checks, cracked straws, anything that left the tank and was not used. The reason.
  • Move. From one tank, canister or cane to another. The batch keeps its count and changes its place.
  • Count fix. A physical recount that did not match. The difference and the reason, if anyone knows it.

Straws on hand for a batch is everything in minus everything out. If the sheet ever disagrees with a physical recount, the count fix line is how the sheet gets corrected without typing over the old number, so the next person can see that it happened.

The Nitrogen Log

The nitrogen log is the oldest record in the tank room and the one most often kept on the tank lid. One line per check or fill for each tank: the date, the level before, the liters added on a fill, the level after, who did it, the supplier and its ticket number, and the date the next fill is due. Use the same unit every time, inches or centimeters on the dipstick, so the readings line up.

The schedule is the tank's and the supplier's, not this page's. Write it at the top of the sheet for each tank: fill every so many days, or below a level, and who to call. The log's job is to make a missed fill visible before it matters.

Straws Stored Somewhere Else

Straws at a storage facility or at the vet's are still inventory, and they still belong on the tank sheet with the facility as the tank. The difference is that the facility keeps its own record of every withdrawal and deposit, and its statement is the count of record for what it holds. Reconcile the spreadsheet against each statement as it comes, and write any difference as a count fix with the statement's date.

Where a Spreadsheet Stops Working

A spreadsheet holds a small, stable inventory well. It starts losing count at four points, and most farms with frozen semen reach all four.

The breeding is written down twice. A frozen breeding goes on the mare's breeding record, and its straws have to come off the tank sheet. When those are two files, one of them is updated in the barn and the other is updated later, or not at all. Every count that drifts starts here.

Straws that aren't yours, and stallions that aren't standing. A farm storing a client's straws needs to know which straws it may never sell or use. A farm holding stock from a stallion that has died, or from an outside stallion, needs those straws kept beside its own and counted the same way. A spreadsheet can carry a "whose straws" column, but nothing stops the wrong batch going out.

More than one person. The person thawing a straw in the breeding shed is rarely the person with the spreadsheet open. Two people editing one file overwrite each other, and a shared file with no record of who changed what can't say why a count is wrong.

More than one tank, in more than one place. A tank at the farm, a tank at the vet's, straws at a storage facility. Each has its own fill schedule and its own count, and "where are this stallion's straws" becomes a search across three tabs.

Frozen Semen in HorseBook

HorseBook's Tanks keeps the same records as the template, on iPhone, iPad and the web, as part of the Business plan.

Each tank lists its batches by stallion, with the canister, cane and straws on hand. A batch can belong to one of your stallions or to a stallion typed by name, so outside stallions and stallions that have died sit beside your own, and straws you store for a client are marked as hers. Each batch keeps the straw log: straws in, used on a breeding, discarded, moved, and count fixes. Its straws on hand are counted from that log and never typed over.

The double entry goes away at the breeding. Recording a frozen breeding asks which batch, and the straws come off that batch's count in the same step. Sell or send straws takes straws off and names who they went to. A stallion's frozen stock shows his straws in every tank at once.

Each tank keeps its nitrogen log too: check the level or log a fill with the date, the level and the liters added. Set the tank to refill every so many days or below a level, and HorseBook keeps one fill reminder for it, which shows in Needs you when a fill is due or a reading is low. A big stock goes in on the web as a table, one row per batch. The frozen semen tanks help covers collections, freezing logs and Tanks step by step.

HorseBook's Tanks counts your frozen semen by tank, canister and cane, for your own, outside and deceased stallions, takes the straws off when you record a frozen breeding, and reminds you when a tank needs filling. iPhone and web, and they sync.

Free to download · 14-day free trial


Brian Bickell is the founder of HorseBook and raises paint and quarter horses at Bickell Ranches in Stillwater, Oklahoma. This article is general information about frozen semen record keeping, not veterinary advice.

Frequently asked questions

How do you keep track of frozen semen in a tank?

With two records, not one. A tank sheet lists every batch by tank, canister and cane, with its stallion, freeze date, straws per dose and straws on hand. A straw log records every change to that count: straws in, straws used on a breeding, sold or sent, discarded, moved to another tank, or a recount. The count on the tank sheet should always be the result of the log, so a wrong number can be traced back to the line that made it wrong.

How many straws are in a dose of frozen semen?

It depends on the stallion and the batch. A dose is however many straws that batch's breeding instructions say make one insemination, and those instructions come with the semen from the freezing center or the stallion owner. Write straws per dose on every batch and count doses by dividing straws on hand by it, rounding down. Never assume two batches from the same stallion use the same number.

Should I count frozen semen in straws or in doses?

Count straws, and work out doses from them. Straws are what is physically in the cane and what comes in and goes out. Doses are what a mare owner books and what a breeding uses, so a tank sheet shows both: straws on hand as the count, and doses on hand as straws divided by straws per dose, with any straws left over written beside it.

What goes in a liquid nitrogen fill log?

One line per check or fill for each tank: the date, the level before, the liters added on a fill, the level after, who did it, the supplier and its delivery ticket number, and the date the next fill is due. Measure in the same unit every time so the readings can be compared, and write the next fill date before the lid goes back on.

When does a frozen semen spreadsheet stop working?

When the same straw has to be written down in two places, or by more than one person. A frozen breeding goes on the mare's breeding record and has to come off the tank sheet too, and when those are two different files they drift apart. Client-owned straws, outside stallions and stallions that have died, several tanks in several places, and two people editing one file at the same time are where most spreadsheet counts go wrong.