The 13-week cash flow model is the single most useful finance tool a D2C founder will ever build. It’s not a budget, not a P&L, not a fundraising model. It’s the early-warning system that surfaces cash problems 6 to 10 weeks before they hit. This guide explains exactly how to build one in a weekend, the Monday refresh discipline that makes it work, and what to do when a week shows negative.
- Why the 13-Week Cash Flow Is the Most Important Finance Tool
- Why Monthly Cash Visibility Isn’t Enough
- The Structure of a Working 13-Week Cash Flow
- How to Build Yours in a Weekend
- The Monday Refresh Discipline
- What to Do When a Week Goes Negative
- Common Mistakes That Break the Model
- Frequently Asked Questions
Why the 13-Week Cash Flow Is the Most Important Finance Tool
D2C brands that run a 13-week cash flow almost never have cash crises. D2C brands that don’t have routine cash surprises every 6 to 9 months. The difference isn’t business quality, revenue growth, or team capability. It’s whether the team is looking at the right view of the business.
The 13-week cash flow is the right view. It shows you, with week-level granularity, every cash inflow and every cash outflow across the next quarter. It translates the P&L into cash timing. It surfaces the gap between when revenue is recognized and when it’s actually collected. It maps every supplier payment, every marketing commitment, every statutory obligation to the specific week it hits your bank.
The model’s value is entirely in what it shows you before it happens. A P&L tells you what happened. An annual budget tells you what you planned. The 13-week tells you what’s coming, in enough detail and far enough in advance that you can act. Six to ten weeks is typically enough time to accelerate receivables, renegotiate payables, adjust marketing pacing, or arrange working capital financing. One week is not enough time for any of those actions.
Why Monthly Cash Visibility Isn’t Enough
Most D2C founders track cash monthly. Monthly tracking feels sufficient until the first time a cash crisis arrives two weeks into a month that looked fine at the monthly view. Five structural reasons explain why monthly is not enough.
Meta Ads and Google Ads charge daily as campaigns run. A ₹5 lakh monthly marketing budget deploys ₹3 lakh in the first three weeks of the month. The revenue that marketing generates doesn’t begin settling until 2 to 14 days after orders are placed. A brand with a ₹5 lakh monthly marketing budget has already deployed ₹3 lakh before the month is half over, with settlement cash still in transit.
Amazon settles every 14 days. Flipkart settles every 7 to 15 days. Quick commerce platforms settle T+7 to T+15. When you’re growing rapidly, marketplace revenue is growing faster than settlement cash, which means receivables grow as a function of growth rate. A brand that grew marketplace revenue 30% in a month now has 30% more receivables outstanding than the prior month, even if settlement cycles haven’t changed.
Supplier payment terms are often structured as Net 30 from purchase order date or Net 15 from invoice. This means supplier payments cluster at the beginning and end of months, and around specific purchase order milestones. A month that looks balanced in aggregate can have two large supplier payments in the same week, creating a temporary cash trough that monthly reporting never sees.
GST is due on the 20th of each month. TDS is due on the 7th of the following month. Advance income tax is due quarterly (June, September, December, March). EPF and ESI are due monthly. Each of these is a specific, non-deferrable cash outflow on a specific calendar date. Monthly budgeting often treats these as evenly spread, but they arrive in clusters that can stress a week’s cash position.
Salaries are paid on the 1st of the month (or 28th to 31st of the prior month, depending on your payroll setup). This is non-negotiable. If cash is thin going into end of month, the salary payment is not movable. Monthly cash planning that doesn’t explicitly place salaries at the right week consistently underestimates the cash stress at month-end.
The Structure of a Working 13-Week Cash Flow
The model has four sections. Each maps to a row group in the spreadsheet, with columns for Week 1 through Week 13 and an additional column for actuals (updated each Monday).
Section 1: Cash on Hand
| Line | Notes |
|---|---|
| Starting Cash (Week 1) | Actual bank balance as of Monday morning. Updated from actuals each week. |
Section 2: Cash Inflows
Do not forecast revenue. Forecast settlements of revenue. They are different by 2 to 30 days depending on channel, and that timing difference is precisely what the model is designed to capture.
| Line | Notes |
|---|---|
| Own website (prepaid) | Settles T+2 to T+3 via payment gateway |
| Own website (COD collected) | Settles T+5 to T+10 depending on logistics partner |
| Amazon settlements | Every 14 days. Forecast against settlement calendar. |
| Flipkart settlements | Settlement cycle varies. Map to actual cycle. |
| Myntra settlements | Settlement cycle varies. Map to actual cycle. |
| Quick commerce settlements | T+7 to T+15 depending on platform |
| Offline retail collections | 30-60 days from invoice date |
| Refund recoveries | Often missed. Add if material to your category. |
| Capital infusion | Pending fundraising close or owner contribution |
| Other receipts | Catch-all for miscellaneous inflows |
| Total Inflows | Sum of all above lines for each week |
Section 3: Cash Outflows
| Line | Notes |
|---|---|
| Supplier payments (raw material) | By supplier, with actual payment terms mapped to specific weeks |
| Supplier payments (packaging) | By vendor, same approach |
| Marketing – Meta | Daily charges, smoothed to weekly total |
| Marketing – Google | Daily charges, smoothed to weekly total |
| Marketing – other paid | Daily charges, smoothed to weekly total |
| Marketing – influencer | Lumpy. Map to specific payment dates per agreement. |
| Marketing – brand and PR | Lumpy. Map to actual invoice due dates. |
| Salaries and contractor payments | Usually 1st and 15th of the month. Fixed to calendar. |
| 3PL and warehousing | Weekly or monthly depending on 3PL contract |
| Office rent | Monthly, specific date. Fixed. |
| Software subscriptions | Monthly or annual. Map each to actual renewal date. |
| GST payments | 20th of the month. Fixed statutory obligation. |
| TDS payments | 7th of the month for previous month’s TDS deducted |
| Advance income tax | Quarterly: June, September, December, March |
| Professional fees | Lumpy. Map to actual invoice dates. |
| Other operating | Catch-all. Review monthly for new items. |
| Total Outflows | Sum of all above lines for each week |
Section 4: Ending Cash Position
| Line | Each Week |
|---|---|
| Starting cash | From prior week ending cash (or actual for Week 1) |
| Plus: Total inflows | From Section 2 |
| Less: Total outflows | From Section 3 |
| Ending cash | Starting cash + inflows – outflows |
| Minimum threshold | Typically 1.5 to 2x weekly operating burn. Set and fix this number. |
| Buffer above threshold | Ending cash minus minimum threshold |
If “buffer above threshold” goes negative for any week in the 13-week horizon, that is the moment for action. Not when the week arrives. The moment it appears in the model.
How to Build Yours in a Weekend
The entire model can be built in 10 hours across a weekend. Here is the sequence.
- 1Hours 1-2: Pull Historical Data
Bank statement last 90 days. Marketplace settlement statements (Amazon, Flipkart, Myntra, quick commerce) last 90 days. Payment gateway statements last 90 days. Supplier payment history last 90 days. Marketing spend by platform last 90 days. Salary, rent, and recurring payment history. This historical data is the calibration set for your forecasts.
- 2Hours 3-4: Build the Inflows Section
For each channel, identify the settlement pattern from the historical data: frequency (daily, weekly, biweekly), days between transaction date and settlement date, and typical settlement amount relative to gross revenue. Project forward 13 weeks. Adjust for known growth trajectory or seasonality. Remember: forecast settlements, not revenue.
- 3Hours 5-7: Build the Outflows Section
List every supplier and vendor with their actual payment terms. Map marketing forecast by week (daily charges smoothed weekly; influencer and PR payments mapped to specific invoice dates). Map all statutory payments to their actual calendar dates (GST on the 20th, TDS on the 7th, advance tax in June, September, December, March). Add all one-time payments you know are coming in the next 13 weeks.
- 4Hours 8-9: Compute the Ending Balance Row
Week 1 starting cash equals current actual bank balance. Each subsequent week: ending cash equals starting cash plus total inflows minus total outflows. Next week’s starting cash equals current week’s ending cash. Set the minimum threshold row (1.5 to 2x weekly operating burn). Compute the buffer row.
- 5Hour 10: Sanity Check and Stress Test
Compare your Week 1 forecasts to what you know will actually happen this week. Investigate any large variances in the historical data (what caused that cash drop in week 8 of the last 90 days?). Run stress scenarios: marketing spend increases 30%, a major supplier demands 15-day terms instead of 30-day, an Amazon settlement slips by one week. Identify which weeks are closest to the minimum threshold and what the trigger point is.
The Monday Refresh Discipline
Building the model is the easy part. The discipline that makes it valuable is the Monday refresh: 45 minutes every Monday morning, every week, without exception. The seven-step sequence:
- Roll the model forward one week. Drop the Week 1 that just closed. Add a new Week 14 at the end with forward-projected figures.
- Update Week 1 starting cash to the actual bank balance as of Monday morning.
- Update Week 1 actual inflows received. Compare to forecast. Investigate any inflow that missed by more than 10%.
- Update Week 1 actual outflows paid. Compare to forecast. Investigate any outflow that exceeded forecast by more than 10%.
- Adjust forecasts for Weeks 2 through 13 based on what changed in Week 1 actuals and any new information (revised growth plans, new supplier terms, pending capital events).
- Look at the ending balance row across all 13 weeks. Note any weeks below threshold or trending toward it.
- Flag any threshold-proximity weeks and distribute the updated view to founders, co-founders, and the finance team. This is a shared visibility tool, not a private document.
“Founders who refresh weekly catch issues 6 to 10 weeks before they manifest as crises. Founders who refresh monthly catch them 2 to 4 weeks before. Founders who refresh quarterly are usually catching them mid-crisis.”
What to Do When a Week Goes Negative
When the buffer row goes negative for any week in the 13-week horizon, work through the following levers in priority order. The order matters: lower-cost levers first.
Upgrade to faster payment gateway settlement tiers (T+1 instead of T+2). Push marketplaces for shorter settlement cycles (volume leverage helps). Run prepaid promotions: a 3 to 5% discount on prepaid orders shifts COD orders to prepaid, accelerating settlements by 5 to 10 days. This is costless or low-cost and should always be the first lever.
Renegotiate supplier payment terms (Net 15 to Net 30, Net 30 to Net 45). Defer non-critical spending (software renewals, brand investments, non-urgent professional fees). Most suppliers will accommodate a one-time extension request if the relationship is healthy. This is also costless if the supplier relationship is strong.
Reducing weekly marketing spend by 30% for 4 weeks defers ₹6 to ₹10 lakh of outflow for a mid-sized brand while preserving most of the conversion from campaigns already in flight. This is reversible: once the cash position recovers, marketing can ramp back. This lever is low-cost (some growth momentum deferred) and fast to implement (same-day on Meta and Google).
Invoice discounting, inventory financing, or short-term revenue-based financing fills the gap when operational levers aren’t sufficient. Effective annual rates run 15 to 22%. This is medium cost, not free, but significantly cheaper than the alternative. Apply at least 4 to 8 weeks before the negative week: lenders require time to process.
If the gap is larger than operational levers can close, and the business fundamentals support it, accelerate the timeline of the next equity raise. The critical distinction: do this 6 to 8 weeks before the projected cash crisis, not 2 weeks before. Fundraising from a position of relative strength (growing, solvent, in control of timing) produces better terms and higher probability of close than fundraising from a position of distress. The runway model and the 13-week together provide the data needed to make this decision before it becomes urgent.
The order matters. Levers 1 through 3 should always be exhausted first because they’re costless or low-cost. Lever 4 is medium cost. Lever 5 is the highest cost (dilution) and should be the last resort, used when the gap is genuinely too large for the others to bridge.
Common Mistakes That Break the Model
Pre-built, with formulas working, ready to drop in your numbers. Free, with our ebook The D2C Founder’s Playbook.
Get the Template