Best Practices for Collaborative Financial Forecasting

Most teams treat rolling forecasts like a monthly budget meeting. That’s why they fail. I used to think a rolling forecast was just a budget with more updates. But the best teams use rolling forecasts in a different way. Rolling forecasts are not about repeating the same process every month. They show the next 12–18 months, not just the year. The plan changes as soon as reality changes. When hiring speed, conversion rates, or CAC move, the plan moves with them. Leaders talk about what is true now, not what was approved months ago. Here is what works for me: → Update the forecast every month. If something like pipeline or churn changes fast, refresh those numbers each week. → Focus on the big drivers: price, volume, mix, ramp. Keep the model simple but strong. → Use one source of truth. Actual numbers come in automatically. Variance explains itself (rate vs. volume vs. mix). → Make it easy to see Base, Downside, and Upside in two clicks. → Finance manages the model, but every team owns the drivers they can change. The real change happens in meetings. People stop looking back at last quarter. They start looking forward. Leaders use leading indicators like win rates, cycle time, or backlog health. The plan becomes a range, not a promise. Everyone manages risk, not just numbers. A simple 10-day cadence helps: 1. Days 1–3: Load actuals. 2. Days 4–5: Auto-break variance. 3. Days 6–7: Driver owners update their parts. 4. Day 8: Finance checks and adjusts for changes. 5. Days 9–10: Meet for 45 minutes-make decisions. What makes rolling forecasts fail? → Too much detail, not enough signal. → Treating it like a full budget, not a light-touch update. → No ranges, only point numbers. → Teams not owning their drivers. How “rolling” is your forecast today-0/10 (static) to 10/10 (live, driver-led, with ranges)? What would move you up one notch?

As CEO of Firmbase, I meet with FP&A leaders every single day. Here’s what the top 1% do differently - it comes down to 5 crucial things: 1. Their financial models offer clarity, not just numbers Most FP&A teams build financial models that overwhelm stakeholders with data. They focus on what happened and add a bunch of different metrics. The best FP&A leaders focus on the "why" and "what’s next." They build models that offer context and strategic insights. They guide business leaders through complex questions, turning data into actionable intelligence. Their models don’t just report - they inform. 2. They run continuous planning, not one-off planning cycles Effective FP&A leaders understand that static, annual plans are irrelevant. Business conditions shift rapidly, driven by market dynamics, customer needs, and internal changes. The best strategic finance leaders adopt rolling forecasts and continuously adjust their plans based on real-time data. They use rolling forecasts to proactively identify trends early, keep finance agile, and change direction quickly. 3. They build partnerships with business partners, not just send reports Less effective FP&A leaders focus on sending spreadsheet templates and reacting to requests. Their communication is one-way and often limited to senior leadership. The best FP&A leaders build meaningful relationships across the organization. They understand the business challenges they face and position finance as a trusted partner. Their collaborative approach enhances alignment across business units. 4. They drive strategic decisions, not just share data Most FP&A leaders distribute reports and dashboards with little explanation, assuming the numbers speak for themselves. This approach leaves budget owners to interpret the data on their own. The best FP&A leaders communicate at a different level. They highlight key takeaways and frame insights: - Collaborate using real-time budget variances - Recap reports that spotlight strategic changes - Run scenario analyses to align w/ decision points Every piece of their communication is designed to actively add value, provide clarity, and prompt action. 5. They use modern software, not stick with manual processes Spreadsheets are certainly useful for specific tasks, but can become a roadblock for complex, company-wide planning. The best strategic finance leaders use modern FP&A software to improve planning collaboration, automate data workflows, and enhance scenario modeling. This also frees up their time for strategic work, allowing them to focus on deeper analysis instead of data entry or version control. TAKEAWAY FP&A is no longer just about modeling skills. The best leaders go well beyond number-crunching. They take deliberate actions to drive more informed decisions.

I've worked in high-pressure FP&A teams. Tight deadlines. Constant last-minute changes. Endless data. What kept us sharp? Rituals. Not boring routines. I mean high-impact habits. Repeatable. Purposeful. Designed to bring clarity, focus, and influence. Here are 8 FP&A rituals that helped my teams and can do the same for yours: 1️⃣ FP&A Weekly Monday sync that sets the tone. Latest updates. Quick priorities. Deadlines. Roadblocks. Everyone speaks. Everyone leaves the meeting with focus. 2️⃣ Monthly Review Cycle Standardized process of performance review after the books are closed. Clear reporting calendar. Automated data extraction. Standardized templates. One version of truth. Trends. Gaps. Risks and opportunities. No noise, insights only.   3️⃣ Forecasting Cadence Monthly/quarterly forecast update based on new information. Driver-based flexible models. Input from sales, marketing and operations. Challenge assumptions. Build anti-bias into the process. Retrospective accuracy checks to calibrate models.   4️⃣ Business Partner Meetings Mid-month check-in. What happened, why, and what’s next. Focus on recommendations and actions.   5️⃣ Strategic Review Sessions Quarterly check on long-term goals. Zoom out and look ahead. Big picture topics only. Growth. Cost. Competition. Positioning. Open discussions: what’s working and what’s not.   6️⃣ Budget Workshops Budgeting is not a black-box model. Collaboration. Interaction. Alignment. Ownership. Accountability. Focus on value creation.   7️⃣ Lessons Learned Sessions Look back. Learn fast. Move forward. What worked? What didn’t? Why? No blame. Celebrate wins. Share insights in a “lessons learned library”. 8️⃣ FP&A Hackathon Not just another meeting. Pick a topic. Automation. AI. Dashboards. Process paint points. Bring in IT and data teams. Welcome creative ideas.   Be creative. Experiment with your rituals. Start small. Keep what works. Drop what doesn’t. Shape them to your team. But make them stick. Consistency. Iteration. Engagement. Less chaos. More clarity. Real FP&A influence. That’s how habits turn into impact. Which of these 8 rituals do you already use? Which one would you steal for your team? 👇 Check out the full blog post with pro tips (link in the comments section).

Instead of deciding on a revenue goal and working backwards from there in a spreadsheet to set pipeline and revenue targets, try this instead: 1. Get finance, sales, marketing and customer success in the same room 2. Have each functional leader share their perspective on what a “bottoms up” forecast would look like based on historical performance, reality and specific changes that we can make to improve historical performance 3. Go ahead and model the “top down” scenario on what would be an ideal revenue target and progression towards that goal over the 12 month timeframe 4. Compare the “bottoms up” and “top down” scenario and get clear on the gap 5. Identify what would have to be true to achieve your ideal top down forecast 6. Honestly assess the feasibility of being able to achieve those things based on historical performance and reality  - wanting and hoping for something is not enough to achieve meaningfully different results  7. Take your “bottoms up” model and identify what the GTM teams can do together to make some improvements, place those bets and adjust the forecast accordingly After this exercise, you’ll probably land closer to your “bottoms up” forecast instead of your ideal “top down” model -  but this is likely much closer to what will really happen vs what you want to happen This isn’t about settling for lower goals, it’s about how do we forecast accurately, take reality into account, identify our best bets, place those bets and try to improve results over time in a realistic and sustainable way Bonus - when all GTM teams and finance are all involved in this process together it creates way more alignment, empathy and clarity on what each team is accountable for and how they need to work together to achieve company targets #marketing #b2b #demandgeneration

You and your Finance team just completed the Mona Lisa of budgets. Months of work putting together the most collaborative, top-down, bottom-up budget ever created. Fast forward three weeks... Revenue targets? Missed. Your beautiful budget? Destroyed. Team morale? Tanked. In startups and scale-ups, change is inevitable. So why do so many companies insist on sticking to static, year-long budgets? Whenever I see this, I instantly know they're approaching budgeting like it's 2005, not 2025. But they seem to ignore the reality: → Technology made updating forecasts effortless  → Long-term projections are increasingly complex → Live reforecasts deliver more value than outdated targets This is why rolling forecasts are recommended, even for large companies. Instead of a single, static budget, here are the forecast models you'll maintain: 1. A yearly budget: This serves as a reference for external commitments and outlines what long-term success should look like 2. A live reforecast: This reflects your quarterly goals and should be updated each month alongside the executive team. It includes current actuals, pipeline, and priorities, ensuring targets are relevant and actionable. Agile planning is of the essence. A rolling forecast allows you to: → Move quickly: Your targets should move as fast as your tactics. Rolling budgets keep your team agile → Simplify everything: Forget multiple, confusing spreadsheets. One live reforecast streamlines the process → Iterate faster: Frequent updates help you learn, adjust, and reduce volatility → Reflect reality: Actuals, pipeline, and SQLs change monthly. Your targets should too → Spot problems early: Regular updates let you identify and address issues before they snowball  → Better assess opportunity costs: Evaluate new options monthly rather than on a one-off basis to make more informed decisions → Impress investors: Focus on what happened and what you’re doing about it—not why you missed a static target Static models don’t work in fast-moving environments. Rolling forecasts help finance teams stay connected to reality, adapt quickly, and drive better decisions. I've been sharing insights on how top finance teams are building better forecasting processes in our 'FP&A Stories from the Trenches' newsletter (new edition every Sunday). This week we broke down the exact steps to make rolling forecasts work: Blog: https://lnkd.in/deYpF7bp Sign up: https://lnkd.in/dYhxB4Yp

Everyone has their role. But they have to stay in sync. Communication is the difference between cross-functional alignment and costly confusion. Finance, Ops, and RevOps all care about performance, but they often define and track it differently. And if your team spends more time interpreting each other than acting, growth stalls fast and value-creation is impossible. So what does effective communication actually look like in a scaling agency? 1. Create shared language around core concepts How: Agree on standard definitions for key metrics like “forecast,” “margin,” “utilization,” and even “booked vs. billable.” Put these into a shared knowledge base or glossary and refer back regularly in dashboards, meetings, and reporting. Example: You say “utilization is low.” Ops hears “we need to fire someone.” Finance hears “margins are tanking.” Instead, everyone agrees: utilization = total billable hours ÷ total available hours. Now you’re debating numbers, not definitions. 2. Use asynchronous updates for tactical reporting How: Move recurring tactical updates (like forecast roll-ups, budget tracking, pipeline status) into asynchronous formats like Loom videos, Slack threads, or shared dashboards so meetings are reserved for strategy and decisions, not reporting. Example: Instead of spending 30 minutes reviewing pipeline and delivery metrics in your weekly sync, each function posts a Loom walk-through in a shared channel every Monday. Your Tuesday meeting now focuses on what the data means and what to do about it. 3. Make project and pipeline transparency a default, not a request How: Give all three teams access to real-time delivery and pipeline data via shared tools (e.g., HubSpot, ClickUp, Float, Mosaic). Remove permission bottlenecks. Build dashboards that auto-pull from shared sources. Example: RevOps updates a proposal scope. Ops sees it immediately in ClickUp. Finance sees the expected hours in their margin model. No email. No Slack ping. No lag. Everyone acts faster because they’re already in the loop. Great collaboration doesn’t require more meetings. It requires better visibility and shared understanding. Get your communication architecture right, and everything else - forecasting, hiring, pricing, client delivery - gets easier. Clarity Scales. Misalignment Costs.

You can't treat every forecast the same. More uncertainty means more risk, and you want to deal with it correctly. After building forecasting models at P&G, Unilever, and Squarespace, I've learned there are three ways to manage uncertainty: 𝟭) 𝗔𝘃𝗼𝗶𝗱 𝗔𝘀𝘀𝘂𝗺𝗽𝘁𝗶𝗼𝗻 𝗦𝘁𝗮𝗰𝗸𝗶𝗻𝗴 The more uncertainty, the fewer assumptions you should include. Why? Because if you add multiple variables on top of each other, their margin of error multiplies. If you base the forecast on many assumptions, it's nearly impossible to determine which one was accurate and which wasn't. So, keep your models as simple as possible. Isolate the variables. You can always add additional assumptions later once you better understand the correlations. 𝟮) 𝗥𝘂𝗻 𝗪𝗵𝗮𝘁-𝗜𝗳 𝗔𝗻𝗮𝗹𝘆𝘀𝗶𝘀 It's your job as a finance leader to quantify the risk of a forecast. The easiest way to do that is by changing individual inputs and noting how much impact that has on the forecast. For example, if a 5% price change affects the revenue forecast by 25%, that's a major risk you'll need to call out. 𝟯) 𝗦𝗵𝗼𝘄 𝗮 𝗥𝗮𝗻𝗴𝗲 Sometimes analysts make the mistake of assuming ranges make it look like they aren't confident in their forecast. But a well-measured range is critical for two reasons: One, it shows the order of magnitude of risk. Your CFO knows what's a conservative estimate to communicate to investors. Two, it enables scenario planning. Leaders can plan contingency measures if results are at the lower end of the range. 𝗜𝗻 𝘀𝘂𝗺, 𝘁𝗼 𝗺𝗮𝗻𝗮𝗴𝗲 𝘂𝗻𝗰𝗲𝗿𝘁𝗮𝗶𝗻𝘁𝘆 𝗶𝗻 𝗮 𝗺𝗼𝗱𝗲𝗹: 1. Reduce the number of assumptions 2. Estimate the risk by running sensitivity analysis 3. Provide ranges instead of point estimates Which approach do you find most useful? Comment below 👇 -Christian Wattig 📌 Get my 𝗙𝗶𝗻𝗮𝗻𝗰𝗶𝗮𝗹 𝗠𝗼𝗱𝗲𝗹𝗶𝗻𝗴 𝘁𝗲𝗺𝗽𝗹𝗮𝘁𝗲 + 𝟰𝟲 𝗯𝗲𝘀𝘁 𝗽𝗿𝗮𝗰𝘁𝗶𝗰𝗲𝘀 (free) here: https://lnkd.in/eBAmSF_6 

Nobody cares in FP&A how accurate your forecasts are if you're late. Example 1 - Monthly revenue forecasting Avoid this mindset: "We need 100% accurate data before submitting the forecast." Instead, think: "Our forecast, based on 90% of the data, shows we're 5% above target. This early insight allows sales to adjust tactics now, potentially increasing results by 2-3%. We'll refine later, but this snapshot drives immediate action." Example 2 - Annual Budgeting Process Move past: "We'll start budgeting in Q4 for the most accurate year-end data." Be proactive: "By using a rolling forecast, we adapt quarterly. Our Q2 review flagged a potential 15% increase in material costs. Early action let operations identify alternate suppliers, saving $2M next year. Waiting for year-end would've been too late." Takeaway? Speed in FP&A matters more than accuracy. Balancing speed with precision makes FP&A a true strategic partner. Time > everything

If your forecast changes every time you talk to someone new… it’s not a forecast. It’s a guess. One of the biggest hidden costs I see in growing companies is forecast chaos: -Sales is overly optimistic -Ops is conservative -Finance is stuck in the middle -Leadership can’t make confident decisions Here’s the fix: 👉 Start by defining your “One Forecast Rule.” That means: one forecast, owned cross-functionally, grounded in real drivers. When Finance facilitates the process—rather than just owning the spreadsheet—you get: ✅ Alignment across teams ✅ Fewer surprises ✅ Better cash decisions ✅ A real story to tell your board or investors This is a big part of what I do in my FP&A Power Launch: I rebuild broken forecasts Align teams around key assumptions And turn the numbers into a story that drives action, not just reports. If you’re scaling and tired of financial uncertainty, let’s talk. #FPandA #FinancialForecasting #BusinessClarity #StartupFinance #StrategicFinance #ForecastingExcellence #GrowthStrategy #CFO #Founders #FinanceLeadership