Current and future headcount data is critical for a financial forecast but can become a massive time suck ๐ for FP&A teams if a scalable workflow is not created from the beginning.
Lately, I’ve been working with two clients, one early-stage and one more mature, which has made me reflect on how to build a scalable headcount workflow before things start to become too complex.
Here are some considerations for FP&A teams dealing with headcount at early-stage companies:
1๏ธโฃ ๐๐๐๐ฎ๐ฏ๐น๐ถ๐๐ต ๐ฎ ๐ฐ๐น๐ฒ๐ฎ๐ฟ ๐ฎ๐ป๐ฑ ๐ฒ๐ป๐ณ๐ผ๐ฟ๐ฐ๐ฒ๐ฎ๐ฏ๐น๐ฒ ๐ต๐ถ๐ฟ๐ถ๐ป๐ด ๐ฎ๐ฝ๐ฝ๐ฟ๐ผ๐๐ฎ๐น ๐๐ผ๐ฟ๐ธ๐ณ๐น๐ผ๐.ย Before worrying about efficiency or scalability, the first item to address is making sure the finance team has control over hiring or has delegated responsibility to an operator with P&L ownership.
2๏ธโฃ ๐ฌ๐ผ๐๐ฟ ๐ณ๐ถ๐ป๐ฎ๐ป๐ฐ๐ถ๐ฎ๐น ๐ณ๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐ ๐๐ต๐ผ๐๐น๐ฑ ๐๐๐ฎ๐ฟ๐ ๐๐ถ๐๐ต ๐ฎ๐ฐ๐๐๐ฎ๐น ๐ต๐ฒ๐ฎ๐ฑ๐ฐ๐ผ๐๐ป๐ ๐ฑ๐ฎ๐๐ฎ ๐ฑ๐ถ๐ฟ๐ฒ๐ฐ๐๐น๐ ๐ณ๐ฟ๐ผ๐บ ๐๐ผ๐๐ฟ ๐ต๐๐บ๐ฎ๐ป ๐ฐ๐ฎ๐ฝ๐ถ๐๐ฎ๐น ๐บ๐ฎ๐ป๐ฎ๐ด๐ฒ๐บ๐ฒ๐ป๐ (๐๐๐ ) ๐๐๐๐๐ฒ๐บ.ย Start in Excel with a standardized report that can be updated quickly but seek to make an automatic connection when forecast software is implemented.
3๏ธโฃ ๐ฆ๐ผ๐น๐๐ฒ ๐ต๐ฒ๐ฎ๐ฑ๐ฐ๐ผ๐๐ป๐ ๐ฑ๐ฎ๐๐ฎ ๐พ๐๐ฎ๐น๐ถ๐๐ ๐ถ๐๐๐๐ฒ๐ ๐ฒ๐ฎ๐ฟ๐น๐, ๐ฎ๐ป๐ฑ ๐ฎ๐ ๐๐ต๐ฒ ๐๐ผ๐๐ฟ๐ฐ๐ฒ. For example, if a new hire is added in the wrong department, figure out why this happened and how to definitively avoid 100% of these mistakes in the future.
4๏ธโฃ ๐๐ฟ๐ฒ๐ฎ๐๐ฒ ๐ฎ ๐๐ผ๐๐ฟ๐ฐ๐ฒ ๐ผ๐ณ ๐๐ฟ๐๐๐ต ๐ณ๐ผ๐ฟ ๐ฎ๐ฝ๐ฝ๐ฟ๐ผ๐๐ฒ๐ฑ ๐ง๐ผ ๐๐ฒ ๐๐ถ๐ฟ๐ฒ๐ฑ๐ (๐ง๐๐๐) ๐๐ต๐ฎ๐ ๐ฐ๐ฎ๐ป ๐ฏ๐ฒ ๐ฎ๐ฐ๐ฐ๐ฒ๐๐๐ฒ๐ฑ ๐ฏ๐ ๐๐ต๐ฒ ๐๐ฃ&๐ ๐๐ฒ๐ฎ๐บ, ๐ฟ๐ฒ๐ฐ๐ฟ๐๐ถ๐๐ฒ๐ฟ๐ ๐ฎ๐ป๐ฑ ๐ฏ๐๐ฑ๐ด๐ฒ๐ ๐ผ๐๐ป๐ฒ๐ฟ๐.ย This is not a trivial exercise, but will save massive amounts of time when these 3 groups donโt need to perform their own monthly reconciliations.ย Bonus points if this is in a system and not an Excel spreadsheet managed by a person.
5๏ธโฃ ๐๐ฟ๐ถ๐๐ฒ ๐๐ผ๐๐ฎ๐ฟ๐ฑ ๐ฎ๐ป ๐ฎ๐๐๐ผ๐บ๐ฎ๐๐ถ๐ฐ ๐ฎ๐ป๐ฑ ๐ณ๐ฟ๐ฒ๐พ๐๐ฒ๐ป๐๐น๐ ๐๐ฝ๐ฑ๐ฎ๐๐ฒ๐ฑ ๐น๐ถ๐ป๐ธ ๐ฏ๐ฒ๐๐๐ฒ๐ฒ๐ป ๐๐๐ ๐๐ผ๐ณ๐๐๐ฎ๐ฟ๐ฒ (๐๐ฅ), ๐๐ต๐ฒ ๐๐ง๐ฆ ๐๐๐๐๐ฒ๐บ (๐ฟ๐ฒ๐ฐ๐ฟ๐๐ถ๐๐ถ๐ป๐ด) ๐ฎ๐ป๐ฑ ๐๐ต๐ฒ ๐ณ๐ผ๐ฟ๐ฒ๐ฐ๐ฎ๐๐๐ถ๐ป๐ด ๐๐ผ๐ณ๐๐๐ฎ๐ฟ๐ฒ (๐๐ฃ&๐). The key is linking the req ID and the employee ID (plus the position ID if you are using Workday). This is also not trivial and requires both technical expertise and working with stakeholders on the workflow, but this should be the long-term goal.
Getting your headcount process right from the start can make a meaningful impact as the company scales.
What are other good tactics for early-stage FP&A teams?
Leave a comment