RFP2025-2_-_Exhibit_B_-_Jan_2025_Analysis_Statements.pdf

PDF 131 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 a default Adobe PDF portfolio opening screen advising users to open the document in Acrobat X or Adobe Reader X or later, with an Adobe PDF logo and a "Get Adobe Reader Now!" button. There are no contract details visible in this initial screen image.

To proceed with reviewing the actual contract details, the full PDF document would need to be opened and its contents examined. The preliminary metadata suggests this is related to a Banking Services RFP for the City of Cooper City, Florida, but the specific file contents are not viewable in this initial screen image.

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 02-07-25

CITY OF COOPER CITY MONTH ENDING 01-31-25

DEVELOPMENT IMPACT FEES MONTHLY SETTLEMENT 01-31-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 476.52

LESS TOTAL SERVICE CHARGES 194.11

AVG LEDGER BALANCE 606,560.51 __________________

LESS AVG FLOAT .00

__________________ EXCESS ALLOWANCE 282.41

AVG COLLECTED BALANCE 606,560.51 __________________

AVG NEGATIVE COLL BALANCE .00

__________________ PERIOD TO DATE EXCESS ALLOWANCE 282.41

AVG POSITIVE COLL BALANCE 606,560.51 __________________

LESS RESERVES 00% .00 __________________

AVAIL BAL FOR EARNINGS CREDIT 606,560.51

AVAILABLE BALANCE REQUIRED 247,079.86

NET AVAILABLE BALANCE 359,480.65

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

NUMBER OF UNIT SERVICE BALANCE

SERVICE UNITS PRICE CHARGE REQUIRED

BALANCE RELATED SERVICES

DEPOSIT BANK ASSESSMENT 606,560 101.11 128,701.49

DEPOSITORY SERVICES

ACCOUNT MAINTENANCE 1 27.0000 27.00 34,367.91

GENERAL ACH SERVICES

ACH BLOCKS AUTH INSTRUCTIONS 1 1.0000 1.00 1,272.89

ACH BLOCKS AUTH MAINTENANCE 1 22.0000 22.00 28,003.48

ACCOUNT RECONCILIATION

POSITIVE PAY MAINT- NO RECON 1 43.0000 43.00 54,734.09

IMAGE

CASHPRO IMAGE SUBSCRIPTION 1 .0000 .00 0.00

TOTAL SERVICE CHARGES 194.11 247,079.86

THIS ACCOUNT IS ANALYZED AT THE GROUP LEVEL.

GROUP NUMBER IS 075 0048 4089 8611.

EXHIBIT B

JANUARY 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 01-31-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 646.34

AVG LEDGER BALANCE .00 __________________

__________________ DEFICIT 646.34

AVG COLLECTED BALANCE .00 __________________

__________________ PERIOD TO DATE DEFICIT 646.34

AVG POSITIVE COLL BALANCE .00 __________________

AVAIL BAL FOR EARNINGS CREDIT .00

AVAILABLE BALANCE REQUIRED 822,717.00

NET AVAILABLE BALANCE 822,717.00-

REQ RESERVES ON NET AVAIL BAL .00

DEFICIT COLLECTED BALANCE 822,717.00

ACCOUNT MAINTENANCE 1 27.0000 27.00 34,367.92

ZBA-SUBSIDIARY ACCOUNT MAINT 1 21.0000 21.00 26,730.60

RETURNS-RECLEAR SERVICES 1 .2000 .20 254.58

DEBITS POSTED-ELECTRONIC 32 .1600 5.12 6,517.18

GENERAL DISB CKS PAID-IMAGE 204 .1700 34.68 44,143.67

ACH REPORTS-ELECTRONIC 6 2.0000 12.00 15,274.63

ACH MONTHLY MAINTENANCE 1 35.0000 35.00 44,551.00

ACH BLOCKS AUTH INSTRUCTIONS 8 1.0000 8.00 10,183.09

ACH OFF US CREDITS 6 .1000 .60 763.73

ACH ON US CREDITS-SAME DAY 11 .1000 1.10 1,400.17

ACH OFF US CREDITS-SAME DAY 35 .5000 17.50 22,275.51

ACH DEBIT RECEIVED ITEM 39 .0200 .78 992.85

ACH POSITIVE PAY ACCT MAINT 1 40.0000 40.00 50,915.43

POSITIVE PAY MAINT-PARTIAL 1 65.0000 65.00 82,737.58

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

BANK AND COST CENTER NUMBER 075 0001166 075

OPERATING ACCOUNT MONTHLY SETTLEMENT 01-31-25

COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC

POSITIVE PAY ITEMS-PARTIAL 204 .0400 8.16 10,386.75

PAYEE POSITIVE PAY ISSUE MATCH 237 .0200 4.74 6,033.47

PAYEE POSITIVE PAY MAINTENANCE 1 1.0000 1.00 1,272.89

EDI SERVICES

PAYMODE CON MTHLY LICENSE 1 100.0000 100.00 127,288.58

PAYMODE CON TRANSACTION 2,443 .1000 244.30 310,966.00

IMAGE ARCHIVE 204 .0253 5.16 6,568.09

MISCELLANEOUS

PHOTOCOPY-MANUAL 1 15.0000 15.00 19,093.28

TOTAL SERVICE CHARGES 646.34 822,717.00

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

BANK AND COST CENTER NUMBER 075 0001166 075

PAYROLL ACCOUNT MONTHLY SETTLEMENT 01-31-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 219,190.93

NET AVAILABLE BALANCE 219,190.93-

REQ RESERVES ON NET AVAIL BAL .00

DEFICIT COLLECTED BALANCE 219,190.93

ACCOUNT MAINTENANCE 1 27.0000 27.00 34,367.92

ZBA-SUBSIDIARY ACCOUNT MAINT 1 21.0000 21.00 26,730.60

RETURNS-RECLEAR SERVICES 1 .2000 .20 254.57

ACH MONTHLY MAINTENANCE 1 35.0000 35.00 44,551.00

ACH BLOCKS AUTH INSTRUCTIONS 1 1.0000 1.00 1,272.89

ACH BLOCKS AUTH MAINTENANCE 1 22.0000 22.00 28,003.49

POSITIVE PAY MAINT-PARTIAL 1 65.0000 65.00 82,737.58

PAYEE POSITIVE PAY MAINTENANCE 1 1.0000 1.00 1,272.88

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

BANK AND COST CENTER NUMBER 075 0001166 075

PAYROLL ACCOUNT MONTHLY SETTLEMENT 01-31-25

COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC

TOTAL SERVICE CHARGES 172.20 219,190.93

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

BANK AND COST CENTER NUMBER 075 0001166 075

BUSINESS CHECKING MONTHLY SETTLEMENT 01-31-25

COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC

AVG POSITIVE LEDGER BALANCE $ 36,381,249.41 AVAIL BAL FOR EARNINGS CREDIT $ 36,309,477.08

__________________ EARNINGS ON AVAILABLE BALANCE 28,525.32

LESS TOTAL SERVICE CHARGES 8,766.05

AVG LEDGER BALANCE 36,381,249.41 __________________

LESS AVG FLOAT 71,772.33

__________________ EXCESS ALLOWANCE 19,759.27

AVG COLLECTED BALANCE 36,309,477.08 __________________

__________________ PERIOD TO DATE EXCESS ALLOWANCE 19,759.27

AVG POSITIVE COLL BALANCE 36,309,477.08 __________________

AVAIL BAL FOR EARNINGS CREDIT 36,309,477.08

AVAILABLE BALANCE REQUIRED 11,158,180.47

NET AVAILABLE BALANCE 25,151,296.61

BALANCE RELATED SERVICES

DEPOSIT BANK ASSESSMENT 36,381,249 6,064.75 7,719,734.09

ACCOUNT MAINTENANCE 1 27.0000 27.00 34,367.91

BANKING CENTER DEPOSIT 111 5.1000 566.10 720,580.64

DEPOSIT CORRECTION-NONCASH-RDS 1 5.3000 5.30 6,746.29

ZBA-DEPOSITORY+ MASTER MAINT 1 41.0000 41.00 52,188.32

ZBA PER TRANSACTION 21 .0200 .42 534.61

RETURNS-CHARGEBACK 4 5.1000 20.40 25,966.87

CHECKS DEPOSITED-BKG CENTER 151 .2200 33.22 42,285.27

STOP PAY AUTOMATED<=12 MONTHS 4 15.0000 60.00 76,373.15

DEBITS POSTED-ELECTRONIC 31 .1600 4.96 6,313.51

CREDITS POSTED-ELECTRONIC 234 .1600 37.44 47,656.84

CHECK DEPOSIT-ICL OR RDSO 81 .8000 64.80 82,483.00

IMAGE DEPOSITED ITEMS-RDSO 2,277 .0600 136.62 173,901.66

COMMERCIAL DEPS-CASH VAULT

CURR-COIN DEP-$100-BKG CTR 438 .2200 96.36 122,655.28

ACH REPORTS-ELECTRONIC 16 2.0000 32.00 40,732.34

ACH REPORTS-FAX 6 5.0000 30.00 38,186.57

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

BANK AND COST CENTER NUMBER 075 0001166 075

BUSINESS CHECKING MONTHLY SETTLEMENT 01-31-25

COOPER CITY FL 33328-4227 OFFICER NUMBER FJSNC FJSNC

ACH RETURN ITEM 13 3.5000 45.50 57,916.31

ACH MONTHLY MAINTENANCE 2 35.0000 70.00 89,102.00

ACH INPUT-FILE 8 20.0000 160.00 203,661.73

ACH BLOCKS AUTH INSTRUCTIONS 49 1.0000 49.00 62,371.40

ACH NOTIF OF CHANGE (NOC) 4 3.5000 14.00 17,820.40

ACH ON US DEBITS 2 .1100 .22 280.04

ACH OFF US DEBITS 1,985 .1100 218.35 277,934.61

ACH ON US DEBITS-SAME DAY 677 .1100 74.47 94,791.81

ACH CREDIT RECEIVED ITEM 234 .0100 2.34 2,978.55

ACH DEBIT RECEIVED ITEM 32 .0200 .64 814.65

ACH POSITIVE PAY ACCT MAINT 1 40.0000 40.00 50,915.43

WIRE TRANSFER

WIRE MONTHLY SUBSCRIPTION 1 38.0000 38.00 48,369.66

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

ELEC WIRE OUT-DOMESTIC 10 10.0000 100.00 127,288.58

ELEC WIRE OUT-BOOK DB 3 4.0000 12.00 15,274.63

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

POSITIVE PAY MAINT- NO RECON 1 43.0000 43.00 54,734.09

INFORMATION SERVICES

CASHPRO ARP REPORTS 2 25.0000 50.00 63,644.29

CASHPRO ONLINE SUBSCRIPTION 1 55.0000 55.00 70,008.72

CASHPRO REPORTING SUBSCRIPTION 1 7.0000 7.00 8,910.20

CASHPRO ONLINE PDR ACCOUNT 4 16.0000 64.00 81,464.69

CASHPRO ONLINE PDR ITEM 1,571 .1000 157.10 199,970.36

CASHPRO ONLINE CDR ACCOUNT 1 16.0000 16.00 20,366.17

CASHPRO ONLINE CDR ITEM 726 .1000 72.60 92,411.51

GCS TRANSACTION HISTORY 1 .0000 .00 0.00

REMOTE DEPOSIT SERVICES

REMOTE DEPOSIT ACCOUNT MAINT 1 225.0000 225.00 286,399.30

REMOTE DEPOSIT CHK IMAGE PROC 2,278 .0100 22.78 28,996.34

REMOTE DEPOSIT FOREIGN ITEM 1 3.0000 3.00 3,818.66

REMOTE DEPOSIT ITEM STORAGE 104,966 .0000 .00 0.00

IMAGE ARCHIVE 193 .0253 4.88 6,211.68

CASHPRO ONLINE IMAGE RETRIEVAL 18 .0000 .00 0.00

TOTAL SERVICE CHARGES 8,766.05 11,158,180.47

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