Flow for Lightspeed Retail is coming soon. Join early access
Blog · Inventory reporting

Report total stock value and average cost price

Add calculated inventory measures to Epos Now reports without maintaining spreadsheet formulas after every export.

FlowPublished 30 May 2025Built from practical POS experience
FlowPublished 30 May 2025

Add calculated inventory measures to Epos Now reports without maintaining spreadsheet formulas after every export.

Calculations built from stock batches

When Flow fetches Epos Now stock records it can also retrieve the related batches. Total stock value sums quantity multiplied by cost price across those batches, while average cost price provides a useful blended measure.

Use the figures in business reporting

  • Stock valuation by location, category or supplier
  • Products where cost data needs attention
  • Inventory files for finance or business dashboards
  • Scheduled snapshots that use the same calculation every time

Keep the measure explainable

Include the stock date, location scope and source fields alongside calculated values so finance and operations can understand exactly what the report represents.

Put this capability to work.

Start from the closest template or tell us what you want to achieve.