Create a Payment Application 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 payment application report in Portfolio Financials and Capital Planning.
Background
Payment application Reporting allows you to report on payment applications submitted vendors in any project. This is useful if you want to know much you were issued in a given month or if you want to see which payment applications from the last month are still pending approval.
Things to Consider
- Required User Permissions:
- 'Full Access' to the project or higher.
Note: Users with 'Full Access' permissions can only create payment application reports for the projects they have access to.
- 'Full Access' to the project or higher.
Steps
Tip
To see a list of data points for custom reports, see What are the data points available for custom reports in Portfolio Financials and Capital Planning?- From the Dashboard, click the Reporting tab.
Note: The Reporting tool automatically opens the Custom Reports tab. - Click the Report By drop-down menu and select Payment application.
- Click the filters icon to expand the Filters panel.
- Click Columns.
This is is where you will select the specific data points that you want to include in your report (see example below).
- To select columns:
- Click a section to see the options.
- Mark the tickboxes next to the columns you want to include in your report.
- To select columns:
- 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 Payment application Status as groupings.
- To select or manage groupings:
- Select a data point from the drop-down menu to group by.
- The following options are available:
- To add a grouping, click the plus 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 next to the grouping.
- To reorder groupings, click the reorder grip icon and drag a grouping to another location.
- To show sub totals for a grouping, click the Sub Total toggle to the ON position.
OR
To hide sub totals for a grouping, click the Sub Total toggle to the OFF position.
- To add a grouping, click the plus icon next to 'Add Another Grouping'.
- To select or manage groupings:
- To continue refining your report, scroll down to Refine.
For example, you can choose to report only on payment applications that are pending approval or report only on payment applications submitted in a certain month.
- To refine the report:
- Click a section under Refine to see the options.
- Mark the tickboxes next to the filters you want to refine the report by.
Tip
If you have an integration set up for your Portfolio Financials and Capital Planning account and send payment applications to Accounts Payable, you can refine your report to show payment applications that have not yet been sent to AP. You can also pull the 'Sent to AP' status in as a column to be seen across various reports.
- To refine the report:
- 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:
- Click Save Current View.
- Enter a name for the report in the Report Name field.
- Click Save.
- Click Save Current View.
- To save your view:
- Optional: To export a copy of the report to your computer, click Export.
A Microsoft Excel file will download to your computer.