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
. 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
|