Help and ideas for busy numbers people
Power Query has been out for over a decade and yet the majority of accountants I meet still seem unaware of what it can do for them.
A possible issue is that it is usually presented in the context of Power BI, and analysing Big Data. And the type of people who like to talk about that also like to talk about other scary things such as VBA and SQL. There aren’t many training resources or articles focussing on Power Query for accountants more generally.
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.
If all this sounds interesting but you don’t have the time, you could always ask me to build a model for you!
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”