Open the Imports page
1
Open Imports
Open the account menu at the bottom of the sidebar and select Bulk Imports.
2
Review previous imports
The Imports page lists your previous imports with their type, file name, status and timestamps.

3
Start a new import
Click New Import to open the Bulk upload wizard.
Choose a template
The first step, Template, lists Recommended Templates and, below them, Auto-Generated Templates. Each card shows how many fields the template has and how many are required. Use Search templates… to find one quickly.
The steps that follow depend on the template.
Import most data types
Every template except the two brokerage templates uses these steps: Template, Method, Data, Map columns (meter reads only, when needed) and Upload.1
Method
Choose Upload CSV or Manual Entry (an editable grid).

2
Data
For Upload CSV, click Download Template with Sample Data to get a correctly formatted CSV with example rows. Fill it in, then drop one or more files onto the upload area. Each file can be up to 50 MB.
UMS checks each file’s columns against the template as soon as you add it, marking it Valid or listing the errors to fix. For Manual Entry, fill in the grid instead; every required field needs a value.

3
Map columns (meter reads)
For a meter-read file in a layout UMS doesn’t recognise, a Map columns step appears. UMS detects a suggested mapping; confirm how each of your columns maps onto the meter-read fields. A mapped interval file must be uploaded on its own, one file per import.
4
Upload
Click the upload button (for example Upload 2 files or Upload 10 rows). UMS processes the data in the background and shows live progress for each file, including how many rows succeeded and any per-row errors. Click Go to imports when you’re done.
Import brokerage records and revenue
Brokerage Records Upload and Brokerage Revenue Upload preview every row before anything is saved. The steps are Template, File, Map columns, Preview and Import.1
File
Drop a CSV or Excel file, or click Download CSV template to start from the template. For a workbook, choose the Sheet; set the Header row if the column headings aren’t on the first row.
2
Map columns
Match the file’s columns to the fields being imported. For revenue, map the NMI/MIRN for new rows, or the revenue ID for existing rows.
3
Preview
UMS checks every row and shows what each will do, with a Result, Agreement match and Message per row. Use Errors only to focus on problems, and tick Exclude on rows you want to skip.
4
Import
Click the import button, for example Import 120 rows. Rows with errors are skipped and counted in the label.
You can also import brokerage data from the Brokerage area. That route adds a Details step after Template for who the file is from.
Onboarding upload (all-in-one)
When you’re setting up a new portfolio, the Onboarding Upload template creates your whole hierarchy (accounts, sites, connections, retail accounts and agreements) from a single CSV. You don’t need a separate file for each entity in dependency order. It’s the file behind the guided onboarding wizard. It’s one row per connection (meter). Account, site and agreement values repeat down the rows and are de-duplicated automatically on a natural key, so you list each account or site once across many connections.Before you upload
- Suppliers and utilities must already exist. They’re referenced by name and only looked up. An unknown name is a validation error, so set them up first.
- Values that repeat must be consistent. Two rows with the same
account_namebut a differentaccount_parent_nameare rejected (no last-write-wins).
Columns
Download the template in the wizard to get the exact headers, or use onboarding-template.csv. The required minimum per row isaccount_name, connection_identifier, retail_supplier_name and retail_supplier_account_id. Everything else is optional: a row can create just an account, connection and retail account when there’s no site or agreement yet.
Review import results
Back on the Imports page, each import has a row menu:- Download: the original file you uploaded.
- Exceptions: a CSV of the rows that failed, with the reason for each.
- Result Data: a CSV with every row’s outcome.
- Refresh: re-checks the status of an import in progress.
Invalid files are skipped during upload rather than blocking the rest. Review the Exceptions report to see which rows were rejected and why, then fix and re-import just those rows.