Perfume Decant Financial Management Dashboard Template

This Excel template is a complete financial management system built especially for perfume‑decant businesses. It is organized into eight interconnected sheets, each serving a specific purpose while feeding data automatically into a visual dashboard.

Structure

• Products – list every perfume, brand, original bottle cost, volume and decant size. Calculated fields give cost per ml, unit cost, total cost, selling price, gross margin (R$ and %). Each size (2 ml, 5 ml, etc.) is a separate line.
• Sales – record every transaction with date, product (dropdown from Products), quantity, unit price, channel, fees, freight and automatically derived revenue, cost, gross profit and net profit.
• Fixed Costs – monthly recurring expenses such as marketing, tools or bulk packaging.
• Variable Costs – per‑unit or percentage costs like packaging, commissions or platform fees, linked to the appropriate product or applied globally.
• Inventory – tracks initial stock, purchases, automatic deductions from sales, current balance and low‑stock alerts.
• Cash Flow – logs every cash inflow and outflow, categorises them and shows a running balance.
• Dashboard – dynamic charts and KPIs: total revenue, gross and net profit, average margin, top‑earning products, best‑selling items, most profitable channel, monthly trends and break‑even point.
• Financial Summary – monthly totals for revenue, variable and fixed costs, net profit, net margin, average ticket and ROI where possible.

Why it matters Running a decant business means juggling tiny unit costs, multiple sales platforms and fluctuating fees. Manual spreadsheets quickly become error‑prone, leaving you blind to true margins and cash health. This template eliminates manual calculations, ensures every sale pulls the correct cost data, and instantly shows which scents, sizes or channels drive profit. You can spot unprofitable products, adjust pricing before losses mount, and keep inventory levels optimal without guessing.

Who benefits Entrepreneurs, small‑scale perfume resellers, e‑commerce managers and anyone selling fragrance samples on platforms like Shopee, TikTok, personal websites or WhatsApp will find this workbook invaluable. It works for startups that need a professional financial view without investing in expensive software.

What it tracks

• Unit cost per decant, including original bottle, decant bottle, packaging and operational overhead.
• Gross and net profit per sale, per product and per channel.
• Fixed and variable expenses, automatically rolled into profit calculations.
• Real‑time inventory levels and low‑stock warnings.
• Cash inflows/outflows and cumulative balance.
• Key performance indicators that highlight profitability trends and break‑even status.

How to use

1. Populate Products – enter each perfume, its brand, original bottle cost and volume. Choose decant sizes; the sheet will compute cost per ml, unit cost and suggested selling price.
2. Log Sales – add a new row for every transaction, select the product from the dropdown, fill quantity, channel and any fees. All revenue, cost and profit fields fill automatically.
3. Update Costs – each month, list fixed expenses in the Fixed Costs sheet and variable per‑unit fees in Variable Costs. The template will incorporate them into the summary and dashboard.
4. Review Dashboard – watch the charts update in real time. Identify top‑performing scents, most lucrative channels and the month‑over‑month profit trajectory. Use the Financial Summary to plan pricing adjustments or inventory re‑orders.

Expected benefits By automating calculations and centralising data, you save hours of manual bookkeeping, reduce errors, and gain instant insight into profitability, enabling faster, data‑driven decisions.