KeyTotalTreasury logo
Tools & Resources

List of Available Reports


Report Information contained within the report Length of time available
Standard Reports
Previous Day The Previous Day balance report provides prior day account balances and transactions for enrolled accounts. Information provided includes transaction descriptions and reference information. The report will show summary only or summary and detail information, depending on the level of service requested. 180 days
Intraday The Intraday balance report provides current day account balances and transactions for enrolled accounts. Information provided includes transaction descriptions and reference information for: Controlled Disbursement (CDA), lockbox, ACH, and wire transactions. The report will show summary only or summary and detail information depending on the level of service requested. 180 days
BAI2 Previous Day File The BAI2 Previous Day File provides prior day account balances and transactions for enrolled accounts. Information provided includes transaction descriptions and reference information downloaded in the BAI2 format. The file will show summary only or summary and detail information, depending on the level of service requested. 180 days
BAI2 Intraday File The BAI2 Intraday File provides current day account balances and transactions for enrolled accounts. Information provided includes transaction descriptions and reference information downloaded in the BAI2 format for: Controlled Disbursement (CDA), lockbox, ACH, and wire transactions. The file will show summary only or summary and detail information 180 days
Global Account Reporting The Global Account Report provides information on your international bank accounts and includes account balances and transactions for enrolled accounts (sent to Key from the owning bank). Information provided includes transaction descriptions and reference information. The report will show summary only or summary and detail information, depending on the level of service requested. 180 days


Report Information contained within the report Length of time available
Customer Statements
Corporate Banking Statement The Corporate Banking Statement feature provides electronic copies of your commercial checking accounts enrolled in the service. Multiple download and printing options are available. Rolling 24 months
Account Analysis Statement The Account Analysis Statement provides detailed information on balances and service charges for all accounts in your relationship. The Account Analysis Statement summarizes and details all treasury (cash management) services that you utilize. Some of the information contained in the Account Analysis statement includes average ledger balance, average float, average collected balance, depository and treasury (cash management) services used, total service charges and Earnings Credit received, and current year historical view of balances. Earnings Credit and service charges are also included. Rolling 12 months
EDI 822 Statement (File) The EDI 822 Account Analysis Statement (file) provides a downloadable electronic file of the monthly Account Analysis statement in the EDI 822 format. The Account Analysis Statement provides detailed information on balances and service charges for all accounts in your relationship. The Account Analysis Statement summarizes and details all treasury (cash management) services that you utilize. Some of the information contained in the Account Analysis statement includes average ledger balance, average float, average collected balance, depository and treasury (cash management) services used, total service charges and Earnings Credit received, and current year historical view of balances. 180 days


Report Information contained within the report Length of time available
Other Reports
Credit Sweep (Loan IQ System) 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. 180 days
Investments (AIS Sweep) Confirmation 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. 180 days
Investments The Investments Confirmation provides daily information regarding your Repurchase Sweep Account. Sweep activity between the Investment and commercial checking account is provided, including balances and earnings. 180 days
Credit Sweep 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 180 days
Zero Balance Accounts The Zero Balance Account (ZBA) report provides you with prior day debit and credit activity for master and sub accounts in your ZBA structure. 180 days
High Order Prefix Detail 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. 180 days
Lockbox Detail (Legacy) 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.) 180 days
Incoming/ Outgoing Wire Activity 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). 14 days


Report Information contained within the report Length of time available
ACH Reports
ACH Customer Activity Report The ACH Customer Activity Report (CAR) provides information on ACH transactions that were originated through Key. This report also includes adjustments to the account balance and/or corrections to the detail on ACH transactions. All clients that originate ACH transactions through Key will receive the Customer Activity Report. 180 days
EDI Remittance The EDI Remittance report provides detailed remittance information for electronic payments received in your Key account (i.e. ACH / EDI). Information provided includes payment originator, payment receiver, invoice information and individual transaction detail. 180 days
ACH Entries Resubmitted via ACH The ACH Entries Resubmitted via ACH report provides a list of ACH entries that were returned for various reasons (including NSF returns) that are now being re-presented. 180 days
ACH Entries Converted to Draft The ACH Entries Converted to Draft report provides a list of ACH entries that were rejected for various reasons and must now be cleared as paper items. 180 days
Deposit Distribution The Deposit Distribution report provides details on ACH entries that have been returned for Originators who have separate entities originating ACH items. 180 days
ACH Receiving Entries The ACH Receiving Entries report provides details on each incoming ACH transaction. The report provides detail of all fields within the ACH transaction sent to Key. Rolling 12 months
ACH Return Notification The ACH Return Notification report provides details on each returned ACH transaction and Notification of Change (NOC) received. Rolling 12 months
Rejected EPA Notification The Rejected EPA Notification report is produced if you utilize ‘manual’ EPA (Electronic Payment Authorization). The report provides details on any incoming ACH debit transactions which have rejected and require review / approval. Rolling 12 months
End of Day EPA Summary The End of Day EPA Summary report provides a recap of all activity from EPA authorizations for the day. It is divided into multiple sections: Authorizations Used Today, Active Unused Authorizations, Expired Authorization List, Authorizations Revoked Today, and Authorizations Reset Today. Rolling 12 months