August 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 transactions and processing metrics for August 2024. The report comprehensively tracks transaction volumes across multiple payment channels including recurring (APP), web, IVR, SMS, call center, bill pay providers, convenience pay, lockbox, and wire transfers. Total monthly transactions reached 210,611, with a total dollar volume of $34,972,150.64, demonstrating a diverse range of payment methods including ACH, credit cards, checks, and cash payments.

The report provides granular insights into payment processing, including return rates, refund rates, and transaction breakdowns by payment type and channel. Key metrics include 95,164 Automatic Payment Plan (APP) customers, 103,824 e-bill customers, and 48% e-bill penetration of the 200,000 customer base. Credit card transactions represented 26% of total payments, with ACH payments comprising 60% of transaction volume. The data suggests a robust electronic payment ecosystem with multiple integrated payment processors, including ACI Speedpay, Western Union Convenience Pay, UMB Lockbox, and various electronic fund transfer (EFT) channels, indicating a sophisticated and diversified payment infrastructure for Denver Water.

View the file

Other files

File Type Posted
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 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 1.docx DOCX document
506333 Exhibits CDEF v.2 (Addendum #2).xlsx XLSX spreadsheet
506333 Exhibits CDEF v.3 (Addendum #3).xlsx XLSX spreadsheet
September 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 Pmts620%$ 1,513,293.842%
In-House Deposit-Cash Pmts00$ - 00
eLockbox16,0728$ 3,326,058.794
EFTDBO (Fiserv)12,1786$ 1,908,803.782
Western Union Convenience Pay WUCPCA2,6341$ 311,798.860
ACI Speedpay E-Bill Credit Card EBCC2,3061$ 510,277.521
ACI Speedpay E-Bill ACH EBCK2,9011$ 899,614.481
ACI IVR Credit Card IVCC5,6813$ 925,908.251
ACI IVR ACH IVCK4,4832$ 657,177.341
ACI Speedpay Credit Card SPCC3,2242$ 839,486.961
ACI Speedpay ACH SPCK9250$ 269,998.230
ACI Web Credit Card WECC16,1068$ 3,393,163.824
ACI Web ACH WECK17,1358$ 6,158,809.527
ACI SMS Credit Card SMSCC1180$ 142,580.760
ACI SMS Check SMSCK4060$ 58,771.540
ACI Recurring Credit Card RECC28,58914$ 3,739,881.755
ACI Recurring ACH RECK72,49234$ 15,254,767.9219
UMB Lockbox25,23312$ 30,266,733.0337
Wires In660$ 11,979,480.3015
LIHWAP Payments00$ - 00
Total210,611100%$ 82,156,606.69100%
Rebate Credits (posted to CC&B Accounts)NumberPercent$ AmountPercent
Residential Rebates9599%0$ 8,196.0699%
Commerical Rebates11100.001
Total96100%$ 8,296.06100%
Handling VolumeNumberPercent$ AmountPercent
A.Return Items
WWF00%$ - 00%
eLockbox00- 00
EFTDBO (Checkfree)20491.730
Western Union Convenience Pay WUCPCA00- 00
ACI82894242,603.6994
Credit Card Chargebacks2534,301.722
UMB Lockbox28310,449.984
Total883100%$ 257,847.12100%
B.Refund ItemsNumberPercent$ AmountPercent
Fiserv (Checkfree)715%$ 440.252%
E-Lockbox234921,110.6973
Western Union Convenience Pay WUCPCA12119.900
Credit Cards16347,255.2025
LIHWAP Refunds00- 00
Total47100%$ 28,926.04100%
C.In-house additional handlingNumberPercent
Posted Suspense Items48296%N/A
Transaction Repair122
Returned ACH Transaction Repair82N/A
NOC00N/A
502100%$ - 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 end102,982
Current month end103,629
B.E-Bills deliveredNumberPercent
(Includes Duplicate & Third Party Bills)
Last month100,710**
This month101,635****Prior reports included courtesy bills and non bill related emails.
NumberPercent
C.E-Bill Customers (percentage based on 244,000 customer base)102,14751%
E-Bill Customers who pay via APP103,82499%

D. Total Speedpay/ACI credit card sales $ 9,551,299.06

&"-,Bold"Monthly Volume Report August 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 Sep-23 Oct-23 Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 TTM %

RECURRING (APP)89,73096,518111,15590,159105,61391,11899,24799,560105,40480,598115,312101,0811,185,49548%
IVR9,33410,4179,9649,30210,7939,3039,6679,9399,7178,88111,07110,164118,5525%
One Click5,3655,5635,3455,1825,6205,0685,0965,1875,0344,6025,5965,20762,8653%
WEB30,24933,31931,99430,84034,99930,42330,56333,96632,90629,87736,77733,241389,15416%
SMS5864118505195755295715845384955365246,7180%
Call Center3,1083,3532,7833,1393,2903,0212,8813,4364,3913,3513,8694,14940,7712%
Bill Pay Provider27,81629,15629,12727,97229,78227,05727,48228,12528,01725,00631,17928,250338,96914%
Convenience Pay2,6663,0002,6922,5442,9832,5642,5882,7952,7122,2802,9692,63432,4271%
Lockbox27,20227,64927,85224,99529,25824,34525,51126,21226,12222,52228,88125,233315,78213%
Wires265666596166436961595565663,3260%
2,494,059100%
Transactions by Payment TypeSep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24TTM%
Paper Checks27,24527,69527,92525,09729,31924,42525,55826,27526,20822,58728,96025,295316,58913%13%Paper Check
Cash2,6663,0002,6922,5442,9832,5642,5882,7952,7122,2802,9692,63432,4271%1%Cash
ACH116,355124,521133,339117,214132,951116,609122,443125,802129,387106,289141,765126,5921,493,26760%
Credit Card49,83354,21657,87949,89957,72149,91053,06454,99556,62046,52162,57556,024649,25726%86%Electronic
Wires2,65666596166436961595565663,3260%
Total Payments198,755209,498221,894194,815223,040193,551203,722209,928214,986177,732236,334210,6112,494,866100%

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

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

DBOEFT & EFTDBO Volume27,48228,12528,01725,00631,17928,250
DBOEFT & EFTDBO Returns646652
Return Rate0.022%0.014%0.021%0.024%0.016%0.007%
ACI ACH Volume94,96197,677101,37076,121110,58698,342
ACI ACH Returns630691734675766828
Return Rate0.663%0.707%0.724%0.887%0.693%0.842%
APP Volume000000*
APP Returns000000
Return Rate0.000%0.000%0.000%0.000%0.000%0.000%
UMB Lockbox Volume25,51126,21226,12222,52228,88125,233
UMB Lockbox Returns211527223628
Return Rate0.082%0.057%0.103%0.098%0.125%0.111%
WU Convenience Pay Volume2,5882,7952,7122,2802,9692,634
WU Convenience Pay Returns000001
Return Rate0.000%0.000%0.000%0.000%0.000%0.038%
ACI Credit Card Volume50,86454,99556,62046,52162,57556,024
ACI Credit Card Chargebacks2553725
Return Rate0.004%0.009%0.009%0.006%0.011%0.045%
ACI Credit Card Volume000000
ACI Credit Card Refunds000000
Return Rate0.000%0.000%0.000%0.000%0.000%0.000%
WWF Volume476386657979
WWF Returns024000
Return Rate0.000%3.175%4.651%0.000%0.000%0.000%
Total Volume201,453209,867214,927172,515236,269210,562
Total Return659717776706814884
Overall Rate0.33%0.34%0.36%0.41%0.34%0.42%

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

Return Rates
Mar-24Apr-24May-24Jun-24Jul-24Aug-24
DBOEFT0.022%0.014%0.021%0.024%0.016%0.007%
ACI0.663%0.707%0.724%0.887%0.693%0.842%
Lockbox0.082%0.057%0.103%0.098%0.125%0.111%
WU Conv Pay0.000%0.000%0.000%0.000%0.000%0.038%
WWF0.000%3.175%4.651%0.000%0.000%0.000%
ACI CC Chargebacks0.004%0.009%0.009%0.600%0.011%0.045%
ACI CC Refunds0.000%0.000%0.000%0.000%0.000%0.000%
Total Returns0.330%0.340%0.360%0.410%0.340%0.420%
Jan-16Feb-16Mar-16Apr-16May-16Jun-16
Total Recurring/APP Customers491854997050355503555064251152
ACH446764485144794447944466544769
ATM213251272272273297
CREDIT CARD429648685289528957046089
Refunds
Mar-24Apr-24May-24Jun-24Jul-24Aug-24
eLockbox0.013%0.006%0.044%0.113%0.102%0.143%
Checkfree0.017%0.000%0.050%0.028%0.007%0.057%
ACI Credit Card0.022%0.004%0.011%0.018%0.013%0.030%
Western Union Con Pay0.000%0.000%0.000%0.000%0.000%0.000%
Total Refund0.000%0.001%0.002%0.002%0.002%0.002%

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

DBOEFT (eLockbox) Volume15,58515,99416,01314,13417,71916,072
DBOEFT (eLockbox) Refunds217161823
Refund Rate0.013%0.006%0.044%0.113%0.102%0.143%
EFTDBO (Checkfree) Volume11,89712,13112,00410,87213,46012,178
EFTDBO (Checkfree) Refunds206317
Refund Rate0.017%0.000%0.050%0.028%0.007%0.057%
ACI Credit Card Volume50,86454,99556,62076,12162,57556,024
ACI Credit Card Refunds112614817
Refund Rate0.022%0.004%0.011%0.018%0.013%0.030%
WU Convenience Pay Volume2,5882,7952,7122,2802,9692,634
WU Convenience Pay Returns000000
Return Rate0.000%0.000%0.000%0.000%0.000%0.000%
Total Volume80,93485,91587,349103,40796,72386,908
Total Refunds15319332747
Overall Rate0.00%0.00%0.00%0.00%0.00%0.00%

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

Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24
Total Lockbox Volume27,20227,64927,85224,95929,25824,34525,51126,21226,21222,52228,88125,233
Errors011110110121
Error Rate0.000%0.004%0.004%0.004%0.003%0.000%0.004%0.004%0.000%0.004%0.007%0.004%
Additional Information
Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24
Posted Suspense782729795795750685682566573470616482
Transfers1412112351353
Transaction Repair00011767911710612
Transaction Repair Returns00002171158528
Rebates-Residential63540282523326415514713395
Rebates-Commercial010101020001
Suspense Total $77770026968001560000
0-5 days %000010097000000
6-30 days %00000301000000
31-60 days %000000000000
61 days and older1001000000000000
Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24
E-Bill99,07699,702100,392100,392100,057101,839102,136102,624102,987103,292103,406103,824
E-Bill Customer who pay via AutoPay97,43497,90198,61898,61899,641100,49799,62299,49299,73399,942101,294102,147

Lockbox Error Rate Error Rate 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 0 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 Number of APP & E-Bill Customer at Month End E-Bill 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 99076 99702 100392 100392 100057 101839 102136 102624 102987 103292 103406 103824 E-Bill Customer who pay via AutoPay 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 97434 97901 98618 98618 99641 100497 99622 99492 99733 99942 101294 102147

APP Snapshot

Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24
Total Recurring/APP Customers98,84499,352100,359100,756101,226101,712102,035102,557102,565103,233102,982103,629
ACH69,85170,25870,92871,34271,86772,10772,35372,69572,74173,15273,20873,649
ATM209207192188180175165162154149143141
CREDIT CARD28,78428,88729,23929,22629,17929,43029,51729,70029,67029,93229,63129,839

Recurring APP Transactions by Types

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

Recurring APP Snapshot Sept 2015

ACH ATM CREDIT CARD 73649 141 29839

Recurring APP Snapshot Aug 2024

ACH ATM CREDIT CARD 73649 141 29839

Wtr Sales CC Water Sales Credit Card Transactions & Fees

WSLS (Master Card)WSLV (VISA)
Transaction CountTotal DollarsTotal FeesTransaction CountTotal DollarsTotal Fees
Jul-231390,647.472,039.573382,886.7701,864.96
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

Total 127 1,087,634.01 10,852.57 566 2,442,183.50 33,162.62

Grand Total

Transaction Count Total Dollars Total Fees

Jul-2346173,534.243,904.53
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

YTD Total 693 3,529,817.51 44,015.19 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

Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24
EFT Volume27,81629,15629,12727,97229,78227,05727,48228,12528,01725,00631,17928,250
UMB Lockbox Volume27,20227,64927,85224,99529,25824,34525,51126,21226,12222,52228,88125,233
APP Volume000000000000
ACI & WU Volume141,038152,581164,783141,685163,873142,026150,613155,467160,702130,084176,130157,000
Sep-23Oct-23Nov-23Dec-23Jan-24Feb-24Mar-24Apr-24May-24Jun-24Jul-24Aug-24
RECKRecurring (APP) Check64,24168,99678,97364,63975,63465,56971,07071,32575,56257,91682,31072,492
RECCRecurring (APP) Credit Card25,48927,52232,18225,52029,97925,54928,17728,23529,84222,68233,00228,589
EBCKEbill Check2,9523,1262,9712,9333,1872,9182,8962,9662,8662,5813,1342,901
EBCCEbill Credit Card2,4132,4372,3742,2492,4332,1502,2002,2212,1682,0212,4622,306
SPCKSpeedPay Check729805225747838707703774977778892925
SPCCSpeedpay Credit Card2,3792,5482,5582,3922,4522,3142,1782,6623,4142,5732,9773,224
IVCKIVR Check4,2314,6644,5194,1944,7924,2034,2594,4564,3053,9584,8784,483
IVCCIVR Credit Card5,1035,7535,4455,1086,0015,1005,4085,4835,4124,9236,1935,681
WECKWeb Check15,94717,45816,75616,32318,26515,74315,58717,69117,24115,66618,95517,135
WECCWeb Credit Card14,30215,86115,23814,51716,73414,68014,97616,27515,66514,21117,82216,106
SMSCKSMS Check439316768406453412446465419384417406
SMSCCSMS Credit Card1479582113122117125119119111119118
WUCPCAWestern Union Conveience Pay2,6663,0002,6922,5442,9832,5642,5882,7952,7122,2802,9692,634
WU Total141,038152,581164,783141,685163,873142,026150,613155,467160,702130,084176,130157,000
Credit Card Pmts49,83354,21657,87949,89957,72149,91053,06454,99556,62046,52162,57556,024
In House CC Pmts000000000000
Total Credit Card49,83354,21657,87949,89957,72149,91053,06454,99556,62046,52162,57556,024
Wires26566659616643696159556566
ACH Pmts116,355124,521133,339117,214132,951116,609122,443125,802129,387106,289141,765126,592
Total ACH119,011124,587133,398117,275133,017116,652122,512125,863129,446106,344141,830126,658
CP Cash Pmts2,6663,0002,6922,5442,9832,5642,5882,7952,7122,2802,9692,634
In House Cash Pmts000000000000
Total Cash Pmts2,6663,0002,6922,5442,9832,5642,5882,7952,7122,2802,9692,634
Checks (paper cks)27,20227,64927,85224,99529,25824,34525,51126,21226,12222,52228,88125,233
In House Checks4346731026180476386657962
Total Checks27,24527,69527,92525,09729,31924,42525,55826,27526,20822,58728,96025,295
198,755209,498221,894194,815223,040193,551203,722209,928214,986177,732236,334210,611
total on Volume Rpt198,755209,498221,894194,815223,040193,551203,722209,928214,986177,732236,334210,611
check000000000000

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

ACI Speedpay & Western Union Cash Transactions by Payment Types EBCK Ebill Check 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 2952 3126 2971 2933 3187 2918 2896 2966 2866 2581 3134 2901 EBCC Ebill Credit Card 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 2413 2437 2374 2249 2433 2150 2200 2221 2168 2021 2462 2306 SPCK SpeedPay Check 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 729 805 225 747 838 707 703 774 977 778 892 925 SPCC Speedpay Credit Card 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 2379 2548 2558 2392 2452 2314 2178 2662 3414 2573 2977 3224 IVCK IVR Check 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 4231 4664 4519 4194 4792 4203 4259 4456 4305 3958 4878 4483 IVCC IVR Credit Card 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 5103 5753 5445 5108 6001 5100 5408 5483 5412 4923 6193 5681 WECK Web Check 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 15947 17458 16756 16323 18265 15743 15587 17691 17241 15666 18955 17135 WECC Web Credit Card 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 14302 15861 15238 14517 16734 14680 14976 16275 15665 14211 17822 16106 WUCPCA Western Union Conveience Pay 45170 45200 45231 45261 45292 45323 45352 45383 45413 45444 45474 45505 2666 3000 2692 2544 2983 2564 2588 2795 2712 2280 2969 2634 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 .