KeyTotalTreasury logo
Online Help

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

  1. Select the Filter button next to Credit Sweep (Loan IQ System) from the Information Reporting main page.

    Credit Sweep (Loan IQ System)

  2. Select the account for the statement that you wish to view.
  3. Select the date range for the statements you wish to view in the Date From and Date To boxes.
  4. Click Next to view the statements in your date range selection. Click Cancel to return to the Information Reporting main page.
  5. 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.

Credit Sweep (Loan IQ System) Report Filter

Credit Sweep (Loan IQ System) Statements

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

  1. Select the Filter button next to Investments (AIS Sweep) from the Information Reporting main page.

    Investments (AIS Sweep) Filter

  2. Select the account for the statement that you wish to view.
  3. 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

  4. Click View to view the statements in your date range selection. Click Cancel to return to the Information Reporting main page.

    Select statement

  5. Select the statement icon for the statement that you wish to view.

    Select statement

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

  1. Select the View button next to Investments from the Information Reporting main page.

    Investments Sweep Confirmation Report

  2. The report will be displayed. Select Main page to return to the Information Reporting main page.

    Investments Sweep Confirmation Report

To filter the Investments Sweep Confirmation Report

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

    Investments Sweep Confirmation Report

    Investments Sweep Confirmation Report

  2. 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.
  3. Select the date or date range for the report.
  4. Click View to see the statements in your date range selection. Click Cancel to return to the Information Reporting main page.

    Investments Sweep Confirmation Report

  5. Select Download to download a filtered report.

    Investments Sweep Confirmation 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

  1. Select the View button next to Credit Sweep from the Information Reporting main page.

    Credit Sweep Report

  2. The report will be displayed.

    Credit Sweep Report

To filter the Credit Sweep Report

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

    Credit Sweep Report

  2. 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.
  3. Select the date or date range for the report.
  4. Click View to see the statements in your date range selection. Click Cancel to return to the Information Reporting main page.

    Credit Sweep Report

  5. Select Download to download a filtered report.

    Credit Sweep 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

  1. Select the View button next to Zero Balance Accounts from the Information Reporting main page.

    Zero Balance Accounts

  2. The report will be displayed.

    Zero Balance Accounts Report

To filter the ZBA Report

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

    ZBA Report Filter

  2. 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.
  3. Select the date or date range for the report.
  4. Click View to see the statements in your date range selection. Click Cancel to return to the Information Reporting main page.

    ZBA Report Filter

  5. Select Download to download a filtered report.

    ZBA Report Filter

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

  1. Select the View button next to High Order Prefix Detail from the Information Reporting main page.

    High Order Prefix Detail

  2. The report will be displayed.

    High Order Prefix Detail

To filter the HOP Report

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

    High Order Prefix Detail Filter

  2. 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.
  3. Select the date or date range for the report.
  4. Click View to see the statements in your date range selection. Click Cancel to return to the Information Reporting main page.

    High Order Prefix Detail Filter

  5. Select Download to download a filtered report.

    High Order Prefix Detail Filter

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

  1. Select the View button next to Lockbox Detail (Legacy) from the Information Reporting main page.

    Lockbox Detail (Legacy) Report

(Example has been reduced to focus on applicable area.)

Lockbox Detail (Legacy) Report

Lockbox Detail (Legacy) Report

To filter the Lockbox Detail (Legacy) Report

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

    Lockbox Detail (Legacy) Report Filter

  2. 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.
  3. Select the date or date range for the report.
  4. Click View to see the statements in your date range selection. Click Cancel to return to the Information Reporting main page.

    Lockbox Detail (Legacy) Report Filter

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

  1. Select the View button next to Incoming/Outgoing Wire Activity from the Information Reporting main page.

  2. The report will be displayed.

To filter the Incoming/Outgoing Wire Activity Report

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

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

  3. 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.
  4. 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.
  5. Select the date or date range for the report.
  6. Select the type code.
  7. Select the transaction type to display Credits Only, Debits Only or credits and debits with All Transactions.
  8. Enter a dollar amount or dollar range for the transactions.
  9. 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.