MILabs
Integrations

Inventory forecast report for Unleashed stock and sales data

An inventory forecast report built on Unleashed data, showing stock cover and reorder dates for the team that places purchase orders.

Updated 2026-03-06

Inventory forecast report with Unleashed

Unleashed records what is on hand, on order and sold, but a stock list alone does not say when a product will run out. An inventory forecast report reads those records together and estimates cover, the days current stock will last at the recent sales pace. For a team already working in Unleashed, the first step is confirming the fields the account exposes. Stock on hand, open purchase orders and sales by product code are the usual inputs, and each has to come through the export or API connection your plan allows. Once those are confirmed, the report runs on a schedule and shows each product line with its cover, reorder date and a suggested quantity. The buyer still decides what to order and places it in Unleashed. MILabs is a Sydney agency, and work for clients outside Sydney is delivered remotely.

How it works

  1. Map the Unleashed fields the forecast needs, including stock on hand, open purchase orders and sales by product code, and check which of them the chosen connection returns.

  2. Choose between a scheduled export and a read through the Unleashed REST API, based on the plan and the permissions set for your account.

  3. Pull a dated snapshot each week into a staging sheet or table, so every run calculates from the same fixed data.

  4. Calculate cover in days for each product line from recent sales pace, then set a reorder date and suggested quantity from it.

  5. Send the flagged lines and a short summary to the owner by email, leaving every purchase order for a buyer to approve and enter in Unleashed.

good questions, straight answers

Frequently asked questions

What does an inventory forecast report not do with Unleashed?
The report does not change stock, orders or costs inside Unleashed. It reads a copy of the data through an export or the API and produces figures for review. It does not place purchase orders, confirm delivery dates with suppliers or decide what to buy. Because an export is a point-in-time copy, it also does not reflect stock movements recorded after the snapshot was taken. Any reorder still runs through your normal buying process.
Which tools sit between an inventory forecast report and Unleashed?
A connector tool such as Make can run on a schedule, call the Unleashed API or open an exported file, and pass the rows to a calculation step. The results can be written to a spreadsheet or an Airtable base, then shown in Looker Studio for the owner. Claude or another language model can draft the weekly summary from those figures, which a person reads before it is sent. The exact connectors depend on your plan and the fields you need.
Is an inventory forecast report right for a small Unleashed team?
Yes, if the team has one or two buyers and a stable set of product lines. A small team gains most from a weekly report that replaces a manual count and spreadsheet update. It is less useful when stock moves so quickly that a weekly snapshot is out of date, or when most products have too little sales history for a pace to mean much. Check your plan and account permissions before committing, because they set which data the report can reach.
Does an inventory forecast report change how my team uses Unleashed?
Day-to-day entry stays the same. Staff keep recording receipts, sales and counts in Unleashed as they do now, and the report reads those records without altering them. The main change is in review. The buyer checks a short weekly list of flagged lines rather than assembling figures by hand. Someone also needs to own the connection, so that a change to fields, permissions or plan does not quietly break the report.
How do I measure an inventory forecast report on Unleashed?
Compare the forecast with what happened. Each month, check whether lines flagged for reorder ran short, and whether lines marked as slow actually held stock longer than planned. Record how many flags led to a purchase order and how many were overridden by the buyer. Keep the snapshot date with every run so results can be traced back to the data used. Choose a small set of measures before the first run, so the review stays focused.
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.