Spreadsheet-to-FP&A Readiness Scorecard

The 12 checks (score 1 point for each “yes”)

• Budget and forecast take more than two weeks to update
• More than three people edit the same planning spreadsheet
• Version confusion has caused a reporting error this year
• Actuals are copied in from the accounting system by hand
• You cannot model a scenario in under a day
• Department heads cannot see their own budget vs actuals
• Board or lender reporting is rebuilt every month
• Headcount planning lives in a separate file
• Cash forecast and P&L forecast do not tie out
• You have more than one entity or currency
• Leadership asks questions finance cannot answer quickly
• Month-end close takes more than 10 business days