September 2024 Monthly Volume Rpt.xlsx

110 KB Posted

Attached to
Electronic Payment Processing Solution
Solicitation number
506333
Issued by
Denver County, Denver City, Colorado

About this file

Written by GovTribe AI ·

The document is a monthly volume report for Denver Water, detailing electronic payment transaction data for September 2024. The report comprehensively tracks payment volumes across multiple channels including recurring payments, web transactions, interactive voice response (IVR), SMS, call center, bill pay providers, and convenience pay options. Transaction types include ACH payments, credit card transactions, wire transfers, and cash payments, with a total transaction volume of 191,662 transactions representing $34,972,150.64 in total payment dollars.

The report provides granular insights into payment processing, including return rates, refund rates, and transaction breakdowns by payment method. Key metrics include 104,092 total recurring/automatic payment plan (APP) customers, with 73,951 ACH transactions, 140 ATM transactions, and 30,001 credit card transactions. Credit card transactions are processed through multiple channels, including Mastercard and Visa, with a total of 712 transactions year-to-date representing $3,476,268.13 in total dollars. The data aligns with Denver Water's ongoing electronic payment processing strategy, which seeks innovative technological solutions to enhance customer experience and streamline payment processing across diverse payment channels.

View the file

Other files

File Type Posted
506333 Addendum No 3.docx DOCX document
506333 Exhibit A - Sample Agreement.docx DOCX document
506333 Exhibit B - Proposal Response.docx DOCX document
506333 Exhibits CDEF.xlsx XLSX spreadsheet
506333 Addendum No 2.docx DOCX document
506333 Exhibit G Technology Accessibility Vendor Questionnaire.xlsx XLSX spreadsheet
506333 Exhibit H Vendor Security Assessment Questionnaire.xlsx XLSX spreadsheet
506333 Request for Proposal.docx DOCX document
506333 Addendum No 1.docx DOCX document
506333 Exhibits CDEF v.2 (Addendum #2).xlsx XLSX spreadsheet
506333 Exhibits CDEF v.3 (Addendum #3).xlsx XLSX spreadsheet
August 2024 Monthly Volume Rpt.xlsx XLSX spreadsheet
Show all 12

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

monthly volume rpt

Volume CountVolume Dollars
Receipts by SourceNumberPercent$ AmountPercent
In-House Deposit-Checks Pmts720%$ 3,762,719.8111%
In-House Deposit-Cash Pmts00- 00
eLockbox12,94761,115,618.333
EFTDBO (Fiserv)16,5948963,418.703
Western Union Convenience Pay WUCPCA2,8951247,912.781
ACI Speedpay E-Bill Credit Card EBCC2,3421209,144.791
ACI Speedpay E-Bill ACH EBCK3,1002237,359.651
ACI IVR Credit Card IVCC5,3873515,499.641
ACI IVR ACH IVCK4,3812343,611.171
ACI Speedpay Credit Card SPCC2,5611548,639.052
ACI Speedpay ACH SPCK9050172,096.430
ACI Web Credit Card WECC13,95071,677,660.175
ACI Web ACH WECK16,42983,012,988.409
ACI SMS Credit Card SMSCC174011,410.140
ACI SMS Check SMSCK475027,916.160
ACI Recurring Credit Card RECC27,117131,413,162.904
ACI Recurring ACH RECK65,328325,685,826.6116
UMB Lockbox29,5961411,197,292.8132
Wires In6903,787,310.0611
LIHWAP Payments196042,563.040
Total204,518100%$ 34,972,150.64100%
Rebate Credits (posted to CC&B Accounts)NumberPercent$ AmountPercent
Residential Rebates19100%0$ 2,308.50100%
Commerical Rebates00- 00
Total19100%$ 2,308.50100%
Handling VolumeNumberPercent$ AmountPercent
A.Return Items
WWF00%$ - 00%
eLockbox00- 00
EFTDBO (Checkfree)41243.990
Western Union Convenience Pay WUCPCA00- 00
ACI63994113,714.7694
Credit Card Chargebacks811,432.031
UMB Lockbox2646,166.735
Total677100%$ 121,557.51100%
B.Refund ItemsNumberPercent$ AmountPercent
Fiserv (Checkfree)133%$ 100.0049%
E-Lockbox267104.4251
Western Union Convenience Pay WUCPCA00- 00
Credit Cards00- 00
Total3100%$ 204.42100%
C.In-house additional handlingNumberPercent
Posted Suspense Items712100%N/A
Letters-payments with wrong Account/Customer ID Number00N/A
NOC (Notice of Change for ACH Pmts)00N/A
Unidenitified Payments Returned00$ - 0
712100%$ - 0
D.Suspense Items*NumberPercent$ AmountPercent
Amount 0 - 5 days old150%2248.9197%
Amount 6 - 30 days old000.000
Amount 31-60 days old15077.003
Amount 61and older000.000
Total at month end2100%2325.91100%
* No items pending as of July 31st.
Other
A.Automatic Pay Plan (APP) CustomersNumberPercent
Prior month end94,787
Current month end95,164
B.E-Bills deliveredNumberPercent
(Includes Duplicate & Third Party Bills)
Last month90,432**
This month91,071****Prior reports included courtesy bills and non bill related emails.
NumberPercent
C.E-Bill Customers (percentage based on 200,000 customer base)95,44548%
E-Bill Customers who pay via APP92,04496%

D. Total Speedpay/ACI credit card sales $ 4,375,516.69

&"-,Bold"Denver Water Monthly Volume Report December 2022 &9&UDistribution:&U Angela Bricmont Brian Good Julie Anderson Usha Sharma Ross Kuhn Aneta Rettig Michelle Garfield Lyndsay Schultz Michael Aragon Kathy Dudas

Monthly volume rpt revised

Volume CountVolume Dollars
Receipts by SourceNumberPercent$ AmountPercent
In-House Deposit-Checks Pmts1030%$ 2,852,524.884%
In-House Deposit-Cash Pmts00$ - 00
eLockbox14,8798$ 2,972,189.814
EFTDBO (Fiserv)11,3036$ 1,841,747.473
Western Union Convenience Pay WUCPCA2,6091$ 301,544.440
ACI Speedpay E-Bill Credit Card EBCC2,1991$ 567,265.591
ACI Speedpay E-Bill ACH EBCK2,7051$ 674,942.791
ACI IVR Credit Card IVCC5,5463$ 857,625.731
ACI IVR ACH IVCK4,4472$ 627,772.951
ACI Speedpay Credit Card SPCC2,9242$ 752,691.291
ACI Speedpay ACH SPCK8920$ 236,655.920
ACI Web Credit Card WECC16,1788$ 3,343,520.365
ACI Web ACH WECK17,4039$ 6,541,266.439
ACI SMS Credit Card SMSCC1260$ 13,655.940
ACI SMS Check SMSCK4330$ 55,195.400
ACI Recurring Credit Card RECC24,30213$ 3,279,388.275
ACI Recurring ACH RECK62,61033$ 14,023,183.1020
UMB Lockbox22,93112$ 19,781,012.7528
Wires In720$ 11,024,174.7616
LIHWAP Payments00$ - 00
Total191,662100%$ 69,746,357.88100%
Rebate Credits (posted to CC&B Accounts)NumberPercent$ AmountPercent
Residential Rebates64100%0$ 5,251.56100%
Commerical Rebates00- 00
Total64100%$ 5,251.56100%
Handling VolumeNumberPercent$ AmountPercent
A.Return Items
WWF00%$ - 00%
eLockbox00- 00
EFTDBO (Checkfree)20165.000
Western Union Convenience Pay WUCPCA00- 00
ACI77093194,841.4595
Credit Card Chargebacks2024,344.072
UMB Lockbox3245,626.363
Total824100%$ 204,976.88100%
B.Refund ItemsNumberPercent$ AmountPercent
Fiserv (Checkfree)514%$ 4,327.4331%
E-Lockbox17472,368.1617
Western Union Convenience Pay WUCPCA13244.402
Credit Cards13366,998.4350
LIHWAP Refunds00- 00
Total36100%$ 13,938.42100%
C.In-house additional handlingNumberPercent
Posted Suspense Items49898%N/A
Transaction Repair20
Returned ACH Transaction Repair71N/A
NOC00N/A
507100%$ - 0
D.Suspense Items*NumberPercent$ AmountPercent
Amount 0 - 5 days old0ERROR:#DIV/0!%0.00ERROR:#DIV/0!%
Amount 6 - 30 days old0ERROR:#DIV/0!0.00ERROR:#DIV/0!
Amount 31-60 days old0ERROR:#DIV/0!0.00ERROR:#DIV/0!
Amount 61and older0ERROR:#DIV/0!0.00ERROR:#DIV/0!
Total at month end0ERROR:#DIV/0!%0.00ERROR:#DIV/0!%
* No items pending as of March 31st.
Other
A.Automatic Pay Plan (APP) CustomersNumberPercent
Prior month end103,629
Current month end104,092
B.E-Bills deliveredNumberPercent
(Includes Duplicate & Third Party Bills)
Last month101,635**
This month102,543****Prior reports included courtesy bills and non bill related emails.
NumberPercent
C.E-Bill Customers (percentage based on 244,000 customer base)102,60251%
E-Bill Customers who pay via APP104,17099%

D. Total Speedpay/ACI credit card sales $ 8,814,147.18

&"-,Bold"Monthly Volume Report September 2024 Distribution:

Angela Bricmont Brian Good Julie Anderson Leila Kleats Abdul Aslamy Aneta Rettig Michelle Garfield Lyndsay Schultz Kathy Dudas receipt channels Transaction by Payment Channel Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 TTM %

RECURRING (APP)96,518111,15590,159105,61391,11899,24799,560105,40480,598115,312101,08186,9121,182,67748%
IVR10,4179,9649,30210,7939,3039,6679,9399,7178,88111,07110,1649,993119,2115%
One Click5,5635,3455,1825,6205,0685,0965,1875,0344,6025,5965,2074,90462,4043%
WEB33,31931,99430,84034,99930,42330,56333,96632,90629,87736,77733,24133,581392,48616%
SMS4118505195755295715845384955365245596,6910%
Call Center3,3532,7833,1393,2903,0212,8813,4364,3913,3513,8694,1493,81641,4792%
Bill Pay Provider29,15629,12727,97229,78227,05727,48228,12528,01725,00631,17928,25026,182337,33514%
Convenience Pay3,0002,6922,5442,9832,5642,5882,7952,7122,2802,9692,6342,60932,3701%
Lockbox27,64927,85224,99529,25824,34525,51126,21226,12222,52228,88125,23322,931311,51113%
Wires6659616643696159556566727420%
2,486,906100%
Transactions by Payment TypeOct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24TTM%
Paper Checks27,69527,92525,09729,31924,42525,55826,27526,20822,58728,96025,29523,034312,37813%13%Paper Check
Cash3,0002,6922,5442,9832,5642,5882,7952,7122,2802,9692,6342,60932,3701%1%Cash
ACH124,521133,339117,214132,951116,609122,443125,802129,387106,289141,765126,592114,6721,491,58460%
Credit Card54,21657,87949,89957,72149,91053,06454,99556,62046,52162,57556,02451,275650,69926%86%Electronic
Wires6659616643696159556566727420%
Total Payments209,498221,894194,815223,040193,551203,722209,928214,986177,732236,334210,611191,6622,487,773100%

Receipt Transactions by Type Paper Checks 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 27695 27925 25097 29319 24425 25558 26275 26208 22587 28960 25295 23034 Cash 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 3000 2692 2544 2983 2564 2588 2795 2712 2280 2969 2634 2609 ACH 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 124521 133339 117214 132951 116609 122443 125802 129387 106289 141765 126592 114672 Credit Card 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 54216 57879 49899 57721 49910 53064 54995 56620 46521 62575 56024 51275 Wires 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 66 59 61 66 43 69 61 59 55 65 66 72

Receipt Transactions by Channel RECURRING (APP) 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 96518 111155 90159 105613 91118 99247 99560 105404 80598 115312 101081 86912 IVR 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 10417 9964 9302 10793 9303 9667 9939 9717 8881 11071 10164 9993 One Click 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 5563 5345 5182 5620 5068 5096 5187 5034 4602 5596 5207 4904 WEB 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 33319 31994 30840 34999 30423 30563 33966 32906 29877 36777 33241 33581 Call Center 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 3353 2783 3139 3290 3021 2881 3436 4391 3351 3869 4149 3816 Bill Pay Provider 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 29156 29127 27972 29782 27057 27482 28125 28017 25006 31179 28250 26182 Convenience Pay 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 3000 2692 2544 2983 2564 2588 2795 2712 2280 2969 2634 2609 Lockbox 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 27649 27852 24995 29258 24345 25511 26212 26122 22522 28881 25233 22931 Wires 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 66 59 61 66 43 69 61 59 55 65 66 72 SMS 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 1 returns Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24

DBOEFT & EFTDBO Volume28,12528,01725,00631,17928,25026,182
DBOEFT & EFTDBO Returns466522
Return Rate0.014%0.021%0.024%0.016%0.007%0.008%
ACI ACH Volume97,677101,37076,121110,58698,34288,490
ACI ACH Returns691734675766828770
Return Rate0.707%0.724%0.887%0.693%0.842%0.870%
APP Volume000000*
APP Returns000000
Return Rate0.000%0.000%0.000%0.000%0.000%0.000%
UMB Lockbox Volume26,21226,12222,52228,88125,23322,931
UMB Lockbox Returns152722362832
Return Rate0.057%0.103%0.098%0.125%0.111%0.140%
WU Convenience Pay Volume2,7952,7122,2802,9692,6342,609
WU Convenience Pay Returns000010
Return Rate0.000%0.000%0.000%0.000%0.038%0.000%
ACI Credit Card Volume54,99556,62046,52162,57556,02451,275
ACI Credit Card Chargebacks55372520
Return Rate0.009%0.009%0.006%0.011%0.045%0.039%
ACI Credit Card Volume000000
ACI Credit Card Refunds000000
Return Rate0.000%0.000%0.000%0.000%0.000%0.000%
WWF Volume6386657979103
WWF Returns240000
Return Rate3.175%4.651%0.000%0.000%0.000%0.000%
Total Volume209,867214,927172,515236,269210,562191,590
Total Return717776706814884824
Overall Rate0.34%0.36%0.41%0.34%0.42%0.43%

Return Rates DBOEFT Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 1.3999999999999999E-4 2.1000000000000001E-4 2.4000000000000001E-4 1.6000000000000001E-4 6.9999999999999994E-5 8.0000000000000007E-5 ACI Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 7.0699999999999999E-3 7.2399999999999999E-3 8.8699999999999994E-3 6.9300000000000004E-3 8.4200000000000004E-3 8.6999999999999994E-3 Lockbox Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 5.6999999999999998E-4 1.0300000000000001E-3 9.7999999999999997E-4 1.25E-3 1.1100000000000001E-3 1.4E-3 WU Conv Pay Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 0 0 0 0 3.8000000000000002E-4 0 WWF Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 3.175E-2 4.6510000000000003E-2 0 0 0 0 ACI CC Chargebacks Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 9.0000000000000006E-5 9.0000000000000006E-5 6.0000000000000001E-3 1.1E-4 4.4999999999999999E-4 3.8999999999999999E-4 ACI CC Refunds Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 0 0 0 0 0 0 Total Returns Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 3.3999999999999998E-3 3.5999999999999999E-3 4.1000000000000003E-3 3.3999999999999998E-3 4.1999999999999997E-3 4.3E-3 data

Return Rates
Apr-24May-24Jun-24Jul-24Aug-24Sep-24
DBOEFT0.014%0.021%0.024%0.016%0.007%0.008%
ACI0.707%0.724%0.887%0.693%0.842%0.870%
Lockbox0.057%0.103%0.098%0.125%0.111%0.140%
WU Conv Pay0.000%0.000%0.000%0.000%0.038%0.000%
WWF3.175%4.651%0.000%0.000%0.000%0.000%
ACI CC Chargebacks0.009%0.009%0.600%0.011%0.045%0.039%
ACI CC Refunds0.000%0.000%0.000%0.000%0.000%0.000%
Total Returns0.340%0.360%0.410%0.340%0.420%0.430%
Jan-16Feb-16Mar-16Apr-16May-16Jun-16
Total Recurring/APP Customers491854997050355503555064251152
ACH446764485144794447944466544769
ATM213251272272273297
CREDIT CARD429648685289528957046089
Refunds
Apr-24May-24Jun-24Jul-24Aug-24Sep-24
eLockbox0.006%0.044%0.113%0.102%0.143%0.114%
Checkfree0.000%0.050%0.028%0.007%0.057%0.044%
ACI Credit Card0.004%0.011%0.018%0.013%0.030%0.025%
Western Union Con Pay0.000%0.000%0.000%0.000%0.000%0.000%
Total Refund0.001%0.002%0.002%0.002%0.002%0.002%

Refunds Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24

DBOEFT (eLockbox) Volume15,99416,01314,13417,71916,07214,879
DBOEFT (eLockbox) Refunds1716182317
Refund Rate0.006%0.044%0.113%0.102%0.143%0.114%
EFTDBO (Checkfree) Volume12,13112,00410,87213,46012,17811,303
EFTDBO (Checkfree) Refunds063175
Refund Rate0.000%0.050%0.028%0.007%0.057%0.044%
ACI Credit Card Volume54,99556,62076,12162,57556,02451,275
ACI Credit Card Refunds261481713
Refund Rate0.004%0.011%0.018%0.013%0.030%0.025%
WU Convenience Pay Volume2,7952,7122,2802,9692,6342,609
WU Convenience Pay Returns000000
Return Rate0.000%0.000%0.000%0.000%0.000%0.000%
Total Volume85,91587,349103,40796,72386,90880,066
Total Refunds31933274735
Overall Rate0.00%0.00%0.00%0.00%0.00%0.00%

Refund Rates eLockbox 45383 45413 45444 45474 45505 45536 6.0000000000000002E-5 4.4000000000000002E-4 1.1299999999999999E-3 1.0200000000000001E-3 1.4300000000000001E-3 1.14E-3 Checkfree 45383 45413 45444 45474 45505 45536 0 5.0000000000000001E-4 2.7999999999999998E-4 6.9999999999999994E-5 5.6999999999999998E-4 4.4000000000000002E-4 ACI Credit Card 45383 45413 45444 45474 45505 45536 4.0000000000000003E-5 1.1E-4 1.8000000000000001E-4 1.2999999999999999E-4 2.9999999999999997E-4 2.5000000000000001E-4 Total Refund 45383 45413 45444 45474 45505 45536 1.0000000000000001E-5 2.0000000000000002E-5 2.0000000000000002E-5 2.0000000000000002E-5 2.0000000000000002E-5 2.2676699999999999E-5 lockbox error

Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24
Total Lockbox Volume27,64927,85224,95929,25824,34525,51126,21226,21222,52228,88125,23322,931
Errors111101101211
Error Rate0.004%0.004%0.004%0.003%0.000%0.004%0.004%0.000%0.004%0.007%0.004%0.004%
Additional Information
Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24
Posted Suspense729795795750685682566573470616482498
Transfers4121123513533
Transaction Repair00117679117106122
Transaction Repair Returns00021711585287
Rebates-Residential54028252332641551471339564
Rebates-Commercial101010200010
Suspense Total $7700269680015600000
0-5 days %000100970000000
6-30 days %00003010000000
31-60 days %000000000000
61 days and older10000000000000
Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Aug-24
E-Bill99,702100,392100,392100,057101,839102,136102,624102,987103,292103,406103,824104,170
E-Bill Customer who pay via AutoPay97,90198,61898,61899,641100,49799,62299,49299,73399,942101,294102,147102,602

Lockbox Error Rate Error Rate 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 3.6167673333574452E-5 3.5904064340083297E-5 4.0065707760727592E-5 3.4178686171303578E-5 0 3.9198776998157654E-5 3.8150465435678313E-5 0 4.4401030103898409E-5 6.92496797202313E-5 3.9630642412713512E-5 4.360908813396712E-5 Number of APP & E-Bill Customer at Month End E-Bill 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45505 99702 100392 100392 100057 101839 102136 102624 102987 103292 103406 103824 104170 E-Bill Customer who pay via AutoPay 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45505 97901 98618 98618 99641 100497 99622 99492 99733 99942 101294 102147 102602

APP Snapshot

Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24
Total Recurring/APP Customers99,352100,359100,756101,226101,712102,035102,557102,565103,233102,982103,629104,092
ACH70,25870,92871,34271,86772,10772,35372,69572,74173,15273,20873,64973,951
ATM207192188180175165162154149143141140
CREDIT CARD28,88729,23929,22629,17929,43029,51729,70029,67029,93229,63129,83930,001

Recurring APP Transactions by Types

ACH 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 70258 70928 71342 71867 72107 72353 72695 72741 73152 73208 73649 73951 ATM 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 207 192 188 180 175 165 162 154 149 143 141 140 CREDIT CARD 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 28887 29239 29226 29179 29430 29517 29700 29670 29932 29631 29839 30001

Recurring APP Snapshot Sept 2015

ACH ATM CREDIT CARD 73951 140 30001

Recurring APP Snapshot Sept 2024

ACH ATM CREDIT CARD 73951 140 30001

Wtr Sales CC Water Sales Credit Card Transactions & Fees

WSLS (Master Card)WSLV (VISA)
Transaction CountTotal DollarsTotal FeesTransaction CountTotal DollarsTotal Fees
Aug-231592,762.982,087.1750169,444.9603,812.51
Sep-231227,096.16609.673241,961.420944.15
Oct-23715,153.87340.9646197,649.1204,447.12
Nov-231123,213.95522.324644,934.9901,011.07
Dec-2368,212.93184.79391,075,827.4702,419.36
Jan-24932,964.54741.713765,373.8501,470.91
Feb-2472,224.2550.063940,357.500908.07
Mar-2411672,584.001,513.893243,944.730988.77
Apr-24858,194.581,309.392895,902.6802,157.80
May-2431,300.0029.2533167,771.3803,774.86
Jun-2452,829.0063.6641123,784.3802,785.18
Jul-2474,514.73101.5858183,849.8304,136.69
Aug-241355,935.551,258.5552108,494.4202,441.17
Sep-2493,352.1075.4356116,632.7602,624.26

Total 123 1,000,338.64 8,888.43 589 2,475,929.49 33,921.92

Grand Total

Transaction Count Total Dollars Total Fees

Aug-2365262,207.945,899.68
Sep-234469,057.581,553.82
Oct-2353212,802.994,788.08
Nov-235768,148.941,533.39
Dec-23451,084,040.402,604.15
Jan-244698,338.392,212.62
Feb-244642,581.75958.13
Mar-2443716,528.732,502.66
Apr-2436154,097.263,467.19
May-2436169,071.383,804.11
Jun-2446126,613.382,848.84
Jul-2465188,364.564,238.27
Aug-2465164,429.973,699.72
Sep-2465119,984.862,699.69

YTD Total 712 3,476,268.13 42,810.35 description

APPAutomatic Payment Plan
EFTBOBiller Consolidator ACH Payments from US Bank
EFTDBOBiller Consolidator ACH Payments from Fiserv (Checkfree)
WUCPWestern Union Convienence Pay (Cash payments at King Soopers)
EBCCACI Ebill Credit Card Payments
EBCKACI Ebill Check Payments
IVCCACI IVR Credit Card Payments
IVCKACI IVR Check Card Payments
SPCCACI Speedpay Credit Card Payments (via Call Center)
SPCKACI Speedpay Check Payments (via Call Center)
WECCACI Web Credit Card Payments
WECKACI Web Check Paymaents
SMSCKACI SMS (Text) Check Payments
SMSCCACI SMS (Text) Credit Card Payments
RECKACI Recurring Check Payments(formally APP)
RECCACI Recurring Credit Card Payments(formally APP)
LOCKBOXUMB Lockbox-mailed payments
Credit CardIn house Credit Card Payments taken in Water Sales
NOCNotice of Change for ACH payments to correct account number information

&"Arial,Bold"&UAcronym Definitions volumes

Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24
EFT Volume29,15629,12727,97229,78227,05727,48228,12528,01725,00631,17928,25026,182
UMB Lockbox Volume27,64927,85224,99529,25824,34525,51126,21226,12222,52228,88125,23322,931
APP Volume000000000000
ACI & WU Volume152,581164,783141,685163,873142,026150,613155,467160,702130,084176,130157,000142,374
Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24Sep-24
RECKRecurring (APP) Check68,99678,97364,63975,63465,56971,07071,32575,56257,91682,31072,49262,610
RECCRecurring (APP) Credit Card27,52232,18225,52029,97925,54928,17728,23529,84222,68233,00228,58924,302
EBCKEbill Check3,1262,9712,9333,1872,9182,8962,9662,8662,5813,1342,9012,705
EBCCEbill Credit Card2,4372,3742,2492,4332,1502,2002,2212,1682,0212,4622,3062,199
SPCKSpeedPay Check805225747838707703774977778892925892
SPCCSpeedpay Credit Card2,5482,5582,3922,4522,3142,1782,6623,4142,5732,9773,2242,924
IVCKIVR Check4,6644,5194,1944,7924,2034,2594,4564,3053,9584,8784,4834,447
IVCCIVR Credit Card5,7535,4455,1086,0015,1005,4085,4835,4124,9236,1935,6815,546
WECKWeb Check17,45816,75616,32318,26515,74315,58717,69117,24115,66618,95517,13517,403
WECCWeb Credit Card15,86115,23814,51716,73414,68014,97616,27515,66514,21117,82216,10616,178
SMSCKSMS Check316768406453412446465419384417406433
SMSCCSMS Credit Card9582113122117125119119111119118126
WUCPCAWestern Union Conveience Pay3,0002,6922,5442,9832,5642,5882,7952,7122,2802,9692,6342,609
WU Total152,581164,783141,685163,873142,026150,613155,467160,702130,084176,130157,000142,374
Credit Card Pmts54,21657,87949,89957,72149,91053,06454,99556,62046,52162,57556,02451,275
In House CC Pmts000000000000
Total Credit Card54,21657,87949,89957,72149,91053,06454,99556,62046,52162,57556,02451,275
Wires665961664369615955656672
ACH Pmts124,521133,339117,214132,951116,609122,443125,802129,387106,289141,765126,592114,672
Total ACH124,587133,398117,275133,017116,652122,512125,863129,446106,344141,830126,658114,744
CP Cash Pmts3,0002,6922,5442,9832,5642,5882,7952,7122,2802,9692,6342,609
In House Cash Pmts000000000000
Total Cash Pmts3,0002,6922,5442,9832,5642,5882,7952,7122,2802,9692,6342,609
Checks (paper cks)27,64927,85224,99529,25824,34525,51126,21226,12222,52228,88125,23322,931
In House Checks46731026180476386657962103
Total Checks27,69527,92525,09729,31924,42525,55826,27526,20822,58728,96025,29523,034
209,498221,894194,815223,040193,551203,722209,928214,986177,732236,334210,611191,662
total on Volume Rpt209,498221,894194,815223,040193,551203,722209,928214,986177,732236,334210,611191,662
check000000000000

Transaction Volume by Payment Processor EFT Volume 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 29156 29127 27972 29782 27057 27482 28125 28017 25006 31179 28250 26182 UMB Lockbox Volume 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 27649 27852 24995 29258 24345 25511 26212 26122 22522 28881 25233 22931 APP Volume 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 0 0 0 0 0 0 0 0 0 0 0 0 ACI & WU Volume 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 152581 164783 141685 163873 142026 150613 155467 160702 130084 176130 157000 142374

ACI Speedpay & Western Union Cash Transactions by Payment Types EBCK Ebill Check 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 3126 2971 2933 3187 2918 2896 2966 2866 2581 3134 2901 2705 EBCC Ebill Credit Card 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 2437 2374 2249 2433 2150 2200 2221 2168 2021 2462 2306 2199 SPCK SpeedPay Check 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 805 225 747 838 707 703 774 977 778 892 925 892 SPCC Speedpay Credit Card 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 2548 2558 2392 2452 2314 2178 2662 3414 2573 2977 3224 2924 IVCK IVR Check 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 4664 4519 4194 4792 4203 4259 4456 4305 3958 4878 4483 4447 IVCC IVR Credit Card 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 5753 5445 5108 6001 5100 5408 5483 5412 4923 6193 5681 5546 WECK Web Check 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 17458 16756 16323 18265 15743 15587 17691 17241 15666 18955 17135 17403 WECC Web Credit Card 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 15861 15238 14517 16734 14680 14976 16275 15665 14211 17822 16106 16178 WUCPCA Western Union Conveience Pay 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 45536 3000 2692 2544 2983 2564 2588 2795 2712 2280 2969 2634 2609 RECK Recurring (APP) Check 1 RECC Recurring (APP) Credit Card 1 SMSCK SMS Check 1 SMSCC SMS Credit Card 1

File details come from the government source that posted it. Updated .