Manage Rows and Columns on a Subcontractor Payment application's Bill of Quantities

Last updated
Save as PDF

For Procore Customers in the United States

When your company applies the 'Owners English' or 'Speciality Contractors English' point-of-view dictionary, you'll see different tool names and term changes in the user interface. Learn how to apply the dictionary options.

To learn the differences: Show/Hide

This table shows the differences in tool names (bold) and terms across the point-of-view dictionaries for Project Financials. These dictionaries are available in US English only. The default dictionary is designed for main contractors, which means that you will need to work with your Procore Administrator at your company and your Procore point of contact to access the other dictionary options.

Main Contractors English (United States) - Default	Owners English (Owner Terminology V2)	Speciality Contractors English (Speciality Contractor Terminology)
Payment Applications	Payment Applications	Progress Billings
Owner	Funding	Owner
Owner/Client	Owner/Client	MC/Client
Main Contract Variation	Funding Variation	Client Contract Variation
Main Contracts	Funding	Client Contracts
Revenue	Funding	Revenue
Subcontract	Contract	Subcontract
Subcontractor	Contractor	Subcontractor
Subcontractor Bill of Quantities (SBOQ)	Contractor Bill of Quantities (CBOQ)	Subcontractor Bill of Quantities (SBOQ)

Objective

To manage the rows and columns in a subcontractor payment application's Bill of Quantities.

Background

If you want to show, hide, group, sort or size the columns in the 'Bill of Quantities' table in the project's Commitments tool, there are a variety of operations you can use to organise the line items on your payment applications.

Things to Consider

Required User Permissions

Prerequisites

Create a Subcontractor Payment application

Steps

Group by Menu

A Group by menu is available when viewing and editing a payment application's Bill of Quantities. With these options, you can choose how the system groups your line items in the Bill of Quantities. By default, the Commitment Lines and Variations option is selected. You can add and remove any additional options as desired.

Tip

How do I show/hide columns that I've selected as grouping options? When you add an option to the Group By menu, Procore automatically adds the column to the right side of the table, unless that column is already configured to show in the Bill of Quantities. To show or hide columns, apply the ON/OFF controls described in Configure Columns.

To organise your Bill of Quantities data, you can click the grab bar on the left side of each option (see 1 and 2 below) and drag the option into the desired position to modify the hierarchy of item groupings in the BOQ table. To remove any options from the payment application, click the close (x) icon next to a single option or simply click Reset.

When applying the menu options, its important to note that the groupings in the Bill of Quantities do NOT impact the layout of the payment application's PDF export files. Any settings you apply to one contract's payment application, do not change the settings on another contract's payment applications. However, any options you set do remain in effect between user sessions on the selected contract's payment applications.

Bulk Edit a Bill of Quantities

You can bulk edit the percentage values to apply to selected line items on a subcontractor payment application's Bill of Quantities. To open the Edit panel, select the line items and then click the Pencil icon. The fields in the Edit panel are available when you update the latest payment application for a commitment. The bulk editing options detailed in the table below are only available when a payment application is in the Draft or Revise & Resubmit status. Any options you set will remain in effect between user sessions on the commitment contract's payment applications.

The first step is to select one (1) or multiple line items using the options illustrated above. The following table describes your options in more detail.

What do you want to select?	Steps	Example
All line items in the Bill of Quantities	Mark the Item Number tickbox at the top of the Bill of Quantities.
All line items in a group	Mark the tickbox(es) at the top of the desired group(s) in the Bill of Quantities table.
One or multiple line items	Mark the tickbox(es) that correspond to individual line item(s) in the Bill of Quantities.

The next step is to click the pencil icon at the top of Bill of Quantities to open the Edit panel on the right.

The final step is to edit one (1) or all of the values in the fields described in this table:

Field Name in the Edit Panel	To edit the selected line items...	To apply your edits...	Learn More
Work Completed This Period (%)	Type a percentage value to bill for work complete.	After updating the field(s) the Edit panel, click the Apply button.	Create a Subcontractor Payment application
Total Completed & Stored to Date (%)	Type a percentage value to bill for work complete.		Create a Subcontractor Payment application
Work Retention This Period (%)	Type a percentage value to set work retention.		Set or Release Retention on a Subcontractor Payment Application
Retention Released (%)	Type a percentage value to release retention.
Materials Retention (%)	Type a percentage value to set materials retention.

Manage Table Settings

You can adjust row height and show/hide columns using the Table Settings options in the Bill of Quantities. First, click the Table Settings icon on the top-right side of the BOQ table. This reveals the Table Settings pane on the right side of the web page. To close the Table Settings pane, click the 'x' in the top-right corner.

Row Height

Under Row Height, choose the Small, Medium or Large option button. Procore's default setting is Medium.

Configure Columns

To choose the columns to show and hide, click the Table Settings icon on the top-right side of the contracts table. This reveals the Table Settings pane on the right side of the web page. Under the Configure Columns area, move the toggle to the right to turn the column display ON. Procore's default setting is to show all available columns.

Notes

The blank line at the top of the 'Configure Columns' list is used to turn the 'Grand Totals' on the BOQ table ON and OFF.
By default, all of the available columns on a payment application are turned ON.

Other options in the Table Settings area include:

To hide a specific column, move the toggle to the left.
To show a specific column, move the toggle to the right.
To restore Procore's default column settings, click the Reset to Default link.

Manage Columns

Adjust Column Width

To adjust the width of a single column, hover your cursor over the right border of a column heading until the resize handle icon appears. Then drag the handle to the left or right to set the desired column width. If you press the SHIFT key while holding down the resize handle, a blue outline appears over the active column to help you see your column adjustment.

Arrange Columns

To move a column to another position in the table, click and hold the desired column's heading. Then use a drag-and-drop operation to place in the position you want.

Sort Columns

To sort the table's data by a specific column, click any column heading to reveal a BLUE arrow to adjust the sort order of the table.

Icon	Sort Order	Additional Information
	Ascending	To reset your columns, hover your cursor over the right side of a column heading until the vertical ellipsis appears. Then choose Reset Columns from the drop-down menu.
	Descending

Overflow Menu

To open a drop-down menu with additional column options, hover your cursor over the right side of a column heading until a vertical ellipsis appears. Then click the vertical ellipsis to reveal an Overflow menu with the additional options. The options are pictured below.

Group By Column

All columns contain an 'Group By' option in the Overflow menu. This lets you group the table's data by the column you select.

Column Grouping Options

Simply hover your mouse cursor over one of these columns until the vertical ellipsis for the Overflow menu appears. Then click the ellipsis and select the column Group By option. You can also apply multiple grouping options to your table by selecting the same option on other columns.

Pin Column

To keep data columns in the Contracts table from moving when you scroll, you can pin a column to freeze it in place. To do this, hover your cursor over the right side of a column heading unit the vertical ellipsis appears. Next, click the vertical ellipsis and choose Pin Column. Then choose one of these options:

To pin a column on the left side of the table, choose Pin Left.
To pin a column on the left side of the table, choose Pin Right.
Tip
- Procore pins columns to the left or right side of the page in the order columns are pinned.
- You can rearrange your pinned columns by dragging and dropping a column into the desired position.
- You can pin columns to both the left and right side of the table.
To remove all pins, choose No Pin.

Autosize this Column

To automatically set the width of a column to match its contents, hover your cursor over the right side of a column heading until the vertical ellipsis appears. Then click the vertical ellipsis and select the Autosize This Column option from the drop-down menu.

Autosize All Columns

To automatically set the width of all columns in the table to best match the contents, hover your cursor over the right side of a column heading until the vertical ellipsis appears. Then click the vertical ellipsis and select the Autosize All Columns option from the drop-down menu.

Reset Columns

To reset the table's columns to Procore's default settings, hover your cursor over the right side of a column heading until the vertical ellipsis appears. Then click the vertical ellipsis and select the Reset Columns option from the drop-down menu. This resets all of your column settings to Procore's default settings.