Attachment A - Fees Proposal.xlsx
XLSX spreadsheet 20 KB Posted
- Attached to
- Depository Banking Services
- Solicitation number
- 2022-23-24
- Issued by
- Texas
About this file
The document is an Attachment A - Fees Proposal for Depository Banking Services for the City of Weslaco, Texas, detailing monthly banking transaction volumes and associated fees. The contract opportunity seeks a financial institution to provide comprehensive banking services within the city limits of Weslaco or within five miles of its boundaries. The proposed banking services include demand deposit services, remote deposit services, and branch services, with specific transaction types tracked such as regular deposit tickets, deposit items (on-us and transit), paid items, hybrid checking maintenance, returns, and reclears.
The fee proposal spreadsheet indicates average monthly transaction volumes across various banking service categories, with detailed tracking from June 2022 through May 2023. The monthly transaction volumes range from approximately 7,649,922 to 19,631,660 in total banking activity balance. Key service metrics include an average of 153 regular deposit tickets, 253 on-us deposit items, 1,600 transit deposited items, 412 paid items, and minimal returns and reclears per month. The proposal suggests a comprehensive, granular approach to tracking banking service utilization, which would allow the City of Weslaco to closely monitor and potentially optimize its banking service costs and efficiency.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Elavon June 2023.pdf | ||
| 2022-23-24 RFP Banking FINAL.pdf | ||
| Q&A Document 1.pdf | ||
| Elavon May 2023.pdf | ||
| INVESTMENT POLICY.pdf | ||
| MAY23 Analysis Statement.pdf | ||
| ADDENDUM #2.pdf | ||
| APR23 Analysis Statement.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| ATTACHMENT A - PROPOSED FEES | |
| All fees required to provide the services requested must | |
| CITY OF WESLACO, TEXAS | be on this attachment. Add any service units as needed. |
| Hidden columns show monthly volumes. |
| AVG VOLUME | PROPOSED | EXTENDED | |||||||||||||||
| Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 | Jan-23 | Feb-23 | Mar-23 | Apr-23 | May-23 | PER MO. | FEE | COST | NOTES, IF APPLICABLE | ||
| AFP CODE | DESCRIPTION | ||||||||||||||||
| BALANCE | 10,181,976 | 10,779,576 | 11,366,194 | 9,961,271 | 13,600,505 | 9,627,720 | 7,649,922 | 11,982,001 | 13,827,992 | 19,631,660 | 14,803,280 | 12,366,913 | 12,148,251 |
| DEMAND DEPOSIT SERVICES | ||||||||||||||
| 100200 | REGULAR DEPOSIT TICKET | 157 | 141 | 169 | 158 | 153 | 143 | 155 | 152 | 144 | 161 | 134 | 164 | 153 |
| 100220 | DEPOSIT ITEMS ON-US | 293 | 265 | 262 | 278 | 227 | 254 | 267 | 216 | 243 | 274 | 197 | 265 | 253 |
| 100200 | DEPOSITED ITEMS - TRANSIT | 1,771 | 1,623 | 1,606 | 1,648 | 1,390 | 1,653 | 1,622 | 1,502 | 1,596 | 1,754 | 1,290 | 1,744 | 1,600 |
| 150100 | PAID ITEMS | 397 | 395 | 518 | 438 | 371 | 395 | 351 | 430 | 360 | 478 | 408 | 398 | 412 |
| 010000 | HYBRID CHECKING MAINT. | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 8 | 7 | 7 | 7 |
| 100400 | RETURNS | 5 | 10 | 2 | 3 | 3 | 4 | 3 | 1 | 4 | 2 | 1 | 2 | 3 |
| 100402 | RECLEARS | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
| REMOTE DEPOSIT SERVICES | ||||||||||||||
| 109999 | DEPOSIT ON-SITE MONTHLY FEE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| OVERDRAFT HANDLING FEE | ||||||||||||||
| 150340 | OVERDRAFT HANDLIG | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| BRANCH SERVICES | ||||||||||||||
| 100048 | CURRENCY FURNISHED ($10 UNITS<$50K) | 121 | 310 | 60 | 90 | 105 | 155 | 0 | 45 | 176 | 85 | 97 | 80 | 110 |
| 100044 | COIN FURNISHED - ROLLS | 38 | 60 | 10 | 20 | 13 | 13 | 0 | 24 | 20 | 17 | 11 | 13 | 20 |
| 100000 | OTC DEPOSIT TICKETS | 157 | 141 | 169 | 154 | 153 | 143 | 155 | 152 | 144 | 161 | 133 | 164 | 152 |
| 100005 | NIGHT DROP BAG DEPOSIT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| 100015 | CASH VERIFICATION OTC - 10.00 UNITS | 19,827 | 18,551 | 18,807 | 17,500 | 17,057 | 16,145 | 17,860 | 17,477 | 17,815 | 20,661 | 1,500 | 17,653 | 16,738 |
| 100015 | CASH VERIFICATION NIGHT DROP - 10.00 | 0 | 0 | 0 | 69 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 6 |
| ACCOUNT RECONCILIATION SERVICES | ||||||||||||||
| 200010 | FULL RECON MONTHLY MAINT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 200110 | FUlL RECONCILEMENT ITEM | 389 | 388 | 513 | 428 | 364 | 388 | 344 | 423 | 355 | 474 | 403 | 392 | 405 |
| 209999 | REJECTED INPUT FILE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 200000 | TELLER POSITIVE PAY MAINT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 999999 | POSITIVE PAY MONTHLY MAINT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 999999 | ONLINE POS PAY EXCEPTIONS LOADED | 0 | 0 | 4 | 0 | 12 | 2 | 0 | 4 | 2 | 1 | 0 | 0 | 2 |
| 999999 | ONLINE ISSUE FILE IMPORT | 3 | 6 | 8 | 2 | 3 | 5 | 3 | 3 | 3 | 2 | 4 | 2 | 4 |
| 209999 | ONLINE PER STOP INDIVIDUAL ENTRY | 0 | 39 | 6 | 5 | 3 | 7 | 6 | 8 | 4 | 7 | 4 | 5 | 8 |
| 999999 | ONLINE CHECK INQUIRY | 0 | 56 | 4 | 14 | 7 | 4 | 0 | 3 | 5 | 2 | 1 | 3 | 8 |
| 999999 | ONLINE ISSUE ADD/CANCEL | 32 | 22 | 16 | 16 | 37 | 42 | 24 | 28 | 43 | 26 | 23 | 77 | 32 |
| 999999 | ONLINE ISSUE FILE IMPORT ITEM | 604 | 477 | 584 | 414 | 347 | 541 | 332 | 350 | 303 | 498 | 469 | 300 | 435 |
| 209999 | ONLINE IMAGE VIEWED | 9 | 31 | 33 | 27 | 91 | 47 | 33 | 18 | 12 | 13 | 20 | 52 | 32 |
| 150400 | ONLIN CHECK INQUIRY RANGE | 0 | 1,972 | 403 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 198 |
| 150410 | ONLINE PER STOP RANGE ENTRY | 0 | 214 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 |
| 150410 | ONLINE IMPORTED STOP PYMT FILE | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 150410 | ONLINE PER STOP IMPORTED ENTRY | 0 | 216 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 |
| ACH SERVICES | ||||||||||||||
| 250000 | ACH MONTHLY MAINT | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 250505 | ONLINE ACH FILE PROCESSED | 2 | 2 | 5 | 1 | 0 | 2 | 3 | 0 | 0 | 0 | 2 | 1 | 2 |
| 250102 | ONLINE ACH DR/CR ORIGINATED | 3,260 | 2,402 | 2,217 | 2,650 | 213 | 3,082 | 2,787 | 2,235 | 2,509 | 2,755 | 2,252 | 3,087 | 2,454 |
| 250120 | ADDENDA ORIGINATED/RECEIVED | 159 | 113 | 134 | 114 | 122 | 187 | 96 | 177 | 167 | 168 | 189 | 178 | 150 |
| 250200 | DEBITS RECEIVED | 29 | 32 | 32 | 30 | 38 | 42 | 96 | 33 | 25 | 39 | 40 | 36 | 39 |
| 250201 | CREDITS RECEIVED | 353 | 364 | 374 | 42 | 326 | 337 | 322 | 360 | 369 | 416 | 316 | 356 | 328 |
| 250501 | CREDIT EXPRESS FILES | 8 | 3 | 4 | 5 | 6 | 7 | 5 | 4 | 0 | 6 | 3 | 5 | 5 |
| 250400 | ACH RETURN ITEM | 19 | 10 | 15 | 13 | 9 | 16 | 12 | 9 | 10 | 13 | 1 | 13 | 12 |
| 251070 | ACH NOC ITEM | 64 | 51 | 52 | 51 | 44 | 49 | 22 | 0 | 1 | 0 | 0 | 2 | 28 |
| 250302 | UNAUTHORIZED ACH RETURN ITEM | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 2 | 0 | 1 | 0 | 4 | 1 |
| 251050 | ACH POSITIVE PAY MONTHLY SVC | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| 250312 | ACH FRAUD PROTECTION RETURNS | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| FUNDS TRANSFER SERVICES | ||||||||||||||
| 350109 | ONLINE DOMESTIC WIRE TRANSFER | 9 | 11 | 18 | 8 | 9 | 9 | 12 | 8 | 17 | 6 | 8 | 6 | 10 |
| 350300 | INCOMING WIRE TRANSFER | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 1 |
| INFORMATION SERVICES | ||||||||||||||
| 400222 | PREVIOUS DAY ACCOUNT | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| 400225 | CURRENT DAY ACCOUNT | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| 350551 | ONLINE TEMPLATE STORAGE | 20 | 20 | 20 | 20 | 20 | 20 | 22 | 20 | 21 | 21 | 21 | 21 | 21 |
| 40027Z | ONLINE INFO REPORTING MONTHLY | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 400271 | ONLINE PREVIOuS DAY TRANSACTION | 1,226 | 1,285 | 1,429 | 1,239 | 1,131 | 1,211 | 1,206 | 1,170 | 1,269 | 1,648 | 1,213 | 1,174 | 1,267 |
| 400274 | ONLINE CURRENT DAY TRANSACTION | 1,030 | 1,069 | 1,235 | 1,009 | 996 | 1,001 | 1,014 | 1,064 | 1,077 | 1,152 | 984 | 1,026 | 1,055 |
| 409999 | ONLNE EVENT NOTIFICATION SMS TEXT | 42 | 40 | 46 | 42 | 41 | 40 | 44 | 38 | 38 | 46 | 42 | 42 | 42 |
| 409999 | ONLINE EMAILED STATEMENTS | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 409999 | ONLINE OUTSTANDING CHECK REPORT | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 999999 | ONLINE ACH SPECIAL REPORT | 27 | 25 | 20 | 27 | 14 | 17 | 16 | 3 | 7 | 7 | 1 | 9 | 14 |
| 999999 | ONLINE EDI SPECIAL REPORT | 21 | 21 | 22 | 21 | 19 | 16 | 18 | 17 | 16 | 20 | 19 | 19 | 19 |
| 409999 | ONLINE INFO TECHNOLOGY IMAGE | 14 | 11 | 9 | 1 | 24 | 7 | 4 | 15 | 44 | 12 | 0 | 0 | 12 |
| 409999 | ONLINE SPECIAL REPORTS IMAGE | 0 | 0 | 2 | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 9 | 1 |
| 409999 | PAYEE ACCOUNT VALIDATION MONTHLY | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 |
| 409999 | ONLINE MODULE FEES | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| EDI | ||||||||||||||
| 250202 | ELECTRONIC PAYMENTS RECEIVED | 382 | 396 | 406 | 369 | 367 | 378 | 355 | 392 | 393 | 454 | 354 | 393 | 387 |
| 309999 | REMITTANCE REPORT - PDF | 21 | 20 | 23 | 21 | 20 | 20 | 21 | 20 | 19 | 23 | 20 | 22 | 21 |
| 300020 | ELECTRONIC RECEIVABLES RPT - MONTHLY | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| ACCOUNTS INCLUDED IN SUMMARY BALANCES | ||||||||||||||
| 9309 | 162,357 | 283,820 | 283,820 | 283,820 | 283,820 | 78,486 | 3,820 | 3,820 | 3,820 | 3,820 | 3,820 | 3,884 | 116,592 | |
| 3346 | 4,991,271 | 4,521,452 | 5,520,327 | 4,979,873 | 3,941,397 | 2,934,930 | 2,496,864 | 2,199,595 | 1,722,935 | 5,365,854 | 3,722,061 | 3,002,088 | 3,783,221 | |
| 3354 | 4,144,224 | 5,151,616 | 4,665,111 | 3,871,272 | 8,545,622 | 5,778,476 | 4,294,538 | 8,946,563 | 11,259,001 | 13,412,959 | 10,223,335 | 8,469,116 | 7,396,819 | |
| 3362 | 55,643 | 11,660 | 36,396 | 36,862 | 34,979 | 40,414 | 59,286 | 39,604 | 44,740 | 38,721 | 41,564 | 39,823 | 39,974 | |
| 5389 | 151,420 | 152,002 | 158,717 | 74,581 | 79,826 | 80,552 | 80,552 | 76,765 | 74,401 | 75,046 | 75,046 | 78,655 | 96,464 | |
| 3397 | 147,019 | 152,306 | 164,381 | 168,431 | 168,431 | 168,431 | 168,431 | 169,224 | 173,346 | 173,346 | 175,540 | 203,938 | 169,402 | |
| 0424 | 530,039 | 530,039 | 537,440 | 546,428 | 546,428 | 546,428 | 546,428 | 546,428 | 549,746 | 561,911 | 561,911 | 569,406 | 547,719 |
File details come from the government source that posted it. Updated .