Skip to content
ProfitCalcTools

Monthly planning

Monthly Ecommerce Profit Is Not the Same as Cash Available

Reconcile order contribution with subscriptions, inventory purchases and held payouts in a complete monthly example.

By ProfitCalcTools · Content revised · Editorial standards

$2,925Illustrative monthly profit before unentered costs

Can a profitable month still run short of cash?

Yes, in a simple inventory-and-payout scenario. Profit compares revenue with the costs assigned to the sales made. Cash availability depends on payment timing. Buying inventory for future orders uses cash now without making all of that inventory a current-month cost of goods sold.

This is a planning reconciliation, not a formal accounting or tax statement. It assumes no tax, debt, depreciation, supplier credit or unpaid operating bills. The purpose is to stop a positive calculator result being mistaken for cash available to withdraw.

Reconcile one month of orders

Assume 300 orders at $50 gross revenue each. Product cost is $18, delivery $6, packaging $1, processing $1.75 and acquisition $10 per order. Realized refund losses are $1.50 per original order. Fixed overhead is $600.

Monthly line Calculation Amount
Gross revenue 300 × $50 $15,000
Goods sold 300 × $18 −$5,400
Delivery 300 × $6 −$1,800
Packaging 300 × $1 −$300
Processing 300 × $1.75 −$525
Refund losses 300 × $1.50 −$450
Advertising 300 × $10 −$3,000
Fixed overhead Monthly assumption −$600
Modeled profit Revenue less stated costs $2,925

Margin is 19.5% of gross revenue. Refund losses are realized here, not an additional future reserve. Do not deduct them again from revenue already net of those refunds.

Find the break-even order count

Contribution before fixed overhead is $11.75: $50 minus $38.25 variable costs. Fixed-cost break-even is $600 ÷ $11.75 = 51.06 orders. At least 52 whole orders cover the $600 in this scenario.

Orders Profit after $600 fixed costs
0 −$600.00
50 −$12.50
100 $575.00
300 $2,925.00
500 $5,275.00

All rows assume identical contribution per order. At zero orders, per-order overhead and revenue margin are undefined, but the monthly expense remains. Non-positive contribution cannot recover positive fixed costs by selling more units.

Now reconcile the cash movement

The business buys 1,000 units at $18, paying $18,000, but sells only 300. The unsold 700 units add $12,600 inventory at cost. The profit model included only $5,400 goods sold, while cash also funded the remaining stock.

Assume $1,200 customer proceeds remain in a payout balance at month end. All other modeled revenue and costs have been collected or paid, with no further timing differences.

Reconciliation Cash effect
Modeled profit +$2,925
Increase in inventory at cost −$12,600
Increase in undisbursed proceeds −$1,200
Net cash movement −$10,875
Starting cash $12,000
Ending cash $1,125

The same business has positive modeled profit and negative cash movement. The stock and held payout are not necessarily lost, but neither is available cash at that moment.

Test acquisition and overhead separately

If CPA rises from $10 to $14 on the same 300 orders, the additional $1,200 ad cost lowers profit to $1,725. Contribution becomes $7.75, and break-even increases to 78 whole orders. Changing only the sales forecast can conceal this pressure.

An annual subscription creates another timing difference. A hypothetical $480 payment allocated over twelve months costs $40 in a monthly planning model but consumes $480 cash when paid. Keep an allocation view for profitability and a due-date view for cash.

Make the model work for a catalog

Sum each product's contribution across quantities sold and subtract shared fixed costs once. An unweighted average margin is misleading when low-margin products produce most sales. Returned stock must be valued consistently: restoring an item to inventory is not another customer payment.

Record the evidence behind each input—supplier invoice, fulfillment bill, processing statement or advertising report. Use consistent periods and currencies. Separate a proposed budget increase from historical costs instead of mixing them into one supposedly historical result.

Use Monthly Profit, Landed Cost and the returns guide together. Before ordering stock or withdrawing funds, reconcile the bank balance and upcoming payments separately. Tax, financing, accounting recognition and owner compensation can require additional treatment. The lesson is that profitability and payment timing both need to work.

Try different assumptions

Defaults reproduce the hypothetical example. Edit the inputs and recalculate. This is a separate teaching scenario, not a live platform quote.

Open related calculator →

Replace the example assumptions with your own costs. Check field definitions before comparing results.

The worked examples are hypothetical. Platform links support the definitions or cost categories identified in the text, not every example amount. Results depend on the inputs and exclusions stated.