Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Daily Deposit Accrued Interest Download (FPSDR192)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Daily Deposit Accrued Interest Download (FPSDR192)

Previous pageReturn to chapter overviewNext page  Print this Topic

Availability

This report should be run daily in the afterhours. It also must be downloaded every day to be useful.

 

Purpose

This report lists all open accounts based on the general category criteria selected, which generally should only be interest-bearing accounts. Closed and unopened accounts are excluded from this report. This is a comma-delimited file only; no report is produced. Totals and headings will not appear. The file will be placed in the GOLDPoint Systems transfer program, File Transfer Utility, in the data staging area for download and viewing in any compatible PC product (such as Microsoft® Excel). The file is replaced each day with the new data. If a download is missed, it cannot be returned on a later date.

 

The following fields appear in the file download:

 

Account number

Current balance

Interest rate

Product code

Interest accrued through today

Carriage Return and Line Feed (CR/LF) at the end of each record

 

The file can be sorted by office number and account number.

 

honeycombgoldgpsonly

GOLDPoint Systems Only: The Sort Key Fields Order for this report must be "1" and "2."

 

The Critical field must be "1" to "4."

 

Report Column Information

See FPSDR192 Example for an example of this report.

 

Column

Description

Account Number

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

Current Balance

This column displays the current balance of the account, pulled from the Current Balance field (DMCRBL) on the Deposits > Account Information > Account Information screen in CIM GOLD.

Interest Rate

This column displays the interest rate of the account, pulled from theInterest Rate field (DMRATE) on the Features/Options tab of the Deposits > Account Information > Account Information screen in CIM GOLD.

Product Code

This column displays the product code of the account, pulled from theProduct Code field (DMPDCD).

Interest Accrued Through Today

This column displays the interest amount accrued through the day the report is produced, pulled from the Interest Accrued to Today field on the Features/Options tab of the Deposits > Account Information > Account Information screen in CIM GOLD.

 

Totals and Subtotals Provided

No totals are provided in the file.

©2021 GOLDPoint Systems. All rights reserved.