Practical guide · Financial support

How to connect a seller’s purchasing plan with cash flow

A promising purchase needs testing both against product economics and cash requirements. Forecast receipts and payments by date.

Start with available cash and obligations

Confirm bank balances and obligations already incurred. List upcoming payments: suppliers, delivery, advertising, rent, payroll, taxes, debt and other business expenses.

Show restrictions on cash use and the agreed reserve separately. A projected marketplace receipt remains an expectation until the money actually arrives.

Break purchases down by payment dates

Record the batch price and dates for advances, final settlement, delivery and other related payments. Staged and single payments create different pressure on cash.

Compare these dates with expected marketplace receipts and other obligations. Daily or weekly forecasts often help operational decisions while retaining individual transaction detail.

Compare several scenarios

Use agreed assumptions for sales, payouts, expenses and timing in the base case. Then test later receipts or sales below expectations.

Compare purchase volume, payment dates and terms agreed with the supplier. Change assumptions explicitly so it is clear which condition creates the shortfall and what needs discussion.

Find the shortfall date, not just the month-end total

A positive month-end balance does not rule out a mid-period shortage. For each date, calculate from the opening balance, expected receipts and planned payments.

If forecast cash falls below the agreed reserve, review the plan. Options may concern payment timing, purchase volume or financing. Check counterparty agreements and financing terms separately.

Replace forecasts with actuals

After receipts and payments, update the forecast using actual data. Explain whether variances arose from sales volume, payout timing, expenses or an initial assumption.

Purchasing planning then becomes part of regular financial support. The owner has a reasoned basis for decisions and understands their dependencies.

Worked example

Illustrative example, RUB thousands. Amounts are hypothetical and explain the method, not client results.

Cash balances by date
Date and transactionOption A: full payment on ThursdayOption B: payment in two stages
Monday: opening cash200200
Wednesday: obligations of 100100100
Thursday: supplier payment of 600 or 100-5000
Friday: receipt of 500; option B also pays the remaining 50000

Both options end with zero cash. Option A creates a Thursday shortfall of 500; option B does not. Rescheduling or splitting payments requires agreed supplier terms.

Checklist

  • Confirm the opening cash balance.
  • List obligations by date.
  • Break purchases into payment stages.
  • Test delayed receipts and changes in sales.
  • Identify potential shortfall dates.
  • Update forecasts with actuals.

Discuss your needs

Where do we start?

Tell me which platforms you use, how many seller accounts you manage and what you want to resolve. We will clarify the available data and agree the format, deliverables and fee before work begins.

Alexey Borodulin. Registered as self-employed, working with clients in Russia. Terms are agreed before work begins.

Useful details for your enquiry

  • Wildberries, Ozon or both; number of seller accounts.
  • Which reports you already have and what remains unclear.
  • The task: profit, purchasing, cash or payments.

Before work starts, we agree deliverables, working arrangements and fees.