MAY23 Analysis Statement.pdf
PDF 81 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 May 1st to May 31st, 2023. The statement details banking services and account activities across seven different bank accounts (numbered 4943539309, 4943553346, 4943553354, 4943553362, 4943553389, 4943553397, and 4944460424) utilized by the City of Weslaco for various municipal financial operations.
The statement provides a comprehensive breakdown of banking services, including demand deposit services, remote deposit services, branch services, account reconcilement services, automated clearinghouse services, funds transfer services, information services, and electronic data interchange services. The total analyzed charges for the month were $2,219.41, with a total waived charges amount of $1,756.12. The city's average ledger balance across all accounts was $12,366,913.40, with an earnings allowance of 0.100%. The statement also includes a year-to-date relationship summary showing monthly variations in average ledger balance, collected balance, activity charges, and excess/deficit balances, indicating the city's ongoing financial transactions and banking relationship with PNC Bank.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Elavon May 2023.pdf | ||
| INVESTMENT POLICY.pdf | ||
| Elavon June 2023.pdf | ||
| ADDENDUM #2.pdf | ||
| APR23 Analysis Statement.pdf | ||
| 2022-23-24 RFP Banking FINAL.pdf | ||
| Attachment A - Fees Proposal.xlsx | XLSX spreadsheet | |
| Q&A Document 1.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 05/01/2023 to 05/31/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
JUNE 12, 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 05/01/2023 to 05/31/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
JUNE 12, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 12,366,913.40 EARNINGS ALLOWANCE (0.100 %) 1,046.44
TOTAL ANALYZED CHARGES 2,219.41
LESS: DEPOSIT FLOAT 45,883.97 EXCESS/(DEFICIT) FEES 1,172.97-
_____________ TOTAL AMOUNT DUE 1,172.97
AVERAGE COLLECTED BALANCE 12,321,029.43 (DEBIT)
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 12,321,029.43
COLLECTED BALANCE REQUIRED 26,131,755.13
EXCESS/(DEFICIT) BALANCE 13,810,725.70-
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 12,367 0.1420 1,756.12 WAIVED
REGULAR DEPOSIT TICKET 10 02 00 164 0.3000 49.20 579,290.15
DEPOSIT ITEMS-ON US(N) 10 02 20 265 0.0500 13.25 156,008.02
DEPOSITED ITEMS-TRANSIT 10 02 00 1,744 0.0500 87.20 1,026,709.37
PAID ITEMS 15 01 00 398 0.1500 59.70 702,919.14
HYBRID CHECKING MAINTENANCE 01 00 00 7 8.0000 56.00 659,354.64
RETURNS 10 04 00 2 16.0000 32.00 376,774.08
$2,053.47 $3,501,055.40
REMOTE DEPOSIT RELATED SERVICES
DEPOSIT ON-SITE MONTHLY FEE 10 99 99 1 100.0000 100.00 1,177,419.00
$100.00 $1,177,419.00
BRANCH SERVICES
CURRENCY FURNISHED $10 UNITS 10 00 48 80 0.4200 33.60 395,612.78
COIN FURNISHED (ROLLS) 10 00 44 13 0.5800 7.54 88,777.39
OVER THE COUNTER DEPOSIT TICKETS 10 00 00 164 0.5000 82.00 965,483.59
CASH VERIFICATION OTC-10.00 UNITS 10 00 15 17,653 0.0120 211.84 2,494,244.41
$334.98 $3,944,118.17
ACCOUNT RECONCILEMENT SERVICES
FULL RECON POSPAY MONTHLY 20 00 10 1 8.4000 8.40 98,903.20
FULL RECON POSPAY ITEM 20 01 10 392 0.0200 7.84 92,309.65
TELLER POSITIVE PAY MAINTENANCE 20 00 00 1 12.0000 12.00 141,290.28
POSITIVE PAY MONTHLY MAINTENANCE 20 00 00 1 12.0000 12.00 141,290.28
PINACLE ISSUE FILE IMPORT 99 99 99 2 3.5000 7.00 82,419.33
PINACLE PER STOP INDIVIDUAL ENTRY 99 99 99 5 8.0000 40.00 470,967.60
PINACLE CHECK INQUIRY 99 99 99 3 0.0500 0.15 1,766.13
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 0011108120 SUMMARY 05/01/2023 to 05/31/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
JUNE 12, 2023
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
PINACLE ISSUE ADD/CANCEL 99 99 99 77 0.0500 3.85 45,330.63
PINACLE ISSUE FILE IMPORT ITEM 99 99 99 300 0.0200 6.00 70,645.14
PINACLE IMAGE VIEWED 20 99 99 52 1.1500 59.80 704,096.56
$157.04 $1,849,018.80
AUTOMATED CLEARINGHOUSE SERVICES
ACH MONTHLY MAINTENANCE FEE 25 00 00 2 10.0000 20.00 235,483.80
PINACLE ACH FILE PROCESSED 25 05 05 1 5.5000 5.50 64,758.05
PINACLE ACH DEBIT/CREDIT ORIGINATED 25 01 02 3,087 0.0800 246.96 2,907,753.96
ADDENDA ORIGINATED/RECEIVED 25 01 20 178 0.0200 3.56 41,916.12
DEBITS RECEIVED 25 02 00 36 0.2200 7.92 93,251.58
CREDITS RECEIVED 25 02 01 356 0.2200 78.32 922,154.56
CREDIT EXPRESS FILES 25 05 01 5 5.5000 27.50 323,790.23
ACH RETURN ITEM 25 04 00 13 4.0000 52.00 612,257.88
ACH NOC ITEM 25 10 70 2 2.0000 4.00 47,096.76
UNAUTHORIZED ACH RETURN ITEM 25 03 02 4 5.0000 20.00 235,483.80
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 7 15.5000 108.50 1,277,499.65
$574.26 $6,761,446.39
FUNDS TRANSFER SERVICES
PINACLE DOMESTIC WIRE TRANSFER 35 01 09 6 12.5000 75.00 883,064.25
$75.00 $883,064.25
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 7 2.5000 17.50 206,048.36
CURRENT DAY ACCOUNT 40 02 25 7 2.5000 17.50 206,048.36
PINACLE TEMPLATE STORAGE 35 05 51 21 0.7500 15.75 185,443.49
PINACLE INFO REPORTING MONTHLY 40 02 7Z 1 150.0000 150.00 1,766,128.50
PINACLE-PREV DAY TRANSACTION 40 02 71 1,174 0.0100 11.74 138,228.98
PINACLE-CURRENT DAY TRANSACTION 40 02 74 1,026 0.0100 10.26 120,803.18
PIN EVENT NOTIF-SMS(TEXT)SG 40 99 99 42 0.1000 4.20 49,451.60
PINACLE EMAILED STATEMENTS 40 99 99 1 0.2500 0.25 2,943.55
PINACLE OUTSTANDING CHECK REPORT 40 99 99 1 20.0000 20.00 235,483.80
PINACLE ACH SPECIAL REPORT 99 99 99 9 3.0000 27.00 317,903.13
PINACLE EDI SPECIAL REPORT 99 99 99 19 3.0000 57.00 671,128.83
PINACLE INFORMATION REPORTING IMAGE 40 99 99 9 1.1500 10.35 121,862.87
PINACLE MODULE FEES 40 99 99 7 30.0000 210.00 2,472,579.90
$551.55 $6,494,054.55
ELECTRONIC DATA INTERCHANGE
ELECTRONIC PAYMENTS RECEIVED 25 02 02 393 0.1100 43.23 508,998.23
REMITTANCE REPORT-PDF 30 99 99 22 3.0000 66.00 777,096.54
ELEC RECEIVABLES REPT MONTHLY MAINT 30 00 20 1 20.0000 20.00 235,483.80
$129.23 $1,521,578.57
TOTAL ANALYZED CHARGES : $2,219.41 $26,131,755.13
TOTAL CHARGES THIS CYCLE : $3,975.53 $26,131,755.13
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 0011108120 SUMMARY 05/01/2023 to 05/31/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
JUNE 12, 2023
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
TOTAL WAIVED CHARGES : $1,756.12 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943539309 05/01/2023 to 05/31/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
JUNE 12, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 3,884.70 EARNINGS ALLOWANCE (0.100 %) 0.33
TOTAL ANALYZED CHARGES 28.95
LESS: DEPOSIT FLOAT 0.00 EXCESS/(DEFICIT) FEES 28.62-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 3,884.70
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 3,884.70
COLLECTED BALANCE REQUIRED 340,862.81
EXCESS/(DEFICIT) BALANCE 336,978.11-
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 94,193.52
$8.57 $94,193.52
AUTOMATED CLEARINGHOUSE SERVICES
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 182,499.95
$15.50 $182,499.95
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 29,435.48
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 29,435.48
PINACLE-PREV DAY TRANSACTION 40 02 71 23 0.0100 0.23 2,708.06
PINACLE-CURRENT DAY TRANSACTION 40 02 74 22 0.0100 0.22 2,590.32
$5.45 $64,169.34
TOTAL ANALYZED CHARGES : $28.95 $340,862.81
TOTAL CHARGES THIS CYCLE : $29.52 $340,862.81
TOTAL WAIVED CHARGES : $0.57 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553346 05/01/2023 to 05/31/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
JUNE 12, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 3,002,088.44 EARNINGS ALLOWANCE (0.100 %) 254.97
TOTAL ANALYZED CHARGES 527.24
LESS: DEPOSIT FLOAT 0.00 EXCESS/(DEFICIT) FEES 272.27-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 3,002,088.44
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 3,002,088.44
COLLECTED BALANCE REQUIRED 6,207,823.95
EXCESS/(DEFICIT) BALANCE 3,205,735.51-
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,002 0.1420 426.28 WAIVED
PAID ITEMS 15 01 00 5 0.1500 0.75 8,830.64
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 94,193.52
$435.03 $103,024.16
ACCOUNT RECONCILEMENT SERVICES
PINACLE ISSUE FILE IMPORT 99 99 99 2 3.5000 7.00 82,419.33
PINACLE ISSUE FILE IMPORT ITEM 99 99 99 300 0.0200 6.00 70,645.14
$13.00 $153,064.47
AUTOMATED CLEARINGHOUSE SERVICES
DEBITS RECEIVED 25 02 00 1 0.2200 0.22 2,590.32
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 182,499.95
$15.72 $185,090.27
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 29,435.48
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 29,435.48
PINACLE TEMPLATE STORAGE 35 05 51 21 0.7500 15.75 185,443.49
PINACLE INFO REPORTING MONTHLY 40 02 7Z 1 150.0000 150.00 1,766,128.50
PINACLE-PREV DAY TRANSACTION 40 02 71 31 0.0100 0.31 3,650.00
PINACLE-CURRENT DAY TRANSACTION 40 02 74 26 0.0100 0.26 3,061.29
PIN EVENT NOTIF-SMS(TEXT)SG 40 99 99 42 0.1000 4.20 49,451.60
PINACLE EMAILED STATEMENTS 40 99 99 1 0.2500 0.25 2,943.55
PINACLE OUTSTANDING CHECK REPORT 40 99 99 1 20.0000 20.00 235,483.80
PINACLE ACH SPECIAL REPORT 99 99 99 9 3.0000 27.00 317,903.13
PINACLE EDI SPECIAL REPORT 99 99 99 19 3.0000 57.00 671,128.83
PINACLE MODULE FEES 40 99 99 7 30.0000 210.00 2,472,579.90
$489.77 $5,766,645.05
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553346 05/01/2023 to 05/31/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
JUNE 12, 2023
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
TOTAL ANALYZED CHARGES : $527.24 $6,207,823.95
TOTAL CHARGES THIS CYCLE : $953.52 $6,207,823.95
TOTAL WAIVED CHARGES : $426.28 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553354 05/01/2023 to 05/31/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
JUNE 12, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 8,469,116.61 EARNINGS ALLOWANCE (0.100 %) 715.47
TOTAL ANALYZED CHARGES 1,396.20
LESS: DEPOSIT FLOAT 45,003.84 EXCESS/(DEFICIT) FEES 680.73-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 8,424,112.77
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 8,424,112.77
COLLECTED BALANCE REQUIRED 16,439,124.09
EXCESS/(DEFICIT) BALANCE 8,015,011.32-
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 8,469 0.1420 1,202.60 WAIVED
REGULAR DEPOSIT TICKET 10 02 00 160 0.3000 48.00 565,161.12
DEPOSIT ITEMS-ON US(N) 10 02 20 263 0.0500 13.15 154,830.60
DEPOSITED ITEMS-TRANSIT 10 02 00 1,741 0.0500 87.05 1,024,943.24
PAID ITEMS 15 01 00 392 0.1500 58.80 692,322.37
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 94,193.52
RETURNS 10 04 00 2 16.0000 32.00 376,774.08
$1,449.60 $2,908,224.93
REMOTE DEPOSIT RELATED SERVICES
DEPOSIT ON-SITE MONTHLY FEE 10 99 99 1 100.0000 100.00 1,177,419.00
$100.00 $1,177,419.00
BRANCH SERVICES
CURRENCY FURNISHED $10 UNITS 10 00 48 80 0.4200 33.60 395,612.78
COIN FURNISHED (ROLLS) 10 00 44 13 0.5800 7.54 88,777.39
OVER THE COUNTER DEPOSIT TICKETS 10 00 00 160 0.5000 80.00 941,935.20
CASH VERIFICATION OTC-10.00 UNITS 10 00 15 17,653 0.0120 211.84 2,494,244.41
$332.98 $3,920,569.78
ACCOUNT RECONCILEMENT SERVICES
FULL RECON POSPAY MONTHLY 20 00 10 1 8.4000 8.40 98,903.20
FULL RECON POSPAY ITEM 20 01 10 392 0.0200 7.84 92,309.65
TELLER POSITIVE PAY MAINTENANCE 20 00 00 1 12.0000 12.00 141,290.28
POSITIVE PAY MONTHLY MAINTENANCE 20 00 00 1 12.0000 12.00 141,290.28
PINACLE PER STOP INDIVIDUAL ENTRY 99 99 99 5 8.0000 40.00 470,967.60
PINACLE CHECK INQUIRY 99 99 99 3 0.0500 0.15 1,766.13
PINACLE ISSUE ADD/CANCEL 99 99 99 77 0.0500 3.85 45,330.63
PINACLE IMAGE VIEWED 20 99 99 52 1.1500 59.80 704,096.56
$144.04 $1,695,954.33
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553354 05/01/2023 to 05/31/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
JUNE 12, 2023
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
AUTOMATED CLEARINGHOUSE SERVICES
ACH MONTHLY MAINTENANCE FEE 25 00 00 1 10.0000 10.00 117,741.90
PINACLE ACH DEBIT/CREDIT ORIGINATED 25 01 02 1,437 0.0800 114.96 1,353,560.88
ADDENDA ORIGINATED/RECEIVED 25 01 20 178 0.0200 3.56 41,916.12
DEBITS RECEIVED 25 02 00 35 0.2200 7.70 90,661.26
CREDITS RECEIVED 25 02 01 356 0.2200 78.32 922,154.56
CREDIT EXPRESS FILES 25 05 01 5 5.5000 27.50 323,790.23
ACH RETURN ITEM 25 04 00 13 4.0000 52.00 612,257.88
ACH NOC ITEM 25 10 70 2 2.0000 4.00 47,096.76
UNAUTHORIZED ACH RETURN ITEM 25 03 02 4 5.0000 20.00 235,483.80
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 182,499.95
$333.54 $3,927,163.34
FUNDS TRANSFER SERVICES
PINACLE DOMESTIC WIRE TRANSFER 35 01 09 6 12.5000 75.00 883,064.25
$75.00 $883,064.25
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 29,435.48
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 29,435.48
PINACLE-PREV DAY TRANSACTION 40 02 71 1,023 0.0100 10.23 120,449.96
PINACLE-CURRENT DAY TRANSACTION 40 02 74 883 0.0100 8.83 103,966.10
PINACLE INFORMATION REPORTING IMAGE 40 99 99 9 1.1500 10.35 121,862.87
$34.41 $405,149.89
ELECTRONIC DATA INTERCHANGE
ELECTRONIC PAYMENTS RECEIVED 25 02 02 393 0.1100 43.23 508,998.23
REMITTANCE REPORT-PDF 30 99 99 22 3.0000 66.00 777,096.54
ELEC RECEIVABLES REPT MONTHLY MAINT 30 00 20 1 20.0000 20.00 235,483.80
$129.23 $1,521,578.57
TOTAL ANALYZED CHARGES : $1,396.20 $16,439,124.09
TOTAL CHARGES THIS CYCLE : $2,598.80 $16,439,124.09
TOTAL WAIVED CHARGES : $1,202.60 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553362 05/01/2023 to 05/31/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
JUNE 12, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 39,823.13 EARNINGS ALLOWANCE (0.100 %) 3.38
TOTAL ANALYZED CHARGES 178.40
LESS: DEPOSIT FLOAT 0.00 EXCESS/(DEFICIT) FEES 175.02-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 39,823.13
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 39,823.13
COLLECTED BALANCE REQUIRED 2,100,515.51
EXCESS/(DEFICIT) BALANCE 2,060,692.38-
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 40 0.1420 5.68 WAIVED
REGULAR DEPOSIT TICKET 10 02 00 2 0.3000 0.60 7,064.51
DEPOSIT ITEMS-ON US(N) 10 02 20 2 0.0500 0.10 1,177.42
PAID ITEMS 15 01 00 1 0.1500 0.15 1,766.13
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 94,193.52
$14.53 $104,201.58
BRANCH SERVICES
OVER THE COUNTER DEPOSIT TICKETS 10 00 00 2 0.5000 1.00 11,774.19
$1.00 $11,774.19
AUTOMATED CLEARINGHOUSE SERVICES
ACH MONTHLY MAINTENANCE FEE 25 00 00 1 10.0000 10.00 117,741.90
PINACLE ACH FILE PROCESSED 25 05 05 1 5.5000 5.50 64,758.05
PINACLE ACH DEBIT/CREDIT ORIGINATED 25 01 02 1,650 0.0800 132.00 1,554,193.08
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 182,499.95
$163.00 $1,919,192.98
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 29,435.48
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 29,435.48
PINACLE-PREV DAY TRANSACTION 40 02 71 28 0.0100 0.28 3,296.77
PINACLE-CURRENT DAY TRANSACTION 40 02 74 27 0.0100 0.27 3,179.03
$5.55 $65,346.76
TOTAL ANALYZED CHARGES : $178.40 $2,100,515.51
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553362 05/01/2023 to 05/31/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
JUNE 12, 2023
SUMMARY OF ACCOUNT SERVICES
COLLECTED
SERVICE DESCRIPTION AFP CODE VOLUME UNIT PRICE TOTAL PRICE BALANCE REQUIRED
TOTAL CHARGES THIS CYCLE : $184.08 $2,100,515.51
TOTAL WAIVED CHARGES : $5.68 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553389 05/01/2023 to 05/31/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
JUNE 12, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 78,655.86 EARNINGS ALLOWANCE (0.100 %) 6.65
TOTAL ANALYZED CHARGES 29.87
LESS: DEPOSIT FLOAT 383.71 EXCESS/(DEFICIT) FEES 23.22-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 78,272.15
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 78,272.15
COLLECTED BALANCE REQUIRED 351,695.08
EXCESS/(DEFICIT) BALANCE 273,422.93-
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 79 0.1420 11.22 WAIVED
REGULAR DEPOSIT TICKET 10 02 00 1 0.3000 0.30 3,532.26
DEPOSITED ITEMS-TRANSIT 10 02 00 2 0.0500 0.10 1,177.42
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 94,193.52
$19.62 $98,903.20
BRANCH SERVICES
OVER THE COUNTER DEPOSIT TICKETS 10 00 00 1 0.5000 0.50 5,887.10
$0.50 $5,887.10
AUTOMATED CLEARINGHOUSE SERVICES
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 182,499.95
$15.50 $182,499.95
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 29,435.48
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 29,435.48
PINACLE-PREV DAY TRANSACTION 40 02 71 24 0.0100 0.24 2,825.81
PINACLE-CURRENT DAY TRANSACTION 40 02 74 23 0.0100 0.23 2,708.06
$5.47 $64,404.83
TOTAL ANALYZED CHARGES : $29.87 $351,695.08
TOTAL CHARGES THIS CYCLE : $41.09 $351,695.08
TOTAL WAIVED CHARGES : $11.22 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4943553397 05/01/2023 to 05/31/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
JUNE 12, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 203,938.39 EARNINGS ALLOWANCE (0.100 %) 17.32
TOTAL ANALYZED CHARGES 28.95
LESS: DEPOSIT FLOAT 0.00 EXCESS/(DEFICIT) FEES 11.63-
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 203,938.39
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 203,938.39
COLLECTED BALANCE REQUIRED 340,862.81
EXCESS/(DEFICIT) BALANCE 136,924.42-
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 204 0.1420 28.97 WAIVED
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 94,193.52
$36.97 $94,193.52
AUTOMATED CLEARINGHOUSE SERVICES
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 182,499.95
$15.50 $182,499.95
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 29,435.48
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 29,435.48
PINACLE-PREV DAY TRANSACTION 40 02 71 23 0.0100 0.23 2,708.06
PINACLE-CURRENT DAY TRANSACTION 40 02 74 22 0.0100 0.22 2,590.32
$5.45 $64,169.34
TOTAL ANALYZED CHARGES : $28.95 $340,862.81
TOTAL CHARGES THIS CYCLE : $57.92 $340,862.81
TOTAL WAIVED CHARGES : $28.97 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 4944460424 05/01/2023 to 05/31/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
JUNE 12, 2023
CURRENT MONTHLY BALANCE & COMPENSATION
AVERAGE LEDGER BALANCE 569,406.27 EARNINGS ALLOWANCE (0.100 %) 48.32
TOTAL ANALYZED CHARGES 29.80
LESS: DEPOSIT FLOAT 496.42 EXCESS/(DEFICIT) FEES 18.52
_____________ (TRANSFERRED TO : 0011108120 )
AVERAGE COLLECTED BALANCE 568,909.85
LESS: RESERVES( 0.00 %) 0.00
INVESTABLE BALANCE 568,909.85
COLLECTED BALANCE REQUIRED 350,870.88
EXCESS/(DEFICIT) BALANCE 218,038.97
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 569 0.1420 80.80 WAIVED
REGULAR DEPOSIT TICKET 10 02 00 1 0.3000 0.30 3,532.26
DEPOSITED ITEMS-TRANSIT 10 02 00 1 0.0500 0.05 588.71
HYBRID CHECKING MAINTENANCE 01 00 00 1 8.0000 8.00 94,193.52
$89.15 $98,314.49
BRANCH SERVICES
OVER THE COUNTER DEPOSIT TICKETS 10 00 00 1 0.5000 0.50 5,887.10
$0.50 $5,887.10
AUTOMATED CLEARINGHOUSE SERVICES
ACH POSITIVE PAY MONTHLY SERVICE 25 10 50 1 15.5000 15.50 182,499.95
$15.50 $182,499.95
INFORMATION SERVICES
PREVIOUS DAY ACCOUNT 40 02 22 1 2.5000 2.50 29,435.48
CURRENT DAY ACCOUNT 40 02 25 1 2.5000 2.50 29,435.48
PINACLE-PREV DAY TRANSACTION 40 02 71 22 0.0100 0.22 2,590.32
PINACLE-CURRENT DAY TRANSACTION 40 02 74 23 0.0100 0.23 2,708.06
$5.45 $64,169.34
TOTAL ANALYZED CHARGES : $29.80 $350,870.88
TOTAL CHARGES THIS CYCLE : $110.60 $350,870.88
TOTAL WAIVED CHARGES : $80.80 WAIVED
ACCOUNT ANALYSIS STATEMENT
CLIENT NAME & ADDRESS ACCOUNT INFORMATION ANALYSIS PERIOD
CITY OF WESLACO ACCOUNT 0011108120 SUMMARY 05/01/2023 to 05/31/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
JUNE 12, 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- MAY 12,366,913.40 12,321,029.43 .100000 2,219.41 26,131,755.13 13,810,725.70- 1,172.97-
QTR TOTAL 13,585,096.72 13,532,873.63 4,142.16 24,762,609.99 11,229,736.36- 1,883.83-
YTD TOTAL 14,522,369.54 14,474,030.76 .100000 10,773.64 26,099,774.48 11,625,743.72- 4,780.80-
File details come from the government source that posted it. Updated .