Navigating a Cash Crunch: What a 13-Week View Actually Needs to Show

A cash crunch doesn’t announce itself a month in advance. It shows up as a specific week where receipts land late and a supplier payment lands on time, and the gap between the two is the actual problem, not the monthly plan that said the quarter would be fine. That’s the resolution most monthly forecasts can’t see at, and it’s exactly the resolution that matters once cash is tight enough that a treasury team is checking it daily instead of monthly.

Build it from the plan you already have

The instinct in a crunch is often to build a fresh weekly spreadsheet from scratch, and that’s the wrong instinct: it’s slow, and it starts from a different set of assumptions than the plan finance already agreed on. A 13-week view should derive its numbers from the monthly plan you already have, split into a direct-method view: customer receipts, supplier payments, operating expenses and tax paid as incurred, with investing, financing, and FX kept as separate lines rather than folded into a catch-all. Anything the split genuinely can’t attribute cleanly should show up as its own visible residual line, not get absorbed silently into a number that looks tidier than it is: a cash view that can quietly invent or destroy cash to make the math balance is worse than useless in a crunch, because that’s precisely when you’re trusting it most.

Turning monthly totals into weekly ones needs one stated assumption: cash spread evenly across the days in a month, then allocated to weeks so they sum back to the month’s total exactly. That assumption should be visible on the page, not something you discover by reconciling the numbers yourself at midnight.

One number is real. Everything else says so.

In a crunch, the temptation is to treat every number in the view with the same weight, because they’re all urgent. Resist that. Exactly one figure should carry an actual audit citation (the opening cash balance, pulled from a cited actual at the prior year-end), and everything downstream of it is plan-derived and should say so throughout. That distinction is not pedantic. When a lender or a board member is watching your liquidity and asks which number is real, the honest answer needs to be visible on the page, not something you have to explain verbally under pressure. This is the same discipline that should carry through into a board reporting cycle if the crunch is serious enough to brief the board on: plan and audited figures need to stay visually distinct, not blended into one confident-looking number.

What you need to flex, without inventing anything

A crunch is when the “what if” questions come fast: what if a customer pays two weeks late, what if you push a supplier payment out, what if the crunch is bad enough that inventory days need to stretch. Timing assumptions (days sales outstanding, days payable outstanding, days inventory outstanding) should be adjustable and recompute deterministically, so the weekly math still ties exactly no matter how many assumptions get stacked. And if a shift pushes a cash flow earlier than day one or later than week thirteen, the view should say so by name rather than quietly dropping it: a vanishing cash flow during an actual crunch is the kind of silent failure that costs real money.

Minimum-liquidity thresholds work the same way: you name the level that matters to your business, the view flags the first week that breaches it, and there’s no invented default pretending to be your covenant or your policy. If you haven’t set a threshold, nothing should imply you have one.

Where this belongs, and where it doesn’t

A 13-week cash view is advisory by nature: it’s plan-derived, not audited, and it should stay out of anything presented with audited weight, like a formal board pack. Mixing plan-derived weekly cash into that kind of document blurs exactly the line the view exists to keep sharp. It belongs in the workbook you and treasury actually work from day to day, and in the conversations you’re having about whether this month’s variance review meeting needs an emergency addendum.

Who actually needs this

Treasury teams watching covenant headroom week to week rather than month to month. CFOs who’ve been burned once by a monthly plan that looked comfortable right up until a specific week wasn’t. Anyone navigating a real crunch who needs weekly answers now, not a rebuilt spreadsheet by Wednesday that’s already stale.

If cash is tight enough that you’re reading this mid-crunch, book a demo and we’ll show you a 13-week view running against real numbers. For the rest of the recurring situations finance teams navigate, see the finance team use cases hub.