Custom Data Import and Export

Objective 1:  Increase efficiency of entering and processing utility invoices and improve data quality.

If one or more of the client’s utility vendors provides utility billing data in an electronic format, NET will complete the following steps to ensure that the client is able to import the data routinely into the EnergyCenter database:

  • Obtain sample data files and related documentation from the client and/or utility vendor.
  • Review data file formats and documentation.
  • Create corresponding file import definitions that allow the EnergyCenter software to interpret and load the invoice data.
  • Test the import process to ensure that all bills and line items contained in the sample data files are interpreted and loaded as expected into the EnergyCenter database.
  • Review results with the client.

Objective 2:  Increase efficiency of the utility bill payment process.

If the client would like to export utility billing data to an accounts payable application or other system, NET will complete the following steps to ensure that all required information can be exported routinely, and that invoice data is represented as necessary for proper interpretation by the receiving system:

  • Obtain sample output data files and related documentation from the client.
  • Review data file formats and documentation.
  • Determine requirements for storing and encoding general ledger codes or other accounting information in the EnergyCenter database.
  • Create invoice data export definitions that allow EnergyCenter software to produce data files that accurately represent utility invoice transactions according to the requirements of the receiving system.
  • Work with our client to test the export process to ensure that all bills and line items are exported and that data files are populated and formatted as required for accurate interpretation and processing by receiving systems.
  • Review results with client.