Oracle Cash Management Command Center

This chapter covers the following topics:

• Cash Management Command Center Overview
• Manual Reconciliation Dashboard

Cash Management Command Center

Cash Management Command Center Overview

The Oracle Cash Management Command Center provides comprehensive insight into unreconciled transactions in your enterprise to enable you to streamline the manual reconciliation process. As a cash manager, you can monitor and manage the cash flow by ensuring that the recorded balance of the business and the banks match. As a cash accountant, you can compare bank statements with the available transactions to identify differences and to perform the reconciliation process.

Depending on your role, use the Cash Management Command center to:

• Accelerate the manual reconciliation process.

  • Complete the reconciliation task using a single interface in place of multiple windows in Oracle Cash Management.

  • Review all unreconciled statements using wide-ranging bank details.

  • Access all available transactions from different financial sources.

• Optimize and improve the reconciliation process.

  • Gain insight into the reconciliation status of transactions.

  • Investigate unreconciled lines.

  • Perform one-to-one or one-to-many reconciliations.

• Analyze transactions to identify variances.

  • Detect anomalies in accounting systems.

  • Monitor cash receipts and payments.

The Cash Management Command Center includes the Manual Reconciliation dashboard to enable you to review all unreconciled transactions and perform one-to-one and one-to-many reconciliation processes.

Important: The Cash Management Command Center shows data for a single ledger even if you have access to multiple ledgers with different currencies.

Note: You can use the Cash Management Command Center only after the installation and common configurations are completed as described in My Oracle Support Knowledge Document 2495053.1, Installing Oracle Enterprise Command Center Framework, Release 12.2. For additional ECC Overview information, see Overview of Enterprise Command Center Framework, Oracle E-Business Suite User's Guide.

Searching Enterprise Command Center Dashboards

To search for and refine (filter) the data on a dashboard, you can select a value from the Available Refinements component, or you can use the Search field to find a keyword, a value, or a specific record. When you submit a search, or select an available refinement, the search term or refinement is added to the Selected Refinements list, and all of the dashboard data is refined. You can add multiple refinements and remove any of them at any time. Use Saved Search to create and save your search. You can edit, delete, or refer to this saved search.

Use an asterisk (*) or a percent sign (%) to perform a partial keyword or record search that matches any string of zero or more characters. You can also use a question mark (?) to perform a partial search that matches any single character.

Additional Information: For more information about searching for and refining data in enterprise command centers, see Search in Highlights of an Enterprise Command Center, Oracle E-Business Suite User's Guide.

Manual Reconciliation Dashboard

See Cash Management Command Center Overview.

The Manual Reconciliation dashboard is an operational dashboard to enable to you to reconcile bank statement lines with available transactions so that cash records of your business are up to date and correct.

Use the dashboard to:

• Review unreconciled statement lines.

  • Use the default display of unreconciled bank statement lines.

  • Search for unreconciled statement lines using criteria such as a bank name, bank account name, transaction, or exchange rate.

• Perform the reconciliation process.

  • Identify unreconciled statement lines.

  • Examine unmatched lines by identifying transactions related to the bank statement line.

  • Verify the total of selected transactions.

  • Initiate the reconcile process using the Reconcile button.

  • Review matching records to confirm reconciliation.

  • View reconciliation record updates in real-time.

Access the Manual Reconciliation dashboard using the following navigation:

(N) Cash Management Manager (responsibility) > Cash Management Command Center

Manual Reconciliation Dashboard - Default UNRECONCILED Status

Manual Reconciliation Dashboard with the Selected Refinements Data

Statement Line and Available Transaction Selected

The following sections describe the dashboard.

Using the Search Box

When you navigate to the dashboard, the Bank Statements search box displays the default UNRECONCILED status code. The dashboard automatically shows unreconciled lines where the bank statement is incomplete. You can inspect these lines without performing a search.

The available transactions are loaded from the following financial sources:

• Oracle Payables

• Oracle Receivables

• Oracle General Ledger

• Oracle Payroll

• Oracle Cash Management

• External bank statements

You can begin investigating the lines or clear the default search.

To search for an unreconciled line:

1. Enter a search term in the Search box. The search engine searches the data sets and displays all values that match the entered text. These values are grouped under relevant attributes.

   Search

   

2. In the Search box, scroll down the list of attributes that contains the search term, which is highlighted. For example, when you enter the text Bank of, the search engine finds values that match the entered text, which belong to the Bank Account Label and Bank Name attributes.

3. In the attribute list, you can select the value that you want to search for or continue to type the text to refine the auto-suggested values further. When you refine your search, the Bank Statements search box displays the refinements as search sequence or breadcrumbs.

Using the Manual Reconciliation Dashboard Components

The following table describes the dashboard:

Component	Description
Bank Account (summarization bar)	Use the following key metrics to monitor the bank details and view information for the unreconciled statement lines. Bank Account: This metric shows the list of bank accounts for the selected bank. Select the required bank account. Bank Account Name: This metric shows the bank account name of the selected bank account. Bank Statements: This metric shows the list of bank statements for the chosen bank account. Unreconciled Lines: This metric shows the number of unreconciled bank statement lines
Manual Reconciliation (tabbed component) Statement Lines (results grid)	This grid lists details for the statement lines of the selected bank account. Use details such as the number, amount, date, and unreconciled amount to reconcile lines manually. The color code for statement line type and status helps you to identify the lines that require reconciliation. Note: You can select a single record for one-to-one and one-to-many reconciliation process.
Manual Reconciliation (tabbed component) Available Transactions (results table)	This results table lists the details about the available transactions that are ready to be matched with the unreconciled statement lines. Note: You can select multiple records for one-to-one and one-to-many reconciliation process.
Reconcile (button)	You can reconcile a bank statement line with a system transaction to perform one-to-one reconciliation or reconcile a bank statement line with many system transactions to perform one-to-many reconciliation. Example of a one-to-many reconciliation: When you reconcile a statement line amount 36850 of Misc Credit type with two available miscellaneous transactions with amounts 25350 and 11500 respectively. To reconcile bank statements manually: Search for the bank account number. In the Statement Lines table, select the bank statement line that you want to reconcile. Click the Record Details icon on the statement line row to review the bank statement line details such as the date, unreconciled amount, and description. Use the Amount filter to identify available transactions that match the selected bank statement line. In the Bank Available Transactions data set, select the Transaction attribute. Select Amount, and then From and To amount to filter by amount range for available transactions. Select the available transactions. Verify the total amounts in the footer summary in the Available Transactions results table before clicking the Reconcile button. Click Reconcile. The Reconciliation page appears. Reconciliation Page Review details in the Statement Line and Available Transactions regions. Review the difference before you click Submit. Click Submit. The Reconciliation confirmation message informs you that the reconciliation process is successfully completed. After the reconciliation process completes successfully, the dashboard updates the records to display real-time data. The number in the Unreconciled Lines metric is also updated to reflect the correct count of the unreconciled lines.