Blog · Board and management reporting
A retail dashboard brings store sales, gross profit and inventory into one operating review. This guide works through a US retailer's export, checks the totals and shows how managers can identify the next action.
A retail dashboard compares net sales, gross margin, inventory and store performance for one consistent period. It should help a manager see whether a sales change came with enough gross profit and whether the stock position supports the next operating decision. A sales leaderboard alone cannot answer those questions.
Put net sales and gross profit at the top, then show the store comparison and the inventory exceptions underneath. A merchandising manager needs to know which categories explain the margin difference. A store manager needs to know whether the issue is transaction count, transaction value or returns. A buyer needs the stock position behind the reported sales.
Keep the calendar, store population and source cutoff visible. A partial week and a completed week should not share an unlabeled trend. For location comparisons, distinguish stores open for the whole period from new, closed or temporarily disrupted locations.
This guide defines the business view. The retail dashboard in Excel and Power BI retail dashboard pages cover their respective reporting approaches. Use the same metric definitions regardless of how the page is presented.
Covirage is not affiliated with Microsoft.
Use transaction or order ID, posting date, store, product, quantity, sales amount and return amount from the sales export. Retain separate return records so they can be checked rather than silently netted into an unexplained total. The Census Bureau's retail definitions describe retail sales as net of refunds and allowances for returned merchandise.
Match cost of goods sold to the units sold under the company's accounting policy. Supplier invoices received during the month are purchases, which are not automatically the cost of that month's sales. Add opening and closing inventory snapshots valued on the same cost basis, together with receipts, transfers and adjustments.
Use the finance-approved sales scope. Exclude sales taxes collected on behalf of government from the management revenue measure used here. State whether shipping revenue and gift-card redemptions are included, and reconcile the chosen treatment to the ledger rather than assuming the point-of-sale total is already the right figure.
A fictional US home-goods retailer reviews one completed month. Gross sales are before returns; there are no other sales deductions in this example. The transaction count contains completed purchase transactions, with return-only transactions excluded, so the transaction measure below is explicitly net revenue per completed purchase.
Net sales = gross sales - returns
Gross profit = net sales - cost of goods sold
Gross margin = gross profit / net sales
The IRS guide to figuring gross profit follows the same arithmetic: deduct returns and allowances to find net receipts, then subtract cost of goods sold. This is a management reporting example, not tax guidance.
| Store | Gross sales (USD) | Returns (USD) | Net sales (USD) | COGS (USD) | Gross profit (USD) | Gross margin |
|---|---|---|---|---|---|---|
| Columbus | 220,000 | 20,000 | 200,000 | 120,000 | 80,000 | 40.0% |
| Dayton | 160,000 | 10,000 | 150,000 | 105,000 | 45,000 | 30.0% |
| Toledo | 120,000 | 10,000 | 110,000 | 66,000 | 44,000 | 40.0% |
| Total | 500,000 | 40,000 | 460,000 | 291,000 | 169,000 | 36.7% |
The total checks are $500,000 minus $40,000 equals $460,000, and $460,000 minus $291,000 equals $169,000. Company margin is $169,000 / $460,000 = 36.7%, rounded to one decimal place. Calculate it from total dollars; the gross profit margin guide explains the weighted-total check.
Dayton earns more revenue than Toledo but produces almost the same gross profit. That is a reason to inspect Dayton's category mix, markdowns, returns and cost assignments. The table does not establish which explanation is correct.
| Store | Net sales (USD) | Completed purchases | Net revenue per purchase (USD) |
|---|---|---|---|
| Columbus | 200,000 | 4,000 | 50.00 |
| Dayton | 150,000 | 3,000 | 50.00 |
| Toledo | 110,000 | 2,000 | 55.00 |
| Total | 460,000 | 9,000 | 51.11 |
Each result divides net sales by the purchase count. The company figure is $460,000 / 9,000 = $51.11, rounded to cents. Toledo's higher result describes dollars per purchase; it does not imply a higher conversion rate because the table contains no visitor count.
The following table uses inventory at cost. There are no transfers, shrinkage or other adjustments in this simplified month. In a real export, keep those movements as separate columns.
| Store | Opening inventory (USD) | Receipts at cost (USD) | COGS (USD) | Closing inventory (USD) |
|---|---|---|---|---|
| Columbus | 150,000 | 100,000 | 120,000 | 130,000 |
| Dayton | 120,000 | 100,000 | 105,000 | 115,000 |
| Toledo | 90,000 | 50,000 | 66,000 | 74,000 |
| Total | 360,000 | 250,000 | 291,000 | 319,000 |
Opening stock plus receipts minus cost of goods sold must equal closing stock: $360,000 + $250,000 - $291,000 = $319,000. Tie the closing balance to the inventory control account. If warehouse stock exists, show it separately and include it once in the company total.
Using the two endpoint balances, average inventory is ($360,000 + $319,000) / 2 = $339,500. Monthly turnover is $291,000 / $339,500 = 0.86 turns, rounded to two decimals. Label it monthly; it is not an annual turnover figure. The inventory turnover guide covers that measure in depth.
Finance owns net sales, cost and the inventory reconciliation. Store operations owns transaction definitions and location comparability. Merchandising owns the explanation of category mix and markdowns. Buyers review stock by product and location, because a company inventory total can conceal a shortage in one store and excess stock in another.
For this example, Dayton's margin is the first commercial exception. Ask for its category-level profit table before proposing a price change. Ask for product-level availability before moving stock merely because one store's closing balance is larger.
Bring a sample of your own sales, returns, product costs and inventory in a business file; Covirage maps the columns, its tools compute and check the figures, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring the export behind your store review.
See revenue driver analysis for the supporting business context.
Start with net sales, gross profit, gross margin, completed transactions, average transaction value and inventory at cost. Add a store or category comparison and a clear period label. A measure belongs on the dashboard when its owner can explain the source and act on an exception.
Divide the agreed net sales amount by the eligible completed transaction count. State how returns and canceled orders affect each side. For a company total, divide total sales by total transactions rather than averaging each store's transaction value.
Use inventory at cost when comparing it with cost of goods sold or calculating inventory turnover. A separate retail-value view can help merchandising, but label it clearly. Mixing stock at selling price with costs makes the resulting ratio difficult to interpret.
Total growth includes changes in the store estate, such as openings and closures. Same-store growth compares a defined set of comparable locations across both periods. State the eligibility rule, comparison dates and treatment of remodeled or temporarily closed stores before reading the result.