Have you ever built a forecast, felt great about it, and never touched it again?
You're not alone. It happens all the time.
In the book I share the story of an owner with multiple locations and multiple legal entities. She wanted to put more focus on the key drivers of performance. She wanted a forecast so she could start planning and working on driving profitability higher.
So she rolled up her sleeves. She built a profitability forecast for each entity in her own homegrown spreadsheet, then rolled them up so she could see the consolidated view as well as each entity. The project took her a long time to complete.
Then she realized something. It was impossible to maintain each month.
It turned out to be a one-time exercise. It could not be turned into a repeatable process. And there was a second problem. The spreadsheet only covered the income statement. There was no forecast for the balance sheet or cash flow.
Why does that matter? Because a forecast you can't update is a snapshot. It's out of date the day the next month closes. And a forecast without a balance sheet and cash flow can tell you you're profitable while it misses where the cash is going.
The fix wasn't to work harder in the spreadsheet. It was to choose a tool that fit the job. Whatever you build or buy, it should model a full set of financial statements, import your actual results, and be easy to update and maintain each month.
Spreadsheets are essential to business. But they're also a bit overused. Building and maintaining a full financial model over time is the opposite of simplification.
A reliable financial forecast isn't a project you finish. It's a living view through the financial windshield that you refresh every month, so you can see what's about to happen and drive growth, profitability, and cash flow higher.
To learn more, visit financialrhythm.com.
IN ENCOREBuilt to be updated
Philip's owner needed three things her spreadsheet couldn't give her: all three financial statements, a roll-up across entities, and a forecast she could refresh every month.
In Encore, each entity or location runs the same logic on its own numbers, and consolidation rolls them up into a company total, with every entity still visible. The income statement, balance sheet and cash flow are modeled together, so profit and cash can't drift apart.
Each month, the Row Mapper imports the new trial balance using last month's mapping. Add the file, click Import, and the forecast is current again.
REALITY CHECKEncore can’t do your thinking for you
It's not quite as simple as it sounds. You don't just click Import and the forecast is current again. You need to do some sanity checking first.
Do the latest actuals change your expectations about the future? Were any sales pulled forward that are still in the forecast? Anything unusual in the expenses? Is cash holding up? What needs to change in the assumptions going forward?
This is an exercise you want to go through every month. Encore is a great tool, but it can't do your thinking for you.
Rusty Luhring, co-founder of Ferox