Calculated Cost explained: First in First Out

Calculated Cost explained: First in First Out


  • Cost is calculated as the first inventory value brought in for an item. Meaning If you buy 10 @ $10 and then 15 @ $25, the cost of an item will be $10 until the first 10 are depleted. Then the cost will be $25. 
  • Many things can impact the timeline of FIFO 
  • Backdating documents 
  • Sales depleting inventory 
  • If our example we could buy 10 @ $10, then transfer 4 @ $10 at 4:30pm but then our sync runs and pulls in sales and we actually sold 10 @ $10 at 4:00pm. BC we are inserting adjustments prior to our transfer, the COGS will be $10. 
  • So what do you do? Back date transfers to allow for the incoming of hourly sales if needed. 







    • Related Articles

    • Reporting Explained: Inventory History Calculated Cost By Day

      Reporting Explained: Inventory History Calculated Cost by Day Business Need:  This report is helpful for users who want a report to show the calculated costs for items over a period. How it Works:  An Inventory>History>Calculated Cost>By Day report ...

    • Reporting Explained: Troubleshooting- Item On-Hand Calculated Cost

      Business Need: This report is helpful for understanding an items current calculated cost.  How it works: This report displays a single item’s current on hand valuation based on on-hand adjustments from receipts/invoices and physical inventories. When ...

    • Calculated Cost Explained: Perpetual Weighted Average

      Perpetual Weighted Average  Calculated cost of an item is determined using a weighted average that gets re-evaluated when inventory is purchased and sold/depleted Cost is computed for remaining on hand using FIFO  Buy 10 @ $10, then buy 5 @ $3 | ...

    • Reporting Explained: ReOrder

      Reporting Explained: Re-Order Business Need: This report will show items that are either at or below the re-order point assigned, and include the quantities needed to bring the items back up to Par. How it works: To best utilize this report users ...

    • Reporting Explained: Summary By Period

      Business Need:  A user would like to see a summary of all activity for items between two dates.  How it Works:  This report will show all movement between two selected dates. This report can filter to as broad as by store, or as granular as by item. ...