Contracts - Schedule of Values
Updated
Suggested Prior Reading
OR
Contracts - Schedule of Values Overview
A Schedule of Values is setup for Contracts to outline the details of the Contracts with Owners/Architects.
A Schedule of Values consists of a number of Line Items.
The Line Items in the Contracts Schedule of Values often make up the Budget for the Contract (i.e. the Contract is setup with the Owner/Architect and the Line Items from the Schedule of Values, then automatically create and populate line item values on the Budget).
The Schedule of Values can be:
- Created during the Add of a new Contract OR
- Created during the edit of an existing Contract (where the Schedule of Values was not previously created) AND/OR
- Maintained during the edit of an existing Contract where the Schedule of Values was previously created
Note, a Contract and its Schedule of Values can be edited only if it is in a status that enables editing. See Contracts - Status for more information.
For complete details on Schedule of Values and when they can be maintained, see Schedule of Values - Overview.
If Financial Markups are going to be applied, they can be setup before or after the creation of the Schedule of Values. See Financial Markups - Overview for more information.
Before getting started on adding Line Items on the Schedule of Values, Cost Codes, Cost Types (and Sub Jobs if applicable must first be setup). See Cost Codes - Overview and Sub Jobs - Overview for more information.
Schedule of Values Component
The Schedule of Values component is where the Schedule of Values settings are set and where Line Items are added, edited or deleted. It is also where summary and total displays.
The Schedule of Values Component displays on the New Contracts form or the Contracts - View/Edit form.
For details on the Schedule of Values overall layout and Navigation, see Schedule of Values – Layout and Navigation.
Schedule of Values - Accounting Method
There is a Schedule of Values setting that sets the Accounting Method. This can only be set when no line items have been added (and as long as the Contract is in a status that enables adding or editing).
A default Accounting Method is setup by the System Administrator, however it can be changed before the Schedule of Values is created. See Schedule of Values - Accounting Method for more information.
Schedule of Values - Line Items
Line Items can be added individually or through a Bulk import.
The columns for the Line Items will vary depending on system settings and project settings as well as financial markups entered. For more information, see Schedule of Values - Line Items.
During the add session i.e. before the Contract is saved, Line Items can be added, all the information on the Line Items can be edited (if needed) and Line Items can be deleted. However, the Line Items aren't actually saved until the Contract is saved. It is a working session.
Once the Contract/Schedule of Values is saved, the Parent/Sub Job (if being used), the Cost Code and the Cost Type for a Line Item can not be edited. The reason, is that the Parent/Sub Job (if being used), the Cost Code and the Cost Type are linked to the Budget.
However, the other information can be still edited after the Contract is saved such as the Description, Amount or Tax (but only as long as the Contract is in a Status that enables editing). After the Save any of the Line Items can be deleted (again only as long as the Contract is in a Status that enables editing)
To fix a situation where the Contract has been saved but the the Parent/Sub Job, the Cost Code or the Cost Type for a Line Item is incorrect, the line would have to be deleted and re-entered (but again this can only be done if the Contract is in a status that enables editing).
For details on how the the Contract Line Items display, see Schedule of Values - Line Items.
Summary and Totals Section
The Summary and Totals Section on the Contracts Schedule of Values has the following information.
- Subtotal - The Subtotal for all Line Items
- Tax - The total tax for all Line Items (with Tax Codes set) (if Tax Codes have been entered).
- Original Contract - The Subtotal for all Line Items plus the total tax for all Line Items
- Approved Changes - The Total of any Approved Changes (including Taxes and Financial Markups)
- Contract Total - The Original Contact plus the Approved Changes
- Billed to Date - The Total Amount Billed to Date (including Taxes and Financial Markups). Note* This does not include the Payments, just the approved Invoice amounts.
- Amount Remaining - The Contract Total minus the Billed to Date
This information is automatically calculated. As Line Item values are entered it also automatically updates to reflect the information (but the form has to be saved to retain the changes).
Next Steps
- Create the Schedule of Values during the add of a New Contract, see Contracts - Schedule of Values - Create During Add.
- Create the Schedule of Values during the edit of an existing Contract (and when no Line Items have been entered), see Contracts - Schedule of Values - Create During Edit.
- Maintain the Schedule of Values during the edit of a Contract, see Contracts - Schedule of Values - Maintain.
