13-week rolling cash flow forecast — treasury team abandoned their spreadsheet

Started by Ayesha Okonkwo · 1 year, 3 months ago · 1 reply · 4 views

Ayesha Okonkwo Participant

1 year, 3 months ago

We built a 13-week rolling cash flow forecast in Fabric Plan for our treasury team. Planning sheet for cash flow line items (receipts, disbursements, FX, intercompany), Intelligence sheet for the waterfall chart and variance vs last week's forecast. The rolling nature means the model auto-extends by one week each Sunday via a scheduled refresh. Three months in and the treasury team has abandoned their spreadsheet entirely.

2 Replies

Sort

Sofia Martínez

Budget & Forecast Analyst · IberiaFin · 1 year ago

This is exactly what I want to build for our firm. How did you model the auto-extension? Is the rolling logic in the semantic model or in the Planning sheet itself?

Up

0

Ayesha Okonkwo

Corporate Finance Manager · Meridian Bank · 1 week, 1 day ago

The rolling window is in the semantic model — a DATE table with a dynamic 13-week relative filter. The Planning sheet just maps to whatever the current active 13 weeks are. When the semantic model refreshes, the window shifts automatically.

Up

0