Skip to content
Bookkeeping · 4 min read

How to Reconcile Your Daraz Payouts With Your Orders

Your dashboard says one figure, your bank says another. Here is how to work out where the difference went, order by order.

How to Reconcile Your Daraz Payouts With Your Orders

Every marketplace seller in Pakistan runs into the same problem sooner or later. The sales figure on the seller dashboard is healthy. The money that reaches the bank is noticeably less. And nobody can say exactly why.

The difference is not a mystery. It is made up of specific deductions, each of which can be traced. Reconciling your payouts is how you trace them. It is also how you find money the marketplace owes you and has not paid.

This guide uses Daraz as the example because it is where most Pakistani sellers start, but the same method works for any marketplace.

What sits between an order and your bank

For each order, the amount you finally receive is the order value minus some combination of:

  • Commission, usually a percentage that varies by category
  • Payment or transaction fees
  • Shipping fees charged to you, depending on your arrangement
  • Vouchers and promotions you agreed to fund
  • Penalties, for late dispatch, cancellations or policy breaches
  • Tax deducted by the marketplace before paying you

And for orders that were returned or failed delivery, you may receive nothing, or be charged return shipping on top.

The exact rates change, and differ by category and seller. That is exactly why you reconcile from the actual statements rather than estimating.

The reconciliation, step by step

1. Download the statements

From your seller account, download the transaction or account statement for the period, and the order report for the same period. Most portals only keep a limited history online, so download every month.

2. Download the bank statement

For the same period, from the bank account your payouts go to.

3. Match payouts to the bank

Each payout listed in the marketplace statement should appear as a deposit in your bank. Tick them off. A payout with no matching deposit needs to be raised with the marketplace.

4. Break each payout down into orders

Each payout covers a set of orders, minus a set of fees. Using the transaction statement, list every order in the payout with its value and every deduction against it.

5. Check every order was paid

Compare the order report with the orders in your payouts. Any order marked as delivered that does not appear in any payout after the normal settlement period is money owed to you. This is the most valuable part of the exercise. Sellers who never reconcile never find these.

6. Check the returns

For every returned order, check that it is actually back in your stock and in a sellable condition. Record return shipping charges and damaged items as costs. If your return rate on a product is high, that product's real margin may be far lower than you think.

7. Record the deductions as costs

Commission, fees, shipping, vouchers and penalties are business expenses. They go in your books as costs of selling, not netted off against sales and forgotten. Your turnover for tax purposes is generally the gross sales figure, not the net payout.

8. Record the tax deducted

Tax deducted by the marketplace is a credit you can claim against your income tax. Keep the record of every deduction. If you do not record it, you pay it twice.

What this tells you

Once a few months are reconciled, you can calculate what each product actually earns after commission, fees, shipping, returns and penalties. For many sellers that is where they discover a bestseller that loses money on every order.

Cash on delivery through your own store

If you also sell through Instagram, WhatsApp or your own website with cash on delivery, the same logic applies to your courier: match each COD remittance to the parcels it covers, chase parcels delivered but not paid for, and record return-to-origin charges.

Doing it every month

The first reconciliation is the hardest. After that, an hour a month keeps it current. If you would rather hand it over, e-commerce bookkeeping is exactly this work, done monthly. If you are selling enough that sales tax registration may apply, see sales tax registration.

Information on this site is general in nature and is not a substitute for advice on your own circumstances.

Get a fixed quote

Send us your details and we'll come back with a firm price and what we need from you. No obligation.

WhatsApp us
WhatsApp Call