Power BI Cash Flow Template: 13-Week Forecast Guide

Build a professional Power BI cash flow template. Track weekly inflows, outflows, and 13-week rolling forecasts with DAX measures and governed semantic…

What a 13-Week Cash Flow Forecast Actually Measures

The 13-week cash flow forecast is a rolling, week-by-week projection of cash inflows, outflows, and ending cash balance across a 13-week window — roughly one quarter. Finance teams use it as the primary liquidity management tool because 13 weeks is short enough to forecast with reasonable accuracy and long enough to identify funding gaps before they become crises.

It is not a P&L. It is not an annual budget. It focuses exclusively on cash timing — when money enters the account and when it leaves — independent of accrual accounting treatment.

Core Structure of a Power BI Cash Flow Template

A production-ready Power BI cash flow template organizes data across three layers: the data layer (your semantic model), the calculation layer (DAX measures), and the visual layer (the dashboard itself).

Data Layer: Semantic Model Requirements

The semantic model must include at minimum:

Fact table: Cash transactions — one row per transaction, with date, amount, category, direction (inflow/outflow), and entity
Dimension table: Calendar — a full date table with week number, fiscal period, and forecast week flag
Dimension table: Category — cash flow categories mapped to operating, investing, and financing classifications
Forecast table — planned weekly cash movements, keyed to the same calendar dimension

Calculation Layer: Essential DAX Measures

Define these measures before building any visuals:

Total Inflows =
CALCULATE(
    SUM(CashTransactions[Amount]),
    CashTransactions[Direction] = "Inflow"
)

Total Outflows =
CALCULATE(
    SUM(CashTransactions[Amount]),
    CashTransactions[Direction] = "Outflow"
)

Net Cash Position =
[Total Inflows] - [Total Outflows]

Forecast Variance =
[Net Cash Position] - [Forecasted Net Cash]

Ending Cash Balance =
CALCULATE(
    [Opening Balance] + [Net Cash Position],
    FILTER(
        ALL('Calendar'),
        'Calendar'[WeekNumber] <= MAX('Calendar'[WeekNumber])
    )
)

Visual Layer: Dashboard Layout for the 13-Week Template

Section	Visual Type	Primary Purpose
Cash Position Summary	KPI cards + waterfall chart	Snapshot of current week ending balance vs. forecast
13-Week Rolling View	Line chart with forecast band	Trend of actual vs. projected cash over the full window
Variance Detail	Matrix / table with conditional formatting	Week-by-week plan-to-actual variance by category

KPI Cards: What to Show Above the Fold

Opening Cash Balance — cash on hand at the start of the current week
Total Inflows (Week) — sum of all cash received in the current week
Total Outflows (Week) — sum of all cash paid out in the current week
Net Cash Position (Week) — inflows minus outflows for the current week
Forecast Variance (Week) — actual net cash minus planned net cash

Connection mechanics, step by step: connecting to data in Power BI Desktop, using an Excel workbook on OneDrive for treasury files, and scheduled refresh so Monday opens on current numbers.

Connecting Your Data Source to the Template

Use DirectQuery when your cash data lives in a live ERP and you need real-time refresh. Use Import mode for flat files or warehouse snapshots updated on a defined cadence. Define Row-Level Security (RLS) before you publish to restrict which rows a given user sees based on their role.

Plan-to-Actual Variance: The Metric That Drives Action

Plan-to-actual variance is the primary decision metric. A variance above +10% signals accelerated collections or delayed payments. A variance below -10% requires immediate action. Build a drill-through page showing individual transactions driving the gap to reduce decision latency.

Where Power BI Cash Flow Dashboards Fail

No single version of the truth: Fragmented source tables that aren't reconciled.
Stale forecast data: Forecast tables that aren't updated on a fixed cadence.
Flat tables: Using wide tables instead of a star schema, leading to double-counting.
No governance: Lack of RLS and undocumented metric ownership.

Extending the Template: Weekly vs. Monthly Views

Build a second page that aggregates the same semantic model to monthly totals for board reporting. Use a page-level filter on the Calendar dimension to switch grains rather than creating duplicate measures.

For the wider comparison see custom dashboard vs. template and Power BI for finance teams; if you take the template route, the after-download guide gets it running the same day.

Template vs. Custom Build: When Each Is the Right Choice

A template covers 80% of standard requirements and is production-ready immediately. A custom build is only justified for complex multi-entity consolidation, multi-currency needs, or proprietary ERP integrations requiring custom connectors.

Conclusion

Build the 13-week cash flow dashboard in three layers: a star-schema semantic model, clearly labeled DAX measures, and a three-section visual layout. The template eliminates manual assembly and allows the finance team to focus on liquidity analysis.

What is a Power BI cash flow template?

A Power BI cash flow template is a pre-built dashboard file (.PBIX) that includes a structured semantic model, pre-written DAX measures, and formatted visuals for tracking weekly cash inflows, outflows, net position, and plan-to-actual variance. Connect it to your own data source and publish — no need to build the model from scratch.

How does a 13-week cash flow forecast work in Power BI?

The 13-week forecast uses a rolling calendar dimension to display 13 consecutive weeks of actual and projected cash data side by side. DAX measures calculate the net cash position for each week and compare it against a forecast table. The result is a live view of where your cash balance is heading over the next quarter.

What data sources can I connect to a Power BI cash flow template?

You can connect to Excel or CSV exports from any accounting system, direct SQL database connections, ERP APIs (SAP, Oracle, Microsoft Dynamics), and cloud data warehouses. Use DirectQuery for live ERP connections and Import mode for scheduled refreshes from flat files or warehouses.

What DAX measures does a cash flow dashboard require?

At minimum, your model needs Total Inflows, Total Outflows, Net Cash Position, Forecast Variance, and Ending Cash Balance. Define each measure on the semantic model — not embedded in visuals — so they produce consistent results across every page and filter context.

How do I prevent data discrepancies in a Power BI cash flow dashboard?

Reconcile all source tables before connecting them to Power BI. Use a single calendar dimension table shared across all fact tables. Apply Row-Level Security to restrict data access by role. Document metric ownership — one named person responsible for each source table — and enforce a fixed refresh cadence.

What is the difference between a cash flow dashboard and a P&L dashboard?

A cash flow dashboard tracks when money physically moves in and out of accounts, regardless of when revenue or expenses are recognized. A P&L dashboard tracks accrual-based income and expenses. The two models use different fact tables and calculation logic and should never share measures without explicit reconciliation.