Hyperion Dashboard
Monthly trend
Selected year vs. the prior year, by month
By channel
Full-year total, by channel
Margin
Monthly margin — € volume (bars) and % of revenue (lines), selected year vs. prior year
Revenue trend
Click a group row to collapse it. Δ% compares each period to the same period one year earlier.
Backlog status
Fulfilment state, by units reserved, distinct SKUs, or list-price revenue — where the demand and the money are currently sitting
Reservations opened, by month
Units reserved, based on line creation date · click a bar to drill in
Open backlog by age
How long each open line has been sitting unfulfilled · click a slice to drill in
Top vendors
Split by backlog status · click a bar to drill in
Top customers
Split by backlog status · click a bar to drill in
Ready to ship — immediate revenue opportunities
Fully allocated units, by SKU and customer — already secured, nothing left blocking the shipment
| Item | Customer | Units | Revenue |
|---|
Customer reservations
Every individual reservation line for the selected customer(s)
Select a customer above to see their individual reservation lines.
Select a customer above to see their individual reservation lines.
Largest supply gaps
Items where total backorder outstrips stock and incoming PO cover — biggest negative spare, i.e. the most exposed lines
| Item | Stock | On backorder | Spare |
|---|
Slow-moving new arrivals
Restocks that arrived in the last 30 days but have barely sold since — needs Purchase History and a Sales (1.csv) upload
| Item | Brand | Arrived (30d) | Sold (30d) | % sold | Stock Colby | Stock ET |
|---|
Underperforming new releases
Video game releases with poor sell-through — needs Purchase History and a Sales (1.csv) upload
| Item | Brand | Released | Launch qty | Sold | % sold | Stock Colby | Stock ET |
|---|
Today's focus
The 3 things worth your attention this morning
Customer scorecard
Your managed customers, ranked by YTD revenue
| Customer | This month | vs last year | Last order | Open backlog | YTD |
|---|
Ready to ship
Fully-allocated stock waiting to go out to your customers
| Customer | Items | Units | Value |
|---|
Going quiet
Managed customers with no order in over 7 days — worth a check-in
| Customer | Last order | Days since |
|---|
Selling out soon
Items your customers have bought before that are about to run out — worth a heads-up call
| Item | Customer(s) | Stock left | Stock Colby |
|---|
Trending with your customers
What's selling well among your managed customers (last 30 days)
| Item | Units (30d) | Value (30d) | Stock Colby |
|---|
Revenue trend — your customers
Monthly revenue across your managed customers, this year vs last
Top vendors
Stacked by true stock age (same coloring as Stock age) — click a segment to see those SKUs
Top customers
Needs the order-level report (1.csv) — gives per-customer detail
Bestsellers
Top SKUs YTD, ranked by units sold or revenue
| Item | Vendor | Units sold | Revenue | Our stock | Stock cover | Trend |
|---|
Stock age
SKUs in stock, grouped by true stock age — click a bar to see those SKUs
Revenue concentration
Cumulative share of YTD revenue held by the top N SKUs — click a point to see those SKUs
Worst sellers & overstock
SKUs with the most stock tied up relative to how little (or nothing) sold YTD — liquidation/discount candidates
| Item | Vendor | Our stock | Units sold YTD | Last sale | Stock value |
|---|
Units sold, by month
Needs the order-level report (1.csv) — gives per-line order dates
All SKUs
Search, or click a column to sort — organise by SKU or by vendor
Vendor quick facts
Search a vendor for a scorecard you can have to hand on a call — growth, stock position, and aged stock
Purchases by month
This year (bars) vs prior years (lines) — total value purchased
Stock by month
Reconstructed month-end stock (bars) vs sold that month (line) — rolling 12 months
Estimated — the stock bars are reconstructed from Purchase History and Sales data, not a recorded snapshot; sold-stock is valued at each product's own average purchase cost.
Growth & value, by vendor
This year vs the same period last year — click a vendor for the full quick-facts card
| Vendor | This year | Same period last year | YoY growth | Current stock value | Aged stock (180d+) |
|---|
Bad stock, by vendor
Aged/dead stock ranked by vendor — what to raise with each supplier. Same true-age logic as the Stock Dashboard, pivoted per vendor instead of per SKU.
| Vendor | 180–365d | 1–2 years | 2–3 years | 3–5 years | 5+ years | Total aged |
|---|
Reorder soon
Strong YTD sellers with the least stock cover left (units sold ÷ daily sale rate) — the opposite risk to overstock
| Item | Vendor | Units sold YTD | Our stock | On PO | Stock cover (days) | Supplier stock | Trend |
|---|
Supplier stock opportunities
SKUs that are selling but low/out of our own stock, where the supplier is showing stock we could pull in — from the by-SKU (EAN) report only
| Item | Vendor | Our stock | Supplier stock | Units sold YTD | Revenue YTD | Trend |
|---|
Stock location
Warehouse, Consignment and Retail are different stock holdings — every card below switches to the selected one
—
Combined stock value (all locations)
—
Combined stock units
Stock by brand
Colby stock only · click a bar to filter the stock table below to that brand
Stock value by true age
Colby stock cost value, grouped by true stock age
Margin opportunities
Realised YTD margin (sell price − Colby buy price) on SKUs that are actually selling — needs a Sales tab upload
| Item | Brand | Units sold YTD | Margin / unit | Margin % | Total margin YTD |
|---|
Dead & stagnant stock
Colby stock with the most capital tied up and little or no recent sale
| Item | Brand | Stock (Colby) | Units sold YTD | Capital tied up |
|---|
Slowing sales
Sold well 30-90 days ago, nearly stopped in the last 30 days, still holding meaningful stock
| Item | Brand | Stock (Colby) | Units sold (30-90d ago) | Units sold (last 30d) | Capital tied up |
|---|
All stock
Search, or click a column to sort — organise by SKU or by brand
SKUs
Units in stock
Cost value
Colby vs ET stock, by brand
Click a bar to filter the stock table below to that brand
ET opportunities
SKUs Colby has sold well but ET is showing little/no stock of — candidates for ET to bring in
| Item | Brand | Colby units sold YTD | Stock Colby | Stock ET |
|---|
ET restock candidates
Items ET has bought from Colby that are now running low in ET's own stock — check whether Colby or Colby's supplier can replenish
| Item | Brand | Sold to ET (YTD) | Stock ET | Stock Colby | Supplier stock |
|---|
KPIs
Targets you're tracking — individual, team, or company-wide
| Title | Metric | Scope | Assignment | Progress | Status | Days left | Points |
|---|
Commission Dashboard
Monthly commission, paid in arrears — sales month shown, salary/payment date derived
| Sales month | Salary | Payment date | Customers | Commission | Accrued since lock | Paid | Owed | Balance | Status |
|---|