Mass-Balance Reports: R2v3's Favorite Spreadsheet, Generated

Mass balance is the R2v3 (and several other standards') requirement that says: for every kilogram you receive, you must be able to account for where it ended up. Resold, recycled, destroyed, returned, or still in inventory — but accounted for. The mass-balance report at /core/reports/mass-balance is the calculation that proves it, built from the same asset and order rows the warehouse created while doing the work.

The snapshot

A report is a snapshot of one period, a month or a quarter, generated on demand by an admin or manager. Inbound is every asset received in the window, in units and in kilograms from the category weights. Outbound is every outbound order shipped in the window - shipped, partially shipped or delivered - with its items grouped by intended disposition: resale, recycling, destruction and return to client. Processed counts what moved through the workflow, and stock remaining is what the period left behind on the racks. Category and material-stream breakdowns sit underneath the flow totals. The snapshot is stored, so the number the auditor saw in March is the number the auditor sees in September.

Why shipped orders, not settlements

Outflow is counted when the goods physically leave, because that is what a mass balance is about. A settlement can close weeks after a truck departed and says how money moved, not how mass moved. Anchoring the out-side on shipped outbound orders means a report for the current quarter already shows the pallets that left last Tuesday, whether or not finance has caught up. Kilograms do not wait for invoices.

What the auditor gets

The report exports to CSV for the line-level view and opens as a printable mass-balance certificate for the summary view. Both are built from the same stored snapshot, so the two never disagree. Exporting is itself an activity event, and the export is refused if that event cannot be written - an evidence document that leaves no trace of having left is not evidence.

Garbage in, garbage weighed

The snapshot inherits the quality of the records under it. Assets received without a category get no weight; outbound orders never marked shipped never leave; a disposition nobody set falls outside the resale-recycling-destruction split. The report is honest about that inheritance. It does not invent kilograms to make the columns meet, and an out-side that reads suspiciously low is usually a shipping status somebody forgot rather than a hole in the floor.