Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Short Trial Balance (FPSDR030)

Navigation:  Deposit Reports > Deposit Reports - Numerical Order >

Short Trial Balance (FPSDR030)

Previous pageReturn to chapter overviewNext page  Print this Topic

Availability

This report is generally run daily in the afterhours. Consult your GOLDPoint Systems banking consultant if you want to schedule this report differently.

 

Purpose

The Short Trial Balance lists the following information for all open accounts.

 

Account number

Current balance

Accrued interest

Accrued date

Date last active

Uncollected funds

Deposit Delay

Payable balance

Product code

Hold codes

 

This report is typically sorted by account number.

 

Report Column Information

See FPSDR030 Example for an example of this report.

 

Account Number

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

Current Bal

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

This is the amount of accrued interest that has not been posted to the account yet.  This information is taken from the Accrued Interest field (DMACRI) on the Deposit Interest Fields screen (function 9/10).

Accr Dt

This is the date interest is accrued to, taken from the Dt Accrd To field (DMDTAC) on the Deposit Interest Fields screen (function 9/10).

Lst Actv

This is the date of last activity on this account, taken from the Last Actv field (DMDTLA) on the Deposit Master Fields screen  (function 1/2).

Uncoltd Funds

This is the total of all checks that have been deposited with a local or non-local hold still in effect.  This information is taken from the Uncoll Funds field (DMUFCH) on the Deposit Master Fields screen (function 1/2).  The length of time that funds are uncollected is determined by institution options.

Deposit Delay

This shows the amount which is being delayed from accruing interest.  Check deposits are placed into the account and affect the account balance.  However, no interest is accrued on the check deposit until the deposit delay period has expired, which is typically only a few days.

Payable Bal

This is the payable balance on an account.  This is calculated with the following formula:

 current balance

- minimum balance

- uncollected funds

- all monetary hold amounts (if used)

- over-the-counter checks (if any)

Any amounts being used to secure deposit loans are not yet included in this calculation.

Prod

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).

Hld Cd

This is the first hold code on the account, taken from the Code column (DMHACC) on the Hold/Action Codes screen (function 11/12).

 

Totals and Subtotals Provided

Institution totals are provided for the following:

 

Total number of records read

Total balance of all accounts on report

Total accrued interest amount of all accounts on report

Total uncollected funds amount of all accounts on report

Total deposit delays for all accounts

Total payable balance of all accounts on report

 

Subtotals by office can be provided if desired. Consult your customer service representative.

©2021 GOLDPoint Systems. All rights reserved.