Construction Bonding Report

Form ID: (PM650500)

Attention: This report is available only if the Construction feature is enabled on the Enable/Disable Features (CS100000) form.

This report is specifically designed to give a wide-angle snapshot of all the projects in the system and helps users to analyze how much has actually been billed for the project compared to the percentage of the project completion.

The report provides the following information: the project’s percentage of budget completion, the amounts of the project billed to a period, the earned revenue, and the billed and unbilled contract amounts. It also displays project costs incurred as of period or calculated at completion, and the billings and costs for the current period and the prior year.

See the following section for a description of each parameter on the Report Parameters tab of the report form. For more information about using other elements on the report form, see Reports.

Report Parameters

On the Report Parameters tab, you use the following parameters to select the information to be displayed on the report:

  • Company/Branch: The company or branch for which you want to view information. You can select a company or make no selection to view information about all companies in the tenant.

    By default, the system inserts the company or branch selected on the Company and Branch Selection menu.

  • As of Period: The period for which the values in the report are displayed. By default, the current financial period is selected.
  • Status: The status of the project for which you want to view the report, which is one of the following:
    • Active (default)
    • Completed
    • Active and Completed
  • Exclude Projects Completed Through Date: The date the system will use to exclude from the generated report completed projects that have an End Date earlier than or the same as the date specified in this box.
  • Project: The project for which you want to view the report. You can select a project to view the report for only this project, or leave the box blank to view the report for all projects.
  • Planned Cost Estimation: The source of the costs that the system will use to calculate the report values. The following options are available:
    • By Cost Budget (default): The system will use the revised budgeted amounts of the cost budget lines for calculations.
    • By Cost Projection: The system will use the amounts from the last released cost projection for calculations.

The Generated Report

This section describes some key elements of the generated report to help you use this report successfully. The row for each project includes the columns whose values are described below.

Column Value Comments
Contract Amount The contract amount of the project, which the system calculates by using the following formula: Contract Amount = SUM of Original Budgeted Amount values + SUM of CO Revenue Budget Change Total values. In this formula, SUM is the sum of the respective amounts in the revenue budget. The values in the Contract Amount column now include the amounts of the change orders that have been released prior to and within the period specified in the As of Period report parameter.
% Complete The percentage of budget completion of the project, which the system calculates by using the following formula:
  • If the report is prepared with By Cost Budget selected in the Planned Cost Estimation box, Complete % = Cost to Period / Cost at Completion * 100%
  • If the report is prepared with By Cost Projection selected in the Planned Cost Estimation box, Complete % = Cost to Period / Projected Cost at Completion * 100%

In both cases, if the calculated value exceeds 100%, % Complete is set to 100.

Earned Revenue The revenue amount of the project, which the system calculates by using other values of the row of the report in the following formula: Earned Revenue = % Complete * Contract Amount.
Billings to Period

The billed amount of the project, which the system calculates by using the following formula: Period Billings = SUM of Amount values.

In this formula, SUM of Amount values is the sum of the relevant project transactions with the AR type on the Project Transactions (PM304000) form that have been released prior to and within the period specified in the As of Period report parameter.

The project transactions that originate from AR invoices and debit memos increase the calculated amount; the project transactions that originate from AR credit memos decrease the calculated amount.

% Billed The percentage of the contract amount that has been billed, which the system calculates by using the following formula: % Billed = Billings to Period / Contract Amount * 100 %.
Over/Under Billed The overbilling or underbilling amount of the project, which the system calculates by using other values of the report in the following formula: Over/Under Billed = Earned Revenue – Billings to Period.
Unbilled Contract Amount The unbilled amount of the project, which the system calculates by using other values of the report in the following formula: Unbilled Contract Amount = Contract Amount – Billings to Period.
Costs to Period The cost of the project, which the system calculates by using the following formula:Costs to Period = SUM (Actual Amount). In this formula, Actual Amount is the actual amount in a cost budget line of the project.
Cost to Complete The cost to complete the project, which the system calculates by using the following formula: Cost to Complete = Cost at Completion - Costs to Period. In this formula, Cost to Complete is the cost to complete amount in a cost budget line of the project.
Projected Cost to Complete The projected cost to complete the project, which the system calculates by using the following formulas:
  • If there is no released cost projection for the period, Projected Cost to Complete = Cost to Complete.
  • If there is a released cost projection for the period, Projected Cost to Complete = SUM of Projected Cost to Complete. In this formula, SUM is the sum of the respective amounts in the cost budget.
Cost at Completion The cost of the project at completion, which the system calculates by using the following formula: Cost at Completion = SUM of Original Budgeted Amount values + SUM of CO Cost Budget Change Total values. In this formula, SUM is the sum of the respective amounts in the cost budget.
Projected Cost at Completion The projected cost of the project at completion, which the system calculates by using the following formulas:
  • If there is no released cost projection for the period: Projected Cost at Completion = Cost at Completion.
  • If there is a released cost projection for the period: Projected Cost at Completion = SUM of Projected Cost at Completion. In this formula, SUM is the sum of the respective amounts in the cost budget.
Period Billings The turnover revenue amount for the specified period, which the system calculates by using the following formula:Period Billings = SUM (Amount). In this formula, Amount is the amount of a project transaction of this project with the AR type on the Project Transactions (PM304000) form that has been released prior to and within the period specified in the As of Period report parameter.

The project transactions that originate from AR invoices and debit memos increase the calculated amount; the project transactions that originate from AR credit memos decrease the calculated amount.

Period Costs The turnover cost amount for the specified period, which the system calculates by using the following formula:Period Costs = SUM (Amount). In this formula, Amount is the amount of an expense project transaction of this project on the Project Transactions (PM304000) form.
Billed Through The turnover billing amount for the previous financial year: Billed Through = SUM (Amount). In this formula, Amount is the amount of a project transaction of this project with the AR type on the Project Transactions (PM304000) form.

The project transactions that originate from AR invoices and debit memos increase the calculated amount; the project transactions that originate from AR credit memos decrease the calculated amount.

Cost Through The turnover cost amount for the previous financial year: Cost Through = SUM (Amount). In this formula, Amount is the amount an expense project transaction of this project on the Project Transactions (PM304000) form.