Articles on: Steer New: Accomplishment Report

Converting BOQ to SOV Import Template

Last Updated: September 6, 2024

Schedule of Values

A Schedule of Values (SOV) is a crucial document used to allocate and track the value of various work components or items within a contract. It helps to keep track of progress and ensure accurate billing throughout the project. In this article, we will guide you to set up your Schedule of Values

Converting BOQ to SOV Import Template

Step 1: Setting up template

Access your Project Dashboard to start the process

Within your project, click on Modules

Fig.1: Dashboard

Click on Accomplishment Report

Fig.2: Accomplishment Report

In the Accomplishment Report section, click on Download Template. The download will start shortly after.

Fig.3: Download Template

Step 2: Inputting Values to the Template

Open the downloaded template and click on Enable Editing to make changes

Fig.4: Template

Input the necessary information. Refer to figure 5 for transferring values from BOQ to SOV template.
Optional Value: Contract Package Optional Information:

Fig.5: BOQ and SOV

Item Number must be a unique identifier and should always have a value.

Calculating Values. If any of the three essential components (Total Cost, Planned Quantity, or Unit Price) are not specified on your BOQ, you can use the following formulas to calculate the missing value:

Total Cost = Planned Quantity x Unit Price
Planned Quantity = Total Cost / Unit Price
Unit Price = Total Cost / Planned Quantity
Planned Percent Weight = Line Item Total Cost / Project Cost

Ensure all Planned Percent Weight value sum up to 1 or 100%

Step 2.1: Detail Explanation of BOQ to SOV transformation

Item Categories: These are broad classifications that group similar items together.

Item Numbers: These are unique identifiers assigned to each individual item within a category. They should be sequential and comprehensive to ensure accurate tracking and reporting.

Fig.6: with Item Categories but Incomplete Unique Identifier

Fig.7: with Complete Unique Identifier and Categories

Item Relationship or Hierarchy. When an item in the Bill of Quantities (BOQ) serves as a parent to other items, clearly indicate this hierarchical relationship in the Description field. For example, if 'Floor Preparations' is a parent category to 'Civil Works,' specify this in the Description field.

Fig.8: (left) incomplete item description. (right) complete item description