13-Week Cash Flow Template

This free 13-Week Cash Flow Template is built for treasury, FP&A, and controllership teams that need weekly (not just monthly) cash visibility: companies preparing short-term liquidity reporting for lenders, boards, or investors, and finance teams that have outgrown a basic monthly cash flow model. It gives you a direct-method weekly forecast of cash receipts and disbursements with pre-built columns, auto-calculating formulas, built-in minimum-cash tracking, and a forecast-vs-actual variance tab.

Download the template as a Google Sheets document; it exports cleanly to Excel (.xlsx). For the broader method, read our full guide to cash flow forecasting.

What Is a 13-Week Cash Flow Forecast?

A 13-week cash flow forecast is a rolling, weekly projection of cash receipts and disbursements covering the next 13 weeks (roughly one quarter). Treasury and FP&A teams use it to manage short-term liquidity: knowing your cash position and runway week by week rather than in monthly aggregates.

Unlike a monthly GAAP cash flow statement, a 13-week forecast uses the direct method: expected inflows and outflows by week, which is far more accurate for near-term liquidity planning. The 13-week window is also the format banks and investors most often request, particularly during covenant reviews.

How to Use This Template

Template Purpose: Forecast weekly cash receipts and disbursements over a rolling 13-week horizon using the direct method, so you always know your near-term cash position and runway.

Template Sources: Bank balances and GL cash detail, AR aging (collections timing), AP aging (vendor payment timing), payroll calendar, debt schedules, and capex plans.

Process Overview

A 13-week cash flow forecast at any point in time involves referencing:

1. Your current bank / GL cash balance (the beginning cash for Week 1)
2. Expected cash receipts: customer collections driven off the AR aging and sales forecast
3. Expected cash disbursements: payroll calendar, AP aging, rent, taxes, debt service, and planned capex

Make a copy of this template and follow these procedures:

1. On the 13-Week Cash Flow tab, enter the Week 1 ending date, beginning cash balance, and minimum cash balance in the yellow input cells
2. Tailor the receipt and disbursement line items to your operations, adding rows for any recurring inflows or outflows specific to your business
3. Enter forecast receipts by week, using your AR aging and invoice-level detail for large customers
4. Enter forecast disbursements by week, using your payroll calendar, AP aging, and debt schedules
5. Review the Ending Cash and Cash Above (Below) Minimum rows. Any week below minimum needs action: accelerate collections, delay payments, or draw on financing
6. Every week, without exception: record what actually happened in the Weekly Variance tab, refresh your assumptions, and roll the forecast forward one week
7. Review forecast-vs-actual variances weekly. Variance discipline is what makes the forecast (and your understanding of the business) better over time

If using Numeric: Our Cash Management suite syncs your bank accounts and GL in real time, so balances and transaction activity feeding this forecast are always current, and cash matching automates the reconciliation behind your Week 1 actuals.

If not using Numeric: Pull your bank and GL balances manually each week before updating the forecast.

See a full list of accounting templates here.

What's Inside the 13-Week Cash Flow Template

This 13-week cash flow template is built for finance teams that need a repeatable weekly forecasting rhythm: one tab to run the forecast, one to hold the discipline of tracking actuals against it.

Tabs

• Cover & Instructions: The template's purpose, data sources, process overview, and step-by-step procedures. New users should start here.
• 13-Week Cash Flow: The forecast itself. Yellow setup inputs, 13 weekly columns with auto-filling dates, receipt and disbursement line items, and the rolling balance logic.
• Weekly Variance: Forecast, actual, and variance rows for Total Cash Receipts, Total Operating Disbursements, Net Cash Flow, and Ending Cash across all 13 weeks.

Weekly Cash Inflows

The Cash Receipts section covers customer collections (driven off your AR aging and sales forecast) and other receipts, with room to add rows for recurring inflows specific to your business. Financing inflows like revolver draws and equity are tracked separately in the non-operating section.

Weekly Cash Outflows

Operating disbursements include payroll and benefits, rent and occupancy, vendor and AP payments, taxes, insurance, and other operating costs. A separate non-operating section covers capital expenditures and debt service (interest and principal), so operating cash flow stays clean.

Underlying Formulas

• Each week's ending cash equals the prior week's ending cash plus that week's net cash flow, carried forward across all 13 weeks.
• Net cash flow is the sum of net operating cash flow (receipts minus operating disbursements) and net non-operating cash flow (capex, debt service, financing).
• A Cash Above (Below) Minimum row compares every week's ending cash to your minimum cash balance, so shortfalls surface before they arrive.
• On the Weekly Variance tab, variance equals actual minus forecast, calculated automatically as you enter actuals.

The legend is consistent throughout: yellow cells are setup inputs, blue cells are weekly inputs, black cells are formulas you shouldn't overwrite.

Example: Week 1 in the Template

The template ships with example data in Week 1: a company starting the quarter with $250,000 in cash and a $100,000 minimum balance. Here's how the math flows:

‍

Receipts of $185,000 against $163,000 of operating disbursements leave $22,000 of operating cash flow; $16,000 of capex and debt service brings net cash flow to $6,000, and ending cash to $256,000, a comfortable $156,000 above minimum. Replace the blue Week 1 cells with your own figures and the whole 13-week window recalculates.

13-Week Cash Flow Forecast vs. Monthly Cash Flow Forecast

Why a 13-Week Cash Flow Forecast Matters

1. Weekly visibility catches what monthly forecasts miss: A company can look fine on a monthly view and still hit a mid-month payroll crunch. Weekly granularity surfaces short-term liquidity gaps while there's still time to act.
2. Lender- and board-ready reporting: The 13-week format is what banks request during covenant reviews and what boards expect during tight-cash periods. Running it continuously means never scrambling to build one under pressure.
3. Variance discipline compounds: Logging actuals against forecast every week steadily improves your collection and payment timing assumptions. A widening gap between forecast and actuals is itself a signal worth investigating.

When to Move Beyond a Cash Flow Spreadsheet

A spreadsheet is a practical starting point for 13-week forecasting. It's free, flexible, and this template removes the setup work. But spreadsheets have limits, and the data makes the case: more than 90% of spreadsheets used for business decisions contain errors. Here's a simple framework, by company size, for knowing when you've hit the wall.

Small Businesses and Early-Stage Companies

A spreadsheet works well when you have one or two bank accounts and one person owns the forecast end to end. The weekly update might take an hour, and that hour buys real visibility into cash flow.

Mid-Sized and Growth-Stage Companies

As bank accounts, entities, and transaction volume grow, the weekly ritual of pulling balances by hand gets error-prone, and the forecast is only as good as its inputs. These teams benefit most from actuals that sync automatically rather than being re-keyed every Monday.

Enterprises and Multi-Entity Organizations

Multi-entity treasury generally requires consolidated, real-time cash visibility across dozens of accounts, with automated matching between forecasted and actual flows. That's beyond what a spreadsheet can do, no matter how disciplined the process.

Knowing When to Re-evaluate

If your team spends more of the weekly update gathering data than analyzing it, it's time to evaluate what's next. The forecast should drive decisions, not consume the week.

How Numeric Helps with 13-Week Cash Flow Forecasting

• Actuals that update themselves: Numeric's Cash Management suite syncs balances and transaction activity directly from your bank and ERP via Bank Integrations, so the inputs feeding your forecast are always current instead of manually re-entered.
• Automated reconciliation behind your actuals: Cash Matching automates the bank reconciliation behind each week's actuals, matching forecasted inflows and outflows against what actually hit the account.
• Variance analysis on autopilot: Teams that want the forecast-vs-actual comparison automated can use Flux Analysis to surface and explain the drivers behind each variance.

Schedule a demo to see how Numeric keeps a 13-week forecast current without the weekly scramble.

FAQs About the 13-Week Cash Flow Template