How do I bill for stored materials in Procore? (Legacy)
Answer
The term stored materials refer to materials that have been purchased prior to their planned use on a construction project. These are materials that are purchased by the entity performing the work and stored on a job site prior to use. Typically, materials quantities are tracked on a line item in the Bill of Quantities (BOQ) so an payment application with the amount owed for services or work can then be submitted to the appropriate party.
Example
Examples of stored materials include Bricks, Roofing Tiles, Drainage Pipes, Sheet Materials, Cement and Aggregates.How do I bill for stored materials?
To bill for stored materials, the contract or funding must be configured to use the 'Amount Based' accounting method. See How do I set the accounting method for a contract or funding? When a contract or funding is 'Amount Based', the payment application works as follows:
- Column F - Material Stored. Enter a value for the payment sought in the 'Materials Presently Stored' column. The total of the column must be recalculated at the end of each pay period. This value covers both materials newly stored for which payment is sought and 'Materials Previously Stored' which are not yet incorporated into the project. Note that payment for stored materials does not result in a deduction from this column. Only as materials are incorporated into the Project is their value deducted from this column and incorporated into Column E - Work Completed—This Period.
- Every time you create a new payment application in Procore, any value currently in Column F - Materials Stored will still be in Column F in the new payment application. If you are incorporating those materials into the project this month, you will need to manually move the proper amount from Column F to Column E - Work Completed this Period.
- Procore allows users to enter different retention percentages in the 'Work Completed' and 'Materials Stored' columns. In the event that you do apply a different retention percent to each, it's important to note that Procore will recalculate the retention value when you move an amount from the 'Materials Stored' column to the 'Work Completed' column. Below is an example showing what happens when the 'Work Completed Retention' is set to 10% and 'Materials Stored Retention' is set to 5%:
Example
In this example, a lower retention amount was withheld on the materials while they were stored and then the full retention was taken once they were incorporated into the project.
FIRST PAYMENT APPLICATION- $50,000 Work Completed
- $5,000 Work Completed Retention withheld
- $10,000 Materials Stored
- $500 Materials Stored Retention withheld
- $70,000 Work Completed ($50,000 from Previous + $10,000 Work this Period + $10,000 Materials Stored)
- $7,000 Work Completed Retention withheld
- $0 Materials Stored
- $0 Materials Stored Retention withheld
- Looking at the Summary Page, note that line 5B for Materials Stored Retention will only show a value if there are current materials being stored. All retention moves into Work Completed retention as the materials are incorporated into the project.