13-Week Cash-Flow Forecast Template (2026)

1Tell us where to send it
Your name and work email — nothing more.
2Check your inbox
Your spreadsheet arrives in seconds, not days.
3Use it with your team
Editable and ready to share — make it your own.

A peek inside

See exactly what you're getting

Free Excel template

Spotsaas · 2026

13-Week Cash-Flow Forecast Template

✓ Instructions

✓ Settings

✓ Forecast

✓ Summary

Get the spreadsheet →

What it is

The 13-Week Cash-Flow Forecast Template is a rolling, direct-method liquidity tool that shows exactly when cash will get tight. Unlike a profit-and-loss statement, which is accrual-based, this forecast tracks the actual cash moving in and out of your bank account week by week. Thirteen weeks is the standard horizon because it spans a full quarter while staying short enough to forecast with real confidence. For most finance teams it is the single best early-warning system for a liquidity crunch.

The workbook is pre-filled with realistic numbers across four tabs. On the Settings tab you enter your opening bank balance and a minimum cash buffer, the floor you never want to drop below. The Forecast tab lays out each of the 13 weeks with editable cash-in lines (AR collections and other receipts) and cash-out lines (payroll, rent, suppliers, taxes, loan payments); total cash-in, total cash-out, net movement, and a carried-forward closing balance all compute live, with each week's closing balance seeding the next week's opening balance.

The Summary tab does the analysis for you. It reports total cash-in and cash-out for the quarter, net movement, the ending balance, and, most importantly, your lowest projected weekly closing balance and how much headroom that leaves above your buffer. A status indicator escalates from Healthy to Caution to Warning to Critical, and tells you when any week is projected to breach the buffer or go cash-negative, so you can act before the shortfall arrives rather than after.

What it's used for

A 13-week forecast is how finance teams manage short-term liquidity with precision. This template is used to see, week by week, whether cash will hold, and to plan the fix when it won't.

✓ Spotting a liquidity crunch weeks in advance instead of discovering it when a payment bounces
✓ Timing large outflows like payroll, tax payments, and supplier runs against expected collections
✓ Testing whether your cash buffer survives a slow collections week or a one-off large payment
✓ Deciding when to accelerate AR collections, delay non-critical payables, or draw on a line of credit
✓ Giving a founder or CFO a clear, weekly view of runway that a P&L cannot provide
✓ Running a rolling forecast: dropping the oldest week, adding a new Week 13, and updating actuals each week
✓ Supporting financing conversations with a concrete, week-level picture of cash needs

Who uses it

Cash forecasting is owned by whoever is responsible for not running out of money. This template serves both the people who build the forecast and the leaders who act on it.

CFOs and finance directorsThey use the 13-week view to manage liquidity proactively and to brief the board or lenders on cash position.

ControllersThey build and maintain the forecast, feeding it accurate collection timing and scheduled outflows.

Founders and small-business ownersFor a cash-tight business, the weekly closing balance is the most important number they watch.

FP&A analystsThey roll the forecast weekly, reconcile actuals against projections, and explain the variances.

Treasury and cash managersThey use the shortfall warnings to decide when to draw on credit lines or move funds between accounts.

Turnaround and restructuring advisorsThe 13-week forecast is the standard tool they use to stabilize a business in a cash crisis.

Context & good to know

The reason a 13-week cash forecast matters so much is that profit and cash are not the same thing. A business can be profitable on its P&L and still run out of cash if customers pay slowly while payroll, rent, and suppliers come due on a fixed schedule. The direct method used here ignores accruals and tracks only real money movement, which is exactly what your bank account experiences. That is why it catches problems a P&L hides.

The forecast is only as good as its inputs, and the two that matter most are collection timing and large one-off payments. A week where you assume a big invoice clears but it slips by ten days can be the difference between Healthy and Critical. The template makes this visible by carrying each week's closing balance forward, so a single optimistic assumption ripples through every following week. Reviewing AR collection timing realistically, and being honest about when taxes and loan payments actually hit, is where forecasting discipline pays off.

When the Summary flags a breach, you have a known set of levers: accelerate AR collections, delay non-critical payables, draw on a line of credit, or cut discretionary spend. The value of seeing the breach weeks early is that gentle levers, such as a collections push or shifting a supplier payment by a few days, are usually enough. Wait until the week of the shortfall and your only options are the expensive, relationship-damaging ones. A common benchmark is to hold a buffer of at least four to eight weeks of operating outflow.

A 13-week forecast is meant to roll, not sit still. Each week you drop the week that just happened, add a fresh Week 13 at the far end, and update the near weeks with actuals. This keeps the horizon constant and forces a weekly habit of comparing what you projected to what really happened, which is how your forecasting accuracy improves over time.

✓ Independent · vendors can't pay to rank

Built on verified data, not vendor spin

Every Spotsaas resource draws on the Spotsaas Score — a blend of verified review ratings, review volume, and feature depth across 165 accounting software tools. Refreshed regularly; data as of June 2026.

FAQ

Questions, answered

What is a 13-week cash flow forecast?

It is a rolling, direct-method projection of the cash moving into and out of your bank account each week over the next 13 weeks (one quarter). It shows your expected closing bank balance every week, making it the standard tool for managing short-term liquidity and spotting a cash crunch in advance.

Why 13 weeks and not a month or a year?

Thirteen weeks covers a full quarter while staying short enough to forecast accurately. Beyond a quarter, weekly cash timing becomes guesswork; a shorter window misses upcoming pressures. Thirteen weeks is the widely used standard, especially in treasury and turnaround work, because it balances horizon against confidence.

How is a cash flow forecast different from a P&L?

A P&L is accrual-based and shows profitability, recognizing revenue and expenses when earned or incurred regardless of cash timing. A cash forecast tracks actual money moving through your bank account. A business can be profitable on the P&L yet run out of cash, which is exactly what this forecast catches.

What is the minimum cash buffer and how do I set it?

The minimum cash buffer is the floor you never want your bank balance to drop below. A common benchmark is four to eight weeks of operating outflow. You enter it on the Settings tab, and the Summary tab tests every week's projected closing balance against it and warns you of any breach.

What do I do if the forecast shows a shortfall?

Trace the warning on the Forecast tab to the specific week and cause, then use your levers: accelerate AR collections, delay non-critical payables, draw on a line of credit, or cut discretionary spend. Seeing the breach early means gentle fixes usually work; waiting forces expensive ones.

How often should I update the forecast?

Weekly. Roll it forward by dropping the week that just passed, adding a new Week 13, and replacing projections with actuals for the recent weeks. This keeps the 13-week horizon constant and steadily improves your forecasting accuracy as you compare projections to reality.

What goes in cash-in versus cash-out?

Cash-in is money you expect to receive that week, mainly AR collections plus other receipts. Cash-out is money leaving that week: payroll, rent, suppliers, taxes, and loan payments. Net movement is cash-in minus cash-out, and it is added to the opening balance to get the closing balance.

Can I build this in my accounting software instead of a spreadsheet?

Some accounting platforms include short-term cash forecasting, often pulling AR and AP timing automatically. A spreadsheet like this template gives you full control over assumptions and is easy to adjust. You can compare accounting platforms with built-in cash-flow tools on Spotsaas if you want automation.

Why does the closing balance carry forward each week?

Cash is continuous: the money you end one week with is the money you start the next week with. Carrying the closing balance forward means a single assumption, like a late collection, ripples through every later week, which is exactly the cumulative effect you need to see to manage liquidity.

Is a 13-week forecast only for businesses in trouble?

No. Turnaround teams rely on it, but healthy businesses use it routinely to time large payments, manage seasonal swings, and decide when to invest surplus cash. Any business with variable collections or lumpy outflows benefits from a weekly view of where cash is headed.

Keep exploring