Generating Cash Sweep Reports

This topic describes the page navigation and usage of each cash sweep report.

Page Name

Definition Name

Usage

Cash Sweep Structure Page

RUN_TRX5000

Run the Cash Sweep Structure report (TRX5000).

Cash Sweep Bank Accounts Page

RUN_TRX5001

Run the Cash Sweep Bank Accounts report (TRX5001).

Cash Sweep Summary Page

RUN_TRX5002

Run the Cash Sweep Summary report (TRX5002).

Denied Cash Sweep Payments Page

RUN_TRX5003

Run the Denied Cash Sweep Payments report (TRX5003).

Use the Cash Sweep Structure run control page (RUN_TRX5000) to run the Cash Sweep Structure report (TRX5000).

Navigation:

Cash Management > Cash Sweep > Reports > Cash Sweep Structure

This report lists detailed information for a cash sweep structure, includes the master bank account, overall cash sweep processing attributes, sub-accounts, sub-account processing attributes and audit information

You must select a SetID and an As of Date for report. You have the option of selecting a specific Sweep ID or leaving the field blank, which will include all cash sweep structures that were created with the specified SetID and as of the specified date.

Use the Cash Sweep Bank Accounts run control page (RUN_TRX5001) to run the Cash Sweep Bank Accounts report (TRX5001).

Navigation:

Cash Management > Cash Sweep > Reports > Cash Sweep Bank Accounts

This report lists all of the cash sweep structures associated with a given bank account and whether the account is the master bank account or sub-account in the structure.

You must select a SetID and an As of Date for this report. You have the option of selecting a Bank Code, the Business Unit associated with the bank, and a Bank Account number, or you can leave one or all of these values blank and the system will list all cash sweep structures created with the specified SetID and as of the specified date and any bank values associated with a master bank account or sub-account in the structures.

Use the Cash Sweep Summary page (RUN_TRX5002) to run the Cash Sweep Summary report (TRX5002).

Navigation:

Cash Management > Cash Sweep > Reports > Cash Sweep Summary

This report summarizes cash sweep amounts within a cash sweep structure by bank account.

You must select a SetID and select From Date and To Date values for this report. You can enter the same date in both fields to run the report as of that date only. You have the option of selecting a specific Sweep ID or leaving the field blank which will display a list of cash sweep amounts for all cash sweep structures that were created with the specified SetID within or on the specified dates.

Use the Denied Cash Sweep Payments page (RUN_TRX5003) to run the Denied Cash Sweep Payments report (TRX5003).

Navigation:

Cash Management > Cash Sweep > Reports > Denied Cash Sweep Payments

This report lists all denied cash sweep payments.

You must select SetID, From Date, and To Date values for this report. You can enter the same date in both fields to run the report as of that date only. You have the option of selecting a specific Sweep ID or leaving the field blank which will display a list of all cash sweep payments that were denied that fall under the specified SetID within or on the specified dates.