Short Answer
This free Excel sheet embeds the Daraz commission table for every category and sub-category that has a rate, 7,840 rows from the Daraz University table effective 1 June 2026. Pick a category, enter a price and quantity, and it shows the commission excluding and including 15 percent VAT, plus what you keep.
This free Excel sheet has the Daraz commission table inside it. You pick a category, type a price, and it tells you the commission in rupees, with and without VAT.
Download daraz-commission-calculator.xlsx
The file is about 240 KB because the table is embedded, so it works offline. No macros, no sign-up.
Source: Daraz University PK commission rates, effective 1 June 2026, excluding VAT (table updated 27 October 2026).
What Is Inside the Sheet?
- Calculator: a category dropdown, price, quantity and VAT inputs, and the results block.
- Rates: every category path that has a rate in the Daraz table, one per row, with its percentage excluding VAT. Test and service placeholder categories are left out.
- Read me: the instructions and the limits.
The same table powers our Daraz commission list and the online commission calculator. You can also download the table as a CSV file if you want to build your own sheet.
How Do I Use It?
- Open the Calculator sheet and click the yellow Category cell (B4). Choose a path from the dropdown. You can also type the full path.
- If you do not know the exact path, type a word in the Search word cell (B12). The first 10 matching category paths and their rates appear in column F. Copy one into B4.
- Enter the item price and quantity.
- Leave VAT at 15 percent unless your statement shows otherwise.
- Read the results from row 14: rate excluding VAT, rate including VAT, commission in rupees both ways, and what you keep after commission.
Example: Commission with and Without VAT
Example (made-up Store A: one item priced at Rs 2,000 in a category with a 13 percent rate):
| Line | Amount |
|---|---|
| Rate excluding VAT | 13.00% |
| Rate including 15% VAT | 14.95% |
| Commission excluding VAT | Rs 260.00 |
| VAT on commission | Rs 39.00 |
| Commission including VAT | Rs 299.00 |
| You keep after commission, including VAT | Rs 1,701.00 |
The 13 percent rate is the real rate for the Phone Cases category in the Daraz table; the price is made up. A category at 18.5 percent costs about 21.3 percent of the item price once VAT is added, which is why two products at the same price can have very different margins.
What Are the Honest Limits?
- It shows commission only. Payment fee, handling, shipping and withholding are separate lines. The profit calculator sheet covers them.
- Rates change. The effective date is in the sheet. Check Seller Center for the current rate on your exact category.
- A path missing from the Rates sheet has no own rate in the table. Use its parent category and check Seller Center.
- The category dropdown is long, because the table is. The search box is usually faster than scrolling.
- Search and lookups use basic Excel functions, so the sheet also opens in LibreOffice and Google Sheets, though the long dropdown can be slow there.
Questions
How current are the rates in the sheet?
They come from the Daraz University PK commission table effective 1 June 2026, updated 27 October 2026, excluding VAT. The dates are written in the sheet. Daraz can change rates, so check Seller Center before relying on a number for a big stock decision.
Why does the sheet show commission with and without VAT?
The Daraz table lists rates excluding VAT. On the weekly statements we checked, 15 percent VAT is charged on top, so the commission line is VAT-inclusive in effect. The sheet shows both so you can match it to your statement.
What if my category is not in the dropdown?
Use the search word box: type a word like case and the first 10 matching category paths appear. Some sub-categories have no own rate in the table and inherit a parent, so if your exact path is missing, use the closest parent category.
Does it include the payment fee and handling fee?
No. It covers commission only. For payment fee, handling, shipping and withholding, use the profit calculator sheet or the online profit calculator.
Sources
Related
Skip the Spreadsheet
Start free with 50 credits, or use a free tool first.