Daraz Profit Calculator Excel Template (Free)

This is a free Excel profit calculator for Daraz sellers. Type a price, a cost and a commission rate, and it builds the same lines you see on a Daraz weekly statement, then shows what you actually keep.

Download daraz-profit-calculator.xlsx

The file is about 30 KB and has three sheets: Orders, Settings and Read me. No macros, no sign-up.

What Does the Sheet Calculate?

For every order row it works out:

• Revenue (price times quantity) and what the customer paid, including shipping they paid and any seller voucher.
• Commission, payment fee and handling fee.
• 15 percent VAT on those three, and VAT on the net shipping charge (shipping charge minus the shipping fee discount).
• Sales tax withholding and income tax withholding.
• Total Daraz deductions, then net payout.
• Your product cost, packing cost, profit, margin and ROI.

There are also columns for free shipping max fees, co-funded vouchers, Daraz Coins fees, refunds, fees reversed on returns, penalties and other deductions. The sums follow the same model as our online profit calculator. For the reasoning behind each line, read Daraz seller fees explained.

How Do I Use It?

1. Download the file and open the Orders sheet. Three sample rows from a fictional Store A are already filled in.
2. Overwrite or clear them. Fill the yellow cells with blue text: product, item price, quantity, cost, packing and commission rate.
3. Look up the commission rate for your category in the Daraz commission list and type it in as a number, for example 13 for 13 percent.
4. Copy the per-unit handling fee, the Daraz shipping charge and the shipping fee discount from a similar line on your own statement. Leave blank what does not apply.
5. Open the Settings sheet and check the payment fee, VAT and withholding percentages. Change them if your statement shows something different.
6. Read profit, margin and ROI at the right of each row. Totals sit in row 3.

Example: One Sample Order

Example (made-up Store A: one phone case sold at Rs 2,000, cost Rs 900, packing Rs 30, handling Rs 20):

Line	Amount (Rs)
Customer paid	2,000.00
Commission at 13%	260.00
Payment fee at 2.25%	45.00
Handling fee	20.00
VAT 15% on those three	48.75
Sales tax withholding (estimate)	39.00
Income tax withholding (estimate)	32.00
Net payout	1,555.25
Product cost and packing	930.00
Profit	625.25

That is a 31.3 percent margin on revenue. The 13 percent commission is the real rate for that category in the Daraz table; the price, cost and handling are invented. Source: Daraz University PK commission rates, effective 1 June 2026, excluding VAT.

The second sample row shows a two-unit order with a shipping charge and discount. The third shows a returned order, where the refund outweighs the fees given back and the sheet shows a loss. That third row is the reason to model returns before you scale a product.

What Are the Honest Limits?

• It is an estimate model. It matches our reconciliation of weekly statements, but your statement is the final word.
• Withholding percentages are our estimates, not legal rates. Check your own statement and FBR guidance.
• It does not look up your category. Use the commission calculator sheet for that.
• It does not import your Daraz data. You type or paste each order.
• Daraz can change fees and rates. Check Seller Center before you rely on a number.

If you run several stores and retyping orders is the bottleneck, Seller's Revolution shows your payouts, statements and fee breakdown for every connected store in one place. The sheet is the free way to start.