Information about the revenue recognition calculation for service fees in Project Accounting in Microsoft Dynamics GP

Work anywhere from any device with Microsoft 365

Upgrade to Microsoft 365 to work anywhere with the latest features and updates.

Upgrade now

INTRODUCTION

This article discusses information about service fees in Project Accounting in Microsoft Dynamics GP. This article also discusses how the revenue recognition amount is calculated.

More Information

A service fee can be set up for any time period that you specify. The percent complete is based on the total number of days for the service fee. The Begin Date field and the End Date field are used to calculate the number of days for the service fee.

Then, the percent complete is multiplied by the fee amount to obtain the revenue recognition amount. Billing has no affect on the amount that is recognized.

The following examples show how the revenue recognition amount is calculated:

  • Service fee example 1
    Fee Amount: $10,000
    Begin Date: 1/1/2007
    End Date: 4/30/2007
    Total Number of Days = 121 days (31 + 29 + 31 + 30)

    If revenue recognition is run with a cutoff date of 2/15/2007, the percent complete is calculated as follows:

    Percent Complete = ((31 + 15) - 1) / (121 - 1) = 0.375 = 37.50%
    Amount Recognized = 37.50% * $10,000 = $3750

  • Service fee example 2
    Fee Amount: $1000
    Begin Date: 1/1/2006
    End Date: 2/29/2007
    Total Number of Days = 425 days (365 + 31 + 29)

    If revenue recognition is run with a cutoff date of 2/15/2007, the percent complete is calculated as follows:

    Percent Complete = ((365 + 31 + 15) - 1) / (425 - 1) = 0.9669811 = 96.70%
    Amount Recognized = 96.70% * $1000 = $967

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×