I’m trying to figure out the best method for building revenue recognition formulas in Quantrix. Attached is a simple example in excel. I essentially want to calculate the monthly revenue recognized and deferred for a given invoice amount. I’d like to avoid duplicating the excel method in Quantrix.
The recognized revenue would be spread over the number of periods specified (12 months for an annual deal that is invoiced entirely in the first period). The monthly amount is then split between the current/next periods (to account for invoices that are booked towards the end of the month) with the percentages specified.
Thanks in advance!