Think Build Implement Repeat
London, UK +44 7367 067226
WhatsApp FOLLOW f in X
  1. Home
  2. Blog
  3. How Do We Record Each Grain and Malt Delivery So We Know Which Lot Went Into Which Mash?
Problems We Solve

How Do We Record Each Grain and Malt Delivery So We Know Which Lot Went Into Which Mash?

Distillery grain and malt deliveries are logged on paper with specs in email. We build an intake record per lot that links to each mash and spirit run.

Updated 2 min readBy SpiderHunts Technologies

Free estimateNo obligation

Get a free estimate

Tell us what you need. A senior engineer reads every enquiry.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →

Quick answer — TL;DR

Malt and grain arrive by the tonne with delivery notes and specification sheets, and the link between a lot and the mash it went into is often lost. We build an intake record for each delivery with its supplier, lot, specification and any checks you do, track it into silo or store, and link each mash to the lots used, so spirit character and yield can be traced to what went in.

A lorry at the silo

The malt lorry arrives. The delivery note is signed and put in a tray. The spec sheet from the maltster arrives separately by email. The malt goes into the silo on top of what was already there. Weeks later, yields seem lower and the new make a touch different. Which malt lot was in those mashes? The delivery note is in the tray, the spec in someone's inbox, and the silo has been topped up twice since.

Grain and malt handling is physical and continuous. Deliveries go into silos or bins that already hold previous lots, so lots mix. Specs and certificates come by email. Mash records note the amount of grist, not the lot. Without a simple rule for how lots are tracked through storage, the link from grain to spirit is lost at the silo.

  • Delivery notes are filed on paper.
  • Spec sheets arrive by email and are not linked to the lot.
  • Silos mix lots with no record of the order.
  • Mash records do not note lots used.
  • Intake checks, if done, are written in a notebook.

Changes in yield or character cannot be traced to a supplier or lot. Conversations with your maltster are based on impressions. Questions from customers or auditors about your raw materials are harder to answer. And records needed for your own quality work or adviser are rebuilt by hand.

An intake record per lot

  1. Each delivery is booked in on a tablet at intake: supplier, lot, quantity, delivery note photo, and the silo or store it goes to.
  2. Spec sheets and certificates from the supplier are attached to the lot, picked up from the email automatically where possible.
  3. Any intake checks you do, moisture, visual or others, are recorded against the lot.
  4. Silo contents are tracked as a sequence of lots, using the rules you choose, for example first in first out, or mixed proportions.
  5. Each mash records the grist taken, and the system estimates which lots it came from, using your silo rule.
  6. Mash, fermentation and still run records link through, so spirit and casks can be traced back to grain lots.
  7. Reports compare yield and your quality notes by supplier and lot.
LinkBeforeAfter
Delivery to lotPaper noteIntake record
Lot to specificationEmailAttached
Lot to siloUnrecordedSilo sequence
Silo to mashGrist amount onlyLots estimated per mash
Mash to spiritSeparate recordsLinked

Tracing spirit back to the field

Every mash has a record of the lots most likely in it. Yield or character changes can be compared with supplier and lot. Specs and certificates are with the lot when anyone asks. Conversations with your maltster start from data. And your full chain, grain to cask to bottle, is traceable for the first time.

For distilleries that use their own grain or a single estate's barley, the same record supports the provenance story on the label, with the facts behind it recorded.

Is this your intake?

  • Delivery notes are filed on paper.
  • Spec sheets stay in email.
  • You cannot say which lot went into a mash.
  • Yield changes are hard to explain.
  • Grain-to-spirit traceability depends on dates and guesswork.

FAQ

Frequently asked questions

The questions readers ask us after this guide.

Still have a question?

Ask us directly — a senior engineer will get back to you.

Ask about your project

How can you know which lot is in a mash if silos mix?

We estimate it from the silo sequence and the rule you choose. It is an estimate, and we show it as one.

Can it pick up spec sheets from email?

Yes, if suppliers send them to a dedicated address. Documents are matched to lots and any unmatched ones go to a person.

Does it work for gin distilleries using neutral spirit?

Yes. Neutral spirit deliveries are recorded by lot in the same way and linked to gin batches.

What affects the cost?

The number of suppliers and silos, how many checks you record, and how far through to casks and bottles you want the link to go.

Keep reading

More on Problems We Solve

Start here

Tell us where the distillery's records let you down

Describe the problem, where your cask, production and sales records live today, and roughly how many casks, releases and visitors you handle. We will tell you what we would build and what we would leave alone, and if your existing system can do it with better set-up, we will say so.

  1. You tell us what you needTwo minutes on the form, or a message on WhatsApp.
  2. A senior engineer reviews itAnd comes back with questions, a realistic range and an honest view on fit.
  3. Free 30-minute scoping callWe talk through scope, options and a realistic estimate — with no obligation.
Free estimateNo obligation

Talk to someone who builds this

Send a short brief and we will come back with an honest view and a realistic range.

Takes under a minute. We never share your details.

  • Free consultation
  • No commitment
  • NDA on request

Prefer to talk? Book a free 30-minute call →