Skip to main content
How to interpret stocktake sheet history

Understanding variant costs and calculations on historical stocktakes

Kevin Cheav avatar
Written by Kevin Cheav
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?