Setting
Report Selection Criteria
The Data Selection Page 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. The list of fields below lists specific details for this report.
Account
Number This multiple
selection list box displays the banks and 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.
The
Exchange Bank 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
Exchange Bank may pre-define a set of transaction groups. If so, they are displayed
in a multi-selection list box labeled (The Exchange Bank code) Transaction Groups.
You or someone in your company may also define a set of transaction groups which
are 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."
Setting
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, select
it to use 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.
Setting
Report Characteristics These
filter criteria apply only to report display.
Type
Summary provides only a description
of the item and an amount
Detail
provides all reported information for all filtered items
Style
A Table report displays with
The Exchange Bank colors applied to it. It 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.
Table
- Horizontal (with text notes)
Table
- Horizontal (no text notes)
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
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.
NOTE:
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 and banks displayed are added
together and displayed. These totals are useful for getting a fast view of the
overall position. You may select:
No
Totals
Show Totals
Only Totals
The
Data Selection Page Buttons
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 so that you might confirm the download
and specify where the file should be saved.
Reset
- This option resets all filter fields to their original values.
Preferences
- This option displays the Data Selection Preferences Page, discussed in the next
section.
Changing
Report Preferences
The Preferences Page allows you set the default values for some Data Selection
criteria. You may set and change these values at any time. The report characteristics
supported on the Preferences Page are:
Type
Summary provides only a
description of the item and an amount.
Detail
provides all reported information for all filtered items.
Style
A Table report displays
with The Exchange Bank colors applied to it. It 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.
Table
- Horizontal (with text notes)
Table
- Horizontal (no text notes)
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
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.
NOTE:
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 and banks displayed are added
together and displayed. These totals are useful for getting a fast view of the
overall position. You may select:
No
Totals
Show Totals
Only Totals
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.
Setting
BAI Output Format
This output option is available from the 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 Exchange 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 reporting bank and 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, the file contains only
a file header and a file trailer (an 01 record and a 99 record).
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.
