Attachment A.pdf
PDF 58 KB Posted
- Attached to
- BANKING SERVICES State and local contract opportunity
- Solicitation number
- 5400026609
- Issued by
- Richland County, South Carolina
About this file
Summary
This file consists of Client Analysis Statements for banking services provided to Midlands Technical College by Wells Fargo for the period of August through October 2018. The statements detail the institution's demand deposit account management, cash management services, and various transaction processing services. The college maintained average collected balances ranging from approximately $10.7 million to $20.4 million during this three-month period, with the significant increase in October reflecting seasonal funding patterns typical of academic institutions.
The banking relationship includes comprehensive transaction services encompassing depository operations, check processing, ACH (Automated Clearing House) payments, wire transfers, positive pay services, and information reporting capabilities. Service charges for the analyzed periods ranged from $2,648 to $3,821 monthly, with the college earning interest on excess balances at rates of 0.35% to 0.70%. The college's investable balance was credited with earnings allowances ranging from $2,333 to $12,112 monthly, which were applied against service charges. Specific service categories included general account maintenance, cash vault operations, depository services, paper and electronic disbursement processing, ACH transaction management, wire transfer services, and information systems access. The statements indicate an active operational relationship with stable transaction volumes and consistent utilization of Wells Fargo's full suite of treasury management services.
View the file
Other files for this state and local contract opportunity
| File | Type | Posted |
|---|---|---|
| October 2023 Analysis Statement.pdf | ||
| Amendment No. One.pdf | ||
| Notice of Award posting.doc | DOC document | |
| Award Extension.pdf | ||
| Administrative Cost Schedule (ACS)_Excel.xlsx | XLSX spreadsheet | |
| August 2023 Analysis Statement.pdf | ||
| 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 AUGUST 2018
MIDLANDS TECHNICAL COLLEGE
PO BOX 2408
COLUMBIA, SC 29202-2408
ANALYSIS SUMMARY
Average Positive Collected Balance......................................... $ 10,886,725.78
Investable Balance Available for Services................................ = 10,886,725.78
Earnings Allowance........................@ 0.70%......................... $ 6,472.38
Net Earnings Allowance................................................. = 6,472.38
Current Month Analyzed Charges............................................ - 2,952.29
Current Month Position............................................................ = 3,520.09
Total Amount Due................................................................... $ 0.00
Number of days this cycle: 31
Investable balance required to offset $1.00 of analyzed charges: $ 1,682
Balance required to cover all analyzed charges: $ 4,965,834
Interest rate on excess balances: 0.50%
Interest paid on excess balances: $ 2,514.35
BALANCE SUMMARY
Negative
Account Account Average Average Average Daily Coll Use of Service
Number Name Ledger Collected Negative Coll Fund Rate Charge
MIDLANDS TECHNICAL COLLEGE 10,967,006.17 10,886,725.78 0.00 0.00% 2,760.51
MIDLANDS TECHNICAL COLLEGE 0.00 0.00 0.00 0.00% 191.78
* Indicates billing account
SERVICE DETAIL
Svc AFP Service Unit Service
Code Code Description Price Volume Charges
IAMIB 00 0230 RECOUPMENT MONTHLY IB 0.06375 10,967.01 699.15
BALANCE & COMPENSATION INFORMATION 699.15
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 123.00 22.14
GENERAL ACCOUNT SERVICES 63.14
34235 10 0416 CEO RETN ITEM SUBSCRIPTION PER ACCT 0.00000 3.00 0.00
08008 10 0110 VAULT DEPOSITED COIN - ROLLED 0.00000 5.00 0.00
08132 10 0100 CASH VAULT MONTHLY BASE 0.00000 4.00 0.00
08290 10 0199 CASH VAULT CURRENCY/COIN DEPOSITED 0.00070 393,100.00 275.17
12707 10 0610 DEPOSIT LOCATION REPORTING - ITEM 0.05000 290.00 14.50
001 10 0220 DEPOSITED CHECKS - ON US 0.04000 198.00 7.92
AUGUST 2018 ATTACHMENT A
boothj Highlight boothj Highlight
002 10 0225 DEPOSITED CHECK 0.04000 796.00 31.84
08173 10 0100 CV CASH ONLY OR CHECK ONLY DEPOSIT 0.20000 37.00 7.40
08174 10 0100 CASH VAULT DEPOSIT CASH AND CHECK 1.00000 121.00 121.00
CK197 10 0040 CASH ORDER FEE IN A WF BRANCH 6.50000 3.00 19.50
CK141 10 0040 CURRENCY FURNISHED BY WF BRANCH 0.00220 1,777.00 3.91
CK061 10 0400 RETURN ITEM - CHARGEBACK 3.00000 3.00 9.00
CK064 10 0416 CEO RETURN ITEM SERVICE MTHLY BASE 0.00000 3.00 0.00
CK069 10 0401 RETURN ITEM SPECIAL INSTRUCTIONS 0.35000 3.00 1.05
CK081 10 0401 RETURN ITEM SPECIAL INST MTHLY BASE 10.00000 1.00 10.00
CK075 10 0402 RETURN ITEM REDEPOSITED 3.00000 2.00 6.00
DEPOSITORY SERVICES 507.29
34336 15 0724 POSITIVE PAY EXCEPTION - CEO IMAGE 2.00000 4.00 8.00
22222 15 0810 PRINTING & SUPPLIES-VENDOR 0.01000 9,786.00 97.86
MD091 15 0240 PYMT AUTH MAX CHECK MTHLY BASE 5.00000 1.00 5.00
12670 15 0410 STOP PAYMENT - ONLINE 6.00000 11.00 66.00
12815 15 1352 CEO IMAGE VIEW > 90 DAYS - ITEM 1.00000 4.00 4.00
12903 15 0310 POSITIVE PAY EXCEPTIONS - ITEM 5.00000 4.00 20.00
12907 15 0030 POSITIVE PAY MONTHLY BASE 20.00000 1.00 20.00
22020 15 1350 WELLSIMAGE PAID CHECK MONTHLY BASE 15.00000 1.00 15.00
22015 15 1353 WELLSIMAGE PAID CHECK PER CD 5.00000 1.00 5.00
22019 15 1353 WELLSIMAGE PAID CHECK DELUXE-ITEM 0.02000 520.00 10.40
22202 15 0100 DDA CHECKS PAID 0.06000 424.00 25.44
DS191 15 0122 PAYEE VALIDATION STANDARD-ITEM 0.03500 424.00 14.84
22810 15 0500 WF CHK CASHED FOR NONACCT HOLDER 0.00000 12.00 0.00
DS255 15 1399 WELLSIMAGE PAID CHECK PER ITEM 0.01000 520.00 5.20
22030 15 0412 STOP PAYMENT - AUTO RENEWAL 3.00000 61.00 183.00
PAPER DISBURSEMENT SERVICES 479.74
34337 20 0201 CEO CHECK ISSUES-ITEM 0.20000 4.00 0.80
12060 20 0010 ARP MONTHLY BASE - FULL 0.00000 1.00 0.00
12377 20 0201 ARP FULL RECON-ITEM 0.00000 408.00 0.00
12430 20 0301 ARP OUTPUT - TRANSMISSION 5.00000 1.00 5.00
12604 20 0306 ARP OPTIONAL REPORTS 0.00000 5.00 0.00
12609 20 0310 ARP PAPER STATEMENT/REPORT DELIVERY 20.00000 1.00 20.00
12684 20 0310 ARP PAPER STMT/REPORT MONTHLY BASE 5.00000 1.00 5.00
12687 20 9999 ARP AGED ISSUE RECORDS ON FILE-ITEM 0.00000 269.00 0.00
12694 20 0100 OUTGOING TRANSMISSION - PER ITEM 0.01000 523.00 5.23
34350 20 0306 CEO ARP STMT & RPTS MONTHLY BASE 0.00000 1.00 0.00
PAPER DISBURSEMENT RECON SERVICES 36.03
34330 25 0703 ACH CEO SUBSCRIPTION - ACCOUNT 0.00000 8.00 0.00
34332 25 0703 ACH CEO SUBSCRIPTION - ITEM 0.00000 677.00 0.00
CK018 25 0201 ELECTRONIC CREDITS POSTED 0.20000 512.00 102.40
34340 25 0400 ACH CEO RETURN SUBSCRIPTION-ACCOUNT 0.00000 5.00 0.00
34342 25 0400 ACH CEO RETURN SUBSCRIPTION - ITEM 1.50000 2.00 3.00
ES280 25 0000 ACH MONTHLY BASE 30.00000 2.00 60.00
ES211 25 0102 ACH ONE DAY ITEM 0.04000 133.00 5.32
ES210 25 0102 ACH TWO DAY ITEM 0.04000 1,316.00 52.64
ES206 25 0120 ACH ORIGINATED - ADDENDA REC 0.05000 19.00 0.95
ES344 25 0202 ACH RECEIVED ITEM 0.10000 612.00 61.20
ES803 25 0500 ACH PAYMENTS ONLINE BATCH RELEASE 0.00000 1.00 0.00
ES801 25 0501 ACH TRANSMISSION CHARGE 7.00000 23.00 161.00
ACH1D 25 0102 ACH PAYMENTS ONE DAY ITEM 0.04000 4.00 0.16
34377 25 0000 ACH PAYMENTS BASE FEE 35.00000 2.00 70.00
34333 25 1050 ACH CEO FRAUD FILTER REVIEW MO BASE 8.00000 2.00 16.00
34335 25 1053 ACH CEO FRAUD FILTER REVIEW - ITEM 5.00000 2.00 10.00
ES481 25 0302 ACH NOC - INFO REPORTING ADVICE 3.50000 2.00 7.00
GENERAL ACH SERVICES 549.67
34240 30 0010 CEO EDI PMT DETAIL SUBSC MO BASE 5.00000 2.00 10.00
34242 30 0225 CEO EDI PMT DETAIL - ITEM 0.05000 394.00 19.70
34245 30 0225 CEO EDI PMT DETAIL - ADDENDA ITEM 0.01000 111.00 1.11
EDI PAYMENT SERVICES 30.81
ES191 35 0320 WIRE IN VIA CORRESPONDENT BK-USD/FX 7.00000 2.00 14.00
ES139 35 0100 WIRE OUT DOMESTIC - CEO 4.00000 16.00 64.00
WIRE & OTHER FUNDS TRANSFER SERVICE 78.00
34207 40 0274 CEO WIRE XFR DETAIL US ACCT ITEM 0.00000 82.00 0.00
27588 40 9999 INFOFAX RETURN MONTHLY BASE 25.00000 2.00 50.00
27707 40 0340 CEO SEARCH 0.80000 39.00 31.20
34100 40 0052 CEO PREV DAY REPORTING MAINTENANCE 0.00000 3.00 0.00
34115 40 0272 CEO PREV DAY REPORTING ITEMS LOADED 0.10000 1,239.00 123.90
34120 40 0055 CEO INTRADAY REPORTING MAINTENANCE 0.00000 3.00 0.00
34121 40 0274 CEO INTRADAY REPORTING ITEMS RPTD 0.00000 74.00 0.00
34123 40 022Z CEO EVENT MESSAGING SERVICE - EMAIL 0.00000 398.00 0.00
34205 40 0003 CEO WIRE XFR DETAIL US ACCT MO BASE 0.00000 3.00 0.00
34253 40 0800 INFO REPORTING HISTORY STORAGE 120 0.00000 2,635.00 0.00
34286 40 0271 CEO PREV DAY EXT DETAIL ITEMS RPTD 0.75000 373.00 279.75
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 8,114.00 8.11
INFORMATION SERVICES 502.96
IL151 60 9999 DEPOSITED CHECK ON FOREIGN BANK 5.50000 1.00 5.50
INTERNATIONAL SERVICES 5.50
Total Analyzed Charges 2,952.29
Total Fee Based Charges 0.00
Total Service Charges 2,952.29
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 2018 16,854,105 16,825,011 16,825,011 0.35% 5,001 0 3,916 1,085
APR 2018 11,002,388 10,980,180 10,980,180 0.35% 3,159 0 3,297 (138)
MAY 2018 9,431,537 9,387,863 9,387,863 0.35% 2,791 0 3,375 (584)
JUN 2018 8,126,525 8,111,403 8,111,403 0.35% 2,333 0 2,089 244
JUL 2018 9,591,449 9,563,041 9,563,041 0.35% 2,843 0 2,342 501
AUG 2018 10,967,006 10,886,726 10,886,726 0.70% 6,472 0 2,952 3,520
AVG 10,995,502 10,959,037 10,959,037
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.
RELATIONSHIP SUMMARY SEPTEMBER 2018
MIDLANDS TECHNICAL COLLEGE
PO BOX 2408
COLUMBIA, SC 29202-2408
ANALYSIS SUMMARY
Average Positive Collected Balance......................................... $ 10,677,560.41
Investable Balance Available for Services................................ = 10,677,560.41
Earnings Allowance........................@ 0.70%......................... $ 6,143.25
Net Earnings Allowance................................................. = 6,143.25
Current Month Analyzed Charges............................................ - 2,648.17
Current Month Position............................................................ = 3,495.08
Total Amount Due................................................................... $ 0.00
Number of days this cycle: 30
Investable balance required to offset $1.00 of analyzed charges: $ 1,738
Balance required to cover all analyzed charges: $ 4,602,776
Interest rate on excess balances: 0.50%
Interest paid on excess balances: $ 2,496.48
BALANCE SUMMARY
Negative
Account Account Average Average Average Daily Coll Use of Service
Number Name Ledger Collected Negative Coll Fund Rate Charge
MIDLANDS TECHNICAL COLLEGE 10,696,528.01 10,677,560.41 0.00 0.00% 2,441.73
MIDLANDS TECHNICAL COLLEGE 0.00 0.00 0.00 0.00% 206.44
* Indicates billing account
SERVICE DETAIL
Svc AFP Service Unit Service
Code Code Description Price Volume Charges
IAMIB 00 0230 RECOUPMENT MONTHLY IB 0.06375 10,696.53 681.90
BALANCE & COMPENSATION INFORMATION 681.90
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 85.00 15.30
GENERAL ACCOUNT SERVICES 56.30
34235 10 0416 CEO RETN ITEM SUBSCRIPTION PER ACCT 0.00000 3.00 0.00
08008 10 0110 VAULT DEPOSITED COIN - ROLLED 0.00000 24.00 0.00
08052 10 0006 BRANCH DEPOSIT 0.20000 1.00 0.20
08132 10 0100 CASH VAULT MONTHLY BASE 0.00000 4.00 0.00
08290 10 0199 CASH VAULT CURRENCY/COIN DEPOSITED 0.00070 55,302.00 38.71
12707 10 0610 DEPOSIT LOCATION REPORTING - ITEM 0.05000 212.00 10.60
SEPTEMBER 2018
boothj Highlight
001 10 0220 DEPOSITED CHECKS - ON US 0.04000 28.00 1.12
002 10 0225 DEPOSITED CHECK 0.04000 170.00 6.80
08173 10 0100 CV CASH ONLY OR CHECK ONLY DEPOSIT 0.20000 52.00 10.40
08174 10 0100 CASH VAULT DEPOSIT CASH AND CHECK 1.00000 50.00 50.00
CK197 10 0040 CASH ORDER FEE IN A WF BRANCH 6.50000 2.00 13.00
CK141 10 0040 CURRENCY FURNISHED BY WF BRANCH 0.00220 1,063.00 2.34
CK064 10 0416 CEO RETURN ITEM SERVICE MTHLY BASE 0.00000 3.00 0.00
CK081 10 0401 RETURN ITEM SPECIAL INST MTHLY BASE 10.00000 1.00 10.00
DEPOSITORY SERVICES 143.17
34336 15 0724 POSITIVE PAY EXCEPTION - CEO IMAGE 2.00000 1.00 2.00
12678 15 0300 MICR CHECK REJECTS OVER 2% 1.25000 10.00 12.50
MD091 15 0240 PYMT AUTH MAX CHECK MTHLY BASE 5.00000 1.00 5.00
12670 15 0410 STOP PAYMENT - ONLINE 6.00000 4.00 24.00
12812 15 1352 CEO IMAGE VIEW < 90 DAYS - ITEM 1.00000 4.00 4.00
12815 15 1352 CEO IMAGE VIEW > 90 DAYS - ITEM 1.00000 1.00 1.00
12903 15 0310 POSITIVE PAY EXCEPTIONS - ITEM 5.00000 2.00 10.00
12907 15 0030 POSITIVE PAY MONTHLY BASE 20.00000 1.00 20.00
22020 15 1350 WELLSIMAGE PAID CHECK MONTHLY BASE 15.00000 1.00 15.00
22015 15 1353 WELLSIMAGE PAID CHECK PER CD 5.00000 1.00 5.00
22019 15 1353 WELLSIMAGE PAID CHECK DELUXE-ITEM 0.02000 424.00 8.48
22202 15 0100 DDA CHECKS PAID 0.06000 323.00 19.38
DS191 15 0122 PAYEE VALIDATION STANDARD-ITEM 0.03500 323.00 11.31
22810 15 0500 WF CHK CASHED FOR NONACCT HOLDER 0.00000 4.00 0.00
DS255 15 1399 WELLSIMAGE PAID CHECK PER ITEM 0.01000 424.00 4.24
22030 15 0412 STOP PAYMENT - AUTO RENEWAL 3.00000 73.00 219.00
PAPER DISBURSEMENT SERVICES 360.91
34337 20 0201 CEO CHECK ISSUES-ITEM 0.20000 5.00 1.00
12060 20 0010 ARP MONTHLY BASE - FULL 0.00000 1.00 0.00
12377 20 0201 ARP FULL RECON-ITEM 0.00000 346.00 0.00
12430 20 0301 ARP OUTPUT - TRANSMISSION 5.00000 1.00 5.00
12604 20 0306 ARP OPTIONAL REPORTS 0.00000 5.00 0.00
12609 20 0310 ARP PAPER STATEMENT/REPORT DELIVERY 20.00000 1.00 20.00
12684 20 0310 ARP PAPER STMT/REPORT MONTHLY BASE 5.00000 1.00 5.00
12687 20 9999 ARP AGED ISSUE RECORDS ON FILE-ITEM 0.00000 267.00 0.00
12694 20 0100 OUTGOING TRANSMISSION - PER ITEM 0.01000 425.00 4.25
34350 20 0306 CEO ARP STMT & RPTS MONTHLY BASE 0.00000 1.00 0.00
PAPER DISBURSEMENT RECON SERVICES 35.25
34330 25 0703 ACH CEO SUBSCRIPTION - ACCOUNT 0.00000 8.00 0.00
34332 25 0703 ACH CEO SUBSCRIPTION - ITEM 0.00000 420.00 0.00
CK018 25 0201 ELECTRONIC CREDITS POSTED 0.20000 331.00 66.20
34340 25 0400 ACH CEO RETURN SUBSCRIPTION-ACCOUNT 0.00000 5.00 0.00
34342 25 0400 ACH CEO RETURN SUBSCRIPTION - ITEM 1.50000 7.00 10.50
ES280 25 0000 ACH MONTHLY BASE 30.00000 2.00 60.00
ES211 25 0102 ACH ONE DAY ITEM 0.04000 127.00 5.08
ES210 25 0102 ACH TWO DAY ITEM 0.04000 1,440.00 57.60
ES206 25 0120 ACH ORIGINATED - ADDENDA REC 0.05000 10.00 0.50
ES344 25 0202 ACH RECEIVED ITEM 0.10000 404.00 40.40
06505 25 0302 ACH RETURN ADMIN -ELECTRONIC 2.50000 2.00 5.00
ES803 25 0500 ACH PAYMENTS ONLINE BATCH RELEASE 0.00000 2.00 0.00
ES801 25 0501 ACH TRANSMISSION CHARGE 7.00000 17.00 119.00
ACH1D 25 0102 ACH PAYMENTS ONE DAY ITEM 0.04000 4.00 0.16
34377 25 0000 ACH PAYMENTS BASE FEE 35.00000 2.00 70.00
34333 25 1050 ACH CEO FRAUD FILTER REVIEW MO BASE 8.00000 2.00 16.00
34335 25 1053 ACH CEO FRAUD FILTER REVIEW - ITEM 5.00000 1.00 5.00
ES390 25 1070 ACH WELLS FARGO NOC-INFO REPT ADVIC 0.00000 1.00 0.00
ES481 25 0302 ACH NOC - INFO REPORTING ADVICE 3.50000 2.00 7.00
GENERAL ACH SERVICES 462.44
34240 30 0010 CEO EDI PMT DETAIL SUBSC MO BASE 5.00000 2.00 10.00
34242 30 0225 CEO EDI PMT DETAIL - ITEM 0.05000 27.00 1.35
34245 30 0225 CEO EDI PMT DETAIL - ADDENDA ITEM 0.01000 14.00 0.14
EDI PAYMENT SERVICES 11.49
ES139 35 0100 WIRE OUT DOMESTIC - CEO 4.00000 7.00 28.00
WIRE & OTHER FUNDS TRANSFER SERVICE 28.00
34207 40 0274 CEO WIRE XFR DETAIL US ACCT ITEM 0.00000 33.00 0.00
27588 40 9999 INFOFAX RETURN MONTHLY BASE 25.00000 2.00 50.00
27707 40 0340 CEO SEARCH 0.80000 16.00 12.80
34100 40 0052 CEO PREV DAY REPORTING MAINTENANCE 0.00000 3.00 0.00
34115 40 0272 CEO PREV DAY REPORTING ITEMS LOADED 0.10000 947.00 94.70
34120 40 0055 CEO INTRADAY REPORTING MAINTENANCE 0.00000 3.00 0.00
34121 40 0274 CEO INTRADAY REPORTING ITEMS RPTD 0.00000 46.00 0.00
34123 40 022Z CEO EVENT MESSAGING SERVICE - EMAIL 0.00000 311.00 0.00
34205 40 0003 CEO WIRE XFR DETAIL US ACCT MO BASE 0.00000 3.00 0.00
34253 40 0800 INFO REPORTING HISTORY STORAGE 120 0.00000 2,046.00 0.00
34286 40 0271 CEO PREV DAY EXT DETAIL ITEMS RPTD 0.75000 924.00 693.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 8,213.00 8.21
INFORMATION SERVICES 868.71
Total Analyzed Charges 2,648.17
Total Fee Based Charges 0.00
Total Service Charges 2,648.17
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 2018 11,002,388 10,980,180 10,980,180 0.35% 3,159 0 3,297 (138)
MAY 2018 9,431,537 9,387,863 9,387,863 0.35% 2,791 0 3,375 (584)
JUN 2018 8,126,525 8,111,403 8,111,403 0.35% 2,333 0 2,089 244
JUL 2018 9,591,449 9,563,041 9,563,041 0.35% 2,843 0 2,342 501
AUG 2018 10,967,006 10,886,726 10,886,726 0.70% 6,472 0 2,952 3,520
SEP 2018 10,696,528 10,677,560 10,677,560 0.70% 6,143 0 2,648 3,495
AVG 9,969,239 9,934,462 9,934,462
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
RELATIONSHIP SUMMARY OCTOBER 2018
MIDLANDS TECHNICAL COLLEGE
PO BOX 2408
COLUMBIA, SC 29202-2408
ANALYSIS SUMMARY
Average Positive Collected Balance......................................... $ 20,373,519.05
Investable Balance Available for Services................................ = 20,373,519.05
Earnings Allowance........................@ 0.70%......................... $ 12,112.47
Net Earnings Allowance................................................. = 12,112.47
Current Month Analyzed Charges............................................ - 3,820.90
Current Month Position............................................................ = 8,291.57
Total Amount Due................................................................... $ 0.00
Number of days this cycle: 31
Investable balance required to offset $1.00 of analyzed charges: $ 1,682
Balance required to cover all analyzed charges: $ 6,426,860
Interest rate on excess balances: 0.50%
Interest paid on excess balances: $ 5,922.55
BALANCE SUMMARY
Negative
Account Account Average Average Average Daily Coll Use of Service
Number Name Ledger Collected Negative Coll Fund Rate Charge
MIDLANDS TECHNICAL COLLEGE 20,393,089.53 20,373,519.05 0.00 0.00% 3,615.56
MIDLANDS TECHNICAL COLLEGE 0.00 0.00 0.00 0.00% 205.34
* Indicates billing account
SERVICE DETAIL
Svc AFP Service Unit Service
Code Code Description Price Volume Charges
IAMIB 00 0230 RECOUPMENT MONTHLY IB 0.06375 20,393.09 1,300.06
BALANCE & COMPENSATION INFORMATION 1,300.06
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 119.00 21.42
GENERAL ACCOUNT SERVICES 62.42
34235 10 0416 CEO RETN ITEM SUBSCRIPTION PER ACCT 0.00000 3.00 0.00
08008 10 0110 VAULT DEPOSITED COIN - ROLLED 0.00000 42.00 0.00
08132 10 0100 CASH VAULT MONTHLY BASE 0.00000 4.00 0.00
08290 10 0199 CASH VAULT CURRENCY/COIN DEPOSITED 0.00070 48,937.00 34.26
12707 10 0610 DEPOSIT LOCATION REPORTING - ITEM 0.05000 257.00 12.85
001 10 0220 DEPOSITED CHECKS - ON US 0.04000 66.00 2.64
OCTOBER 2018
boothj Highlight
002 10 0225 DEPOSITED CHECK 0.04000 163.00 6.52
08173 10 0100 CV CASH ONLY OR CHECK ONLY DEPOSIT 0.20000 77.00 15.40
08174 10 0100 CASH VAULT DEPOSIT CASH AND CHECK 1.00000 54.00 54.00
CK197 10 0040 CASH ORDER FEE IN A WF BRANCH 6.50000 1.00 6.50
CK141 10 0040 CURRENCY FURNISHED BY WF BRANCH 0.00220 217.00 0.48
CK061 10 0400 RETURN ITEM - CHARGEBACK 3.00000 2.00 6.00
CK064 10 0416 CEO RETURN ITEM SERVICE MTHLY BASE 0.00000 3.00 0.00
CK069 10 0401 RETURN ITEM SPECIAL INSTRUCTIONS 0.35000 2.00 0.70
CK081 10 0401 RETURN ITEM SPECIAL INST MTHLY BASE 10.00000 1.00 10.00
DEPOSITORY SERVICES 149.35
34336 15 0724 POSITIVE PAY EXCEPTION - CEO IMAGE 2.00000 2.00 4.00
12676 15 0300 MICR CHECK REJECTS THROUGH 1% 0.00000 14.00 0.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
12670 15 0410 STOP PAYMENT - ONLINE 6.00000 60.00 360.00
12812 15 1352 CEO IMAGE VIEW < 90 DAYS - ITEM 1.00000 15.00 15.00
12903 15 0310 POSITIVE PAY EXCEPTIONS - ITEM 5.00000 2.00 10.00
12907 15 0030 POSITIVE PAY MONTHLY BASE 20.00000 1.00 20.00
22020 15 1350 WELLSIMAGE PAID CHECK MONTHLY BASE 15.00000 1.00 15.00
22015 15 1353 WELLSIMAGE PAID CHECK PER CD 5.00000 1.00 5.00
22019 15 1353 WELLSIMAGE PAID CHECK DELUXE-ITEM 0.02000 323.00 6.46
22202 15 0100 DDA CHECKS PAID 0.06000 1,578.00 94.68
DS191 15 0122 PAYEE VALIDATION STANDARD-ITEM 0.03500 1,578.00 55.23
22810 15 0500 WF CHK CASHED FOR NONACCT HOLDER 0.00000 48.00 0.00
DS255 15 1399 WELLSIMAGE PAID CHECK PER ITEM 0.01000 323.00 3.23
22030 15 0412 STOP PAYMENT - AUTO RENEWAL 3.00000 120.00 360.00
PAPER DISBURSEMENT SERVICES 968.60
34337 20 0201 CEO CHECK ISSUES-ITEM 0.20000 2.00 0.40
12060 20 0010 ARP MONTHLY BASE - FULL 0.00000 1.00 0.00
12377 20 0201 ARP FULL RECON-ITEM 0.00000 1,828.00 0.00
12430 20 0301 ARP OUTPUT - TRANSMISSION 5.00000 1.00 5.00
12604 20 0306 ARP OPTIONAL REPORTS 0.00000 5.00 0.00
12609 20 0310 ARP PAPER STATEMENT/REPORT DELIVERY 20.00000 1.00 20.00
12684 20 0310 ARP PAPER STMT/REPORT MONTHLY BASE 5.00000 1.00 5.00
12687 20 9999 ARP AGED ISSUE RECORDS ON FILE-ITEM 0.00000 226.00 0.00
12694 20 0100 OUTGOING TRANSMISSION - PER ITEM 0.01000 327.00 3.27
34350 20 0306 CEO ARP STMT & RPTS MONTHLY BASE 0.00000 1.00 0.00
PAPER DISBURSEMENT RECON SERVICES 33.67
34330 25 0703 ACH CEO SUBSCRIPTION - ACCOUNT 0.00000 8.00 0.00
34332 25 0703 ACH CEO SUBSCRIPTION - ITEM 0.00000 465.00 0.00
CK018 25 0201 ELECTRONIC CREDITS POSTED 0.20000 337.00 67.40
34340 25 0400 ACH CEO RETURN SUBSCRIPTION-ACCOUNT 0.00000 5.00 0.00
34342 25 0400 ACH CEO RETURN SUBSCRIPTION - ITEM 1.50000 4.00 6.00
ES280 25 0000 ACH MONTHLY BASE 30.00000 2.00 60.00
ES211 25 0102 ACH ONE DAY ITEM 0.04000 151.00 6.04
ES210 25 0102 ACH TWO DAY ITEM 0.04000 1,470.00 58.80
ES206 25 0120 ACH ORIGINATED - ADDENDA REC 0.05000 23.00 1.15
ES344 25 0202 ACH RECEIVED ITEM 0.10000 424.00 42.40
06505 25 0302 ACH RETURN ADMIN -ELECTRONIC 2.50000 1.00 2.50
ES803 25 0500 ACH PAYMENTS ONLINE BATCH RELEASE 0.00000 4.00 0.00
ES801 25 0501 ACH TRANSMISSION CHARGE 7.00000 21.00 147.00
ACH1D 25 0102 ACH PAYMENTS ONE DAY ITEM 0.04000 4.00 0.16
ACH2D 25 0102 ACH PAYMENTS TWO DAY ITEM 0.04000 4.00 0.16
34377 25 0000 ACH PAYMENTS BASE FEE 35.00000 2.00 70.00
34333 25 1050 ACH CEO FRAUD FILTER REVIEW MO BASE 8.00000 2.00 16.00
34335 25 1053 ACH CEO FRAUD FILTER REVIEW - ITEM 5.00000 2.00 10.00
ES481 25 0302 ACH NOC - INFO REPORTING ADVICE 3.50000 3.00 10.50
GENERAL ACH SERVICES 498.11
34240 30 0010 CEO EDI PMT DETAIL SUBSC MO BASE 5.00000 2.00 10.00
34242 30 0225 CEO EDI PMT DETAIL - ITEM 0.05000 189.00 9.45
34245 30 0225 CEO EDI PMT DETAIL - ADDENDA ITEM 0.01000 43.00 0.43
EDI PAYMENT SERVICES 19.88
ES191 35 0320 WIRE IN VIA CORRESPONDENT BK-USD/FX 7.00000 1.00 7.00
ES139 35 0100 WIRE OUT DOMESTIC - CEO 4.00000 24.00 96.00
WIRE & OTHER FUNDS TRANSFER SERVICE 103.00
34207 40 0274 CEO WIRE XFR DETAIL US ACCT ITEM 0.00000 104.00 0.00
27588 40 9999 INFOFAX RETURN MONTHLY BASE 25.00000 2.00 50.00
27707 40 0340 CEO SEARCH 0.80000 71.00 56.80
34100 40 0052 CEO PREV DAY REPORTING MAINTENANCE 0.00000 3.00 0.00
34115 40 0272 CEO PREV DAY REPORTING ITEMS LOADED 0.10000 2,163.00 216.30
34120 40 0055 CEO INTRADAY REPORTING MAINTENANCE 0.00000 3.00 0.00
34121 40 0274 CEO INTRADAY REPORTING ITEMS RPTD 0.00000 34.00 0.00
34123 40 022Z CEO EVENT MESSAGING SERVICE - EMAIL 0.00000 455.00 0.00
34205 40 0003 CEO WIRE XFR DETAIL US ACCT MO BASE 0.00000 3.00 0.00
34253 40 0800 INFO REPORTING HISTORY STORAGE 120 0.00000 3,295.00 0.00
34286 40 0271 CEO PREV DAY EXT DETAIL ITEMS RPTD 0.75000 460.00 345.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 7,706.00 7.71
INFORMATION SERVICES 685.81
Total Analyzed Charges 3,820.90
Total Fee Based Charges 0.00
Total Service Charges 3,820.90
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 2018 9,431,537 9,387,863 9,387,863 0.35% 2,791 0 3,375 (584)
JUN 2018 8,126,525 8,111,403 8,111,403 0.35% 2,333 0 2,089 244
JUL 2018 9,591,449 9,563,041 9,563,041 0.35% 2,843 0 2,342 501
AUG 2018 10,967,006 10,886,726 10,886,726 0.70% 6,472 0 2,952 3,520
SEP 2018 10,696,528 10,677,560 10,677,560 0.70% 6,143 0 2,648 3,495
OCT 2018 20,393,090 20,373,519 20,373,519 0.70% 12,112 0 3,821 8,292
AVG 11,534,356 11,500,019 11,500,019
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
File details come from the government source that posted it. Updated .