13-Week Cash-Flow Forecast: Your Short-Term Cash GPS

Every ambitious company eventually runs into the same headache: cash-flow surprises. Revenue may look strong on paper, yet the bank balance sits anemically low because customers pay late or a stack of bills lands at once. A 13-week cash-flow forecast fixes that by giving you a clear, week-by-week picture of money in and money out—well before problems hit. Case in point: we helped a new client build their first 13-week model and uncovered a significant looming cash gap they wouldn’t have seen until it was too late. Armed with this foresight we were able to secure a line of credit for the client to smooth out the cash swings.

What Exactly Is a 13-Week Cash-Flow Forecast?

A 13-week forecast is a rolling schedule that starts with today’s bank balance, layers in expected customer receipts adjusted for invoice lag days, and subtracts every scheduled outflow—payroll, vendors, taxes, even autopay credit-card charges. Updated each Friday, it always shows the next thirteen Fridays of liquidity, letting leadership steer with real-time visibility rather than end-of-month surprises. Wyatt Stovall of Till CFO notes that the secret sauce is tagging each invoice with “the lag we know that customer actually takes to pay,” turning a spreadsheet into a cash crystal ball.

Why 13 Weeks—Not 4 or 52?

Thirteen weeks hits the sweet spot: it is long enough to arrange a credit line, renegotiate payment terms, or trim discretionary spend, yet short enough for the numbers to stay accurate. Boards and lenders appreciate knowing exactly how many weeks of oxygen the company has, and most recurring costs—payroll, rent, SaaS renewals—cycle at least once during this window, ensuring nothing sneaks past the radar.

Step-by-Step: Building Your Rolling Cash-Flow Forecast

1. Record today’s bank balance. It’s the only immutable fact in the model.
2. Extract your A/R aging report. List every open invoice.
3. Apply invoice lag days. If a customer chronically pays 30 days late, add +30 to the due date.
4. Input fixed outflows. Payroll, rent, debt service—anything with a firm date.
5. Estimate variable spend. Cloud bills, marketing, contractors—use recent averages.
6. Calculate weekly net cash. Flag any week that dips below your operating cushion.
7. Stress-test. Delay a major receipt or pre-pay a vendor in the model and watch how fast the buffer shrinks.

Lag-Day Logic: Turning “On-Time” Into Reality

Contract terms rarely match real life. For example, Customer A’s Net 60 invoices often hit the account 90 days after issuance, while Customer B can stretch to Net 120—unless they route through their CS department and cut that in half. Customer C pays 90 days after PO approval, not after the invoice date. By embedding these nuances, our clients see cash gaps weeks earlier and avoid last-minute funding scrambles.

From Forecast to Action

At Till CFO we set a simple red-zone rule: if next week’s projected ending cash drops below a certain multiple of payroll, we set up a call to work through the cash crunch. In that meeting, leaders decide whether to accelerate collections, defer non-critical expenses, or tap the credit line. It may also trigger a shift in deal strategy-such as renegotiating customer terms on the very next deal. This kind of forecasting shifts finance from passive scorekeeper to proactive strategist.

Key Takeaways

A 13-week cash-flow forecast is a short-term GPS that spots dips in the road ahead. Modeling invoice lag days is what transforms a neat spreadsheet into a reality-tested decision engine. Update it weekly and you will make faster calls, maintain stakeholder confidence, and keep surprise cash crises off the agenda.

Ready to Put This to Work?

Till CFO provides an embedded CFO services team. We customize a cash-flow forecast specifically for the nuances of your business, automate your data feeds, and activate in under two weeks. Book a call today and turn cash-flow guesswork into confident, data-driven control.

‍