Mass-Balance Table¶

Accounting tool — instantiates Conserved Reservoir-Flux Balancing

Lays every measured inflow and outflow of a conserved quantity into one ledger so inputs minus outputs must equal the change in stock — and any residual is flagged, not buried.

The Mass-Balance Table is the arithmetic that a conserved quantity cannot escape: for a chosen boundary and period, everything that flows in must equal everything that flows out plus whatever accumulated inside. It lays each measured flow into a single ledger — inputs as one column, outputs and losses as another, the change in stock as the closing line — and requires the books to close. What makes it this mechanism rather than a picture (that's the Sankey Flow Map) or a live gauge (the Reservoir Balance Dashboard) is that its whole product is the residual: the gap between what went in and what can be accounted for. A balance that closes to zero is reassurance; a balance that doesn't is a finding — a leak, a mis-metered flow, double counting, or theft made visible precisely because conservation forbids the numbers from simply not adding up.

Example¶

A materials-recovery facility wants to know where a month of incoming recycling actually goes. The boundary is the plant; the period is the month; the conserved quantity is mass. Inputs: ≈4,200 tonnes of mixed material across the inbound weighbridge. Outputs: baled cardboard, aluminium, PET, and glass sold to buyers; residual sent to landfill; a moisture-loss term. Accumulation: the change in material sitting on the tip floor. Summed, the outputs plus accumulation fall short of the inputs by about 6%.

That 6% is not written off as "shrinkage" — it is the reason to run the table. Investigation traces roughly four points to an out-of-calibration outbound scale that under-weighed every sold bale, and most of the rest to moisture evaporating from cardboard between intake and baling. Two flows that had been invisible are now named and sized. The value isn't the tidy final ledger; it's that conservation turned a vague sense of "we seem to lose some" into a specific, assignable discrepancy someone can fix.

How it works¶

One quantity, one boundary, one period. Fix what is conserved, where the walls are, and over what interval — the table is meaningless without all three.
Every flow gets a row, with a sign convention. Inflows positive, outflows and losses negative; the change in stock is the balancing line the rest must reconcile to.
Normalise units first. All rows are converted to a common unit (it consumes the Unit Conversion Crosswalk) before anything is summed.
Close the balance, then interrogate the residual. The defining discipline: the leftover gap is a finding to explain, never a reconciling plug to make the sheet look tidy.

Tuning parameters¶

Boundary and period granularity — a plant-per-year balance hides what a unit-per-shift balance exposes; finer boundaries localise the leak but multiply the metering.
Closure tolerance — how small a residual counts as "balanced." Set it by the honest precision of your meters, not by the size of gap you'd rather ignore.
Line-item granularity — one lump outflow or an itemised breakdown; itemising surfaces where the loss lives but demands more measurement.
Sign and accumulation convention — whether stock change sits on the input or output side; harmless if consistent, a silent double-count if not.
Residual treatment — the integrity dial: explain the gap, or absorb it. Absorbing it destroys the whole point.

When it helps, and when it misleads¶

Its strength is that it converts "roughly balances" into an explicit closure with a named residual, catching metering errors, leaks, unrecorded transfers, and double counting that no eyeballing would find. It is the numeric backbone the archetype's other mechanisms draw on.

Its classic misuse is the balancing figure, or "plug" — forcing the sheet to close by routing the residual into an "unaccounted" or "shrinkage" line, so the table always balances and therefore never tells you anything.^[1] A tidy closed balance can also lend false precision when the underlying flows are poorly metered — the arithmetic is exact even when the inputs are guesses. The discipline that keeps it honest is to hold a stated tolerance and treat any residual above it as an open finding with an owner, rather than a number to bury.

How it implements the components¶

The Mass-Balance Table realises the archetype's arithmetic-and-closure core — the components an accounting ledger can actually fill:

conservation_balance_equation — the table is the equation in = out + Δstock, evaluated over the period for a specific boundary.
inflow_outflow_rate_measure — each row is a measured flow quantity; assembling them is the measurement step made concrete.
balance_reconciliation_rule — the closure test plus its tolerance is the rule that turns a leftover gap into a reconciled result or a flagged discrepancy.

It does NOT map the reservoirs' structure or topology — that's the Stock-and-Flow Diagram and Sankey Flow Map — nor track where losses go (Loss-Sink Audit), nor define a specific resource's boundary and sources (Water or Resource Budget).

Instantiates: Conserved Reservoir-Flux Balancing — the Mass-Balance Table supplies the closed numeric balance the rest of the network reasons from.
Consumes: Unit Conversion Crosswalk — every flow must be in a common unit before the rows can be summed.
Sibling mechanisms: Water or Resource Budget · Sankey Flow Map · Stock-and-Flow Diagram · Reservoir Balance Dashboard · Material Flow Analysis · Loss-Sink Audit · Data Lineage Balance Check · Inventory Reconciliation Workflow

Notes¶

The product of a Mass-Balance Table is the residual, not the closed books. A table that balances perfectly on the first pass is either trivially instrumented or hiding a plug — genuine measurement almost always leaves a gap worth explaining. Keeping the residual visible is what separates this tool from a spreadsheet that merely looks reconciled.

References¶

[1] In accounting a balancing figure or "plug" is an entry inserted to force a statement to reconcile. Used openly as a flagged unknown it is harmless; used to make discrepancies disappear it defeats the purpose of reconciliation, which is exactly why a mass balance must treat its residual as a finding rather than a plug. ↩