Compensation Review Manager
From spreadsheet calculations and manually produced documents to one structured review system.
Jordan Lee
Requested changes stay attached to the record instead of disappearing into an email thread.
The calculations worked. The process around them didn’t.
The original workflow depended on a spreadsheet, manual document preparation, manager emails, repeated edits, and careful version control. The new system brought those pieces into one structured review flow.
A working process held together manually.
Salary adjustments, effective-date logic, bonus values, and payband positioning lived in workbook formulas.
Compensation results had to be copied into an employee-facing document after the calculation was complete.
Managers reviewed information outside the calculation environment, usually through a separate document or message.
Requested edits could become detached from the actual employee record and require manual reconciliation.
Changes had to be re-entered carefully without disrupting formulas or the wrong employee record.
Every accepted change meant another round of document updates, checking, and version control.
One guided compensation review system.
The user works with clear fields rather than exposing the underlying workbook and formulas.
Salary increases, effective dates, payband values, variable compensation, and totals are calculated consistently.
HR can compare potential adjustments and understand their effect before sending anything for review.
Managers see the information they need to approve or request changes without touching the backend logic.
Review comments and revision requests stay connected to the employee instead of disappearing into an email thread.
Once finalized, the approved compensation information can be turned into a standardized output without rebuilding it manually.
Protected the logic.
Users no longer need to understand or safely navigate the spreadsheet formulas behind the compensation calculation.
Standardized the workflow.
The same inputs, review stages, and output structure are followed every time instead of depending on individual habits.
Connected review to the record.
Manager comments, requested revisions, final calculations, and document output all stay connected to the employee being reviewed.
Hide the complexity without hiding the logic.
The system had to support salary changes, effective-date calculations, payband positioning, variable compensation, review statuses, revisions, and employee document preparation without exposing a giant workbook to every user.
Calculate
Consistent formulas based on structured inputs.
Compare
See multiple compensation scenarios before finalizing.
Review
Give managers a focused review experience.
Generate
Produce a standardized employee-facing output.
Complexity belongs in the system — not in the user’s head.
This public case study uses fictional names, figures, and presentation details to demonstrate the workflow concept without exposing employer or employee information.