Organic Mass Balance Audit, Worked Through (Template)

An organic mass balance audit checks that the organic ingredients you bought account for the organic products you made, stored and sold: inputs account for outputs. Your inspector picks a product and a period, then works through your purchase records, stock counts, batch records and sales, and every quantity has to add up, with any difference small and explained. Alongside it comes a traceability exercise: one lot followed back to its supplier and forward to its customers. Since the Strengthening Organic Enforcement rule, both are written into what every on-site inspection must verify. Below is a quarter worked through for one product, the trace, and a free template to run your own before the inspector does.

The short version

• Pick a product and a period, the way the inspector will.
• Inputs: opening stock + organic purchased − closing count = used. Compare it with batches made × the recipe.
• Outputs: opening stock + made − sold − written off = what should be on the shelf. Compare it with the count.
• Check the organic inputs could have made the organic output, with nothing conventional slipped in.
• Trace one lot back to the supplier's certificate and forward to every customer.
• Explain every difference. A small one with a reason is fine; a gap with no reason is a finding.
• TaroStack keeps every movement of every lot, so the in-out is a report. More below.

What the rule says

Every on-site inspection must verify mass balances, "in that quantities of organic product and ingredients produced or purchased account for organic product and ingredients used, stored, sold, or transported," and that organic products are traceable from purchase through production to sale, back to the last certified operation (7 CFR 205.403(d)). Your records have to make that possible: span purchase through production to sale, be traceable to the last certified operation, be readily understood and audited, and be kept for at least 5 years (7 CFR 205.103). These came in with the Strengthening Organic Enforcement rule, effective March 20, 2023, with an implementation date of March 19, 2024 (USDA AMS).

The rule doesn't set a tolerance. Your certifying agent judges whether a difference is reasonable for your process. This is general information, not legal advice; your certifier has the last word.

Step 1: the organic inputs

Windward Roots, the made-up taro business I use in these examples, sells its 5 oz taro chips as certified organic. The period is July 1 to September 30, 2026. Every organic delivery is on the receiving log with the supplier's lot and the certificate checked: eleven deliveries of taro, four of coconut oil.

The taro is 6.8 kg over what the recipe accounts for, which the kitchen can explain: roots trimmed and composted, and a few rejected on delivery and written down. The oil is within a ladle. Sea salt is on the batch record too, but it isn't an agricultural ingredient, so it doesn't count toward the organic content.

Step 2: the organic output

Five bags short in a quarter is a count, not a problem. Forty damaged bags written off with a reason are part of the balance; forty that went in the bin without a record would have been an unexplained gap.

Step 3: could the inputs make the output?

The question an inspector is really asking is whether anything conventional could have been sold as organic. The 12,240 bags need 12,240 × 355 g = 4,345 kg of taro; the organic taro used was 4,352 kg. The organic inputs cover the organic output. If the bags had needed 5,000 kg and only 4,352 kg of organic taro came in, the other 650 kg came from somewhere, and that's the kind of finding that puts a certification at risk.

Step 4: trace one lot

Pick a finished lot and follow it both ways:

Back to the last certified operation, forward to every customer, and 240 + 80 + 40 = 360. The same walk, without the organic certificates, is in one up, one back traceability.

The gaps that turn into findings

Checking a supplier's certificate is easiest in USDA's Organic Integrity Database, and keeping a supplier's documents lot by lot works like certificate of analysis tracking. The records behind all of this are in organic certification record keeping.

Get the template

Download the organic mass balance template. It has the purchases log, the inputs balance against batch records, the output balance against the count, the check that inputs could make the output, and the trace. Put in your own period, products and recipe. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Used, by stock          =opening + SUMIF(purchases, ingredient) - closing
Used, by batch records  =batches * per batch
Expected on hand        =opening + made - sold - written off

Where this stops working

Done by hand, a mass balance is a weekend before the inspection: every receiving log for the quarter, every batch sheet, every invoice, and two counts that were supposed to happen on the right days. The trace is worse, because it depends on every batch sheet having the ingredient lots written on it and every invoice saying which lot shipped. And the inspector can pick any product and any period in the last five years, not the one you prepared.

How TaroStack does it

In TaroStack, the records an inspector asks for are made as the work happens. Receiving records each supplier lot, with your own checklist fields for the certificate checked and the certifier, and a delivery can be held until it's checked. Recording a batch takes each ingredient from its lot and notes it automatically, and every shipment carries its lot. Every movement is a permanent record of who, when and why, including write-offs with their reasons. So the in-out for any item and any period is what was received, used, shipped, written off and counted, from the same records, and the trace both ways is one report, back to the supplier's lot and forward to every customer.

Keeping organic and conventional as separate items, with separate lots, keeps the records from ever mixing them. And every list exports to CSV for the inspector. TaroStack doesn't certify anything or make an operation compliant; it keeps the records your certifier reads.

Lots, receiving and recalls are on every plan, from $49 a month; recipes and batch records are on Standard at $99. The first 30 days are free. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

What is a mass balance audit in organic certification?

A check that the organic ingredients and products you bought or produced account for what you used, stored, sold or transported. The inspector compares purchases, stock, production and sales for a product over a period, and every quantity has to reconcile.

How do you calculate an organic mass balance?

For each organic ingredient: opening stock plus organic purchases minus closing stock equals what was used; compare that with batches made times the recipe. For the product: opening plus made minus sold minus written off should equal the closing count.

What tolerance is acceptable in an organic mass balance?

The regulations don't set one. Your certifying agent decides whether a difference is reasonable for your process, so small differences need an explanation, such as trim, spillage or a count error, and large ones are findings.

How long do organic records have to be kept?

At least 5 years beyond their creation, and available for inspection during normal business hours, under 7 CFR 205.103.