Edit Owner Invoices (Beta)

Beta icon In Beta

This page details the modernized owner invoice experience.

Objective

To edit an owner invoice for a prime contract.

Background

After creating an owner invoice, you can open it using the Project level Prime Contracts or Invoicing tool to edit as needed. The steps below show you how to edit an owner invoice using the Prime Contracts tool.

Things to Consider

  • Required User Permissions:

    • 'Admin' level permissions on the project's Prime Contracts tool.

  • Additional Information:

Prerequisites

Steps

  • Open an Invoice

    • Update the General Information

    • View a Summary Preview

    • Review & Add Approved Changes

    • Update the Schedule of Values* Set the Column View for PDF Exports* Search for Matching Line Items* Manage Custom Groups* Manage Table Settings* Choose Your Editing Method* Update the Line Items Using the Contract's Accounting Method

    • Upload Attachments* Upload PDF Backup From Records in the Selected Billing Period* Upload Attachments

Open an Invoice

  1. Navigate to the project's Prime Contracts tool.

  2. In the table, locate the contract to edit.

    Tip icon Tip
    • Looking for a specific invoice? To quickly find a match in a long list of invoices, start typing in the Search box. Procore narrows the list to show only the invoices that match your keywords.

    • Want to organize the invoices in the Owner list? To organize the invoice table, use the options in the Add Group and Add Filter menus. To learn more, see Search, Filter, and Group Invoices.

  3. Click the contract's Number link to open it.

  4. Click the Invoices tab.

  5. Locate the invoice in the Invoices (Payment Applications) tab.

  6. Click the Invoice Position or Invoice # link to open it.

Procore opens the invoice. You have different editing options on each card in the invoice.

Update the General Information

To update the invoice's general information:

  1. Scroll to General Information.

  2. Click Edit.

  3. Update these fields as needed:

    Note icon Note

    An asterisk (*) below indicates the field is required.

    edit-invoice-general-information.png

    • Status
      Choose a status from the drop-down list. The default status of a new invoice is Draft. See What are the default statuses for Procore invoices?

    • Invoice No.
      Change the invoice number, if appropriate.

    • Billing Period.*
      Procore automatically populates the drop-down menu with the project's open billing period. If there isn't an open billing period, Procore selects the most recent billing period.

      Tip icon Tips

      Not seeing a menu option for the current billing period? To learn how to create a billing period, see Create Billing Periods.

    • Period Start
      Procore automatically shows the start date of the selected billing period.

    • Period End
      Procore automatically shows the end date of the selected billing period.

  4. Click Save.

View a Summary Preview

To preview the invoice in its finished layout:

  1. Scroll to the Summary Preview section.

  2. Click the arrow to expand it.
    expand-summary-preview.png

Click here to view an example of the Summary Preview.

Summary Preview: Upstream Invoice

The Summary Preview lets you view the finished layout of your upstream invoice.

Example iconExample

Below is an example of an owner invoice created with the Prime Contracts tool. You'll notice slight field labeling differences, if you are viewing an upstream invoice created with one of these Project Tools:

The layout of a Summary Preview always matches the example below.

summary-preview.png

The table below details each field in the General Information area of an owner invoice.

Field

Description

Project Tool

Source Field(s)

To Owner/Client or GC/Client

Shows the name of the Owner/Client or GC/Client as specified in the contract or funding.

Directory, Prime Contracts

Owner/Client or GC/Client

Project

Shows the name of the project as specified in the Project Number field in the Project Information area of the Project Details page.

Portfolio

Project Number

Application No.

Shows the invoice number specified on the invoice.

Invoicing

Invoice No.

Period

Shows the billing period for the invoice.

Invoicing

Billing Period

Project Nos.

Show the Procore project numbers.

Portfolio

From Contractor

Shows the name of the primary contractor managing the project

Prime Contracts

Contractor

Via Architect/Engineer

Shows the name of the Architect/Engineer as specified on the contract.

Prime Contracts

Architect/Engineer

Contract Date

Shows the effective date of the contract. This is the date the contract went into force.

Prime Contracts

Contract For

Shows the name of the project as specified in the Project Number field in the Project Information area of the Project Details page.

Prime Contracts

The table below provides details about each field in the Contractor's Application for Payment area of an owner invoice.

Line

Field

Description

Project Tool

Source Field(s)

1

Original Contract Sum

Show the amount recorded in the 'Original Contract Amount' field in the contract.

Prime Contracts

Original Contract Amount

2

Net Change by Change Orders

Shows the total amount of any change orders in the Approved status that impact this invoice.

Prime Contracts, Change Orders

3

Contract Sum to Date (Line 1 ± 2)

Shows the sum or difference of the Original Contract Sum (line 1) combined with the Net Change by Change Orders amount (line 2). This shows the positive or negative cost resulting from any approved change orders. See the Summary Preview - Change Order Summary.

Prime Contracts, Change Orders

4

Total Completed and Stored to Date (Column G on Detail Sheet)

Procore adds the Work Completed and Materials Presently Stored values to show the cumulative sum of the cost for each line item on the invoice.

Invoicing

5

Retainage

Shows the percentage of the payment is being withheld until the job is complete. This value is specified in the contract. Typically, the value is between 5% and 10% for each progress payment. Because some regions require variable retention, the 'Retainage' amount may only be reduced once a certain percentage of the contract is complete.

Prime Contracts

5a

% of Completed Work

Shows the percentage of work completed from previous payment applications plus the work completed for this billing period.

Invoicing

5b

% of Stored Materials

Shows the percentage of materials being stored on-site. This reflects the value of the materials that were purchased for, but not used on, the project up to the end of the invoice's billing period.

Invoicing

-

Total Retainage (Line 5a + 5b or Total in Column I on Detail Sheet)

Shows the variable retainage rate. A variable retainage rate can represent one of two rates: (1) The amount of retainage that is reduced after a certain percentage of work is complete, or (2) the amount of retainage that retainage applies only to labor and NOT to materials. Note: If you are withholding a fixed percentage throughout the entire project, you will not use this field.

Invoicing

6

Total Earned Less Retainage (Line 4 less Line 5 Total)

Shows the Work Completed and Materials Stored Amount

Invoicing

7

Less Previous Certifications for Payment (Line 6 from Prior Certificate)

Shows all previous payments for the contract. On the first invoice, this number is zero (0). On subsequent invoices, the amount matches line 6 on the previous invoice.

Invoicing

Total Earned Less Retainage (from previous invoice)

8

Current Payment Due

Shows the current payment due for the invoice's billing period. This calculation takes the 'Total Completed and Stored to Date' value in the invoice minus 'Retainage' and any completed payments from past invoices.

Invoicing

Calculated

9

Balance to Finish, Including Retainage

Shows the amount remaining to be paid on the contract, including the 'Retainage' amount.

Invoicing

Calculated

The table below provides details about each field in the Change Order Summary area of an owner invoice.

Field

Description

Project Tool

Source Field(s)

Total Changes Approved in Previous Months by Owner/Client

Shows the total amount of any change orders that were Approved during previous billing periods.

Prime Contracts, Client Contracts, Funding, Change Orders, Invoicing, Progress Billings

Calculated

Total Approved this Month

Shows the total amount of any change orders that were Approved during the current billing period.

Prime Contracts, Client Contracts, Funding, Change Orders, Invoicing, Progress Billings

Calculated

Totals

Shows the total amount of all Approved change orders.

Invoicing

Calculated

Net Changes by Change Order

Shows the net change to the total amount for this invoice.

Prime Contracts, Client Contracts, Funding, Change Orders

Calculated

Review & Add Approved Changes

If your team approves new budget changes or prime contract change orders after an owner invoice is created, a notification banner appears at the top of the invoice's Schedule of Values.

If you want to add any newly approved changes to the most recent owner invoice, follow these steps:

  1. At the top of the Schedule of Values, click Review & Add the notification banner.
    banner-review-and-add-active.png

    Tip icon Tips
    • Don't see a notification banner? Either (1) there are no approved changes to add to the invoice, or (2) the required 'Budget Changes' settings aren't configured. See Configure Settings: Budget.

    • Can't click the Review & Add button? Approved changes can only be added to a prime contract's most recent invoice. If you are editing an older invoice, you can't click the Review & Add button.

    • Are approved changes added to new owner invoices automatically? Yes. Approved changes are automatically added to the Schedule of Values on a new invoice. You do not need to add approved changes to new owner invoices.

  2. In the Review & Add Approved Changes window, review the adjustment details.

  3. Mark the check boxes next to the changes to add.

    Important icon Important

    Adding approved changes is a permanent action. Once added, they cannot be removed.


    review-and-add-budget-change.png

  4. Choose from the options:

    • To add the selected changes, mark the checkboxes that correspond to the change and then, click Add.
      A GREEN banner appears when the change is successfully added.
      OR

    • To skip adding the changes, click Cancel.

Update the Schedule of Values

Before updating the line items, it's helpful to understand the available editing methods. It's also important to know that the accounting method set on the prime contract impacts which columns are available for data entry on the Schedule of Values.

To update a schedule of values:

  • View the Schedule of Values in Full Screen

  • Set the Column View for PDF Exports

  • Search for Matching Line Items

  • Manage Custom Groups

  • Manage Table Settings

  • Choose Your Editing Method

  • Update the Line Items Using the Contract's Accounting Method

View the Schedule of Values in Full Screen

You can view the Schedule of Values in full screen and close it when you finish your updates.

open-fullscreen.pngclose-fullscreen.png

To open or close the fullscreen view of the Schedule of Values:

  • Click the Open Fullscreen link in the top-right corner of the Schedule of Values.
    OR

  • Click the Close Fullscreen button to return to the card view.

Set the Column View for PDF Exports

You can configure the SOV's column view before you Export Owner Invoices.

column-view-when-exported.png

Choose an option from the drop-down list:

  • Industry Standard. This exports Procore's default column layout, which is compatible with most industry-standard forms.

  • Current Configuration. This exports your SOV's current column view.

Search for Matching Line Items

You can search for the matching line items to edit.

search-schedule-of-values.png

About the Search Scope

The scope of a search includes:

  • Budget Code

  • Description of Work

Search for Line Items

To search for matching line items:

  1. In the Search field, type a keyword or phrase.

  2. Press the TAB key or click the magnifying glass icon.

Manage Custom Groups

You can create, edit, or delete custom grouping options. Once you've created your groups, you can apply them using the drop-down menu to the left of the 'Manage Custom Groups' button.

manage-custom-groups.png

Add, Edit, or Delete Custom Groups
  1. In the Schedule of Values, click Edit.

  2. Click Manage Custom Groups.

  3. In the 'Manage Custom Groups' pane, click Add New Group.

  4. In the Group Name box, type a name for the group.

  5. Optional. Choose from these options:

    • To add additional groups, click Add New Group. You can create one or more groups.

    • To add a subgroup, type a name in the subgroup's Enter Name box. You must create at least one (1) subgroup for each group.

    • To change the name of a group or subgroup, type over the existing name as needed.

    • To delete a group or subgroup, click the Delete icon.

  6. Click Save.

assign-to-custom-groups.png

Assign Line Items to Custom Groups
  1. In the Schedule of Values, click Edit.

  2. Select the check boxes that correspond to the line items to add to a custom group.

  3. Click Assign to Custom Groups.
    This open the Assign to Custom Groups panel on the right side of the page.

  4. Select the desired subgroup from the Group drop-down list.

apply-custom-groups.png

Apply Custom Groups

Apply the groups to the table using the drop-down menu to the left of the 'Manage Custom Groups' button. You have these options:

  • To apply a group to the table, select it in the drop-down menu.

  • To move an active group, click and hold the double-ellipsis and use a drag-and-drop motion to move it into the position you want.

  • To remove an active group, click the X to the right. Deleting a group also deletes any subgroups in it. You can not recover a deleted group, you must re-create it.

  • To remove any customizations from the table, click Reset to Default.

Manage Table Settings

You can change the row height for the Schedule of Values. You can also show or hide the columns that appear.

owner-invoice-table-settings.png

Set Row Height
  1. Click the Table Settings button.
    This opens the Table Settings pane.

  2. Under Row Height, click one (1) option:

    • Small

    • Medium

    • Large

Configure Columns
  1. Click the Table Settings button.
    This opens the Table Settings pane.

  2. Under Configure Columns, choose from these options:

    • To show a column, move the toggle to the right.

    • To hide a column, move the toggle to the left.

    • To show all columns, click Show All. This is the default setting.

Choose Your Editing Method

It's helpful to understand the differences between the two (2) available data entry methods for contracts. See How do I set the accounting method for a contract? Once you know the accounting method in place, click the Edit button to place the Schedule of Values in editing mode. You can only edit the most recent invoice. If there is a more recent invoice, an informational message appears at the top of the Schedule of Values.

  • To edit individual line items inline Show /Hide

    • Edit line items inline by typing in the text boxes that appear in the editable cells.

      owner-invoice-sov-inline-item-entry.png

  • To edit line items in bulk Show /Hide

    • To edit SOV line items in bulk:

      1. Click Edit in the top right corner of the SOV card.
        This places the SOV into editing mode.

      2. Place checkmarks in the boxes to the left of each line item. You have these options:

        • To select all of the SOV line items, mark the box in the Item Number column (see 1).

        • To select all of the line items in a group, mark the box in a line item group (see 2).

        • To select individual line items, mark the desired boxes next to each line item (see 3).

          owner-invoice-edit-values-panel.png

      3. Click the Edit Values button (see 4).

      4. In the Edit Values pane on the right (see 5), enter percentage values as needed.
        The data entry fields in the Edit Value pane on the invoice's SOV are different, depending on whether the contract was configured to use the amount-based or unit-based accounting method. To learn more, see How do I set the accounting method for a contract?

      5. Click Apply (see 6).

Update the Line Items Using the Contract's Accounting Method

The data entry requirements for line items on a Schedule of Values are determined by the accounting method set on the invoice's prime contract. In Procore, a prime contract can be configured to use one (1) of two (2) accounting methods: Amount-Based or Unit/Quantity Based. The accounting method set on the prime contract impacts which columns are available for data entry on the Schedule of Values. Once line items are created on a contract, all invoices for that contract use the same accounting method. To learn more, see How do I set the accounting method for a contract or funding?

Tip icon Tips

How do you know which accounting method is being used? An Amount-Based contract includes columns for entering dollar and percentage amounts. A Unit/Quantity Based contract includes columns for entering a quantity and percentage amounts. Simply compare the columns in your invoice's Schedule of Values to the ones in the examples below.

  • To update line items with the Amount-Based accounting method Show /Hide

    • To update the line items on an owner invoice's Schedule of Values (SOV) when the prime contract is using the Amount-Based accounting method:

      1. Scroll to the Schedule of Values.
        Each line item on an owner invoice's SOV corresponds to a contract line item.

      2. Click Edit.
        This places the Schedule of Values into edit mode.

      3. Enter values in these fields as needed:
        The columns in your SOV may be different. To show and hide columns, click the Table Settings icon-ag-grid-table-filter-menu.png icon. To learn more, see Manage Table Settings.

        • Work Completed This Period (%)
          Enter a percentage to represent the monetary value of work completed for this billing period.
          Note: If the user who created the invoice marked the 'Populate the Schedule of Values with Costs from the Selected Billing Period' checkbox, Procore automatically populates the entry in the hidden 'Work Completed This Period ($)' column with values from subcontractor invoices, direct costs, and commitment change orders.

        • Total Work Completed (%)
          Enter a percentage to represent the work completed to date through this billing period. Procore uses this entry to display the '% of Completed Work' (line 5a) in the Summary Preview.
          Note: This number represents the cumulative amount of work completed from the first invoice on the contract through the current billing period for this invoice.

        • Work Retainage This Period (%)
          Enter a percentage to represent the work retainage to release this billing period.
          Note: An entry in this cell lets Procore automatically calculate the currency value in the 'Work Retainage This Period ($)' column of the Schedule of Values.

        • Materials Retainage (%)
          Enter a percentage to represent the material retainage for this billing period.
          Note: An entry in this cell lets Procore automatically calculate the currency value in the 'Materials Retainage This Period ($)' column.

        • Work Retainage Released (%)
          Enter a percentage to represent the material retainage that you are requesting to be released for work completed this billing period.

  • To update line items with the Unit/Quantity Based accounting method Show /Hide

    • To update the line items on an owner invoice's Schedule of Values when the prime contract is using the Unit/Quantity Based accounting method:

      1. Scroll to the Schedule of Values.
        Each line item in the invoice's Schedule of Values corresponds to a line item on the invoice's prime contract.

      2. Click Edit.
        This places the Schedule of Values into edit mode.

      3. Enter values in these cells as needed:

        • Work Completed: This Period (Qty).
          Enter a quantity amount to represent the work completed for this billing period. This automatically updates the amount in the 'Work Completed: This Period (%)' cell.

        • Work Completed: This Period (%).
          This cell updates automatically when you enter a value in the 'Work Completed: This Period (Qty)' cell. You can type over this value to change the other entries for this row.

        • Total Completed & Stored To Date: Total to Date (%).
          This updates automatically when you enter a value in the 'Work Completed: This Period (Qty)' or 'Work Completed: This Period (%)' cells. You can type over this value to change the other entries for this row.

Upload Attachments

When creating an invoice, users have the option to place a mark in the Include backup from direct costs and invoices in the selected billing period box. The experience you see will depend on whether the setting is turned ON or OFF.

  • Include Backup from Direct Costs and Invoices in the Selected Billing Period

  • Upload Attachments

include backup from direct costs and invoices in the Selected Billing Period

If the Include backup from direct costs and invoices in the selected billing period setting is turned ON.

  1. Scroll to Attachments.

  2. Click Edit.
    Scroll to the Attachments card.

    Note icon Note

    When the Include backup from direct costs and invoices in the selected billing period setting is turned ON, the Attachments card contains these sections: Uploaded Attachments, Attachments from Subcontractor Invoices, and Attachments from Direct Costs.


    attachments-with-prefill.png

  3. In the Uploaded Attachments section, click the Upload Attachments button.

  4. Upload the desired attachments.

Upload Attachments

If the Include backup from direct costs and invoices in the selected billing period setting is turned OFF in the invoice.

  1. Scroll to Attachments.

  2. Click Upload Attachments.

    upload-attachments.png

  3. Upload the desired attachments.