Bridging HR headcount and payroll expense

HR reports active headcount. Finance reports payroll expense. Those two numbers rarely meet without a bridge, especially when contractors, unpaid leave, and mid-month joiners sit in different systems.

Start with a single as-of date. Ask HR for the roster frozen at that date, including status codes. Ask finance for the payroll GL detail for the same period, split by cost centre if you use them.

Then build three columns: people who appear in HR but not in pay, people paid who are not active in HR, and people present in both with mismatched amounts. Most Chiayi manufacturers we meet find the second column filled with final pay runs for leavers already marked inactive.

Assign an owner to each reconciling item before the close call ends. Without owners, the same gap returns next month and the payroll audit review grows longer than it needs to be.