Capital One Information Reporting: A Comprehensive Guide, Study notes of Printing

Download Capital One Information Reporting: A Comprehensive Guide and more Study notes Printing in PDF only on Docsity!

Information Reporting

Reference Guide

Table of Contents

• Introduction to Information Reporting
• Viewing the Account Summary
  • Customizing the Account Summary Screen
  • Managing Columns
  • Using Views and Saving Customizations as a View
  • Creating an Account Group
  • Using the Filter on the Account Summary Screen
  • Viewing Transaction Details
  • Viewing an Account Statement Report
• Balance and Transaction Reports
  • Report Descriptions
  • Report Filters
  • Printing a Report
  • Exporting Balance and Transaction Detail
• Exporting and Downloading Statements
• Searching for a Check or Deposit Ticket Item Image
• Creating an Alert

To view the Account Summary, select Account Summary from the Services g Information Reporting menu.

• The opening ledger and current available columns show the balances for the accounts.
• The balances are current as of the time listed in the “Last Updated” column. NOTE: If you have access to current day reporting, you will be provided with the current balance. You can also click “Refresh your List” to refresh the data every 2 minutes.

CUSTOMIZING THE ACCOUNT SUMMARY SCREEN

There are various functions available on the Account Summary to customize your view. Functions include:

• Manage Columns to remove or add columns of information
• Drag and drop columns to change the order of information
• A filter to limit the accounts (with associated information) based on set criteria. This function can be used on the Account Summary screen in order to locate an account or narrow the accounts in the view
• Create Account Groups that can be used in a filter
• Views to quickly select a saved customized view/filter

MANAGING COLUMNS

In the upper-right corner of the Account Summary is a “Manage Columns” link.

By clicking this link, you can select or deselect columns and click OK.

1

If you would like to change the order of the columns, you can simply drag-and-drop a column to your desired location.

USING VIEWS AND SAVING CUSTOMIZATIONS AS A VIEW

If you customize your Account Summary screen, once you leave the screen and return, the Account Summary will revert back to the default view. However, you can save your customizations as a new view and make it your default view if you prefer.

Click Manage next to the View drop-down.

CREATING AN ACCOUNT GROUP

If you have many accounts, you may wish to create Account Groups that can be used in a filter. For example, if your organization has many real estate properties with multiple accounts for each property, you can create an account group for each property.

Click the Account Groups link from the Account Summary.

Click the Add button.

Enter an Account Group Name. Click Add Accounts.

1

2

3 4

Select the accounts that you wish to include in the group. Click Use Selected Item. Accounts selected display for the Group.

5

6

Click Save. Click Close on the confirmation. The Account Group displays on the Account Groups screen. Click the Account Summary link to return to the Account Summary screen.

7 8 9

USING THE FILTER ON THE ACCOUNT SUMMARY SCREEN

The “Filter” function is available on almost all Information Reporting screens. This function can be used on the Account Summary screen in order to locate an account or narrow the accounts (with associated information) displayed in the view.

Click the Filter drop-down arrow to choose the field (column) on which to filter. For example:

• Choose Account Number or Account Nickname to locate a particular account. This is particularly helpful for organizations with many accounts.
• Choose Account Group to filter by a saved group.

1

(^2) Enter or select the criteria for the chosen field and click Go.

From this screen, you can: A. View additional advice transaction details for wires or ACH by clicking the View Details link in the Add’l Details column. (You may need to scroll to the right to see the Add’l Details column.)

Transaction Details display (Wire example included here):

• Click the Print or Export button to print or export the details.
• To return to the Transaction Details, click Cancel.
• To return to the Account Summary, click View Account Summary.

2

B. View an image of a check or deposit ticket by clicking the icon in the Image column.

C. An image will appear:

Balance and Transaction Reports

Balance & Transaction Reports

• Available history for Balance & Transaction Reporting (up to 18 months)

REPORT DESCRIPTIONS

Report Description

ACBS Facility Loan Report Displays details for all single or multiple deal facilities for Commercial loans.

Business Loan Detail Report Displays details for business lines of credit including rates, payoff amounts, amount due, etc.

Business Loan History Report Displays transaction history for business lines of credit including balance, interest paid, etc.

CD Balance Report Displays information on balance & interest earned for CDs.

Controlled Disbursements Displays funding requirements & details for Controlled Disbursements Detail Report accounts.

Inclearing Report Displays a report of all check transactions drawn on the account for a specific time period.

Lockbox Detail Report Displays detailed information about deposits made via Lockbox.

Pending NSF Items Report Displays an early window of all Not Sufficient Funds (NSF) items processed the evening before that will be evaluated by a Capital One Relationship Manager for payment. You may cover these items with a balance transfer to assist your Relationship Manager’s NSF review and decisioning.

Sweep Report Displays rate & earning details for accounts that utilize Sweep investment services.

Current Day Reports Description

Cash Position Report Displays opening account balances for the current day.

Current Day Displays opening ledger and available balances for each account. Availability Report

Current Day Transaction Displays all available detail about transactions for the current day. Detail Report

Current Day Transaction Displays a one-line summary of all current-day transactions. Clicking on a Summary Report transaction displays the details of the transaction.

Prior Day Reports Description

Account Statement Report Displays daily cash balances with debit and credit details for a specific period of time.

Prior Day Balance – Displays all posted balance information from prior day. The report is designed Export Format Report for use with the client applications or spreadsheets. Data is presented in simple columnar, comma-separated format suitable for exporting, without formatting, page headers/footers, group, or report totals.

Daily Balance History Report Displays the historical balances for the requested accounts.

Prior Day Transaction Displays all available detail about the transactions for the requested date Detail Report range.

Prior Day Transaction Displays a one-line summary of all prior-day transactions. Clicking on a Summary Report transaction displays the details of the transaction.

Prior Day Transaction – Displays the transactions, closing, and float balances for one or more Export Format Report accounts. The report is designed for use with third-party applications or spreadsheets. Data is presented in simple columnar, comma-separated format suitable for exporting, without formatting, page headers/footers, group, or report totals.

Running Balance Report Displays transactions by account, including transaction and balance totals for the account.

PRINTING OR EXPORTING A REPORT

At the top of the report are controls to print or export the report.

To print the report:

Click the printer icon at the top of the report. Follow the printing instructions specific to the browser being used.

To export the report:

Click the export icon at the top of the report. Follow the exporting instructions specific to the browser being used.

Print Export

1 2

1 2

EXPORTING BALANCE AND TRANSACTION DETAIL

The Export feature allows you to download specific bank account data in BAI, Quicken and QuickBooks format.

Select Export Information from the Services g Information Reporting menu. The Export Information screen shows existing export requests and their status.

Click the Create Export link.

Complete the Export Data form:

• Export Type: Select which format you would like to export the data to
• File Name: Enter the name you wish to use for the file
• Date Range: Select the date range from the options available
• Account Details: Specify the details you wish to download

1

2

3

Exporting and Downloading Statements

The Statements function allows you to search for and export statements issued by the Bank – such as eStatements (i.e. bank account statements) and Account Analysis statements. Statements will export in PDF format and will be available for download in a Zip file.

Select Statements from the Services g Information Reporting menu. The Statements screen displays.

Complete the search details:

• Statement Type: Options include eStatement and Account Analysis statement.
• Date Range: The date range of the statement – limited to a one-year time period at a time.
• Account Details: Select one or more accounts to be included.

1

2

Click View Results. Statements will display that match the search criteria. Select the Statements you wish to download. Click Download. A message will appear informing you that your request is being processed. A Zip file with the statements will be available from the Export Information screen. Select Export Information from the Services g Information Reporting menu. The Export Information screen shows existing export requests and their status.

3 4 5 6 7 8

For the exported item that contains your statements, click Download from the Actions drop-down menu. Follow the prompts to save the file.