Account Reports

The Account Reports page has two tabs: Standard Reports and Custom Reports.

Standard Reports

Each tab includes these columns:

  • Standard Reports – Click the report name link to view the report.
  • Type – Describes the timeliness of report data
    • Current Day – The report includes data up to and including today.
    • Prior Day – The report includes data up to and including yesterday.
  • Action – To make a custom report based on the corresponding standard report, click Customize Report.

The following reports are listed in the Standard Reports section:

Report Name Provides account information for...
ACH Detail ACH-related transaction data reported by the financial institution. This report does not contain data on ACH transactions generated from the Payments module in Universal Online Banker.
ACH Return and NOC ACH-related data for return and NOC (notification of change)
ACH Summary ACH-related balances and summary data reported by the financial institution. This report does not contain data on ACH transactions generated from the Payments module in Universal Online Banker.
Controlled Disbursement Detail Controlled disbursement-related transaction data
Controlled Disbursement Summary Controlled disbursement-related balances and summary data
Current Day Combination Current day or memo-posted summary and transaction data

The summary and detail sections are displayed together for each account.

Current Day Detail Current day or memo-posted transaction data, based on the user's entitled accounts
Current Day Detail New Items Transaction data since the last time current day detail was retrieved for the user requesting the report
Current Day Summary Current day or memo-posted balances and summary data, based on the user's entitled accounts
Lockbox Detail Lockbox-related transaction data
Lockbox Summary Lockbox-related balances and summary data
Multi-Day Statement A report with statement data from a time period determined by the report default or a customized time period
Paid Check The BAI debit transaction data "475 - Check Paid"
Pay Through Draft Detail The BAI debit transaction data "435 - Payable Through Draft"
Pay Through Draft Summary The BAI debit balances and summary data "430 - Total Payable Through Drafts"
Prior Day Combination Reported (prior day or hard-posted) summary and transaction data

The summary and detail sections are displayed together for each account

Prior Day Detail Prior day or hard posted transaction data
Prior Day Detail No Check Same as Prior Day Detail, excluding the Check Paid transaction data (BAI code 475)
Prior Day Summary Prior day or hard-posted balances and summary data
Wire Confirmation Detail Confirmations of all incoming and outbound wire debit and credit transactions, including all transaction details
Wire Confirmation Summary Summary of confirmations of all incoming and outbound wire debit and credit transactions
Wire Transfer Detail Wire-related transaction data reported by the financial institution. This report does not contain data on wire transactions generated from the Payments module in Universal Online Banker.
Wire Transfer Summary Wire-related balances and summary data reported by the financial institution. This report does not contain data on wire transactions generated from the Payments module in Universal Online Banker.

Custom Reports

This tab lists custom reports that you have created and custom reports created by others and shared with you.

Note: A customized report, which you modify to suit your purposes, is not the same as a special report, which is created by your financial institution.

This tab includes these columns:

  • Select All/Select None – Clicking the Select All button selects all the rows in the column. Clicking the Select None button deselects all the rows in the column.
  • Custom Reports – Click the report name link to view the report.
  • Type – This value is the same as the standard report from which the custom report was created.

    Describes the timeliness of report data

    • Current Day – The report includes data up to and including today.
    • Prior Day – The report includes data up to and including yesterday.
  • Last Updated Date/Time – The date and time of the most recent report customization.
  • Action – This column includes buttons that edit or delete custom reports.

Customize Standard Report

Under the Accounts tab, the Customize Standard Report page (or Customized Report page) allows you to modify a standard report to create a custom report template. Some of the information requested on the different versions of this page can vary depending on the report type.

Note: A customized report, which you modify to suit your purposes, is not the same as a special report, which is created by your financial institution.
Custom Report Name

The name of the customized report

Bank Report Name

The name of the standard report on which the customized report is to be based

This field is read-only.

Report Type

The report type on which the customized report is based

When customizing a report, users cannot change the basic report type.

This field is read-only.

Usage

The report's availability

Options are as follows:

  • Private – Available to only the user who created the report
  • Shared – Available to all company users who have the required entitlements
Reference Text

Whether the report includes reference text, such as a check memo

Accounts

Specific company accounts to include in the report

Select multiple accounts by selecting the account's check box in the Select column.

The list includes only the accounts the user has access to through Account Services entitlements.

Date Range

Defines the range of transaction dates to be included in the report

You can define the date range in two ways:

  • Relative Date – Defines the From and To dates according to how the dates fall relative to a specific measurement, such as the current month
  • Absolute Date – Specifies calendar dates as From and To dates
Amount Range

Limits the report to transactions within a specific amount range

Serial Number Range

The numeric range of serial numbers (check numbers) to be included in the report

To search for a single number, enter a numeric value in the From field only, and leave the To field blank.

The value in the From field must be less than the To field.

Customer Reference Number

One or more customer reference numbers to be included in the report

Note: Use the asterisk (*) wildcard character to locate multiple transactions having similar reference numbers. For example, 123* would locate all transactions where the reference number begins with 123.
Bank Reference Number

One or more bank reference numbers to be included in the report

Note: Use the asterisk (*) wildcard character to locate multiple transactions having similar reference numbers. For example, 123* would locate all transactions where the reference number begins with 123.
BAI Groups

Selecting a BAI group from the list limits the report to that BAI group.

Transaction Codes

Limits the report to specific BAI or SWIFT codes

The user can specify codes in two ways:

  • Select transaction codes from a list
  • Enter them directly in the text box as a comma-separated list (for example: 101,102,103).
Note: To include all codes except for a few exceptions, click the link at the top of the Select column, and then clear the check boxes of the codes to be excluded.
Note: Use the asterisk (*) wildcard character to locate multiple transactions having similar reference numbers. For example, 123* would locate all transactions where the reference number begins with 123.

Click Continue to preview and save the report customization.

Custom Report - Transaction List

Use the Custom Report - Transaction List page to select the transaction codes to include in the Transaction Codes field of the Customized Report page.

Select

Check boxes for selecting a code

The All link selects every code on the list.

The None link clears every code on the list.

Tip: To choose all the codes except a few, select the All link, and clear the few you do not want.
BAI/SWIFT

BAI codes followed by a back slash, and SWIFT codes preceded by a back slash

Description

Description of the BAI or SWIFT code

To add your choices to the Transaction Codes field of the Customized Report page, click Continue.