Omnikyo/Help Center
Reference

How report numbers are worked out

Every report figure comes from a rule about which orders count and what they mean. Learn the rules so you can trust the numbers.

বাংলায়: রিপোর্টের প্রতিটা সংখ্যা আসে একটা নিয়ম থেকে — কোন অর্ডার কাউন্ট হবে, কোন অর্ডার হবে না। সেই নিয়মগুলো জানলে বুঝতে পারবেন সংখ্যা কোথা থেকে এসেছে।

Where to find it: Every report in Sidebar › Business › Reports uses these rules.

Sales, revenue and profit: what each means

Sales is the total of all order amounts — what customers were charged, delivered and unpaid both. A Tk 5,000 order counts as Tk 5,000 in sales whether they paid upfront or you are still waiting for cash on delivery.

Revenue is the cash your business actually got. On a Delivered order, revenue is the cash collected plus any advance payment made. Returned orders and orders still in transit do not bring revenue.

Gross profit is revenue minus the courier fees on delivered orders, minus the cost of the goods you sold, minus courier fees on returned orders. It does not include ads or other running costs.

Net profit is gross profit minus ad spend minus expenses logged in the Expenses page. This is how much money the business kept after everything.

Worked example

You place an order for Tk 10,000 at Tk 6,000 cost, with a Tk 300 delivery fee and Tk 500 advance payment. When it is delivered, the customer pays Tk 9,500 cash on delivery.

  • Order total (Sales) = Tk 10,000
  • Revenue when delivered = Tk 9,500 + Tk 500 advance = Tk 10,000
  • Gross profit = Tk 10,000 (revenue) − Tk 6,000 (goods cost) − Tk 300 (delivery fee) = Tk 3,700
  • Net profit = Tk 3,700 (gross) − Tk 200 (ads that day) − Tk 100 (rent share) = Tk 3,400

How each order status is counted in reports

A report counts orders created in your date range, grouped by their current status right now. A cancelled order is excluded from the headline figures; a returned order counts differently than a delivered one.

StatusIn Sales totalRevenue counted?Delivery fee typeCounts as delivered?Counts as returned?
New, Confirmed, Preparing, Hold✓ yesno (still promised)not countednono
Dispatched✓ yesnonot countednono
Delivered✓ yes✓ yes (cash + advance)Courier fee✓ yesno
Return Pending, Returned✓ yesnoReturn fee onlyno✓ yes
Cancelledno (left out)nonot countednono

An order is New, Confirmed or Preparing when nothing has been decided or done yet. It is in Sales (the number of orders promised) but brings no revenue until cash arrives or you mark it Delivered. The delivery fee does not count as cost yet.

When an order is Dispatched it is on the way. It still has not brought revenue. The delivery fee does not count yet.

When an order is Delivered the goods are with the customer and either cash was collected or an advance was taken. This is when the order becomes revenue and the delivery fee counts as a cost. Product cost also counts now.

Returned and Return Pending orders are orders that came back. They bring no revenue. The courier fee on a returned parcel counts as a cost (the return fee). Returned orders are counted as returns, not deliveries.

Cancelled orders are orders that never happened. They are left out of the headline figures on the Overview — not in Sales, not in Orders, not in profit.

Delivery rate and return rate: why pages show different numbers

The same words mean different things on different report pages, because each page answers a different question. A delivery rate of 95% on one page and 92% on another is not a mistake.

PageWhat "Delivery rate" countsExample
Overviewdelivered ÷ all non-cancelled orders950 delivered ÷ 1,000 non-cancelled = 95%
Orders & Salesdelivered ÷ dispatched only950 delivered ÷ 980 dispatched = 97%
Fulfilment & Courierdelivered ÷ dispatched only950 delivered ÷ 980 dispatched = 97%
Products (units)— (no delivery rate)—
Customers (per customer)delivered ÷ (delivered + returned)That customer: 4 delivered ÷ 5 orders = 80%

Why the differences make sense

Overview's delivery rate (delivered ÷ all non-cancelled) tells you: "Of all the orders my business took, what share reached the customer?" It includes orders you have not sent yet, because they are still a risk.

Orders & Sales and Fulfilment pages (delivered ÷ dispatched) answer "Of the parcels we sent, what share arrived?" It ignores orders not yet sent, because you have not handed them to a courier.

Customers page (delivered ÷ delivered + returned) measures that customer's reliability. It does not include orders still being prepared, only ones that had an outcome.

The same thinking applies to return rates. On Overview, return rate is returned orders against all non-cancelled orders; on Orders & Sales it is returned ÷ (delivered + returned); on Fulfilment it is returned ÷ dispatched.

Worked example

You have 1,000 orders created this month. 50 are still being prepared. 950 have been dispatched. 900 delivered, 40 returned, 10 lost. What are your delivery rates?

  • Overview: 900 delivered ÷ 1,000 non-cancelled = 90%
  • Orders & Sales: 900 delivered ÷ 950 dispatched = 95%
  • Fulfilment: 900 delivered ÷ 950 dispatched = 95%

All are correct. Overview tells your customer success. Orders & Sales tells how well your couriers perform.

Why the drawer total can differ from the headline

When you click Orders on a headline figure, a drawer opens showing the orders behind that number. But the Total in the drawer may not equal the headline — sometimes it is much lower.

The difference is the accounting basis.

Headlines use a P&L basis: they count what the business kept and what it owed. Revenue on Overview means cash collected + advances on delivered orders. Net profit is what the business gets to keep after all costs.

The drawer lists the orders behind the number and works from the order lines: product amount (quantity × selling price) and cost of goods, without delivery fees, ad spend or other business costs. Its profit is product sales minus the cost of goods, not the net profit the business sees.

Worked example

An order for Tk 10,000 in products (Tk 6,000 cost), with Tk 300 delivery, was delivered and paid in full.

  • Headline Net profit counts this order as: Tk 10,000 (revenue) − Tk 6,000 (cost) − Tk 300 (delivery) − Tk 100 (ads) = Tk 3,600
  • Drawer profit on that order shows: Tk 10,000 (sales) − Tk 6,000 (goods cost) = Tk 4,000

The headline is lower because it subtracts delivery fees and ads. The drawer uses goods basis — it shows the profit on the products alone.

If you open the Revenue headline and look in the drawer, the drawer shows goods sales only (it won't subtract delivery fees, because they're not part of goods sales). The headline Revenue of Tk 10,000 and the drawer Total of Tk 10,000 are the same — but one is P&L revenue (cash in), the other is goods sales, and they happen to match on this product.

FigureHeadline basisDrawer basisWhy it matters
Net ProfitGross profit − ads − expensesGoods sales − goods costHeadline is business net; drawer shows just the products
RevenueCash + advances on DeliveredGoods sales onlyThey often match; watch for discounts and partial deliveries

Other ways people ask this

  • sales vs revenue kibhabe alada
  • কোনো অর্ডার যখন রিটার্ন হয় তখন কী সব গণনা থেকে বাদ যায়
  • দেখাচ্ছে ডেলিভারি ৮৫ শতাংশ, আরেক পাতায় ৯০, কিসের পার্থক্য
  • গ্রস প্রফিট আর নেট প্রফিট এর ফারাক
  • ড্রয়ার খুলে তাকিয়ে দেখি শিরোনাম থেকে একি সংখ্যা নয় কেন
  • কেন রিপোর্টে একি অর্ডার আমার সেলস তালিকায় আছে কিন্তু রেভিনিউ তে নেই
  • cancelled order কোথায় দেখা যায় রিপোর্ট এ
  • cash on delivery order এ advance থাকলে কী গণনা হয়
  • একি পণ্য বিক্রয় মূল্য আর খরচ দামে ধরা হয় না কেন রিপোর্টে

Checked against the product on 2026-10-02.