The 13-Week Cash Floor: The Forecast Your P&L Can't Give You

You approve an inventory deposit with enough money in the bank to cover it. Payroll falls in the same week. Your payment provider then pushes a settlement into the following week, and you spend Thursday negotiating a payment you agreed to a month ago.

You can run a profitable direct-to-consumer brand and still face that collision. Your accountant recognizes revenue and expenses under accounting rules; you pay suppliers and employees on specific dates. You need both views to decide how much cash you can commit.

A 13-week cash flow forecast gives you the second view. Start with available bank cash, schedule receipts and payments by week, and calculate the lowest projected closing balance. Express that low point in days of operating expense, then agree on the threshold that requires a decision.

I use cash floor to mean that projected low point. The operating habit matters as much as the calculation: review the forecast before approving spending, record the decision, and compare what happened with what you expected the following week.

Schedule Cash by Bank Date, Including Commitments You Have Already Made

Your bank balance tells you how much you have available now. It leaves you to account for the deposit due next month, the media bill due Friday, and the sales proceeds your marketplace still holds. Subtracting a vague buffer from today’s balance will not tell you which future week needs attention.

The profit-and-loss statement answers a different question. You might pay for inventory months before recognizing its cost against a sale. You might recognize a sale before receiving the processor payout. Debt principal also consumes cash without appearing as an operating expense. Read the P&L to understand profitability, and schedule those cash movements to understand liquidity.

Separate Sales From Receipts

For the near term, pull expected deposits from payment-provider records. Shopify documents payout activity, fees, reserves, and payout timing as distinct parts of its payments reporting.¹ Use the expected bank-arrival date and net amount rather than dropping yesterday’s sales into this week’s cash column.

Follow the same discipline for marketplace settlements. Amazon describes a settlement process that accounts for expenses, refunds, and reserves before disbursement; bank processing can add time after it initiates a transfer.² Your own account’s schedule and available balance should govern the forecast. A general two-week settlement assumption cannot capture an account hold or deferred transaction.

Further out, you will need a sales forecast because the provider cannot show settlements for orders that have not happened. Document how you convert expected sales into receipts: channel mix, refund assumptions, settlement lag, and any reserve withholding. Keep confirmed deposits distinguishable from estimated receipts in your supporting schedule.

A delayed $40,000 payout belongs in a later week. Remove it from the original week and add it to the expected arrival week. Enter a negative receipt only if you expect an actual cash debit, such as a provider collecting a negative balance. Reserve withholding alone does not mean money leaves your bank.

Schedule the Whole Inventory Payment

Ask your purchasing owner for the payment schedule behind each open purchase order (PO). Include the deposit, production balance, and freight or duty payments you expect within the window. A deposit-only forecast understates the cash you will need to make that inventory available for sale.

For a health-and-wellness brand, that can include a manufacturing balance due before batch release and inbound freight payable before the warehouse receives the goods. Check the contract and shipment status. A promised sales launch does not change the supplier’s due date.

Apply the same care to advertising. Enter the date cash leaves the bank, which can differ from the date your team runs the ads. If you pay through a card, schedule the relevant card payment and reconcile it to planned spend. Counting ad delivery as one outflow and paying the card as another would double the same cost.

Calculate Weekly Closing Cash and the Lowest Balance Across the Window

Give each week one column. Use the same week-start convention across your source schedules, and keep the model in one reporting currency. Translate foreign-currency receipts and payments with documented assumptions, including conversion charges where relevant.

The core calculation is:

Projected closing cash = Opening cash + Cash receipts - Cash payments
Next week's opening cash = This week's projected closing cash
13-week cash floor = Lowest projected weekly closing cash

Begin with available cash from the bank accounts you can use for these obligations. Exclude restricted balances. If your opening figure already reflects a pending debit, reconcile that treatment before scheduling the payment again. Keep undrawn credit outside opening cash; a planned draw needs its own timing, fees, and repayment assumptions.

Thirteen weeks gives you a near-term quarter with enough weekly detail to coordinate several purchasing and payroll decisions. It is a practical starting window. An imported product with a longer replenishment cycle needs a longer planning view alongside it, especially when you must commit cash before week 13 for receipts that arrive beyond the forecast.

Use the Minimum, Not the Final Week

In the fictional example accompanying the cash-floor template, the brand opens with $280,000. It closes week 13 with $560,000. Looking at those endpoints alone would miss a week-7 balance of $140,000.

The low point occurs before the later receipts replenish the account. You still need to fund obligations during that interval. Review both the lowest balance and its date; a quarter-end number cannot substitute for either.

Keep a separate view of daily cash around a tight week. Payroll could clear on Tuesday and a large settlement arrive on Friday, producing a positive week-end balance after an earlier shortfall. A weekly forecast helps you find the weeks that deserve that closer review.

Build the Forecast Around the Template’s Actual Inputs

The 13-Week Cash Floor workbook has a working tab and a separate, fictional filled-in example. Keep two sets of figures distinct as you enter your own numbers: the operating expense base you use to measure coverage, and the weekly payments you use to calculate closing cash.

Set the Expense Base and Opening Date

In Cash Floor!B2, enter your monthly operating expense (OPEX). Cell B3 divides that amount by 30 to give you daily OPEX. Use the same convention for February and for months with 31 days. You can then compare coverage between reviews without changing the denominator.

Decide which expenses to include in that base. Payroll, rent, and operating software are a starting point. Write down any other expense classes you add, and keep that definition for subsequent reviews. Inventory purchases and scheduled media payments belong in the cash forecast whether or not you include them in the coverage denominator.

Enter the first Monday of your forecast in B5 and available opening cash in B7. The other date cells move ahead seven days at a time. Each later opening-cash cell carries over the preceding week’s projected closing balance.

Monthly OPEX does not carry over into the weekly payroll-and-OPEX row. Enter the amounts you expect to pay in the weeks you plan to pay them. Dividing payroll by four could hide a three-payroll month; the same problem applies to a quarterly subscription renewal or a tax payment. Check the calendar before filling those cells.

Fill the Receipts and Payment Rows

Use the receipts and payment rows to check your supporting schedules:

Record routine payments as positive amounts. The closing-cash calculation subtracts the total. For a payout that already excludes processor fees or refunds, enter the net deposit and leave those deductions out of the payment rows. Limit other receivables to money you haven’t counted through a provider.

The week-1 calculations are:

B11 = SUM(B8:B10)       Total inflows
B16 = SUM(B12:B15)      Total outflows
B17 = B7+B11-B16        Projected closing cash
B18 = B17/$B$3         Days of OPEX, for a positive expense base

Row 17 is closing cash, row 18 is days of OPEX, and row 19 is status. Use MIN(B17:N17) to find the lowest week-end balance in dollars, or MIN(B18:N18) for coverage. Find the column containing that low point, then read the week-start date in row 5 of the same column.

Reconcile Before You Roll Forward

Choose a single point of contact in finance or operations to maintain the forecast. Purchasing supplies updates on supplier payments, and marketing supplies spending changes. The forecast owner needs that information before the spending review. A new commitment announced during the meeting may require you to recalculate the forecast before you can approve anything else.

Save a dated copy of the prior forecast at the start of your next weekly update. Compare its projected closing balance with actual available cash. Explain the discrepancy, then use actual cash as the new opening balance. Shift the remaining schedule forward and insert a new thirteenth week. Check the formulas and payment dates after moving the columns.

Record whether a material variance came from timing, an amount change, or an omission. Receiving a settlement two days late requires a different correction from discovering a manufacturing balance that nobody entered. Keep the explanation with the revision so you can refine the assumption for the next week.

Keep a Receipt Register Behind the Weekly Totals

For each material receipt, keep the provider or customer’s name, expected amount, expected bank date, and date last reviewed. Add a confidence label: confirmed for disbursement, estimated from account activity, or forecast from future sales. You can aggregate these amounts into a weekly total, but the reviewer should be able to trace each one back to its source.

Assume you were expecting a $40,000 settlement from a provider and received $25,000. If the provider has scheduled the remaining $15,000 for the coming week, move that amount to the new date. Keep the record supporting the change. If fees or refunds explain the difference, reduce the expected receipt instead of carrying an unaccounted-for $15,000 into another week. A later payment changes the timing; fees and refunds reduce the cash you can expect across the remaining forecast.

Keep uncertain collections separate from confirmed receipts until you have evidence to confirm them. A wholesale customer’s verbal agreement may support a base-case assumption. If you’re relying on that money to fund a deposit, ask whoever manages collections to confirm the date before the purchasing decision, and test a delay in the downside case.

Keep the original expected amount and date beside the revised ones. Over several reviews, you may find that one provider takes longer than you assumed or that a receivables category needs a larger timing allowance. Update the assumption for that receipt or category. Adding an unexplained buffer to the final cash balance would leave the cause of the error unresolved.

Use a 45-Day Trigger as a Defined Decision Policy

Days of OPEX express a cash balance relative to the expense base you selected:

Daily OPEX = Monthly OPEX / 30
Days of OPEX = Projected cash / Daily OPEX

With $120,000 of monthly OPEX, daily OPEX is $4,000. A 45-day threshold equals $180,000. The template marks coverage below 45 days for a decision, from 45 to below 60 days as watch, and 60 days or more as okay.

Those are example policy settings. Choose your own review threshold around obligations, payout variability, supplier lead times, and financing access. Forty-five days does not represent a universal inventory cycle or prove that a brand has enough liquidity.

It also differs from runway. Days of OPEX divide cash by a defined gross expense base. Net-burn runway compares cash with net cash consumption after receipts and other outflows. You cannot conclude that a 35-day coverage figure means the company will run out of cash in 35 days.

Read the Week-7 Breach

The filled example uses $120,000 monthly OPEX and therefore $4,000 daily OPEX. Its middle weeks look like this:

These are fictional planning figures, not results from a client or my brand. Week 7 includes a $240,000 PO deposit plus $75,000 of other payments. Earlier PO deposits of $180,000 in week 5 and $60,000 in week 6 also reduce the cash available going into that week.

The example contains negative marketplace entries in weeks 5 and 6. Read those as assumed net account debits, not as payout delays. For your own forecast, support such an entry with an expected bank debit; put a withheld positive settlement in its expected future receipt week instead.

At $140,000, week 7 sits $40,000 below the example’s $180,000 threshold. You can now evaluate a specific funding gap with a date attached.

Test a Response Across the Remaining Weeks

Suppose your supplier agrees to move $40,000 of the week-7 deposit into week 8 without changing the delivery date or total cost. Week-7 payments fall to $275,000, leaving $180,000 at close: 45 days of OPEX.

Week 8 then opens with $180,000, receives $155,000, and pays $115,000. It still closes with $220,000, or 55 days. You have changed the timing of $40,000, not created additional cash. That distinction belongs in the decision log and in any claim about the benefit.

Check downside assumptions before accepting the move. A $30,000 week-7 receipt delayed until week 8 would pull the revised week-7 close down to $150,000, or 37.5 days. The initial reschedule meets the base-case threshold with no headroom; the downside case exposes how much additional room you might need.

Compare the Commercial Cost of Each Cash Response

Start with obligations you can change before they become binding. Pause an uncommitted replenishment order, reduce its size, or ask a supplier for split payments. Check the resulting stock availability and expected contribution before approving the change. An inventory delay that creates a stockout may cost more than a financing fee.

Negotiate timing with the supplier rather than moving a due date in your spreadsheet and treating it as settled. Keep the original terms in the base forecast until you have agreement; use a separate scenario to show the proposal. Record the person responsible for confirming the new terms.

Evaluate demand changes through both margin and cash. A promotion can bring receipts forward, but it can also increase fulfillment costs and accelerate a replenishment purchase. A subscription offer that collects cash now creates a future fulfillment obligation. Model those payments across the rest of the window before treating the initial receipts as available surplus.

Use SKU contribution margin to estimate what you keep from the orders you are trying to accelerate. Apply the same check to a media reduction: lower spending saves cash on the payment date, but reduced receipts can create a later low point. The attribution triage framework helps you assess the evidence behind that expected revenue response.

If financing is part of the response, add the expected draw, fees, and repayments to a separate scenario. Confirm availability and timing with the lender. An undrawn facility subject to conditions cannot cover payroll until you can access it.

End the review with a named owner, an action deadline, and the assumptions under which you approved the decision. For a seasonal promotion, carry those assumptions into your BFCM execution plan, including the deposit and receipt dates that could change the campaign budget.

Automate the Updates You Can Verify

Manual upkeep becomes difficult when the forecast owner must reconcile several payment providers, a changing PO register, and spending changes between meetings. A missed update can leave you approving a commitment against last week’s assumptions.

You can automate collection of bank balances, provider settlements, and recorded commitments. Calculate the weekly balances and threshold comparisons with defined formulas. Keep a timestamp for each source, surface failed imports, and preserve the prior forecast so the reviewer can see what changed.

The DTC Revenue Intelligence Engine applies that structure across cash, product margin, and marketing efficiency. Deterministic pipelines compute the numbers. AI agents can explain those supplied metrics and highlight decisions for review; they still need your purchasing terms and forecast assumptions to describe future cash.

A useful notification would identify the lowest week, its coverage, and the commitment responsible for a material change. For the fictional example, it could read:

Illustrative cash review: W7 projected close is $140,000, or 35 days of OPEX, against a 45-day review threshold. The W7 PO deposit is $240,000. Finance and purchasing should evaluate payment timing before confirming the deposit schedule.

Link the alert to the underlying forecast and source records. Keep stale inputs visible so the reviewer can distinguish a new cash concern from a failed settlement import. The same ownership and freshness rules apply to a sheet and to an automated management dashboard.

Download the 13-Week Cash Floor Template

Free Download

The 20-Minute Cash Floor Forecast

A complete Excel forecasting system: 13-week grid, payout and settlement inputs, PO deposit and ad-spend trackers, days-of-OPEX trigger, status alerts, and a worked example.

Your subscription could not be saved. Please try again.

You're in — check your inbox to confirm your subscription.

Download Free Template

No spam. Unsubscribe anytime.

Keep the Forecast Honest as Conditions Change

Maintain a base case and a downside case with specific changes. Move a major settlement, reduce expected receipts, or add a plausible freight payment. Avoid an unexplained percentage haircut across the whole sheet; you need to know which assumption would force a different action.

Review commitments beyond the thirteenth week before approving spending now. A production deposit may sit inside the window while the final balance falls outside it. Extend the schedule far enough to inspect that obligation and the expected receipts from selling the inventory.

For the first review, bring available bank cash, the current payout schedules, and the open-PO payment register. Enter payroll and planned media payments on their bank dates, then inspect the lowest projected week. Assign the person who can change the largest relevant commitment and agree on when they will report back.

Use the 13-Week Cash Floor template to organize that first review. Start with the working tab, compare its rows with the fictional example, and replace the example’s review threshold with a policy finance can defend for your obligations.

Use that updated forecast in the next spending decision. After the week closes, compare actual cash with the number you approved against and record the cause of the difference. Repeating that comparison gives you a basis for improving both the forecast and the commitments you make from it.