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 in Settings > Accounting > Labor Options:
  • Enable 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 Vantagepoint 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 Overview tab of the Projects form in 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 Overview tab of the Projects form in 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 Overview tab of the Projects form in 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).
  • The 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