TemplatesType: Standard Operating Procedure8 min readUpdated May 2026By Julian Vance

12 Week Cash Flow Forecast Template

Having a well-structured 12 week cash flow forecast template is the single most important step you can take to ensure financial health, tracking metrics, and auditing processes. Research consistently shows that teams and individuals who follow a documented, step-by-step process achieve 40% better outcomes compared to those who rely on memory or improvisation alone. Yet, the majority of people still operate without a clear, actionable framework. This comprehensive 12 Week Cash Flow Forecast Template template bridges that gap — giving you a battle-tested, ready-to-use guide that covers every critical step from start to finish, so nothing falls through the cracks.

What is a 12 Week Cash Flow Forecast Template?

A 12 week cash flow forecast template is a standardized document used to streamline processes, ensure consistency, and maintain compliance within the finance-accounting domain. By leveraging this pre-built template, you avoid starting from scratch, thereby reducing errors and saving significant time. Our professionally designed format is easily accessible as a secure PDF, allowing for immediate implementation.

Complete SOP & Checklist

Template Registry

Standard Operating Procedure

Registry ID: TR-12-WEEK-

12-Week Rolling Cash Flow Forecast & Liquidity Management System

1. System Overview & Purpose

Purpose

To provide institutional-grade, weekly rolling visibility into operational liquidity, capital burn rate, and runway risk over a 90-day horizon. This model differentiates between invoiced accounts receivable (AR) and projected sales, as well as committed accounts payable (AP) and discretionary overhead, ensuring treasury management decisions are based on cash-basis realities rather than accrual assumptions.

Scope

Frequency: Weekly roll-forward (actuals locked, forecast horizon pushed out by 1 week).
Granularity: Direct cash flow method (cash receipts minus cash disbursements).
Users: Chief Financial Officer (CFO), Treasury Manager, Controller, and FP&A Lead.

Update Cadence

Every Monday, 09:00: Reconcile prior week’s ending bank balance against actual cash inflows and outflows.
Every Friday, 17:00: Update rolling forecast assumptions based on sales pipeline velocity and upcoming vendor payment schedules.

2. Data Structure & Column Definitions Table

Field Name	Data Type	Validation Rules / Format	Description
`Line_Item_ID`	String (Alpha-Numeric)	Primary Key, Unique, e.g., `REV-001`, `EXP-042`	Unique identifier for the cash flow category.
`Category`	Dropdown	`Operating`, `Financing`, `Investing`	High-level cash flow statement classification.
`Sub_Category`	Dropdown	`AR Collections`, `Projected Sales`, `Payroll`, `COGS`, `Rent`, `Debt Service`, `Tax`, `CapEx`	Granular operational grouping for variance analysis.
`Counterparty`	Text	Free text (Customer/Vendor Name)	Entity paying or receiving funds.
`Probability_Weight`	Percentage	`0%` to `100%` (Step of 10%)	Likelihood of cash movement (100% for committed invoices/bills).
`W1` through `W12`	Currency	Numeric, 2 decimal places, Format: `$#,##0`	Projected net cash flow for Weeks 1 through 12.
`Is_Actual`	Boolean	`TRUE` or `FALSE`	Flags whether the column represents historical reconciled actuals (`TRUE`).

3. Complete Master Data Table / Tracker

Note: Amounts are denominated in USD thousands. W1 represents the current operating week.

Line_Item_ID	Category	Sub_Category	Counterparty	Prob	W1 (Act)	W2	W3	W4	W5	W6	W7	W8	W9	W10	W11	W12
REV-001	Operating	AR Collections	Enterprise Clients	100%	$450	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
REV-002	Operating	AR Collections	Mid-Market Corp	100%	$120	$85	$0	$0	$0	$0	$0	$0	$0	$0	$0	$0
REV-003	Operating	Projected Sales	Pipeline (Stage 4)	75%	$0	$50	$75	$100	$120	$150	$150	$150	$200	$200	$250	$250
REV-004	Investing	Asset Sale	Equipment Disposal	90%	$0	$0	$25	$0	$0	$0	$0	$0	$0	$0	$0	$0
EXP-001	Operating	Payroll	Internal Staff	100%	($320)	$0	($320)	$0	($320)	$0	($320)	$0	($320)	$0	($320)	$0
EXP-002	Operating	Payroll	Contractor / T&M	100%	($45)	($45)	($45)	($45)	($45)	($45)	($45)	($45)	($45)	($45)	($45)	($45)
EXP-003	Operating	COGS	Tier-1 Suppliers	100%	($110)	($90)	($105)	($115)	($120)	($125)	($130)	($130)	($140)	($140)	($150)	($150)
EXP-004	Operating	Rent	Corporate HQ	100%	($35)	$0	$0	($35)	$0	$0	($35)	$0	$0	($35)	$0	$0
EXP-005	Financing	Debt Service	Term Loan Principal	100%	$0	($50)	$0	$0	($50)	$0	$0	($50)	$0	$0	($50)	$0
EXP-006	Operating	Tax	State & Federal	100%	$0	$0	($80)	$0	$0	$0	$0	$0	($80)	$0	$0	$0

4. Key Formulas & Calculation Logic

1. Weighted Cash Flow Projection (Applied per cell, factoring in probability)

=SUMIFS($F$2:$Q$11, $E$2:$E$11, E14) * $E15 (Used to adjust gross pipeline numbers by historical conversion weights).

2. Total Cash Inflows (Per Week)

=SUMIFS($F$2:$F$11, $B$2:$B$11, "Operating", $C$2:$C$11, "*Collections*") + SUMIFS($F$2:$F$11, $B$2:$B$11, "Operating", $C$2:$C$11, "*Sales*") (Replicated across columns W1 through W12).

3. Total Cash Outflows (Per Week)

=SUM(F$2:F$11) - F$14 (Calculates aggregate outflows by subtracting inflows from the net range sum, format absolute values for reporting).

4. Net Weekly Cash Flow

=CASH_INFLOW_ROW - CASH_OUTFLOW_ROW (Calculates net burn or net generation per weekly period).

5. Ending Cash Balance (Liquidity Position)

=PREVIOUS_WEEK_ENDING_BALANCE + CURRENT_WEEK_NET_CASH_FLOW (Roll-forward formula establishing the baseline for the subsequent week).

5. Summary KPI Dashboard

Metric Identifier	Metric Name	Calculation Logic / Formula	W1 Value	W12 Value	Target / Threshold
KPI-01	Beginning Cash Balance	`=Previous_Week_Ending_Cash`	`$1,250`	`$715`	`>= $500` (Safety Floor)
KPI-02	Total Cash Inflows	`=SUM(Inflow_Rows)`	`$570`	`$250`	N/A (Run-rate tracking)
KPI-03	Total Cash Outflows	`=SUM(Outflow_Rows)`	`($510)`	`($515)`	Strict budget alignment
KPI-04	Net Cash Flow	`=Inflows - Outflows`	`$60`	`($265)`	Positive monthly run-rate
KPI-05	Ending Cash Balance	`=Beginning + Net`	`$1,310`	`$450`	> $500 (Minimum Liquidity)
KPI-06	Runway (Weeks)	`=Ending_Cash / ABS(Average_Weekly_Burn)`	`12.8 wks`	`4.4 wks`	`>= 13 Weeks`

6. Standard Operating Workflow

[1. Actuals Reconciliation] ➔ [2. Pipeline & AR Update] ➔ [3. Variance Review] ➔ [4. Executive Sign-Off]
      (Monday 09:00)              (Friday 15:00)           (Friday 16:30)           (Friday 17:00)

Reconcile Actuals (Monday AM): Lock the prior week's column (W1). Input bank statement closing balances into the Ending Cash balance row. Calculate the cash variance (Actual vs. Prior Forecast).
Update Receivables & Payables (Friday PM): Clear collected AR items from the master schedule. Update upcoming AP payment dates based on current vendor credit terms (Net 30/60).
Adjust Sales Probabilities (Friday PM): Review the sales pipeline (REV-003). Adjust probabilities (Probability_Weight) based on deal progression through CRM stages.
Evaluate Minimum Liquidity Threshold (Friday PM): Check KPI-05 (Ending Cash Balance) across all 12 periods. If any week drops below the $500,000 safety floor, trigger the Liquidity Defense Protocol (defer discretionary CapEx, accelerate collections outreach, or draw on credit facilities).
Roll Forward the Model (Weekly Cycle): Shift all columns left by one week. Drop the historical actual column, rename W2 to W1, and open a fresh W12 projection column populated with baseline recurring assumptions.

Official Standardized Document

Download this Template

View all