Export Payment Reports

You can generate reports for payment applications and expenses to share information with owners and subcontractors. The system supports both PDF and Excel report formats, and you can create reports directly from the Cost Management tool or through the Reports tool.

In this article:

Export Budget Payment Application Reports
Export Cost Payment Application Reports
Export and Reimport Cost Payment Applications
- Export for Subcontractor Input
- Import Completed Excel Files
Export Expense Reports
Report Templates and Customization
Time Range Filtering for Exports
Report Delivery and Access
Related Articles

Export Budget Payment Application Reports

You can generate a report for budget payment applications to share information with an owner.

To create a budget payment application report:

Select the Budget tool from the left navigation.
Switch to the Budget Payment Application tab.
Click the name of the contract. The flyout panel opens.
In the Associated Cost section, click .
Select PDF Report or Excel Report.

Note: The generated report contains the items from the cost payment application and expenses previously added as associated costs for this budget payment application. To learn more, see the related section in the Expenses article.

Export Cost Payment Application Reports

You can generate a report for cost payment applications to share information with subcontractors.

To create a cost payment application report:

Select the Cost tool from the left navigation.
Switch to the Cost Payment Application tab.
Click .
Select PDF Report or Excel Report.
Enter the report title and choose the template.
Click Run report.

Export and Reimport Cost Payment Applications

Cost payment applications can be exported for subcontractors to enter their billing information. This workflow allows subcontractors to fill out payment details in Excel and reimport the data.

Export for Subcontractor Input

To export a cost payment application for subcontractor completion:

Select the Cost tool from the left navigation.
Switch to the Cost Payment Application tab.
Open the More menu .
Click Populate via Excel.
Click Export Excel File. The Excel file is downloaded.

Note: When a contract associated with a cost payment application is denominated in a foreign currency, the value will be exported in that currency during document generation.
Click the name of the cost payment application to open the details panel.
In the Documents section, click Add Document, and choose the downloaded Excel file from your computer.
Click Request Input. A window pops up. Fill out the necessary information and click Send. Your cost payment application has the Pending Supplier Input status now.

Import Completed Excel Files

You can import the received filled-out Excel file by clicking the Import Excel File option:

Open the details panel of the cost payment application.
In the Documents section, click Import Excel File.
Select the completed Excel file from the subcontractor.
Review and process the imported data.

Export Expense Reports

To create a formatted report of expenses:

Select the Cost tool from the left navigation.
Switch to the Expense tab.
Click .
Choose between PDF Report and Excel Report.
Enter the report title and choose the report template:
- Current View - includes all currently visible columns. Use this one to create a report for filtered expense table views or previously saved current views.
- System Default View - includes system default columns in all groups.
Tip: When exporting a PDF or Excel expense report in Edit mode, the system will only export currently visible columns.
Click Run report.

Report Templates and Customization

When generating payment application reports, you can:

Choose from available report templates.
Customize report titles.
Select between PDF and Excel formats.
Include associated costs and expenses in budget payment application reports.

Tip: For more advanced reporting options, you can also create reports in the Reports tool. To learn more, see the Create and Schedule Reports article.

Time Range Filtering for Exports

You can filter expenses by time range before exporting to get specific information:

Select the Cost tool from the left navigation.
Switch to the Expense tab.
Click the Past month drop-down list, next to the Export button.
Select one of the predefined time range options.
Proceed with your export using the filtered view.

Report Delivery and Access

After generating any report:

You'll receive an email notification when your report is ready.
You can download reports from the Reports tool.
Reports are available for future reference and sharing.

Note: When generating budget payment application documents, you can choose to collate associated expenses, attachments, and supplier payment applications together for submission to the owner. These will also be visible in the exported reports.