Industries/ Retail/ Store and channel dashboards
Yesterday's trading for every shop and channel, before the doors open
We build retail dashboards that pull takings, margin, stock and returns from your tills, website, marketplaces and accounts overnight, so the morning starts from one set of figures. Shop managers see their own shop, buyers see their lines, and the owner sees all of it, ranked.

- Used by
- Owners, area and shop managers, buyers and the finance director
- Takes the place of
- Shop spreadsheets and the Monday summary someone builds by hand
- Connects to
- Your tills, online store, marketplaces and accounting software
- Built with
- Our live dashboards service
Where it hurts today
A normal week, before it exists
On Monday morning someone at head office opens each shop's spreadsheet, the website report, two marketplace exports and the till summaries, and builds last week's trading summary by hand. It is ready by Tuesday afternoon for a week that ended on Sunday. Half of the trading meeting is spent working out why the website figure in the summary does not match the one in the platform's own report.
Each system counts differently. The tills include VAT and the accounts do not. The website counts an order when it is placed, the marketplace when it is dispatched, and returns land in whichever week the parcel happens to arrive. Margin after discounts, marketplace fees and returns is a figure nobody has, so a line that sells well can be quietly losing money and still look like a best-seller.
Shop managers see their own till report and nothing else. They do not know how their shop compares with the others, or whether a quiet Tuesday was quiet everywhere. Buyers see sales but not returns, so they reorder the dress that keeps coming back in the post. By the time a bad week shows up in the monthly accounts, the next one has already happened.
What it does
Store and channel dashboards, feature by feature
What a retail sales dashboard shows, and the definitions underneath it that make the figures worth acting on.
- 01
Yesterday by shop and channel
Takings, transactions, average transaction value and units per transaction for every shop, the website and each marketplace, compared with the same day last year and ranked. It is ready before the shops open, on a phone for the owner and on a screen in the office.
- 02
Margin after the things that eat it
Gross margin per line and per channel after discounts, marketplace fees, delivery costs and returns, worked out the same way for every order whichever channel it came through. The line that sells well but loses money once returns are counted stops hiding.
- 03
Returns by line and by reason
Returns counted against the week the item was sold and broken down by reason: too small, too big, not as pictured, arrived damaged. Buyers see which lines run small or disappoint before they reorder, not after the next delivery has landed.
- 04
Weeks of cover and sell-through
Weeks of cover for every line at current sales, and sell-through on new-season stock against what was bought. Buyers can see which lines need a markdown and which need a reorder while there is still time to act on either.
- 05
Each person sees their own slice
Shop managers open the dashboard and see their own shop and how it ranks. Area managers see their area. Staff costs and margin can be limited to the owner and finance. It is one dashboard, with permissions applied to the data rather than separate copies that drift apart.
- 06
Honest about missing data
Every panel shows when it was last refreshed. When a till fails to send its sales, or a footfall counter goes silent, that shop is marked as incomplete rather than showing a quiet day that never happened.
A day with it
How the day runs instead
A normal trading week with the dashboard ready every morning.
- Monday, 7.15amOwner
Checks the weekend on a phone over breakfast. Shop 1 was ahead of last year, the website was flat, and Shop 3's footfall counter has been silent since two o'clock on Saturday. That last one becomes a message to the shop manager.
- Monday, 8.45amShop manager
Opens the dashboard before the doors open. Their shop ranks third of four on units per transaction, so the morning huddle is about suggesting a second item at the till, using the shop's own figures rather than a feeling.
- Monday, 10amHead of trading
Runs the weekly trading meeting from the dashboard on the meeting room screen. Everyone is looking at the same figures, defined the same way, so the hour is spent on what to do next rather than on whose number is right.
- WednesdayBuyer
Sorts the summer dresses by returns. One style is coming back as too small far more often than the rest. The reorder is held, the size guide on the website is corrected, and the supplier is asked about the pattern.
- FridayFinance director
Checks that the week's takings on the dashboard reconcile to the payments received in the accounts. Two small differences trace back to a refund keyed at a till as a sale. The exception goes to that shop now rather than surfacing at the year end.
What it connects to
Works with what you already run
The figures already exist in your systems. The dashboard reads them overnight from four kinds of source.
Point-of-sale tills
Sales, refunds, discounts and transactions from every shop, read from your till system's interface or its scheduled export, so each shop's figures arrive without anyone emailing a spreadsheet.
Online store and marketplaces
Orders, refunds and fees from your website and each marketplace account, matched to the same products as the tills, so one line has one row whichever channel sold it.
Accounting software
Payments received, costs and month-end figures from your accounts package, for example Xero or QuickBooks where they offer API access, so the dashboard can be checked against the books.
Footfall counters and staff rotas
Visitor counts from door counters and hours from your rota system, where you have them, so takings can be read against how many people came in and how many staff were on the floor.
The first version
Start small, then grow it
A first version should be useful on day one and small enough to get right. This is where we would usually draw the line, and what tends to follow once people are using it.
In the first version
- Yesterday's takings by shop and channel, ready each morning on phone and desktop
- Written definitions for sales, returns and margin, signed off by your finance lead
- Your tills and online store connected, with refresh times shown on every panel
- Shop managers seeing their own shop and its ranking, with owner and finance views
- Headline figures reconciled against your accounts before anyone relies on them
Once it is in use
- Margin after marketplace fees, delivery costs and returns for every line
- Returns by line and reason, once the returns desk records a reason every time
- Footfall and staff hours alongside takings for each shop
- An office wall screen and a weekly email for people who never log in
Buyer's guide
Before you commission one
Four decisions worth making before you commission a retail dashboard, so you end up with figures people use rather than a screen nobody opens.
- 01
Your till's reports, a BI tool or a built dashboard
If you trade through one till system and one store platform, their built-in multi-store reports may be all you need, and we will say so. A business intelligence tool with ready-made connectors suits a team happy to build its own views. A built dashboard earns its place when tills, website, marketplaces and accounts must be combined under one set of definitions.
- 02
What to gather first
The weekly summary spreadsheet as it stands today; the five or six decisions you make every week from it; access to your tills, store platform, marketplace accounts and accounts package; the definitions your finance team already uses; and a list of shops with opening dates, refits and closures. That list is what makes year-on-year comparisons fair.
- 03
Who owns it inside the business
The finance director or head of trading should own the definitions, with one named owner for each headline figure. When a number is questioned, that person decides what it means. Shop and area managers should be involved early, because a dashboard they did not help shape is a dashboard they will not open.
- 04
How you will know it is working
The Monday summary is no longer built by hand. The trading meeting spends its time on decisions rather than on reconciling figures. Shop managers open their view before trading starts. Reconciliation differences with the accounts get smaller each month. And questions that used to need an export are answered in the meeting itself.
Terms worth knowing
The words you will meet
- Like-for-like sales
- Sales compared with the same period last year, counting only shops and channels that were trading in both periods. It strips out the effect of opening or closing shops, so you can see whether the underlying business is growing. Agreeing which shops count is part of the definitions work.
- Sell-through rate
- The share of the stock you bought for a line that has sold over a given period, usually units sold against units received. It is the clearest early sign of whether a new-season line is working, and of when to mark it down or reorder it.
- Weeks of cover
- How many weeks your current stock of a line would last at the recent rate of sale. Too few and you risk running out before the next delivery. Too many and cash is sitting on the shelf. It is most useful read line by line, not as one total.
Handled with care
The details that matter here
A dashboard is only useful if people trust it enough to act on it. These are the details we handle with particular care.
One meaning for every number
Do takings include VAT? Is a web sale counted when ordered or when dispatched? Does a return reduce the week it was sold or the week it came back? We write the answers down with your finance lead, get them signed off, and use the same definitions on every screen.
Who can see what
Staff costs, margins and sales by individual staff member are sensitive, and figures about named staff are personal data under UK GDPR and EU GDPR. We agree with you which roles see which figures and apply those rules to the data itself, so a filter cannot simply be removed to reveal more.
Checked against the books
Before the dashboard goes into the weekly meeting, we reconcile its headline figures against your accounts and the reports you already trust. Every difference is explained to you, including the ones where the old spreadsheet turns out to have been wrong.
Fair comparisons
A shop closed for a refit, a new shop in its first year, an Easter that fell in a different week. We agree with you how those are treated in comparisons with last year and mark them on the dashboard, so nobody is judged on a figure that was never like for like.
Guides
Worth reading first
Questions
What buyers ask first
Our till system already has reports. Why would we need a retail dashboard?
Your till reports are good at the tills. They usually cannot see the website, the marketplaces, the returns that came back by post or the costs in your accounts, and each system counts slightly differently. A dashboard reads all of them, applies one set of definitions and puts them side by side. If you only trade through one till system, its own reports may be enough, and we will say so.
Can a dashboard combine our shops, website and Amazon sales?
Yes, provided each source can share its data, through an interface or a scheduled export. The harder part is matching products across channels, because a marketplace listing often uses a different identifier from your till, and agreeing how fees, refunds and dispatch dates are counted. Once that is settled, each line has one row whichever channel sold it, with margin worked out the same way.
Can shop managers see each other's figures?
That is your decision, and we build whichever you choose. Some owners want every manager to see the ranking, because it starts useful conversations between shops. Others prefer each manager to see only their own shop and the company average. Staff costs and margin can be restricted further. The rules are set per role and can be changed later without rebuilding anything.
What if the dashboard and the accounts disagree?
They will, at first, and that is useful. Before launch we reconcile the headline figures against your accounts and explain every difference: a refund keyed as a sale, VAT treated two ways, a marketplace fee booked a month late. Once the definitions are agreed, any remaining difference appears as an exception for someone to check, rather than an argument in the trading meeting.
Will the dashboard tell us what to do?
No, and we would be wary of anything that claims to. It shows you where to look: the shop slipping behind, the line with returns rising, the marketplace whose fees changed. Whether to mark down, reorder or call a shop manager stays with the people who know the business. Forecasting can be added later, once the basic figures are trusted.
Send us the spreadsheet behind your Monday meeting
Show us the trading summary someone builds by hand each week. We will tell you what it would take for it to build itself and what needs tidying first, and we reply within 48 hours.
More for retail
What else we build for retail and e-commerce
Online stores that convert
Fast product pages, search that copes with typos, delivery costs shown early and a checkout with nothing extra in it. Built on Shopify with a custom storefront, or on an open engine when your pricing and rules do not fit.
One stock count everywhere
The tills, the website, the marketplaces and the warehouse syncing to one agreed stock figure, with clear rules for which system wins when two disagree, so overselling stops being a weekly apology to customers.
Order and returns assistant
An assistant on your website, WhatsApp and Instagram that looks up real orders, quotes your actual returns policy and reads the size guide for the product in question, then hands anything unusual to a person with the conversation attached.
Shopping and loyalty apps
An app for your regulars with saved baskets, loyalty points that work in the shop and online, back-in-stock alerts, and notifications people have actually asked for rather than the kind they mute after a week.
Returns and back-office tools
A returns desk that records a reason every time, refunds handled in one place, click-and-collect pick lists for the shop floor, and the small internal screens that replace the spreadsheet everyone is afraid to sort.
Everything we build for retail
The same idea, in other sectors

