You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Straight line revenue for a multi year contract with different discounts for each year

Summary:

We have a scenario where we have one item charged differing discounts over the period of the contract.
Year Qty Rate Amount List Price Discount
Yr1 7 9075 63525 10000 925
Yr2 7 9175 64225 10000 825
Yr3 7 9275 64925 10000 725
Total Contract Value 192675

When we create this as three lines in the FBDI, the system is creating three promise details (1 for each year) with one performance obligation. It is recognizing the revenue for each promise detail as per the below table. We want this to be
Year Days YR1 YR2 YR3
1 24 4176.929 4222.956 4268.983
2 30.455 5300.349 5358.755 5417.161
3 30.455 5300.349 5358.755 5417.161
4 30.455 5300.349 5358.755 5417.161
5 30.455 5300.349 5358.755 5417.161
6 30.455 5300.349 5358.755 5417.161
7 30.455 5300.349 5358.755 5417.161
8 30.455 5300.349 5358.755 5417.161
9 30.455 5300.349 5358.755 5417.161
10 30.455 5300.349 5358.755 5417.161
11 30.455 5300.349 5358.755 5417.161
12 30.455 5300.349 5358.755 5417.161
13 6 1044.232 1055.739 1067.246
Total 365.005 63525 64225 64925

The business is expecting the revenue will be carved out from year 3 and applied to year 1 there by evening out the revenue recognition per period. The system is not carving out the revenue from year 3 and applying it to year 1. Can you please let me know how this can be handled?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!