
Section 4
Other Reports
Credit Sweep (Loan IQ System) Report
The Credit Sweep (Loan IQ System) report provides funds transfer activity between a commercial checking account and an associated Loan IQ system account. Paydown and Advance transfers as well as balance information are provided.
To view the Credit Sweep (Loan IQ System) Report
- Select the Filter button next to Credit Sweep (Loan IQ System) from the Information Reporting main page.
- Select the account for the statement that you wish to view.
- Select the date range for the statements you wish to view in the Date From and Date To boxes.
- Click Next to view the statements in your date range selection. Click Cancel to return to the Information Reporting main page.
- Select the statement icon for the statement that you wish to view.
NOTE: You must have Adobe Acrobat Reader 4.0 or higher to view your statement. Please click on the link to download a free copy of Adobe Acrobat Reader if needed.
Investments (AIS Sweep) Confirmation Report
The Investments (AIS Sweep) Confirmation provides daily information regarding your AIS Sweep account. Sweep activity between the Investment and commercial checking account is provided, including balances and earnings.
To view the Investments (AIS Sweep) Confirmation Report
- Select the Filter button next to Investments (AIS Sweep) from the Information Reporting main page.
- Select the account for the statement that you wish to view.
- Select the date range for the statements you wish to view in the Date From and Date To boxes.
NOTE: You must have Adobe Acrobat Reader 4.0 or higher to view your statement. Please click on the link to download a free copy of Adobe Acrobat Reader if needed
- Click View to view the statements in your date range selection. Click Cancel to return to the Information Reporting main page.
- Select the statement icon for the statement that you wish to view.
Investments Sweep Confirmation
The Investments Sweep Confirmation provides daily information regarding your Repurchase Sweep Account. Sweep activity between the Investment and commercial checking account is provided, including balances and earnings.
To view the Investments Sweep Confirmation Report
- Select the View button next to Investments from the Information Reporting main page.
- The report will be displayed. Select Main page to return to the Information Reporting main page.
To filter the Investments Sweep Confirmation Report
- Select the Filter button next to Investments from the Information Reporting main page or select the filter button from the Investments report that was displayed when View was selected.
- Select the account(s) to be included in the report. Multiple accounts can be selected by holding CTRL or Shift and clicking on the desired accounts.
- Select the date or date range for the report.
- Click View to see the statements in your date range selection. Click Cancel to return to the Information Reporting main page.
- Select Download to download a filtered report.
Credit Sweep Report
The Credit Sweep report provides funds transfer activity between a commercial checking account and an associated loan account. Paydown and Advance transfers, as well as balance information, are provided.
To view the Credit Sweep Report
- Select the View button next to Credit Sweep from the Information Reporting main page.
- The report will be displayed.
To filter the Credit Sweep Report
- Select the Filter button next to Credit Sweep from the Information Reporting main page or select the filter button from the Credit Sweep Report that was displayed when View was selected.
- Select the account(s) to be included in the report. Multiple accounts can be selected by holding CTRL or Shift and clicking on the desired accounts.
- Select the date or date range for the report.
- Click View to see the statements in your date range selection. Click Cancel to return to the Information Reporting main page.
- Select Download to download a filtered report.
Zero Balance Accounts Report
The Zero Balance Accounts (ZBA) report provides you with prior day debit and credit activity for master and sub accounts in your ZBA structure.
To view the ZBA Report
- Select the View button next to Zero Balance Accounts from the Information Reporting main page.
- The report will be displayed.
To filter the ZBA Report
- Select the Filter button next to Zero Balance Accounts from the Information Reporting main page or select the filter button from the ZBA Report that was displayed when View was selected.
- Select the account(s) to be included in the report. Multiple accounts can be selected by holding CTRL or Shift and clicking on the desired accounts.
- Select the date or date range for the report.
- Click View to see the statements in your date range selection. Click Cancel to return to the Information Reporting main page.
- Select Download to download a filtered report.
High Order Prefix Detail Report
The High Order Prefix Detail (HOP) report provides summary and detailed transaction information for your HOP structure. The HOP feature allows you to subdivide your Controlled Disbursement Account (CDA) by adding a prefix to the account’s check serial numbers. This prefix is then used to segregate your CDA clearings into subtotals.
To view the HOP Report
- Select the View button next to High Order Prefix Detail from the Information Reporting main page.
- The report will be displayed.
To filter the HOP Report
- Select the Filter button next to High Order Prefix Detail from the Information Reporting main page or select the filter button from the HOP report that was displayed when View was selected.
- Select the account(s) to be included in the report. Multiple accounts can be selected by holding CTRL or Shift and clicking on the desired accounts.
- Select the date or date range for the report.
- Click View to see the statements in your date range selection. Click Cancel to return to the Information Reporting main page.
- Select Download to download a filtered report.
Lockbox Detail (Legacy) Report
The Lockbox Detail (Legacy) report is a standard Lockbox deposit report. This report provides basic information regarding deposits received in your Key lockbox. (Please see the Receivables section of the User Guide for additional information on lockbox reporting and imaging.)
To view the Lockbox Detail (Legacy) Report
- Select the View button next to Lockbox Detail (Legacy) from the Information Reporting main page.
(Example has been reduced to focus on applicable area.)
To filter the Lockbox Detail (Legacy) Report
- Select the Filter button next to Lockbox Detail (Legacy) from the Information Reporting main page or select the filter button from the Lockbox Detail report that was displayed when View was selected.
- Select the account(s) to be included in the report. Multiple accounts can be selected by holding CTRL or Shift and clicking on the desired accounts.
- Select the date or date range for the report.
- Click View to see the statements in your date range selection. Click Cancel to return to the Information Reporting main page.
- Select Download to download a filtered report.
Incoming/Outgoing Wire Activity Report
The Incoming/Outgoing Wire Activity report provides real-time details on incoming and outgoing wire transfers. Information provided includes date/time wire was sent/received, account number/name, transaction description, wire amount, and any reference details included with the wire (Fed Wire reference number).
To view the Incoming/Outgoing Wire Activity Report
- Select the View button next to Incoming/Outgoing Wire Activity from the Information Reporting main page.
- The report will be displayed.
To filter the Incoming/Outgoing Wire Activity Report
- Select the Filter button next to Incoming/Outgoing Wire Activity from the Information Reporting main page or select the filter button from the Incoming/Outgoing Wire Activity report that was displayed when View was selected.
- To utilize a saved filter, use the dropdown menu to select the appropriate filter and select Apply to use the filter, Edit to update the filter with new criteria, or Delete to remove the filter from the menu.
- To create a new filter that can be saved and utilized later, enter a name for the new filter, enter the appropriate ranges and/or criteria (discussed in more detail in the following steps), and select Save. After the new filter has been saved, it will appear in the list of saved filters.
- Select the account(s) to be included in the report. Multiple accounts can be selected by holding CTRL or Shift and clicking on the desired accounts.
- Select the date or date range for the report.
- Select the type code.
- Select the transaction type to display Credits Only, Debits Only or credits and debits with All Transactions.
- Enter a dollar amount or dollar range for the transactions.
- Select Cancel to return to the Information Reporting main page, select Download to download the filtered report, or select View to view the filtered report.