13-Week Cash Flow Template
The exact Excel template we use on $1M–$25M e-commerce engagements. Direct method, weekly grid, colour-coded inputs, sample numbers ready to overwrite.
Get the template
Drop your work email — we'll send the .xlsx and a short Loom walking through the model. Prefer us to plug in your Shopify, Amazon and bank data and run the first forecast for you? Book a diagnostic call and we'll do it as part of the free session.
- Opening & ending cash by week
- AR collections (Shopify Payouts, Amazon disbursements, wholesale)
- Ad spend, COGS, payroll, opex, AP
- Tax and inventory deposits
- Colour conventions (blue = input, black = formula)
- Sample numbers ready to overwrite
Who it's for
- DTC and marketplace operators between $500K and $25M revenue.
- Founders who need weekly cash visibility but don't have a CFO yet.
- Works for Shopify, Amazon FBA, wholesale and hybrid models.
How to use it (3 steps)
- 1. Replace the blue-cell sample numbers with your last 4 weeks of actuals and your best estimate of the next 13 weeks.
- 2. Update the cadence assumptions: Shopify payout lag, Amazon disbursement schedule, supplier terms.
- 3. Re-forecast every Monday. Roll the window forward and compare actual vs forecast on the variance row.
Most operators run cash forecasts in a P&L tab or — worse — off the bank balance. Both miss the 4–8 week danger window. This direct-method weekly model is the format institutional lenders and PE buyers expect to see.
Want us to run the first forecast for you?
A free 30-minute call with a senior CFO. No sales pitch – just a clear read on where your money is and what to do next.
30 min · No pitch · A real CFO, not a chatbot