Revenue Projection Method

by | Sep 2, 2020

Revenue Projection Method

When you create revenue, you can fill in the revenue projected amount within the “Revenue Projection” section. This value will be displayed within the application regardless of the revenue status and can be used to compare the projected amount with the actual amount.

You can configure how the revenue projected amount will be filled in:

  • Manual: the projected amount will be typed. The currency can be changed to any of the enabled currencies
  • Based on completed tasks: The projected revenue amount will be based on the tasks completed per period. Users will be presented with a pop-up to select which tasks to include.
    Each task will add its value, which is calculated multiplying the estimated hours by the bill rate of the categories involved

 

Configuration

 There are three locations where you can set your preferences for revenue projected amount, from a higher level to the project itself:

For the whole company, in Configuration Configuration

  1.  Project Parameters → Methods.
  2. By project type, in Configuration → Project Parameters → Project Type.
  3. By project, in the General section of the project. This option will only be available if the option “Allow project settings to override this configuration” was ticked at the company level

At any of those levels, you will be able to set your preference for the way revenue projected amount is filled in

Revenue Recognition

by | Sep 2, 2020

Revenue Recognition

 

Contents

 

Introduction to Revenue Recognition

Revenue Recognition is part of the Project Revenue Management feature in ITM Platform, which includes plan revenue, recognize revenue, actual revenue processing, and perform project account closure and financial analysis within the project life cycle.

Revenue recognition is an accounting principle that identifies the specific conditions in which revenue is recognized. The revenue recognition concept is part of accrual accounting and establishes that revenue should be recorded when it has been earned, not received.

Revenue versus cash timing:

  • Accrued revenues are used for transactions in which goods and services have been provided, but cash has not yet been received.
  • Deferred revenues reflect situations in which money has been received, but goods and services have not been provided.

Recognition principles are extensively outlined in IFRS and U.S. GAAP.

ITM Platform provides the following project revenue recognition methods.

  • Percentage-of-completion
  • Linear Distribution by Milestones
  • Fixed Price per Period
  • Bill Rate per Estimated Hours
  • Direct Revenue Recognition

The revenue recognition feature will distribute the total project revenue budget within the different periods of the project. Each method will use different formulas to calculate revenue recognition for each period.

You can choose to apply the same method for all projects in your company, specify a method per project type, or specify the method project by project. Before describing each of the methods, let us clarify the concepts of periods, actuals, forecast, amounts, percentages, how they apply to projects and how they affect revenue recognition.

Periods

Intuitively, you can tell a period is a range of time between two dates. ITM Platform identifies periods as days, weeks, or months. Months are more generally used for accounting and financial analysis purposes.

When a project is created, so are the periods. For example, say a project starts on November 15th and ends on February 10th. It will have four periods: November, December, January, and February.

Whenever a Revenue Recognition is made, it will apply to one period. Therefore, you will be able to recognize revenue for each month, using the method of your choosing.

Actuals and forecast

When you select a revenue recognition method, establish a revenue budget, and set the project start and end dates, the system will automatically create a forecasted revenue recognition per period.

Forecasted revenue recognition is the expected revenue recognition for a future period. The forecast can use the revenue recognition method applied to the project or, if you configure it that way, it can just make a homogeneous distribution along all periods.

Once forecasts have been calculated, you can create an actual revenue recognition, starting with the first period.

Actual revenue recognition is usually applied to past periods and represents the revenue that has been recognized.

Amounts and percentages

Whenever revenue recognition is made, it will generate four relevant values per period: amount and percentage both for the period and accumulated to the project.

Let’s see an example:

The project has a revenue budget of 100,000 $ and has four periods. Let us assume each period will have the same revenue recognition of 25,000 $ each.

  • Revenue recognition amount for the period: the amount of money recognized on the period. In our example, this will be 25,000 $.
  • Accumulated revenue recognition amount: the amount of money recognized from the beginning of the project until that period. On the third period, it will be 75,000$
  • Revenue recognition percentage for the period: the proportion of the revenue recognition amount for the period over the total revenue budget. In our case, 25%
  • Accumulated revenue recognition percentage: the proportion of the accumulated revenue recognition amount for that period over the total revenue budget. On the third period, it will be 75%

 

Revenue Recognition Methods

 

Percentage-of-completion

This method calculates revenue recognition multiplying the project progress during the period by the total revenue budget.

Linear Distribution by Milestones

This method is based on “Revenue Milestones”. The value of each milestone is the proportion of its estimated hours within the project, multiplied by the total revenue budget

As opposed to the percentage-of-completion method, each milestone will consider a linear distribution of progress along time and will apply that percentage to-date to the milestone value, regardless of the progress reported.

To use this model, you need to create “Revenue Milestones” within the project plan. They are created equal to regular milestones but should also be marked as “Revenue Milestone” within the milestone’s general tab.
In the Gantt Chart, you should then set the milestone’s dependencies with the task you want to use in the revenue recognition of each revenue milestone. To include multiple tasks in the milestone’s revenue recognition, you have to create a summary task with those tasks and establish the dependency between the summary task and the milestone.

Fixed Price per Period

This method will divide the total revenue budget by the number of periods within the project, applying the same revenue recognition amount per period.

Bill Rate per Estimated Hours

This method recognizes the revenue as the result of multiplying the bill rate per professional category by the estimated hours of each task, factoring in the progress task as the proportion for that period.

Direct Revenue Recognition

This method recognizes all revenue, regardless of their status.

 

Getting Started with Revenue Recognition

Configuration

There are three locations where you can set your preferences for revenue recognition, from a higher level to the project itself:

  1. For the whole company, in Configuration → Project Parameters → Methods
  2. By project type, in Configuration → Project Parameters → Project Type.
  3. By project, in the General section of the project. This option will only be available if the option “Allow project settings to override this configuration” was ticked at the company level

Regardless of the level at which you configured the settings, these are the options you can configure:

  • Revenue Recognition Method: any of the methods offered by ITM Platform.
  • Forecast Recognition Method: use the same as Revenue Recognition Method or create a linear distribution over the future periods.
  • Revenue Recognition Periods: Months or weeks.
  • Whether the actual revenue recognition amount can be manually changed or not.

Project requirements to work with revenue recognition

Once you have chosen the options that best meet your needs, make sure your project has the necessary information:

  • Your project has both start and end dates. Otherwise, the system will not be able to create the periods.
  • Your project has a total revenue budget. You can set this value in the Budget section of the project, clicking on the “Edit Top-Down Budget” button.

Accessing the revenue recognition feature

If your project meets the requirements, it will show a new “Revenue Recognition” section under “Revenue”

There are two main subsections on this page:

  • Summary, which provides with condensed and graphical data about the current revenue recognition status
  • Revenue Recognition Periods, which will display a list of all actual and forecasted revenue recognition periods

The button “Add New Revenue Recognition” button will convert the next forecasted revenue recognition into actual revenue recognition.

You will be able to add a description and, if it was configured that way, change the period amount.

Once you save, the line will turn into actual revenue recognition, and the next forecasted period will be next to become actual.

Actual revenue recognitions can be deleted from the list in the reverse order they were created. A user with enough permissions can lock actual revenue recognition lines, so they cannot be changed or deleted.