To forecast marketplace cash flow from settlement cycles, find your payout rules in the seller agreement, map each order from delivery to payout date, apply expected returns and deductions to get net payable, then place that amount in the payout week. Roll it forward weekly and compare with actual settlements to refine your assumptions.
Start with the settlement rules, not the sales report
Sales dashboards show demand. Your bank shows cash. The gap between them is set by the marketplace's settlement terms, so collect these first:
- Settlement trigger: whether payout is counted from dispatch, delivery or the end of the return window.
- Payout frequency: daily, weekly, fortnightly or on a fixed calendar, as per your seller agreement.
- Holds and reserves: any amount retained for returns, disputes or compliance checks.
- Deduction heads: commission, fixed fees, shipping, ads, penalties, and statutory deductions such as TCS or TDS.
Do not copy any of these from another brand or from an old blog post. Rates and cycles change. Confirm them in your current agreement, rate card and recent settlement reports, and ask your tax adviser how statutory deductions should be treated in your books.
Map the order-to-cash timeline
Build a simple timeline for one order and note the lag in days at each step. Use your own settlement reports to measure the lags, not assumptions.
| Stage | What to record |
|---|---|
| Order placed | Order date, gross value |
| Shipped / delivered | Delivery date, usually the start of the clock |
| Return window closes | Date after which the sale is largely final |
| Settlement eligible | Date the order enters a payout cycle |
| Payout credited | Bank credit date and UTR |
The total lag from delivery to credit is your cash conversion lag. It may differ by marketplace, category or fulfilment model, so keep separate lags where they differ.
Convert gross sales into expected net payout
For each week of deliveries, work down from gross value to expected cash:
- Gross delivered value for the week.
- Less expected returns, using your own historical return rate by category or marketplace.
- Less commission and fees as per your agreement and rate card.
- Less other deductions such as shipping, ads or statutory deductions, taken from recent settlement reports.
- Less holds, if the marketplace retains a portion for a period.
The result is expected net payable. Place it in the payout week implied by your lag, not the delivery week.
Build a rolling 13-week view
A 13-week rolling forecast suits most brands because it covers a full quarter while staying close enough to act on. Lay out weeks across the top and keep three rows for each marketplace: forecast deliveries, expected payouts and actual payouts. Add outflows below: inventory purchases, ad spend, salaries, rent and tax payments.
For future weeks, use your sales plan or recent run rate. For near weeks, deliveries already made give you high-confidence payouts. Mark which part of each week's number is already in the pipeline and which is still projected.
Reconcile weekly and fix the assumptions
A forecast improves only when you compare it with actual settlements. Each week, compare expected and actual payout and classify the difference:
- Timing: payout shifted to another week, so the cash is delayed, not lost.
- Returns: return rate differed from your assumption.
- Fees: deductions did not match agreed terms, which needs checking against the rate card.
- Unexplained shortfall: a missing order, wrong adjustment or unrecovered claim that needs a case.
Tools such as MarketplaceMetrics by Fundle can help here by reconciling sales against settlements, checking commissions and fees against agreed terms, and tracking returns and recovery cases. A spreadsheet works too if you stay consistent.
Common mistakes to avoid
- Forecasting on order date instead of delivery or eligibility date.
- Using one blended lag for every marketplace and category.
- Ignoring returns that arrive after the payout, which show up as later deductions.
- Treating short settlements as timing differences without checking them.
- Not updating assumptions after a change in the seller agreement or fee structure.
Worked example
Illustrative example only. The figures below are assumptions for explanation, not real rates or results. Replace them with numbers from your own agreement and settlement reports.
Assume a brand delivers ₹10,00,000 of orders in Week 1 on one marketplace. From history, it expects 15% returns and a blended 22% of the remaining value in commission, fees and other deductions. Payout lag is two weeks from delivery.
| Step | Amount (₹, illustrative) |
|---|---|
| Gross delivered, Week 1 | 10,00,000 |
| Less returns at 15% | (1,50,000) |
| Net kept sales | 8,50,000 |
| Less blended deductions at 22% | (1,87,000) |
| Expected net payout | 6,63,000 |
The ₹6,63,000 goes into the Week 3 column, not Week 1. If the actual credit is ₹6,20,000, the ₹43,000 difference is then split into timing, return variance, fee variance or an unexplained shortfall for follow-up.
Questions and answers
How far ahead should I forecast marketplace cash flow?
A 13-week rolling forecast works for most brands. Near weeks are driven by orders already delivered, so they are reliable. Later weeks rely on your sales plan and historical return rates. Refresh it weekly and compare with actual payouts.
Where do I find my settlement cycle and payout terms?
Check your seller agreement, the marketplace's current rate card or policy pages, and your recent settlement reports. Reports show actual payout dates and deductions. If the documents conflict or are unclear, confirm the latest terms with your account manager.
Should I forecast by order date or delivery date?
Use the date that starts the settlement clock under your agreement, which is often delivery or the end of the return window. Order date is useful for demand planning but misleads cash planning because cancellations and returns change what is finally paid.
How do I handle returns in a settlement-based forecast?
Apply an expected return rate from your own history, by category and marketplace, to each week's deliveries. Track late returns that appear as deductions in later settlements, and review the rate monthly so the forecast reflects current behaviour.