Deliverable Recognition Method

If you are using the integration between PSA and Revenue Management, records looking up to a template in Revenue Management of type "Deliverable" that fall within the monthly time periods spanning the project duration are included, with the exception of Est Vs Actuals (EVA) records. EVA records only need to meet the criteria listed below.

Tip:

To configure the template in Revenue Management, use the Actuals Template setting in the Revenue Management Settings custom setting. For more information, see Managing Custom Settingsin the Revenue Management Help.

If you run Revenue Forecasting after revenue has been recognized, the revenue is displayed in the Revenue Recognized to Date field on the revenue forecast record for the monthly time period that corresponds to the date the revenue was recognized in Revenue Management.

If you are not using the integration between PSA and Revenue Management, Revenue Forecasting looks at the Recognition Method field on a record, which must have a value of "Deliverable".

Includes scheduled hours for the resources assigned to the project, taking into account the hours and bill rates associated with those resources.

EVA records that meet the following criteria are included:

• The Type field in the Time Period lookup has a value of Month.
• The time period set on the EVA falls between the project start and end date, or overlaps one of those dates.
• For EVA records generated for assignments, the assignment record in the Assignment lookup has:
  • The Billable checkbox selected.
  • A value in the Bill Rate field that is not zero or null.
• For EVA records generated for held resource requests:
  • The value in the Resource Request Hours field is greater than zero.
  • The value in the Resource Request Bill Rate field is greater than zero.
  • The held resource request does not have an associated assignment.

For assignments, the following calculations are used to work out the number of scheduled hours or days:

• Estimated Hours - Actual Hours (if the Scheduled Bill Rate is Daily Rate checkbox is set to false)
• Estimated Days - Actual Days (if the Scheduled Bill Rate is Daily Rate checkbox is selected)

Note:

If the value in the Actual Hours field is less than zero, it is treated as zero for the purposes of the calculation.

The following calculation is used to work out the scheduled revenue:

Scheduled Hours or Scheduled Days * Scheduled Bill Rate

For held resource requests, Revenue Forecasting calculations use the value in the Resource Request Hours field multiplied by the value in the Resource Request Bill Rate field.

The value in the Scheduled Revenue field on each revenue forecast type record is calculated using values taken from the monthly EVA records that fall within the same time period as the revenue forecast.

For more information about the fields on an EVA record, see Estimates Versus Actuals Fields.

Tip:

To exclude EVA records that relate to specific assignments or resource requests from the forecast, you can set up PSA to exclude records that have the checkbox you nominate selected. EVA records generated for assignments and resource requests for use in fixed fee forecast calculations are unaffected. For more information, see Excluding Selected Assignments and Resource Requests (Deliverable Revenue).

When calculating the revenue for assignments and resource requests, PSA uses the values in the following fields by default:

• The Bill Rate field on an assignment record.
• The Resource Request Bill Rate field on related EVA records.

If required, you can configure PSA to use the values in different fields on assignment or resource request records instead of the default fields. This affects the revenue forecasts in the following way:

• Only EVA records containing a value or zero in the nominated fields are included.
• The following calculation is used to work out the revenue for a monthly time period:
  
  Total hours or days on the EVA record * Value in the nominated assignment or resource request fields.

For information on how to set up PSA to use nominated fields instead of the default bill rate fields, see Specifying the Fields to Use Instead of Bill Rate on Assignments and Resource Requests (Deliverable Revenue).

Expense records that meet the following criteria are included:

• The Approved checkbox is selected.
• The Billable checkbox is selected.
• The value in the Expense Date field falls within a monthly time period of a revenue forecast.

The Revenue Pending Recognition field on each revenue forecast type record contains the sum of the values in the Billable Amount field for all expense records in a given month.

Tip:

If you do not want the Effective Date field on an expense record to determine the month in which expense revenue is placed, you can create a custom field and add it to the Custom Date for Deliverable Expenses field on the revenue forecast setup record. For more information, see Determining the Month Deliverable Expense, Milestone, or Misc Adjustment Revenue Is Added To.

For more information about the fields on an expense record, see Expense Entry Page Fields.

Note:

The value in the Planned Hours field on a milestone is used in the revenue forecast calculation as the total hours.

For completed milestones, milestone records that meet the following criteria are included:

• The Approved checkbox is selected.
• The Exclude from Billing checkbox is set to false.
• The value in the Actual Date field falls within a monthly time period of the revenue forecast.

The Revenue Pending Recognition field on the revenue forecast type record contains the sum of the values in the Milestone Amount field for all completed milestone records in a given month.

For scheduled milestones, milestone records that meet the following criteria are included:

• The Approved checkbox is set to false.
• The Exclude from Billing checkbox is set to false.
• The value in the Target Date field falls within a monthly time period of the revenue forecast.

The Scheduled Revenue field on the revenue forecast type record contains the sum of the values in the Milestone Amount field for all scheduled milestone records in a given month.

Tips:

If you do not want the Actual Date or Target Date fields on a milestone record to determine the month in which PSA places completed or scheduled milestone revenue, you can create a custom field and add it to the Custom Date for Deliverable Milestones field on the revenue forecast setup record. For more information, see Determining the Month Deliverable Expense, Milestone, or Misc Adjustment Revenue Is Added To.

If you do not want PSA to use the value in the Milestone Amount field on the milestone record as the total amount in revenue forecast calculations, you can specify an alternative numeric field in the Total Revenue Field on Milestone field on the active revenue forecast setup record. For more information, see Specifying the Field Containing the Total Milestone Revenue (Deliverable, % Complete, and Equal Split Revenue).

For more information about the fields on a milestone record, see Milestone Fields.

Miscellaneous adjustment records that meet the following criteria are included:

• The Approved checkbox is selected.
• The Exclude from Billing checkbox is set to false.
• The value in the Effective Date field falls within a monthly time period of a revenue forecast.

The Revenue Pending Recognition field on the revenue forecast type record contains the sum of the values in the Amount field for all miscellaneous adjustment records within a given month.

Note:

If the effective date on a misc adjustment record is in a future month, the revenue is added to the current month.

Tip:

If you do not want the Effective Date field on a misc adjustment record to determine the month in which misc adjustment revenue is placed, you can create a custom field and add it to the Custom Date for Deliverable Misc Adjusts field on the revenue forecast setup record. This only works if the custom date is in the current month or a past month. If the custom date is in a future month, the revenue will be added to the current month instead. For more information, see Determining the Month Deliverable Expense, Milestone, or Misc Adjustment Revenue Is Added To.

For more information about the fields on a miscellaneous adjustment record, see Miscellaneous Adjustment Fields.

Timecard split records that meet the following criteria are included:

• The value in the Status field matches one of the values displayed in the Timecard Statuses field on the Est Vs Actuals custom setting.
• The Billable checkbox is selected.
• The values in the Start Date and End Date fields fall within a monthly time period of a revenue forecast.

The Revenue Pending Recognition field on the revenue forecast type record contains the sum of the Total Billable Amount for all timecard split records in a given month.

Note:

The bill rate on an assignment associated with a timecard cannot be zero.

For more information about the fields on a timecard record, see Timecard Entry Fields.

If you are using the integration between PSA and Revenue Management, when you run a revenue forecast, the revenue is treated in the following way when there are closed monthly time periods:

• Closed period, full amount recognized: the full approved billable amount is displayed in the Revenue Recognized to Date field on the revenue forecast record for the closed time period.
• Closed period, partial amount recognized: the part of the approved billable amount that has been recognized is displayed in the Revenue Recognized to Date field on the revenue forecast record for the closed time period. The remainder is displayed in the Revenue Pending Recognition field on the revenue forecast record for the next open time period.
• No open time period within project duration: a revenue forecast record is created for the next available open time period and any revenue that has not been recognized is displayed in the Revenue Pending Recognition field on this record. If the revenue is subsequently recognized and you run Revenue Forecasting again, the revenue is moved into the Revenue Recognized to Date field on the revenue forecast record for the time period that corresponds to the date the revenue was recognized in Revenue Management.

If you are not using the integration between PSA and Revenue Management and you run a revenue forecast, the revenue is treated in the following way when there are closed monthly time periods:

• Actual revenue is displayed in the Revenue Pending Recognition field on the revenue forecast record.
• Any scheduled or unscheduled revenue is ignored.

• Start Date = March 12.
• End Date = May 23.
• Timecard split and expense records are set up to be recognized on delivery.
• The monthly time period records for February and March have the Closed for Forecasting checkbox selected.

There is one billable assignment with the following attributes:

• Assigned to resource: Sanjay Singh.
• Bill Rate = $200.
• Start Date = March 12.
• End Date = May 23.
• Total scheduled hours = 120.
• Schedule or schedule exceptions = 40 hours per month.

The following diagram gives details of the dates, time periods, and records included in the forecast.

When Revenue Forecasting is run on the project, the following fields are updated on the revenue forecast records relating to each monthly time period.

Fields Updated

Field	$ Revenue
	March	April	May
Revenue Recognized To Date	$7,450	$0	$0
Revenue Pending Recognition	$0	$9,480	$0
Scheduled Revenue	$0	$0	$8,000
Unscheduled Revenue (not currently supported for time and materials projects recognized on delivery)	$0	$0	$0

The following revenue forecast type records are created.

Revenue Forecast Type Records and Values in Relevant Fields

		$ Value in Revenue Forecasting Fields
Revenue Source	Revenue Forecast Type	March	April	May
Deliverable EVA	Forecast	Revenue Recognized To Date: $0 Revenue Pending Recognition: $0 Scheduled Revenue: $0 Unscheduled Revenue: $0	Revenue Recognized To Date: $0 Revenue Pending Recognition: $0 Scheduled Revenue: $0 Unscheduled Revenue: $0	Revenue Recognized To Date: $0 Revenue Pending Recognition: $0 Scheduled Revenue: $8,000 Unscheduled Revenue: $0
Deliverable Expense	Actual	Revenue Recognized To Date: $450 Revenue Pending Recognition: $0 Scheduled Revenue: $0 Unscheduled Revenue: $0	Revenue Recognized To Date: $0 Revenue Pending Recognition: $280 Scheduled Revenue: $0 Unscheduled Revenue: $0	Revenue Recognized To Date: $0 Revenue Pending Recognition: $0 Scheduled Revenue: $0 Unscheduled Revenue: $0
Deliverable Timecard	Actual	Revenue Recognized To Date: $7,000 Revenue Pending Recognition: $0 Scheduled Revenue: $0 Unscheduled Revenue: $0	Revenue Recognized To Date: $0 Revenue Pending Recognition: $9,200 Scheduled Revenue: $9,200 Unscheduled Revenue: $0	Revenue Recognized To Date: $0 Revenue Pending Recognition: $0 Scheduled Revenue: $0 Unscheduled Revenue: $0

Notes

The March time period is closed for forecasting. No billable timecards have been approved for the two scheduled hours that are outstanding in March (see diagram above). These scheduled hours are ignored by Revenue Forecasting.

In March, the expected $7,600 revenue from timecards does not match what the Revenue Manager has recognized. The March time period is closed for forecasting, so the remaining $600 moves to the April time period to be recognized together with the revenue from the April timecards.

In April, Sanjay logged more time than was scheduled, so there is no scheduled revenue for this month.