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