Skip to main content
Procore

Create a Cost Item Detail Report in Portfolio Financials and Capital Planning

 Note
The information in this tutorial applies to accounts with the Portfolio Financials product in Procore. Reach out to your Procore point of contact for more information. 

Objective

To create a Cost Item Detail report in Portfolio Financials and Capital Planning.

Background

Cost Item Detail Reporting allows you to report on the cost item details across your entire portfolio. This is useful if you want to get more granular with your data; for example, you might want to see how much is being spent on a certain item across projects.

Things to Consider

  • Required User Permissions:
    • 'Full Access' to the project or higher.
      Note: Users with 'Full Access' permissions can only create a Cost Item Detail report for the projects they have access to.

Steps

  1. From the Dashboard, click the Reporting tab.
    Note: The Reporting tool automatically opens the Custom Reports tab. 
  2. Click the Report By drop-down menu and select Cost Item Detail.
  3. Click the filters icon-filter-pfcp.png  icon to expand the Filters panel.
  4. Click Columns.
    This is is where you will select the specific data points that you want to include in your report (see example below).
    cost-item-details-columns.png
    • To select columns:
      1. Click a section to see the options.
      2. Mark the checkboxes next to the columns you want to include in your report.
  5. Click Groupings to expand the section for different grouping options. Groupings help to create a visual distinction between sections, and can be used to calculate subtotals by group. The image below shows Contract Name and Invoice Status as groupings.
    cost-item-details-groupings.png
    • To select or manage groupings:
      1. Select a data point from the drop-down menu to group by.
      2. The following options are available:
        • To add a grouping, click the plus icon-orange-plus-pfcp.png icon next to 'Add Another Grouping'.
          Note: You can have up to three groupings on a report. 
        • To delete a grouping, click the remove icon-x-remove-pfcp.png icon next to the grouping.
        • To reorder groupings, click the reorder grip icon-reorder-grip-pfcp.png icon and drag a grouping to another location. 
        • To show sub totals for a grouping, click the Sub Total toggle to the ON icon-toggle-on-pfcp.png position.
          OR
          To hide sub totals for a grouping, click the Sub Total toggle to the OFF icon-toggle-off-pfcp.png position.
  6. To continue refining your report, scroll down to Refine.
    For example, if you want to report on a subset of cost item details, you can use these filter options to narrow down your view.
    • To refine the report:
      1. Click a section under Refine to see the options.
      2. Mark the checkboxes next to the filters you want to refine the report by.
  7. Optional: If there is a certain combination of filters you prefer, you can save the current report view. Views that you save can be selected at any time from the 'Saved Views' drop-down menu.
    • To save your view:
      1. Click Save Current View.
        cost-item-detail-save-view.png
      2. Enter a name for the report in the Report Name field.
      3. Click Save.
  8. Optional: To export a copy of the report to your computer, click Export.
    A Microsoft Excel file will download to your computer.