I attended an excellent livestream last week about Excel dashboards, presented by the legendary Chandoo. In his tutorial, he built a KPI dashboard in Excel in around an hour. As well as learning lots of useful tips, it also made me think about the key skills (Excel and otherwise) that you need to build a great dashboard.
What would happen in your organisation if you stopped producing management accounts?
I’ve had to delay issuing management accounts a few of times in my professional career. (It’s funny, it feels scary even admitting that, such is the sacred status of the Month End Routine. It makes me feel like I’ve failed as a finance director.)
When I had more junior finance roles in larger organisations, I often found the annual budgeting process to be somewhere between traumatic and soul-destroying. Week after week of meetings and emails and multiple versions of clunky spreadsheets.
So when I became a Finance Director, I thought long and hard about what made organisational budgeting so awful. I then identified four key components of a happier budgeting process;
If you’re managing a finance team, at some point you (or someone in the team) will need to prepare some kind of year end accounts, also known as statutory accounts. I’ve been doing this for many years now and in this post I will share my observations about what makes for a smooth year end process.
The short version of this; planning in advance will always reap dividends. As you will see, most of my advice concerns things you can and should be doing well in advance of year end.