Holiday Hours
Quick Start for:
Finances & Economy
A group of professional looking Pooled Collateral participants

Participant Instructions

V.1.0 - September 1, 2010


PROGRAM OVERVIEW

Under existing Texas law, a depository institution must pledge security to collateralize deposits of public funds by a public entity in excess of federal deposit limits. The current system requires that each public entity's deposits be collateralized individually, even if a depository institution holds deposits from several different public entities. The new Pooled Collateral Program provides an alternative to the current system by allowing a depository institution to pool collateral for public entities, and requires the Comptroller to regulate and monitor the Program. Under this Program, the Comptroller ensures that the securities pledged as collateral have a market value greater than the deposits.


WEBSITE NAVIGATION FOR BANKS

  1. Go to your web browser and type texasenterpriseportal and hit enter.
  2. Type in the User ID and password that you have been assigned.

website navigation for banks

REPORTING

Daily Report: This report will be the prior business day's aggregate ledger balance of deposits of public funds. The report will be itemized by each public entity and account. The report will indicate whether each account is interest bearing or non-interest bearing so that the proper federal deposit insurance may be calculated.

Follow the steps below to submit a daily report by 9:00 a.m. CT each weekday morning:

  1. At the top left hand side you will find a box titled “Banking Links.”
  2. Select “Bank Daily Balance Load” in order to submit a daily file.
Reporting
  1. You will come to a page that has an open text box where you are able to paste your report.
Reporting

(Please see the example below for the format)


Daily Report File Format


1 Detail record (field Length 1)
111002501 Parent Bank Routing number (field length 9)
20100630 Statement date YYYYMMDD (field length 8)
123456789 Public Entity Taxpayer ID (field length 9)
N Bank Account Type (field length 1) – N = Non-Interest, I = Interest
   
0128 Public Entity Last 4 Digits Account Number (field length 4)
1110000 Balance (field length 15)
9 Summary record (field length 1)
111002501 Parent Bank Routing number (field length 9)
20100630 Statement date YYYYMMDD (field length 8)
1110000 Total Non-Interest Balance (field length 15)
3330000 Total Interest Balance (field length 15)



Sample Daily File


1 11100250120100630123456789N   0128 1110000
1 11100250120100630123456789I   0128 3330000
9 11100250120100630     1110000 3330000  


  1. After pasting your report select “Validate Format” to ensure that file is formatted correctly.
Validate Format

  1. A box will appear telling you that the format is valid. Then click on the link at the bottom of the page titled “Review Daily Balance.”
Review Daily Balance

  1. In the “Daily Balance Load Validation” page, you are able to see the upload in a table format. Once the information is verified click "Submit Data" on the bottom left side of the page.
Daily Balance Load Validation

  1. A box will appear with your confirmation number letting you know that the data has been downloaded.
Image Confirmation

Loading Weekly and Monthly Reports

Weekly Summary Report (to be submitted each Monday morning):
This report will be the total par and market value of collateral held by a custodian trustee on its behalf. The participating depository institution may either report the market value itself or adopt by reference the Comptroller's daily report indicating the market value of the collateral for the due date of the weekly report.

Monthly Report (to be submitted on the first working day of the month):
This report will list the collateral instruments held by a custodian trustee on behalf of the participating depository institution, together with the par and market value of the securities with their CUSIP numbers (if applicable).

Follow the steps below to submit a weekly or monthly report:

  1. At the top left hand side you will find a box titled “Banking Links.”
  2. Select “Bank Report Load” in order to submit a weekly or monthly file.
Bank Report Load

  1. You will come to a page that has an open text box where you are able to paste your report.
Bank Report Load

(Please see the example below for the format)


Weekly and Monthly Report File Format


111002501 Parent Bank Routing Number (field length 9)
111905227 Custodian Routing Number (field length 9)
W Report Type (field length 1) W = Weekly, M = Monthly
20100630 Date YYYYMMDD (field length 8)
3133TP789 CUSIP ID (field length 9). This field will be empty for weekly report which only provides total value per Bank ID / Custodian.
99505 PAR Value (field length 15)
87698 Market Value (field length 15)



Sample Weekly File


111002501111905227W20100630 99505 87698



Sample Monthly File


111002501111905227M201006303133TP789 99505 87698


  1. After pasting your report select “Validate Format” to ensure that file is formatted correctly.
Validate Format

  1. A box will appear telling you that the format is valid. Then click on the link at the bottom of the page titled “Bank Report Load.”
Bank Report Load

  1. In the “Bank Report Load Validation” page, you are able to see the upload in a table format. Once the information is verified click “Submit Data” on the bottom left side of the page.
Bank Report Load Validation

  1. A box will appear with your confirmation number letting you know that the data has been downloaded.
Confimation Number

The Comptroller will also provide a daily report on the market value of the collateral held in each pool on its Web site.


PAGELET DESCRIPTIONS


Bank Collateral Summary

This page shows a summary of many different tables pertaining to the collateral that has been pledged by the bank.

If you select Show Details you see the following:

  1. “Totals for Selected Bank” shows you an aggregate amount of collateral that is pledged by Par, Market, and Collateral value.
  2. “Collateral Summary” breaks down that total amount into which custodians are actually holding collateral for the bank and the total dollar amounts.
  3. “Collateral Detail” gives you a description of every piece of collateral that is being used along with the value of what it is worth.
Collateral Details

Bank Balance Summary

This link has a list of all the Public Entities that are participating in the Pooled Program.

If you select Show Details you see the following:

Show Details

Bank Statement Confirmation

On this page you will see all reports that you have submitted by confirmation number.

If you select Show Details you see the following:

Show Details

BANKING LINKS

Public Entity Bank Balance Entry
This screen allows you to input data into a table that creates a file upload.
Collateral Inquiry
This page shows a summary of many different tables pertaining to the collateral that has been pledged by the bank.
Bank Report Load
Is an open text box where you are able to paste your file from an excel spreadsheet and submit for validation for the weekly and monthly report.
Bank Daily Balance Load
Is an open text box where you are able to paste your file from an excel spreadsheet and submit for validation for the Daily report.
Bank Confirmation Review
On this page you will see all reports that you have submitted by confirmation number.

For Further Information

If you have any questions about the Pooled Collateral Program, please feel free to contact our staff at (800) 531-5441, extension 3-6069 or 3-5902, or you may dial directly at (512) 463-6069 or (512) 463-5902.

You may also email any questions to:

collateral@cpa.state.tx.us

Required Plug-ins