Billing Tab of the Project Review Form

Use this tab to compare billing amounts to actuals.

For any field with a blue, underlined amount, click the amount to open the corresponding dialog box of supporting detail. On the supporting detail dialog box you can also click any blue, underlined amount to see another level of detailed data on a second drill-down dialog box.

Fields on the Billing tab are impacted by the following settings on the Reporting tab of the Accounting System Settings form:

• Reporting at Billing Rates: When this option is selected , Project Review calculates amounts based on billing rates.
• Use Billing Currency not Project Currency: When this option is selected, project amounts are reported using the billing currency instead of the project currency. This option is only available if DPS is set up to use multiple currencies.

Contents

Field	Description
Principal	This field displays the employee at your enterprise who is identified as the project's principal. You can drill down on this employee name to display the employee's record in the Employees hub. You specify the principal assigned to the project on the General tab of the Projects hub.
Project Manager	This field displays the employee at your enterprise who is serving as the project manager for the project. You can drill down on this employee name to display the employee's record in the Employees hub. You specify the project manager assigned to the project on the General tab of the Projects hub.
Supervisor	This field displays the employee at your enterprise who is serving as the supervisor for the project. You can drill down on this employee name to display the employee's record in the Employees hub. The supervisor is assigned to the project on the General tab of the Projects hub.
Budget Source	If your enterprise has activated the Resource Planning module, you can decide whether you want to draw budgeted amounts from: The budget worksheet in the Accounting application (Budget Worksheet option). Tthe project plan in the Projects hub. You select the budget source on the Options dialog box. The budget source impacts the fields that display on the Billing tab. Refer to each field description for details.
Currency	If you use multiple currencies and report at billing rates in the billing currency (not the project currency), this field displays the billing currency of the project. Otherwise, it displays the project currency of the project.

Fee Analysis at Billing Value

Columns

The columns in this section provide an overview of the contract/fee, planned, and variance amounts at billing rates for your plan. The columns that display depend on the project's budget source and the project's charge type (regular, overhead, or promotional).

Field	Description
Contract/Fee	These fields display the user- entered compensation or fee amount. As you update these amounts, the planned and variance amounts automatically recalculate.
Planned	These fields display the planned amount at billing rates.
Variance	These fields display the difference between the contract/fee and planned amounts.

Rows

The rows of fields display the contract amounts, planned amounts, and variance for the following categories:

Field	Description
Compensation	This is the sum of all labor and direct expense amounts, which is added to the direct consultant amount.
Direct Consultants	This is the amount budgeted or spent on direct (non-reimbursable) consultants.
Reimbursable Allowance	This is the sum of reimbursable consultant and reimbursable expense amounts.
Total	This is the total of all compensation, direct consultant, and reimbursable allowance amounts.

Planning Analysis at Billing

Columns

The columns in this section provide an overview of the actual, estimate-to-complete (ETC), and estimate-at-completion (EAC) amounts at billing for your plan. The columns that display depend on the project's budget source and the project's charge type: regular, overhead, or promotional).

Field	Description
Actual	These fields display the actual amounts that are pulled from different areas.
ETC Starting <date>	These fields display the ETC amounts as of the date displayed. ETC labor amounts are the sum of the planned amounts at billing from the day after the displayed date forward. ETC expense and consultant amounts are the planned amounts at billing less the job-to-date (JTD) actual amounts through the displayed date.
Estimate-at-Completion	These fields display the EAC amounts: sum of the JTD actual amounts and ETC amounts as of the displayed date.

Rows

You can read down each row to view the amounts at billing for the following categories:

Field	Description
Compensation	These rows display the actual, ETC, and EAC amounts for labor and direct expenses.
Direct Consultants	This row displays the actual, ETC, and EAC amounts for direct consultants. This does not include reimbursable consultant amounts.
Reimbursable Allowance	These rows display the actual, ETC, and EAC amounts for reimbursable consultants and reimbursable expenses.
Total	This row displays totals for the preceding rows.

Job-to-Date Actual

Field	Description
Planned Ratio	This field displays when you plan at billing rates. This ratio is used to evaluate how much revenue a plan will return based on each labor billing dollar planned. Planned Total Compensation (Compensation + Consultant Fee + Reimbursable Allowance) - Direct and Reimbursable Expenses / Planned Labor Billing
Realization Ratio	The realization ratio is calculated in this way: Total Earned Value / Total Actual Billing Value
Planned Variance $	The planned variance amount is calculated in this way: Total Contract Compensation - Total Planned Compensation This field does not display if the project's charge type is overhead or promotional.
Earned Revenue	This field displays the actual JTD revenue for the current period.
Actual Bill Value	This field displays the actual JTD amount that was spent at billing for the period.
Actual Variance $	The actual variance amount is calculated in this way: Total Earned Actual - Total Billing Actual This field does not display if the project's charge type is overhead or promotional.
Actual Variance %	The actual variance percent is calculated in this way: Total Variance / Total Earned This field does not display if the project's charge type is overhead or promotional.
% Complete	This field displays the percent of the project that is complete.
% Expended Hour	The percent expended per hour is calculated in this way: Total Actual Hours / Total Planned Hours
% Expended $	The percent expended dollar amount is calculated in this way: Total Actual Hours / Total Planned Dollar Amount