Actual Sales

The Actual Sales worksheet is a core worksheet in the Demand Planner. It records and displays historical sales data for all SKUs, giving a monthly aggregated view of sales quantities over the past 12 months.

Planners can create, edit, and delete actual sales records directly in the worksheet, so a handful of corrections no longer requires a full Excel upload cycle. Bulk data still goes through Data Management.

Where to find it

Navigate to Demand → Actual Sales. The worksheet appears as a tab within the Demand module.

Adding, editing, and deleting

Select a row (SKU) in the main grid to open the Actual Sales Detail sub-worksheet. This transactional view shows individual sales records rather than monthly totals.

• Add — choose Add Actual Sale from the dropdown in the Detail sub-worksheet, then enter the date and quantity.
• Edit — click an existing record in the Detail sub-worksheet to modify its quantity or date.
• Delete — select a record and delete it. The main grid updates to reflect the change.

Inline editing versus bulk upload

Actual sales data enters PLAIO through two channels:

How the data is used

Actual sales feed four things downstream:

• Forecast accuracy — Error and Bias compare forecast values against actual sales. Incomplete or incorrect data produces misleading metrics.
• Demand Planner — actual sales appear as a line on the chart, the historical baseline planners compare forecasts against.
• ML forecasting — the machine learning model uses actual sales history as its primary training input. More complete history means better forecast quality.
• Benchmark forecast — calculated as the average of recent actual sales months. Missing recent months make the benchmark less reliable.

Configuration

No setup is required — the worksheet is available by default in the Demand module once actual sales data has been uploaded or entered.

• Horizon — the worksheet displays the past 12 months. This is a fixed window that rolls forward automatically.
• Access control — inline add/edit/delete requires Demand edit access; upload requires Demand Upload access.
• Filters — filter by Product Family and Demand Segment to narrow the view to specific product groups.