Imagine this scenario: You’re responsible for managing your company’s operational costsย and wondering how to budget for and calculate the average cost per employee effectively.
๐๐ก๐ข๐ฌ ๐ข๐ฌ ๐ญ๐ก๐ ๐๐ฑ๐๐๐ญ ๐ช๐ฎ๐๐ฌ๐ญ๐ข๐จ๐ง ๐จ๐ง๐ ๐จ๐ ๐จ๐ฎ๐ซ ๐๐ฎ๐ฌ๐ญ๐จ๐ฆ๐๐ซ๐ฌ ๐ซ๐๐๐๐ง๐ญ๐ฅ๐ฒ ๐๐ฌ๐ค๐๐ ๐ฆ๐.
While Business Central does offer Human Resources capabilities (defining employees, keeping track of their skills and certifications etc), these details, including the headcount, can’t be used (yet) in conjunction with financial data in standard reports, such as the Financial Reportingโthe embedded report builder.
So what is the solution other than using Power BI, another reporting tool, or the easy solution of creating another Excel spreadsheet?
Actually, the solution is simpler than you might think. You can achieve all of this using the built-in capabilities of Business Central. Let’s dive into the steps:
1๏ธโฃ Go to (search) Statistical Accounts and create a new statistical account. Let’s call it ๐๐ฎ๐ฑ๐ญ๐ฐ๐บ๐ฆ๐ฆ๐ด.
2๏ธโฃ Use Statistical Accounts Journalย to record the number of employees at the beginning of the reporting period and the number of employees at the end of each month (or use variation month-to-month)
3๏ธโฃ Go to Financial Reporting and create a new report. Let’s call it Cost per Employee.
4๏ธโฃ In the Cost per Employee report, define Rows to calculate operational costs (which could be taken from multiple GL accounts or GL Budgets), headcount, and the average cost per employee. As Columns, you will have your reporting periods.
Like any other report, you can use it directly in Business Central and drill down to the individual record. You can also export it to Excel, print it (if necessary), or send it via e-mail.
