Salary and Benefits budget for grant tracking

The goal was to build a spreadsheet that tracked all expenses on a grant budget, the salary and benefits being the most complex. The challenge was capturing all employees' varying start/end dates at varying amounts, and designed in a digestible way for non-finance users to understand. The spreadsheet needed to also account for one-off stipend amounts that didn't align to regular budget cycles.

Figures have been randomized in attached pictures with names removed to maintain confidentiality.