Schedule_of_Information_-_Exhibit_A.xlsx
XLSX spreadsheet 40 KB Posted
- Attached to
- Banking Treasury Management Services
- Solicitation number
- 2026-GEN-0062
- Issued by
- Sacramento County, San Francisco City, California
About this file
This is a Schedule of Information exhibit for a Banking Treasury Management Services request for proposals issued by the Sacramento County Employees' Retirement System (SCERS) in California. SCERS is soliciting proposals from qualified banking institutions to establish a new comprehensive banking and treasury management services structure. The services include account management across multiple account types (concentration, disbursement, deposit, payroll, and benefit payment accounts), cash management tools (ACH fraud filters, payment authorization, online wires, positive pay with payee validation, and desktop deposit), commercial card services with a credit limit of $55,000 to $75,000, pension administration system support including check printing and ACH processing, and comprehensive online reporting and transaction management capabilities. The organization processes approximately 15,000 monthly pension benefit payments totaling $67.5 million, manages 87 vendor payments averaging $600,000 monthly, handles biweekly employee contribution receipts averaging $15 million, and processes an annual employer contribution of approximately $360 million received in July. The average monthly account balance is $12.5 million with average monthly inflows and outflows of approximately $63.7 million, excluding the July spike.
The selected bank provider must deliver dedicated project management oversight for onboarding and testing, prenote file validation, ACH payment processing, check production in MICR format on approved stock, cleared check file reporting, support for payment voids and reissues, and comprehensive payroll reporting with audit trails. The bank must support multiple withholding types including federal and state taxes, medical, dental, vision, union dues, garnishments, and healthcare fees, with annual adjustments for cost-of-living adjustments and tax changes. Benefit payments include 15,000 electronic fund transfers, 170 physical checks, and approximately 1,150 lump sum payments annually. The implementation will follow phased timelines including file development, initial testing, feedback and revisions, and final production readiness. Multiple users and administrative access to online banking platforms are required to generate customizable reports for specific dates and time ranges to support annual financial reporting preparation.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| SCERS_Banking_RFP_Final.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Acct Structure
| Schedule of Information - Exhibit A |
| Account Structure Relationship |
ZBA
Money Market Mutual Fund Target $100,000 Sacramento County Employees' Retirement System (SCERS) Concentration Account Key Billing Account
• ACH Fraud Filter - Stop
• Payment Authorization
• Online Wires
• Voice Wires
• Commercial Card Services
- AP Control
• Online Alerts
• Online Statements and Notices
• Online Transaction Search
• Online Treasury Information Reporting
- Previous Day Composite
- Sweep Account Position Report
SCERS
Disbursement Account
SCERS
Deposit Account
SCERS
Payroll Account
SCERS
Online Benefit Payment Account
• Online ACH Fraud Filter - Review
• Full ARP with Image Positive Pay
- Payee Validation
- Via SAFE Transmission
• ACH Payments
• ACH Vendor Payments
• Payment Manager
• Online Wires
• Voice Wires
• Previous Day Balance
• Online Transaction Search
• Online Treasury Information Reporting
- ARP Statements and Reports (PDF)
- Previous Day Composite
• ACH Fraud Filter - Stop
• Payment Authorization
• Desktop Deposit
• Online Wires
• Online Statements and Notices
• Online Transaction Search
• Online Treasury Information Reporting
- Intraday Composite
- Previous Day Composite
• Online ACH Fraud Filter - Review
• Full ARP with Image Positive Pay
- Payee Validation
- Via SAFE Transmission
• ACH Direct Origination
• ACH Payments
• Payment Manager
• TAX Payment
• Online Wires
• Voices Wires
• Online Transaction Search
• Online Treasury Information Reporting
- ARP Statements and Reports (PDF)
- Previous Day Composite
• Online ACH Fraud Filter - Review
• Full ARP with Image Positive Pay
- Payee Validation
- Via SAFE Transmission
• Payment Manager
• Online Wires
• Voice Wires
• Online Transaction Search
• Online Treasury Information Reporting
- ARP Statements and Reports (PDF)
- Previous Day Composite
Cash Projections
| Schedule of Information - Exhibit A |
| Cash Projection |
| Respondents are expected to model the proposed account structure to demonstrate optimal cash utilization and maximize earning potential. |
Monthly Cash Position - Average
| Beginning Balance | + | Cash Receipts* | - | Cash Disbursements* | = | Ending Balance |
| $ 12,500,000.00 | $ 70,000,000 | $ 70,000,000 | $ 12,500,000.00 |
Note: *Cash receipts and disbursements exclude the annual prepaid employer contribution of approximately $360 million received each July. Because this is a once-per-year transaction and not representative of normal monthly activity, it has been excluded from the average monthly cash flow figures presented above.
| Cash Receipts | ||
| Description | Frequency/Timing | Amount |
| Pension funding deposit | Monthly (second-to-last business day) | $54,130,000 |
| Contribution receipts | Biweekly | $6,700,000 |
| Contribution receipts (alternate cycle) | Biweekly | $660,000 |
| Deposits (Service Purchase & Others) | Throughout month | $150,000 |
| Interest Income | Quarterly (amount varies each quarter) | $3,000,000 |
| Employer contribution | Annually (July) | $360,000,000 |
| Cash Disbursements | ||
| Description | Frequency/Timing | Amount |
| Pension benefit payroll | Monthly (last business day) | $54,800,000 |
| Payroll tax remittance | Monthly (1st business day of month) | $9,300,000 |
| Medical & other Withholding Remittances | Monthly (5th business day of month) | $3,400,000 |
| SCERS Employee Payroll | Biweekly | $450,000 |
| Contribution Refund & Other benefit payments | Throughout month | $1,000,000 |
| Vendor Payments | Throughout month | $600,000 |
| Employer contribution transfer to investments | Annually (July) | $360,000,000 |
Note: SCERS processes approximately $67.5 million in monthly gross pension payroll, including applicable taxes and other withholding amounts. Monthly contribution receipts average approximately $15 million and provide a significant source of operating cash flow. The remaining funding requirements are met through transfers from the investment portfolio maintained at the custodian bank.
Cash Flow Activity
| Respondents are expected to model the proposed account structure to demonstrate optimal cash utilization and maximize earning potential. | |
| Expected Cash Flow Activity |
Note: The information below is based on actual activity during the prior fiscal year and is provided as a reasonable estimate of expected account activity. Future balances and transaction amounts may vary based on contribution levels, benefit payments, investment activity, and other operational factors.
Average Monthly Balance: $12.5 million
Average Monthly Activity (excluding July):
Inflows: $63.7 million
Outflows: $63.7 million
July activity is significantly higher due to the annual receipt of prepaid employer contributions. During July, average inflows and outflows are approximately $405 million, including an annual employer contribution of approximately $360 million.
| Cash Inflow | |||
| Major Cash Flow Activity | Frequency | Amount | |
| Pension funding deposit | Monthly | $54,800,000 | 62.15 |
| Employer contribution | Annually (July) | $360,000,000 | |
| Contribution receipts | Biweekly | $6,500,000 | |
| Contribution receipts (alternate cycle) | Biweekly | $680,000 | |
| Service Purchase deposits | Throughout month | $140,000 | |
| Total (excluding annual employer contributions) | $62,120,000 |
| Cash Outflow | ||
| Major Cash Flow Activity | Frequency | Amount |
| Pension benefit payroll | Last day of month | $54,800,000 |
| Payroll tax remittance | 1st business day of month | $9,300,000 |
| SCERS Employee Payroll | Biweekly | $450,000 |
| EBO transfer | 5th business day of month | $3,100,000 |
| Other disbursements | Throughout month | $2,300,000 |
| Total | $69,950,000 |
Pension AdminstrationSys
| Schedule of Information - Exhibit A |
| SCERS Pension Administration System |
| Goal: | The selected bank provider will partner with SCERS to enable in-house payroll processing. The selected bank provider will be responsible for printing checks, readiness to support file testing and check validation. |
| Scope of Services: | Dedicated Project Manager/Coordinated to oversee the onboarding, testing and check validation and other related risk management installations; |
| Timely review and feedback on payroll files; | |
| Deliver clear documentation and technical specifications for file fromatting and check processing; | |
| Prenote File Validation: Validate account information prior to initiating live ACH transactions, ensuring accuracy and reducing payment errors as part of Prenote processing; | |
| Process ACH payments: Ensure timely and accurate electronic disbursement of payroll funds, along with generation of payment advice documents for recipients; | |
| Produce Checks: In MICR (Magnetic Ink Character Recognition) and Approved Check Stock. Support physical check issuance that meets industry standards for MICR and approved stock specifications; | |
| Provide Cleared Check Files: Supply cleared check data files that confirm which checks have been processed and settled, supporting reconciliation and audit tracking; | |
| Support Voids and Reissues: Collaborate with LRS and SCERS to define and implement a clear, auditable process for voiding and reissuing payroll payments; | |
| Produce Payroll Reports: Deliver reporting capabilities that align with payroll processing needs, including reconciliation, transaction summaries, and audit trails. | |
| Production Readiness: Confirm successful test results and readiness for production within agreed timeline; | |
| Communication: Maintain consistent communication with LRS, SCERS and interested parties throughout the implementation. |
| File and Check Testing Requirements | Receive and review test payroll files generated from Pension Administration System. |
| Provide secure submission protocols for test files; | |
| Ensure test files are not processed as live production data; | |
| Support iterative testing cycles until final approval is achieved. |
| Timeline Expectations | The implementation will follow these phases: |
| File development; | |
| Initial testing; | |
| Feeback and revisions; | |
| Final approval and production readiness. |
Benefit Payment
| Schedule of Information - Exhibit A |
| Benefit Payment Profile |
| Service Description | Required Service |
| Number of retirees | 15,000 |
| Monthly gross benefit payment amount | $67,500,000 |
| Number of physical check payments | 170 |
| Number of EFTs | 15,000 (254 retirees using more than 1 bank account) |
| Number of lump sum payments | 1,150 (650 death benefits; 500 contribution refunds) |
| Are there any tax forms besides a 1099R required | Federal 945 annual reporting, State DE-09 quarterly reporting, 1099R |
| Other than federal and state taxes, are there other withholdings processed from payments like medical, dental, or life insurance? | In addition to taxes, SCERS withholds amounts for medical, dental, vision, union dues, and arrear advances. An arrear advance is an account setup to recover from beneficiaries' pension after a retiree's death. As well as, garnishments and deductions such as Sacramento County Retiree Employee Association (SCREA) dues and healthcare fees (which is sent to County of Sacramento). |
| Customization provided on the check or ACH (i.e., logo, address)? | No customization provided |
| Foreign Participants/Payment | None |
| Annual Adjustments to either payment or withholding amounts? | Annual adjustments in pension payroll include annual cost of living adjustment (COLA), state taxes and withholding amount adjustments. |
Vendor Payment
| Schedule of Information - Exhibit A |
| SCERS Vendor Information |
| Number of Vendors | 87 |
| Monthly Payment Amount | $600,000 |
| Number of EFTs - Monthly | 37 |
| Number of Checks - Monthly | 50 |
| Customization provided on the check ACH | No |
| Foreign Participants | No |
Commercial Credit Card
| Schedule of Information - Exhibit A | |
| Business Credit Card | |
| Credit limit | $55,000 (matches current AMEX ; or $75,000 the CEO delegated authority amount: |
| https://www.scers.gov/post/ceo-delegated-authority-policy-expenses |
https://www.scers.gov/post/ceo-delegated-authority-policy-expenses Online Report Access
| Schedule of Information - Exhibit A |
| SCERS Online Banking Report Access Requirements* |
| Products/Services |
| Commercial Card Expense Reporting |
| Commercial Electronic Office |
| ACH Payments |
| Alerts |
| Fraud Manager ACH Fraud Filter |
| Fraud Manager ARP Register Maintenance |
| Fraud Manager Image Positive Pay |
| Image |
| Statements & Notices |
| Transaction Search |
| Treasury Information Reporting |
| Virtual Card Payments |
| Wires |
| SAFE Transmission |
| Sweep & Fed Funds Statements & Confirmations |
| Desk Top Deposit |
| Tax Payments |
| Item Detail Inquiry Service |
| Payment Manager |
| *Multiple users and Admin Access |
Ability to generate reports for specific dates or customizable time ranges, with integrated expense categorization to facilitate accurate and efficient preparation of the annual financial report.
File details come from the government source that posted it. Updated .