Loading...
HomeMy WebLinkAbout20221223_Veolia to Staff Attachment - Response to No. 53.pdf VEO-W-22-02 IPUC DR 53 Page 1 of 1 VEOLIA WATER IDAHO, INC. CASE VEO-W-22-02 THIRD PRODUCTION REQUEST OF THE COMMISSION STAFF Preparer/Sponsoring Witness: Cary REQUEST NO. 53: Please provide an update through November 2022 to the SUZ-W-19-01 Semi-Annual Deferred Convenience Fee Report filed in November 2021. RESPONSE NO. 53: Please see the attachment to this data request. Customer payment convenience fees are no longer deferred to General Ledger Account 18699- Other Regulatory Assets as of conclusion of the 2020 general rate case in May 2021. Those costs are now included as part of operating expenses reflected in General Ledger Account 50400- Outside Services Cost Element 641045 E- Payment Convenience Fees. The only deferred balance transactions posting are for monthly amortization per the Commission's Order. VEO-W-22-02IPUC DR 53 Attachment 1 of 4 SUEZSemi-Annual Report to IPUC - As of November 2021Deferred Customer Convenience FeesSUZ-W-19-01 Order No. 34405 Description Payment Type Period Payment Unit Price Amount Quick Collect/Convenience Pay/CC - credit applied by CSR Various Dec-19 835 1.99$ 1,662.59$ Quick Collect/Convenience Pay/CC - credit applied by CSR Various Dec-19 32 1.99$ 63.68$ Speedpay_BILLER PAID_ACH PYMTNS ACH Dec-19 3,364 0.25$ 841.00$ Speedpay_BILLER PAID_RETURN ACH ACH RETURN Dec-19 3 1.50$ 4.50$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless ATM Dec-19 633 1.99$ 1,259.67$ Speedpay_BILLER PAID_CC PYMTNS CC Dec-19 6,157 1.99$ 12,252.43$ Speedpay_BILLER PAID_ACH PYMTNS ACH Jan-20 4,001 0.25$ 1,000.25$ Speedpay_BILLER PAID_RETURN ACH ACH RETURN Jan-20 9 1.50$ 13.50$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless ATM Jan-20 657 1.20$ 788.40$ Speedpay_BILLER PAID_CC PYMTNS CC Jan-20 8,109 1.20$ 9,730.80$ Speedpay_BILLER PAID_ACH PYMTNS ACH Feb-20 3,824 0.25$ 956.00$ Speedpay_BILLER PAID_RETURN ACH ACH RETURN Feb-20 7 1.50$ 10.50$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless ATM Feb-20 549 1.20$ 658.80$ Speedpay_BILLER PAID_CC PYMTNs CC Feb-20 8,004 1.20$ 9,604.80$ Speedpay_BILLER PAID_ACH PYMTNS ACH Mar-20 3,952 0.25$ 988.00$ Speedpay_BILLER PAID_RETURN ACH ACH RETURN Mar-20 5 1.50$ 7.50$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless ATM Mar-20 522 1.20$ 626.40$ Speedpay_BILLER PAID_CC PYMTNS CC Mar-20 7,486 1.20$ 8,983.20$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDL CC Apr-20 1 1.20$ 1.20$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EIAC CC Apr-20 268 1.20$ 321.60$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDA CC Apr-20 7,649 1.20$ 9,178.80$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Apr-20 2,348 0.25$ 587.00$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_IDA ATM Apr-20 549 1.20$ 658.80$ Speedpay_BILLER PAID_DC PYMTNS ALL CT-REID ATM Apr-20 1 1.99$ 1.99$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Apr-20 1,654 0.25$ 413.50$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN Apr-20 7 1.50$ 10.50$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EIAC CC May-20 296 1.20$ 355.20$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDA CC May-20 5,955 1.20$ 7,146.00$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH May-20 1,933 0.25$ 483.25$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN May-20 1 1.50$ 1.50$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_IDA ATM May-20 921 1.20$ 1,105.20$ Speedpay_BILLER PAID_DC PYMTNS ALL CT-REID ATM May-20 7 1.20$ 8.35$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH May-20 1,690 0.25$ 422.50$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN May-20 5 1.50$ 7.50$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Jun-20 2,376 0.25$ 594.00$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Jun-20 1,552 0.25$ 388.00$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EIAC CC Jun-20 6,423 1.20$ 7,707.60$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDA CC Jun-20 311 1.20$ 373.20$ Speedpay_BILLER PAID_DC PYMTNS ATM PinlessCT_IDA ATM Jun-20 1,024 1.20$ 1,228.80$ Speedpay_BILLER PAID_RETURNS ACH CT_EBIA ACH RETURN Jun-20 6 1.50$ 9.00$ Speedpay_BILLER PAID_DC PYMTNS ALL CT_REID ATM Jun-20 7 1.20$ 8.40$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDL CC Jun-20 1 1.20$ 1.20$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Jul-20 2,307 0.25$ 576.75$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Jul-20 1,776 0.25$ 444.00$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDA CC Jul-20 4,438 1.20$ 5,325.60$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EIAC CC Jul-20 431 1.20$ 517.20$ Speedpay_BILLER PAID_DC PYMTNS ATM PinlessCT_IDA ATM Jul-20 1,126 1.20$ 1,351.20$ Speedpay_BILLER PAID_RETURNS ACH CT_EBIA ACH Jul-20 8 1.50$ 12.00$ Speedpay_BILLER PAID_DC PYMTNS ALL CT_REID ATM Jul-20 11 1.20$ 13.20$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDL ACH Jul-20 1 0.25$ 0.25$ Speedpay_BILLER PAID_DC PYMTNS ATM PinlessCT_IDL ATM Jul-20 1 1.20$ 1.20$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDL CC Aug-20 1 1.20$ 1.20$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EIAC CC Aug-20 351 1.20$ 421.20$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Aug-20 5,045 1.20$ 6,054.00$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN Aug-20 2,779 0.25$ 694.75$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_IDA ATM Aug-20 1,364 1.20$ 1,636.80$ Speedpay_BILLER PAID_DC PYMTNS ALL CT-REID ATM Aug-20 13 1.20$ 15.60$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Aug-20 1,594 0.25$ 398.50$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN Aug-20 7 1.50$ 10.50$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EIAC CC Sep-20 459 1.20$ 550.80$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Sep-20 4,520 1.20$ 5,424.00$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Sep-20 2,438 0.25$ 609.50$ VEO-W-22-02IPUC DR 53 Attachment 2 of 4 SUEZSemi-Annual Report to IPUC - As of November 2021Deferred Customer Convenience FeesSUZ-W-19-01 Order No. 34405 Description Payment Type Period Payment Unit Price Amount Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDL ACH Sep-20 1 0.25$ 0.25$ Speedpay_BILLER PAID_DC PYMTNS ALL CT-REID ATM Sep-20 31 1.20$ 37.20$ Speedpay_BILLER PAID_DC PYMTNS ATM PinlessCT_IDL ATM Sep-20 1 1.20$ 1.20$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Sep-20 1,606 0.25$ 401.50$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN Sep-20 7 1.50$ 10.50$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EIAC CC Oct-20 398 1.20$ 477.60$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDA CC Oct-20 4,959 1.20$ 5,950.80$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Oct-20 2,864 0.25$ 716.00$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_IDA ATM Oct-20 1,703 1.20$ 2,043.60$ Speedpay_BILLER PAID_DC PYMTNS ALL CT-REID ATM Oct-20 49 1.20$ 58.80$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Oct-20 1,551 0.25$ 387.75$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN Oct-20 7 1.50$ 10.50$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDL CC Nov-20 1 1.20$ 1.20$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EAIC CC Nov-20 430 1.20$ 516.00$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDA CC Nov-20 4,717 1.20$ 5,660.40$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Nov-20 2,725 0.25$ 681.25$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_IDA ATM Nov-20 1,682 1.20$ 2,018.40$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT-IDL ACH Nov-20 1 0.25$ 0.25$ Speedpay_BILLER PAID_DC PYMTNS ALL CT-REID ATM Nov-20 40 1.20$ 48.00$ Speedpay_BILLER PAID_DC PYMTNS ATM PinlessCT_IDL ATM Nov-20 1 1.20$ 1.20$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Nov-20 1,523 0.25$ 380.75$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN Nov-20 2 1.50$ 3.00$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EAIC CC Dec-20 289 1.20$ 346.80$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDA CC Dec-20 5,313 1.20$ 6,375.60$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Dec-20 3,023 0.25$ 755.75$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_IDA ATM Dec-20 1,915 1.20$ 2,298.00$ Speedpay_BILLER PAID_DC PYMTNS ALL CT-REID ATM Dec-20 69 1.20$ 82.80$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Dec-20 1,149 0.25$ 287.25$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN Dec-20 8 1.50$ 12.00$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EAIC CC Jan-21 314 1.20$ 376.80$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDA CC Jan-21 4,999 1.20$ 5,998.80$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Jan-21 2,880 0.25$ 720.00$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_IDA ATM Jan-21 2,075 1.20$ 2,490.00$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT-IDL ACH Jan-21 1 0.25$ 0.25$ Speedpay_BILLER PAID_DC PYMTNS ALL CT-REID ATM Jan-21 59 1.20$ 70.80$ Speedpay_BILLER PAID_DC PYMTNS ATM PinlessCT_IDL ATM Jan-21 1 1.20$ 1.20$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_REIC ATM Jan-21 2 1.20$ 2.40$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Jan-21 1,238 0.25$ 309.50$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN Jan-21 3 1.50$ 4.50$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EAIC CC Feb-21 192 1.20$ 230.40$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDA CC Feb-21 4,670 1.20$ 5,604.00$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Feb-21 2,918 0.25$ 729.50$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_IDA ATM Feb-21 1,943 1.20$ 2,331.60$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_EIAC ATM Feb-21 2 1.20$ 2.40$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_REID ATM Feb-21 71 1.20$ 85.20$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Feb-21 940 0.25$ 235.00$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN Feb-21 6 1.50$ 9.00$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EAIC CC Mar-21 1,444 1.20$ 1,732.80$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDA CC Mar-21 3,619 1.20$ 4,342.80$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Mar-21 2,575 0.25$ 643.75$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_IDA ATM Mar-21 2,081 1.20$ 2,497.20$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDL ACH Mar-21 1 0.25$ 0.25$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_IDL ATM Mar-21 1 1.20$ 1.20$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_EIAC ATM Mar-21 662 1.20$ 794.40$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_REID ATM Mar-21 78 1.20$ 93.60$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDL CC Mar-21 1 1.20$ 1.20$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Mar-21 1,930 0.25$ 482.50$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN Mar-21 2 1.50$ 3.00$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_EAIC CC Apr-21 2,435 1.20$ 2,922.00$ Speedpay_BILLER PAID_CC PYMTNS ALL CT_IDA CC Apr-21 1,754 1.20$ 2,104.80$ Speedpay_BILLER PAID_ACH PYMTNS ALL CT_IDA ACH Apr-21 1,329 0.25$ 332.25$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_IDA ATM Apr-21 1,214 1.20$ 1,456.80$ Speedpay_BILLER PAID_DC PYMTNS ATM Pinless CT_EIAC ATM Apr-21 1,419 1.20$ 1,702.80$ VEO-W-22-02IPUC DR 53 Attachment 3 of 4 SUEZSemi-Annual Report to IPUC - As of November 2021Deferred Customer Convenience FeesSUZ-W-19-01 Order No. 34405 Description Payment Type Period Payment Unit Price Amount Speedpay_BILLER PAID_ACH PYMTNS ALL CT_EBIA ACH Apr-21 2,435 0.25$ 608.75$ Speedpay_BILLER PAID_RETURN ACH CT_EBIA ACH RETURN Apr-21 9 1.50$ 13.50$ May-21 (11,579)(9,898.45)$ Jun-21 (10,670)(9,230.90)$ Deferred Convenience Fees 172,498 0.90$ 155,783.31$ VEO-W-22-02IPUC DR 53 Attachment 4 of 4 SUEZSemi-Annual Report to IPUC - As of November 2021Deferred Customer Convenience FeesSUZ-W-19-01 Order No. 34405 Description Payment Type Period Payment Unit Price Amount month period from May 1, 2021 to Apr 30, 2025 (RY1-RY4), per May-21 (3,245.00)$ Amortization Total (61,655.00)$ Deferred Balance Convenience Fees & Amortization as of: 11/30/2022 94,128.31$ NOTES: Fee reduction Jan. 2020 from $1.99 to $1.20 per transaction per renegotiated SpeedPay/ACI contract ACH Automatic Clearing House ACH Returns ATM Automated Teller Machine (Debit Card) CC Credit Card