Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Public Funds Report (FPSDR100)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Public Funds Report (FPSDR100)

Previous pageReturn to chapter overviewNext page  Print this Topic

Availability

Generally, this report is run weekly in the afterhours. Consult your GOLDPoint Systems banking consultant if you want to schedule this report differently.

 

Purpose

The Public Funds Report is used to show accounts that are tied to public funds through the Deposit System. Accounts with a General Category 3, Subcategory 1, or Subcategory 6 will be shown on this report.

 

The report is typically sorted and subtotaled by office and account numbers. No extra sorting options are provided with this report.

 

Report Column Information

See FPSDR100 Example for an example of this report.

 

Column Heading

Description

Account Number

This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) for the account.

Soc Sec Nbr

This is the Social Security number or federal identification number of the person or organization.

IRS Owner Short Name

This is the short name of the IRS owner of the account whose SSN or FIN appears in the column previous.  If the system cannot locate a name for this SSN, "NOT ON FILE" will appear here.

Prod Code

This is the product code used for this account, taken from the Product Code field (DMPDCD) on the Deposit Master Fields screen (function 1/2).

Current Balance

This is the current balance of the account, taken from the Current Balance field (DMCRBL) on the Deposit Master Fields screen (function 1/2).

Accrued Int Thru Today

This is the amount of accrued interest that has been calculated to the run date.

Interest Rate

This is the current interest rate for the account, taken from the Interest Rate field (DMRATE) on the Deposit Master Fields screen (function 1/2).

Date Opened

This is the date on which the account was opened, taken from the Date Opened field (DMDTOP) on the Deposit Master Fields screen (function 1/2).

Maturity Date

This is the maturity date for this account, taken from the Maturity Date field (DMMTDT) on the Deposit Master Fields screen (function 1/2).

Last Mat Roll Dat

This is the last maturity roll date for this account, taken from the Last Maturity Roll Date field (DMLMRD) on the Deposit Master Fields screen (function 1/2).

 

Totals and Subtotals Provided

Institution Totals are provided for the number of public accounts, total account balances, and total accrued interest.

©2021 GOLDPoint Systems. All rights reserved.