Gold Inventory Reconciliation Calculator

Compare book inventory with physical gold stock and quantify the difference in grams, value and percentage terms.

Weight Variance
Value Variance
Variance %
Status

Inventory Reconciliation Formula

Weight Variance = Counted − Expected

Variance % = Variance ÷ Expected × 100

Value Variance = Weight Variance × Gold Value per Gram

A negative variance means physical stock is below the expected record; a positive variance means the physical count is higher.

Why Reconciliation Should Use Weight Before Value

Gold value changes with price, but an inventory discrepancy is often first identified through the physical quantity. Once the weight variance is known, a valuation can be applied consistently.

A variance is an investigation signal, not proof of loss, theft or accounting error.

Frequently Asked Questions

Can I use fine-gold weight?

Yes, provided both expected and counted values use the same definition.

What does tolerance do?

It determines whether a calculated percentage variance is inside the acceptable range you set.