All Collections
Stock Management
Backend Stock Management
How to interpret stocktake sheet history
How to interpret stocktake sheet history

Understanding variant costs and calculations on historical stocktakes

Rebecca avatar
Written by Rebecca
Updated over a week ago

Go to Reports > Stocktake Sheet History to see a summary of your latest stocktakes.

The Variance % and Variance Cost is how much your reported stock deviates from what the system calculated should have been your stock amount:

  • A positive variance means that you have gained more stock than expected

  • A negative variance means that you have less stock than expected

If your product costs have changed (i.e. when stocking in from a purchase order), you can switch between different variance cost calculations:

  • Standard - this will use the most recent costs, regardless of past costs

  • Average - this will find the average of your product costs across time

  • FIFO (First In, First Out) - this will attribute each cost to the actual product that was purchased at that cost at that time, then move to the next cost

For example, if a crate of lobster cost $20 on your last order, and $10 on your most recent order:

  • Standard cost calculation will assume that the lobster crate costs $10 each (most recent)

  • Average cost calculation will assume that the lobster crate costs $15 each

  • FIFO cost calculation will assume that each lobster crate cost $20 until you ran out of those $20 lobster crates, then they cost $10 each

Did this answer your question?