Pop quiz to all finance peeps: list all the critical master sheets your company uses (Need to Set up this whole process for a client)
Need to pretty much tell him every excel finance sheet he needs, then I'll build them for him!
Here are my current answers:
Critical sheets:
- Cash position and 13-week forecast
- AR summary and top 5 overdue
- AP summary and payment run recommendation
- Cash conversion cycle vs baseline vs last month
- Project/contract P&L
- Flags, actions taken this month, recommended actions
Pretty sure the top 4 is all they need?
They need AR visibility, AP visibility, cash flow!
What am I missing?