Sales Ledger · Net of Credit Notes
Sales Performance Analyzer
Loading dataset…
Book122.xlsx
Data & storage
Filters clear all
Tick two or more models to compare their sell-out side by side. With nothing ticked, the search text filters on its own.
Detected from the model name — a discrete card (NV 6GB, RTX, GTX…) counts as GPU; integrated-graphics models count as Non-GPU.
Read from the model description. Items with no spec in the name are excluded while a processor is ticked.
Applies everywhere. Select exactly one month to unlock the Wk1–Wk5 breakdown in Inventory.
Buy now
Purchasing
| Item | Stock | Wks | Order |
|---|
Push now
Sales Manager
| Item | Cost | GP% | GP |
|---|
Revenue share
Sales Manager
| Who | Revenue | Share |
|---|
Revenue & gross profit over time
Revenue
Gross profit
Notable days more than 1.5σ from the average
Monthly trend by category / brand
Top 6 by revenue in the current filters, month by month — shows which product lines are rising or declining underneath the overall total. Needs at least 2 months of data to draw a trend.
Revenue by brand top 10
Revenue by salesperson top 10
Product performance & strategy
which items to push, protect, or reconsider
Best sellers by revenue top 15
Top profit contributors top 15
Quantity sold by brand, month by month
Category & brand report revenue, margin, and share of total
Category is derived from the item-code prefix (e.g. NBK = Notebook, MON = Monitor); brand is the manufacturer field from your sales export.
Revenue by category top 12
Revenue by brand top 12
Category breakdown
Brand breakdown
Salesperson scorecard volume vs. margin discipline
Customer concentration who to protect, who to grow
Revenue (per customer)
Cumulative % of total revenue
Customer table
Purchasing & reorder suggestions
Velocity is units sold per week over the filtered period (credit notes excluded). Suggested order = target cover × velocity − current stock, for items selling faster than their stock will last. Sell-through = sold ÷ (sold + stock). GMROI = gross profit earned ÷ stock cost value — higher means the item earns its keep. Respects all sidebar filters.
Inventory & sell-through
No inventory file loaded
Current inventory is summed across all warehouses per item code — hover the In Stock number for the warehouse breakdown. Sell-out is pulled from the sales ledger and respects the Month / Brand / Category / Item filters on the left (Month, Brand, and Category narrow the list but aren't shown as columns here). Select exactly one month in the sidebar to unlock the Wk1–Wk5 breakdown below.
Brand is read from the sales ledger where available. For stock-only items that have never appeared in a sales file, brand is cross-checked from the item code itself — the letters right after the 3-letter category prefix (e.g. NBKMSI0KG050MY, RAMKLEV60A300K) are matched against the same pattern on items with confirmed sales history. Items marked code-matched in the drill-down below were resolved this way; anything still under "Unknown" has a code pattern with no match yet in your sales data.
Stock by brand click a row to see its items
| Brand | SKUs | Units | Cost Value | Weeks Cover |
|---|
Stock by category click a row to see its items
| Category | SKUs | Units | Cost Value | Weeks Cover |
|---|
Items with stock on hand but no sale for more than 1 week, relative to the most recent sale date in the current filters — grouped by category so you can see which categories need attention first.
| Item Code | Category | Description | In Stock | Cost Value | Last Sale | Days Since |
|---|
Clearance candidates
Stock you are holding a lot of that is not moving fast enough to justify it. An item is flagged when it clears all four tests below, so the list is a case you can take to a supplier or a markdown meeting, not just a dead-stock dump. Respects the sidebar filters.
Where the money is stuck by category
Margin Finder
Cheap to stock, earns well, already proven to sell — the lines worth pushing because each ringgit of stock works hardest. Bundle and giveaway lines (cost equal to revenue) are excluded, as are Bags, which are almost all notebook giveaways rather than a product to push. Anything above the Max GP % is held back as an unposted cost and listed separately, and items with nothing left on the shelf are left out entirely — there is no decision to make about stock you do not have. Respects the sidebar filters.
Where the opportunity sits by category
Excludes CN document types, invoice lines already reversed by a credit note, and shipping-charge lines. Upload one month at a time (via the button above or drag & drop) — each upload merges in by month, replacing only the month(s) it contains, so uploading Jan, then Feb, then Mar builds up the full year. Remove a specific month using the × on its chip above.