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.Continue reading “Creating dashboards in Excel – key skills”
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.)Continue reading “Who would miss your management accounts?”
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;
This post explores these further.Continue reading “A happier annual budgeting process”
I’ve written more generally about how to have a smooth year end accounts process. This is a more specific piece about how to build an audit-friendly year end accounts model.
I’ve included examples for download to illustrate the principles.Continue reading “Preparing a year end accounts model”
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.Continue reading “A smooth year end accounts process”
Have Key Performance Indicators (KPIs) ever featured so much in our news bulletins? As a nation we are suddenly poring over death and testing rates and graphs as never before.
Our new-found love of stats highlights six lessons I’ve learned over the years from producing board reports and analysis.Continue reading “Coronavirus and Key Performance Indicators”