Free 13-Week Cash Flow Forecast Template + Calculator

See where your cash runs tight, before it does. Plug in seven numbers, get your runway, your tightest week, and what changes when customers pay a few days sooner. Or download the full 8-tab Excel for customer-level detail.

13wk-forecast.xlsx
ABCDE
1WeekInflowOutflowNetCash 2W01$1.8M$1.4M+$0.4M$3.2M 3W02$2.1M$1.9M+$0.2M$3.4M 4W03$1.4M$1.7M-$0.3M$3.1M 5W04$0.9M$1.8M-$0.9M$2.2M 6W05$2.4M$1.6M+$0.8M$3.0M 7W06$1.7M$1.5M+$0.2M$3.2M 8W07$2.0M$2.1M-$0.1M$3.1M
WeeklyInputsCustomersScenarios
Live Calculator

Plug in seven numbers. See your next 13 weeks.

Real-time forecast. Tightest-week alerts. What-if slider for faster customer payments. No signup, no signin, no data leaves your browser.

Your Numbers

$
$
days
$
From new sales. Excludes the open invoices above.
$
Rent, vendors, software (no payroll).
$
$
Anything below this triggers a warning.

Your cash, week by week

Next 13 weeks. Red zone is below your floor.

How long your cash lasts
13 weeks
At your current pace
Your tightest week
$350k
Week 6, $150k below your floor

How this works: The first 4 weeks come from invoices already on your books, so confidence is high. Weeks 5 to 13 use your weekly run-rate as an estimate. Download the 8-tab Excel below to plug in real customer-by-customer numbers.

What if customers paid 7 days faster
Your tightest week jumps from $350k to $630k. That covers about 1 week of outflow. $280k of cash flows in earlier.

High-confidence first 4 weeks

Driven by invoices already on your books. Treasury-grade accuracy where it matters most.

Run-rate weeks 5 to 13

Your weekly cadence projected forward. Tightest-week alerts highlight where cash dips below your floor.

What-if in one slider

Move customer payment timing and watch the tightest week jump in real time. No model rebuild.

Why 13 Weeks

Long enough to spot crunches. Short enough to stay accurate.

Treasury teams standardised on 13 weeks because it covers a full quarter of payroll cycles plus quarterly tax payments, while keeping forecast accuracy high in the early weeks.

90%+ early-week accuracy

AFP 2025 Treasury Survey: top teams hit 90% accuracy at the 1-week mark. That is why we split the forecast into a high-confidence first month and a run-rate estimate after.

13 weeks, the CFO standard

A full quarter of payroll cycles plus quarterly tax payments. Long enough to spot cash crunches early, short enough to stay accurate.

8 to 12 days of DSO upside

Typical DSO improvement when AR teams move from manual collections to 100%-coverage workflow. The what-if slider above shows exactly what those days are worth to you.

8-Tab Excel Toolkit

A peek at what is inside

Customer-by-customer AR detail, three-scenario fan chart, variance-vs-actuals tracker, and a DSO reduction modeler that targets your slowest payers.

13-Week Rolling Forecast tab preview 13-Week Rolling Forecast
Customer AR Schedule tab preview Customer AR Schedule
DSO Reduction Modeler tab preview DSO Reduction Modeler
Variance vs Actuals tab preview Variance vs Actuals
Industry Benchmarks tab preview Industry Benchmarks

Free 13-week cash flow forecast Excel

Customer-by-customer detail. Variance tracking that sharpens your forecast every week.

  • Customer-level AR schedule with editable collection probabilities
  • Three-scenario fan chart: best, today, worst, all on one toggle
  • Variance-vs-actuals tracker. Log actuals weekly, forecast self-corrects
  • DSO reduction modeler that targets your slowest payers, not just aggregates

By downloading you agree to receive insights and product updates from Transformance.

CashPulse · Enterprise Forecasting

When Excel can't keep up, CashPulse takes over.

Live AR/AP feeds, ML-driven customer payment predictions, and continuous re-forecasting at multi-entity scale. The model gets sharper every week without anyone touching a spreadsheet.

CashPulse cash flow forecasting dashboard with weekly cash position and variance attribution

ML payment predictions

Per-customer payment probability models, retrained continuously on your AR history. No more average DSO assumptions.

Live ERP and bank feeds

Multi-entity, multi-currency rollups from SAP, Oracle, NetSuite or any system. Forecast updates as actuals land.

Variance attribution

When the week comes in different, CashPulse tells you which driver moved: collections timing, new sales, or unplanned outflow.

TRUSTED BY O2C AND FINANCE TEAMS
FAQ

Questions, answered

What is a 13-week cash flow forecast?

A 13-week cash flow forecast is a weekly view of money coming in and going out over the next quarter. It uses the direct method, meaning actual customer payments, payroll dates, and vendor invoices rather than accrual accounting, so it shows real cash timing. Each week you drop the past one and add a new week ahead, keeping the rolling 13-week window. It is the standard tool finance teams use to spot cash shortfalls early enough to do something about them.

Why is a cash flow forecast 13 weeks specifically?

A 13-week cash flow forecast covers a full fiscal quarter. That is long enough to see major events like quarterly tax payments, board commitments, and debt covenants, but short enough that recent history is still a reliable predictor. Daily forecasts are too noisy; monthly forecasts hide weekly cash crunches. Restructuring practitioners standardised on 13 weeks because it covers a complete payroll cycle plus quarter-end events while keeping accuracy high in the early weeks.

Direct method vs indirect method for cash flow forecasting: which is better?

Use the direct method for weekly cash flow forecasts. It lists actual cash inflows (customer collections by week) and outflows (payroll, AP, rent) at the dates they hit your account, which matches how short-term liquidity actually behaves. The indirect method starts from net income and adjusts for non-cash items. Better for monthly profit planning, worse for catching a Tuesday payroll squeeze. Direct method equals liquidity forecasting. Indirect method equals profitability planning.

How accurate is a 13-week cash flow forecast?

Top treasury teams hit 90%+ accuracy in weeks 1 to 4 of a 13-week cash flow forecast, dropping to around 60 to 70% by week 13. The drop-off is why this tool splits the forecast into a high-confidence early month (driven by invoices already on your books) and a run-rate estimate after. The point is not perfect prediction. It is spotting which week is tight and what would move it: faster AR collection, delayed AP, or a line draw.

How often should I update my cash flow forecast?

Update your cash flow forecast weekly. Every Monday: drop last week, log what actually came in and out, add a new week 13 at the far end. This rolling cadence is the single biggest accuracy lever. Forecasts reconciled against actuals get sharper every week, while static templates drift further from reality. The Excel template above includes a variance sheet built exactly for this loop.

Cash flow forecast: Excel template or software, which is better?

Excel cash flow forecast templates work for steady-state businesses with a single entity and a treasurer who can refresh them weekly. They are free, flexible, and good enough up to roughly $50 to 100M revenue. Cash flow forecasting software pulls live AR/AP/ERP data automatically, runs ML on customer payment patterns, and handles multi-entity and multi-currency rollups. Necessary at enterprise scale, where manual reconciliation breaks down. Start with the Excel above, scale to CashPulse when the model can no longer keep up.

Cash certainty, every Monday morning.

Use the calculator and Excel above to start. When the model outgrows the spreadsheet, CashPulse picks it up.