It sounds like you need better accounting software, it should be trivial to use your accounting software to keep track of this information.

Presumably whoever does your financial projections has this info in a spreadsheet as well ? (e.g so they can project new employee cost for software that's sold per seat)