Finance

Forecast model rollforward automation

AI automates month-end rollforward of financial model formulas from the last forecast month into the new actual month, reducing repetitive spreadsheet maintenance.

Why the human is still essential here

Finance remains responsible for model structure, assumption quality, exception handling, and deciding whether the updated model reflects reality.

How people use this

Excel formula rollforward

A finance analyst uses AI in Excel to copy prior-period formulas, update date references, and check for broken links when a new actual month is opened.

Microsoft Copilot for Excel

Driver-based planning refresh

Planning teams automate forecast version rollforwards so new months inherit the right logic and driver relationships without manually rebuilding schedules.

Anaplan

Monthly template propagation

FP&A teams keep recurring forecast tabs current by having AI carry forward formulas and structures into the next planning cycle before assumptions are updated.

Planful

Need Help Implementing AI in Your Organization?

I help companies navigate AI adoption -- from strategy to production. Whether you are building your first LLM-powered feature or scaling an agentic system, I can help you get it right.

LLM Orchestration

Design and build LLM-powered products and agentic systems

AI Strategy

Go from idea to production with a clear implementation roadmap

Compliance & Safety

Build AI with human-in-the-loop in regulated environments

Related Prompts (2)

Latest community stories (1)

Personal Story
LinkedIn

The AI hype is real.

The AI hype is real. It's also incredibly useful, ๐˜ช๐˜ง you know where to apply it. I think the problem for a lot of people is that the practical examples of how AI can actually help, and how it makes you more efficient, are missing.

Here's my honest take, from a finance seat in a scale-up.

So I thought I'd share some real examples of how I use AI, as the CFO of Orbisk | Zero Food Waste.


In the scale-up phase we're in, capital isn't usually spent on big finance teams. But then all the finance topics still need to be covered:


Monthly reporting, updated rolling forecasts, annual statements, ad hoc analysis whenever the business asks for it.


With a small team, that can become overwhelming.


And it leads to something I want to avoid: only doing the "producing" part of the job, instead of the strategic part, giving guidance and direction to the company.


This is exactly where AI can add value. Because a lot of that producing part can be done with AI.


Some practical examples I've automated, that save me a lot of time:


1๏ธโƒฃ ๐— ๐—ผ๐—ป๐˜๐—ต๐—น๐˜† ๐—ฐ๐—ผ๐—ป๐˜€๐—ผ๐—น๐—ถ๐—ฑ๐—ฎ๐˜๐—ถ๐—ผ๐—ป & ๐˜๐—ฟ๐—ถ๐—ฎ๐—น ๐—•๐—ฎ๐—น๐—ฎ๐—ป๐—ฐ๐—ฒ ๐—ฐ๐—ผ๐—บ๐—ฝ๐—ฎ๐—ฟ๐—ถ๐˜€๐—ผ๐—ป

Consolidates the trial balances of all entities and summarises the differences per month, per G/L account and expense group


2๏ธโƒฃ ๐—ฃ๐—ฟ๐—ผ๐—ฝ๐—ผ๐˜€๐—ฒ๐—ฑ ๐—ฎ๐—ฐ๐—ฐ๐—ฟ๐˜‚๐—ฎ๐—น๐˜€ ๐—ฏ๐—ฎ๐˜€๐—ฒ๐—ฑ ๐—ผ๐—ป ๐—น๐—ฎ๐˜€๐˜ ๐Ÿฏ ๐—บ๐—ผ๐—ป๐˜๐—ต๐˜€ ๐—ผ๐—ณ ๐˜๐—ฟ๐—ฎ๐—ป๐˜€๐—ฎ๐—ฐ๐˜๐—ถ๐—ผ๐—ป๐˜€

Spots which vendor invoices are still missing on day 1 of the month, based on last month's pattern, including the average amount


3๏ธโƒฃ ๐—ฅ๐—ผ๐—น๐—น๐—ผ๐˜ƒ๐—ฒ๐—ฟ ๐—ผ๐—ณ ๐—บ๐˜† ๐—ณ๐—ถ๐—ป๐—ฎ๐—ป๐—ฐ๐—ถ๐—ฎ๐—น ๐—บ๐—ผ๐—ฑ๐—ฒ๐—น

Automatically drags forward all formulas from the last forecasting month to the actual month at month-end


4๏ธโƒฃ ๐—•๐—ฎ๐—น๐—ฎ๐—ป๐—ฐ๐—ฒ ๐˜€๐—ต๐—ฒ๐—ฒ๐˜ & ๐—ฐ๐—ฎ๐˜€๐—ต๐—ณ๐—น๐—ผ๐˜„ ๐˜€๐˜๐—ฎ๐˜๐—ฒ๐—บ๐—ฒ๐—ป๐˜ ๐—ฝ๐—ฟ๐—ผ๐—ฑ๐˜‚๐—ฐ๐˜๐—ถ๐—ผ๐—ป

Based on the trial balances in our ERP, it builds the consolidated balance and cashflow statement automatically, including management corrections and a forecast based on the drivers we've discussed


5๏ธโƒฃ ๐—”๐˜‚๐˜๐—ผ๐—บ๐—ฎ๐˜๐—ถ๐—ฐ, ๐—ถ๐—ป๐˜๐—ฒ๐—ฟ๐—ฎ๐—ฐ๐˜๐—ถ๐˜ƒ๐—ฒ ๐—›๐—ง๐— ๐—Ÿ ๐—บ๐—ผ๐—ป๐˜๐—ต๐—น๐˜† ๐—ฟ๐—ฒ๐—ฝ๐—ผ๐—ฟ๐˜๐—ถ๐—ป๐—ด ๐—ฝ๐—ฎ๐—ฐ๐—ธ๐—ฎ๐—ด๐—ฒ

Built from an auto-generated input Excel, it creates a dashboard and in- and external reporting where I only manually add comments and observations


All of these used to be repetitive, boring, producing work.


I already hear some finance people say: nice story, but are the numbers correct?


Yes. If you build in testing, let AI crosscheck what it produces, and make sure it's always tied back to your source data.


The only catch: you have to invest the time to make it to work. Spend one hour on it and it won't work. Put in the time properly, and it pays you back many times over.


โ†ณ Where in your finance function is AI actually saving you real hours?

TC
Teun CastelijnsCFO at Orbisk | Zero Food Waste
Aug 5, 2026