Deposit Reports > Deposit Reports - Numerical Order

Availability

This report can be run daily, monthly, or quarterly in the afterhours, based on a specified list of products or deposit account types.

Purpose

This report shows balance and activity information for all open deposit accounts with product codes or account types you specify in the misc parm field. The report can show up to 12 different codes. The daily report uses the deposit (DM), CIF (MN), and transaction log (TG) records, and shows each day’s activity, month-end balance, month-to-date activity, current balance, and available balance. The monthend report uses the deposit (DM) and CIF (MN) records, and shows the beginning-of-month balance, the current balance, the available balance, and the month’s activity. The quarterly report also uses the deposit (DM) and CIF (MN) records, and shows the month’s activity, the year-end balance, year-to-date activity, the current balance, and the available balance.

Accounts can be selected by deposit type, product code, or any other standard selection field.

The report can be sorted by standard sorts (e.g., account number, office number, etc.) as well as by Account Representative Code.

	GOLDPoint Systems Only: To set a BAI file to report current-day, interim data, the Misc Opts 1 field must be set to "Y." This will cause the file to report all the day’s activity for every account up to the time the file is created. This option should only be run upon an institution's request; it is not meant to be run daily.

Report Column Information

See the Business Banking Tracking Report - Daily Run (FPSDR180) example.

Daily Run

Column	Description
Account Number	This column displays the office number (DMACTO), account number (DMACTA), and the check digit (DMCKDG) for the account.
Short Name	This is the short name of the IRS account owner (SHNAME), pulled from the CIF System.
Product Code	This is the product code used for this account. It is pulled from theProduct Code field (DMPDCD).
Today's Activity	This is the total amount the account balance changed on the date the report was run. It is a calculated field using transaction log records and the Current Balance field (DMCRBL) on the Deposits > Account Information > Account Information screen in CIM GOLD.
Monthend Balance	This is the account balance at last monthend. It is pulled from theMonthend Balance field (DMMEBL) on the Deposits > Account Information > Additional Fields screen in CIM GOLD.
Month-to-date Activity	This is the total amount the account balance has changed from the date the report was run since the last monthend date.
Current Balance	This is the current balance of the account. It is pulled from the Current Balance field (DMCRBL) on the Deposits > Account Information > Account Information screen in CIM GOLD.
Available Balance	This is the available balance of the account on the date the report was run. It is pulled from the Available Balance field (WKAVLB) on the Deposits > Account Information > Account Information screen in CIM GOLD.
Acct Rep	This is the account representative code for this account. It is pulled from the Account Representative field (DMOFCD) on the Deposits > Account Information > Account Information screen in CIM GOLD. Note: When Misc Opts 1 is set, the account representative code will be replaced by the last four digits in the user-defined field #4 on the same screen.

Monthend Run

Column	Description
Account Number	This column displays the office number (DMACTO), account number (DMACTA), and the check digit (DMCKDG) for the account.
Short Name	This is the short name of the IRS account owner (SHNAME), pulled from the CIF System.
Product Code	This is the product code used for this account. It is pulled from theProduct Code field (DMPDCD).
Blank	The monthly report does not contain an amount in this column.
Beginning-of-month Balance	This is the account balance at the beginning of the month. It is pulled from the Monthend Balance field (DMMEBL) on the Deposits > Account Information > Additional Fields screen.
Activity this Month	This is the total amount the account balance has changed from the beginning of the month to the end of the month.
Current Balance	This is the current balance of the account. It is pulled from the Current Balance field (DMCRBL) on the Deposits > Account Information > Account Information screen in CIM GOLD.
Available Balance	This is the available balance of the account on the date the report was run. It is pulled from the Available Balance field (WKAVLB) on the Deposits > Account Information > Account Information screen in CIM GOLD.
Acct Rep	This is the account representative code for this account. It is pulled from the Account Representative field (DMOFCD) on the Deposits > Account Information > Account Information screen in CIM GOLD. Note: When Misc Opts 1 is set, the account representative code will be replaced by the last four digits in the user-defined field #4 on the same screen.

Quarterly Run

Column	Description
Account Number	This column displays the office number (DMACTO), account number (DMACTA), and the check digit (DMCKDG) for the account.
Short Name	This is the short name of the IRS account owner (SHNAME), pulled from the CIF System.
Product Code	This is the product code used for this account. It is pulled from theProduct Code field (DMPDCD).
Month-to-date Activity	This is the total amount the account balance has changed from the beginning to the end of the last month in the quarter for which the report was run.
Year-end Balance	This is the account balance at last year-end. It is pulled from the Year-End Balance field (DMEYBL) on the Deposits > Account Information > Additional Fields screen in CIM GOLD.
Year-to-date Activity	This is the total amount the account balance has changed from the beginning of the current calendar year to the end of the quarter in which the report was run.
Current Balance	This is the current balance of the account. It is pulled from the Current Balance field (DMCRBL) on the Deposits > Account Information > Account Information screen in CIM GOLD.
Available Balance	This is the available balance of the account on the date the report was run. It is pulled from the Available Balance field (WKAVLB) on the Deposits > Account Information > Account Information screen in CIM GOLD.
Acct Rep	This is the account representative code for this account. It is pulled from the Account Representative field (DMOFCD) on the Deposits > Account Information > Account Information screen in CIM GOLD. Note: When Misc Opts 1 is set, the account representative code will be replaced by the last four digits in the user-defined field #4 on the same screen.

Totals and Subtotals Provided

Totals are provided in the following categories:

•Number of accounts

•Account activity for today (daily report) or this month-to-date (quarterly)

•Account balance as of the beginning of this month (monthly), the end of last month (daily), or the beginning of the current calendar year (quarterly)

•Activity month-to-date (daily and monthly) or year-to-date (quarterly)

•Account current balances

•Account available balances

Business Banking Tracking Report (FPSDR180)

Business Banking Tracking Report (FPSDR180)