Deferred Revenue for Saas Company

If a) I've understood {which incl. calendar based qtrs} and, b) you're using O365 (per profile) then one option, to simplify, might be as follows:

Formula:

Please Login or Register  to view this content.

the above would generate total revenue of $2,028,062 in 2019 and $2,652,485 in 2020
{the above balances matched a much larger matrix based check I did - so seems sound to me - the remaining delta reflects the booked revenue deferred into 2021}