Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

How To Split Headcount Between Departments

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.

Question

I have several employees who are shared among multiple departments. What is the best way in AP to allocate a portion of the employee’s salary to multiple P&L departments?

Answer

Typically employees who are shared among multiple departments are planned using splits on the Personnel sheet. For example, you could have an employee, Joe Smith, with two splits, one for the Marketing Department and one for the Sales Department. Then, a column would be added to represent the allocation %, for example, 75% of Joe's salary should be billed to the Marketing department and 25% should be billed to the Sales department. Finally, this percentage would be be multiplied by the Personnel related accounts.

Something else to consider is that in some of your formulas, i.e. calculating tax caps for an individual, you might need to reference the unsplit Headcount and or Salary account. I often see multiple headcount accounts set up to show both the split values and the unsplit values:

  • Allocated Headcount
  • Unallocated Headcount
  • Allocated Partial Headcount
  • Unallocated Partial Headcount
  • Allocated Salary
  • Unallocated Salary

Click HERE to access the Personnel Planning Advanced Modeling user guide which includes more information on how splitting headcount is typically handled.