Billing Tab of Project Review

Use this form to compare billing amounts to actuals for the plan.

Contents

This tab only displays when:
  • The Budget Source is set to Project Plan.
  • The Vision Billing application is installed.
  • The Reporting at Billing option is selected in Accounting System Settings.

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.

Field Description
Principal This field displays the employee at your firm who is identified as the project's principal. You can drill down on this employee name to display the employee's record in the Employee Info Center. You specify the principal assigned to the project on the General tab of the Project Info Center.
Project Manager This field displays the employee at your firm 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 Employee Info Center. You specify the project manager assigned to the project on the General tab of the Project Info Center.
Supervisor This field displays the employee at your firm 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 Employee Info Center. You specify the supervisor assigned to the project on the General tab of the Project Info Center.
Budget Source

This field displays the budget source, which draws budgeted amounts from the mapped plan.

You select the budget source on the Options dialog box in Accounting > Project Review. The budget source impacts the fields that display on the Billing Analysis tab. Refer to each field description for details.

Currency

If your firm uses the Multicurrency feature and if you report at billing rates in Billing Currency not Project Currency, this field displays the billing currency of the project. Otherwise, it displays the project currency of the project. that your company selected from the list of enabled currencies.

Fields in the Billing Tab are impacted by the following Accounting System Settings:
  • Reporting at Billing Rates - When this option is selected, project review displays amounts based on billing and cost rates. This option is only available if the Vision Billing application is installed.
  • Use Billing Currency not Project Currency - When you use the Multicurrency feature and this option is selected, project amounts are reported using the billing currency instead of the project currency.

Fee Analysis at Billing Value

Use these fields to review the project's billing amounts.

Field Description
Compensation

These fields display the different amounts that represent the total compensation your company expects to receive for the project. The compensation amount should include labor services and direct expenses. You specify these amounts in the compensation fields on the Budget & Revenue tab of the Project Info Center.

Direct Labor

Contract/Fee: The sum of all planned direct labor amounts from the Project Info Center.

Plan/Budget: The sum of all planned or budgeted direct labor amounts at billing.

Variance: The variance between the Contract/Fee and Plan/Budget amounts. Vision calculates the variance in this way:

Contract/Fee - Plan/Budget

This field does not display if the project's charge type is Overhead or Promotional.

Direct Labor Hours

Plan/Budget: The total number of hours budgeted for labor.

Average Base Rate/Hour

Plan/Budget: The average rate amount that is budgeted per hour at billing. Vision calculates the plan/budget amount in this way:

Direct Labor / Direct Labor Hours

Direct Expense

Contract/Fee: The amount budgeted for other direct expenses (not including direct consultant expenses).

Plan/Budget: The actual amount spent on direct expenses (not including direct consultant expenses).

Variance: The variance between the budgeted and actual expense amounts. Vision calculates the variance in this way:

Contract/Fee - Plan/Budget

This field does not display if the project's charge type is Overhead or Promotional.

Direct Consultant

Contract/Fee: The amount budgeted for direct (non-reimbursable) consultants.

Plan/Budget: The actual amount spent on direct consultants.

Variance: The variance between the budgeted and actual consultant amounts. Vision calculates the variance in this way:

Contract/Fee - Plan/Budget

This field does not display if the project's charge type is Overhead or Promotional.

Reimbursable Allowance

These fields displays the monetary amount of your company's reimbursable allowance for the project. The reimbursable allowance includes all expenses that will be reimbursed to your company by the client, including reimbursable consultant fees. You specify these amounts in the reimbursable allowance fields on the Budget & Revenue tab in the Project Info Center.

Reimbursable Expense

Contract/Fee: The budgeted expense amount that is expected to be reimbursed by the client.

Plan/Budget: The actual expense amount that is reimbursed by the client.

Variance: The variance between the budgeted and actual reimbursable expense amounts. Vision calculates the variance in this way:

Contract/Fee - Plan/Budget

This field does not display if the project's charge type is Overhead or Promotional.

Reimbursable Consultant

Contract/Fee: The amount of consultant fees that is budgeted to be reimbursed by the client.

Plan/Budget: The actual reimbursable consultant expense amount that is spent on this project.

Variance: The variance between the budgeted and actual reimbursable expense amounts. Vision calculates the profit/loss variance in this way:

Contract/Fee - Plan/Budget

This field does not display if the project's charge type is Overhead or Promotional.

Total Contract These fields display the total of the amounts that are either entered or automatically calculated in the Compensation, Direct Consultant, and Reimbursable Allowance fields.

Contract/Fee: The total amount budgeted for the contract, which is calculated by adding the Labor, Direct Expense, Direct Consultant, Reimbursable Expense, and Reimbursable Consultant amounts from this column.

Plan/Budget: This field displays the actual labor amount budgeted for the contract, which is calculated by adding the Labor, Direct Expense, Direct Consultant, Reimbursable Expense, and Reimbursable Consultant amounts from this column.

Variance: The total variance amount for the contract. Vision calculates the variance between the Contract/Fee amount and the Plan/Budget amount in this way:

Contract/Fee - Plan/Budget

This field does not display if the project's charge type is Overhead or Promotional.

Planning Analysis at Billing Value

If you report at billing rates in Billing Currency, all fields in this section display the billing currency of the project; otherwise, they display the project currency of the project.

Field Description
Direct Labor Actual: The actual direct labor amount for the current period.
Estimate to Complete: The direct labor amount remaining. The calculation for this field depends on the Budget Source setting:
  • If the Budget Source is Project Planning, the total planned row from the effective date to the completion of the project displays.
  • If the Budget Source is Budget Worksheet, the labor amount is the total amount in the Estimate to Complete column.

Estimate at Complete: The amount estimated at completion. Vision calculates the estimate at complete in this way:

Actual + Estimate to Complete

Direct Labor Hours Actual: The actual labor hours used during the current period.
Estimate to Complete: This field displays the amount of hours remaining to completion. The calculation for this field depends on the Budget Source setting:
  • If the Budget Source is Project Planning, the total planned row from the effective date to the completion of the project displays.
  • If the Budget Source is Budget Worksheet, the total hours in the Estimate to Complete column displays.

Estimate at Complete: The amount estimated to completion. Vision calculates the Estimate at Complete in this way:

Actual + Estimate to Complete

Average Base Rate / Hour Actual: The actual base rate that is spent per labor hour at billing during the current period. Vision calculates the Average Base Rate in this way:

Direct Labor Amount / Direct Labor Hours

Estimate to Complete: The amount of hours estimated to completion. The calculation for this field depends on the Budget Source setting:
  • If the Budget Source is Project Planning, the total planned row from the effective date to the completion of the project displays.
  • If the Budget Source is Budget Worksheet, the labor amount is the total amount in the Estimate to Complete column.

Estimate at Complete: The amount estimated at completion. Vision calculates the Estimate at Complete in this way:

Actual + Estimate to Complete

Direct Expense

The planned direct expense billing amount should include expenses that are not reimbursable.

Actual: The actual amount paid for direct expenses during the current period.

Estimate to Complete: The amount remaining to complete. The calculation for this field depends on the Budget Source setting:
  • If the Budget Source is Project Planning, the total planned row from the effective date to the completion of the project displays.
  • If the Budget Source is Budget Worksheet, the labor amount is the total amount in the Estimate to Complete column.

Estimate at Complete: The amount estimated at completion. Vision calculates the Estimate at Complete amount in this way:

Actual + Estimate to Complete

Direct Consultant

The planned direct consultant billing amount should include fees for consultant work that are not reimbursable. You specify this amount in the Direct Consultant field in the Project Info Center.

Actual: The actual amount spent for direct (non-reimbursable) consultants.

Estimate to Complete: The amount remaining to complete. The calculation for this field depends on the Budget Source setting:
  • If the Budget Source is Project Planning, the total planned row from the effective date to the completion of the project displays.
  • If the Budget Source is Budget Worksheet, the labor amount is the total amount in the Estimate to Complete column.

Estimate at Complete: The amount estimated at completion. Vision calculates the Estimate at Complete amount in this way:

Actual + Estimate to Complete

Reimbursable Allowance

Refer to these fields for the individual amounts that make up the total reimbursable allowance. Reimbursable Allowance is calculated as Reimbursable Expense plus Reimbursable Consultant.

Reimbursable Expense

Actual: The actual amount of planned reimbursable expense billing amounts.

Estimate to Complete: The amount of planned reimbursable expense billing amounts remaining to complete. The calculation for this field depends on the Budget Source setting:
  • If the Budget Source is Project Planning, the total planned row from the effective date to the completion of the project displays.
  • If the Budget Source is Budget Worksheet, the labor amount is the total amount in the ETC column.

Estimate at Complete: The amount of planned reimbursable expenses estimated at completion. Vision calculates the Estimate at Complete in this way:

Actual + Estimate to Complete

Reimbursable Consultant

Actual: The actual amount of planned reimbursable consultant billing amounts.

Estimate to Complete: The planned reimbursable consultant billing amount remaining to completion. The calculation for this field depends on the Budget Source setting:
  • If the Budget Source is Project Planning, the total planned row from the effective date to the completion of the project displays.
  • If the Budget Source is Budget Worksheet, the labor amount is the total amount in the ETC column.

Estimate at Complete: The amount estimated to completion. Vision calculates the Estimate at Complete in this way:

Actual + Estimate to Complete

Total Contract These fields display the total of the amounts that are either entered or automatically calculated in the Compensation, Direct Consultant, and Reimbursable Allowance fields.

Actual: The total amount entered for the contract, which is calculated by adding the Labor, Direct Expense, Direct Consultant, Reimbursable Expense, and Reimbursable Consultant amounts from this column.

Estimate to Complete: The total amount estimated to complete, which is calculated by adding the Labor, Overhead (if in use), Direct Expense, Direct Consultant, Reimbursable Expense, and Reimbursable Consultant amounts from this column.

Estimate at Complete: The total amount spent when the contract is complete. Vision calculates the Estimate at Complete in this way:

Actual + Estimate to Complete.

Job-to-Date Actual

Field Description
Planned Ratio The Planned Ratio is shown when planned at Billing. It 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 Vision calculates the Realization Ratio in this way:

Total Earned Value / Total Actual Billing Value

Planned Variance $ Vision calculates the Planned Variance amount 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 The actual Job-to-Date revenue that is associated with the current period.
Actual Bill Value The actual Job-to-Date amount that was spent at billing that is associated with the period.
Actual Variance $ Vision calculates the Actual Variance amount 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 % Vision calculates the Actual Variance percent in this way:

Total Variance / Total Earned

This field does not display if the project's charge type is Overhead or Promotional.

% Complete The percent of the project that is complete.
% Expended Hour Vision calculates the percent expended per hour in this way:

Total Actual Hours / Total Planned Hours

% Expended $ Vision calculates the percent expended dollar amount in this way:

Total Actual Hours / Total Planned Dollar Amount