A business can finish a quarter with more cash than it started with and still face a payment shortfall along the way. A 13-week cash flow forecast exposes those timing problems by showing when customer receipts, payroll, supplier payments and other obligations are expected to reach the bank account.
For CFOs, controllers and business owners, the useful question is more specific than whether cash is increasing. It is whether accessible funds will cover obligations when they fall due, how much room remains above the operating cash buffer and what must change before that room disappears.
What Is a 13-Week Cash Flow Forecast?
A 13-week cash flow forecast is a rolling projection of weekly cash receipts, cash payments and closing cash balances over the next 13 weeks. It typically uses the direct receipts-and-disbursements approach, helping a business identify near-term funding needs and update its cash expectations as actual results become available.[1]
Thirteen weeks covers 91 days, approximately one quarter. Unlike a fixed quarterly forecast, a rolling model continues to look ahead: when one week ends, the business incorporates actual results, updates the remaining assumptions and adds another week.
The model should make three things immediately visible.
Download the Free 13-Week Cash Flow Forecast Excel Template
13-Week-Cash-Flow-Forecast-Template.xlsx
The workbook includes an editable worked example, formulas and instructions for replacing the example with business-specific figures. Four worksheets: Forecast, Inputs, Variance and Guide.
Download the Excel template Excel workbook, 20 KB. No email required.| Worksheet | Purpose |
|---|---|
| Forecast | Calculates weekly opening cash, receipts, payments, closing cash, cash-buffer shortfalls and liquidity after confirmed undrawn credit |
| Inputs | Holds the start date, opening cash, operating buffer, weekly assumptions and base/downside collection scenarios |
| Variance | Compares a frozen prior forecast with actual cash results and reconciles calculated ending cash to a bank-confirmed balance |
| Guide | Explains input conventions, scenario controls, weekly rollover and model limitations |
Amber cells with blue text are editable inputs. Formula cells calculate the results.
All example amounts are illustrative teaching assumptions. They are not company results, market statistics or recommended financial benchmarks. The calculations discussed below can be reproduced in the workbook.
The template models one currency and one consolidated pool of unrestricted cash. It does not automatically calculate borrowing-base availability, interest expense, covenant compliance or daily cash balances. Those requirements need supporting schedules.
Build the Forecast Around Cash Settlement, Not Accounting Recognition
The direct method starts with expected cash receipts and payments. An indirect approach starts with profit and adjusts for noncash items and working-capital changes. These are distinct approaches to understanding cash flow; accounting standards describe both methods for reporting operating cash flows.[2]
For a weekly operating model, settlement timing should determine the placement of transactions.
A customer invoice belongs in the week the money is expected to become available. Payroll belongs in the week funds leave the business. Equipment purchases belong in the payment schedule, while depreciation does not create a separate cash payment.
Establish the Cash Boundary Before Entering Transactions
Define which bank accounts, entities and currencies the forecast covers before calculating opening cash. A model can reconcile perfectly and still mislead management if its starting balance includes money unavailable to the operation being assessed.
Use a reconciled opening cash balance
Start with funds available at the beginning of the first forecast week. Reconcile bank information with the accounting records and identify transactions in transit.
The treatment of outstanding payments must be consistent. If an issued payment has already reduced opening cash, do not subtract it again when it clears. If opening cash still includes the money, include the expected clearing payment in the forecast. Apply the same logic to deposits. Counting a receipt in both places overstates liquidity.
Document the cutoff alongside the model: accounts and legal entities included, the date and time of the opening balance, treatment of uncleared payments and deposits, restricted balances excluded, and the reporting currency.
Choose a consistent weekly convention
The supplied template uses Monday-through-Sunday weeks, with columns labeled by the Monday start date. A different convention can work, but every supporting schedule must use it consistently. A customer collection recorded in a Friday-ending schedule cannot be combined mechanically with payroll recorded in a Sunday-ending schedule. The first forecast week should follow the opening-balance cutoff without a gap or overlap.
Assemble the Supporting Schedules
A bottom-up forecast uses detailed operating information, while a top-down forecast relies more heavily on historical patterns and broader assumptions. Gathering granular information generally requires coordination across functions such as finance, human resources and other business units.[4]
| Input | Starting evidence | Judgment required |
|---|---|---|
| Opening cash | Bank balances and reconciliations | Which funds are unrestricted and available? |
| Existing receivables | Open invoice listing and collection notes | When will each material customer actually pay? |
| Future customer receipts | Orders, billing schedules and sales forecasts | When will activity become an invoice, then cash? |
| Supplier payments | Accounts payable aging and payment runs | Which payments are scheduled, committed or under negotiation? |
| Payroll | Payroll calendar and funding instructions | When are wages, deductions and employer costs funded? |
| Taxes | Tax payment schedules | What amounts and settlement dates apply? |
| Capital expenditure | Contracts and project milestones | When are deposits and final payments due? |
| Debt service | Loan schedules and lender notices | What principal, interest and fees will be paid? |
Assign an owner to each schedule. A named person should be able to explain the amount, expected settlement date and uncertainty behind a material input. Keep the weekly forecast concise, but retain the supporting detail: an aggregate supplier-payment number should be traceable to the payment run that produced it.
Forecast Customer Collections Without Double Counting Revenue
Customer collections deserve particular attention because an apparently small timing change can materially alter the lowest cash balance.
For large or uncertain invoices, record the customer and invoice identifier, outstanding collectible amount, contractual due date, expected receipt date, dispute status, collection owner and the evidence supporting the expected payment date. The due date is a starting point; a promised payment date or known customer payment run may provide better evidence of actual timing.
Do not automatically move every overdue invoice into the first forecast week. That creates a cash expectation without establishing a collection event.
Collections from opening receivables + collections from future billings + cash sales = customer cash receipts
Each transaction should enter the model through only one route. For later weeks, a business may use historical collection patterns to estimate receipts from future billings. Keep those assumptions separate from invoice-specific estimates so that a customer moving from forecast billing into actual receivables is not counted twice.
For card or marketplace receipts, determine whether the forecast uses gross customer payments or net deposits after fees. Either basis can work, but the treatment must be consistent. If the receipt already excludes processing fees, subtracting those same fees again as a separate payment understates cash.
A disputed invoice, expected asset sale or pending tax refund should have a documented assumption behind its inclusion. A probability-weighted receipt may help estimate an average outcome, but the bank account will experience the actual settlement. A critical payment cannot be funded with an average of several possible receipt outcomes.
Calculate Cash, Buffer Headroom and Funding Needs Separately
Closing cash = Opening cash + Nonfinancing receipts − Cash payments + New financing receipts
The next week starts with the previous week's closing cash. The template then calculates several distinct measures.
Set the operating buffer deliberately
The minimum operating cash balance should reflect the business's payment requirements, collection uncertainty and ability to obtain funds in time. Consider payments that cannot be delayed without disrupting operations, concentration in a small number of large receipts, the time required to approve and settle a borrowing, differences between daily cash needs and weekly reporting, and restrictions affecting transfers between accounts or entities.
The template's $50,000 buffer is an illustrative input. It is not an industry standard.
Do not double count borrowing capacity
If a planned borrowing is included in cash receipts, remaining undrawn credit must reflect that borrowing. Otherwise the model counts the same funding once as cash and again as available credit. The workbook deliberately leaves remaining credit availability as a separately verified input. It does not infer availability from a headline facility limit or automatically update it when borrowing changes.
Worked Example: The Same Final Cash Balance Can Hide a Funding Gap
The supplied workbook starts with opening unrestricted cash of $120,000, minimum operating cash of $50,000, no new borrowing or equity, a base collection schedule, and a downside schedule that moves $60,000 from week three to week five. Other receipt and payment assumptions are unchanged between the two scenarios.
| Cash-flow item | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |
|---|---|---|---|---|---|
| Base customer collections | 90 | 100 | 110 | 120 | 130 |
| Downside customer collections | 90 | 100 | 50 | 120 | 190 |
| Total cash payments | 110 | 100 | 155 | 115 | 110 |
| Base closing cash | 100 | 100 | 55 | 60 | 80 |
| Downside closing cash | 100 | 100 | (5) | 0 | 80 |
| Minimum operating cash | 50 | 50 | 50 | 50 | 50 |
| Downside gap to operating buffer | 0 | 0 | 55 | 50 | 0 |
Amounts are in USD thousands. The base case reaches its lowest closing cash balance of $55,000 in week three, leaving only $5,000 above the operating buffer. When the receipt moves, week-three projected cash falls to negative $5,000. That represents an unfunded requirement; it does not imply the business can overdraw its bank account.
Two different funding questions now arise. How much is needed to avoid negative week-end cash? $5,000 in week three. How much is needed to preserve the selected operating buffer? $55,000 in week three. Those are different targets, and management should know which one a proposed financing action addresses.
By week five the delayed receipt arrives and both scenarios return to the same $80,000 closing balance. Both also finish week 13 with $150,000. The unchanged final balance does not resolve the earlier shortage. A business must fund the intervening obligations before reaching the later recovery.
Connect the shortfall to a feasible action
The model identifies the timing and amount of the problem. The response requires separate evidence. Potential actions might include confirming an earlier customer payment, changing the timing of an approved capital purchase, negotiating a supplier payment schedule or drawing an available facility.
For each proposed action, record the expected cash effect, earliest achievable settlement date, person responsible, approval or contractual condition, and status with supporting evidence. A forecast should distinguish a committed action from a management intention.
Add a Daily View When Weekly Balances Are Too Coarse
A positive week-end balance does not establish that every payment during that week can be funded. Where large payroll or tax payments fall early in a week and major receipts arrive late, a daily schedule for the affected weeks will show whether the intra-week position holds.
Roll the Forecast Forward Without Losing Accountability
How to roll the supplied Excel workbook
On the Inputs worksheet:
- Save a dated copy before making changes.
- Copy columns F:Q into E:P as values only for rows 12:14, 16:23, 25:26 and 28.
- Enter the new week-13 assumptions in column Q for those rows.
- Advance the first-week date in E4 by seven days.
- Replace opening cash in E5 with reconciled actual closing cash.
- Revise collection timing, payment commitments and remaining credit availability.
Do not copy over the active-collection formulas in row 11 or the date formulas in row 10. Changing the date alone does not roll the underlying assumptions; it merely relabels the old cash flows with new dates. The Variance worksheet has its own fixed historical date and input values, so changing the active forecast case does not rewrite that historical comparison.
Explain Forecast Variances in Cash Terms
Variance analysis compares actual figures with forecast or budget figures. Differences can arise from timing changes, recurring changes or one-off items.[6] For cash management, the explanation should also establish what happens next.
| Variance type | Meaning | Forecast response |
|---|---|---|
| Timing | The amount is expected in a different period | Move it to a supported new date |
| Amount | The receipt or payment differs from the original estimate | Change the amount and assess future effects |
| Recurring change | The underlying operating assumption has changed | Update the remaining affected weeks |
| One-off item | An isolated receipt or payment was omitted or unexpected | Add the item and check for related obligations |
| Scope or classification | Actuals and forecast do not cover the same cash flows | Reconcile the basis before interpreting performance |
A favorable payment variance does not necessarily represent a saving. If the invoice remains payable, the cash benefit may reverse in a later week.
Receipt and payment errors can also offset each other. A model that overestimates both collections and payments by similar amounts may produce an accurate closing balance for the wrong reasons. Review material receipt and payment categories separately before concluding that forecasting quality has improved. The workbook returns "n.a." when the prior forecast amount is zero, because dividing by zero does not produce a meaningful percentage comparison; the dollar impact remains visible.
Stress-Test the Cash Drivers That Could Change the Decision
Scenarios should test plausible changes in the business's cash flows and the actions available to mitigate them. Short-term cash forecasting guidance emphasizes identifying funding shortfalls and evaluating scenarios and mitigating actions.[5]
The supplied downside case changes customer collection timing only. It is a focused sensitivity, not a comprehensive business downside. For a broader assessment, consider separate saved cases addressing slower collections across the whole receivables book, the loss or delay of a concentrated customer, an unplanned payment such as a tax assessment or legal settlement, a supplier tightening payment terms, and a facility becoming unavailable when it was assumed to be drawable.
Decide When Excel Needs Additional Controls or Automation
A spreadsheet remains appropriate for many businesses, provided the model has a single owner, a documented change history and protection on formula cells. Consider additional controls or a dedicated treasury system when multiple entities or currencies are involved, when bank data must be imported daily, when several people edit the same file, or when covenant reporting depends on the output.
FAQ
Can a profitable company still need a 13-week cash flow forecast?
Yes. Profit is recognized when revenue is earned and expenses are incurred, while cash depends on settlement timing. A growing, profitable business can consume cash through receivables, inventory and capital spending before customer payments arrive.
Should unused credit be included in opening cash?
No. Opening cash should contain unrestricted bank balances. Undrawn credit is a potential funding source subject to the facility's conditions and should be shown separately, as the supplied workbook does.
Should a delayed receipt be moved automatically into the next week?
Only when evidence supports the new date. Moving an overdue receipt forward one week at a time produces a forecast that is continuously wrong in the same direction. Record the reason and the supporting evidence for the revised date.
How should a receipt expected after week 13 be handled?
Exclude it from the 13-week columns and note it separately. A receipt outside the horizon cannot fund an obligation inside it, and including it would understate the near-term requirement.
Is the lowest closing cash balance the same as the funding requirement?
Not necessarily. The lowest balance answers how far cash falls. The funding requirement depends on which target management intends to hold: avoiding negative cash, or preserving the operating buffer. The workbook reports both.
Can weeks be added together to produce monthly cash totals?
Weekly columns rarely align to calendar months, so a simple sum will straddle month boundaries. Use the weekly model for liquidity decisions and reconcile to monthly reporting separately rather than treating four weeks as a month.
- Association of Corporate Treasurers, "Cash Flow Forecasting: The Bedrock of Treasury," accessed October 2026. hub.treasurers.org
- IFRS Foundation, "IAS 7 Statement of Cash Flows," accessed October 2026. ifrs.org
- Office of the Comptroller of the Currency, "Asset-Based Lending," Comptroller's Handbook. occ.gov
- J.P. Morgan, "How to Create Cash Flow Forecasts and Projections," accessed October 2026. jpmorgan.com
- Association of Corporate Treasurers, "Cash Forecasting," accessed October 2026. treasurers.org
- Association of Corporate Treasurers, "Variance Analysis," Treasurers' Wiki, accessed October 2026. wiki.treasurers.org
Financial Advisor vs Financial Planner: What’s the Difference and Which Do You Need?
Understanding your financial goals is one thing—figuring out who can help you achieve them is another. With terms like "financial advisor" and "financial planner" often used interchangeably, it’s no surprise that many people are confused about which professional they...
How the Federal Reserve Regulates Interest Rates: A Deep Dive for Finance Professionals
Interest rates are the backbone of modern finance. They influence the cost of capital, consumer demand, investment strategies, and even global capital flows. At the center of this system stands the U.S. Federal Reserve (the Fed), wielding substantial influence over...
Building a Career Path in Finance: Opportunities, Challenges, and Strategies for Success
A career in finance offers one of the broadest and most dynamic ranges of opportunities in today’s professional landscape. From investment banking and wealth management to corporate finance and financial technology, the field encompasses diverse roles that appeal to...
Navigating the New U.S. Tax Landscape
As of mid‑2025, several sweeping tax reforms—primarily consolidated under the One Big Beautiful Bill Act (OBBBA)—have reshaped the U.S. tax code. These changes introduce both permanent updates and temporary incentives, creating new strategic opportunities as well as...
Strategic Financial Planning for a Changing Retirement Landscape
Financial planners today face a rapidly shifting environment. Longer life expectancies, rising healthcare costs, and inflationary pressures mean that retirement planning has become more complex than ever. Clients are looking for clear strategies to safeguard their...
