13-Week Cash Flow Forecast Excel Template - Rolling Weekly Cash Flow Model

Description
A 13-week cash flow forecast gives businesses a detailed view of expected cash inflows, cash outflows and closing cash balances on a weekly basis. This 13-Week Cash Flow Forecast Excel Template is designed to help business owners, finance professionals and advisers identify potential cash shortages early, understand short-term liquidity requirements and make better cash management decisions.
The model provides a structured 13-week rolling cash flow forecast using configurable assumptions for sales, customer collection timing, supplier payments, operating expenses and other cash movements.

CUSTOMER COLLECTIONS AND ACCOUNTS RECEIVABLE
Forecast cash receipts based on expected sales and configurable customer collection patterns. The model separates immediate collections from amounts collected one, two and three weeks later.
Opening accounts receivable can also be entered and allocated across the opening weeks of the forecast, allowing existing customer balances to be incorporated into short-term cash planning rather than assuming the business starts with no outstanding receivables.

SUPPLIER PAYMENTS AND ACCOUNTS PAYABLE
Forecast supplier cash payments using configurable supplier payment terms. Opening accounts payable can also be entered and allocated across the opening forecast weeks so existing supplier obligations are reflected in the cash position.

WEEKLY CASH FLOW FORECAST
The model calculates expected weekly cash receipts, cash payments, net cash movement and closing cash balance across the full 13-week forecast period. Each week's closing cash balance automatically becomes the following week's opening cash balance, creating a continuous short-term liquidity forecast.

OPERATING CASH REQUIREMENTS
Include recurring operating expenses together with tax, capital expenditure and other cash payments to build a practical view of expected weekly cash requirements.

MINIMUM CASH BALANCE AND FUNDING GAP
Set a minimum cash threshold and identify when projected cash falls below the required level. The model highlights the first week below the threshold and helps quantify potential funding requirements before a cash shortage occurs.

BASE AND DOWNSIDE SCENARIOS
Compare Base and Downside scenarios to understand how weaker sales or slower customer collections could affect liquidity and cash runway. This allows users to stress-test short-term cash requirements before making financial decisions.

DASHBOARD
A dedicated dashboard summarises key cash flow outputs and provides a clear view of forecast cash performance across the 13-week period.
The model is suitable for businesses requiring a practical short-term cash flow forecasting tool rather than a full three-statement financial model. It can support weekly cash management, liquidity planning, working capital management, cash runway analysis, budgeting and short-term financial planning.
The download includes the Excel financial model together with a separate PDF How-To Guide explaining how to set up, use and interpret the forecast.