Clothes Shop Finance Dashboard — Excel Tracker

The Complete Finance Tracker for Clothes Shops & Fashion Retailers

Built specifically for clothing boutiques, fashion retailers, and uniform suppliers in Mauritius, this Excel dashboard gives shop owners and managers a full financial overview — from monthly sales by category to stock inventory — all in one file in Mauritian Rupees (Rs).

Enter your figures in the yellow cells and every total, stock value, and profit margin updates automatically.

What's Inside — 4 Powerful Tabs

• 📊 Dashboard — Your command centre. See Total Revenue, Total Expenses, and Net Profit at a glance, plus a Full Summary showing Total Revenue, Total Expenses, Net Profit, Profit Margin %, Total Payroll, and Total Stock Value — all auto-calculated.
• 📅 Sales — Monthly Revenue by Category (Ladies Clothing, Mens Clothing, Kids Clothing, Shoes & Footwear, Bags & Accessories, Sportswear, School Uniforms, Other) with annual totals, plus a Monthly Operating Costs breakdown (Stock Purchase, Staff Wages, Rent, Utilities, Marketing & Social Media, Packaging & Bags, Display & Fixtures, Miscellaneous) and a Profit Summary.
• 📦 Inventory — Stock & Inventory Tracker with 13 pre-filled items across 7 categories: Ladies Dress, Ladies Top (Ladies), Mens Shirt, Mens Trousers (Mens), Kids T-Shirt, Kids Shorts (Kids), Sneakers, Sandals (Shoes), Handbag (Accessories), School Shirt, School Trousers (Uniform), Other. Enter Qty in Stock, Reorder Level, Cost Price, and Selling Price — Stock Value calculates automatically per item with a Total Stock Value summary.
• 👥 Payroll — Monthly Staff Payroll for up to 6 roles (Shop Manager, Senior Sales Staff, Sales Staff x2, Cashier, Part-Time). Enter Basic Salary, Allowances, Overtime, and Deductions — Net Pay calculates automatically.

Key Features

• ✅ Pre-built formulas — zero manual calculations
• ✅ 13 pre-filled clothing items with size ranges
• ✅ Stock value calculator with reorder level tracking
• ✅ Currency set to Mauritian Rupees (Rs)
• ✅ Color-coded for fast, easy reading
• ✅ Works on Microsoft Excel (desktop & online)
• ✅ Instant download — ready to use today

Perfect for clothing boutiques, fashion retailers, shoe shops, school uniform suppliers, and accessories stores in Mauritius.

Format: .xlsx (Microsoft Excel) | Currency: MUR (Rs) | Instant Digital Download