APR23 Analysis Statement.pdf
PDF 80 KB Posted
- Attached to
- Depository Banking Services
- Solicitation number
- 2022-23-24
- Issued by
- Texas
About this file
This document is a monthly Account Analysis Statement from PNC Bank for the City of Weslaco, Texas, covering the analysis period from April 1, 2023 to April 30, 2023. The statement details seven different bank accounts (numbered 4943539309, 4943553346, 4943553354, 4943553362, 4943553389, 4943553397, and 4944460424) maintained by the city, providing a comprehensive breakdown of banking services, transaction volumes, and associated fees.
The statement reveals the city's average ledger balance across these accounts was approximately $14.8 million for the month, with an earnings allowance of 0.100%. The total analyzed charges for the month were $1,922.75, with various service categories including demand deposit related services, remote deposit services, branch services, account reconcilement services, automated clearinghouse services, funds transfer services, information services, and electronic data interchange. Several account balance fees were waived, and the bank noted upcoming changes to the treasury management fee schedule effective July 1, 2023, which may impact select service fees and transaction volumes.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Elavon May 2023.pdf | ||
| INVESTMENT POLICY.pdf | ||
| MAY23 Analysis Statement.pdf | ||
| Elavon June 2023.pdf | ||
| 2022-23-24 RFP Banking FINAL.pdf | ||
| Attachment A - Fees Proposal.xlsx | XLSX spreadsheet | |
| Q&A Document 1.pdf | ||
| ADDENDUM #2.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
Visit us at pnc.com
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 0011108120 SUMMARY 04/01/2023 to 04/30/2023
255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
MAY 11, 2023
ACCOUNTS INCLUDED IN THIS ANALYSIS
BANK NUMBER ACCOUNT NUMBER ACCOUNT NAME ACCOUNT TITLE
071 4943539309 CITY OF WESLACO
071 4943553346 CITY OF WESLACO
071 4943553354 CITY OF WESLACO
071 4943553362 CITY OF WESLACO
071 4943553389 CITY OF WESLACO
071 4943553397 CITY OF WESLACO
071 4944460424 CITY OF WESLACO
GO PAPERLESS. SIGN-UP TODAY FOR FREE ONLINE CORPORATE ACCOUNT ANALYSIS STATEMENTS THAT YOU CAN ACCESS VIA PINACLE.
ENROLL TODAY. FOR MORE INFORMATION, CALL TREASURY MANAGEMENT CLIENT CARE AT 1-800-669-1518 OR CONTACT YOUR TREASURY
MANAGEMENT OFFICER OR SALES ASSOCIATE.
IMPORTANT INFORMATION
CHANGES TO YOUR TREASURY MANAGEMENT FEE SCHEDULE EFFECTIVE JULY 1 2023.
IN SUPPORT OF OUR CONTINUED INVESTMENT IN NEW TECHNOLOGY AND INNOVATIVE CASH MANAGEMENT TOOLS, WE ARE INCREASING SELECT FEES AND EXPIRING WAIVERS FOR SELECT SERVICES. THE IMPACT OF THESE PRICE CHANGES WILL DEPEND ON THE MIX OF
SERVICES USED AND RELATED TRANSACTION VOLUMES.
TO RECEIVE SPECIFIC 2023 PRICING INFORMATION FOR YOUR ORGANIZATION, CONTACT YOUR TREASURY MANAGEMENT OFFICER. PLEASE NOTE THAT THESE PRICE CHANGES WILL BE EFFECTIVE WITH YOUR JULY 2023 ACCOUNT ANALYSIS STATEMENT, WHICH YOU WILL RECEIVE IN
AUGUST 2023.
QUESTIONS? PLEASE CONTACT YOUR TREASURY MANAGEMENT OFFICER.
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 0011108120 SUMMARY 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 14,803,280.03 EARNINGS ALLOWANCE (0.100 %) 1,211.89
TOTAL ANALYZED CHARGES 1,922.75
LESS: DEPOSIT FLOAT 58,562.20 EXCESS/(DEFICIT) FEES 710.86-
_____________ TOTAL AMOUNT DUE 710.86
AVERAGE COLLECTED BALANCE 14,744,717.83 (DEBIT)
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 14,744,717.83
COLLECTED BALANCE REQUIRED 23,393,464.84
EXCESS/(DEFICIT) BALANCE 8,648,747.01-
YOUR ACCOUNT 4943553354 WILL BE CHARGED ON THE LAST BUSINESS DAY OF THE MONTH FOR THE ABOVE NOTED DEFICIENCY AMOUNT.
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
DEMAND DEPOSIT RELATED SERVICES
ACCOUNT BALANCE FEE 00 02 30 14,804 0.1420 2,102.16 WAIVED
REGULAR DEPOSIT TICKET 10 02 00 134 0.3000 40.20 489,100.13
DEPOSIT ITEMS-ON US(N) 10 02 20 197 0.0500 9.85 119,841.70
DEPOSITED ITEMS-TRANSIT 10 02 00 1,290 0.0500 64.50 784,750.22
PAID ITEMS 15 01 00 408 0.1500 61.20 744,600.20
HYBRID CHECKING MAINTENANCE 01 00 00 7 8.0000 56.00 681,333.52
RETURNS 10 04 00 1 16.0000 16.00 194,666.72
$2,349.91 $3,014,292.49
REMOTE DEPOSIT RELATED SERVICES
DEPOSIT ON-SITE MONTHLY FEE 10 99 99 1 100.0000 100.00 1,216,667.00
$100.00 $1,216,667.00
BRANCH SERVICES
CURRENCY FURNISHED $10 UNITS 10 00 48 97 0.4200 40.74 495,670.14
COIN FURNISHED (ROLLS) 10 00 44 11 0.5800 6.38 77,623.35
OVER THE COUNTER DEPOSIT TICKETS 10 00 00 133 0.5000 66.50 809,083.56
NIGHT DROP BAG DEPOSIT 10 00 05 1 0.5000 0.50 6,083.34
CASH VERIFICATION OTC-10.00 UNITS 10 00 15 15,010 0.0120 180.12 2,191,460.60
CASH VERIFICATION/NIGHT DROP-10.00 10 00 15 7 0.0070 0.05 608.33
$294.29 $3,580,529.32
ACCOUNT RECONCILEMENT SERVICES
FULL RECON POSPAY MONTHLY 20 00 10 1 8.4000 8.40 102,200.03
FULL RECON POSPAY ITEM 20 01 10 403 0.0200 8.06 98,063.36
TELLER POSITIVE PAY MAINTENANCE 20 00 00 1 12.0000 12.00 146,000.04
POSITIVE PAY MONTHLY MAINTENANCE 20 00 00 1 12.0000 12.00 146,000.04
PINACLE ISSUE FILE IMPORT 99 99 99 4 3.5000 14.00 170,333.38
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 0011108120 SUMMARY 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
PINACLE PER STOP INDIVIDUAL ENTRY 99 99 99 4 8.0000 32.00 389,333.44
PINACLE CHECK INQUIRY 99 99 99 1 0.0500 0.05 608.33
PINACLE ISSUE ADD/CANCEL 99 99 99 23 0.0500 1.15 13,991.67
PINACLE ISSUE FILE IMPORT ITEM 99 99 99 469 0.0200 9.38 114,123.36
PINACLE IMAGE VIEWED 20 99 99 20 1.1500 23.00 279,833.41
$120.04 $1,460,487.06
AUTOMATED CLEARINGHOUSE SERVICES
ACH MONTHLY MAINTENANCE FEE 25 00 00 2 10.0000 20.00 243,333.40
PINACLE ACH FILE PROCESSED 25 05 05 2 5.5000 11.00 133,833.37
PINACLE ACH DEBIT/CREDIT ORIGINATED 25 01 02 2,252 0.0800 180.16 2,191,947.27
ADDENDA ORIGINATED/RECEIVED 25 01 20 189 0.0200 3.78 45,990.01
DEBITS RECEIVED 25 02 00 40 0.2200 8.80 107,066.70
CREDITS RECEIVED 25 02 01 316 0.2200 69.52 845,826.90
CREDIT EXPRESS FILES 25 05 01 3 5.5000 16.50 200,750.06
ACH RETURN ITEM 25 04 00 1 4.0000 4.00 48,666.68
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 7 15.5000 108.50 1,320,083.73
$422.26 $5,137,498.12
FUNDS TRANSFER SERVICES
PINACLE DOMESTIC WIRE TRANSFER 35 01 09 8 12.5000 100.00 1,216,667.00
$100.00 $1,216,667.00
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 7 2.5000 17.50 212,916.76
CURRENT DAY ACCOUNT 40 02 25 7 2.5000 17.50 212,916.76
PINACLE TEMPLATE STORAGE 35 05 51 21 0.7500 15.75 191,625.05
PINACLE INFO REPORTING MONTHLY 40 02 7Z 1 150.0000 150.00 1,825,000.50
PINACLE-PREV DAY TRANSACTION 40 02 71 1,213 0.0100 12.13 147,581.71
PINACLE-CURRENT DAY TRANSACTION 40 02 74 984 0.0100 9.84 119,720.02
PIN EVENT NOTIF-SMS(TEXT)SG 40 99 99 42 0.1000 4.20 51,100.01
PINACLE EMAILED STATEMENTS 40 99 99 1 0.2500 0.25 3,041.67
PINACLE OUTSTANDING CHECK REPORT 40 99 99 1 20.0000 20.00 243,333.40
PINACLE ACH SPECIAL REPORT 99 99 99 1 3.0000 3.00 36,500.01
PINACLE EDI SPECIAL REPORT 99 99 99 19 3.0000 57.00 693,500.19
PINACLE INFORMATION REPORTING IMAGE 40 99 99 2 1.1500 2.30 27,983.34
PINACLE MODULE FEES 40 99 99 7 30.0000 210.00 2,555,000.70
$519.47 $6,320,220.12
ELECTRONIC DATA INTERCHANGE
ELECTRONIC PAYMENTS RECEIVED 25 02 02 354 0.1100 38.94 473,770.13
REMITTANCE REPORT-PDF 30 99 99 20 3.0000 60.00 730,000.20
ELEC RECEIVABLES REPT MONTHLY MAINT 30 00 20 1 20.0000 20.00 243,333.40
$118.94 $1,447,103.73
TOTAL ANALYZED CHARGES : $1,922.75 $23,393,464.84
TOTAL CHARGES THIS CYCLE : $4,024.91 $23,393,464.84
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 0011108120 SUMMARY 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
TOTAL WAIVED CHARGES : $2,102.16 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943539309 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 3,820.24 EARNINGS ALLOWANCE (0.100 %) 0.31
TOTAL ANALYZED CHARGES 28.91
LESS: DEPOSIT FLOAT 0.00 EXCESS/(DEFICIT) FEES 28.60-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 3,820.24
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 3,820.24
COLLECTED BALANCE REQUIRED 351,738.44
EXCESS/(DEFICIT) BALANCE 347,918.20-
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
DEMAND DEPOSIT RELATED SERVICES
ACCOUNT BALANCE FEE 00 02 30 4 0.1420 0.57 WAIVED
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 97,333.36
$8.57 $97,333.36
AUTOMATED CLEARINGHOUSE SERVICES
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 188,583.39
$15.50 $188,583.39
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 30,416.68
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 30,416.68
PINACLE-PREV DAY TRANSACTION 40 02 71 21 0.0100 0.21 2,555.00
PINACLE-CURRENT DAY TRANSACTION 40 02 74 20 0.0100 0.20 2,433.33
$5.41 $65,821.69
TOTAL ANALYZED CHARGES : $28.91 $351,738.44
TOTAL CHARGES THIS CYCLE : $29.48 $351,738.44
TOTAL WAIVED CHARGES : $0.57 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553346 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 3,722,061.38 EARNINGS ALLOWANCE (0.100 %) 305.92
TOTAL ANALYZED CHARGES 513.36
LESS: DEPOSIT FLOAT 0.00 EXCESS/(DEFICIT) FEES 207.44-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 3,722,061.38
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 3,722,061.38
COLLECTED BALANCE REQUIRED 6,245,881.72
EXCESS/(DEFICIT) BALANCE 2,523,820.34-
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
DEMAND DEPOSIT RELATED SERVICES
ACCOUNT BALANCE FEE 00 02 30 3,722 0.1420 528.52 WAIVED
PAID ITEMS 15 01 00 5 0.1500 0.75 9,125.00
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 97,333.36
$537.27 $106,458.36
ACCOUNT RECONCILEMENT SERVICES
PINACLE ISSUE FILE IMPORT 99 99 99 4 3.5000 14.00 170,333.38
PINACLE ISSUE FILE IMPORT ITEM 99 99 99 469 0.0200 9.38 114,123.36
$23.38 $284,456.74
AUTOMATED CLEARINGHOUSE SERVICES
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 188,583.39
$15.50 $188,583.39
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 30,416.68
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 30,416.68
PINACLE TEMPLATE STORAGE 35 05 51 21 0.7500 15.75 191,625.05
PINACLE INFO REPORTING MONTHLY 40 02 7Z 1 150.0000 150.00 1,825,000.50
PINACLE-PREV DAY TRANSACTION 40 02 71 28 0.0100 0.28 3,406.67
PINACLE-CURRENT DAY TRANSACTION 40 02 74 25 0.0100 0.25 3,041.67
PIN EVENT NOTIF-SMS(TEXT)SG 40 99 99 42 0.1000 4.20 51,100.01
PINACLE EMAILED STATEMENTS 40 99 99 1 0.2500 0.25 3,041.67
PINACLE OUTSTANDING CHECK REPORT 40 99 99 1 20.0000 20.00 243,333.40
PINACLE ACH SPECIAL REPORT 99 99 99 1 3.0000 3.00 36,500.01
PINACLE EDI SPECIAL REPORT 99 99 99 19 3.0000 57.00 693,500.19
PINACLE MODULE FEES 40 99 99 7 30.0000 210.00 2,555,000.70
$465.73 $5,666,383.23
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553346 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
TOTAL ANALYZED CHARGES : $513.36 $6,245,881.72
TOTAL CHARGES THIS CYCLE : $1,041.88 $6,245,881.72
TOTAL WAIVED CHARGES : $528.52 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553354 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 10,223,335.94 EARNINGS ALLOWANCE (0.100 %) 835.46
TOTAL ANALYZED CHARGES 1,154.36
LESS: DEPOSIT FLOAT 58,562.20 EXCESS/(DEFICIT) FEES 318.90-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 10,164,773.74
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 10,164,773.74
COLLECTED BALANCE REQUIRED 14,044,717.21
EXCESS/(DEFICIT) BALANCE 3,879,943.47-
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
DEMAND DEPOSIT RELATED SERVICES
ACCOUNT BALANCE FEE 00 02 30 10,223 0.1420 1,451.67 WAIVED
REGULAR DEPOSIT TICKET 10 02 00 132 0.3000 39.60 481,800.13
DEPOSIT ITEMS-ON US(N) 10 02 20 195 0.0500 9.75 118,625.03
DEPOSITED ITEMS-TRANSIT 10 02 00 1,290 0.0500 64.50 784,750.22
PAID ITEMS 15 01 00 403 0.1500 60.45 735,475.20
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 97,333.36
RETURNS 10 04 00 1 16.0000 16.00 194,666.72
$1,649.97 $2,412,650.66
REMOTE DEPOSIT RELATED SERVICES
DEPOSIT ON-SITE MONTHLY FEE 10 99 99 1 100.0000 100.00 1,216,667.00
$100.00 $1,216,667.00
BRANCH SERVICES
CURRENCY FURNISHED $10 UNITS 10 00 48 97 0.4200 40.74 495,670.14
COIN FURNISHED (ROLLS) 10 00 44 11 0.5800 6.38 77,623.35
OVER THE COUNTER DEPOSIT TICKETS 10 00 00 131 0.5000 65.50 796,916.89
NIGHT DROP BAG DEPOSIT 10 00 05 1 0.5000 0.50 6,083.34
CASH VERIFICATION OTC-10.00 UNITS 10 00 15 15,010 0.0120 180.12 2,191,460.60
CASH VERIFICATION/NIGHT DROP-10.00 10 00 15 7 0.0070 0.05 608.33
$293.29 $3,568,362.65
ACCOUNT RECONCILEMENT SERVICES
FULL RECON POSPAY MONTHLY 20 00 10 1 8.4000 8.40 102,200.03
FULL RECON POSPAY ITEM 20 01 10 403 0.0200 8.06 98,063.36
TELLER POSITIVE PAY MAINTENANCE 20 00 00 1 12.0000 12.00 146,000.04
POSITIVE PAY MONTHLY MAINTENANCE 20 00 00 1 12.0000 12.00 146,000.04
PINACLE PER STOP INDIVIDUAL ENTRY 99 99 99 4 8.0000 32.00 389,333.44
PINACLE CHECK INQUIRY 99 99 99 1 0.0500 0.05 608.33
PINACLE ISSUE ADD/CANCEL 99 99 99 23 0.0500 1.15 13,991.67
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553354 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
PINACLE IMAGE VIEWED 20 99 99 20 1.1500 23.00 279,833.41
$96.66 $1,176,030.32
AUTOMATED CLEARINGHOUSE SERVICES
ACH MONTHLY MAINTENANCE FEE 25 00 00 1 10.0000 10.00 121,666.70
PINACLE ACH DEBIT/CREDIT ORIGINATED 25 01 02 1,157 0.0800 92.56 1,126,146.98
ADDENDA ORIGINATED/RECEIVED 25 01 20 189 0.0200 3.78 45,990.01
DEBITS RECEIVED 25 02 00 40 0.2200 8.80 107,066.70
CREDITS RECEIVED 25 02 01 316 0.2200 69.52 845,826.90
CREDIT EXPRESS FILES 25 05 01 3 5.5000 16.50 200,750.06
ACH RETURN ITEM 25 04 00 1 4.0000 4.00 48,666.68
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 188,583.39
$220.66 $2,684,697.42
FUNDS TRANSFER SERVICES
PINACLE DOMESTIC WIRE TRANSFER 35 01 09 8 12.5000 100.00 1,216,667.00
$100.00 $1,216,667.00
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 30,416.68
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 30,416.68
PINACLE-PREV DAY TRANSACTION 40 02 71 1,066 0.0100 10.66 129,696.70
PINACLE-CURRENT DAY TRANSACTION 40 02 74 855 0.0100 8.55 104,025.03
PINACLE INFORMATION REPORTING IMAGE 40 99 99 2 1.1500 2.30 27,983.34
$26.51 $322,538.43
ELECTRONIC DATA INTERCHANGE
ELECTRONIC PAYMENTS RECEIVED 25 02 02 354 0.1100 38.94 473,770.13
REMITTANCE REPORT-PDF 30 99 99 20 3.0000 60.00 730,000.20
ELEC RECEIVABLES REPT MONTHLY MAINT 30 00 20 1 20.0000 20.00 243,333.40
$118.94 $1,447,103.73
TOTAL ANALYZED CHARGES : $1,154.36 $14,044,717.21
TOTAL CHARGES THIS CYCLE : $2,606.03 $14,044,717.21
TOTAL WAIVED CHARGES : $1,451.67 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553362 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 41,564.27 EARNINGS ALLOWANCE (0.100 %) 3.42
TOTAL ANALYZED CHARGES 139.29
LESS: DEPOSIT FLOAT 0.00 EXCESS/(DEFICIT) FEES 135.87-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 41,564.27
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 41,564.27
COLLECTED BALANCE REQUIRED 1,694,695.48
EXCESS/(DEFICIT) BALANCE 1,653,131.21-
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
DEMAND DEPOSIT RELATED SERVICES
ACCOUNT BALANCE FEE 00 02 30 42 0.1420 5.96 WAIVED
REGULAR DEPOSIT TICKET 10 02 00 2 0.3000 0.60 7,300.00
DEPOSIT ITEMS-ON US(N) 10 02 20 2 0.0500 0.10 1,216.67
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 97,333.36
$14.66 $105,850.03
BRANCH SERVICES
OVER THE COUNTER DEPOSIT TICKETS 10 00 00 2 0.5000 1.00 12,166.67
$1.00 $12,166.67
AUTOMATED CLEARINGHOUSE SERVICES
ACH MONTHLY MAINTENANCE FEE 25 00 00 1 10.0000 10.00 121,666.70
PINACLE ACH FILE PROCESSED 25 05 05 2 5.5000 11.00 133,833.37
PINACLE ACH DEBIT/CREDIT ORIGINATED 25 01 02 1,095 0.0800 87.60 1,065,800.29
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 188,583.39
$124.10 $1,509,883.75
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 30,416.68
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 30,416.68
PINACLE-PREV DAY TRANSACTION 40 02 71 25 0.0100 0.25 3,041.67
PINACLE-CURRENT DAY TRANSACTION 40 02 74 24 0.0100 0.24 2,920.00
$5.49 $66,795.03
TOTAL ANALYZED CHARGES : $139.29 $1,694,695.48
TOTAL CHARGES THIS CYCLE : $145.25 $1,694,695.48
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553362 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
TOTAL WAIVED CHARGES : $5.96 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553389 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 75,046.46 EARNINGS ALLOWANCE (0.100 %) 6.17
TOTAL ANALYZED CHARGES 28.91
LESS: DEPOSIT FLOAT 0.00 EXCESS/(DEFICIT) FEES 22.74-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 75,046.46
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 75,046.46
COLLECTED BALANCE REQUIRED 351,738.44
EXCESS/(DEFICIT) BALANCE 276,691.98-
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
DEMAND DEPOSIT RELATED SERVICES
ACCOUNT BALANCE FEE 00 02 30 75 0.1420 10.65 WAIVED
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 97,333.36
$18.65 $97,333.36
AUTOMATED CLEARINGHOUSE SERVICES
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 188,583.39
$15.50 $188,583.39
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 30,416.68
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 30,416.68
PINACLE-PREV DAY TRANSACTION 40 02 71 21 0.0100 0.21 2,555.00
PINACLE-CURRENT DAY TRANSACTION 40 02 74 20 0.0100 0.20 2,433.33
$5.41 $65,821.69
TOTAL ANALYZED CHARGES : $28.91 $351,738.44
TOTAL CHARGES THIS CYCLE : $39.56 $351,738.44
TOTAL WAIVED CHARGES : $10.65 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553397 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 175,540.52 EARNINGS ALLOWANCE (0.100 %) 14.43
TOTAL ANALYZED CHARGES 29.01
LESS: DEPOSIT FLOAT 0.00 EXCESS/(DEFICIT) FEES 14.58-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 175,540.52
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 175,540.52
COLLECTED BALANCE REQUIRED 352,955.11
EXCESS/(DEFICIT) BALANCE 177,414.59-
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
DEMAND DEPOSIT RELATED SERVICES
ACCOUNT BALANCE FEE 00 02 30 176 0.1420 24.99 WAIVED
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 97,333.36
$32.99 $97,333.36
AUTOMATED CLEARINGHOUSE SERVICES
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 188,583.39
$15.50 $188,583.39
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 30,416.68
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 30,416.68
PINACLE-PREV DAY TRANSACTION 40 02 71 31 0.0100 0.31 3,771.67
PINACLE-CURRENT DAY TRANSACTION 40 02 74 20 0.0100 0.20 2,433.33
$5.51 $67,038.36
TOTAL ANALYZED CHARGES : $29.01 $352,955.11
TOTAL CHARGES THIS CYCLE : $54.00 $352,955.11
TOTAL WAIVED CHARGES : $24.99 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4944460424 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 561,911.22 EARNINGS ALLOWANCE (0.100 %) 46.18
TOTAL ANALYZED CHARGES 28.91
LESS: DEPOSIT FLOAT 0.00 EXCESS/(DEFICIT) FEES 17.27
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 561,911.22
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 561,911.22
COLLECTED BALANCE REQUIRED 351,738.44
EXCESS/(DEFICIT) BALANCE 210,172.78
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
DEMAND DEPOSIT RELATED SERVICES
ACCOUNT BALANCE FEE 00 02 30 562 0.1420 79.80 WAIVED
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 97,333.36
$87.80 $97,333.36
AUTOMATED CLEARINGHOUSE SERVICES
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 188,583.39
$15.50 $188,583.39
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 30,416.68
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 30,416.68
PINACLE-PREV DAY TRANSACTION 40 02 71 21 0.0100 0.21 2,555.00
PINACLE-CURRENT DAY TRANSACTION 40 02 74 20 0.0100 0.20 2,433.33
$5.41 $65,821.69
TOTAL ANALYZED CHARGES : $28.91 $351,738.44
TOTAL CHARGES THIS CYCLE : $108.71 $351,738.44
TOTAL WAIVED CHARGES : $79.80 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 0011108120 SUMMARY 04/01/2023 to 04/30/2023
255 S KANSAS AVE255 S KANSAS AVE TREASURY MICHAEL BRADLEY
WESLACO TX 78596-6158 OFFICER (972) 765-7292
CLIENT TMCC@pnc.com
SERVICES 1-800-669-1518 STATEMENT DATE
BILLING CYCLE MONTHLY
MAY 11, 2023
YEAR-TO-DATE RELATIONSHIP SUMMARY
ADJUSTED ADJUSTED EARNINGS TOTAL COLLECTED
AVERAGE COLLECTED CREDIT ACTIVITY BALANCE EXCESS/(DEFICIT) EXCESS/(DEFICIT)
MONTH LEDGER BALANCE BALANCE RATE CHARGES REQUIRED BALANCE FEE EQUIVALENT
JANUARY 11,982,001.58 11,953,592.13 .100000 2,083.41 24,530,465.31 12,576,873.18- 1,068.19- FEBRUARY 13,827,992.70 13,775,307.55 .100000 2,293.54 29,897,922.43 16,122,614.88- 1,236.81- MARCH 19,631,660.00 19,575,506.84 .100000 2,254.53 26,545,264.67 6,969,757.83- 591.97-
QTR TOTAL 15,147,218.09 15,101,468.84 6,631.48 26,991,217.47 11,889,748.63- 2,896.97-
APRIL 14,803,280.03 14,744,717.83 .100000 1,922.75 23,393,464.84 8,648,747.01- 710.86-
QTR TOTAL 14,803,280.03 14,744,717.83 1,922.75 23,393,464.84 8,648,747.01- 710.86-
YTD TOTAL 15,061,233.58 15,012,281.09 .100000 8,554.23 26,091,779.31 11,079,498.23- 3,607.83-
File details come from the government source that posted it. Updated .