Revenue Recognition (was Accumulated)

3.16K viewsGeneral Discussion
0

Hello,

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!
-Bryan

Attachments

rev recog.zip
0

Hello Chris,

This is a very elegant solution – just what I was looking for!!

I also noticed a few other techniques in your example that I can implement in my models.

Thanks for the quick response.

-Bryan

You are viewing 1 out of 2 answers, click here to view all answers.