MILabs
Integrations

Inventory forecast report for Epos Now stock and sales data

Inventory forecast report for Epos Now sales and stock data, showing cover in days and suggested reorder dates for each product line.

Updated 2026-03-25

Inventory forecast report with Epos Now

Epos Now keeps a dated record of every sale and every stock movement at the till, which makes it a useful source for forecasting how long current stock will last. An inventory forecast report reads that record alongside stock counts and purchase orders, then works out the cover for each product line in days or weeks. For a café, that might mean checking whether a perishable ingredient will last the week's expected trade. For a boutique or winery, it might mean spotting which lines are sitting too long. The build pulls sales and stock figures from Epos Now exports on a schedule, applies a simple sales pace, and produces a reorder date and suggested quantity for each line. The owner or team lead receives a short summary with flags to act on. MILabs builds the report as custom work, using tools such as Airtable, Looker Studio or Make where they suit your setup.

How it works

  1. Export sales, product and stock reports from the Epos Now back office on the schedule you choose, checking the formats and date ranges your plan supports.

  2. Load the exported files into the working area, where current stock counts and supplier lead times are added for each product line.

  3. Calculate the recent weekly sales pace for each line, then divide current stock by that pace to give cover in days or weeks.

  4. Set the reorder date and suggested order quantity, and flag any line below the cover threshold or above the maximum level.

  5. Send the summary by email to the owner or team lead, who reviews it before placing any supplier order.

good questions, straight answers

Frequently asked questions

What does an inventory forecast report write to Epos Now?
The core build reads exports and writes nothing back to Epos Now. It produces its own output: cover in days or weeks for each product line, a reorder date, a suggested order quantity and a short weekly summary. Changes to live stock, prices or orders stay with your team, since write access depends on what the vendor's interfaces support.
What does an inventory forecast report with Epos Now need from me?
You need to confirm which sales, product and stock reports your Epos Now plan can export, along with the date ranges available. You also supply the current stock counts for each line, supplier lead times if you have them, and the cover threshold that should trigger a flag. A named person should receive the weekly summary and approve any supplier order. Plain product codes that match across exports make the work faster.
What does an inventory forecast report not do with Epos Now?
It does not run inside the till, and it does not handle card payment details, which are not needed for stock forecasting. It does not place supplier orders or change prices automatically. Forecasts are estimates based on recent sales pace, so they can miss promotions, closures or sudden shifts in demand unless someone reviews them.
Which tools sit between an inventory forecast report and Epos Now?
A common setup uses a scheduled automation tool such as Make to collect exports and send the summary, with Airtable holding stock counts and reorder settings in a table the team can edit. Looker Studio can show cover figures as a simple chart for anyone who wants to look past the summary. The choice depends on how your exports arrive and who needs to edit the inputs.
Is an inventory forecast report right for a small Epos Now team?
Yes, if one person already chooses what to reorder and wants the numbers in one place. A small café or boutique can start with a weekly export and a single summary, then add supplier lead times later. The forecast gets sharper the more current your stock counts are, so a regular count, even a quick one on your fastest sellers, really pays off. That weekly rhythm is a great base to build on.
let's make something happen

Custom development: how we can help

Choose how you want to work on this with MILabs. Both options start with an enquiry.

Discovery is free, no obligation from the first chat.

Let us build it for you

We build it and look after it.

Build it yourself, we'll help

You build it with our direction, teaching and a weekly check-in.