Skip to main content

ETF Invoice Queue

alt_text

The ETF invoice queue will generate invoices for ETF if certain parameters are met.

ETF Invoice Amount: Calculation Detail​

Residential and Small Commercial Accounts​

  • Involved Fields:

    • ETF Window (Under Utility Manager)

    • Cancellation Fee Type (Under Plans Manager)

    • Cancellation Fee $ (Under Plans Manager)

CALCULATION

For the ETF amount to be calculated, the following criteria must be met: Contract End Date and Drop Date must be different than NULL. For accounts that aren’t dropped, the current date works as the Drop Date.

  1. System calculates the difference between the Contract End Date and Drop Date.

  2. If the amount of days from the previous calculation is equal or smaller than the value of days specified under ETF Window (Utility Manager), zero amount is billed to the customer.

  3. If the amount of days from step 1 is greater than ETF Window (Utility Manager), system will check the Cancellation Fee Type tied to the plan of the account.

  • Annual: Cancellation Fee $ (Plans Manager) is divided by 365 and multiplied by the amount of days from step 1. This is the amount billed to the customer.

  • Monthly: Cancellation Fee $ (Plans Manager) is divided by 12 and multiplied by the amount of days from step 1. This is the amount billed to the customer.

  • Daily: Cancellation Fee $ (Plans Manager) is multiplied by the amount of days from step 1. This is the amount billed to the customer.

  • Fixed: Cancellation Fee $ (Plans Manager) is billed to the customer.

Large Commercial Accounts​

  • Involved Fields:

    • Approximated Annual Usage (From Enrollment)

    • Large Commercial ETF Days (From System Setup)

    • Plan Rate

CALCULATION

  1. Annual amount is calculated by dividing approximated annual usage by 12 then by 30 and then this result is multiplied by the plan’s rate.

  2. Difference of days is calculated between Current Date and Contract End Date.

  3. This difference is compared against the ETF Days for Commercial Accounts.

  4. If the difference is bigger or equal to the ETF Days,  the amount calculated on step 1, this amount is multiplied by the ETF Days for Commercial accounts. This is the final amount billed to the customer.

  5. Otherwise, if the difference is smaller, the annual amount from step 1 is multiplied by the amount of days from step 2 and this is the final amount billed to the user.