September 2023 Analysis Statement.pdf
PDF 74 KB Posted
- Attached to
- BANKING SERVICES State and local contract opportunity
- Solicitation number
- 5400026609
- Issued by
- Richland County, South Carolina
About this file
This is a Client Analysis Statement for banking services provided to Midlands Technical College in South Carolina for the month of September 2023. The statement documents the college's demand deposit account (DDA) relationship with its financial institution, detailing the organization's cash management and banking service utilization during the analyzed period.
The statement reveals that Midlands Technical College maintained an average collected balance of $23,757,110.63 in September 2023, with an investable balance available for services of the same amount. The college earned $32,218.52 in earnings allowance at a rate of 1.65% and incurred total analyzed service charges of $3,136.46 for the month. The account generated interest paid on excess balances of $19,035.53 at a rate of 1.08%. Services utilized included depository services, general account services, paper disbursement services, ACH services, wire and funds transfer services, and information services. The trend analysis spanning April through September 2023 shows the college's average ledger balance ranged from $11,480,548 to $24,684,523, with relatively stable monthly service charges between $2,305 and $3,239. The relationship summary indicates account number 0600 was the primary active account, while a secondary account 0613 showed no activity during the period.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Administrative Cost Schedule (ACS)_Excel.xlsx | XLSX spreadsheet | |
| August 2023 Analysis Statement.pdf | ||
| Solicitation.pdf | ||
| October 2023 Analysis Statement.pdf | ||
| Amendment No. One.pdf | ||
| Attachment A.pdf | ||
| Notice of Award posting.doc | DOC document | |
| Award Extension.pdf |
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
CLIENT ANALYSIS STATEMENT
RELATIONSHIP SUMMARY SEPTEMBER 2023
Officer:
Phone No.:
MIDLANDS TECHNICAL COLLEGE
PO BOX 2408
COLUMBIA*SC*29202-2408
ANALYSIS SUMMARY
Average Positive Collected Balance......................................... $ 23,757,110.63
Investable Balance Available for Services................................ = 23,757,110.63
Earnings Allowance........................@ 1.65%......................... $ 32,218.52
Net Earnings Allowance................................................. = 32,218.52
Current Month Analyzed Charges............................................ - 3,136.46
Current Month Position............................................................ = 29,082.06
Total Amount Due................................................................... $ 0.00
Interest rate on excess balances: 1.08%
Interest paid on excess balances: $ 19,035.53
BALANCE SUMMARY
Negative
Account Account Average Average Average Daily Coll Use of Service
Number Name Ledger Collected Negative Coll Fund Rate Charge
0600 MIDLANDS TECHNICAL COLLEGE 23,772,667.03 23,757,110.63 0.00 0.00% 2,972.06
0613 MIDLANDS TECHNICAL COLLEGE 0.00 0.00 0.00 0.00% 164.40
* Indicates billing account
SERVICE DETAIL
Svc AFP Service Unit Service
Code Code Description Price Volume Charges
IAMIB 00 0230 RECOUPMENT MONTHLY IB 0.06375 23,772.67 1,515.51
BALANCE & COMPENSATION INFORMATION 1,515.51
DS510 01 0020 ZERO BALANCE MASTER ACCOUNT MAINT 15.00000 1.00 15.00
22051 01 0000 ACCT MAINTENANCE 8.00000 2.00 16.00
DS001 01 0021 ZERO BALANCE MONTHLY BASE 10.00000 1.00 10.00
CK021 01 0100 DEBITS POSTED 0.18000 84.00 15.12
GENERAL ACCOUNT SERVICES 56.12
34235 10 0416 RETN ITEM SUBSCRIPTION PER ACCT 0.00000 3.00 0.00
08052 10 0006 BRANCH DEPOSIT 1.00000 37.00 37.00
12707 10 0610 DEPOSIT LOCATION REPORTING - ITEM 0.05000 172.00 8.60
002 10 0225 DEPOSITED CHECK 0.04000 11.00 0.44
706 10 0224 DESKTOP DEPOSIT-DEPOSITED ITEM 0.03000 90.00 2.70
CK161 10 0006 CASH DEPOSITED IN BRANCH 0.00120 9,791.00 11.75
CK197 10 0040 CASH ORDER FEE IN A BRANCH 9.00000 2.00 18.00
CK141 10 0040 CURRENCY FURNISHED BY BRANCH 0.00300 400.00 1.20
CK064 10 0416 RETURN ITEM SERVICE MTHLY BASE 0.00000 3.00 0.00
DEPOSITORY SERVICES 79.69
34336 15 0724 POSITIVE PAY EXCEPTION - IMAGE 2.00000 3.00 6.00
MD091 15 0240 PYMT AUTH MAX CHECK MTHLY BASE 5.00000 1.00 5.00
12505 15 0222 POSITIVE PAY EXCEPTION CHECKS RETND 15.00000 1.00 15.00
01/26/2024 DDA 200004-2770600 MIDLTECCO0001 SEPTEMBER 2023 Member FDIC 1/3
12670 15 0410 STOP PAYMENT - ONLINE 6.00000 8.00 48.00
12812 15 1352 IMAGE VIEW < 90 DAYS - ITEM 1.00000 7.00 7.00
12903 15 0310 POSITIVE PAY EXCEPTIONS - ITEM 5.00000 3.00 15.00
12907 15 0030 POSITIVE PAY MONTHLY BASE 20.00000 1.00 20.00
22020 15 1350 PAID CHECK MONTHLY BASE 15.00000 1.00 15.00
22015 15 1353 PAID CHECK PER CD 5.00000 1.00 5.00
22019 15 1353 PAID CHECK DELUXE-ITEM 0.02000 373.00 7.46
22202 15 0100 DDA CHECKS PAID 0.06000 646.00 38.76
DS191 15 0122 PAYEE VALIDATION STANDARD-ITEM 0.03500 646.00 22.61
22810 15 0500 CHK CASHED FOR NONACCT HOLDER 0.00000 9.00 0.00
DS255 15 1399 PAID CHECK PER ITEM 0.01000 373.00 3.73
22030 15 0412 STOP PAYMENT - AUTO RENEWAL 3.00000 202.00 606.00
PAPER DISBURSEMENT SERVICES 814.56
34337 20 0201 CHECK ISSUES-ITEM 0.20000 6.00 1.20
12060 20 0010 ARP MONTHLY BASE - FULL 0.00000 1.00 0.00
12377 20 0201 ARP FULL RECON-ITEM 0.00000 925.00 0.00
12430 20 0301 ARP OUTPUT - TRANSMISSION 5.00000 1.00 5.00
12604 20 0306 ARP OPTIONAL REPORTS 0.00000 1.00 0.00
12687 20 9999 ARP AGED ISSUE RECORDS ON FILE-ITEM 0.00000 575.00 0.00
12694 20 0100 OUTGOING TRANSMISSION - PER ITEM 0.01000 375.00 3.75
34350 20 0306 ARP STMT & RPTS MONTHLY BASE 0.00000 1.00 0.00
PAPER DISBURSEMENT RECON SERVICES 9.95
34330 25 0703 ACH SUBSCRIPTION - ACCOUNT 0.00000 8.00 0.00
34332 25 0703 ACH SUBSCRIPTION - ITEM 0.00000 453.00 0.00
CK018 25 0201 ELECTRONIC CREDITS POSTED 0.20000 321.00 64.20
34340 25 0400 ACH RETURN SUBSCRIPTION-ACCOUNT 0.00000 5.00 0.00
34342 25 0400 ACH RETURN SUBSCRIPTION - ITEM 1.50000 8.00 12.00
ES280 25 0000 ACH MONTHLY BASE 30.00000 2.00 60.00
ES211 25 0102 ACH FUTURE DATED ITEM 0.04000 1,393.00 55.72
ES206 25 0120 ACH ORIGINATED - ADDENDA REC 0.05000 22.00 1.10
ES344 25 0202 ACH RECEIVED ITEM 0.10000 363.00 36.30
ES349 25 0220 ACH RECEIVED ADDENDA 0.00000 388.00 0.00
06502 25 0302 ACH RETURN ITEM-ELECTRONIC 2.50000 1.00 2.50
06505 25 0302 ACH RETURN ADMIN -ELECTRONIC 2.50000 2.00 5.00
ES803 25 0500 ACH PAYMENTS ONLINE BATCH RELEASE 0.00000 4.00 0.00
ES801 25 0501 ACH TRANSMISSION CHARGE 7.00000 15.00 105.00
ACH1D 25 0102 ACH PAYMENTS FUTURE DATED ITEM 0.04000 12.00 0.48
34377 25 0000 ACH PAYMENTS BASE FEE 35.00000 2.00 70.00
34333 25 1050 ACH FRAUD FILTER REVIEW MO BASE 8.00000 2.00 16.00
34335 25 1053 ACH FRAUD FILTER REVIEW - ITEM 5.00000 2.00 10.00
GENERAL ACH SERVICES 438.30
34240 30 0010 EDI PMT DETAIL SUBSC MO BASE 5.00000 2.00 10.00
34242 30 0225 EDI PMT DETAIL - ITEM 0.05000 6.00 0.30
34245 30 0225 EDI PMT DETAIL - ADDENDA ITEM 0.01000 80.00 0.80
EDI PAYMENT SERVICES 11.10
ES030 35 0300 WIRE IN TO USA ACCT-USA DOMESTIC 6.00000 2.00 12.00
ES139 35 0100 WIRE OUT DOMESTIC /API 4.00000 8.00 32.00
WIRE & OTHER FUNDS TRANSFER SERVICE 44.00
27707 40 0340 SEARCH 0.80000 38.00 30.40
34100 40 0052 PREV DAY REPORTING SUBSCRIPTION 0.00000 3.00 0.00
34115 40 0271 PREV DAY REPORTING ITEMS LOADED 0.10000 1,153.00 115.30
34120 40 0055 INTRADAY REPORTING SUBSCRIPTION 0.00000 3.00 0.00
34121 40 0274 INTRADAY REPORTING ITEMS RPTD 0.00000 5.00 0.00
34123 40 022Z ALERTS SERVICE - EMAIL 0.00000 276.00 0.00
34205 40 0003 WIRE TRANSFER REPORT BASE- 0.00000 3.00 0.00
34420 40 0051 ARP STMTS & RPTS (CSV/EXCEL) BASE 10.00000 1.00 10.00
34421 40 0272 ARP STMTS & RPTS (CSV/EXCEL) / ITEM 0.00100 11,533.00 11.53
INFORMATION SERVICES 167.23
01/26/2024 DDA 200004-2770600 MIDLTECCO0001 SEPTEMBER 2023 Member FDIC 2/3
Total Analyzed Charges 3,136.46
Total Fee Based Charges 0.00
Total Service Charges 3,136.46
TREND ANALYSIS
Investable
Average Average Positive Balance Earnings
Ledger Collected Available Credit Earnings Fee Based Analyzed Monthly
Month Balance Balance for Services Rate Allowance Charges Charges Position
APR 2023 15,634,502 15,612,645 15,612,645 1.65% 21,173 0 2,965 18,208
MAY 2023 11,480,548 11,445,664 11,445,664 1.65% 16,040 0 2,957 13,083
JUN 2023 13,813,608 13,805,644 13,805,644 1.65% 18,723 0 2,305 16,418
JUL 2023 24,684,523 24,673,890 24,673,890 1.65% 34,577 0 3,116 31,461
AUG 2023 23,217,725 23,171,317 23,171,317 1.65% 32,472 0 3,239 29,232
SEP 2023 23,772,667 23,757,111 23,757,111 1.65% 32,219 0 3,136 29,082
AVG 18,767,262 18,744,379 18,744,379
Note: Customer must examine this statement and report to Bank any claim for credit or refund within 60 days after Bank makes the statement available. If Bank does not receive notice of error or discrepancy within this time frame, items on the statement will be deemed to be correct.
01/26/2024 DDA 200004-2770600 MIDLTECCO0001 SEPTEMBER 2023 Member FDIC 3/3
File details come from the government source that posted it. Updated .