Free Excel template
Daraz Seller Profit Calculator
Free Excel sheet for Daraz sellers in Pakistan: enter each order and see real profit after commission, payment fee, shipping, vouchers and packing. Monthly summary included.
Download free Excel fileWorks in Excel and Google Sheets. Sheets inside: How to use, Settings, Orders, Summary.
How to use it
- 1Type your own commission % and payment fee % in Settings. Copy them from your Daraz Seller Center statement; rates differ by category, so the sheet does not guess them.
- 2Add one row per order: date, order number, product, quantity, selling price and buying cost.
- 3Profit and margin fill in automatically. Red profit means the order lost money.
- 4Open Summary to see total sales, fees and profit, for all time or one month.
What it shows
- Profit and margin per order
- Commission, payment fee, shipping and voucher costs
- Monthly filter on the summary
- Loss orders highlighted in red
Made for: Daraz and online sellers who want to know which products actually make money.
The few rows marked EXAMPLE show how it works. Delete them before adding your own data.
Want this sheet set up with your own data?
Send your file and we adjust the template to your business. Simple Excel changes Rs 900 per file, messy file clean-up Rs 2,000 per file.
Need more than a template? See our Financial Analysis & Reporting service.
More free templates
Shop Stock Register
Record stock in and out and instantly see current stock, stock value and what to reorder.
ViewKhata / Udhaar Ledger
Track udhaar given and payments received, with every customer's balance in one place.
ViewPayment Recovery Tracker
See who owes you, how late each bill is and how much is stuck in each ageing group.
View