Opened Account Journal (FPSDR050) |
  
|
Navigation: Deposit Reports > Deposit Reports - Numerical Order >
Opened Account Journal (FPSDR050) |
|
Availability
This report can be run weekly, monthly, or yearly, in the afterhours. Consult your GOLDPoint Systems banking consultant about how you want to schedule this report.
Purpose
The Opened Account Journal lists all accounts opened during the run period. For example, if it is run weekly, it will show all accounts with an opening date occurring in the last week. If run monthly, it will show accounts opened during the last month. Detail lines provide the following information.
•Account number
•Short name of the account owner
•Household number
•Social security number or Tax ID number
•Product Code
•Date Opened
•Teller number of the employee who opened the account (DMOTLR)
•Opening balance
•Interest rate (if interest feature is being used)
•Maturity term, type and maturity date for certificates
•Optionally, the referring teller number
•Optionally, the full name of the IRS account owner
The report is sorted by account number, special sort field 80 (Teller ID).
|
GOLDPoint Systems Only: The miscellaneous options for this report are as follows:
•None: List all accounts opened within the past week •Misc Opt 1: List all accounts opened from the first of the month to the current date. •Misc Opt 2: List all accounts opened in the previous month. •Misc Opt 3: List all accounts opened during the current year. •Misc Opt 4: List all accounts opened in the previous year. •Misc Opt 5: List all accounts opened on the current date only. •Misc Opt 6: Add an extra line for each account showing the referring teller. (This will be line two if Misc Opt 7 is not selected, line three if it is.) •Misc Opt 7: Add an extra line (line two) showing the full name of the IRS account owner. |
|---|
Report Column Information
See FPSDR050 Example for an example of this report.
Column |
Description |
|---|---|
Account Number |
This is the office number (DMACTO), account number (DMACTA), and check digit (DMCKDG) for the account. |
Short Name |
This is the short name of the IRS owner of the account, taken from the CIF System (SHNAME). |
Household Number |
This is the household number in which this account resides, taken from the CIF System (MNHHLD). |
Social Sec/Tax ID Num |
This is the social security number or tax identification number of the IRS owner, taken from the CIF System. |
Prod Code |
This is the product code used for the account, taken from the Product Code field (DMPDCD) 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). |
Teller ID |
This is the teller ID number of the employee who performed the opening transaction for this account (DMOTLR). |
Opening Balance |
This is the opening balance for this account, taken from the Opening Balance field (DMOPBL) on the Deposit Additional Fields screen (function 3/4). |
Rate |
This is the interest rate on the account taken from the Interest Ratefield (DMRATE) on the Deposit Master Fields screen (function 1/2) if this account is an interest bearing account. |
Term/Type |
This is the certificate term and type, taken from the Term fields (DMCTRM and DMTMTP) on the Deposit Master Fields screen (function 1/2). They will only appear on the report for accounts that have the CD (certificate) feature selected. |
Maturity Date |
This is the maturity date, taken from the Maturity Date field (DMMTDT) on the Deposit Master Fields screen (function 1/2). The maturity date will only appear on the report for accounts that have the CD (certificate) feature selected. |
Source of Funds |
This is the source of funds opening the account, taken from the Source of Funds (DMSFND) field on the Miscellaneous Fields screen (function 37/38). This column describes why the customer opened their new account. This column can also be filled in from GOLDTrak I or GOLDTeller Platform. |
Referring Teller |
This is the teller number or employee number of the person who referred this customer to the bank. This information is taken from theReferring Teller field (DMRTLR) on the Miscellaneous Fields screen (function 37/38). It is an optional field and it prints below the rate term and type fields. This appears when miscellaneous option #6 is set. |
Full Name |
This is the full name of the IRS account owner (MNFMXI), which will appear on all accounts for which miscellaneous option #7 is set. This information is taken from the CIF System. |
Totals and Subtotals Provided
Subtotals give a detail of how many opened accounts fall within dollar ranges, then the total dollar amount for each range, and last the average dollar amount for each range. The ranges are:
•0.00 TO 49.99
•50.00 TO 99.99
•100.00 TO 499.99
•500.00 TO 999.99
•1,000.00 TO 2,499.99
•2,500.00 TO 9,999.99
•10,000.00 TO 49,999.99
•50,000.00 TO 99,999.99
•100,000.00 TO 999,999,999,999.99
A total is then given for all accounts within the current subtotal for the number of accounts opened, the total value of the accounts opened, and the average account balance for the accounts opened.
A product code summary is also given at the subtotal level for the number of accounts opened per product code, the total value of the accounts opened per product code, and the average account balance in that product code.
Report Selection Options
The report will default to listing all accounts opened within the last week. Other available options for selecting accounts for this report are as follows:
•All accounts opened from the first of the current month to the current date.
•All accounts opened in the previous month.
•All accounts opened in the current year.
•All accounts opened in the previous year.
•All accounts opened on the run date only.
Miscellaneous Information
If a particular account does not have an 1100 tran code (open account transaction) in its history record, “-NA-” will be printed in the Teller ID column to indicate that the teller ID number for this transaction is not available. This is a rare occurrence and will only appear if history was purged for the date recorded as the Date Opened for this account. The “-NA-” message may also appear if an institution was converted to the GOLDPoint Systems Deposit System without converting all previous history for an account.
If the institution has more than 250 different product codes on which accounts have been opened during a particular cycle, the report will print “PROD CODE TABLE FULL - PLEASE NOTIFY FPS" at the beginning of the report. The program is limited to 250 different product codes. If your institution uses more than 250 product codes per report, GOLDPoint Systems will need to expand the table holding the product code summary information. The number 250 was chosen as large enough to accommodate most institutions while keeping the program size within acceptable limits.
This report can be displayed with the referring teller on a second line. Send in a work order if your institution would like this option.
This report can show the full name of the IRS account owner on a second line. If both the referring teller and the full name are requested, both will appear on the second line. Send in a work order if you institution would like this option.
