Wine, Spirits & Cigars Finance Dashboard — Excel Tracker

The Complete Finance Tracker for Wine Shops, Spirits Retailers & Cigar Lounges

Built specifically for the wine, spirits, and cigars trade in Mauritius, this Excel dashboard gives shop owners and managers a full financial picture — from annual revenue to staff payroll — all in one beautifully organised file in Mauritian Rupees (Rs).

Just enter your figures in the yellow cells. Every total, margin, and status updates automatically.

What's Inside — 5 Powerful Tabs

• 📊 Dashboard — Your command centre. See Total Annual Revenue, Total Expenses, and Net Annual Profit at a glance, plus a Full Annual Summary covering Monthly Expenses, Net Profit, Profit Margin %, Total Payroll, and Total Stock Value.
• 📅 Sales — Monthly Sales Tracker by product category (Red Wine, White Wine, Rosé Wine, Champagne, Premium Whisky, Rum & Spirits, Gin & Vodka, Craft Beer, Premium Cigars, Cigarillos, Gift Sets & more) with annual totals and a Monthly Operating Costs breakdown (Stock, Wages, Rent, Marketing, Storage, Import Duties, Packaging, Miscellaneous).
• 💰 Product Margin — Enter cost price and selling price per product to instantly see Gross Margin (Rs) and Margin % with a traffic-light status: 40%+ = Great | 30–40% = Acceptable | Below 30% = Review Price.
• 📦 Inventory — Stock & Inventory Tracker covering Wines, Spirits, Beer, Cigars, and Accessories. Enter quantities and costs to see Stock Value per item, Total Stock Value, and automatic REORDER NOW alerts when stock hits the reorder level.
• 👥 Payroll — Monthly Staff Payroll for up to 7 roles (Shop Manager, Senior Sales Advisor, Sales Advisor, Cashier, Stock & Delivery, Part-Time Staff). Enter Basic Salary, Allowances, Overtime, and Deductions — Net Pay calculates automatically.

Key Features

• ✅ Pre-built formulas — zero manual calculations
• ✅ Tailored for wine, spirits & cigars retail
• ✅ 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 wine shops, spirits boutiques, cigar lounges, duty-free retailers, and F&B importers in Mauritius.

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