If you sell sofas, beds or dining sets online, a plain order export tells you almost nothing. You need to see revenue next to profit, margin by category, which traffic source brings the high-value orders, and how many orders come back. The online furniture retail dashboard in Excel from Next Gen Templates does that on five pages, using 500 sample orders you can replace with your own in minutes.
Watch the Online Furniture Retail Dashboard in Excel: 5 Pages, 17 Charts walkthrough
What the Online Furniture Retail Dashboard Shows
The Overview page opens with five cards: $577.3K total revenue, $212.2K total profit, 500 orders, a $1.2K average order value and a 3.9 star customer rating. Beside them a gauge shows a 36.8% profit margin, and charts break revenue down by product category, orders by sales channel and margin by traffic source. In the sample data Sofas & Sectionals lead revenue at $150.4K, followed by Dining Furniture at $116.1K, and the Website channel brings 211 of the 500 orders.
Sales Analysis: Regions, States and Customer Type
Page two compares revenue with profit by region. The South leads with $186.5K of revenue and $70.2K of profit, ahead of the West at $161.1K. A Top 10 chart ranks states, with California first at $85.6K, and a small chart compares the average order value of new and returning customers.
Product Insights: Margin, Material and Units
Page three is where furniture sellers find out what really pays. Profit margin by category runs from 29.3% for Outdoor Furniture to 43.3% for Home Decor & Lighting, so the category with the most revenue is not the one with the best margin. A material chart ranks the Top 10 materials by revenue, and Units Sold by Product Category shows Office Furniture selling 173 units.
Marketing: Which Traffic Source Earns the Most
Page four ranks traffic sources by revenue: Organic Search $147.0K, Paid Search $103.3K, Social Media $91.7K, Direct $91.3K, Email $85.0K and Affiliate $58.9K. Average order value by source and profit margin by sales channel sit next to it, so you can judge a channel on margin as well as volume.
Fulfillment: Delivery, Returns and Shipping Cost
Page five tracks average delivery days by region (from 5.9 in the South to 6.6 in the West), orders by status (327 delivered, 58 returned, 57 shipped, 33 cancelled, 25 processing) and total shipping cost by channel, with the Website at $16.3K.
How to Set Up the Dashboard
- Open the workbook and click Enable Editing. There are no macros.
- On the Data sheet, delete the 500 sample rows and paste your own orders under the same headers.
- Use Data, Refresh All so the pivot tables rebuild.
- Click the Year, Month, Product Category or Sales Channel slicers to filter every card and chart together.
Limitations
This is a paste-and-refresh workbook, not a live connection to Shopify, Amazon or an ERP, and it is not an inventory or accounting system. It is built for desktop Excel on Windows. All sample figures are fictional.
This Dashboard vs. Other Options
| This Excel dashboard | DIY Google Sheets | Paid e-commerce BI | |
|---|---|---|---|
| Cost | $17.99 once | Free tool, days of build time | $50-$300+ per month |
| Setup | Paste orders, Refresh All | 1-3 days to build | Connector and schema work |
| Macros | None | None | Not applicable |
| Works offline | Yes | No | No |
Frequently Asked Questions
What is the Online Furniture Retail Dashboard in Excel?
It is a five-page Excel workbook that reports revenue, profit, orders, margin, traffic sources and delivery for an online furniture store. It runs on 21 pivot tables and 17 charts with five slicers and needs no macros.
Do I need Power BI or Shopify to use it?
No. You export your orders to Excel or CSV, paste them onto the Data sheet and click Refresh All. There is no live connector to any store platform.
Is the data real?
No. The 500 orders, customers and figures are fictional sample data so you can see every chart working before you add your own.
Which Excel version do I need?
Desktop Excel 2016 or later, or Microsoft 365 on Windows. Pivot tables and slicers refresh reliably in the desktop app.
Explore More
If you prefer Google Sheets, there is a Furniture Retail Dashboard in Google Sheets. For other five-page slicer dashboards see the Carpentry Workshop KPI Dashboard in Excel walkthrough and the Furniture Sales Register Data Entry System in Excel post.
Get the Template
Download the Online Furniture Retail Dashboard in Excel once and use it for every month of orders. The ZIP includes the workbook and a PDF user manual. Need a custom version? Contact us. Follow PK on YouTube for more Excel dashboards.
