Construction Bonding Report
Form ID: (PM650500)
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:
|
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: In this formula, |
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:
|
|
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:
|
|
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. |