We have a list of service agreements with start and end dates and agreed monthly service fees. I am trying to track the sum of those monthly service fees by month. What is the best way to do this?
Example:
Agreement 1 starts 01-01-2022 and ends 12-31-2022 and runs $100/mo.
Agreement 2 starts 07-01-2022 and ends 06-30-2023 and runs $50/mo.
I want an output for the total monthly fees from each agreement in any given month.
Jan 22: 100
Feb 22: 100
Mar 22: 100
Apr 22: 100
May 22: 100
Jun 22: 100
Jul 22: 150
Aug 22: 150
Sep 22: 150
Oct 22: 150
Nov 22: 150
Dec 22: 150
Jan 23: 50
Feb 23: 50
Mar 23: 50
Apr 23: 50
May 23: 50
Jun 23: 50
etc
