Batch losses by stage report
The Batch losses by stage report shows where each batch's volume went, one row per batch: what went in, what was lost at each stage, and what left the batch as packaged stock or as part of another batch. The figures add up, so you can see exactly where a batch lost volume rather than just how much it lost in total.
Find it under Reporting → Pre-built Production & inventory reports → Batches & production.
Running the report
- Choose a date range.
- Under Which date should the date range apply to?, choose Brew date or Completion date. A batch's completion date is the date of its last action, so if you choose the completion date, batches that are still in progress are left out.
- Choose to view the report in your browser, or export it to Excel or CSV.
Reading the results
Each row is one batch, showing its batch number, beer, status and brew date, followed by its target volume. The volume columns are grouped under four headings.
Into the batch
| Column | What it means |
|---|---|
| Volume brewed (before brewhouse loss) | The volume brewed, before anything was lost in the brewhouse |
| Brewhouse loss | Volume lost between the brewhouse and the batch's first vessels |
| Merged in from other batches | Volume that came in from another batch through a merge |
| Volume added | Volume added to the batch later on |
| Total volume | What went into the batch's first vessels, plus anything merged in or added |
Losses after the brewhouse
| Column | What it means |
|---|---|
| Loss into fermenters | Volume lost transferring into fermenters |
| Loss into brite tanks | Volume lost transferring into brite tanks |
| Loss into other vessels | Volume lost transferring into any other vessel |
| Packaging loss | Volume lost when packaging, including volume lost sending a batch for off-site packaging and any shortfall in what an off-site packager returns |
| Wasted volume | Volume left behind in a vessel when it was emptied |
| Volume removed | Volume removed from the batch |
| Other process losses | Volume lost extracting an ingredient batch or converting to a serving batch |
| Total loss (including brewhouse loss) | All of the losses above, plus the brewhouse loss |
Out of the batch
| Column | What it means |
|---|---|
| Extracted as ingredient | Volume extracted from the batch as an ingredient batch |
| Converted to serving batch | Volume converted into a serving batch |
| Transferred out to other batches | Volume merged or split out into another batch |
| Volume packaged | Volume packaged from the batch |
| Still in progress | Volume still in a vessel, or out at an off-site packager. For a contract brew, this is the volume you're still expecting to receive |
| Unaccounted volume | Whatever is left once everything else is counted |
After packaging
Packaged stock spoiled, Packaged stock lost and Packaged stock sampled show packaged stock marked as spoiled, lost or taken as samples. These happen after the batch has been packaged, so they aren't part of the total loss.
The table ends with a totals row for each volume column.
How the percentages work
In the browser, the main loss columns show a percentage under each volume, and each percentage says what it's measured against:
- Brewhouse loss is a percentage of the volume brewed.
- Loss into fermenters, Loss into brite tanks, Loss into other vessels, Packaging loss and Volume packaged are percentages of the total volume.
- Total loss includes the brewhouse loss, so it's a percentage of the total volume plus the brewhouse loss.
In an Excel or CSV export, each of these percentages has its own numeric column straight after its volume, such as Packaging loss (% of total volume), so you can sort and chart them.
What counts as a loss
- Volume merged or split out into another batch isn't a loss. It's shown under Transferred out to other batches, and the losses that happen to it after that are shown on the other batch's own row.
- Volume removed from a batch counts as a loss in this report, so totals here can differ from the volume shown on the batch itself.
- Packaged stock that's spoiled, lost or sampled is shown separately at the end and isn't included in Total loss.
Unaccounted volume
Unaccounted volume is normally zero. If it isn't, a volume recorded on that batch may have been changed after later steps were recorded. Use the View batch flowchart row action to check the batch, and correct the volume that's out of step.
Row actions
Each row offers View batch to open the batch, and View batch flowchart to open its flowchart with the volume reconciliation for that batch.
Volume reconciliation on the batch flowchart
You can see the same figures for a single batch on its flowchart. Open the batch, go to the Actions tab and press View as flowchart. Below the flowchart, a Volume reconciliation card lists the batch's volumes under the same headings as this report, along with its Start volume, the volume the batch started with after the brewhouse loss.
For a batch that wasn't brewed at your brewery, such as a blend, a split or a contract brew, the brewhouse rows show Not brewed here. Batches created by a data import have no production history to reconcile, so the card says so instead of showing figures.
The flowchart itself also shows losses as they happen: transfers, merges and packaging steps show the volume lost and which kind of loss it counts as, and steps that add or remove volume show the change and the volume that results, such as "+ 50 L added = 1,050 L".
How this report relates to the other production reports
The Batch losses by stage report shares its volume figures with these reports, so they agree with each other:
- Completed batch yields shows a batch's Total volume and works out its yield as the volume packaged, transferred out to other batches, converted to serving batches or extracted as ingredients, divided by the total volume. Volume removed from a batch counts as a loss rather than reducing the total volume. For a contract brew, the total volume is the volume actually received.
- The batch efficiency report uses the same Total volume for its loss and yield percentages.
- The beer loss report lists the individual losses behind these totals, and can group them by batch.