# Deferred Revenue Recognition

#### shazam17

##### New Member
Hello! Seeking some urgent help. I have data by month 1,2,3.....across over 60 months. I need to defer the recognition by n (number of months) fixed throughout the term but can be changed and the entire sequence is corrected to reflect this. As an example all data in months 1,2,3 need to be deferred by 2 months then data in month 1 would then fall into month 3 data in month 2 then falls in month 5 and so forth and needs to stop when the total is reached.

 12 24 Month 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Y1 Y2 data 23 354 56 6 78 45 91 900 45 67 898 2,563 - WHAT NEEDS TO HAPPEN 23 354 56 6 78 45 91 900 45 67 898 517 2,046 Revenue Delay 2 Mths

<colgroup><col><col span="6"><col><col><col><col span="23"><col><col><col></colgroup><tbody>
</tbody>
12 24

<colgroup><col><col span="6"><col><col><col><col span="23"><col><col><col></colgroup><tbody>
</tbody>

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Hi Shazam and welcome to the Forum

Now that's a deferred revenue recognition methodology I've never seen in nearly 40 years of accounting!!

And it took some hard thinking and experimentation to implement in Excel - but I think I've got it.

 A​ B​ C​ D​ E​ F​ G​ H​ I​ J​ K​ L​ M​ N​ O​ P​ Q​ R​ S​ T​ U​ V​ W​ X​ Y​ Z​ AA​ AB​ AC​ AD​ AE​ AF​ AG​ AH​ AI​ AJ​ AK​ 3 ​ Revenue Delay (Mths)​ 2 ​ 4 ​ Month No.​ 1 ​ 2 ​ 3 ​ 4 ​ 5 ​ 6 ​ 7 ​ 8 ​ 9 ​ 10 ​ 11 ​ 12 ​ 13 ​ 14 ​ 15 ​ 16 ​ 17 ​ 18 ​ 19 ​ 20 ​ 21 ​ 22 ​ 23 ​ 24 ​ 25 ​ 26 ​ 27 ​ 28 ​ 29 ​ 30 ​ 31 ​ 32 ​ Y1 ​ Y2​ 5 ​ Actual revenue​ 23 ​ 354 ​ 56 ​ 6 ​ 78 ​ 45 ​ 91 ​ 900 ​ 45 ​ 67 ​ 898 ​ 2,563​ -​ 6 ​ 7 ​ Recognise in Mth​ 3​ 5​ 7​ 9​ 11​ 13​ 15​ 17​ 19​ 21​ 23​ 25​ 8 ​ Recognised revenue:​ -​ -​ 23​ -​ 354​ -​ 56​ -​ 6​ -​ 78​ -​ 45​ -​ 91​ -​ 900​ -​ 45​ -​ 67​ -​ 898​ -​ -​ -​ -​ -​ -​ -​ -​ -​ 517​ 2,046​

<tbody>
</tbody>
 Sheet: .

<tbody>
</tbody>

C7 =C4+COUNT( \$B5:B5) + \$C\$3
C8 = IFERROR( INDEX( \$C\$5:\$AH\$5, MATCH( C4, \$C\$7:\$AH\$7, 0 ) ), 0 )

Replies
0
Views
174
Replies
1
Views
268
Replies
1
Views
258
Replies
2
Views
307
Replies
19
Views
310

1,216,132
Messages
6,129,068
Members
449,485
Latest member
greggy

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back