Monthly Recurring Revenue projection reporting

My business charges a monthly subscription fee throughout the life an an agreement. For example, someone signs an agreement to participate from 06/01/2020 to 12/31/2021 and they pay $500 per month.

I am new to AirTable. I have the monthly amount they are paying associated with the client and I have the start date of the agreement and the end date of the agreement. I need to be able to create a table or a view that shows me the total revenue for all clients for a given time period (i.e. revenue every month into the future).

Is this possible?


Hello and welcome @Darby_Vannier!

I set up an example table based off your description:

It sounds like creating a filtering view will give you the flexibility you are looking for to create custom views for particular time ranges.

Here is an example of a filter I created to only show Clients who would have active contracts in the month of January (the start date was before January, and the end date was after January):

The summary bar will then show you an automatic sum for currency amount on that view

Hope that helps! Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark:.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.