Billing Tab of the Project Review Form

Use this form to compare billing amounts to actuals.

This tab only displays when:
  • The Budget Source is set to Project Plan.
  • The 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.

Fields on 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 Billing application is installed.
  • Use Billing Currency not Project Currency: When this option is selected, project amounts are reported using the billing currency instead of the project currency.

Contents

Field Description
Principal-In-Charge 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 uses the Planning application, you can decide whether you want to draw budgeted amounts from:
  • The budget worksheet in the Accounting application (Budget Worksheet option).
  • A mapped plan in the Project Planning application (Project Planning option).

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 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 that your company selected from the list of enabled currencies.

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

You can read down each row to view the contract or planned amounts 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 The reimbursable allowance includes all expenses that will be reimbursed to your company by the client, including reimbursable consultant fees.
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, and Estimate at Complete 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.
Estimate to Complete These fields display the amounts remaining to complete. The ETC is calculated based on the application in which the plan was created.
Estimate at Complete These fields display the sum of the actual and estimate to complete amounts.

Rows

You can read down each row to view the actual and estimate to complete amounts 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 reimbursable allowance includes all expenses that will be reimbursed to your company by the client, including reimbursable consultant fees.
Total This is the total of all compensation, direct consultant, and reimbursable allowance amounts.

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 job-to-date revenue for the current period.
Actual Bill Value This field displays the actual job-to-date 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