What data columns are available in a schedule of values on an owner invoice ? (Beta - Draft)
In Beta
This page details the modernized owner invoice experience.
Answer
The data column layout of an owner invoice depends on these factors:
The accounting method set on the contract that the invoice is billing against. See How do I set the accounting method for a contract?
The column configuration on the invoice. If you apply customizations, you may see columns that are different from Procore's default column layout detailed below.
Owner Invoices: Schedule of Values Data Columns
When you set the accounting method to use on a prime contract's Schedule of Values, that method is automatically applied to the contract's owner invoices. See How do I set the accounting method for a contract? Each accounting method has a unique column layout that includes specific columns and column groups designed specifically to work for each accounting method. For both methods, you can expand and collapse each column group by clicking these icons:
Expand Column Group. Click to expand the columns in the group.
Collapse Column Group. Click to collapse the columns in the group.
Amount-Based Accounting Method
When an owner invoice uses the amount-based accounting method, you'll see these columns.
Default Columns
This table details the default columns for owner invoices with the amount-based accounting method. An asterisk (*) by a 'Column Name' indicates the column is only visible when the 'Column Group' is expanded.
Column Group | Column Name | Data Entry Field | Description | |
|---|---|---|---|---|
Item Number |
| Show the line item number on the invoice's Schedule of Values. | ||
Line Item Details | Budget Code |
| Shows the budget code for the line item. | |
Description of Work |
| Shows the description for the line item from the corresponding line item on the contract. | ||
Line Item Type * |
| Shows the line item type. | ||
Source * |
| Shows the link to the line item source. This includes: SOV or Change Order. | ||
Value | Prime Contract Value* |
| Shows the value of the line item from any 'Approved' change orders for the contract. | |
Change Value* |
| Shows the value of the line item from any 'Approved' change orders. | ||
Scheduled Value |
| Shows the line item's scheduled value from the prime contract or change order. Where the group total shows, the value is the total sum of all the values on its prime contract plus all of its change orders. | ||
Work Completed | From Previous Application ($) |
| Shows the currency amount for all work completed in previous payment applications. | |
From Previous Application (%) * |
| Shows the percentage value for all work completed in previous payment applications. | ||
This Period |
| Enter a currency amount for all work completed this billing period. | ||
This Period (%) * |
| Enter a percentage value for all work completed in this billing period. | ||
Materials | Previous Materials Stored* |
| Enter a currency amount that represents the total of all materials stored in previous billing periods. | |
New Materials Stored* |
| Enter a currency amount for all materials stored in this billing period. | ||
Materials Presently Stored |
| Shows the currency amount that is the sum of 'Previous Materials Stored' plus 'New Materials Stored.' | ||
Total Completed & Stored Materials | Total to Date ($) |
| Shows the currency amount for all completed and stored materials for previous billing periods plus this billing period. | |
Total to Date (%) |
| Enter a percentage value for all completed and stored materials for previous billing periods plus this billing period. | ||
Balance to Finish |
| Shows the remaining currency amount that has yet to be completed and stored for the contract. | ||
Retainage Note: To fully expand this column group, you may need to collapse other column groups first. | Previous Work Retainage * |
| Shows the currency amount for any work retainage held for work completed from previous billing periods. | |
Previous Materials Retainage * |
| Shows a currency amount for any materials retainage held from previous billing periods. | ||
Previous Total Retainage * |
| Shows the currency amount that is the sum of 'Previous Work Retainage' and 'Previous Total Retainage.' | ||
Work Retainage This Period ($) * |
| Enter a currency amount for the work retainage held for this billing period. | ||
Work Retainage This Period (%) |
| Enter a percentage value for the work retainage held for this billing period. | ||
Total Work Retainage * |
| Shows a currency amount for the total work retainage held for previous billing periods plus this billing period. | ||
Materials Retainage ($) * |
| Enter a currency amount for materials retainage held for this billing period. | ||
Materials Retainage (%) |
| Enter a percentage value of materials retainage held for this billing period. | ||
Work Retainage Released This Period * |
| Enter a currency amount of work retainage released for this billing period. | ||
Total |
| Shows the total retainage. Procore calculates this value as: ('Total Work Retainage' + 'Materials Retainage ($)') - 'Total Retainage Released This Period'. This 'Total' is analogous to the definition of 'Retainage' on common industry-standard forms. |
Unit/Quantity-Based Accounting Method
When owner invoices use the unit/quantity-based accounting method, you'll see these columns.
Default Columns
This table details the default columns for owner invoices with the unit/quantity-based accounting method. An asterisk (*) under 'Column Name' indicates the column is only visible when the 'Column Group' is expanded.
Column Group | Column Name | Data Entry Field | Description | |
|---|---|---|---|---|
Item Number |
| Shows the line item number on the invoice's Schedule of Values. | ||
Line Item Details | Budget Code |
| Shows the budget code for the line item. | |
Description of Work |
| Shows the description for the line item from the corresponding line item on the contract. | ||
Line Item Type * |
| Shows the line item type. | ||
Source * |
| Shows the link to the line item source. This includes: SOV or Change Order. | ||
Value | Scheduled Quantity |
| Shows the scheduled quantity for the line item. | |
Unit Price |
| Shows the unit price for the line item. | ||
Prime Contract Value * |
| Shows the value of the line item from the prime contract. | ||
Change Value * |
| Shows the value of the line item from any 'Approved' change orders for the contract. | ||
Scheduled Value |
| Shows the line item's scheduled value from the prime contract or change order. Where the group total shows, the value is the total sum of all the values on its prime contract plus all of its change orders. | ||
Work Completed | From Previous Application (Qty) |
| Shows the unit quantity for all work completed in previous payment applications. | |
From Previous Application ($) |
| Shows the currency amount for all work completed in previous payment applications. | ||
From Previous Application (%) * |
| Shows the percentage value for all work completed in previous payment applications. | ||
This Period (Qty.) |
| Shows the quantity for all work completed in this billing period. | ||
This Period ($) |
| Shows the currency amount for all work completed in this billing period. | ||
This Period (%) * |
| Shows the percentage value for all work completed in this billing period. | ||
Total Completed & Stored Materials | Total to Date (Qty.) * |
| Shows the quantity for all completed and stored materials for previous billing periods plus this billing period. | |
Total to Date ($) * |
| Shows the currency amount for all completed and stored materials for previous billing periods plus this billing period. | ||
Total to Date (%) * |
| Enter a percentage value for all completed and stored materials for previous billing periods plus this billing period. | ||
Balance to Finish * |
| Shows the remaining currency amount that has yet to be completed and stored for the contract | ||
Retainage Note: To fully expand this column group, you may need to collapse other column groups first. | Previous Work Retainage * |
| Shows a currency amount for any materials retainage held from previous billing periods. | |
Work Retainage This Period ($) * |
| Enter a currency amount for the work retainage held for this billing period. | ||
Work Retainage This Period (%) * |
| Enter a percentage value for the work retainage held for this billing period. | ||
Work Retainage Release This Period * |
| Enter a currency amount for the work retainage released for this billing period. | ||
Total |
| Shows the total retainage. Procore calculates this value as: ('Total Work Retainage' + 'Materials Retainage ($)') - 'Total Retainage Released This Period'. This 'Total' is analogous to the definition of 'Retainage' on common industry-standard forms. |
See Also
Loading related articles...