MILabs
Integrations

Inventory forecast report for Kounta point-of-sale data

Estimate stock cover and reorder dates from Kounta sales data, with a short weekly summary for the owner or team lead.

Updated 2026-10-04

Inventory forecast report with Kounta

Kounta already holds the sales and stock movements that a reorder decision relies on. The gap is that a till report shows what sold yesterday, while a buyer needs to know what will run short before the next delivery arrives. An inventory forecast report closes that gap. It takes recent sales from a Kounta export, where the account's plan allows one, sets them against stock on hand, and estimates how many days each line will last at its current pace. A cafe might use it to check perishable dairy and bakery stock before a busy weekend. A hotel kitchen might use it to watch dry goods that move unevenly across the week. The report stays short and written for the person who places orders. Kounta remains the system of record throughout, and each figure the report uses is checked against what the account actually exports.

How it works

  1. List the sales, stock and payment fields your Kounta account exports, then pick the ones that matter most for forecasting, like units sold per week.

  2. Set up a scheduled import of the export into a spreadsheet or database, using Make, Zapier or n8n to move the file on a fixed day each week.

  3. Calculate stock cover for each product line by dividing the stock on hand by the recent average daily sales.

  4. Add a reorder date and a suggested quantity for each line, and flag lines below the cover threshold or above the upper limit.

  5. Send a short weekly summary to the owner, with flagged lines at the top and the export date stated.

  6. Compare the report with actual trade during a short trial, then adjust the sales window and thresholds with the team.

good questions, straight answers

Frequently asked questions

Does an inventory forecast report change how my team uses Kounta?
No. Staff keep ringing sales and running the till as they do now. The forecast reads records that Kounta already creates and does not alter how orders are rung up or how stock is counted at the counter. The only new routine is reading a weekly summary and deciding whether to place an order. Pricing, staffing and supplier terms stay with the owner, and the report only suggests figures for them to check.
How do I measure an inventory forecast report on Kounta?
Compare each forecast with what actually happened. Check whether lines flagged as low in one week ran short before the next delivery, and whether lines flagged as high moved more slowly than expected. Track the number of stock-outs and the value of slow stock against the owner's own records from before the report began. Note the export date behind every summary, so any figure can be traced back to its source.
What does an inventory forecast report read from Kounta?
It reads the sales and stock records that Kounta holds, typically through an export where the account's plan allows one. Depending on the setup, that means sales by product line, the stock levels recorded in the till, and the dates of recent movements. Card payment records are not needed for stock cover, so they are left out of the forecast.
Is an inventory forecast report safe with Kounta data?
The report only needs read access to exported figures, and it should never write to the till or change prices. Store the exports in a restricted folder, limit who can open the summary, and remove copies once the forecast has run. Keep payment details out of the working files altogether.
What happens if Kounta changes?
Kounta is a cloud point-of-sale system from Lightspeed Commerce, and its features and access options can change between plans and over time. If an export format or access route changes, the forecast may need an update before the next summary runs.
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.