We've upgraded your dashboard with advanced financial analysis, giving you a clear, precise, and realistic view of your margins and profitability.
🔍 What's Changed
Your interface now displays detailed financial indicators that help you understand where you're truly making money and where you can optimize.
📊 New Statistics Available
👉 Overall:
💼 Cost of Goods Sold (COGS)
→ How much the products you've sold cost you
(calculated from the purchase price of each product sold)
📈 Gross Profit
→ Your earnings before operating expenses
📊 Gross Margin (%)
→ Your commercial margin
💸 Total Expenses
→ Stock purchases + operational expenses
💰 Net Profit
→ Your actual profit after all costs
📉 Net Margin (%)
→ Your final profitability
📦 In the sales statistics table (by product, category, and collection)
🧮 Purchase Cost (based on the entered purchase price of products sold)
💵 Gross Profit & Profit Margin
⚙️ How It Works
Simply Enter the purchase price in your product sheets (if not already done)
The system automatically calculates:
✅ COGS for each sale
✅ Margins by product, category, and collection
✅ Gross and net profits
✅ Your most profitable products
🛡️ Smart Display Based on Period
To avoid any double counting, the system automatically adjusts the display:
🔹 If there are no stock purchases during the selected period
→ The overall COGS is displayed

🔹 If there are stock purchases during the period
→ The overall COGS is hidden, and the calculation is based on total expenses

👉 Detailed analysis by product, category, and collection remains available, based on purchase prices.

📅 Concrete Examples
🟦 Month 1 — You purchase stock
You purchase stock
You record the purchase in your expenses
You update the purchase price of the affected products (if necessary)
🔍 When you view statistics for this month:
*Overall COGS hidden
*Profit calculation is based on total expenses (stock purchases + other charges)
👉 Goal: avoid any double counting
🟩 Month 2 — No stock purchases
You make no stock purchases
You continue to sell normally
🔍 When you view statistics for this month:
COGS displayed
→ based on the last entered purchase price for each product
Gross profit & gross margin displayed
Other expenses taken into account
Net profit & net margin displayed
👉 Goal: measure the actual profitability of sales
🟨 Simple Summary
With stock purchases during the period
→ calculation based on expenses
Without stock purchases during the period
→ calculation based on COGS
Product-level analysis always remains available
🚀 To Get Started
1️⃣ Add your cost prices
Open each product sheet
Enter the purchase price
Save
2️⃣ Record your expenses normally
Stock purchases → category Product Purchases
Other expenses → rent, salaries, advertising…
3️⃣ View your statistics
The correct metrics are automatically displayed based on the period
🎯 What This Brings You
📊 Clear vision of truly profitable products
🎯 Strategic decisions based on reliable data
⚡ Total flexibility: two methods usable simultaneously
🛡️ Automatic protection against double counting of costs
⚠️ Limitations to Know
Product COGS is based on the current cost price, not historical
Modifying a purchase price also impacts past statistics
During periods with purchases, overall COGS is hidden (but product analysis remains visible)
🎓 Not to Be Confused
🧮 COGS = cost of products sold during the period
📦 Stock Purchases = money spent on stock (sold or not)
➡️ These two concepts are different, hence the smart display.



