Skip to content
English
  • There are no suggestions because the search field is empty.

Uploading Business Units

A guide for uploading business units

  • Business Units can be loaded via .csv file on the backend 
    • If a customer is requesting addition of more than 5 business units, this feature is the most efficient tool, if less than 5 manual creation (see Expense Classification) is the best use of time
  • Start by downloading a clean copy of the template
  • Use an existing data request form to fill in the template
    • If no form exists, send a new one to customer or request a spreadsheet of locations they would like added
  • Fill in all fields
    • Location ID 
      • Found on the backend on the location page
        • If you are executing this upload directly after a location upload, maintain the order from the location upload
        • Location upload generate the ids sequentially based on upload order, so maintaining order for this upload will allow for easier matching of the location id and business unit
    • Expense Type
      • Must link to a customers existing chart of account
        • Ex. Operating, Capital, Homes
    • Business Unit
      • Customer provided business unit or short code to identify the billing entity
  • Once complete, download a copy of the sheet as a .csv file
  • Proceed to the correct customer page
  • Once selected, click "Locations" from the left hand navigation bar
  • In the upper right corner select "Import business units"
  • Select your recently completed .csv file after clicking "Choose File"
  • Click "Upload"
  • A green bar will appear with a link to check progress
  • Click the link and you will be taken to status screen similar to this

  • If the status shows "Not Imported due to errors" click "Download me" by "Result file path"
    • The resulting excel sheet will show any errors on the upload
      • Typical errors are location ids not registered to the specific customer or unsupported expense type
    • After correcting the errors, retry the download as many times as needed to clear the errors
      • If you are still unsuccessful in downloading, slack #product-updates with the issue(s) along with steps you have taken to resolve
  • Once you get a screen confirming upload, return to the customer page and confirm locations were added as desired
  • Return to the customer page and spot check selected location to confirm accuracy