Skip to main content
Procore (en-GB)

What are the financial line items in custom reports?

Answer

When creating a custom report, you can select Financial Line Items and see the options Financial Line Item Details and Financial Line Item Summary. For more information on creating a custom report, see Create a Custom Company Report and Create a Custom Project Report. Below we will cover potential user cases for each and how to use them in a report. 

 

reports-select-tool-financial-line-items.png

 

Financial Line Item Details

Adding the Financial Line Item Details option to your custom report lets you to extract a log of all of your financial line items for every line item type, whether it’s a forecasting line item, Programme of Values (BOQ) line item on a commitment or a Potential Variation (PV). This report is similar to clicking an amount in the Budget tool as it shows one (1) line per transaction or BOQ line item and has only one (1) amount column. 

Use Cases

  • This custom report provides an alternate way to see individual transactions without having to go to each individual item in the financial tools.

    • Example:  You can use this to provide the project owner with a list of all contingency or allowance use.  This will show the amount deducted from Contingency or Allowance cost codes.  Since Contingency or Allowance use typically results in a net $0 Main PV, the amount used from Contingency or Allowance cannot be accessed from the Main PV log.

  • This report can provide insight into Unit/Quantity data (Quantity, Units & Unit Cost) per cost code for Unit/Quantity based contracts and variations.

  • This report also produces a list/log for the Financial Mark-Up amount per Main PV in one place.

How to Use

  • We include every type of financial line item in a log format, this means in order to properly use the report, you will have to filter for the proper types by bringing in the “Type” field. (ie. Budget mods, forecast line items, payment applications etc.)

  • This report enables users to see each individual line item for any given cost code.

  • This report doesn’t include data from the ERP Integrations tool. 

Financial Line Item Summary

Adding the Financial Line Item Summary option to your custom report includes a summary of your financial data at the cost level and enables you to report off of your financials alongside other Procore data. This report is similar to the Budget tool, where there is one (1) line item per cost code + cost type and there are different columns with different amounts.

Use Cases

  • Construction executives can analyse their financial data for each cost code, so that they can see their costs and/or billings across their entire portfolio.

  • Owner clients can utilise the project square footage (entered in Admin tool) and calculate their Budget or Cost amount per line item per square foot.

How to Use

  • This report summarises financial information for each individual cost code. The best way to use this report at the company level is to always group by Project Name first. This will enable you to get an accurate aggregation of SUM, MIN, MAX, AVG on currency fields.  

  • This report also is best used with calculated columns. For example, Direct Costs + Payment Applications would potentially give you the Job to Date Costs.

  • This report includes main contract amount per cost code, payment applications per cost code and pay applications, making it easy to tie other financial items.

  • This report doesn’t include ERP data yet.  

Included Statuses 

Below are the statuses for each item that are included in the Financial Line Item Summary report:

  • Main Contract Value. A Main Contract Value with an Approved status are shown in the Financial Line Item Summary report.
  • Direct Costs. A Direct Costs with any status is shown in the Financial Line Summary report.
  • Payment Applications. Payment Applications with any status is shown in the Financial Line Summary report.
  • Pending Commitments
    • Subcontracts with the status of Out For Pricing are shown in the Financial Line Summary report.
    • Purchase Orders with the status of Processing, Submitted, Partially Received, and Received are shown in the Financial Line Item Summary report. 

See Also