REPORT INFORMATION PANEL
This panel appears on both the Customize Standard Report page and on the Customized Report page. The items that appear vary depending on Report Type. Variations are noted in the table below.
Description/(Comments) Required Default Value Valid Entries/Choices Examples
Bank Report Name (Not editable)
The standard bank report being customized. (This is the title that appears on the report.)
N/A N/A N/A “Prior Day Summary”
Report Type (not editable) The class of report.
(Report Type determines which data set is searched. Four data sets are used: Current Day–Summary; Current Day–Detail; Prior Day–Summary; Prior Day–Detail. The Current Day data sets include transactions that have not yet been posted to accounts. The Prior Day data sets include posted transactions that were posted within the last 18 months.)
N/A N/A N/A “Prior Day Detail”
(This means the Prior Day– Detail data set is used in the custom report.)
Usage A dropdown list specifying whether the report
may be shared with other users.
(If you choose “Shared” the report is listed on the Custom Report list and is available to all
Yes Shared Select one from the dropdown list:
– Shared
Description/(Comments) Required Default Value Valid Entries/Choices Examples
Customized Report Name
The name of the custom report.
(This name appears only on the Custom Report list. The standard report name appears
Yes (None) Enter any text, 32 characters
maximum.
“Money Market – Prior Month Detail”
Reference Text (Appears only for Detail reports)
A checkbox indicating whether to include additional reference information, such as transaction memos, addenda or special instructions.
No Yes (checked) Yes (checked) – include references
No (unchecked) – do not include references
Accounts List of bank accounts to include in the report. (You can select multiple accounts, by holding
Yes “All Accounts” Select one or more accounts from
the list.
Date Range Option button specifying whether to use relative or absolute dates in the report. (If you select “Relative Date” transaction dates will be selected relative to the date you run the report (e.g., last week).)
Works with the From [relative date] To [relative date] fields or with the From [date] To [date] fields, depending on whether you selected “Relative Date” or “Absolute Date”, respectively.
Yes “Relative Date” Select one from the dropdown list: ○Relative Date
○Absolute Date
If you select “Relative Date,” you must select dates in the From
[relative date] To [relative date]
dropdown lists.
If you select “Absolute Date,” you must enter dates in the From
[date] To [date] fields.
Description/(Comments) Required Default Value Valid Entries/Choices Examples
From [relative date] To [relative date]
(Used only if “Relative Date” is selected in
Date Range.)
The period covered in the report, relative to the date on which the report is run.
Yes, only if “Relative Date” is selected in Date Range.
(none) Select a date from dropdown lists:
From: Beginning of current month
Beginning of current week Beginning of prior month Beginning of prior week Today
Prior Business Day
To: End of prior month End of prior week
If you select “Prior Business Day” for both From and To, and the report is run on Tuesday, Feb. 1, “Today” = Feb. 1, and Monday, Jan. 31 becomes the prior business day. The report will include specified
transactions dated Jan. 31.
From [date] To
[date]
(Used only if “Absolute Date” is selected in
Date Range.)
The time period covered in the report.
Yes, only if “Absolute Date” is selected in Date Range.
(none) Enter a date in each of the date
fields.
Click to select a date, or enter the date using the format: MM/DD/YYYY.
Fromdate must be <=Todate
From: 01/01/2010 To: 12/31/2010
Amount Range From
(Appears only in Detail reports)
Lower limit in the range of amounts to search for.
Used together with Amount Range To
(If zeros are left in bothFromandTofields all
No 0 Enter a dollar amount to a
maximum of 50 characters. Amounts must be in a valid dollar format e.g., #,###.## (no $ sign)
“0.50” “5,000” “5,000.00” Not allowed: “$50” (uses $ sign); Amount Range To
(Appears only in Detail reports)
Upper limit in the range of amounts to search for.
Used together with Amount Range From
(If zeros are left in bothFromandTofields all
No 0 Enter a dollar amount to a
maximum of 50 characters. Amounts must be in a valid dollar format e.g., #,###.## (no $ sign) and must be greater than or equal to the value in Amount From.
“0.50” “5,000” “5,000.00”
Not allowed: “$50” (uses $ sign);
Description/(Comments) Required Default Value Valid Entries/Choices Examples
Customer
Reference Number Range
From
(Appears only in Detail reports)
Either the lower limit in the range of Customer Reference numbers to search for, or a single non-numeric customer reference number. Used together with Customer Reference Number Range To when a numeric value is entered.
(Customer Reference Numbers are typically check numbers, but they are also used in non- check transactions. In that case the customer reference “number” may not be numeric. The Customer Reference Number is called the
No (none) Enter a number or a reference ID,
50 characters maximum.
If a range is entered (i.e., a value is entered in Customer Reference Number Range To), the value must be a number (no commas or other special characters allowed)
“12345” (check number) “10SUD000008488” (ACH number) Customer Reference Number Range To
(Appears only in Detail reports) Upper limit in the range of Customer Reference numbers to search for.
Used together with Customer Reference Number Range From. only if a number is entered there.
(Customer Reference Numbers are typically check numbers, but they are also used in non- check transactions. In that case the customer reference “number” may not be numeric.
Th C t R f N b i ll d th
No (none) Enter a number to a maximum of
50 characters. (no commas or special characters)
The number must be greater than or equal to the value in Customer Reference Number Range From.
“12345” (check number)
Not allowed:
“10SUD000008488” (non-
numeric values are not allowed in a range)
Description/(Comments) Required Default Value Valid Entries/Choices Examples
Bank Reference Number Range From
(Appears only in Detail reports) Lower limit in the range of FI (Financial Institution) Reference numbers to search for. Used together with Bank Reference Number Range To.
(Bank Reference Numbers are internal numbers used by the bank to track the transaction
No (none) Enter a number to a maximum of
50 characters. (no commas or special characters) “12345” (check number) “10SUD000008488” (ACH number) Bank Reference Number Range To
(Appears only in Detail reports) Upper limit in the range of FI (Financial Institution) Reference numbers to search for. Used together with Bank Reference Number Range From. only if a number is entered
there.
(Bank Reference Numbers are internal numbers used by the bank to track the
No (none) Enter a number to a maximum of
50 characters. (no commas or special characters)
The number must be greater than or equal to the value in Customer Reference Number Range From.
“20101101000007”
BAI Codes (Appears only in Detail reports that are not
based on specific BAI codes)
The transaction codes representing the types of transactions to include in the report (e.g., 475 = Paid checks).
(BAI codes are industry standard banking codes representing specific transaction types.
Yes (none) Enter one or more valid detail BAI
II transaction codes, separated by commas, or click
(View BAI List) and submit selected codes from the list.
“595” (ATM Debit)
“409” (Any type of Debit) “108” (Any type of Credit) “108,409” (any credits or debits) Not allowed:
“140” (Total Bank Card Deposits) Summary transaction codes are
47