• A Data Selection - used to filter information to display.
• A Data Selection Preferences - used to set your personal report display preferences.
• Report - the output of your data selection, displayed on your screen.
• A File Export Utility - the output of your data selection, written to a file and downloaded to your computer.

Data Selection
Data Selection provides you with many options for filtering and formatting the data to display on the report. You may use any or all options, alone or in combination.

• Account Number List - This multi-selection list box displays the accounts for which you may view information. The default selection is "All Accounts." Each account in the list is identified by the reporting bank, account number, currency, and account name.
• Balance Types - This multi-selection list box displays the levels of information to display or export. The default selection is "All Balances & Transactions." You may also choose to view only the account balances, summary totals, detail credit transactions, and/or detail debit transactions
• Transaction Groups - Transaction Groups are sets of individual reporting items grouped together so that they may be applied as a filter to your data. For example, if you want a report or export of all ACH activity in your accounts, you could apply an ACH transaction group to your data and limit the report to only those balance, summary, and detail items having to do with ACH.The Bank has pre-defined transaction groups which are displayed in a multi-selection list box labeled HARRIS Transaction Groups. You may also define transaction groups which will be displayed in their own list box labeled (your company's code) Transaction Groups. You may select from either or both boxes, or leave the selection at the default value of "No Transaction Groups."
• Date and Amount Queries
  • Date - This is the date of the information you wish to export or display. The system will automatically show the most recent previous business day, but you may enter a specific date or range of dates. The small blue icon to the right of each date field is a calendar that can be used as a visual aid in selecting your date(s).
  • Amount - This is the amount of the item or items to export or display. Use this filter if you are looking for a specific item. The amount values you enter are inclusive and if transactions of this amount exist, they are output.
  • Consolidate Multi-Day Report - This option is only used by the system when you select a date range. When checked, the data from all dates within a range is consolidated into one report. When unchecked, the data is displayed as individual "reports," one for each day within the date range.
    
• Report Characteristics - The following characteristics affect the format and content of the report and do not apply to the BAI Output export option.
  • Type - Summary or Detail. Summary provides only a description of the item and an amount. Detail provides all reported information for all filtered items.
  • Style - Table, Table - Horizontal (with text notes), Table - Horizontal (no text notes), or Raw. A Table report is a presentation-quality report. The two Table Horizontal reports contain the same data as the Table report but include additional columns and are presented in a horizontal format. The Raw report resembles a dot matrix printer report, which may be more familiar to some users.
  • Sort 1 and Sort 2 - These options determine how information is sorted in the report or export. Options are: type code, the amount on either ascending (+) or descending (-) order, bank ref, cust ref, or date. Sort 2 is the second level sort. For example, if you select sort "by date" in Sort 1, you could select By Amount + in Sort 2 for the sort of items within the each date category. NOTES: If you select the same option in both Sort fields, only the Sort 1 option will be performed. For example, if you select By Amount + in Sort 1 and By Amount - in Sort 2, only the By Amount + will be performed.
  • Totals - This determines whether the balance and summary total items for all accounts displayed are added together and displayed. These totals are useful for getting a fast view of your overall position. You may select among displaying no totals, only totals or show totals combined with the individual items.

• Submit - After you have selected the desired filters, select this button to generate the requested report, which is displayed as a new page in your browser work area.
• BAI Output - This option creates a BAI version 2 export file of your data and brings up the "Download" page, allowing you to confirm the download and specify where the file should be saved.
• Reset - This option resets all filter fields to their original values.
• Preference - Displays the Data Selection Preferences Page, discussed in the next section.

• Type - Summary or Detail. Summary provides only a description of the item and an amount. Detail provides all reported information for all filtered items.
• Style - Table, Table - Horizontal (with text notes), Table - Horizontal (no text notes), or Raw. A Table report is a presentation-quality report. The two Table Horizontal reports contain the same data as the Table report but include additional columns and are presented in a horizontal format. The Raw report resembles a dot matrix printer report, which may be more familiar to some users.
• Sort 1 and Sort 2 - These options determine how information is sorted in the report or export. Options are: type code, the amount on either ascending (+) or descending (-) order, bank ref, cust ref, or date. Sort 2 is the second level sort. For example, if you select sort "by date" in Sort 1, you could select By Amount + in Sort 2 for the sort of items within the each date category. NOTES: If you select the same option in both Sort fields, only the Sort 1 option will be performed. For example, if you select By Amount + in Sort 1 and By Amount - in Sort 2, only the By Amount + will be performed.
• Totals - This determines whether the balance and summary total items for all accounts displayed are added together and displayed. These totals are useful for getting a fast view of your overall position. You may select among displaying no totals, only totals or show totals combined with the individual items.

The Preferences Page Buttons

• Set Preferences - After you have defined the desired preferences, selecting this button saves your selections. They are used the next time you request a report.
• Reset - This resets the filter fields to their original values.

Previous Day Report
The Previous Day Report displays prior day information about your accounts based on the selection criteria specified in the Data Selection Page.

The report header contains:

• Your company's name
• The report name, Previous Day Report
• The date(s) you selected on the Data Selection Page
• The date and time you displayed the report

The data area of the report is divided into sections, displayed in outline structure for easier viewing.

  AsOf Date
      Reporting Bank
          Account
              Status level information
              Summary level information
              Detail Credit Transactions
                  Detail Credit Totals
              Detail Debit Transactions
                  Detail Debit Totals
      Bank level Status and Summary Totals
  AsOf Date Status and Summary Totals

If there was no Previous Day data loaded for a particular day, meaning that no information was loaded for any customers, you receive the standard report header, but the data area of the report contains a message stating "No data available for AsOf Date." Where AsOf Date is the particular date for which there is no data. If balances were loaded but there was no information reported for a particular account, you receive the report, bank, and account headers and where there should be data, there is a message stating "No Data Reported," and the report proceeds to the next account, if applicable.

Display of the Bank level and AsOf Date Status and Summary Totals depends on your having chosen "show totals" or "totals only" from the Totals Report Characteristics field on the Data Selection Page.

• If you chose "totals only", the Bank level and AsOf Date Status and Summary Totals are displayed and transactions and their details are excluded.
• If you chose to display totals, Bank level totals are displayed only if you have chosen more than one account.
• AsOf Date totals are displayed only if you have chosen to display data for more than one date.

If you chose to display multiple accounts, all information for one account is displayed before the next account's information is presented. The same is true for AsOf Dates. Likewise, within an account, all information of one level is displayed before the next level is displayed. This is true, regardless of the sort order you have selected. The sort order is applied within each separate information level.

   
BAI-Formatted Data
This output option is available from Data Selection Page and allows you to create an output file of your data, which you may import into another system for other processing, such as account reconciliation. The file created is a fully qualified BAI version 2 file, which adheres to the Bank Administration Institute's balance and transaction file format version 2, last revised, September 1984. The 01 record, or file header, specifies the Bank as both the ultimate sender and receiver of the information. At least one 02/98, or group record set, is created. A separate 02/98 set is created for each AsOf date selected.

The information in the file, including item count, text, and availability values, is extracted from the same database that generates the report discussed above and is output to the file exactly as it is stored in the database. All totals and trailer records are calculated from the selected data as the file is created.

If there is no information reported for a particular account, the account is not included in the file. If multiple AsOf Dates are chosen and there is no data for one or more date(s), no group (02 record) for the date(s) is created. If there is no data at all, for any dates or accounts selected, there will be no file available to download.

The Download Page - This page allows you to confirm that you want to perform the download and specify the location on your computer or network where the export file should be saved. The name of the file defaults to "baidata.txt." You may change the name of the file before you save it or accept the default name.

Sample Screen