Estimates Versus Actuals Fields

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

Key:
* – Mandatory.
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.

Field		Description
Actual Average Bill Rate		Timecard Billable Amount divided by Actual Hours or Actual Days. Note: It is possible for a timecard 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 period 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 assignment 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 project 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.
Resource		Lookup to the assigned resource A contact that works on a project..
Resource Request	*	Lookup to the held resource request relating to this estimates versus actuals Comparison of scheduled hours (estimates) and actual hours entered on timecards. record.
Resource Request Bill Rate		The bill rate currency amount for the requested resource. The Resource Request Bill Rate field is calculated in the project currency when an EVA record is generated. If the Suggested Bill rate on the Rate Card object is not available, the Requested Bill Rate on the Resource Request object is used.
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.
Scheduled Bill Rate		The assignment bill rate multiplied by the estimated hours shown on the Estimates Versus Actuals page, or multiplied by the estimated days if a daily bill rate is in use
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 actuals Comparison of scheduled hours (estimates) and actual hours entered on timecards. numbers relate.
Time Period Type		The type of time period 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.