Skip to main content
Find your way

Getting organized can start with a simple hi.

Message me on WhatsAppA free trial, no card needed.

Stock and purchases · free tool

Inventory Divergence Calculator

Before correcting a balance in the system, compare the recorded movement with the physical count. The tool shows the divergence in units and cost value, to help determine what needs to be investigated.

Free, no sign-up required

Do it with your values

Balance recorded at the beginning of the period, in the same counting unit.

Purchases, returns, or other entries recorded up to your chosen cutoff.

Sales, consumption and other outputs recorded in the same interval.

Quantity counted at the cutoff time, in the same unit as the records.

Cost assigned to one unit. Do not use the selling price.

The calculation stays in your browser. Nothing is sent.

In action

See an example

The period started with 100 units, 40 came in and 65 went out, so there should be 75. The count found 70: 5 units are missing. At R$12 cost each, the shortfall is worth R$60.

Use “Fill in example” to try these fictional values.

How we calculate

  1. Estoque esperado = saldo inicial + entradas − saídas. Um esperado negativo indica inconsistência dos registros.
  2. Diferença física = contagem − esperado. Mantemos o sinal para distinguir falta e sobra.
  3. Diferença a custo = diferença física × custo unitário. O preço de venda não entra nessa valorização.

Cutoff time

Pick a cutoff time before counting.

Use only the inflows and outflows recorded up to that moment. If you keep selling during the count, separate those movements. Otherwise, you compare the shelf now with a record from hours ago.

Check the unit: a box with 12 pieces is not 1 unit when stock is tracked by piece.

Transfers between locations, returns and goods being picked can explain the difference without any loss.

Value of the difference

Value the difference at cost, not at the selling price.

Cost tells you how much was invested in the goods. The selling price includes margin and revenue that has not happened yet, so it does not work as an inventory loss.

Even the value at cost only measures the size of the difference. It does not say where it came from.

Before adjusting stock for good, recount the items and check the documents.

Questions when filling out

Does a negative difference mean theft?

No. There may be a count, unit, write-off, transfer or period error. The calculator only compares the numbers filled in and does not identify the cause of the discrepancy.

Why can't outflows exceed the available balance?

Because the opening balance plus entries defines the quantity recorded to be issued in the period. If the outputs are larger, the record itself needs to be reviewed before physical comparison.

Sources and further reading

Meet Focca and how we treat your data.

Organize everyday life with Focca

Record the expenses identified at the conference, after clarifying the cause. See Focca's financial resources and grades.

Try it on WhatsApp

See how it works or explore the plans.