TemplatesType: Spreadsheet/Log8 min readUpdated May 2026By Julian Vance

13 Week Cash Flow Forecast Template Excel

Having a well-structured 13 week cash flow forecast template excel 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 13 Week Cash Flow Forecast Template Excel 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 13 Week Cash Flow Forecast Template Excel?

A 13 week cash flow forecast template excel 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.

Spreadsheet/Log Preview

Template Registry

Standard Operating Procedure

Registry ID: TR-13-WEEK-

13-Week Cash Flow Forecast System

1. System Overview & Purpose

Purpose: To provide a granular, actionable 13-week rolling cash flow forecast, enabling proactive management of liquidity, identification of potential shortfalls, and optimization of cash reserves.

Scope: This system tracks projected cash inflows and outflows on a weekly basis, categorized by key business drivers. It is designed for businesses requiring detailed visibility into their short-term cash position.

Update Cadence: Weekly. Forecasts are updated every Friday to reflect the preceding week's actuals and the coming 13 weeks' projected movements.

2. Data Structure & Column Definitions Table

This table defines the structure and content of the Cash Flow Master Data sheet.

Field Name	Data Type	Description	Validation Rules
`Category`	Text	Broad classification of cash movement (e.g., Revenue, Payroll, Operating Exp)	Dropdown: Revenue, Sales, Collections, Payroll, Rent, Utilities, Marketing, CAPEX, Debt Service, Other Inflow, Other Outflow
`Sub-Category`	Text	Specific item within a Category (e.g., Product Sales, Software Subscriptions)	Free Text (dependent on `Category`)
`Item Description`	Text	Detailed description of the specific cash flow item.	Free Text
`Week 1 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 1.	Number (>= 0 for inflows, <= 0 for outflows or use sign convention)
`Week 2 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 2.	Number
`Week 3 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 3.	Number
`Week 4 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 4.	Number
`Week 5 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 5.	Number
`Week 6 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 6.	Number
`Week 7 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 7.	Number
`Week 8 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 8.	Number
`Week 9 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 9.	Number
`Week 10 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 10.	Number
`Week 11 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 11.	Number
`Week 12 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 12.	Number
`Week 13 (YYYY-MM-DD)`	Number (Currency)	Projected cash inflow/outflow for Week 13.	Number
`Notes`	Text	Contextual information for the specific cash flow item.	Free Text

Note: Date format YYYY-MM-DD will dynamically update based on the current forecast period.

3. Complete Master Data Table / Tracker

This sheet serves as the primary data input and storage for the forecast.

Category	Sub-Category	Item Description	Week 1 (2023-10-27)	Week 2 (2023-11-03)	Week 3 (2023-11-10)	Week 4 (2023-11-17)	Week 5 (2023-11-24)	Week 6 (2023-12-01)	Week 7 (2023-12-08)	Week 8 (2023-12-15)	Week 9 (2023-12-22)	Week 10 (2023-12-29)	Week 11 (2024-01-05)	Week 12 (2024-01-12)	Week 13 (2024-01-19)	Notes
Revenue	Product Sales	Q4 Sales - Client A	50,000	60,000	55,000	70,000	75,000	80,000	78,000	85,000	90,000	95,000	88,000	92,000	98,000	Typical holiday season uplift.
Revenue	Subscriptions	Monthly SaaS Revenue	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	15,000	Consistent monthly billing.
Collections	Accounts Receivable	AR Collection - Invoice #12345	25,000	0	0	0	0	0	0	0	0	0	0	0	0	Payment expected on Nov 1st.
Payroll	Salaries	Bi-weekly Payroll	-30,000	-30,000	-30,000	-30,000	-30,000	-30,000	-30,000	-30,000	-30,000	-30,000	-30,000	-30,000	-30,000	Standard payroll cycle.
Operating Exp	Rent	Office Rent - November	-10,000	0	0	0	0	0	0	0	0	0	0	0	0	Due Nov 1st.
Operating Exp	Utilities	Electricity - October usage	-2,500	0	0	0	0	0	0	0	0	0	0	0	0	Due Nov 15th.
Operating Exp	Marketing	Digital Ad Spend	-5,000	-6,000	-5,500	-7,000	-7,500	-8,000	-7,800	-8,500	-9,000	-9,500	-8,800	-9,200	-9,800	Variable based on campaign performance.
CAPEX	Equipment Purchase	New Server Investment	0	0	-15,000	0	0	0	0	0	0	0	0	0	0	Approved Q4 capital expenditure.
Debt Service	Loan Payment	Term Loan Principal & Interest	-5,000	-5,000	-5,000	-5,000	-5,000	-5,000	-5,000	-5,000	-5,000	-5,000	-5,000	-5,000	-5,000	Monthly payment.
Other Outflow	Vendor Payment	Supplier Invoice #INV789	0	0	0	-8,000	0	0	0	0	0	0	0	0	0	Payment due Nov 20th.

4. Key Formulas & Calculation Logic

Sheet: Summary Dashboard

Cell B3 (Opening Balance): =IFERROR(INDEX('Cash Flow Master Data'!$D$2:$P$1000,MATCH("Opening Balance",'Cash Flow Master Data'!$B$2:$B$1000,0),1),0) This formula assumes an "Opening Balance" row exists in the Master Data. If not, it defaults to 0. Adjust range $D$2:$P$1000 to match the actual number of weeks.

Cell B5 (Total Inflows - Week 1): =SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Revenue",'Cash Flow Master Data'!D2:D1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Sales",'Cash Flow Master Data'!D2:D1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Collections",'Cash Flow Master Data'!D2:D1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Other Inflow",'Cash Flow Master Data'!D2:D1000) Adjust column reference D2:D1000 for subsequent weeks.

Cell B6 (Total Outflows - Week 1): =SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Payroll",'Cash Flow Master Data'!D2:D1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Operating Exp",'Cash Flow Master Data'!D2:D1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"CAPEX",'Cash Flow Master Data'!D2:D1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Debt Service",'Cash Flow Master Data'!D2:D1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Other Outflow",'Cash Flow Master Data'!D2:D1000) Adjust column reference D2:D1000 for subsequent weeks. Note: The SUMIF will correctly sum negative values for outflows.

Cell B8 (Net Cash Flow - Week 1): =B5+B6 Calculates the net change in cash for the week.

Cell B9 (Ending Balance - Week 1): =B3+B8 Calculates the projected cash balance at the end of the week.

For Subsequent Weeks (e.g., Week 2):

Cell C3 (Opening Balance - Week 2): =B9 The closing balance of the previous week becomes the opening balance of the current week.

Cell C5 (Total Inflows - Week 2): =SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Revenue",'Cash Flow Master Data'!E2:E1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Sales",'Cash Flow Master Data'!E2:E1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Collections",'Cash Flow Master Data'!E2:E1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Other Inflow",'Cash Flow Master Data'!E2:E1000) Adjust column reference E2:E1000 for Week 2.

Cell C6 (Total Outflows - Week 2): =SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Payroll",'Cash Flow Master Data'!E2:E1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Operating Exp",'Cash Flow Master Data'!E2:E1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"CAPEX",'Cash Flow Master Data'!E2:E1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Debt Service",'Cash Flow Master Data'!E2:E1000)+SUMIF('Cash Flow Master Data'!$A$2:$A$1000,"Other Outflow",'Cash Flow Master Data'!E2:E1000) Adjust column reference E2:E1000 for Week 2.

Cell C8 (Net Cash Flow - Week 2): =C5+C6

Cell C9 (Ending Balance - Week 2): =C3+C8

These formulas are then dragged across to cover all 13 weeks.

Total Net Cash Flow (All Weeks): =SUM(B8:N8) (assuming B8:N8 are Net Cash Flow for Week 1 to Week 13)

Total Ending Cash Balance (Week 13): =N9 (assuming N9 is Ending Balance for Week 13)

5. Summary KPI Dashboard

This dashboard provides a visual overview of the 13-week cash flow.

Metric	Week 1 (2023-10-27)	Week 2 (2023-11-03)	Week 3 (2023-11-10)	...	Week 13 (2024-01-19)
Opening Balance	$50,000	$63,000	$73,000	...	$165,000
Total Inflows	$75,000	$75,000	$70,000	...	$113,000
Total Outflows	($52,000)	($65,000)	($62,000)	...	($77,000)
Net Cash Flow	$23,000	$10,000	$8,000	...	$36,000
Ending Balance	$73,000	$83,000	$91,000	...	$201,000
Minimum Weekly Balance	$73,000	$73,000	$73,000	...	$73,000
Days of Runway (Est.)	50 days	55 days	60 days	...	80 days

Note: "Days of Runway (Est.)" requires an assumption of average daily burn rate or fixed operating expenses.

6. Standard Operating Workflow

Weekly Update Trigger: Every Friday, the designated owner (e.g., Finance Manager) initiates the weekly update process.
Data Entry - Actuals vs. Forecast (Optional but Recommended):
- If tracking actuals is a requirement, create a separate sheet or section to record actual cash movements for the completed week.
- Compare actuals against the previous week's forecast. Identify significant variances and document reasons in the Notes column of the Cash Flow Master Data or a separate variance analysis sheet.
Forecast Adjustment - Rolling 13 Weeks:
- Shift Weeks: All data in the Cash Flow Master Data table is shifted one column to the left. The data from Week 1 becomes the baseline for Week 2, Week 2 for Week 3, and so on. The last column (Week 13) is effectively cleared.
- Update Week 1: The current week's column (which is now Week 1 after the shift) is populated with updated projections for the upcoming 13-week period. This involves:
  - Revisiting Existing Items: Reviewing and adjusting existing entries based on new information (e.g., updated sales pipeline, confirmed payment dates, delayed expenses).
  - Adding New Items: Incorporating any new anticipated cash inflows or outflows that were not previously forecast.
  - Removing Irrelevant Items: Deleting entries that are no longer relevant (e.g., a one-time expense that has passed).
Review and Validation:
- Formula Check: Ensure all formulas on the Summary Dashboard are correctly referencing the Cash Flow Master Data and have been updated for the new week's column.
- Data Integrity: Perform a spot check of key entries to ensure accuracy and adherence to definitions.
- Sanity Check: Review the Summary Dashboard for any obvious anomalies (e.g., an unexpectedly large negative cash balance, significant unexplained fluctuations).
Distribution & Communication:
- Save the updated spreadsheet.
- Communicate the key takeaways and any critical liquidity concerns to relevant stakeholders (e.g., CEO, Head of Operations).
Archiving (Optional): Consider a process for archiving previous forecast versions for historical analysis.

Official Standardized Document

Download this Template

View all