| Excerpt | ||
|---|---|---|
| ||
Revenue Recognition - at the contract line item > revenue recognition landing page |
| Info | |
|---|---|
Revenue recognition is the process of realizing earned revenue. This is a manual process that ensures that accounting complies with Generally Accepted Accounting Practices (GAAP) and does not violate IRS laws. In Projector, this process is performed in bulk from the contract line item search page and individually from the revenue recognition landing pages for individual CLIs. Revenue recognition is most commonly run on Fixed Price contract line items. It is not advised and much less commonly run against Time and Materials or Not to Exceed contract line items.
|
| Tip | ||
|---|---|---|
| ||
|
At a Glance
Data
The revenue recognition landing page includes a information about the contract type & time contract term, who last ran rev rec and when they ran it, the date through with revenue has been recognized, as well as the amount of revenue recognized, revenue remaining to be recognized, and the time contract amount.
...
A full history of revenue recognition activity is available in tabular form along with downloadable PDFs for each rev rec run.
Actions
Revenue recognition can be run or undone as necessary.
Permissions and Settings
To perform revenue recognition you must have the cost center permission Revenue Recognition for the engagement's cost center.
...
- The accounting period should be closed and/or
- The associated projects should be closed for time
Running Revenue Recognition
The revenue recognition dialog is launched from the contract line item landing page. The contract line item can be found by performing a search on the Contract Line Item search page, navigating to the landing page, selecting the Revenue Recognition sub-page, and then clicking on the button "Run Revenue Recognition". Projector will present one of two dialogs depending on whether the contract line item has a Time Contract Terms of Percent Complete or a Revenue Schedule.
Percent Complete
At it's core, the percent complete revenue recognition process is pretty simple. The wizard allows you to selects a start date, an end date, and how much revenue you want to recognize between those two dates. Projector finds all the approved time cards between the dates, and allocates the revenue between all the time cards according to the selected Percent Complete method (Hours, Resource Direct Cost, or Contract Revenue).
Note: If you have run revenue recognition previously on your selected date range, then all time cards before the start date are left alone. All time cards after the cutoff date are given a revenue of 0.00 for fixed price CLIs and are revalued for T&M-based CLIs.
Revenue Schedule
If you are running revenue recognition for a CLI with time contract terms set to Fixed Price with revenue schedule, the revenue recognition dialog locks into the start dates, end dates, and scheduled revenue for each revenue schedule period. The dialog is very similar to the percent complete revenue recognition dialog, it's just missing the option to change how revenue is recognized, as percent complete calculations based on actual and scheduled work are not a factor when recognizing revenue for revenue schedule-based contract line items.
...
In the unlikely event that you have multiple unrecognized revenue schedule periods, the "Run Revenue Recognition" button will appear with a drop menu from which you are able to run rev rec against all unrecognized revenue periods in a single bulk action.
Dialog Pieces & Parts
Engagement & Contract Line Item Info
A reminder of the engagement, contract line item, and contract terms you about to recognize revenue for.
Date Range
For Percent Complete CLIs you can specify the date range for which revenue recognition should be run against.
...
| Options | Description |
|---|---|
| Begin Date | The first day of the period for which you want to recognize revenue. The begin date is typically set to the day after the last revenue recognition run's cutoff date, but you are able to select additional dates as necessary. Alternate begin dates include:
Additional Notes:
|
| Cutoff Date | The last day day of the period for which you want to recognize revenue. The cutoff date is initialized to the "Recognize revenue through" date on the rev rec landing page, and you can change it as appropriate. Date selections for the cutoff date include:
Additional Notes:
|
Revenue Amount
For Percent Complete CLIs, the lower half of the dialog is where you specify how much revenue should be allocated across the given time cards. You have four options. The first is an automatic calculation done by Projector. The remaining three are manual override amounts. Each is explained in the table below.
...
| Revenue Amount | Description |
|---|---|
| Calculate percent complete using the ratio of actual vs scheduled work and the (X) method | You will see one of three different wordings here depending on your installation's Percent Complete method.
This is the "automatic" option. Projector gathers the following information:
With this information in hand Projector can then calculate what percent of the work you have completed according to your Percent Complete Method (Hours, Contract Revenue, Resource Direct Cost). An explicit revenue number is then formulated ($X) and allocated to the approved time cards. This option works well when actual work and scheduled work are fully and accurately represented in Projector. Include Requested Hours in calculation - Consider requested hours as booked hours for the purposes of calculating percent complete. Useful when you have a plan that is in flux, but you know that requested hours will be incorporated. *The Resource Direct Cost option is grayed out unless you have the global permission Resource Direct Cost (RDC) Data |
| Override percent complete To | Rather than have Projector calculate your percent complete based on remaining booked hours, override that value to an explicit completeness percent. This is often chosen when you have a better idea of how complete a project is. For example, there may be a large number of hours left, but perhaps it is all easy, low-level work. You know that the project is more complete than what your scheduling data suggests. |
| Recognize total system revenue of | Enter the total revenue through the cutoff date, including revenue recognized prior to your begin date, that you would like recognized. For example, if two months ago you recognized 10k, and now for last month you earned another 5k, you would enter 15k here. Projector will back calculate the percent complete automatically. |
| Recognize period system revenue of | Projector looks at all revenue currently recognized (even in the future) and adds this number to it. That revenue is then applied to your revenue recognition period's specified date range. If there is already revenue on time cards in that date range, then the revenue is first removed and the new amount allocated. |
| Use the last billed milestone | Recognize the milestone amount of the last billed milestone for the period between the configured rev rec begin date and the last billed milestone's achieved date. |
Calculation Previews
There are two views of the revenue to be recognized. A summary view and a detail view. These views are present for both percent complete and revenue schedule CLI rev rec runs.
Revenue Recognition Summary
Displays the date range of the period for which revenue is being recognized, the revenue amount for the period, and the total contract revenue that will be recognized after the rev rec operation.
Calculation Details
The calculation details section shows all the information Projector gathered for this revenue recognition run and how it will be used to adjust your recognized revenue. The data points are displayed in three separate columns. The first column shows all your actuals to date. The second column shows all your estimates based on booked hours. The final column shows the sum of the first two as the estimate at completion.
...
| Row | Description |
|---|---|
| Method | You'll see one of four options displayed here. The first three are shown if you allowed Projector to calculate your revenue from the beginning of the project through your end date. Overridden is displayed if you manually specified a date period and revenue amount. If you let Projector do the calculations then it will show you the actual Hours / Contract Revenue / Billing Adjusted Revenue amounts.
|
| Percent Complete | The percent complete the project is as of your end date. |
| Proposed System Revenue | The total amount of revenue that will be recognized between the project start date and the revenue recognition end date. We also show how much recognized revenue is currently in that time period. |
| Proposed Adjustment | The difference between the current and proposed revenue amounts. This amount is viewable in the Revenue Recognition history viewer. |
Warnings
You may see the following warnings. Some of these warnings will prevent you from completing your revenue recognition run. Others are merely to notify you that something may need your attention.
Warning | Description |
|---|---|
| No eligible time cards exist from the beginning of the project through (date) to receive the proposed system revenue | Projector looked for time cards between your start and end dates, but was not able to find any. You cannot complete revenue recognition without having at least one approved time card in the specified period. You should add a time card and rerun revenue recognition or expand your start/end dates to encompass an existing time card. Why does Projector enforce this rule? Because according to GAAP you can only recognize revenue when work is done. If no work has been done, then no revenue should be recognized. |
| No scheduled hours exist starting (date) to receive the proposed revenue left to earn | You have recognized less than 100% of your contract, and Projector expects that remaining contract amount to be allocated on future time cards. You have no future booked hours, so currently there is nowhere for that revenue to land. |
| Cannot calculate percent complete because costs, rates or hours are zero | Projector cannot calculate how percent complete the project is because there is no revenue on the time cards. |
| Contract rates on scheduled hours are set to zero, preventing allocation of proposed revenue left to earn | Your percent complete method is set to Contract Revenue, but your contract rates are zero. Projector can't figure out what percent of work should be allocated to your current revenue recognition time period vs. your booked hours. You cannot complete revenue recognition. You should correct your contract rates and rerun revenue recognition. |
| The total contract revenue amount on eligible time cards is zero, preventing allocation of proposed changes to actuals to date | This warning will appear if the total contract revenue associated with eligible time cards prior to the end date is zero and therefore the proposed adjustment cannot be properly allocated. In this case, the first checkbox will be disabled. Note that the text of this warning will vary to reflect configured percent complete algorithm. |
| Draft, rejected or unapproved time cards exist prior to (date) | There are Draft, Rejected, or Unapproved time cards prior to your end date. These cards, if later approved, would enter the system but have zero recognized revenue on them. This is usually a bad thing because you want to paint the most accurate revenue picture possible. You should clean up the hours by submitting and approving them, moving them to another project, or deleting them from the system. |
Notes
The notes area is a place where you can store information about this revenue recognition run and why you made the choices you did. You can review these notes on your confirmation PDF, discussed next.
Revenue Recognition Confirmation PDF
Each time you run revenue recognition the details of the run are stored in a PDF file. At any time you can view this detailed PDF from the history browser (see the history browser docs below).
...
Field | Description |
|---|---|
| User | The user account that performed this revenue recognition |
| Date/Time | The date and time that this revenue recognition run was performed. Timezone reflects your installation's time zone. |
| Client | The client associated with this engagement |
| Engagement | The engagement associated with this contract |
| Contract Terms | The terms as specified on the contract line item landing page |
| Currency | The currency as specified on the engagement landing page |
| Cutoff Date | The end date selected for this revenue recognition run. All previously recognized revenue after this date is zeroed out. |
| Proposed Adjustments | The table shows your revenue recognition method, actuals, and more. See the Confirmation Screen section of this page for full details of this table. |
| Warnings | There are a number of possible warnings. These would have been shown to the revenue recognition runner prior to completing their run. See the warnings section of this page for an explanation of each. |
| Notes | When a user performs revenue recognition they have the option of typing in notes about what they did and why. These are entered here. |
| Projector Confirmation ID | The confirmation ID consists of the engagement code followed by a colon and then the date/time in ET format Year, Month, Day, Time format (YYYYMMDDTTTTTT) |
Undo Revenue Recognition / Reverse Rev Rec
When new time cards are approved within already rev rec'd periods, in order to allocate revenue to them, you should unrecognize revenue for the period and then rerun revenue recognition to spread the revenue across all approved cards within the date range. Other actions requiring revenue recognition to be undone include: transferring time to another project, unapproving, or deleting time cards that have recognized revenue.
...
- Reversing Revenue Recognition in the Management Portal
Revenue Recognition Activity Tables
You can view past revenue recognition activity right on the revenue recognition landing page. There is a History view that shows the high-level details of each and every rev rec run, and a Net view that hides overwritten runs and shows fewer data columns for a more compact information display.
Recognized Revenue (History)
View who, what, when, and how much for each rev rec run in the history view.
Recognized Revenue (Net)
Simplify the view down to when and how much only for periods that have not been overwritten with the net view. If you compare the two views displayed here, you will see that the first four rows of data in the history view (above) are omitted from the net view (below). They are omitted because they have been overwritten by subsequent rev rec runs.
...