Payment estimate reports

Last updated: 2023-02-24

There are currently 4 base and 3 historical payment estimate reports. Instructions appear below to generate a report for a payment estimate or print a historical payment estimate report.

  1. From the Contract Payment Estimate Summary component, select the Component Actions Menu | Reports.
  2. Under Reports, select the report to be printed.
    • Insufficient Materials
    • Items with Unpaid Placed Quantities
    • Payment Estimate for Contractor
    • Payment Estimate Report
    • Summary By Project Report

  3. Do not change the system default settings (Output Type = Generate as PDF, Report Layout Source = Custom)
  4. Click <Execute>. The report will open in an new browser window and can be viewed, printed or saved.
  1. From the Contract Payment Estimate Summary component, select the Component Actions Menu | Reports.
  2. Under reports, select the historical report:
    • Items with Unpaid Placed Quantities
    • Payment Estimate for Contractor
    • Payment Estimate Summary By Project Report

  3. The report will be saved in PDF format to the current user profile \Download folder. Within File Explorer, open file. It can be saved or printed.

Requirement: If a historical payment estimate report is not accessible, all approvals for the payment estimate have not been received. Select the Approval Tracking tab to determine who has not approved the payment estimate.

Report Name Report Type Description
Insufficient Materials Report Base (N/A at this time) This report identifies the amounts withheld from a payment estimate due to insufficient materials, or materials for which acceptance actions have not been satisfied. The report lists insufficient materials according to contract project item along with the amounts and quantities withheld due to insufficient materials. Only material quantities on approved DWRs are included in the evaluation.
Items with Unpaid Placed Quantities Base and Historical This report lists all of the items in a contract that have been used in construction and posted on a DWR, but have not yet been included in a payment estimate. The report includes unpaid item quantities and unpaid dollar amounts.
Payment Estimate for Contractor Base and Historical

This report lists the electronic signatures of the staff who approved the payment estimate. The report provides individual item quantity paid to date, quantity this payment estimate, percent complete, along with detailed subtotals for stockpiles, retainage, disincentive, liquidated damage, and other payment estimate amounts. The breakdown is at the contract level.

This report includes the electronic approval signatures for the payment estimate.

A selection parameter has been added prior to generating this report that allows the user to print only the paid contract items on this payment estimate. If this selection is not checked, all contract items will appear on the report.
Payment Estimate Report Base This is the report that appears on the Contract Payment Estimate Summary General tab. The report provides a snapshot of the payment estimate with totals for the previous payment estimate, the current payment estimate, and all payment estimates on the contract, along with detailed subtotals for retainage, disincentive, liquidated damage, and other payment estimate amounts. The breakdown is at the project and category level.
Summary By Project Report (Base); Payment Estimate Summary By Project Report (Historical) Base and Historical (note different report names)

This report provides a snapshot of the Payment Estimate Report with item breakdown amounts for the previous, current and all payment estimates on the contract. The report then breaks down item payments by project and category.

 

Tips:

What is the difference between a report and a historical report?

A report can be generated at any time within the application. Some reports have a historical report available at the completion of an approval process. This includes the daily work reports (DWRs), Change Order Report, Contract Project Design Evaluation Report, Contractor Evaluation Report, Items With Unpaid Placed Quantities report, Payment Estimate for Contractor report, and the Payment Estimate Summary By Project Report. For these reports, print this report version until the historical report becomes available.

A historical report is the final report for a specific approval process. This includes daily work reports (DWRs), contract project design evaluations, contractor / subcontractor evaluations, and payment estimates. When the final approval is granted for one of the noted processes, the historical report is generated as a PDF file that is directly attached to the source record (e.g. change order number 0004, payment estimate number 0005, etc.). In the case of DWRs, they are part of an approved payment estimate and the associated DWR Report is created when the final approval is received on the payment estimate. The historical report is the final copy of the report and cannot be edited.