KeyTotalTreasury logo
Tools & Resources

Reports


5.1 View Reports

You may only access reports and accounts that have been assigned to you. If you do not have access to view reports, the Reports area will display the following message, “No Reports Available… you have not been granted access to any reports.”

To view reports, click the report name you wish to access. A screen will be displayed allowing you to view the selected report. Default values are displayed. You can, however, tailor the report content by selecting the specific criteria. Choose the specific criteria from the options provided, and click on ‘View Report.’ To print the report, click on the Print icon in the function bar at the top of the page. To export the data, choose the desired file format from the drop down list provided and click on Export. The Following file formats are available: Word, XML, CSV (commadelimited), TFF, Acrobat (pdf), Web Archive (.mhtml) and Excel.

NOTE: Reports can be generated up to 90 days after the deposit has been completed.

5.2 Daily Deposit Detail Extract

The Daily Deposit Detail Extract provides the details for deposits made on the selected business day.

Choose the Business Date and Account Number and then click ‘View Report’.

To print the extract, click the Print icon on the report function bar. To export the data to a file, select a format and then click Export. The following file formats are available: Word, XML, CSV (comma-delimited), TFF, Acrobat (pdf), Web Archive (.mhtml) and Excel.

5.2.1 Report Fields

The following report fields are available:

  • Financial Institution
  • Corporate ID – A unique number assigned by Key to an individual company
  • Company Name
  • Processing Date – Processing date is in mm/dd/yyyy format.
  • Deposit Account – The deposit account number.
  • Site ID – The site ID.
  • Deposit ID – The deposit ID.
  • Deposit Receipt Time –The deposit receipt time (ET).
  • ISN – The item sequence number.
  • Account Number – The account number.
  • Routing and Transit – The routing and transit number.
  • Serial Number – Check Serial Number
  • Tran Code – Check Tran Code
  • Amount – The amount of the deposit.
  • User ID – Name or ID of the individual completing the deposit.
  • Item Level Memo 1-5 – Any notation made by the depositor for a specific check.

5.3 Daily Deposit Detail

The Daily Deposit Detail Report provides the images for deposits made on the selected business day.

Choose the business date and account number. Then click ‘View Report’. To print the extract, click the Print icon on the report function bar. To export the data to a file, select a format, click Export. The following file formats are available: Word, XML, CSV (comma-delimited), TFF, Acrobat (pdf), Web Archive (.mhtml) and Excel.

5.3.1 Report Fields

The following report fields are available:

  • Deposits for Account Number – The deposit account number.
  • Amount – Total of all deposits for the account in this report.
  • Item Count – Count of all items in all deposits for the account in this report.
  • Deposit Number – The sequence number of the deposit.
  • Made at – Time (ET).
  • By – ID of the user who made this deposit.
  • At site – The deposit site ID.
  • Image – The image of the front of the item.
  • ISN – The item sequence number on the back of the check.
  • Amount – The amount of the item.

5.4 Daily Payment Extract

This extract provides a summary of information if you opt into the Smart Field capabilities. Business Date, Account Number and Location are all required fields to be entered before the Daily Payment Extract report can be generated.

You will select the following:

  • A specific business day rather than a range of dates.
  • A specific account
  • A specific location

Select a date range and then click ‘View Report’. To print the extract, click the Print icon on the report function bar. To export the data to a file, select a format and click Export. The following file formats are available: Word, XML, CSV (comma-delimited), Tiff, Acrobat (pdf file), Web Archive (.mhtml), or Excel.

  • Deposit Account – The deposit account number
  • Location – The location of the deposit
  • Deposit ID – The deposit ID
  • Item Number – Check item number
  • Item Account – Deposit account for an item
  • Item ABA – Routing\transit number for an item
  • Check Number – Check number
  • Amount – Amount of a deposited check
  • Smart Fields (*) – Electronic identifiers used to tag deposited items (*) Five 5 columns that vary based on the template assigned to the account

5.5 Deposit Summary

The Deposit Summary Report provides a summary of all deposits made at all sites and accounts for which you, the user, has authority.

Select a date range and then click ‘View Report’. To print the extract, click the Print icon on the report function bar. To export the data to a file, select a format and click Export. The following file formats are available: Word, XML, CSV (comma-delimited), Tiff, Acrobat (pdf file), Web Archive (.mhtml), or Excel.

5.5.1 Report Fields

Report data is grouped first by date, then account and then site:

  • Date – Processing date in mm/dd/yyyy format.
  • Total Deposits – Total of all deposits for all accounts on that date. Deposit count is the total count of all deposits for the date. Item count is the total count of all items in all deposits for the selected date.
  • Deposits for Account – The deposit account number.
  • Deposits for Site – The site number, if applicable.
  • Total Deposits – Total of all deposits for this account, date and site.

5.6 Item Search

The Item Search Report provides the deposit details and image information for items within the search criterion.

To view reports, there are only two required fields the From Date and To Date; leaving any of the other fields blank will not limit the search. All wildcards are implicit, which means that everything that matches your criteria will be returned. Deposit Account Number is a required field.

Once the entire search criterion is entered, click ‘View Report’ to begin the search. The on-screen report displays 25 rows of data. To change the maximum rows displayed, select a value in the Max Number of Items Returned field. The minimum is one and the maximum is 1,000.

To print the report, choose the Print icon on the function bar. To export the data to a file, select the format and click Export.

5.6.1 Filter Fields

The Report has eight different parameters that can be used to narrow or widen the search:

  • From Date – The oldest date to begin searching for items. This is initially set to the current date. This is a required field.
  • To Date – The most recent date to end searching for items. This is initially set to the current date. This is a required field.*
  • Amount >= (greater than or equal to) –The lower bound for searching on item amount. Numeric data only.**
  • Amount <= (less than or equal to) – The upper bound for searching on item amount. Numeric data only.**
  • Check Account Number– The account number of the check, which can be found in the MICR code-line.
  • Routing and Transit –The Routing number found on the check, which can be found in the MICR code-line.
  • Check Number – Represents the number of the check, which depends on the type of check scanned.
  • Deposit Account Number– Lists all available account numbers. Select one or select all.
  • Max Number of Items to Return – The number of rows to display; one item per row.
  • Item Level Search – The memo entered in the item level memo field while making the deposit (Corporate reporting access only)

NOTES: ** Data entered into these fields must be numeric; otherwise, there will be an error running the reports. The result set is limited to the most recent 1,000 items. Better performance can be achieved with narrower search criterion.

5.6.2 Report Fields**

  • Show Image – Initially collapsed; when expanded displays front and rear image.
  • ISN – Item sequence number given to each check.
  • Deposit Account No.– Account number in which the check was deposited.
  • Site ID – Identifier of the site where the deposit was made.
  • Check Account No.– The account number found on the check.
  • Routing/Transit – The RT number found on the check.
  • Tran Code – See page 36 for definition.
  • Western Aux – The Western Aux code, which is sometimes the same as the check number.
  • Serial Number– See page 36 for definition.
  • Amount – The dollar amount of the item.
  • Receipt Time – The time that the bank received the deposit (ET).

5.7 Payment Search

Payment Search enables you to search a specific payment on a specific date. There are check boxes that allow a report to expand to view images associated with the payment for Smart Field accounts.

Required fields include Deposit Account (defaults to the first account in the dropdown listing), Deposit Location, After Date, and Before Date.

Select a date range and then click ‘View Report.’ To print the extract, click the Print icon on the report function bar. To export the data to a file, select a format and click Export. The following file formats are available: Word, XML, CSV (comma-delimited), Tiff, Acrobat (pdf file), Web Archive (.mhtml), or Excel.

5.7.1 Filter Fields

  • Deposit account
  • Deposit Location
  • After Date- a cutoff date
  • Before Date
  • Payment Field
  • Value
  • More than $
  • Less Than $
  • Check #
  • Check Account #
  • Check ABA #
  • Max Items Returned (default 25)

5.7.2 Report Fields

  • Deposit Account.
  • Deposit Location
  • After Date
  • Before Date
  • More Than $
  • Less Than $
  • Check #
  • Check Account #
  • Check ABA #
  • Deposit Date
  • Item #
  • Check #
  • ABA:
  • Account:
  • Amount