Cash flow & advisory

Cash flow forecasting for ecommerce businesses

Build a rolling cash forecast around inventory payments, channel payouts and customer collections, then compare actual results with your assumptions.

Sema Koch, CPA

Published

2026-09-30

Last updated

October 23, 2026

Author credentials and experience

Published on Beamarc: September 30, 2026.

You had a great Q4. Revenue up. Gross margin held. The P&L shows profit.

A profitable quarter can still be followed by a cash shortfall.

Inventory deposits, freight, advertising and payroll can require payment before the related customer cash arrives.

This is the ecommerce cash trap: cash outflows (inventory, marketing, payroll) and cash inflows (settlements, collections) rarely line up with when revenue and expenses hit the P&L. If you manage to accrual profit without a cash plan, you can be profitable and still run out of money.

Cash flow forecasting doesn’t “fix” the reality. It makes it visible early enough to act.

Before you forecast: fix the inputs

If your books don’t tie to cash, your forecast won’t either. Don’t build a forecast on top of unreconciled clearing accounts and unexplained balances.

Minimum data hygiene (non-negotiable)

Cash All bank accounts reconciled. Include wallets (PayPal) if you use them. Know what “cash” actually is today.
Clearing Settlement channels reconciled. Shopify/Amazon/Stripe/PayPal clearing ties to pending payouts/settlements and documented holds.
AR/AP AR aging and AP schedule are current. Collections and vendor payments are timing items. Your forecast is timing.
Commitments Inventory POs + supplier terms are mapped. Deposits, milestones, freight, duties: when do you actually pay?
Taxes Sales tax and payroll tax calendars are known. These are predictable cash hits. Treat them that way.

Reconcile the starting balances and identify gaps in source records before relying on the forecast.

Why ecommerce cash flow is different

Ecommerce has structural cash timing issues that don’t show up in a normal P&L review:

Inventory lead time

You may pay suppliers weeks or months before the related customer cash arrives. Overseas manufacturing can require deposits long before goods arrive. That cash may be tied up in supplier prepayments or inventory, depending on the contract and shipping terms.

Settlement lag + holds

A sale today becomes cash later. Timing varies by processor settings, weekends/holidays, disputes/chargebacks, reserves, and risk holds. The P&L sees revenue. The bank account waits.

Seasonality mismatch

Seasonal inventory and marketing can require payment well before expected sales. Model the effect of a weaker or later peak on cash.

These aren’t problems you “solve.” They’re realities you manage. A forecast is how you manage them on purpose.

Cash flow statement vs cash flow forecast

Different tools. Different jobs.

Time orientation. Cash Flow Statement: Historical (what happened); Cash Flow Forecast: Forward-looking (what’s expected)
Purpose. Cash Flow Statement: External reporting in a full GAAP set for most entities; Cash Flow Forecast: Operational planning and decision support
Structure. Cash Flow Statement: Operating / Investing / Financing activities; Cash Flow Forecast: Receipts / disbursements by timing and category
Precision. Cash Flow Statement: Historical cash movement, reconciled to the accounting records; Cash Flow Forecast: Estimated (assumptions drive results)
Update frequency. Cash Flow Statement: Monthly/quarterly with financials; Cash Flow Forecast: Weekly (ideal) or at least monthly

A cash flow statement explains historical cash movement. A forecast estimates future receipts and payments so management can assess possible shortfalls.

The 13-week cash flow forecast

A rolling 13-week forecast is a common planning format. It is short enough for useful timing detail and can be extended with a less detailed monthly view.

Why weekly beats monthly

Cash crises happen mid-month. Monthly buckets hide the cliff.
Inventory payments are lumpy. Deposits and balances don’t respect month-end.
Processors don’t pay monthly. Settlements hit when they hit.

Basic structure

Beginning cash (reconciled cash available at the start of the week, with outstanding payments and any restrictions identified)
Inflows (settlements, collections, financing, other receipts)
Outflows (inventory, payroll, marketing, rent, debt, taxes, etc.)

Beginning cash + inflows − outflows = ending cash. Ending cash becomes next week’s beginning cash. Reconcile the starting balance and reflect outstanding payments consistently so they are not deducted twice. Funds still with a processor belong in expected receipts, not both opening bank cash and future receipts.

If receipts are forecast net of fees, refunds, advertising or other deductions, do not include those same deductions again as separate cash outflows. Keep amounts billed or paid separately in the payment schedule. Weekly totals can hide an earlier shortfall within the week; use daily dates where payment timing is tight.

Beginning Cash. Wk 1: $125,000; Wk 2: $118,500; Wk 3: $142,200; ...; Wk 13: $89,400
Cash Inflows.
Shopify settlements. Wk 1: $52,000; Wk 2: $48,000; Wk 3: $51,000; ...; Wk 13: $45,000
Amazon settlements. Wk 1: $0; Wk 2: $67,000; Wk 3: $0; ...; Wk 13: $58,000
Wholesale collections. Wk 1: $12,000; Wk 2: $8,000; Wk 3: $15,000; ...; Wk 13: $10,000
Total Inflows. Wk 1: $64,000; Wk 2: $123,000; Wk 3: $66,000; ...; Wk 13: $113,000
Cash Outflows.
Inventory payments. Wk 1: ($45,000); Wk 2: ($60,000); Wk 3: ($35,000); ...; Wk 13: ($80,000)
Payroll. Wk 1: ($18,000); Wk 2: $0; Wk 3: ($18,000); ...; Wk 13: ($18,000)
Marketing/advertising. Wk 1: ($5,500); Wk 2: ($5,500); Wk 3: ($5,500); ...; Wk 13: ($7,000)
Rent + utilities. Wk 1: ($2,000); Wk 2: $0; Wk 3: $0; ...; Wk 13: $0
Other operating. Wk 1: $0; Wk 2: ($33,800); Wk 3: ($2,500); ...; Wk 13: ($4,200)
Total Outflows. Wk 1: ($70,500); Wk 2: ($99,300); Wk 3: ($61,000); ...; Wk 13: ($109,200)
Ending Cash. Wk 1: $118,500; Wk 2: $142,200; Wk 3: $147,200; ...; Wk 13: $93,200

Illustrative extract; weeks 4–12 are omitted. A working forecast needs every week and all applicable receipts and payments.

Forecasting cash inflows

Forecast cash receipts by their expected bank dates. For sales channels that settle net, allow for fees, refunds and other deductions withheld before payment. Include other receipts, such as borrowing, owner contributions or proceeds from selling equipment, where applicable.

Settlement channels (Shopify, Amazon, Stripe, PayPal, marketplaces)

Settlement behavior varies. That’s normal. Your forecast should reflect your actual history, not a generic rule.

Start with a sales forecast by channel. Weekly is best for 13-week models.
Apply your observed cash lag. Shift expected receipts into the week they usually arrive.
Forecast net-to-bank, not gross sales. Use a “net realization” assumption (after fees/refunds/chargebacks) and refine it as you get actuals.
Track holds and reserves explicitly. Use supported release dates and downside assumptions. A hold can delay cash availability; assess recoverability separately.

Wholesale collections (AR)

Wholesale inflows should come from your AR aging, not wishful thinking:

Current invoices: forecast based on terms and your actual collection pattern.
Past-due invoices: forecast with haircut/probability. Old AR is not cash. It’s a risk item.
Deductions/chargebacks: expect them if your channel has them; they reduce cash receipts.

Financing inflows

Include financing only when it’s real:

Executed credit line with known availability
Signed loan docs with a draw schedule
Committed equity with a close date

If it’s “maybe,” it belongs in a scenario, not the base case forecast.

Forecasting cash outflows

Build payment dates from invoices, contracts, purchase plans and payroll schedules. Estimate uncertain amounts explicitly and include payments outside day-to-day operating expenses.

Inventory payments (the big one)

Build inventory payments from the purchase or production plan and supplier terms. A cost-of-goods-sold forecast can help estimate purchasing needs, but it is not a payment schedule: allow for changes in stock, opening payables, deposits and due dates.

POs + supplier terms: deposits, milestones, balance timing
Freight/duties: when they actually get invoiced and paid
Seasonal buys: forward buys that hit cash now to support sales later

Payroll (and payroll taxes)

Pay dates + net cash leaving the bank
Employer payroll taxes, withheld employee taxes and benefit remittances, each scheduled once alongside net pay
Tax deposit cadence (don’t “forget” this, ever)

Operating spend

Marketing: know your platform billing rhythm (it’s often weekly/daily behavior in disguise)
3PL/fulfillment: usually billed in arrears; forecast off volume + invoices
Software and subscriptions: annual renewals are silent killers if you don’t calendar them
Insurance: monthly vs annual: track the actual payment dates

Debt and financing costs

Scheduled principal/interest payments
Daily/weekly auto-withdrawals (revenue-based financing, MCA products)
Fees (lender fees, wire fees, covenant-related costs)

Equipment and owner payments

Schedule cash payments for equipment and other long-term assets, along with planned owner draws or distributions. These payments can reduce cash without being current operating expenses. Depreciation and amortization are noncash expenses; do not deduct them as payments in a receipts-and-disbursements forecast.

Plan for tax payments

Set aside enough cash for tax obligations and schedule the payments. A management allocation is not automatically restricted cash for financial reporting; that classification depends on the applicable restrictions and reporting framework.

Include tax payment dates and amounts in the forecast. Cash set aside for tax obligations should not be treated as freely available for new commitments.

Sales tax remittances: driven by your filing calendar (often multi-state)
Estimated income taxes: quarterly payments (entity-dependent)

Weekly forecast update process

Refresh the forecast regularly so it reflects actual receipts, payments and changes in assumptions.

Weekly update (simple, repeatable)

1 Replace Week 1 with actuals. Actual beginning cash. Actual receipts. Actual disbursements.
2 Measure variance. Biggest misses = where your assumptions are wrong (timing, net realization, spend discipline).
3 Update known items. New POs, new invoices, changed pay dates, new collections info.
4 Roll forward. Drop the completed week. Add a new Week 13.
5 Check the minimum cash line. If any week dips below your floor, take action now.

The time required for weekly updates depends on the quality of the records, the number of accounts and channels, and the decisions being modeled.

Minimum cash: pick a floor and enforce it

Set a minimum cash target based on upcoming obligations, volatility, seasonality and access to funding.

Choose a cash reserve based on obligations and downside scenarios. Any example expressed as weeks of spending is a planning assumption, not a universal requirement.
Largest obligation buffer: enough to fund your biggest predictable payment (often an inventory balance due)
Tax buffer: sales tax/payroll tax held should be ring-fenced operationally (separate account or hard floor)

The “right” floor depends on volatility, seasonality, and credit access. The point is having one and acting before you breach it.

Scenario planning (where the value lives)

A single forecast is one set of assumptions. Scenarios force you to look at reality.

Base case: current run-rate and realistic assumptions
Downside case: sales down 15–20%, collections slower, costs up
Upside case: sales up (and the inventory + ad spend required to support it)

Downside is the control case. If you hit the floor in Week 8 under downside, you have time to pull levers now.

Raising capital or talking to lenders? They’ll ask about runway and working capital. A forecast with scenarios shows you understand cash mechanics. See monthly close and reporting.

Working capital levers

When the forecast shows a crunch coming, you have three buckets of levers: speed up cash in, slow cash out, or finance the gap.

Accelerate inflows

Tighten wholesale terms where you can
Active AR collections (don’t “wait and see”)
Reduce refund leakage and chargeback exposure (cash impact is real)
Explore faster payout options where available (often fee-based and eligibility-based)

Slow down outflows

Negotiate supplier terms (deposit structure, timing, credit)
Resequence inventory buys (smaller buys, better reorder points)
Defer discretionary spend
Renegotiate vendor payment schedules early (before you miss)

Finance the gap

Line of credit (arrange before you’re desperate)
Inventory financing
AR financing/factoring (know the effective cost)
Revenue-based financing (understand cash drag from remittances)

Sharing a forecast with an outside party

If you share a forecast with a lender, investor, or buyer, be clear:

Identify who prepared it. Management should understand and take responsibility for the assumptions, including when an adviser helps build the forecast.
Document key assumptions. Sales growth, settlement lags, net realization, inventory payment terms, ad spend, hiring plans.
Label management forecasts clearly and identify their assumptions, preparation date and intended use. An ordinary advisory forecast does not provide audit or review assurance.

Common forecasting mistakes

Mistake 1: Using the P&L as a proxy for cash

Accrual profit is not cash timing. Build a receipts/disbursements model. Then reconcile it to reality weekly.

Mistake 2: Ignoring inventory timing

The cost of inventory sold becomes COGS when the related revenue is recognized. Supplier payments follow their own dates. Growth can increase the cash needed for inventory and receivables, depending on customer and supplier terms.

Mistake 3: False precision beyond 13 weeks

Use detailed weekly timing where the information supports it. Beyond the operational window, a monthly forecast and scenarios can better communicate uncertainty.

Mistake 4: Not updating

A forecast built once becomes wrong fast. Update it. Measure variance. Fix assumptions.

Mistake 5: Optimism disguised as planning

Use supported, realistic assumptions in the base case. Put stronger results in the upside scenario and test weaker sales, slower collections and higher costs in the downside case.

If opening cash, clearing balances or inventory commitments are uncertain, resolve or clearly disclose those gaps before using the forecast to make commitments.

Completion checks

13 Weeks

Rolling forecast updated weekly with actuals and revised assumptions

By Source

Inflows mapped by channel with settlement timing and net-to-bank behavior

Scenarios

Base + downside + upside cases with stress-tested drivers

Actionable

Cash floor defined; levers identified before you hit it

A maintained forecast helps you identify pressure points early and choose a response. Actual cash results can still differ from the assumptions.

FAQ

Why can a profitable ecommerce business run out of cash?

Profit is measured over a period; cash is what’s in the bank on a specific day. Inventory and marketing are often paid before sales settle, and settlements/collections have timing gaps. A business can show profit while burning cash if working capital timing doesn’t align.

What's the difference between a cash flow forecast and a cash flow statement?

A cash flow statement is historical and part of external reporting for many GAAP financial statement sets. A cash flow forecast is forward-looking and used for planning. The statement tells you what happened; the forecast helps you plan.

How far out should an ecommerce business forecast cash flow?

A rolling 13-week forecast is a common starting point. Extend the horizon to cover major commitments and seasonal needs, and refresh assumptions regularly.

How do I forecast cash inflows when settlement timing varies?

Use your actual settlement history by channel and forecast net-to-bank receipts. Timing varies by processor settings, holds/reserves, weekends/holidays, and chargebacks. Shift receipts into the weeks they typically hit cash.

How should inventory purchases enter the cash forecast?

Schedule supplier deposits, balances, freight and duties when payment is expected. Schedule customer receipts separately: selling inventory does not necessarily mean collecting cash that day.

How do I handle seasonality in a cash flow forecast?

Use historical seasonality patterns, adjust for growth, and stress-test downside scenarios (for example, peak sales below forecast). Remember: inventory and marketing cash hits often occur months before the seasonal peak.

Cash forecasting with Beamarc

Beamarc helps CPG and eCommerce owners plan the cash committed to inventory. We can build a cash forecast from your supplier terms, purchase plans, payroll dates and expected Shopify, Amazon and wholesale receipts, using the records available.

Your agreed scope can include a base case and a scenario with slower sales or later collections. The forecast helps identify when cash is needed and which assumptions could change the next order decision.

You can keep your existing bookkeeper involved. Responsibilities, forecast periods, update frequency and fees are agreed in writing.

Explore Beamarc’s CPG and eCommerce accounting services or request a consultation.