RFP2025-2_-_Exhibit_C_-_Feb_2025_Analysis_Statements.pdf

PDF 190 KB Posted

Attached to
Banking Services State and local contract opportunity
Solicitation number
RFP2025-2
Issued by
Broward County, Florida

About this file

The image is an Adobe PDF portfolio welcome screen recommending users open the document in Acrobat X or Adobe Reader X or later, with a graphic of a red and white document folder and the Adobe PDF logo. The screen includes a "Get Adobe Reader Now!" button and instructions for optimal PDF viewing.

There is insufficient content in this initial screen to provide a detailed summary of the banking services contract opportunity. To fully analyze the RFP details, access to subsequent pages of the document would be required.

View the file

Other files for this state and local contract opportunity

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

For the best experience, open this PDF portfolio in

Acrobat X or Adobe Reader X, or later.

Get Adobe Reader Now!

http://www.adobe.com/go/reader

ANALYSIS STATEMENT

BANK OF AMERICA, N.A. Member FDIC

P.O. BOX 15284

WILMINGTON DE 19850

FULL ANALYSIS BUSINESS CKG 01 0042 8117 3553 01 0042 8117 3553

BANK AND COST CENTER NUMBER 075 0001166 075

DATE PREPARED 03-05-25

CITY OF COOPER CITY MONTH ENDING 02-28-25

DEVELOPMENT IMPACT FEES MONTHLY SETTLEMENT 02-28-25

9090 SW 50TH PL SETTLEMENT & ACCOUNT TYPE GROUPED 507

COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC

BALANCE SUMMARY EARNINGS CREDIT SUMMARY

AVG POSITIVE LEDGER BALANCE $ 606,560.51 AVAIL BAL FOR EARNINGS CREDIT $ 606,560.51

__________________ EARNINGS ON AVAILABLE BALANCE 430.40

LESS TOTAL SERVICE CHARGES 194.11

AVG LEDGER BALANCE 606,560.51 __________________

LESS AVG FLOAT .00

__________________ EXCESS ALLOWANCE 236.29

AVG COLLECTED BALANCE 606,560.51 __________________

AVG NEGATIVE COLL BALANCE .00

__________________ PERIOD TO DATE EXCESS ALLOWANCE 236.29

AVG POSITIVE COLL BALANCE 606,560.51 __________________

LESS RESERVES 00% .00 __________________

AVAIL BAL FOR EARNINGS CREDIT 606,560.51

AVAILABLE BALANCE REQUIRED 273,552.70

NET AVAILABLE BALANCE 333,007.81

CURRENT MONTH'S EARNINGS CREDIT RATE = 0.92% CURRENT MONTH'S MULTIPLE = $1,416.92

NUMBER OF UNIT SERVICE BALANCE

SERVICE UNITS PRICE CHARGE REQUIRED

BALANCE RELATED SERVICES

DEPOSIT BANK ASSESSMENT 606,560 101.11 142,490.93

DEPOSITORY SERVICES

ACCOUNT MAINTENANCE 1 27.0000 27.00 38,050.19

GENERAL ACH SERVICES

ACH BLOCKS AUTH INSTRUCTIONS 1 1.0000 1.00 1,409.26

ACH BLOCKS AUTH MAINTENANCE 1 22.0000 22.00 31,003.87

ACCOUNT RECONCILIATION

POSITIVE PAY MAINT- NO RECON 1 43.0000 43.00 60,598.45

IMAGE

CASHPRO IMAGE SUBSCRIPTION 1 .0000 .00 0.00

TOTAL SERVICE CHARGES 194.11 273,552.70

THIS ACCOUNT IS ANALYZED AT THE GROUP LEVEL.

GROUP NUMBER IS 075 0048 4089 8611.

EXHIBIT C

FEBRUARY 2025 ANALYSIS STATEMENT

01 0042 8117 3553 01 0042 8117 3553 075 075

FJSNC FJSNC

THIS PAGE INTENTIONALLY LEFT BLANK

FULL ANALYSIS BUSINESS CKG 01 0048 4089 8611 01 0048 4089 8611

BANK AND COST CENTER NUMBER 075 0001166 075

OPERATING ACCOUNT MONTHLY SETTLEMENT 02-28-25

COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC

AVG POSITIVE LEDGER BALANCE $ .00 AVAIL BAL FOR EARNINGS CREDIT $ .00

__________________ EARNINGS ON AVAILABLE BALANCE .00

LESS TOTAL SERVICE CHARGES 602.40

AVG LEDGER BALANCE .00 __________________

__________________ DEFICIT 602.40

AVG COLLECTED BALANCE .00 __________________

__________________ PERIOD TO DATE DEFICIT 602.40

AVG POSITIVE COLL BALANCE .00 __________________

AVAIL BAL FOR EARNINGS CREDIT .00

AVAILABLE BALANCE REQUIRED 848,942.08

NET AVAILABLE BALANCE 848,942.08-

REQ RESERVES ON NET AVAIL BAL .00

DEFICIT COLLECTED BALANCE 848,942.08

ZBA-SUBSIDIARY ACCOUNT MAINT 1 21.0000 21.00 29,594.59

RETURNS-RECLEAR SERVICES 1 .2000 .20 281.86

DEBITS POSTED-ELECTRONIC 32 .1600 5.12 7,215.44

GENERAL DISB CKS PAID-IMAGE 188 .1700 31.96 45,040.15

ACH REPORTS-ELECTRONIC 4 2.0000 8.00 11,274.13

ACH MONTHLY MAINTENANCE 1 35.0000 35.00 49,324.33

ACH BLOCKS AUTH INSTRUCTIONS 8 1.0000 8.00 11,274.13

ACH OFF US CREDITS 6 .1000 .60 845.56

ACH ON US CREDITS-SAME DAY 7 .1000 .70 986.49

ACH OFF US CREDITS-SAME DAY 27 .5000 13.50 19,025.10

ACH DEBIT RECEIVED ITEM 37 .0200 .74 1,042.86

ACH POSITIVE PAY ACCT MAINT 1 40.0000 40.00 56,370.65

POSITIVE PAY MAINT-PARTIAL 1 65.0000 65.00 91,602.32

FULL ANALYSIS BUSINESS CKG 01 0048 4089 8611 01 0048 4089 8611

BANK AND COST CENTER NUMBER 075 0001166 075

OPERATING ACCOUNT MONTHLY SETTLEMENT 02-28-25

COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC

POSITIVE PAY ITEMS-PARTIAL 188 .0400 7.52 10,597.68

PAYEE POSITIVE PAY ISSUE MATCH 205 .0200 4.10 5,777.99

PAYEE POSITIVE PAY MAINTENANCE 1 1.0000 1.00 1,409.26

EDI SERVICES

PAYMODE CON MTHLY LICENSE 1 100.0000 100.00 140,926.65

PAYMODE CON TRANSACTION 2,282 .1000 228.20 321,594.59

IMAGE ARCHIVE 188 .0253 4.76 6,708.11

TOTAL SERVICE CHARGES 602.40 848,942.08

FULL ANALYSIS BUSINESS CKG 01 0048 4089 8629 01 0048 4089 8629

BANK AND COST CENTER NUMBER 075 0001166 075

PAYROLL ACCOUNT MONTHLY SETTLEMENT 02-28-25

COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC

AVG POSITIVE LEDGER BALANCE $ .00 AVAIL BAL FOR EARNINGS CREDIT $ .00

__________________ EARNINGS ON AVAILABLE BALANCE .00

LESS TOTAL SERVICE CHARGES 172.20

AVG LEDGER BALANCE .00 __________________

__________________ DEFICIT 172.20

AVG COLLECTED BALANCE .00 __________________

__________________ PERIOD TO DATE DEFICIT 172.20

AVG POSITIVE COLL BALANCE .00 __________________

AVAIL BAL FOR EARNINGS CREDIT .00

AVAILABLE BALANCE REQUIRED 242,675.67

NET AVAILABLE BALANCE 242,675.67-

REQ RESERVES ON NET AVAIL BAL .00

DEFICIT COLLECTED BALANCE 242,675.67

ZBA-SUBSIDIARY ACCOUNT MAINT 1 21.0000 21.00 29,594.60

RETURNS-RECLEAR SERVICES 1 .2000 .20 281.85

ACH MONTHLY MAINTENANCE 1 35.0000 35.00 49,324.32

ACH BLOCKS AUTH INSTRUCTIONS 1 1.0000 1.00 1,409.27

ACH BLOCKS AUTH MAINTENANCE 1 22.0000 22.00 31,003.86

POSITIVE PAY MAINT-PARTIAL 1 65.0000 65.00 91,602.31

PAYEE POSITIVE PAY MAINTENANCE 1 1.0000 1.00 1,409.27

FULL ANALYSIS BUSINESS CKG 01 0048 4089 8629 01 0048 4089 8629

BANK AND COST CENTER NUMBER 075 0001166 075

PAYROLL ACCOUNT MONTHLY SETTLEMENT 02-28-25

COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC

TOTAL SERVICE CHARGES 172.20 242,675.67

FULL ANALYSIS BUSINESS CKG 01 0048 4090 0476 01 0048 4090 0476

BANK AND COST CENTER NUMBER 075 0001166 075

BUSINESS CHECKING MONTHLY SETTLEMENT 02-28-25

COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC

AVG POSITIVE LEDGER BALANCE $ 33,758,785.99 AVAIL BAL FOR EARNINGS CREDIT $ 33,676,117.53

__________________ EARNINGS ON AVAILABLE BALANCE 23,896.20

LESS TOTAL SERVICE CHARGES 8,088.40

AVG LEDGER BALANCE 33,758,785.99 __________________

LESS AVG FLOAT 82,668.46

__________________ EXCESS ALLOWANCE 15,807.80

AVG COLLECTED BALANCE 33,676,117.53 __________________

__________________ PERIOD TO DATE EXCESS ALLOWANCE 15,807.80

AVG POSITIVE COLL BALANCE 33,676,117.53 __________________

AVAIL BAL FOR EARNINGS CREDIT 33,676,117.53

AVAILABLE BALANCE REQUIRED 11,398,710.42

NET AVAILABLE BALANCE 22,277,407.11

BALANCE RELATED SERVICES

DEPOSIT BANK ASSESSMENT 33,758,785 5,627.58 7,930,759.46

BANKING CENTER DEPOSIT 97 5.1000 494.70 697,164.09

DEPOSIT CORRECTION-NONCASH-RDS 2 5.3000 10.60 14,938.23

ZBA-DEPOSITORY+ MASTER MAINT 1 41.0000 41.00 57,779.92

ZBA PER TRANSACTION 19 .0200 .38 535.52

RETURNS-CHARGEBACK 1 5.1000 5.10 7,187.26

CHECKS DEPOSITED-BKG CENTER 185 .2200 40.70 57,357.14

DEBITS POSTED-ELECTRONIC 27 .1600 4.32 6,088.03

CREDITS POSTED-ELECTRONIC 209 .1600 33.44 47,125.87

CHECK DEPOSIT-ICL OR RDSO 63 .8000 50.40 71,027.02

IMAGE DEPOSITED ITEMS-RDSO 1,859 .0600 111.54 157,189.58

COMMERCIAL DEPS-CASH VAULT

CURR-COIN DEP-$100-BKG CTR 401 .2200 88.22 124,325.48

ACH REPORTS-ELECTRONIC 13 2.0000 26.00 36,640.93

ACH REPORTS-FAX 5 5.0000 25.00 35,231.66

ACH RETURN ITEM 13 3.5000 45.50 64,121.62

FULL ANALYSIS BUSINESS CKG 01 0048 4090 0476 01 0048 4090 0476

BANK AND COST CENTER NUMBER 075 0001166 075

BUSINESS CHECKING MONTHLY SETTLEMENT 02-28-25

COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC

ACH MONTHLY MAINTENANCE 2 35.0000 70.00 98,648.65

ACH INPUT-FILE 6 20.0000 120.00 169,111.97

ACH BLOCKS AUTH INSTRUCTIONS 49 1.0000 49.00 69,054.05

ACH NOTIF OF CHANGE (NOC) 2 3.5000 7.00 9,864.87

ACH ON US DEBITS 2 .1100 .22 310.04

ACH OFF US DEBITS 1,994 .1100 219.34 309,108.49

ACH ON US DEBITS-SAME DAY 674 .1100 74.14 104,483.01

ACH CREDIT RECEIVED ITEM 203 .0100 2.03 2,860.81

ACH DEBIT RECEIVED ITEM 30 .0200 .60 845.56

ACH POSITIVE PAY ACCT MAINT 1 40.0000 40.00 56,370.66

WIRE TRANSFER

WIRE MONTHLY SUBSCRIPTION 1 38.0000 38.00 53,552.12

PH OR STND ORDER TMPLT STORG 8 .1000 .80 1,127.42

ELEC WIRE OUT-DOMESTIC 7 10.0000 70.00 98,648.65

ELEC WIRE OUT-BOOK DB 3 4.0000 12.00 16,911.20

INCOMING DOMESTIC WIRE 6 10.0000 60.00 84,555.98

CASHPRO GP CUST MNT TMPLT STRG 9 .0000 .00 0.00

POSITIVE PAY MAINT- NO RECON 1 43.0000 43.00 60,598.45

INFORMATION SERVICES

CASHPRO ARP REPORTS 2 25.0000 50.00 70,463.32

CASHPRO ONLINE SUBSCRIPTION 1 55.0000 55.00 77,509.65

CASHPRO REPORTING SUBSCRIPTION 1 7.0000 7.00 9,864.87

CASHPRO ONLINE PDR ACCOUNT 4 16.0000 64.00 90,193.05

CASHPRO ONLINE PDR ITEM 1,457 .1000 145.70 205,330.11

CASHPRO ONLINE CDR ACCOUNT 1 16.0000 16.00 22,548.27

CASHPRO ONLINE CDR ITEM 654 .1000 65.40 92,166.02

REMOTE DEPOSIT SERVICES

REMOTE DEPOSIT ACCOUNT MAINT 1 225.0000 225.00 317,084.94

REMOTE DEPOSIT CHK IMAGE PROC 1,859 .0100 18.59 26,198.27

REMOTE DEPOSIT ITEM STORAGE 94,260 .0000 .00 0.00

IMAGE ARCHIVE 162 .0253 4.10 5,777.99

CASHPRO ONLINE IMAGE RETRIEVAL 3 .0000 .00 0.00

TOTAL SERVICE CHARGES 8,088.40 11,398,710.42

File details come from the government source that posted it. Updated .