Pricing & Bill Component Mapping

As part of the bill validation process, Utilidex processes billing & pricing data from suppliers and turns it into easy to understandable nomenclature for the user.  This data comes through xls, xlsx, pdf and/or EDI, which makes it difficult to access and understand for most people in the industry not specialised in billing. 

It is often seen that there will be a difference in how information is displayed within pricing files and the prices in the contract.  For instance, a line item like Feed in Tariff, can be displayed as UNRESTRICTED106FIT within the billing file, but at the same time displayed as FiT in the contract.  The information needs to be deciphered to produce a cohesive result during the bill validation process.

Once the information is collated and turned into easy to understand text, it requires mapping between the 2 areas, which can differ per customer, even if they are under the same supplier.  The EDI/XLS mapping tool within the shadow bill validation screen solves this issue by creating a bridge between the information.  You can now choose connection points and display names. This cuts through the noise of complex industry billing and incoherent charge names. 

To complete the mapping, you need to enable the feature from User management in settings.  To update this, navigate to User Management and Manage Roles. From here you need to choose the role type you wish to have access to this feature, for example Admin users. Select the pencil to the side of the user role type and turn the feature on:

Now you have this feature enabled, you can navigate to Bills, Validation and Validate Bills. Next select the bill and invoice you wish to complete the mapping. 

Bill mapping invoice

Once you have chosen the invoice, Navigate to the shadow bill comparison tab and to the right of the screen select the EDI/XLS mapping. You will then see the below table in the centre of the screen. Within this window, you can identify 3 primary names: -

  • EDI/XLS name – this is how the line item appears in the billing file
  • Available Mapping – this is how the line item appears in the contract/pricing file
  • Display Name – this is how the line item will be displayed in the Utilidex system
EDI_XLS Mapping

You will also see 2 additional columns: -

  • Validate – this allows you to select whether to validate the line item or not
  • Group Category – this groups the line item under the selected group (the information for this is later used in analytics such as the Invoice Summary BI)

To set up, you simply select Locked on the top right corner.  This will turn the editable fields yellow as shown below.


You can then proceed to edit the details.  Once finished you can select save to finish the process and it is saved against the EDI/XLS mapping for the specific tariff. 

Please note you will need to re-run the billing file(s) to see the changes reflected.