October 2023 Analysis Statement.pdf
PDF 75 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 Columbia, South Carolina, dated October 2023. The statement documents the college's relationship summary with its banking institution, detailing the financial position, service charges, and account activity for the month of October 2023. Midlands Technical College maintained an average positive collected balance of $24,926,900.75 during the analysis period, with an investable balance available for services equal to that amount. The institution received earnings on this balance at a rate of 1.65%, generating $34,931.80 in earnings allowance for the month.
The statement itemizes comprehensive banking services utilized by Midlands Technical College, including balance and compensation maintenance, general account services, depository services, paper disbursement services, ACH services, EDI payment services, wire and funds transfer services, and information services. Total analyzed service charges for October 2023 amounted to $3,756.95, with no fee-based charges assessed. The net position for the month was $31,174.85, and interest paid on excess balances totaled $20,405.36 at a rate of 1.08%. A trend analysis covering May through October 2023 demonstrates relatively stable account activity, with the average ledger balance across this six-month period reaching $20,319,044, reflecting consistent cash management and banking service utilization by the institution.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Amendment No. One.pdf | ||
| Attachment A.pdf | ||
| Notice of Award posting.doc | DOC document | |
| Award Extension.pdf | ||
| August 2023 Analysis Statement.pdf | ||
| Administrative Cost Schedule (ACS)_Excel.xlsx | XLSX spreadsheet | |
| Solicitation.pdf | ||
| September 2023 Analysis Statement.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 OCTOBER 2023
Officer:
Phone No.:
MIDLANDS TECHNICAL COLLEGE
PO BOX 2408
COLUMBIA*SC*29202-2408
ANALYSIS SUMMARY
Average Positive Collected Balance......................................... $ 24,926,900.75
Investable Balance Available for Services................................ = 24,926,900.75
Earnings Allowance........................@ 1.65%......................... $ 34,931.80
Net Earnings Allowance................................................. = 34,931.80
Current Month Analyzed Charges............................................ - 3,756.95
Current Month Position............................................................ = 31,174.85
Total Amount Due................................................................... $ 0.00
Interest rate on excess balances: 1.08%
Interest paid on excess balances: $ 20,405.36
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 24,945,193.04 24,926,900.75 0.00 0.00% 3,586.27
0613 MIDLANDS TECHNICAL COLLEGE 0.00 0.00 0.00 0.00% 170.68
* Indicates billing account
SERVICE DETAIL
Svc AFP Service Unit Service
Code Code Description Price Volume Charges
IAMIB 00 0230 RECOUPMENT MONTHLY IB 0.06375 24,945.19 1,590.26
BALANCE & COMPENSATION INFORMATION 1,590.26
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 81.00 14.58
GENERAL ACCOUNT SERVICES 55.58
34235 10 0416 RETN ITEM SUBSCRIPTION PER ACCT 0.00000 3.00 0.00
08052 10 0006 BRANCH DEPOSIT 1.00000 40.00 40.00
12707 10 0610 DEPOSIT LOCATION REPORTING - ITEM 0.05000 198.00 9.90
002 10 0225 DEPOSITED CHECK 0.04000 6.00 0.24
706 10 0224 DESKTOP DEPOSIT-DEPOSITED ITEM 0.03000 127.00 3.81
CK161 10 0006 CASH DEPOSITED IN BRANCH 0.00120 18,276.00 21.93
CK197 10 0040 CASH ORDER FEE IN A BRANCH 9.00000 1.00 9.00
CK141 10 0040 CURRENCY FURNISHED BY BRANCH 0.00300 200.00 0.60
CK064 10 0416 RETURN ITEM SERVICE MTHLY BASE 0.00000 3.00 0.00
DEPOSITORY SERVICES 85.48
34336 15 0724 POSITIVE PAY EXCEPTION - IMAGE 2.00000 5.00 10.00
22222 15 0810 PRINTING & SUPPLIES-VENDOR 0.01000 33,068.00 330.68
12678 15 0300 MICR CHECK REJECTS OVER 2% 1.25000 17.00 21.25
01/26/2024 DDA 200004-2770600 MIDLTECCO0001 OCTOBER 2023 Member FDIC 1/3
MD091 15 0240 PYMT AUTH MAX CHECK MTHLY BASE 5.00000 1.00 5.00
12670 15 0410 STOP PAYMENT - ONLINE 6.00000 50.00 300.00
12812 15 1352 IMAGE VIEW < 90 DAYS - ITEM 1.00000 21.00 21.00
12903 15 0310 POSITIVE PAY EXCEPTIONS - ITEM 5.00000 5.00 25.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 646.00 12.92
22202 15 0100 DDA CHECKS PAID 0.06000 687.00 41.22
64100 15 1357 IFI SETUP PER PRODUCT 0.00000 1.00 0.00
DS191 15 0122 PAYEE VALIDATION STANDARD-ITEM 0.03500 687.00 24.05
22810 15 0500 CHK CASHED FOR NONACCT HOLDER 0.00000 8.00 0.00
DS255 15 1399 PAID CHECK PER ITEM 0.01000 646.00 6.46
22030 15 0412 STOP PAYMENT - AUTO RENEWAL 3.00000 130.00 390.00
PAPER DISBURSEMENT SERVICES 1,227.58
34337 20 0201 CHECK ISSUES-ITEM 0.20000 7.00 1.40
12060 20 0010 ARP MONTHLY BASE - FULL 0.00000 1.00 0.00
12377 20 0201 ARP FULL RECON-ITEM 0.00000 529.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 538.00 0.00
12694 20 0100 OUTGOING TRANSMISSION - PER ITEM 0.01000 648.00 6.48
34350 20 0306 ARP STMT & RPTS MONTHLY BASE 0.00000 1.00 0.00
PAPER DISBURSEMENT RECON SERVICES 12.88
34330 25 0703 ACH SUBSCRIPTION - ACCOUNT 0.00000 8.00 0.00
34332 25 0703 ACH SUBSCRIPTION - ITEM 0.00000 455.00 0.00
CK018 25 0201 ELECTRONIC CREDITS POSTED 0.20000 318.00 63.60
34340 25 0400 ACH RETURN SUBSCRIPTION-ACCOUNT 0.00000 5.00 0.00
34342 25 0400 ACH RETURN SUBSCRIPTION - ITEM 1.50000 6.00 9.00
ES280 25 0000 ACH MONTHLY BASE 30.00000 2.00 60.00
ES211 25 0102 ACH FUTURE DATED ITEM 0.04000 1,424.00 56.96
ES206 25 0120 ACH ORIGINATED - ADDENDA REC 0.05000 15.00 0.75
ES344 25 0202 ACH RECEIVED ITEM 0.10000 332.00 33.20
ES349 25 0220 ACH RECEIVED ADDENDA 0.00000 389.00 0.00
06505 25 0302 ACH RETURN ADMIN -ELECTRONIC 2.50000 1.00 2.50
ES803 25 0500 ACH PAYMENTS ONLINE BATCH RELEASE 0.00000 3.00 0.00
ES801 25 0501 ACH TRANSMISSION CHARGE 7.00000 15.00 105.00
ES230 25 0620 ACH DELETE - ITEM 30.00000 1.00 30.00
ACH1D 25 0102 ACH PAYMENTS FUTURE DATED ITEM 0.04000 8.00 0.32
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 4.00 20.00
06525 25 0302 ACH NOC - ELECTRONIC 6.50000 1.00 6.50
GENERAL ACH SERVICES 473.83
34240 30 0010 EDI PMT DETAIL SUBSC MO BASE 5.00000 2.00 10.00
34242 30 0225 EDI PMT DETAIL - ITEM 0.05000 76.00 3.80
34245 30 0225 EDI PMT DETAIL - ADDENDA ITEM 0.01000 124.00 1.24
EDI PAYMENT SERVICES 15.04
ES030 35 0300 WIRE IN TO USA ACCT-USA DOMESTIC 6.00000 3.00 18.00
ES139 35 0100 WIRE OUT DOMESTIC /API 4.00000 16.00 64.00
WIRE & OTHER FUNDS TRANSFER SERVICE 82.00
34207 40 0274 WIRE TRANSFER RPRT PER ITEM- 0.00000 2.00 0.00
27707 40 0340 SEARCH 0.80000 100.00 80.00
34100 40 0052 PREV DAY REPORTING SUBSCRIPTION 0.00000 3.00 0.00
34115 40 0271 PREV DAY REPORTING ITEMS LOADED 0.10000 1,118.00 111.80
34120 40 0055 INTRADAY REPORTING SUBSCRIPTION 0.00000 3.00 0.00
34121 40 0274 INTRADAY REPORTING ITEMS RPTD 0.00000 57.00 0.00
34123 40 022Z ALERTS SERVICE - EMAIL 0.00000 301.00 0.00
34205 40 0003 WIRE TRANSFER REPORT BASE- 0.00000 3.00 0.00
01/26/2024 DDA 200004-2770600 MIDLTECCO0001 OCTOBER 2023 Member FDIC 2/3
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 12,496.00 12.50
INFORMATION SERVICES 214.30
Total Analyzed Charges 3,756.95
Total Fee Based Charges 0.00
Total Service Charges 3,756.95
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
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
OCT 2023 24,945,193 24,926,901 24,926,901 1.65% 34,932 0 3,757 31,175
AVG 20,319,044 20,296,755 20,296,755
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 OCTOBER 2023 Member FDIC 3/3
File details come from the government source that posted it. Updated .