ESBD_571773_1793050545956_Attachment A - Activity Detail.xlsx
XLSX spreadsheet 12 KB Posted
- Attached to
- Banking Services
- Solicitation number
- RFP-731-27-001-CJ
- Issued by
- Texas
About this file
This file is an Activity Detail attachment for a Banking Services contract opportunity in Texas, providing a financial summary of account transactions and balances based on the last 90 days as of October 16, 2026. The document details the state or local entity's banking requirements, including a safekeeping balance requirement of $45,000,000 and comprehensive transaction activity across multiple banking functions. Key transaction categories tracked include ACH credits (averaging 222.67 monthly transactions totaling $17,295,352.84), ACH debits (averaging 53.00 monthly transactions totaling $19,873,031.46), checks paid (averaging 272.33 monthly transactions totaling $1,874,879.14), money transfers via wire and other methods, and zero balance account (ZBA) credits and debits. The data is segmented between Operating and Payroll functions to provide visibility into the entity's banking activity patterns.
The financial data reveals significant monthly transaction volumes with total average withdrawals of $67,081,113.99 and total average deposits of $66,643,718.46, demonstrating substantial liquidity management requirements. The most significant transaction categories are wire money transfers (averaging $27,477,913.72 monthly in debits and $1,222,465.13 in credits) and ZBA credits (averaging $34,628,607.01 monthly), indicating the entity's reliance on advanced cash management services. The breakdown between Operating and Payroll functions shows that Operating activities represent the majority of transactions across most categories, while Payroll activities comprise a notable portion of ACH credits and certain wire transfer debits. This activity detail serves as the basis for evaluating the scope and complexity of banking services required to support the entity's operational and payroll processing needs.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ESBD_571773_1793050575690_Attachment B - Historical Rates.xlsx | XLSX spreadsheet | |
| ESBD_571773_1793050501768_RFP-731-27-001-CJ Banking Services.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
Attachment A Safekeeping Balance 45,000,000
| Average Monthly Cost | Balance Required to Offset Costs | |
| ACH Credits |
ACH Debits
Checks Paid
Deposited Items Returned
Detail Credit Adjustments
Detail Deposits
Miscellaneous Credits
Miscellaneous Fees
Money Transfer CR - Other
Money Transfer CR - Wire
Money Transfer DB - Other
Money Transfer DB - Wire
Stop Payment
ZBA Credits
ZBA Debits
Historical Activity Safekeeping Balance 45,000,000
| Monthly Count Average | Monthly Withdrawals Average | Monthly Deposit Averages | |
| ACH Credits | 222.67 | - 0 | 17,295,352.84 |
| Operating | 218.00 | - 0 | 17,283,145.20 |
| Payroll | 4.67 | - 0 | 12,207.64 |
| ACH Debits | 53.00 | 19,873,031.46 | - 0 |
| Operating | 35.00 | 9,431,784.48 | - 0 |
| Payroll | 18.00 | 10,441,246.98 | - 0 |
| Checks Paid | 272.33 | 1,874,879.14 | - 0 |
| Operating | 188.00 | 1,829,378.69 | - 0 |
| Payroll | 84.33 | 45,500.45 | - 0 |
| Deposited Items Returned | 1.33 | 3,226.80 | - 0 |
| Operating | 1.33 | 3,226.80 | - 0 |
| Detail Credit Adjustments | 1.33 | - 0 | 5,724.11 |
| Operating | 0.67 | - 0 | 5,262.33 |
| Payroll | 0.67 | - 0 | 461.77 |
| Detail Deposits | 36.67 | - 0 | 5,294,619.92 |
| Operating | 36.67 | - 0 | 5,294,619.92 |
| Miscellaneous Credits | 1.00 | - 0 | 30,282.78 |
| Operating | 1.00 | - 0 | 30,282.78 |
| Miscellaneous Fees | 1.00 | 4,093.88 | - 0 |
| Operating | 1.00 | 4,093.88 | - 0 |
| Money Transfer CR - Other | 1.67 | - 0 | 8,166,666.67 |
| Operating | 1.67 | - 0 | 8,166,666.67 |
| Money Transfer CR - Wire | 6.67 | - 0 | 1,222,465.13 |
| Operating | 6.67 | - 0 | 1,222,465.13 |
| Money Transfer DB - Other | 1.00 | 5,166,666.67 | - 0 |
| Operating | 1.00 | 5,166,666.67 | - 0 |
| Money Transfer DB - Wire | 18.33 | 27,477,913.72 | - 0 |
| Operating | 15.67 | 24,954,849.41 | - 0 |
| Payroll | 2.67 | 2,523,064.31 | - 0 |
| ZBA Credits | 86.00 | - 0 | 34,628,607.01 |
| Operating | 68.00 | - 0 | 21,950,495.55 |
| Payroll | 18.00 | - 0 | 12,678,111.47 |
| ZBA Debits | 19.33 | 12,681,302.33 | - 0 |
| Operating | 18.67 | 12,680,595.56 | - 0 |
| Payroll | 0.67 | 706.77 | - 0 |
| Grand Total | 722.33 | 67,081,113.99 | 66,643,718.46 |
| based on last 90 days as of October 16, 2026 |
File details come from the government source that posted it. Updated .