How to Reconcile Nykaa Seller Payouts with Orders

Why payouts rarely equal order value

A Nykaa payout is built from sales on delivered orders, less returns, commission, fees and tax deductions, adjusted for timing. Orders placed in one week may settle in another, and returns can land in a later cycle.

Reconciliation means proving, line by line, why the amount received is what it is. Do it for every settlement cycle rather than once a quarter, so gaps are still fresh and the evidence is still available.

Collect the data you need

Pull these for the same period and keep them in one workbook or database:

• Order or sales report: order ID, SKU, selling price, status and delivery date.
• Returns report: return or cancellation IDs, dates and reasons.
• Settlement or payout statement: line-level credits and deductions for each cycle.
• Bank statement: the actual credit and its date.
• Seller agreement and rate card: commission, fixed fees and any other agreed charges, including amendments.
• Your own records: ERP or order system, invoices and credit notes.

Report names and columns differ by seller panel and change over time, so confirm what your panel currently offers before building a template.

Step-by-step: match payouts to orders

1. Fix the cycle. Choose one settlement and list the orders and returns it claims to cover.
2. Standardise keys. Use order ID (and sub-order or SKU where relevant) in every file. Remove duplicates and fix formatting such as trailing spaces.
3. Match delivered orders to payout lines. Flag delivered orders with no payout line, and payout lines with no matching order.
4. Match returns and cancellations. Each return should appear as a reversal or deduction. Note any that are missing or duplicated.
5. Recalculate charges. Compute expected commission, fees and tax deductions yourself (see next section).
6. Tie to the bank. Expected net payout minus actual net payout is your variance. The settlement total must equal the bank credit.

Recalculate commission, fees and tax deductions

Do not rely on memory or an old email for rates. Commission and fee terms sit in your seller agreement, rate card and any later amendments. Confirm the latest terms with your Nykaa account contact before disputing anything.

• Commission: check the category, the value it is charged on (before or after discounts) and whether the right rate was applied to each SKU.
• Fixed and other fees: confirm each fee exists in your agreement and is charged once per event.
• Promotions: if you agreed to fund a discount, check that the amount matches the agreed scheme.
• Tax deductions at source: rates and treatment are set by law, so confirm them with your tax adviser and match the amounts against your tax statements.

Common mismatches and what to do

• Timing differences: the order is delivered but not yet settled. Carry it forward and re-check next cycle rather than raising a claim.
• Returns after payout: a return recovered in a later cycle. Link it to the original order so it does not look like an unexplained deduction.
• Fee or commission differences: the amount charged differs from your recalculation. Document the SKU, rate expected, rate applied and agreement clause.
• Missing orders: delivered and not paid after the usual cycle. Raise a ticket with order IDs and delivery proof.
• Bundled adjustments: one line covering several orders. Ask for a breakup before accepting it.

Make it a repeatable monthly routine

Reconciliation only pays off if it is regular. A simple routine: reconcile every settlement within a few days of receipt, keep a running list of open variances with ageing, and raise recovery cases in time to meet whatever claim windows your agreement sets.

If volumes make spreadsheets slow, MarketplaceMetrics by Fundle reconciles marketplace sales and settlements, checks commissions and fees against agreed terms, and tracks returns and recovery cases. Myntra Excel reports are reviewed; other marketplaces, including Nykaa, are in scope discussion. Pricing is a tailored quote.