Deferred Revenue and Balance Report

Hi all,

I am trying to finalise a report I have wanted for a few months now to show my deferred revenue schedule as well as the remaining balance for each bill in a deferred balance field. We have lots customers and lots of agreements so having a formula to do this will remove a huge manual effort.

I join here and found a great deferred rev report to base it on and included this into my standard report that our system output. However, I have noticed an issue that I cannot resolve. Some agreement where the month starts late for example row 2, we invoiced early April for their agreement to start on April 25th, but the formula doesn't add a monthly fee for this item. It also doesn't take the last month into account so essentially we are only reporting 11 months of the service fee. - Example file Example Reports.xlsx

Any ides on how we can get around this, would it be possible to show the remaining days from month 1 and the 24 days from the final month?

Any help would be appreciated.

Thanks
Chris

Thanks, updated!

Try in Q2: =IF(MEDIAN(EOMONTH($L2,-1)+1,EOMONTH($L2,11),Q$1)=Q$1,$P2,0), copy across and down.

That seems to have done the trick, thank you so much!

You are welcome and thanks for the Rep!