Purchase order cash flow calculator

Enter the order value, deposit, production and shipping times and your sales pace. The calculator shows how much money goes out, when it goes out and on which day the order pays for itself.

Order details

Order and payments
Excluding VAT.
Units in the order.
Paid on order day.
Freight, duty, import VAT, clearance.
Timing
The balance is paid when production ends.
From factory to warehouse.
Sales and payouts
Price minus fees and customer shipping.
Average units sold per day.
Days until the gateway or marketplace pays out.
Jump to result

Order cash flow

Enter order value, units and net income per unit.

How do you calculate the cash a purchase order needs?

Peak cash = order value + arrival costs. Payback day = arrival day + payout delay + peak cash ÷ daily inflow.

A €10,000 order for 1,000 units with a 30% deposit, 30 days of production and 35 days of shipping. You pay €3,000 on order day, €7,000 on day 30 and €2,000 of arrival costs on day 65: peak cash is €12,000. Selling 10 units a day with €20 net per unit and a 7-day payout delay, you collect €200 a day from day 72. The order pays back on day 132 and, once the stock is sold, leaves a positive balance of €8,000.

When you buy from a supplier, especially outside the EU, you pay long before you sell: the deposit on order, the balance at the end of production, then freight, duty and import VAT when the goods arrive. Sales start only after arrival, and payment gateways or marketplaces pay out with a few days' delay. The chart shows this gap day by day, from order day until the last unit is sold and paid out.

Peak cash is the amount you need available, in the bank or on a credit line, before you collect the first euro. If the time from order to arrival is longer than the days needed to sell the stock, the reorder must be paid before this order has paid back, and the cash needs add up. In that case consider a smaller deposit, split deliveries or financing the order. The calculation assumes steady sales and does not include the cost of money.

Questions about cash for a purchase order

What goes into arrival costs?

Everything you pay when the goods arrive: freight if not already paid, duty, import VAT, customs clearance and delivery to your warehouse. Include VAT even if you reclaim it, because you pay it upfront and recover it only with your periodic VAT return.

What is net income per unit?

It is the cash you keep for each unit sold: selling price minus payment or marketplace fees and shipping to the customer. Do not subtract the product cost, which is already in the order value.

Why is the final balance negative?

The net income from all units does not cover what you paid the supplier and on arrival. The order does not pay for itself: review price, arrival costs or order value with the margin calculator.

How do I account for returns?

Reduce daily sales or net income per unit in proportion to the return rate you see on the product.

Does the calculator include advertising?

Not directly. If you pay for ads to sell this stock, subtract the average ad spend per unit sold from net income per unit.

What does the reorder warning mean?

If production and shipping take longer than the days needed to sell the stock, you must reorder before this order has paid back to avoid running out. You will have two orders to finance at the same time.

More ecommerce calculators

Guide to ecommerce product profitability