August 2023 Analysis Statement.pdf
PDF 73 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 August 2023. The statement details the college's deposit account activity, including average collected balances of $23,171,317.42 and investable balances available for services. The document outlines comprehensive banking services utilized by the institution, including account maintenance, general account services, depository services, paper disbursement services, ACH transaction processing, EDI payment services, wire transfer capabilities, and information reporting services. No specific contract term, renewal options, or response dates are indicated in this financial statement.
Pricing for services is itemized throughout the statement with variable charges based on transaction volumes and service usage. Total analyzed charges for August 2023 amounted to $3,239.43, comprised entirely of service charges with no fee-based charges assessed. The account generated earnings allowance of $32,471.58 at a rate of 1.65% on the investable balance, with interest paid on excess balances at 1.08% totaling $19,133.77. The trend analysis demonstrates fluctuation in average collected balances from March through August 2023, ranging from $11,445,664 to $24,673,890, with corresponding variations in earnings allowance and service charges. As the incumbent provider, the bank processed numerous transaction types including 373 paid checks, 712 ACH items, 494 received ACH items, and multiple wire transfers, reflecting active operational banking requirements for the college.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| Solicitation.pdf | ||
| September 2023 Analysis Statement.pdf | ||
| October 2023 Analysis Statement.pdf | ||
| Amendment No. One.pdf | ||
| Attachment A.pdf | ||
| Notice of Award posting.doc | DOC document | |
| Award Extension.pdf | ||
| Administrative Cost Schedule (ACS)_Excel.xlsx | XLSX spreadsheet |
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 AUGUST 2023
Officer:
Phone No.:
MIDLANDS TECHNICAL COLLEGE
PO BOX 2408
COLUMBIA*SC*29202-2408
ANALYSIS SUMMARY
Average Positive Collected Balance......................................... $ 23,171,317.42
Investable Balance Available for Services................................ = 23,171,317.42
Earnings Allowance........................@ 1.65%......................... $ 32,471.58
Net Earnings Allowance................................................. = 32,471.58
Current Month Analyzed Charges............................................ - 3,239.43
Current Month Position............................................................ = 29,232.15
Total Amount Due................................................................... $ 0.00
Interest rate on excess balances: 1.08%
Interest paid on excess balances: $ 19,133.77
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,217,725.20 23,171,317.42 0.00 0.00% 3,083.51
0613 MIDLANDS TECHNICAL COLLEGE 0.00 0.00 0.00 0.00% 155.92
* 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,217.73 1,480.13
BALANCE & COMPENSATION INFORMATION 1,480.13
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 68.00 12.24
GENERAL ACCOUNT SERVICES 53.24
34235 10 0416 RETN ITEM SUBSCRIPTION PER ACCT 0.00000 3.00 0.00
08052 10 0006 BRANCH DEPOSIT 1.00000 33.00 33.00
12707 10 0610 DEPOSIT LOCATION REPORTING - ITEM 0.05000 186.00 9.30
002 10 0225 DEPOSITED CHECK 0.04000 4.00 0.16
706 10 0224 DESKTOP DEPOSIT-DEPOSITED ITEM 0.03000 208.00 6.24
CK161 10 0006 CASH DEPOSITED IN BRANCH 0.00120 84,854.00 101.82
CK061 10 0400 RETURN ITEM - CHARGEBACK 3.00000 1.00 3.00
CK064 10 0416 RETURN ITEM SERVICE MTHLY BASE 0.00000 3.00 0.00
CK075 10 0402 RETURN ITEM REDEPOSITED 3.00000 1.00 3.00
DEPOSITORY SERVICES 156.52
34336 15 0724 POSITIVE PAY EXCEPTION - IMAGE 2.00000 2.00 4.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 AUGUST 2023 Member FDIC 1/3
12670 15 0410 STOP PAYMENT - ONLINE 6.00000 32.00 192.00
12812 15 1352 IMAGE VIEW < 90 DAYS - ITEM 1.00000 13.00 13.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
12908 15 0310 POS PAY CHECKS WITH NO ISSUE RECORD 0.00000 1.00 0.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 435.00 8.70
22202 15 0100 DDA CHECKS PAID 0.06000 373.00 22.38
DS191 15 0122 PAYEE VALIDATION STANDARD-ITEM 0.03500 373.00 13.06
22810 15 0500 CHK CASHED FOR NONACCT HOLDER 0.00000 1.00 0.00
DS255 15 1399 PAID CHECK PER ITEM 0.01000 435.00 4.35
22030 15 0412 STOP PAYMENT - AUTO RENEWAL 3.00000 180.00 540.00
PAPER DISBURSEMENT SERVICES 872.49
34337 20 0201 CHECK ISSUES-ITEM 0.20000 20.00 4.00
12060 20 0010 ARP MONTHLY BASE - FULL 0.00000 1.00 0.00
12377 20 0201 ARP FULL RECON-ITEM 0.00000 395.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 570.00 0.00
12694 20 0100 OUTGOING TRANSMISSION - PER ITEM 0.01000 438.00 4.38
34350 20 0306 ARP STMT & RPTS MONTHLY BASE 0.00000 1.00 0.00
PAPER DISBURSEMENT RECON SERVICES 13.38
34330 25 0703 ACH SUBSCRIPTION - ACCOUNT 0.00000 8.00 0.00
34332 25 0703 ACH SUBSCRIPTION - ITEM 0.00000 712.00 0.00
CK018 25 0201 ELECTRONIC CREDITS POSTED 0.20000 480.00 96.00
34340 25 0400 ACH RETURN SUBSCRIPTION-ACCOUNT 0.00000 5.00 0.00
ES280 25 0000 ACH MONTHLY BASE 30.00000 2.00 60.00
ES211 25 0102 ACH FUTURE DATED ITEM 0.04000 1,233.00 49.32
ES206 25 0120 ACH ORIGINATED - ADDENDA REC 0.05000 12.00 0.60
ES344 25 0202 ACH RECEIVED ITEM 0.10000 494.00 49.40
ES349 25 0220 ACH RECEIVED ADDENDA 0.00000 495.00 0.00
ES803 25 0500 ACH PAYMENTS ONLINE BATCH RELEASE 0.00000 1.00 0.00
ES801 25 0501 ACH TRANSMISSION CHARGE 7.00000 14.00 98.00
ACH1D 25 0102 ACH PAYMENTS FUTURE DATED ITEM 0.04000 6.00 0.24
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 449.56
34240 30 0010 EDI PMT DETAIL SUBSC MO BASE 5.00000 2.00 10.00
34242 30 0225 EDI PMT DETAIL - ITEM 0.05000 23.00 1.15
34245 30 0225 EDI PMT DETAIL - ADDENDA ITEM 0.01000 101.00 1.01
EDI PAYMENT SERVICES 12.16
ES030 35 0300 WIRE IN TO USA ACCT-USA DOMESTIC 6.00000 1.00 6.00
ES139 35 0100 WIRE OUT DOMESTIC /API 4.00000 6.00 24.00
WIRE & OTHER FUNDS TRANSFER SERVICE 30.00
34207 40 0274 WIRE TRANSFER RPRT PER ITEM- 0.00000 2.00 0.00
27707 40 0340 SEARCH 0.80000 61.00 48.80
34100 40 0052 PREV DAY REPORTING SUBSCRIPTION 0.00000 3.00 0.00
34115 40 0271 PREV DAY REPORTING ITEMS LOADED 0.10000 1,018.00 101.80
34120 40 0055 INTRADAY REPORTING SUBSCRIPTION 0.00000 3.00 0.00
34121 40 0274 INTRADAY REPORTING ITEMS RPTD 0.00000 8.00 0.00
34123 40 022Z ALERTS SERVICE - EMAIL 0.00000 341.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,345.00 11.35
INFORMATION SERVICES 171.95
01/26/2024 DDA 200004-2770600 MIDLTECCO0001 AUGUST 2023 Member FDIC 2/3
Total Analyzed Charges 3,239.43
Total Fee Based Charges 0.00
Total Service Charges 3,239.43
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
MAR 2023 20,837,514 20,801,016 20,801,016 1.65% 29,150 0 2,640 26,510
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
AVG 18,278,070 18,251,696 18,251,696
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 AUGUST 2023 Member FDIC 3/3
File details come from the government source that posted it. Updated .