Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Adden 5
CAG-13-042, Adden #5-21 Proforma Account Analysis Page 1 of 8 CITY OF RENTON Consolidated Analysis Summary Lead Account Number XXXXXXXX8326 Earnings Credit Rate 0.25% Negative Collected Rate 7.25% Current Month Multiplier 4,800.00 Settlement Frequency ANNUAL Balance Summary Average Collected Balance = 82,766,362.70 Settlement Analysis Collected Balance Available for Earnings Credit Services = 82,766,362.70 Earnings Credit @ 0.25%17,242.99 Earnings Credit Based Service Charges - 6,527.32 Current Month Surplus/(Deficit) Position = 10,715.67 Net Service Charges $- Collected Unit Total Balance AFP Service Volume Price Price Required Depository Services 010101 Paper Account Analysis Stmt 1 $0.00 -$ 010000 Account Maintenance 6 $2.00 12.00$57,600$ 010101 Paper Credits 98 $0.04 3.92$18,816$ 010101 Electronic Credits 362 $0.02 7.24$34,752$ 010100 Paper Debits 327 $0.04 13.08$62,784$ 010100 Electronic Debits 102 $0.02 2.04$9,792$ 010102 Combined Transactions/Items 5,151 $0.00 -$ 150101 Reject Checks Paid $0.00 150101 For First 50 Per Acct $0.00 150101 For Over 50 Per Acct $0.50 100224 Deposited Item 1,482 $0.02 29.64$142,272$ 100400 Returned Deposited Items 14 $1.00 14.00$67,200$ 100405 Returned Item Special Instruc $0.00 100405 For First 1 1 $5.00 5.00$24,000$ 100405 For Over 1 3 $5.00 15.00$72,000$ 100402 Redeposited Returned Item 1 $0.40 0.40$1,920$ 100403 Returned Item Image Viewed 16 $0.75 12.00$57,600$ 100414 Returned Item Img Advice View 1 $0.50 0.50$2,400$ 000230 Deposit Coverage 82,997 $0.00 -$ 010310 Paper Statement Fee 4 $0.00 -$ 010310 Image Paper DDA Statement 2 $10.00 20.00$96,000$ 150240 Check Filter Monthly Maint 2 $0.00 -$ 010600 Account Inquiry $7.00 151342 Copy of Check/Deposit Ticket $1.00 December 2021 Exhibit B-1 Proforma Account Analysis Page 2 of 8 Collected Unit Total Balance AFP Service Volume Price Price Required 151360 Statement - Number of Items $0.00 151360 For First 100 Per Acct $0.00 151360 For Over 100 Per Acct $0.01 Subtotal Depository Services 134.82$ 647,136$ Account Reconcilement Services 150030 Partial/Positive Pay Maint $0.00 150030 For First 1 Per Acct 3 $ 10.00 30.00$ 144,000$ 150030 Each Additional Reconciliation per Cycle Over 1 Per Acct $ 10.00 -$ 150120 Partial/Positive Pay-per Item 284 $0.02 5.68$ 27,264$ 150120 Full/Positive Pay - per Item $0.02 150030 SP Positive Pay Only Maint 1 $ 10.00 10.00$ 48,000$ 150120 SP Pos Pay Only - per Item 43 $0.01 0.43$ 2,064$ 151352 SP Pos Pay Image Retrieval 2 $0.00 -$ 20020B SP Issue/Cancel Input 31 $0.10 3.10$ 14,880$ 150310 SP Positive Pay Exceptions 1 $1.00 1.00$ 4,800$ 159999 SP Issue Mnt Confirm-per File 12 $1.00 12.00$ 57,600$ 200100 SP ARP Recon Report-per Item 995 $0.02 19.90$ 95,520$ 200306 SP ARP Recon Reports Maint 3 $ 10.00 30.00$ 144,000$ 151200 Recon Printing / Mailing Fee 3 $ 10.00 30.00$ 144,000$ 200306 SP ARP Recon Outstanding Maint 3 $ 10.00 30.00$ 144,000$ 200306 SP ARP Recon Outstanding Item 29,313 $0.03 879.39$ 4,221,072$ 200201 Transmission Input 12 $ 15.00 170.00$ 1 816,000$ 200301 ARP Transmission Output 2 $3.00 6.00$ 28,800$ 200301 ARP Transmission - per Item 351 $0.01 3.51$ 16,848$ 100600 Deposit Recap Maintenance 1 $0.00 -$ 151022 Payee Positive Pay-per Item $0.02 150122 SP Payee Pos Pay Exceptions $1.00 SUBD9999 Subtotal Account Reconcilement Services 1,231.01$ 5,908,848$ E-PAYMENT/EBILL SERVICES 310000 EPay Monthly Maint-Web-No Load $0.00 310000 For First 1 1 $ 150.00 150.00$ 720,000$ 310000 For Over 1 3 $ 40.00 120.00$ 576,000$ 310000 EPay Monthly Maint-IVR+Web $0.00 310000 For First 1 1 $ 300.00 300.00$ 1,440,000$ 310000 For Over 1 $ 200.00 -$ 310420 EPay Web+admin Pymt-Non-Recur $0.00 310420 If 1 - 1000 103 $0.35 36.05$ 173,040$ 310420 If 1001 - 10000 $0.25 -$ 310420 If 10001 - 50000 $0.30 -$ 310420 If 50001 - 100000 $0.20 -$ 310420 If 100001 - 250000 $0.20 -$ 310420 If Over 250000 $0.20 -$ 310420 EPay IVR Initiated Payments $0.00 310420 If 1 - 1000 $0.35 -$ 310420 If 1001 - 10000 1,421 $0.25 355.25$ 1,705,200$ December 2021 Proforma Account Analysis Page 3 of 8 Collected Unit Total Balance AFP Service Volume Price Price Required 310420 If 10001 - 50000 $0.30 -$ 310420 If 50001 - 100000 $0.20 -$ 310420 If 100001 - 250000 $0.20 -$ 310420 If Over 250000 $0.20 -$ 310420 EPay IVR Minutes 6,008 $0.10 600.80$ 2,883,840$ 310000 EPay Web Test Monthly Maint $ 37.50 300029 EPay Custom Rept Monthly Fee 3 $ 56.25 168.75$ 810,000$ 300519 EPay Custom Rept per Payment 1,617 $ 0.065 105.11$ 504,504$ 310501 EPay Custom Rept Transmission 37 $3.75 138.75$ 666,000$ Subtotal E-PAYMENT/EBILL SERVICES 1,974.71$ 9,478,584$ SinglePoint 400272 Sp Current Day Per Acct $0.00 400272 For First 1 1 $ 10.00 10.00$ 48,000$ 400272 For Over 1 4 $ 10.00 40.00$ 192,000$ 400272 Sp Current Day Per Item 1,796 $0.01 17.96$ 86,208$ 400273 SPE Current Day per Item Sum $0.01 400272 Sp Previous Day Per Acct $0.00 400272 For First 1 1 $5.00 5.00$ 24,000$ 400272 For Over 1 4 $5.00 20.00$ 96,000$ 400272 Sp Previous Day Per Item 2,538 $0.01 25.38$ 121,824$ 409999 Monthly DDA Statement PDF 7 $1.00 7.00$ 33,600$ 250720 ACH Return and NOC Report 2 $0.00 -$ 250720 ACH Return and NOC Report $0.00 250720 For First 1 1 $5.00 5.00$ 24,000$ 250720 For Over 1 1 $2.00 2.00$ 9,600$ 401020 SP Token Monthly Maintenance 23 $1.50 34.50$ 165,600$ 400810 SP User Add/Modify/Delete $3.50 400810 SP Account Add/Modify/Delete $3.50 409999 SP Book Transfer Mo Maint $0.00 409999 For First 1 1 $0.00 -$ 409999 For Over 1 5 $0.00 -$ 150410 SP Stop Payments Mo Maint $0.00 150410 For First 1 1 $3.75 3.75$ 18,000$ 150410 For Over 1 4 $3.75 15.00$ 72,000$ 150410 SP Stop Payments-per Stop $0.00 150410 For First 10 Per Acct 3 $3.00 9.00$ 43,200$ 150410 For Over 10 Per Acct $3.00 -$ 350000 SP Wires Monthly Maintenance $0.00 350000 For First 1 1 $5.00 5.00$ 24,000$ 350000 For Over 1 $0.00 -$ 150030 SP Positive Pay Monthly Maint 4 $0.00 -$ 200201 SP Issue Maint Mo Maintenance $0.00 200201 For First 1 1 $1.50 1.50$ 7,200$ 200201 For Over 1 3 $0.00 -$ 151350 SP Image Access Mo Maint 5 $5.00 25.00$ 120,000$ 409999 Invest Reporting Mo Maint $3.75 409999 SPE Ext Messaging Mo Maint $0.00 December 2021 Proforma Account Analysis Page 4 of 8 Collected Unit Total Balance AFP Service Volume Price Price Required 409999 For First 1 $0.00 409999 For Over 1 $0.00 409999 SP External Message Mo Maint $0.00 409999 For First 1 1 $ 10.00 10.00$ 48,000$ 409999 For Over 1 12 $0.00 -$ 409999 SP External User Message Sent 108 $0.00 -$ 409999 SP External User Task Sent 18 $0.00 -$ Account Analysis Report PDF 1 $5.00 5.00$ 24,000$ Subtotal SinglePoint 241.09$ 1,157,232$ Wire Transfers 350000 Wire Monthly Maint Voice-Pin 1 $0.00 -$ 350300 Incoming Fedwire 1 $6.00 6.00$ 28,800$ 350123 Internal Wire Credit $2.00 350202 Voice Fedwire Non-Repetitive $6.00 35020Z Federal Tax Payment $1.00 350300 Incoming Fedwire Ctp 3 $6.00 18.00$ 86,400$ 350100 SP Fedwire Repetitive 4 $6.00 24.00$ 115,200$ 350104 SP Fedwire Non-Repetitive $6.00 350120 SP Internal $2.00 350412 Wire Advice Mail $0.75 Subtotal Wire Transfers 48.00$ 230,400$ Zero Balance Accounts 010020 ZBA Lead 1 $4.00 4.00$ 19,200$ 010021 ZBA Subsidiary 4 $3.00 12.00$ 57,600$ Subtotal Zero Balance Accounts 16.00$ 76,800$ Image Services 151351 SP Cks Pd per item Stored 0 $0.00 -$ 151351 Dep Itms Img per Item Stored 0 $0.00 -$ 151350 Image Archive Monthly Maint $7.00 151351 Image Archive per Check Image $0.01 151353 Image Archive - per CD-ROM 1 $5.00 5.00$ 24,000$ 151353 Duplicate CD-ROM $5.00 151352 SP Short Term Imgs Retrieved 13 $0.20 2.60$ 12,480$ Subtotal Image Services 7.60$ 36,480$ Lockbox 050000 WLBX Monthly Maint-Seattle $0.00 050000 For First 1 1 $ 80.00 80.00$ 384,000$ 050000 For Over 1 $ 120.00 -$ 050300 WLBX Deposit-Seattle 28 $0.15 4.20$ 20,160$ 050122 WLBX OCR Item-Seattle 2,374 $0.20 474.80$ 2,279,040$ 050500 WLBX Except/Return-Seattle 384 $0.14 53.76$ 258,048$ December 2021 Proforma Account Analysis Page 5 of 8 Collected Unit Total Balance AFP Service Volume Price Price Required 050126 WLBX Data Keystroke-Seattle 499 $0.01 4.99$ 23,952$ 050103 WLBX Multi Payment-Seattle 181 $0.12 21.72$ 104,256$ 05011I WLBX Manual Mail - Seattle $2.00 050401 WLBX Transmission-Seattle $0.00 050401 For First 1 Per Acct 1 $ 185.00 185.00$ 888,000$ 050401 For Over 1 Per Acct $0.00 -$ 05011R WLBX Image Check/Coupon-Seattl 5,338 $0.01 53.38$ 256,224$ 05011R WLBX Image Document-Seattle $0.05 05011R WLBX Image Monthly-Seattle 1 $ 60.00 60.00$ 288,000$ 05011R WLBX Image CD/DVD Charge-Sea $ 15.00 05011L WLBX Package Prep-Seattle $1.00 05021Q WLBX Web Decisioning Maint-Sea $ 70.00 05021Q WLBX Web Decisioning Item-Sea $0.30 100214 Lockbox Deposited Item 2,374 $0.03 71.22$ 341,856$ WLBX Courier-Seattle 384 $1.00 384.00$ 1,843,200$ Subtotal Lockbox 1,393.07$ 6,686,736$ ACH Services 250000 ACH Monthly Maintenance 1 $5.00 5.00$ 24,000$ 250501 ACH Process Run 18 $3.00 54.00$ 259,200$ 250102 ACH Orig Transit Item $0.00 250102 If 1 - 10000 Per Acct 2,682 $0.02 53.64$ 257,472$ 250102 If Over 10000 Per Acct $0.02 -$ 250102 Same Day ACH Orig Transit Item $0.50 250102 ACH Originated On-US Item $0.00 250102 If 1 - 10000 Per Acct 448 $0.02 8.96$ 43,008$ 250102 If Over 10000 Per Acct $0.02 -$ 250202 ACH Received Item 406 $0.03 12.18$ 1 58,464$ 250220 ACH Received Addenda Item 8 $0.03 0.24$ 1,152$ 250102 E-Pay/eBill ACH Fed Item $0.00 250102 If 1 - 10000 216 $0.10 21.60$ 103,680$ 250102 If Over 10000 $0.10 -$ 250102 E-Pay/eBill Service On-Us Item $0.00 250102 If 1 - 10000 30 $0.02 0.60$ 2,880$ 250102 If Over 10000 $0.02 -$ 250302 E-Pay/eBill Service ACH Return $1.00 251070 E-Pay/eBill Service NOC Item $3.50 251050 ACH Block Mthly Maint-per Acct. 3 $5.00 15.00$ 72,000$ 251050 ACH Filter Mthly Maint 3 $5.00 15.00$ 72,000$ 250300 Unauth ACH Return - per Item $7.00 250302 ACH Return-per Item 5 $1.00 5.00$ 24,000$ 251070 ACH Notification of Change 7 $ 2.0625 14.44$ 69,300$ 250401 ACH Return/NOC Faxed 8 $3.00 24.00$ 115,200$ 250670 ACH Return/NOC Transmit Items $1.00 250640 ACH Item Adjustment Request $3.00 250641 ACH Batch Adjustment Request $3.00 259999 SDA Special Processing $ 175.00 250102 SP ACH On-US Item $0.11 December 2021 Proforma Account Analysis Page 6 of 8 Collected Unit Total Balance AFP Service Volume Price Price Required Subtotal ACH Services 229.66$ 1,102,356$ Branch Coin/Currency Services 10001Z Cash Deposited-per $100 $0.06 100000 Branch Deposit Processing Fee $1.25 109999 Night Dep Processing-per Dep $0.75 10004A Currency Ordered-per Strap $0.20 100048 Loose Currency Ordered/$100 $0.06 100044 Coin Rolls Ordered-per Roll $0.06 100046 Coin Rolls Ordered-per Box $0.06 100040 Standard Chng Order-per Order $2.50 150501 Non Customer On US Ck Cashing $0.00 Subtotal Branch Coin/Currency Services -$ CVS Coin/Currency 100114 Cash Dep-per $100 369 $0.04 14.76$ 70,848$ 100100 Cash Vault Deposit 70 $0.04 2.80$ 13,440$ 100111 Loose Coin Deposit 1 $3.00 3.00$ 14,400$ 100501 Cash Dep Adjustment $2.00 109999 Mailed Receipts $0.00 Subtotal CVS Coin/Currency 20.56$ 98,688$ VantagePoint 40005Z VP Monthly Maint - per Acct $0.00 40005Z For First 1 1 $0.00 -$ 40005Z For Over 1 $0.00 -$ 410000 Data Normalization - per Item 3,212 $0.00 -$ Subtotal VantagePoint -$ Electronic Deposit Services 101300 EDM Monthly Maint - per Acct $0.00 101300 For First 1 $ 40.00 101300 For Over 1 $ 10.00 101300 Web Monthly Maint - per Wrkstn $0.00 101300 If 1 - 10 $ 20.00 101300 If 11 - 50 $ 35.00 101300 If Over 50 $ 30.00 109999 Deposit Credit $0.70 101311 Image Check Item - On-Us $0.09 101310 Image Check Item - Transit $0.09 151352 Image Retrieval - per Item $0.09 101311 Image Cash Letter Item - On-Us 5 $0.06 0.30$ 1,440$ 101310 Image Cash Letter Item-Transit 101310 If 1 - 10000 Per Acct 53 $0.10 5.30$ 25,440$ 101310 If 10001 - 25000 Per Acct $0.10 -$ December 2021 Proforma Account Analysis Page 7 of 8 Collected Unit Total Balance AFP Service Volume Price Price Required 101310 If 25001 - 100000 Per Acct $0.09 -$ 101310 If Over 100000 Per Acct $0.07 -$ 010101 Image Cash Letter Deposit Fee 14 $1.50 21.00$ 100,800$ 101324 Image Cash Letter Transmission $0.00 101324 For First 1 1 $ 175.00 175.00$ 840,000$ 101324 For Over 1 $0.00 -$ 101300 ICL Monthly Maintenance $0.00 101300 For First 1 1 $ 200.00 200.00$ 960,000$ 101300 For Over 1 $ 40.00 -$ Subtotal Electronic Deposit 401.60$ 1,927,680$ E-Lockbox 310104 E-LOCKBOX Maintenance $0.00 310104 For First 1 1 $ 75.00 75.00$ 360,000$ 310104 For Over 1 $ 50.00 -$ 250202 ELBX Electronic Pymt RB Item $0.00 250202 If 1 - 4999 Per Acct 3,212 $0.15 481.80$ 2,312,640$ 250202 If 5000 - 9999 Per Acct $0.11 -$ 250202 If 10000 - 24999 Per Acct $0.10 -$ 250202 If 25000 - 49999 Per Acct $0.08 -$ 250202 If 50000 - 99999 Per Acct $0.06 -$ 250202 If Over 99999 Per Acct $0.04 -$ 310113 ELBX Data Trans Out /billerID 22 $5.00 110.00$ 528,000$ 310112 E-LOCKBOX Transl Payment 3,609 $ 0.045 162.41$ 779,544$ Subtotal E-Lockbox 829.21$ 3,980,184$ International Banking 100310 Un-Encode CAD/USD Item $1.00 Subtotal International Banking -$ Total Service Charges 6,527.32$ 31,331,124$ One Time and Annual Charges 251055 ACH Filter/Block Setup $0.00 101333 Digital Check CX30 Scanner $0.00 101330 Web Client Setup and Training $0.00 101333 Digital Chk TS240 x100 Scanner $0.00 101333 Digital Check TS240 Warranty $0.00 Total One Time and Annual Service Charges -$ Prices quoted in this proposal are only for those Treasury Management Services requested by the customer. Additional Treasury Management Services will be separately priced at the time of customer's request. Prices quoted are valid for 60 days following customer's receipt, after which they will be December 2021 Proforma Account Analysis Page 8 of 8 Collected Unit Total Balance AFP Service Volume Price Price Required subject to change by U.S. Bank. All prices are subject to change, at any time and at Bank's sole discretion, due to changes in business conditions, volumes, quality of work provided by the customer and normal pricing change cycles. Notwithstanding anything contained herein to the contrary, all Treasury Management Services provided to customer are subject to U.S. Bank's Services Terms and Conditions, as the same may be amended from time to time. Branch Cash services availability is subject to change based on client processing requirements and branch capacity. Pricing for Branch Cash Services is subject to change when non-standard processing is requested. December 2021