Energy Provider Product

Enrollment Capture

This subsystem captures all necessary information to enroll a customer.  The information can be manually entered through an administrative interface, manual entered through a guided wizard interface or entered directly by the customer through a web interface.  

Special features include 

  • Enrollment process flow that follows and adheres to all PUC regulatory requirements.  Easily updated verbiage allows for easy updates as regulation changes dictate. 
  • The ability to quickly search existing customer accounts based upon multiple search parameters to insure information continuity for re-enrolling customers and reduction in duplicate customer accounts. 
  • Quick retrieval of all location information based on minimal address entry. 
  • The ability to enroll residential, commercial, CSA, and Reverse Generation customers. 
  • The ability to process reverse generation accounts. 
  • The ability to capture the credit rating of a new customer and automatically calculate and bill a required deposit amount prior to activating the customer. 
  • The ability to capture ACH/Credit Card information, Instantaneous preauthorization on credit cards is used to insure account validity. 
  • A process to automatically capture tax rate information associated with the service address. 
  • Safe harbor information to protect battered spouses. 
  • Alert information that can be used to aid support staff in dealing with chronically late pay or fraudulent customers.  
  • An online process that uses a three tier methodology designed to make SQL injection attacks impossible.  
  • A complete history of all plans, both current and prior associated with the customer. 
  • The ability to link plans combining all transactions into a single invoice that allows customers to view charges for each service address separately, but pay for both via a single transaction even if the meter read dates are different. 
  • The ability to specify multiple payment methods associated with a customer.  Either support staff or the customer can then easily alter the payment account used to satisfy a charge. 
  • The ability to specify Guarantor information.  This allows support staff to easily charge an alternate entity should the primary entity be unable to pay. 
  • The ability to have multiple people authorized to make decisions regarding commercial accounts. 
  • The ability to quickly see all charges and payments associated with a customer’s account.  All transactions will be grouped by invoice thus allowing support staff to quickly see any pending transactions. 
  • A list of all system generated notices including the date emailed to the customer.  
  • The ability to handle delinquent customers.  This includes the ability to initiate payment plans in a variety of ways that include one-time payments, over time payments, and invoiced based payments. 
  • The ability to track and manage customer referrals. 
  • The ability to track all TDSP Usage and Pass-Thru charges. 
  • The ability to create and track all manual charges. 
  • The ability to track all outgoing ERCOT transactions such as switch, move-in, or move out. 
  • The ability to manage re-enrollment. 
  • The ability to capture Customer Issue Interaction via linked issue tracking.

image1

Credit Analysis

This subsystem interfaces directly with Equifax for both residential and commercial credit analysis.  This interface is used during the enrollment process to determine if a deposit will be required.  The web interface returns a credit score and calculates a required deposit amount based upon that score.  

Special features include 

  • Automated interface with Equifax from within the application.

image2

EDI Transaction Management

This subsystem interfaces directly with Energy Service Group (ESG) for both residential and commercial customers.  ESG was chosen as the default EDI provider as they offered a common transaction format for all states.  The interface is written in such a fashion as to make switching EDI providers relatively easy.  

Special features include 

  • Generic translation process to convert EDI files into database tables. 
  • Minimal interfaces to the raw data thus making it easier to change EDI providers.

image3

Customer Service

This subsystem provides an enrollment interface that is designed to walk a support representative through the process of enrolling a customer.  The subsystem uses a step by step approach complete with prompts to ask for customer information and/or responses to authorize their enrollment. 

Special features include 

  • Step by step screens designed to minimize training necessary to enroll a customer via telephone. 
  • Automatic credit checks performed during enrollment. 
  • Special features designed to detect fraudulent customers during enrollment. 
  • Dashboard designed to show all relevant information about the customer.  This aids in detecting enrollment requests from people that are using fraudulent practices.  It also provides a quick one look view of billing vs. payment history.

image4

Customer Prospecting

This subsystem allows sales staff to capture a variety of information about potential customers.  This information can be used to track the progress of sales attempts as well as ultimately creating new enrollments without having to duplicate enrollment information. 

Special features include 

  • The ability to perform credit checks on commercial prospects. 
  • The ability to specify guarantor information should the company’s financial history prove to be inadequate. 
  • The ability to incorporate legal into the sales process to insure that all necessary paperwork has been reviewed and deemed to be in compliance with company policy. 
  • The ability to auto generate commercial customer enrollments should the sales effort prove successful.

image5

Pricing Capture

This subsystem stores plan rates which are then used by all enrollment and invoicing processes.  These rates are date/time stamped to insure that enrolling customers get the most current pricing.  The rates may be entered into the system manually or uploaded by external systems.  Uploaded rates are deemed to be effective until a new rate is uploaded or until the plan is deactivated.  These rates are used to define plan pricing during enrollment/re-enrollment and for MTM pricing during invoice creation. 

Special features include 

  • EFL documents are linked to each pricing plan and stored on cloud servers.

image6

Delinquent Accounts

This subsystem automatically classifies any past due account or write-off account as delinquent.  Alternate collection methods can then be used for these accounts.  In severe cases, the accounts can be marked for disconnection and turned over to a collection agency.  If payment is made, the system will automatically remove the customer from the delinquent subsystem.  Tracking items and notices can be generated from within the subsystem to aid in the collection process. 

Special features include 

  • Automatically adding or removing accounts from Delinquent subsystem based upon payment history. 
  • The ability to easily see invoice vs. payment history. 
  • The ability to capture money collected by outside agencies for tax purposes. 
  • The ability to generate disconnect notices. 
  • The ability to generate and store printable disconnect notices.

image7

Issue Tracking

This subsystem is used for cross departmental communication as well as a method for the subsystem to communicate required actions.  This subsystem allows for manual as well as automated action item generation.  These actions can be assigned to individuals or groups based upon conditions within the system.  They aid in the work process associated with REP functions. 

Special features include 

  • Direct integration to all retail subsystems. 
  • The ability to enter manual action items.  These action items are often used to tell other departments such as accounts receivable to place credits on a customer’s account or possibly mark an invoice as disputed pending meter testing. 
  • Automatic generation of many action items such as renewal contact and payment denied actions. 
  • The ability to provide a clear path of accountability for processing tasks that need to be performed.

image8

Forecasting

This subsystem is used to estimate energy demands in the near future.  The difference between this daily demand and the physical wholesale power purchased is used to either buy or sell block power to match a client’s estimated power needs.  

Special features include 

  • The ability to do daily adjustments to wholesale power trades.

image9

Billing

This subsystem automatically generates invoices based upon receiving EDI transactions.  Every EDI transaction will automatically be assigned to a pending invoice or create a new invoice should one not exist.  The system will analyze all transactions associated with an invoice and mark the invoice as complete once all required transactions have been received. 

Special features include 

  • Invoice form and content is designed to comply with all PUC regulations.  Invoice can be delivered in English or Spanish to meet the customer’s language preference. 
  • The ability to process and create invoices from transactions received from the TDSP via the EDI provider, system transactions such as late fee or levelized billing created during the invoice process, manual transactions such as promotional discounts, referrals, and customer service  alterations and payment plan transactions.
  • Generating a single invoice for linked energy plans.  The process will treat one plan as the master and allow the combined invoice to be created by either specifying that all plans must be complete or allowing selected plans to be partial.  Any partial plans will be captured on the next combined invoice. 
  • Auto generating an email notice to the customer indicating the date and amount that will be billed. 
  • Flagging and sending out all completed invoices with a single click. 
  • Performing a variety of accuracy and reasonability checks on each invoice generated.  Any invoice falling outside of the criteria is automatically flagged for review.  Examples would be refunds due, or usage volumes falling out of historical ranges. 
  • Allowing accounting personnel to adjust invoices by adding/removing charges or credits to existing invoices. • Generating a printable adobe PDF file that is stored on cloud servers for online viewing of historical data.  Each invoice includes graphs containing energy usage statistics for the last year at the service address. 
  • The ability to perform levelized billing.  
  • The ability to incorporate payment plans into the invoice. 
  • The ability to handle disputed charges.  Any disputed invoices are temporarily removed from the aging reports pending resolution of the disputed charges. 
  • Automatically tracks unpaid amounts associated with an invoice. 
  • Automatically assigns ledger account numbers to each transaction for accurate year-end tax processing. 
  • Allows special notices to be incorporated into the invoice generation process.  These notices can be anything from required PUC notices to custom marketing notices. 
  • The ability to track deposits and calculate interest upon return of the deposit.

image10

Payment Capture

This subsystem generates a list of payments due over the next few weeks and allows support staff to request payment either individually or in bulk.  Payment requests that fail are placed in a denied status where notices can be sent via an automated process to the customer indicating that the payment failed and tracking items are generated to support staff indicating that the customer should be contacted to fix the problem.  Payment requests that succeed are automatically placed in a received status and then used to generate cash entries that are itemized against invoices.  This automatic itemization process allows support staff to easily determine if money is due as well as increasing the accuracy of the aging reports.  If payments are reversed, these automatic entries can be corrected manually during the process of balancing bank statements.  Any past due account is automatically placed in the delinquent subsystem where alternate collection methods can be used.  Credit card and ACH processing is currently handled thru an API interface with CyberSource.  The interface is written in such a fashion as to make switching Institutions relatively easy.     

Special features include 

  • Automatic verification of payments and logging of responses. 
  • Itemization of cash entries against invoices. 
  • Ability to send notices to the customer for a variety of situations including a lack of funds or payment denied.
  • Ability to alter payment methods to secondary accounts. 
  • Ability to alter payment methods to guarantor accounts. 
  • Ability to defer payments to a date when funds will be available. 
  • Automatically flag denied payments whose payment method has changed so they can be reprocessed. 
  • Ability to write-off payments as uncollectible. 
  • Automatically placing unpaid accounts into the delinquent subsystem. 
  • Automatic generation of payments due to the TDU’s. 
  • Ability to generate customer refunds with proper authorization. 
  • Ability to exclude specific payments from the batch being processed. 
  • Ability to delay payment request without running it. 
  • History of all customers’ payments.

image11

Accounts Payable / Receivable

This subsystem allows manual and automated entry of payable and receivable transactions which can then be itemized against invoices to quickly determine under or over payments.  The interface is simple and easy to use.  Cash entries can be easily extracted for external system interfaces. 

Special features include 

  • Easy to use Quick Books type interface. 
  • Easy extraction of information for external system interfaces. 
  • Automatic links from cash entries to the original source transaction.

image12

Daily Reporting

This subsystem provides a wide variety of reports and messaging used in conjunction with the retail subsystem.  Examples include basic audit reports, pre and post close accounting reports, invoice generation and meter read cycle reports. 

Special features include 

  • Report group segmentation. 
  • Easy creation and inclusion of new or modified reports into the system. 
  • Ability to group and manage report and message distribution. 
  • Ability to automatically generate and distribute reports thru email. 


Reporting examples include but are not limited to 

  • Basic audit reports
  • Pre and post close accounting reports
  • Invoice generation


Meter read cycle Ability to automatically generate and distribute system messages thru email.  Messaging examples include

  • Commercial Prospect Requires Legal Approval
  • Commercial Customer Requires Legal Approval

image13

Auditing

This subsystem provides a method of reviewing all changes made to master transactions.  The system is designed to retain a history of each modification made.  The retention of the change history is dynamic and can be controlled on an individual table by table basis. 

Special features include 

  • The ability to dynamically change the alteration history retention by table.

image14

Ledger Entry

The subsystem extracts all relevant retail transactions and summarizes them into ledger entries during an accounting close process.  Once closed, a period can be locked thus preventing accidental alterations to transactions associated with that period.  The summarized ledger entries can then be extracted and entered into alternate accounting systems such as Quick Books if desired.  The accounting subsystem is also designed to accept manual entries and can therefore be used as a replacement for external accounting subsystems. 

Special features include 

  • The ability to alter ledger number schemes without changing existing transactions. 
  • The ability to maintain detail ledger entries that can be extracted and summarized for entry into external accounting systems.

image15

Custom Security

This subsystem provides multiple levels of security within the entire application.  The first level of security is by table.  The security subsystem can restrict access by table or groups of tables.  The second level of security is controlled at a company level.  Each user defined to the system can be associated with multiple companies.  The system can be used to allow anything from full access to no access for a company within authorized tables.  The third level of access is by application screen.  Users can be allowed or prevented from viewing content on a screen by screen basis. 

Special features include 

  • The ability to control access by table, company, and screen. 
  • The ability to force password changes on a user by user basis. 
  • The ability to encrypt passwords within the application thus preventing users from accessing data from third party software.

image16

Task Scheduler

This subsystem is used to automate daily processing.  Nearly all functions within the application can be entered into the task scheduler and run on an automated timer throughout the day. 

Special features include 

  • The ability to create multiple schedules. 
  • The ability to specify single or multiple starts within a schedule. 
  • The ability to hold a process until a specified time. 
  • Message logging indicating the status of each schedule process.

image17

Web Interface

This subsystem allows potential customers to perform all common tasks associated with the act of changing energy providers and managing “payment for services” accounts.  The guided navigation allows customers to easily review plans and rates currently available, specify payment information, change energy providers and specify a date the change is to take effect.  Existing customers can alter payment dates within predefined system limits, view historical invoices and alter personal information associated with the account.  

Special features include 

  • Easy to use guided navigation. 
  • The ability to review available plans and rates. 
  • The ability to sign up for new residential and/or small commercial service. 
  • The ability to capture payment information and perform online credit checks. 
  • The ability to update personal information associated with managing service accounts. 
  • The ability to alter payment dates within predefined system limits. 
  • The ability to view historical invoices.

image18