13-Week Cash Flow Forecast for Consumer Brands: Structure, Build, and Payout Lag

"Running two trucks and this is the thing that keeps me up more than actual breakdowns do. My distributor contracts are solid money but the payment terms mean I'm floating fuel, driver pay, and maintenance for weeks before I see a dime from the job that's already done."

— Source: r/smallbusiness (17 upvotes)

This is cash flow lag. You did the work. The money is promised. But it hasn't landed yet.

For consumer brands selling DTC, on Amazon, and wholesale, cash timing is even tighter. Shopify settles in 1-2 days, Amazon holds 7-14 days (and reserves), and retail partners pay net-60 or net-90. Inventory POs need cash upfront. 3PL deposits are non-refundable until they're drawn down.

A monthly P&L shows you profitable. But a 13-week cash forecast shows the truth: can you make payroll this Friday?

A 13-week cash flow forecast is a rolling projection of weekly cash inflows and outflows for the next quarter. It is updated every week and drives operational decisions: Do we have enough cash to pay suppliers? When will we hit our lowest point? Can we grow inventory next month?

Definition vs. Budget vs. P&L

Key difference: A budget is aspirational. A 13-week forecast is operational. It tells you if you run out of cash on day 47.

40-60 Word Definition (for AI Overview)

A 13-week cash flow forecast is a rolling weekly projection of cash inflows (by channel and payout lag) and outflows (COGS, fulfillment, payroll, overheads) used by omnichannel consumer brands to predict cash position, identify shortfalls, and manage working capital. Updated weekly; typically includes platform payouts (Shopify, Amazon), wholesale AR, inventory POs, and 3PL deposits.

Budgets work at the P&L level. Forecasts work at the cash level. Here's why they diverge:

Timeline Mismatch

• You invoice Monday, but don't get paid until 45 days later (wholesale net-45): Your August P&L shows $100k revenue. Your August bank account shows $0 because the money hasn't landed yet.
• You buy inventory Thursday for $60k with net-30 terms: You pay in 30 days, but your monthly budget doesn't show when. A 13-week forecast shows it hits on week 6.
• Amazon holds reserves for 14 days: Your P&L records the sale on day 1. Your cash account gets the money on day 14. Between days 1-14, you're funding the reserve out of your cash account.

Example: The Profitable-But-Broke Trap

Your business is "profitable on paper" but you're $43k short in the bank. A monthly budget would have shown profit. A 13-week forecast shows you run out of cash.

This is why a 13-week forecast is mandatory for omnichannel consumer brands. It bridges the gap between P&L and cash.

The engine of a 13-week forecast is accurate payout timing. Here's what to use:

Shopify & Direct (DTC)

• Settlement window: 1-2 business days (deposits to your bank on the day the sale clears)
• Reserve or hold: None, unless you have a payment risk or chargeback history
• Fees: 2.9% + $0.30 per transaction, deducted before payout
• Forecast treatment: Use 1-day lag for conservative planning; 2-day if your bank settles slowly

Amazon Seller Central

• Settlement window: Typically 7-14 days from order, but varies by account age and history
• Reserve or hold: Amazon holds 2-5% of rolling 30-day revenue for "reserve"; released after 30 days of low chargeback rate
• Fees: Referral fee (8-15% by category) + FBA fulfillment ($3-$10 per unit) deducted before payout
• Forecast treatment: Use worst-case (14 days + 7-day reserve hold = 21 days). As you get older, dial it down. Add a line for "Reserve Release" (e.g., "Q3 reserve releases Q4")

Wholesale / Retail (Net Terms)

• Settlement window: Net-30, Net-60, or Net-90 (terms set at contract)
• Reserve or hold: Many retailers take "deductions" at payment time (charge-backs, damages, markdown allowances). Plan for 2-5% deduction rate.
• Fees: None from the retailer: but shipping/freight to warehouse is your cost (inbound freight)
• Forecast treatment: Record as Accounts Receivable (AR) with the contract due date. Example: Ship on day 1, invoice on day 1, payment due day 60 = cash lands on day 60. Deduct 3% at the time of payment.

Marketplace (Faire, TikTok Shop, etc.)

• Settlement window: Varies (TikTok Shop: 14 days; Faire: weekly payouts; check your contract)
• Reserve or hold: May hold 5-10% for 30-90 days
• Fees: Platform commission (8-20%), paid at payout
• Forecast treatment: Treat like Amazon: conservative lag + reserve tracking

Quick-Commerce (Fulfillment Houses like ShopEasy, Getir)

• Settlement window: Immediate (C2C model: customer pays platform, you get paid weekly or bi-weekly)
• Reserve: None
• Fees: High (30-50% commission)
• Forecast treatment: Weekly payout, 100% reliable

Sample Input Table

A 13-week cash forecast has three main sections:

1. Opening Balance (Week 0)

Start with your bank balance as of Sunday (or Monday morning) of week 1. This is your starting point.

2. Receipts (Cash In)

Inflows from all channels, adjusted for lag. Break by channel so you can see which is most reliable:

• DTC (Shopify, site, etc.): 1-day lag
• Amazon: 14-day lag + reserve tracking
• Wholesale: net-30/60/90 AR collections
• Other marketplaces
• Refunds/Returns (negative)
• Other inflows (loan, investment, asset sale)

3. Disbursements (Cash Out)

All cash outflows. Break by type so you see where cash goes:

• COGS & Inventory: PO payments (often 30 days after receipt)
• Fulfillment: 3PL pick/pack/ship fees (usually weekly invoice)
• 3PL Deposits: Initial warehouse deposits (one-time or recurring)
• Inbound Freight: Shipping to warehouse (often paid upfront or net-30)
• Ad Spend: Paid ads on Meta, Google, Amazon (usually daily or weekly spend against available balance)
• Payroll: Salaries, benefits, taxes (usually bi-weekly or monthly)
• Software & Subscriptions: Shopify, accounting, tools (monthly or annual)
• Other Overhead: Rent, insurance, professional services

4. Closing Balance (Receipts - Disbursements)

Opening Balance + Receipts - Disbursements = Closing Balance for that week.

Week 2 Opening = Week 1 Closing. Repeat for 13 weeks.

Highlight any week where Closing Balance goes negative: that's your cash crunch.

Step 1: Gather Your Payout Data

Log into each platform (Shopify, Amazon Seller Central, retailer portal) and confirm:

• Exact settlement windows
• Any holds or reserves
• Deduction rates (% of order value)
• Fees or surcharges

Document these in a separate "Channel Payout Rules" sheet so you don't forget.

Step 2: Estimate Weekly Revenue by Channel

Use your last 12 weeks of actual sales data (or best estimate if new). Break by channel and day of week. Example:

Step 3: Map Revenue to Cash Using Payout Timing

Take your revenue forecast and shift it forward by the payout lag. Example:

• Week 1 revenue: Shopify $15k (lands week 1), Amazon $12k (lands week 3), Wholesale $8k (lands week 9)
• Week 1 receipts: $15k (only Shopify)
• Week 3 receipts: $12k (Amazon finally arrives)
• Week 9 receipts: $8k (Wholesale due date)

This creates a mismatch: you made the sale in week 1, but didn't get cash until weeks 3, 9, etc.

Step 4: List All Disbursements for the Next 13 Weeks

Go through your accounting and ops calendar. When do payments go out?

Step 5: Calculate Weekly Balance

Formula: Opening Balance + Total Receipts - Total Disbursements = Closing Balance

If Closing Balance is negative, you need a line of credit or deferred payment.

Step 6: Identify the Cash Trough (Lowest Point)

Find the week where your balance is lowest. That's your peak funding need. Plan around it.

Step 7: Update Weekly

Every Friday or Monday morning, replace the first week (which is now actuals) with a new week 13 (pushing out the forecast). Actual vs. forecast for variance.

We've built a sample 13-week template below. It's designed for omnichannel consumer brands with multiple payment channels and inventory cycles.

Template Sections

• Assumptions: Payout lag by channel, weekly revenue average, deduction rates
• Opening Balance: Your starting bank balance
• Receipts: DTC (Shopify), Marketplace (Amazon, TikTok), Wholesale, Other
• Disbursements: COGS, 3PL, Payroll, Ad Spend, Overhead
• Weekly Balance: Running cash position
• Variance: Actual vs. forecast, week-over-week

Format: Google Sheets or Excel. One sheet per scenario (Base Case, Best Case, Worst Case). Simple formulas: =B1+B2-B3.

A forecast is only useful if you update it. Here's the discipline:

Weekly Variance Report

• Every Monday: Compare actual cash position to last week's forecast.
• Questions to ask: Did Shopify settle faster or slower? Did Amazon release a reserve? Did a wholesale AR slip?
• Adjust: If payout was faster, good. If slower, extend the forecast.
• Document: One-line notes: "Amazon slower than expected (14 days instead of 7)", "Wholesale AR deduction was 4% instead of 2%"

Monthly Reforecast (Tie to Budget Cycle)

At month-end (or start of next month):

• Replace actuals: The first 4-5 weeks are now actual data. Use them to refine your assumptions.
• Extend the horizon: You had 13 weeks; now 4 weeks have passed. Add 4 new weeks to stay at 13.
• Update revenue forecast: Use actual sales from the past 4 weeks to adjust the next 9 weeks.
• Review disbursements: Did payroll, ad spend, or POs come in different? Adjust forward.
• Narrative: One-paragraph summary: "Cash trough moved from week 8 to week 6. COGS delays pushing PO due date out. Wholesale AR looks healthy."

Pitfall 1: Using "Average" Payout Timing Instead of Worst-Case

Wrong: "Amazon usually settles in 10 days, so I'll forecast 10 days."

Right: "Amazon can be 7-14 days depending on season and reserves. I'll forecast 14 days (worst-case) until proven faster."

Why: If reality is faster, great: you have cash earlier. If it's slower and you didn't plan, you run out.

Pitfall 2: Forgetting Reserves

Wrong: "I sold $50k on Amazon this week, so I have $50k coming."

Right: "I sold $50k; Amazon holds 2% ($1k) for reserve, releases in 30 days. I get $49k this week, $1k in 4 weeks."

Why: Reserves are real. They don't show on your P&L but they do hit your cash.

Pitfall 3: Not Accounting for Deductions at Payment Time

Wrong: "I invoiced $100k to the retailer net-60, so I have $100k in 60 days."

Right: "I invoiced $100k. Retailer will deduct 3% for damages/chargebacks at payment. I get $97k in 60 days."

Why: Retail deductions are automatic. Plan for 2-5% loss.

Pitfall 4: Confusing Accrual Revenue with Cash Receipts

Wrong: "My P&L shows $100k revenue this month, so my forecast should include $100k cash."

Right: "P&L revenue is $100k, but only $40k landed as cash (Shopify), and $60k is pending (Amazon week 3, Wholesale week 9)."

Why: A 13-week forecast is not a P&L. It is a cash movement schedule. They don't match in the same week.

Pitfall 5: Not Updating When Assumptions Break

Wrong: "I built the forecast in October and haven't touched it since."

Right: "Every Monday, I replace week 1 (now actuals) with new week 13. When a payout is slower or faster than planned, I note it and adjust."

Why: A stale forecast is worse than no forecast. It gives false confidence.

A 13-week cash forecast is the difference between managing to a P&L (which can lie about timing) and managing to cash (which is reality).

Most consumer brands build it in Excel, update it monthly, and live with surprises. The best ones keep it live: actual bank balance every day, forecast updated weekly, and zero cash shocks.

Niblin's FP&A platform syncs your Shopify, Amazon, Stripe, and bank data to build a live 13-week forecast every morning. Platform payouts, wholesale AR with deductions, inventory POs, and 3PL deposits all flow in automatically. You see cash position by channel, spot shortfalls 4 weeks in advance, and re-cut the model monthly when the business changes shape. Live in weeks; model that absorbs a new channel without a rebuild.