Stock movements log & shrinkage dashboard

Also known as: movimientos, audit log, stock history, shrinkage, mermas, unexplained loss, perdida no explicada.

The reason brasio tracks every stock movement (sales, waste, deliveries, stocktake adjustments) as an append-only event log is so you can answer the question: "Where did that bottle go?"

Two screens surface this data.

The movements log

Admin → Inventario → Movimientos — every stock movement in the chosen date range, paginated to 500 rows max.

Filters:

• Date range (default: last 7 days; widens to 1 year when deep-linked from a product).
• Category dropdown (includes all sub-categories of a parent).
• Type chips: Sale, Goods in, Waste, Adjustment, Void.
• Optional product filter (set when you arrive from a product editor's "See full history" link).

Each row shows:

• Time, product, type
• Quantity delta — size-aware for waste (e.g. 1 × Small (330ml)) and stock-unit for the rest (+1 barril, −5 botellas).
• Operator who did it
• Reason text (notes, supplier name, etc)
• Cost impact in euros

KPI strip at the top shows totals per type for the visible range. CSV export dumps the filtered view for your accountant.

The shrinkage dashboard

Admin → Inventario → Mermas — the same data, transposed: one row per product with all the deltas in columns.

Columns: Opening stock · Goods in · Sales out · Voids out · Waste out · Stocktake adjustment · Expected close · Actual close · Unexplained delta · Unexplained cost.

The unexplained column is the killer: actualClose − (opening + goodsIn − salesOut − voidsOut − wasteOut + stocktakeAdjustment). If this is non-zero, stock has moved without being recorded — most often a forgotten waste entry, an unlogged staff drink, or a missed pour.

KPI tiles up top: total unexplained cost (in red), total declared waste cost (for context).

Stock history on the product editor

Don't need the full log? Open any product in Admin → Catálogo, scroll to the Stock history collapsible at the bottom. Last 20 movements for that product, with a "See full history" link that deep-links into the Movements tab pre-filtered to the product.

Reading the report

A healthy bar will see:

• Declared waste cost in the low single-figure € per day per category.
• Unexplained loss at zero or very close, across most products.

Flags worth investigating:

• A single product with consistently high unexplained loss → likely staff not recording personal drinks. Recording-waste training + the staff-drink reason chip usually fixes it.
• Unexplained loss spikes on stocktake days → the count may be off. Re-count that product and the variance gets recorded as a stocktake adjustment.
• Declared waste consistently zero on a busy category → no one is recording. Long-press is fast; spread the habit.

Not working?

• CSV download fails: make sure you're logged in (the API requires the Bearer token). Refresh and try again.
• Movements log says "0 movements" but I know there were sales: check the date range and that the Sale type chip is active. The default is last 7 days only.
• Shrinkage shows "unexplained: 0" everywhere: either business is genuinely clean, or no stocktakes have been recorded in the range — without a counted close, actual close equals expected close and the gap stays at zero by construction. Run a stocktake first.
• A waste shows cost 0 €: the original product had no container cost set when the waste was recorded. Newer entries are correct once cost is added.

Related

• Recording waste
• Stocktake
• Goods-in