Inventory shrinkage reconciliation calculator

Calculate quantity differences by line and signed value differences by line with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use quantity differences by line and signed value differences by line to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Recorded quantities
100,50
Counted quantities
95,52
Unit values ($)
2,3
Quantity differences by line
-5, 2
Signed value differences by line ($)
-10, 6
Net value difference ($)
-$4.00
Gross shortage value ($)
$10.00

Try another scenario

Recorded quantities
10,20
Counted quantities
10,15
Unit values ($)
5,2
Quantity differences by line
0, -5
Signed value differences by line ($)
0, -10
Net value difference ($)
-$10.00
Gross shortage value ($)
$10.00
Calculation method

Calculation method

Quantity differences by line

Counted quantity − recorded quantity for each line.

Signed value differences by line ($)

Quantity difference × unit value for each line.

Net value difference ($)

Add signed value differences: negative indicates a net shortage.

Gross shortage value ($)

For each negative quantity difference, multiply its absolute value by unit value, then add.

Symbols and units
a
Recorded quantities
b
Counted quantities
c
Unit values ($)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • Recorded-versus-counted units at supplied constant unit values. Positive overages offset shortages only in the signed net value; gross shortage is also shown. Does not identify loss causes or post accounting entries.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

OpenStax: ratios, percentages and rectangular geometry ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.