Skip to main content
Procore

Create an Allowance and/or Contingency Report

Objective

If you want to create an allowance and/or contingency report using your project's Main Potential Variations (PVs)

Background

When setting up your project's budget, Procore recommends that clients set up both allowance and contingency cost types. To create new cost types in your company's Work Breakdown Structure, see Add Company Cost Types. You can also assign your allowance or contingency cost type to your cost codes so that when your team later creates variations, your budget line items can use the same cost code/cost type as the contract scope.

When you create a Main PV, each variation line item becomes a negative line item against the allowance/contingency and a positive line item against the purchase order or subcontract. Because allowance and/or contingency shows a net zero (£0) in the Main Potential Variation's log, you can create the report below to the 'Original Budget Amount' from your contingency and/or allowance cost codes

Things to Consider

Steps

  1. Navigate to the project's Reports tool.
  2. Click + Create Custom Report.
  3. Click Create New Report
  4. Complete the following information:
    • Enter Report Name: Type a name for your report. For example, type: Allowance & Contingency Report
    • Enter Description: Enter a descriptive summary of the report. 
      report-name-description.png
  5. Under Select Tool, do the following:
    • Click Financial Line Item.
    • Click Financial Line Item Details
      This adds a 'Financial Line Item Details' tab to your report. 
      financial-line-item-details.png
  6. In the right pane, search for these columns and use a drag-and-drop operation to place them in your report:
    columns-added.png
    • Optional: Project Name. If you are creating a Company level report, add this column to each project's name. 
    • Cost Code. This column shows the cost code. 
    • Type. This column is included to group the report by type. The grouping will show how many pouinds were used. 
    • PV #. This column provides the PV number. 
    • Description. This column provides the PVs description. 
    • Amount. This column shows the monetary amount. 
  7. Add a filter to your report as follows:
    • Click the Add Filter menu and choose Type.
    • In the secondary filter drop-down, mark these tickboxes:
      • Original Budget
      • Main Contract PV
        allowance-contingency-type-fields.png
         
  8. Add another filter to your report as follows:
    • Click the Add Filter menu and choose Cost Code.
    • In the secondary filter drop-down, mark the tickbox that corresponds to your Contingency cost code. 
      allowance-contingency-contingency-code.png
  9. At the top of the Amount column, click fx and select SUM.

    amount-sum.png
     
  10. Add a grouping to your report as follows:
    • Click the Group By menu.
    • Choose the following items:
      • Optional: Project Name: You only need to select this option if you are creating the report using the Company level Reports tool. 
      • Cost Code: This option will show cost code subtotals on the report. 
      • Type: This option will show subtotals for how much is used. 
  11. Click Create to save your report.