Stock valuations

Breww's stock valuation tool calculates the total value of all stock held by your brewery at a point in time. It covers five categories of stock: work-in-progress (WIP) beer, packaged beer, stock items (raw materials), ingredient batches, and serving batches. Each valuation is stored as a snapshot, so you can track how your stock value changes over time.

Accessing the stock valuation tool

To access stock valuations, navigate to Reporting and then Stock valuations. This page shows a list of all previously generated stock valuation reports, with the most recent at the top.

From this page you can:

• Run a stock valuation — Click the Run stock valuation button to manually trigger a new valuation. Breww will calculate the value of all your stock in the background and redirect you to the results when complete.
• View a previous valuation — Click the eye icon on any row to see its summary and the assumptions that were used.
• Adjust settings — Click the Valuation settings button to configure how valuations are calculated and scheduled.

Understanding a stock valuation report

When you view a stock valuation report, you'll see a summary showing:

• Grand total — The combined value of all stock across every category.

• WIP total — The value of beer that is still in production (e.g. fermenting, conditioning) and has not yet been packaged.

• Packaged stock total — The value of beer that has been packaged into containers and is in your inventory.

• Stock item total — The value of raw materials (e.g. malt, hops, yeast) that you have in stock but have not yet allocated to a batch.

• Ingredient batch total — The value of ingredients that have been pre-allocated to batches but not yet used.

• Serving batch total — The value of beer held in serving batches (e.g. for taproom or on-site sales).

  Below the summary, you can see the assumptions that were used when this valuation was generated, including the wastage option and any additional per-container values.

  For a full line-by-line breakdown of how every figure was calculated, click Export as Excel file in the top-right corner of the report. This downloads a detailed spreadsheet showing each individual item, its quantity, per-unit value, total value, and the stock type category it belongs to.

Running a stock valuation manually

To run a valuation on demand:

1. Go to Reporting → Stock valuations

2. Click Run stock valuation

3. On the manual create page, click Manually run a stock valuation now

4. Breww will process the valuation in the background and redirect you to the completed report

   This page also shows your current automatic schedule (if one is configured), or a note that automatic valuations are not enabled.

Setting up automatic stock valuations

Breww can run stock valuations automatically on a schedule, so you always have up-to-date figures without needing to remember to run them manually.

To configure a schedule:

1. Go to Reporting → Stock valuations → Valuation settings

2. Tick Run automatic stock valuations

3. Set a schedule using the schedule picker (e.g. "At 12:00 AM on the 1st of every month")

4. Click Save

   The minimum interval for automatic valuations is 7 days. We recommend running them monthly on the 1st at midnight, which aligns with most accounting periods.

   Once enabled, Breww will automatically generate a stock valuation report at each scheduled time. These reports appear in the stock valuations list alongside any manually triggered reports, and you can view or export them in the same way. The report will show as "Automatic" in the "Run by" column.

   To disable automatic valuations, untick the Run automatic stock valuations checkbox and save.

Configuring wastage options

When Breww calculates the value of your stock, it needs to account for wastage — the beer lost during the brewing and packaging process. There are three options for how Breww handles this, which you can configure in Reporting → Stock valuations → Valuation settings.

No expected wastage

This assumes that all wastage is unexpected. Any beer lost during production will reduce the valuation of the remaining goods proportionally.

For example, if you brewed 1000 litres at a cost of £1,000 and lost 100 litres, the remaining 900 litres would be valued at £900 (the 100 litres of wastage reduces the total value).

Use recipe expected wastage (recommended)

This is the recommended option. Breww will look at the expected wastage set on each batch's recipe and compare it to the actual wastage.

• If you lost more than expected, the valuation is reduced proportionally (the excess wastage was an unexpected loss).

• If you lost less than expected, the valuation is increased proportionally (you retained more product than anticipated).

• If you lost exactly what was expected, the valuation remains at the full ingredient cost.

  This approach gives the most accurate picture of your stock value because it treats expected wastage as a normal part of production costs, while still flagging unexpected losses.

Ignore wastage

This ignores wastage completely. The value of your goods will always equal the cost of the ingredients, regardless of how much beer was lost. Wastage has no effect on the stock valuation.

Wastage example

To illustrate how each option affects the valuation, consider a 1,000 litre batch costing £1,000 with 10% expected wastage set on the recipe:

With No expected wastage, the value scales directly with the volume packaged. With Use recipe expected wastage, packaging 900L (exactly 10% wastage) retains the full £1,000 value, while packaging less reduces it and packaging more increases it. With Ignore wastage, the value is always the full ingredient cost regardless of volume packaged.

WIP additional value per unit of volume

You can add an additional value per unit of volume (e.g. per litre or per barrel) for work-in-progress beer. This accounts for the labour, energy, and overhead costs involved in brewing that go beyond just the ingredient costs.

This is configured in Reporting → Stock valuations → Valuation settings under the WIP additional value section.

Finished goods additional value per container

For packaged beer, you can add an additional value per container to account for packaging costs (labels, caps, cans, boxes, etc.). This is set per container type, so you can have different additional values for kegs, cans, bottles, and other container types.

This is configured in Reporting → Stock valuations → Valuation settings under the Finished Goods additional value per container section.

How Breww calculates stock value

Breww uses a cost-based approach to value stock. The value of each item is based on the cost of the ingredients and materials that went into it, plus any additional values you have configured (WIP additions and per-container additions).

The calculation works differently depending on the stock type:

• Stock items — Valued at their received cost (the price paid when the stock was received into Breww).

• Ingredient batches — Valued at the cost of the allocated stock items.

• WIP beer — Valued at the total cost of allocated ingredients, adjusted for wastage (based on your chosen wastage option), plus any WIP additional value per unit of volume.

• Packaged beer — Valued at the WIP value of the beer inside the container, plus any additional value per container for the container type used.

• Serving batches — Valued similarly to packaged beer, based on the cost of the beer allocated to the serving batch.

  Each valuation captures a snapshot of your settings at the time it was run, so changing your settings later will not affect previous reports — only future valuations.