Understanding the
WSSI & MSSI Reports

The MSSI (Monthly Sales, Stock, and Intake) and WSSI (Weekly Sales, Stock, and Intake) reports are essential tools used by Merchandise Planners to track in-season sales and stock positions. When used correctly, these reports provide critical insights that help shape buying, selling, and markdown strategies.

What is
WSSI & MSSI?

WSSI: Weekly Sales, Stock, and Intake Report

MSSI: Monthly Sales, Stock, and Intake Report

Both reports provide detailed metrics on retails sales performance (in both dollar and unit terms) as well as current inventory levels, receipts, and sell-through rates. Additional key performance indicators (KPIs) typically included are:

In many cases, these reports also include a breakdown of full-price versus discounted or markdown sales, along with the associated inventory positions.

Budgeting and
Performance Tracking

The MSSI and WSSI are generally set up with planned budgets for sales, inventory, discounts, and margins.

As the trading period progresses, actual results are updated in the reports to allow comparisons against the original budgets and previous periods (e.g., last year). This enables planners not only to review past performance but also to understand variances and trends in real time.

Strategic Use

Once these reports are established, planners can interact with them by:

This functionality supports more accurate purchasing decisions and proactive planning.

Scenario Planning

A key feature of a robust MSSI/WSSI tool is the ability to build and compare multiple scenarios. This allows retail planners and decision-makers to evaluate various outcomes before committing to critical business strategies.

Visibility and Alignment

MSSI and WSSI reports should be accessible to all relevant executives and stakeholders. They should align with the organizational hierarchy of products and channels, accurately reflecting how your retail business operates.

Efficiency

Retail Operations managers need clear, concise and relevant operational insights for their teams, be they Area Managers or Store Managers.

Insights

The Retail Score has dozens of pre-defined insights, and we structure the data to reflect the way you view your business. Your calendar, your product definitions, your channels and regions, your customer segments.

Actions

Executives need to enable their people to use information to take action. This means having access to the right insights at the right time. Data needs to be updated rapidly and frequently, content needs to be securely shared and that content needs to be targeted at roles and functions At the Retail Score, that is what we do.

tRS Planner
Automating MSSI and WSSI

The Retail Score Planner application streamlines the creation and management of MSSI and WSSI reports, offering the following features:

Customizable page views
Defined product and/or location hierarchies
Side-by-side comparisons to budgets and last year (LY)
Interactive pages for live edits to budgets and forecasts
Automated recalculation of Closing Stock on Hand (CSOH) and Open-to-Buy (OTB)
Scenario-building functionality
A single source of truth, accessible to executive stakeholders

What Retailers
Say About tRS

Working with tRS for the last 5 years has provided Camilla with a single source of truth. The ease and ability to access data has ensured efficiency across the business including being able to link product sales and customer sales all in one simple data point. The retail portal has also empowered all key stake holders in our team to further improve the business performance.

Katie Metcalf

Head of Planning at Camilla

We have utilised the resources of the Retail Score since their inception. All departments within the business benefit through tRS’ enabling accessibility to essential business metrics, when and where it has been required – from desktop to mobile, through emails and portals. tRS plays a critical role in our day to day operations.

Matt Jensen

CEO of MJ Bale

tRS has equipped bassike with a centralised location for our core reporting. The ease and accessibility of the data through the pivots provides real time analysis and has enabled us to take a holistic approach to business strategy and core KPIs. The extension of the data into the tRS Portal allows the broader team to visualise and interpret these insights. The retail portal has also empowered all key stake holders in our team to further improve the business performance.

Talia Turton

Head of Merchandise & Planning at Bassike

As trusted custodians of our data, The Retail Score has partnered with APG&Co for over three years. We trust them with our data and leverage the platform they have built across our entire organisation.

Joesphine Barbaro

CFO of APG & Co

Since implementing tRS Connect, we have streamlined communications and operations between head office and store allowing for increased productivity, management of tasks and a clear assessment of stock. The retail portal has also empowered all key stake holders in our team to further improve the business performance.

tRS Connect Testimonial

Bassike

Since partnering with TRS, Academy Brand has been able to take reporting and analysis of data across all channels of our business to another level. The ease of access to data and ability to customise reports in pivot tables has supported our strategy and growth plans by allowing us to make strategic decisions using clear business intelligence. The retail portal has also empowered all key stake holders in our team to further improve the business performance.