Active Headcount by Department

Employee IDFull NameDepartmentJob Title StatusTenure (Yrs)Current Salary (Annualized)Bonus ($)

Calculated Automatically

Identity & Employment

Contact Information

Emergency Contact

Health & Benefits

Compensation

Vacation

Notes

Bonus Tiers (based on Tenure in Years)

Applied automatically to every employee's Bonus % based on their calculated tenure.

As-Of Date

Used for all tenure, anniversary, and bonus calculations. Defaults to today — set a fixed date to freeze calculations for year-end reporting.