KeyTotalTreasury logo
Tools & Resources

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

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

  1. Select the ‘view’ button next to Investments from the Information Reporting main page.
  2. The report will be displayed. Select ‘main page’ to return to the Information Reporting main page.

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

  1. Select the ‘view’ button next to Credit Sweep from the Information Reporting main page.
  2. The report will be displayed.

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

  1. Select the ‘view’ button next to Zero Balance Accounts from the Information Reporting main page.
  2. The report will be displayed.

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

  1. Select the ‘view’ button next to High Order Prefix Detail from the Information Reporting main page.
  2. The report will be displayed.

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

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

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