Collected and outstanding are two different reports, and both need the same clean data underneath. How to build each one by customer, by age and by period, what to do about part-payments, and how to turn the report into the right phone calls.
Six reports, twenty minutes, once a month: cash collected, what's owed and how old it is, payroll cost, the VAT position, spend by category, and what's waiting for approval. What each one tells you and the question to ask of it.
If someone rebuilds the same management report every Monday, the problem isn't the report. How to get the numbers an MD needs from records your team already keeps, and which six figures matter most.
How a group gets one honest view across several companies: set them up the same way, compare like with like, handle intercompany items carefully, and know what to consolidate and what not to.