Your best sales month can trigger your worst cash crisis. A Shopify store doing $120,000 in December can still miss its January 5th supplier payment. The problem isn’t profitability.
It’s the days between a customer’s order and the settlement in your bank account.
Most financial projection guides start with the income statement. They treat revenue as cash-in-hand. They ignore the settlement lag that breaks e-commerce businesses during high-growth months.
This post replaces that approach. It gives you a cash-timing-first model built from real processor data.
Why do income-statement-first projections fail for e-commerce businesses?
Income statements record revenue when orders happen—not when cash lands. The settlement gap across payment processors runs 5 to 14 days. Supplier invoices don’t wait for those settlements to clear.
Your spreadsheet says profitable month. Your checking account hits overdraft. Most founders discover this during their highest-revenue month.
Most founders build projections by starting with monthly revenue targets from Shopify’s dashboard. They subtract estimated expenses. They celebrate the positive bottom line.
That bottom line assumes every dollar becomes available cash within the same calendar month. For a store using multiple payment processors, that assumption fails during peak season.
An apparel brand owner discovered this through a near-miss. Her store processed $62,000 during a Memorial Day sale. She ordered $31,000 in summer inventory the next Monday.
She expected the sale revenue to cover the supplier bill by Wednesday. Shopify Payments settled $14,000 on Thursday. Another $19,000 cleared the following Tuesday.
PayPal held the rest in reserve until late June. Her supplier charged a 3% late fee on the $12,000 shortfall. That single timing miss cost $360 and three days of stockouts on her best-selling dress.
The income statement didn’t predict this. It can’t. It measures accounting profitability over fixed periods.
E-commerce cash flow operates on a different clock. Every processor runs its own settlement rhythm.
Shopify Payments settles 2-5 business days after order date. PayPal holds funds 7-21 days depending on account history. Stripe settles on a rolling 2-day delay but imposes reserves for accounts above a 0.75% chargeback ratio.
Amazon Pay settles net-14 for most new sellers. Selling across four channels means cash arrives in four different cadences. A single-date revenue projection captures none of this.
The fix starts with one inversion. Build projections from settlement dates first. Map your cash-in cadence before you touch a revenue target.
What’s the actual cash timing gap between a sale and usable money?
The gap varies by processor and risk profile. A store using Shopify Payments and PayPal sees a blended average of 6 to 9 calendar days. Return-rate reversals and reserve holds often push the real number to 10 or 14 days.
Three factors determine your actual settlement speed.
First, the processor’s standard schedule. Shopify Payments offers next-business-day payout for eligible U.S. accounts. An order placed Friday afternoon settles Tuesday morning—four calendar days later.
Second, your chargeback and dispute history. Processors classify accounts by risk tier. A dispute rate above 1% can trigger rolling reserves that hold 5-10% of processed volume for 90 days.
Third, your sales channel mix. Amazon’s disbursement cycle runs every 14 days by default. Selling on Amazon plus Shopify means Amazon revenue arrives in two-week chunks. Shopify revenue arrives daily or weekly. The combined cash picture rarely matches any single channel’s rhythm.
A $500K kitchenware brand I analyzed operated across three channels. Shopify delivered 65% of their sales. Amazon contributed 25%.
Wholesale through Faire brought the remaining 10%. Their blended settlement delay averaged 8.2 days. That average hid a dangerous pattern.
Shopify settled in 3.7 days. Amazon settled every 14 days in lump sums. Faire paid net-30.
During September, 37% of total revenue landed 27 days after the orders. Their largest recurring expense—a $14,000 container shipment—hit on September 18th.
Available cash on September 17th was $6,200. Booked September revenue sat at $53,000. None of it was accessible.
The lesson isn’t to avoid Amazon or Faire. Map your actual settlement calendar before you model anything else.
Open your last 90 days of processor statements. Record every settlement date against every order batch. Calculate the average and worst-case gap for each channel.
These numbers become the foundation of your projections. Without them, you’re guessing. Guessing creates overdrafts.
How do I build a 13-week cash rollforward that catches crunches before they happen?
Start with settlement-timed cash inflows, not revenue. List every recurring payment obligation by its actual due date. Plot both on a week-by-week timeline for 13 weeks.
The first week where the running balance hits zero or below is your real risk window. Fix that week before touching any other part of your projections.
A cash rollforward is simpler than a full cash flow statement. It uses four columns: week ending date, cash in, cash out, running balance.
Cash in comes from your processor settlement schedule. Cash out includes supplier invoices by due date, payroll, ad platform billing, warehouse fees, subscriptions, and tax deadlines. Nothing gets averaged into monthly buckets. Every line item sits on its exact date.
Here is how to build it.
Export your last 90 days of transactions from every payment processor. Group them by settlement date, not order date. This reveals your actual cash-in cadence.
Next, open your accounts payable ledger. List every recurring payment with its contractual due date. Supplier invoices. Amazon FBA fees. Facebook Ads billing. Shopify subscriptions. Klaviyo. ShipStation. 3PL warehouse fees. Sales tax remittance dates. One-time expenses like container shipments go on their known dates.
Now open a blank sheet. Create 13 columns for the next 13 weeks. Row 1 shows projected cash-in by week based on your sales forecast multiplied by processor-specific settlement delays.
Rows 2 onward show each expense line by its actual due date. The bottom row tracks the running balance starting from your current bank balance. The first week where that balance goes negative is where you intervene.
A $300K Shopify pet supply store ran this exercise last October. Their forecast revealed negative cash in the second week of November. That was eight days before Black Friday.
The culprit: a $22,000 inventory payment due November 4th. At the same time, $28,000 of October revenue sat in PayPal’s settlement queue.
They spotted the problem on October 18th. They called the supplier. They negotiated a 14-day extension on the November payment.
In exchange, they offered a 3% early-payment incentive on their January order. The cash crunch disappeared. Total cost: zero.
What it saved: Black Friday inventory that would have arrived late if the supplier paused shipments.
How do I account for return rates and chargebacks in cash projections?
Returns create negative cash events that arrive 7-30 days after the original sale. A 25% return rate on apparel means one-quarter of your booked revenue reverses weeks after you allocated it. Model returns by product category as a cash-out line.
Treat them as a timing risk, not just a revenue deduction.
Return rates vary dramatically by category. Apparel runs 20-30%. Electronics run 5-10%. Consumables like supplements or coffee run 2-5%. Home goods sit around 8-15%.
These aren’t statistical noise. They are cash reversals that hit your settlement balance after the original funds cleared.
If Shopify Payments settled $10,000 for a batch of orders, you might see $2,500 in reversals trickle in across weeks three through six. Your projection needs a reserve line for this drag.
A women’s apparel brand running $80K per month learned this the hard way. They launched a spring collection in March. The collection sold $43,000 in the first two weeks.
They used the Shopify dashboard revenue number to authorize $18,000 in summer pre-season inventory. Returns on the spring collection started hitting in week three.
By week six, $11,800 had reversed. Their cash balance dipped $4,200 below zero. The summer inventory payment cleared before the return reversal pattern appeared on their outdated projection model.
The fix is straightforward. Pull your actual return rate by product category from the last 12 months.
Create a separate line in your cash rollforward labeled "Expected Return Reversals." Schedule this negative cash entry 7-14 days after your peak shipping weeks.
Customers receive products in 3-5 days. Your return window is 30 days. Model the reversal peak at 14-21 days post-shipment.
The estimate won’t be perfect. It will be closer than zero.
How do I account for seasonality in e-commerce financial forecasts?
Stop using flat monthly growth rates. Seasonality doesn’t hit all categories the same way. A supplement brand sees a January spike from resolution buyers.
A swimwear brand sees December as a dead zone. Map your own last 24 months of revenue by week. Don’t apply a seasonal multiplier until you do this.
Most projection templates apply a generic "holiday lift" of 20-30% to Q4. That approach misses category-specific patterns entirely.
A toy brand might do 45% of annual revenue in November and December. A gardening brand might peak in April and May. A back-to-school supplies brand sees a tight six-week window in July and August.
Applying a flat seasonal multiplier to the wrong category produces projections that look reasonable on paper and fail in practice.
Pull your Shopify revenue report for the last 24 months. Export it by week, not by month. Calculate what percentage of annual revenue each week represents.
Apply those actual percentages to your forward forecast. Week 47 historically delivers 8% of your annual revenue. Model 8% of your projected annual figure for that week.
The pattern already bakes in your specific seasonal dynamics. You don’t need a generic multiplier. You need your own data plotted honestly.
A $400K swimwear brand ran this same exercise. Their accountant assumed December was the cash low point. The data said late September.
By September, summer inventory had sold through. Holiday prep inventory hadn’t arrived yet. Their processor settlements had thinned to a trickle.
The September 25th payroll always felt tight. They never modeled the gap. Their quarterly projections lumped September into Q3. June and July’s strong numbers masked the problem. Weekly cash rollforwards revealed the pattern instantly.
How often should I update financial projections when payment terms keep shifting?
Update the cash rollforward every week. Update the full projection monthly. A projection from three months ago is already wrong somewhere.
Processor terms change. Supplier relationships evolve. Chargeback rules shift overnight.
Weekly updates take 30 minutes once the sheet is built. Pull actual settlements from the past week. Compare them against what you projected.
Adjust the forward weeks based on any discrepancies. If Shopify Payments suddenly holds an extra day, you catch it within seven days. Chargeback ratio shifts cause this without warning.
Without weekly updates, you discover the delay during a cash crunch. Your options are fewer and more expensive by then.
Monthly updates go deeper. Recalculate processor-specific settlement averages. Review supplier payment terms for any changes.
Update return-rate assumptions using the most recent 90 days of data. Re-forecast sales using actual conversion rates and ad spend effectiveness curves.
Most e-commerce operators update projections quarterly because their accountant recommends it. Accountants think in tax periods. Cash crunches don’t wait for quarter-end.
A $1.2M Shopify electronics brand updates their cash rollforward every Monday morning. Their operations manager spends 25 minutes pulling processor statements and updating the 13-week sheet.
In the past year, that weekly habit caught four potential negative-cash weeks before they happened. Three resolved by shifting supplier payment dates by 5-7 days.
One required a short-term line-of-credit draw that cost $180 in interest. The alternative: missing a supplier payment and losing Q4 inventory access. Estimated cost: $40,000 in lost sales.
What results should I expect after switching to cash-timing-first projections?
You stop checking Shopify’s dashboard for cash decisions within two weeks. You catch crunches 4-8 weeks before they hit instead of 2 days before. You negotiate supplier terms from data instead of panic.
You time inventory restocks around settlement peaks instead of crossing your fingers.
Your first 13-week rollforward takes about two hours to build. The ongoing weekly update takes 20-30 minutes.
Within three weeks, you know your actual settlement cadence across every channel. Within two months, you have a documented pattern of when cash arrives and when it leaves. This data changes how you evaluate every spending decision.
The businesses I work with report one surprising outcome. They discover they need less working capital than they thought. They hoarded cash because they feared running out.
The rollforward replaces fear with visibility. Visibility lets you deploy cash into inventory, into ads, into growth. You fund the activities that actually move the business forward.
You know exactly when you need it back because the sheet shows you.
The income statement tells you if the business model works. The cash rollforward tells you if you can pay your supplier next Tuesday.
For a business under $10M, processor delays and supplier terms pull in opposite directions. The rollforward matters first.
Build it this week. Update it every Monday. Trust it more than the dashboard number that got you into trouble in the first place.
