Revenue Recognition Schedule with multiple contract values

Question

Hi All,

I have a question about how to create an revenue recognition schedule based on multi-year contracts with step up revenues.

I would like to create a workflow that could turn it into a monthly recognition report. I am currently doing this manually and it becomes excruciatingly painful

Input :

Output

Thanks in advance!!!

Yoshiro_Fujimori · Accepted Answer

Hi @SArielle ,

Here is one way of doing this.

I assume the values in Y1, Y2 columns are always split to 12 months.

It that is not the case, you may want to tweak the formula tools. Good luck!

Workflow

Output