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

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 CostBalance 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 AverageMonthly Withdrawals AverageMonthly Deposit Averages
ACH Credits222.67- 017,295,352.84
Operating218.00- 017,283,145.20
Payroll4.67- 012,207.64
ACH Debits53.0019,873,031.46- 0
Operating35.009,431,784.48- 0
Payroll18.0010,441,246.98- 0
Checks Paid272.331,874,879.14- 0
Operating188.001,829,378.69- 0
Payroll84.3345,500.45- 0
Deposited Items Returned1.333,226.80- 0
Operating1.333,226.80- 0
Detail Credit Adjustments1.33- 05,724.11
Operating0.67- 05,262.33
Payroll0.67- 0461.77
Detail Deposits36.67- 05,294,619.92
Operating36.67- 05,294,619.92
Miscellaneous Credits1.00- 030,282.78
Operating1.00- 030,282.78
Miscellaneous Fees1.004,093.88- 0
Operating1.004,093.88- 0
Money Transfer CR - Other1.67- 08,166,666.67
Operating1.67- 08,166,666.67
Money Transfer CR - Wire6.67- 01,222,465.13
Operating6.67- 01,222,465.13
Money Transfer DB - Other1.005,166,666.67- 0
Operating1.005,166,666.67- 0
Money Transfer DB - Wire18.3327,477,913.72- 0
Operating15.6724,954,849.41- 0
Payroll2.672,523,064.31- 0
ZBA Credits86.00- 034,628,607.01
Operating68.00- 021,950,495.55
Payroll18.00- 012,678,111.47
ZBA Debits19.3312,681,302.33- 0
Operating18.6712,680,595.56- 0
Payroll0.67706.77- 0
Grand Total722.3367,081,113.9966,643,718.46
based on last 90 days as of October 16, 2026

File details come from the government source that posted it. Updated .