Estimates Versus Actuals Fields

Here is a description of the fields on an estimates versus actualsClosed Comparison of scheduled hours (estimates) and actual hours entered on timecards. comparison.

Key:
* – Mandatory field.
R – Read-only
A – Only available if the PSA Reporting Expansion Pack package is installed.

Note:

An estimates versus actuals comparison record requires either an assignment or a resource request.

Estimates Versus Actuals Fields
Field   Description
Actual Average Bill Rate  

Timecard Billable Amount divided by Actual Hours or Actual Days.

Note:

It is possible for a timecardClosed A mechanism for logging time against a project or an assignment. to have a different bill rate than its assignment. If a user edits the Assignment Bill Rate after the timecard is submitted; subsequent timecards may get the new rate.
Actual Billable Amount   The billable amount calculated from the resource's timecards.
Actual Billings A The Actual Billable Amount in PSA reports without the currency code.
Actual Days * Actual number of days worked during the time periodClosed A period of time with a start date and an end date to which forecasts, actuals calculations, billing event batches, utilization calculations and region plans belong..
Actual Days (Aggregated)   Actual number of days worked in the time period based on aggregated timecards by week.
Actual Hours * Actual number of working hours entered on timecards.
Assignment * Lookup to the related assignmentClosed Connection between a resource and a project..
Days Percent Variance R Percentage variation between the estimated and actual days. The formula for the calculation is:
(Actual Days – Estimated Days) / Estimated Days.
Days Variance R Difference between the estimated and actual days. The formula for the calculation is:
Actual Days – Estimated Days.
Est Vs Actuals Name   Name of the report.
Estimated Days   Number of days scheduled for work during the time period.
Note:

Calculation of estimated days respects hours to days rules when PSA is configured to do so.
Estimated Hours * Number of hours scheduled for work during the time period.
EvA Variance A Formula field used in PSA reports that shows the Actual Billable amount divided by the Scheduled Billings when the scheduled billings does not equal 0.0.
Hours Percent Variance R Percentage variation between the estimated and actual hours. The formula for the calculation is:
(Actual Hours – Estimated Hours) / Estimated Hours.
Hours Variance R Difference between the estimated and actual hours. The formula for the calculation is:
Actual Hours – Estimated Hours.
Project  

Lookup to the projectClosed A collection of activities and related items to be managed over a defined time range, such as timecards, expenses, milestones and budgets..

This is populated when you copy a held resource request from an opportunity to a project.
Project Currency Exchange Rate   Project (bill rate) exchange rate, relative to corporate currency, calculated on the end date of the schedule. If the schedule's end date is in the future, the latest available exchange rate is populated in the Project Currency Exchange Rate field. If the end date is today or in the past, the exact exchange rate for the matching date is populated. When the end date is in the past, the exchange rate is not updated again. To stamp all historic and scheduled EVA records where the project currency exchange rate value is not populated in this field, see Update Project Currency Exchange Rates on Milestones and EVAs.
Project Manager   Name of the project manager overseeing the assignment.
(Beta) Requested Billable Amount  

The billable amount for the related resource request. The rates used to calculate this amount are determined as follows:

  • If the resource request is linked to a rate card with a fixed bill rate, the resource request's suggested bill rate (or its requested bill rate if the suggested bill rate is not available) is used.
  • If the resource request is linked to a bill rate card with dated resource rates, the dated resource rates that apply across the resource request's duration are used.

The relevant rates are applied to the resource request's hours in the period covered by the EVA.
Resource   Lookup to the assigned resourceClosed A contact that works on a project..
Resource Request * Lookup to the held resource request relating to this estimates versus actualsClosed Comparison of scheduled hours (estimates) and actual hours entered on timecards. record.
Resource Request Bill Rate   The bill rate for the related resource request. This is calculated by dividing Requested Billable Amount by the resource request's hours in the period covered by the EVA.
Resource Request Days   The number of requested days scheduled for the work on the held resource request during the time period.
Resource Request Hours   The number of requested hours scheduled on the held resource request.
(Beta) Scheduled Billable Amount  

The scheduled billable amount if the related assignment has a bill rate card with dated resource rates. Depending on whether Bill Rate is Daily Rate is selected on the assignment, the relevant rates are applied to the hours or days set out on the assignment's schedule.

This field is blank if the estimates versus actuals comparison record is linked to either of the following:

  • An assignment that does not have a bill rate card
  • A resource request
Scheduled Bill Rate   The scheduled bill rate used by the estimates versus actuals comparison record. This is calculated by dividing Scheduled Billable Amount by the estimated number of hours or days, depending on whether Bill Rate is Daily Rate is selected on the assignment. If Scheduled Billable Amount is blank, this is the bill rate from the assignment.
Scheduled Bill Rate is Daily Rate   Indicates whether the scheduled bill rate is a daily rate.
Scheduled Billings A Formula field used in PSA reports that calculates the scheduled billings based on the estimated days or estimated hours depending on whether the Scheduled Bill Rate is Daily Rate checkbox is selected.
Start/End Date * Time period of the report.
Time Period   The time period to which the estimates versus actualsClosed Comparison of scheduled hours (estimates) and actual hours entered on timecards. numbers relate.
Time Period Type   The type of time periodClosed A period of time with a start date and an end date to which forecasts, actuals calculations, billing event batches, utilization calculations and region plans belong. applied to the estimates versus actuals record.
Timecards Submitted   Indicates whether timecards that affect this report have been submitted. The checkbox is deselected and selected automatically depending on whether additional timecards are saved or submitted respectively.