How each dashboard number is calculated
Every dashboard figure follows an exact formula. This table shows how each one is worked out, which orders go into the sum, and what is never taken out.
বাংলায়: ড্যাশবোর্ডের প্রতিটা সংখ্যা একটা নির্দিষ্ট ফর্মুলা দিয়ে হিসাব করা হয়। এই টেবিলে প্রতিটা সংখ্যার পেছনের গণনা, কোন কোন অর্ডার গণনা হয় এবং কি কি বাদ দেওয়া হয় না, তা লেখা আছে।
Where to find it: Sidebar › Dashboard › click on any headline figure or slot for the formula
Which orders are counted
Only orders placed in the chosen date range are counted, by the date they were placed, in your business time zone. All order statuses except Cancelled count: New, Confirmed, Preparing, Hold, Dispatched, Delivered, Return Pending and Returned all go into Sales, Orders, Items and profit figures.
Headline figures and their formulas
| Figure | Counted on | Formula | Notes |
|---|---|---|---|
| Sales | Included orders | Sum of order total (total_amount) | Includes delivery fee the customer paid. Not reduced by returns that happen later. |
| Orders | Included orders | Count of included orders | One order, no matter how many items. |
| Items | Included orders | Sum of quantity on all order lines | Total items sold across all included orders. |
| Delivery fees | Included orders | Sum of shipping fee on each order | Maximum of 0 (never negative). |
| Gross revenue (not shown) | Included orders | Sales − Delivery fees | What you take after the courier is paid their delivery fee by you, before product cost. |
| Product cost | Included orders | Sum of (quantity × cost price per unit) | Cost price from the order line when placed, else the product's current cost price, else 0. Products with no cost price count as zero and inflate profit. |
| Gross profit | Included orders | Gross revenue − Product cost | Money left before ads. |
| Gross margin | Included orders | (Gross profit ÷ Gross revenue) × 100 | Zero when no revenue. Higher is better. |
| Avg order | Included orders | Sales ÷ Orders | Zero when no orders. Used for comparison with previous period. |
| Delivered | Included orders | Count of orders with current status Delivered | Only orders that have actually reached the customer. |
| Delivered share | Included orders | (Delivered ÷ Orders) × 100 | Shown as a percentage next to Delivered count. |
| Ad spend | Meta account | Meta daily spend for the range, converted and taxed (see Ad spend and ROAS) | Floors at 0. Null (n/a) when Meta failed or timed out. Reduced by any campaigns you exclude with the gear button. |
| Ad share | If ad spend is known | (Ad spend ÷ Sales) × 100 | Shown in the card's caption. |
| ROAS | If ad spend is known | Sales ÷ Ad spend | Null (n/a) when ad spend is 0 or unknown. Higher is better. |
| Per order (ad cost) | If ad spend is known | Ad spend ÷ Orders | Per-order advertising cost. Null when Meta is unknown. |
| Per delivered | If ad spend is known | Ad spend ÷ Delivered | Ad cost per order that reached the customer. Critical to profitability. Null when Meta is unknown. |
| Per unit (ad cost) | If ad spend is known | Ad spend ÷ Items | Advertising cost per item sold. Null when Meta is unknown. |
| Net profit | Included orders + Meta | Gross profit − Ad spend | What you kept. Null if Meta failed. Zero if you have no sales. |
| Net margin | Included orders + Meta | (Net profit ÷ Sales) × 100 | Shown below the Net profit figure. Uses Sales as the denominator, not Gross revenue. |
| Per order (profit) | Included orders + Meta | Net profit ÷ Orders | Profit per order on average, after products and ads. Null if Meta failed. |
| Per unit (profit) | Included orders + Meta | Net profit ÷ Items | Profit per item sold. Null if Meta failed. |
What is never subtracted
The dashboard does not reduce profit for:
- Expenses (rent, salaries, utilities) — handled separately in the Expenses area and the Financials report.
- Courier fees to Pathao or Steadfast — these are separate from the delivery fee the customer pays.
- Returns that happen after the order is placed — returned items stay in the sales total.
- Tax on your sales (VAT/GST) — this is a business accounting decision.
Figures that show as "n/a" (not available)
| Situation | Figures that read n/a |
|---|---|
| Meta not connected | Ad spend shows ৳0; ROAS, Per order, Per delivered, Per unit (ad cost), Net profit and Net margin read n/a |
| Meta timed out or failed | Ad spend, ROAS, Per order, Per delivered, Per unit (ad cost), Net profit and Net margin read n/a |
| Orders or items is zero (empty store) | ROAS, Per order, Per delivered, Per unit (profit) read n/a |
| No delivered orders | Per delivered reads n/a |
Other ways people ask this
- dashboard e sales formula kya
- profit kaise calculate hota hai ড্যাশবোর্ডে
- roas meaning and formula
- gross profit vs net profit dashboard
- order returned holes sales theke komba hoy ki na
- cancelled order dashboard e count hoy ki
- cost price না থাকলে profit কত দেখাবে
- delivery fee sale এর অন্তর্ভুক্ত কিনা
- margin percentage mane ki
- dashboard numbers formula exact
Related pages
- The Sales, Ads and Profit cards — what each figure means in plain words
- Gross profit and net profit on the Dashboard — why cost prices matter and what net profit leaves out
- Ad spend and ROAS on the Dashboard — how Meta spend is converted and taxed
- Order statuses and the lifecycle — which order statuses count as "included"
Related guides
Checked against the product on 2026-10-02.