Create a Budget

Adding a budget to Cost Management is one of the first steps to start working with Cost Management capabilities and workflows.

There are three ways to add a budget:

• Import an existing budget in the form of a spreadsheet.
• Manually add budget items one at a time.
• Integrate directly to an ERP or estimating system using an API. Contact your integration vendor for more information.

Import an Existing Spreadsheet

Once budget code segments have been defined, you can import a budget to Cost Management using the budget template provided by the software. To create a well-formatted budget, follow the guidelines provided within the template.

To download a budget template:

1. Click Module Selector .
2. Click on the Budget tab to open the budget in Edit mode.
3. Click Import to import an existing budget spreadsheet.

Within the budget template, you can see examples with helpful formatting tips and already prepared budget codes, along with empty templates with or without hierarchy. Follow guidelines provided within template to create a well-formatted budget. Once done:

1. Save the file to your computer.
2. Come back to the Cost Management's Budget Import window.
3. Drag a file there or click Choose file.

Best Practices on Formatting a Budget Excel File

• The imported budget should not include summary groups of other budget items. Grouping is managed by using master lists for each segment, allowing more flexibility while manipulating the budget.
• The imported budget can have subitems. However, those should only be subitems to an actual budget item.
• When importing budget codes, the system allows the import of special characters (for example, hyphen), known as a delimiter within the actual imported code.
• Any special characters will be counted in the # of digits in the segment. For example:
  • 03.00.00 = 8 digits
  • 030000 = 6 digits
• Members can add delimiters between complete segments. For example, if CSI was a segment (eight digits) and cost type another (three digits), then there might be a delimiter between 03.00.00-LAB. This example will be 11 total digits (8+3) when imported. This means both the group headers which are driven by the segment master list and the actual budget line items will be shown with special characters.

The following example shows an exported budget on the left and the proper format for import on the right. The summary groups are removed allowing cost to sort by segment to get the same functionality but have more flexibility.

The following video explains setting up the import of a budget:

Add a Budget Item

You can add a budget manually. To add a budget item:

1. Click Module Selector .
2. Click on the Budget tab to open the budget in Edit mode.
3. Click Add to add individual budget items.
4. On the new budget item row, enter the budget code. The budget code field restricts your data entry to the form defined in the budget code template. If delimiters are used between segments, they are automatically populated.
5. Enter a budget name for the new item. The name of the new budget item is added automatically, based on the previously prepared budget code segments in Services.
6. If desired, you can click the budget name to open the details panel and add a description for the budget code or change the budget name.
7. Enter the Quantity.
8. Select the Unit type.
9. Enter the Unit Cost. The amount is populated automatically from the quantity and unit cost.
10. Select a Location for the budget item from the location breakdown structure.
11. Click again to return to the default view only state.

Add a Subitem

Within individual budget line items, you can add subitems that roll up into the parent budget item. For example, you may have a budget line item for concrete substructure. Wherein, you can break out individual subitems for pile caps, labor, and slab on grade.

To add a subitem:

1. Click on the Budget tab to open the budget in Edit mode.

2. Enable the checkbox for a budget item. This becomes the parent.

3. Click the More menu on the parent budget item.

   Tip: You can also right-click the budget item to bring up the More menu.

4. Choose Add subitem.

5. Follow steps 4-10 in the previous section to fill out the budget code, budget name, quantity, unit, and unit cost.

6. Click again to return to the default view only state.

Next Steps

You can learn how to work with budgets after creating one.

Related Articles

• Budget Settings
• Budget Code Setup