Over months or quarters you can compare periods like for like and look for trends, using simple graphs for quick visualisations. There’s no point listing reams of numbers – no one will ever look at them.
If your existing systems dont give you the reports you need, then doing this kind of work in Excel can absorb a whole member of your finance team. Once you know what you want it needs to be automated.