Create cost centers with a spreadsheet

Setup spreadsheets save time and let you create multiple items at once.

  • The menu displays spreadsheets matching your permissions.
  • Always download a new spreadsheet before you begin adding data because the spreadsheet is populated with information from your database. 
  • To avoid errors when creating different objects refer to the required upload order.
  • To save time when creating many objects, select from the drop-down menu and then copy and paste the value into the other rows.

Format rules

  • Enter all information as text or dates.
  • You can add sheets to the notebook, UtilityManagement only processes the sheet named DataEntry.
  • Do not rename, remove, or rearrange columns.

Download the cost centers spreadsheet

On the Create page, select Setup Spreadsheets.

  1. From the Setup Spreadsheets Log, select Download.  
  2. Under Create Spreadsheet, select Cost Centers.
  3. Download the spreadsheet.
  4. The name format is yyyymmdd-CREATE_CostCenters.xlsx.
  5. Add your information and save.
  6. Use Import to upload your spreadsheet.
  7. The Setup Spreadsheets Log reports the results and any errors. You can download the kickout (errors) spreadsheet from the hyperlink, fix any errors, and upload the error sheet.

Permissions

The ability to create objects is determined by user role and any limits placed on the user's topmost place or topmost cost center.

Prerequisites

If creating multiple levels of cost centers, the parent cost center must exist in UtilityManagement or be created in a row before being referenced as a parent.

Maximum length for codes and names

The column header lists the maximum length for each attribute. When entering data, a red cell indicates the name or code exceeding the specified length. If you upload the spreadsheet without fixing the cell, the row fails to process and an error spreadsheet is created.

Create cost centers spreadsheet details

Column

Rules

Cost Center Code

This code must be unique. The row fails to process if a duplicate is found in your database. See the list below for accepted characters in codes.

Cost Center Name

 The name does not need to be unique but keeping names unique makes searching and reporting much clearer.

Parent Cost Center Code

Select where you want to create the cost center. If blank, the cost center is created at the root or at the user's topmost permissions.  

Multiple levels can be created by adding cost centers under cost centers.

Allowed characters for codes

  1. A-Z, no lower case letters
  2. 0-9
  3. &
  4. _
  5. /
  6. -

Example 

example spreadsheet