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.

0 likes · 0 views · Oct 23, 2025
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 ...