11Oracle Fusion Cash Management Reports

This chapter contains the following:

Oracle Fusion Cash Management Predefined Reports

Oracle Fusion Cash Management provides predefined reports that are used in the following areas:

  • Bank Statements

  • Cash Transit

  • Reconciling to the General Ledger

Scheduled Processes Work Area

You can schedule and run reports from the Scheduled Processes work area in the Tools section of the Navigator.

Reports and Analytics Work Area

In some cases, reports are also:

  • Accessed from the Reports and Analytics work area in the Tools section of the Navigator or from other work areas.

  • Opened using links that launch the Oracle Business Intelligence Catalog.

The following tables list the predefined reports by type:

Bank Statement Reports:

Report Name Description Parameters (*Required)

Bank Statement Report

Displays the bank statements that are used to analyze balances and transaction details.

  • *Bank Account

  • *From Statement End Date

  • *To Statement End Date

Bank Statement Analysis Report

Displays bank statements used to analyze balances and transaction details.

NA

Cash Transit Report

Report Name Description Parameters (*Required)

Cash in Transit Report

Lists all transactions for a specific bank account, that have been remitted to the bank but haven't been cleared. The report excludes all voided transactions and all reversed transactions with a reversal date on or prior to the As of Date.

  • *Bank Account

  • Transaction Source

  • As-of Date

Cash to General Ledger Report

Report Name Description Parameters (*Required)

Cash to General Ledger Reconciliation Report

Displays bank statement transactions and general ledger accounting entries that haven't been reconciled and can cause discrepancies. The report is used to reconcile bank balances to general ledger cash balances.

  • *Bank Account

  • *Accounting Period

To run predefined reports, navigate to the Scheduled Processes work area and follow these steps:

  1. Click the Schedule New Process button.

  2. Search the Process Name.

  3. Enter the parameters.

  4. Enter the applicable process options and schedule.

  5. Click Submit.

Cash Management Bank Statement Report

This topic includes details about the Cash Management Bank Statement Report.

Overview

The Cash Management Bank Statement Report displays bank account balances and transaction information for specific bank statements. The following figure is an example of the report:

This graphic illustrates the Bank Statement Report
in detail.

Key Insights

The Cash Management Bank Statement Report is used for reviewing activity of a specific bank account.

Report Parameters

The following table describes required process parameters:

Name Description

Bank Account

The specific bank account used to receive payments and disburse funds.

From Statement End Date

Starting date range of the activities for the account.

To Statement End Date

Ending date range of the activities for the account.

Frequently Asked Questions

The following table lists frequently asked questions about the Cash Management Bank Statement Report.

FAQ Answers

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Cash Manager

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use this report to review the bank statement of a specific bank account over a selected period.

What can I do with this report?

You can use this report to review bank statements and their reconciliation status.

What type of report is this?

Oracle Business Intelligence Publisher

Cash in Transit Report

This topic includes details about the Cash in Transit Report.

Overview

The Cash in Transit Report lists, for a specific bank account, all transactions that have been remitted to the bank but haven't been cleared. The Cash in Transit report excludes the following:

  • All voided transactions

  • All reversed transactions with a reversal date on or prior to the As of Date

The following figure is an example of the cash in transit report:

This graphic illustrates the Cash in Transit Report
payments made from the bank account selected.

Key Insights

The Cash in Transit Report lists the transactions that are created but haven't been cleared as of a specific date.

Report Parameters

The following table describes required process parameters:

Name Description

Bank Account

The specific bank account used to receive payments and disburse funds.

Transaction Source

The origin of the transaction, such as payables or receivables.

As of Date

The date when the transaction status is checked.

Frequently Asked Questions

The following table lists frequently asked questions about the Cash in Transit Report.

FAQ Answers

How do I find this report?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses this report?

  • Cash Manager

  • Financial Manager

  • Financial Specialist

When do I use this report?

Use this report to review the transactions of a specific bank account that have been remitted but haven't been cleared.

What can I do with this report?

Identify transactions that haven't been cleared as of a specific date.

What type of report is this?

Oracle Business Intelligence

Cash to General Ledger Reconciliation Report

This topic provides information about the Cash to General Ledger Reconciliation Report.

Overview

The Cash to General Ledger Reconciliation Report compares the GL cash account balance against the bank account balance. It displays the unreconciled GL cash account journal entries and unreconciled bank statement lines that help identify the discrepancies between the balances. This is done based on the specified range of periods.

The body of the Cash to General Ledger Reconciliation
Report.

Key Insights

The Cash to General Ledger Reconciliation Report lists the subledger transactions that are accounted in GL but they are not reconciled in Cash Management.

Consider assigning a unique GL cash account for each bank account and using it to record all cash transactions to facilitate this book to bank reconciliation.

Report Parameters

The following table describes required process parameters:

Name Description

Bank Account

The specific bank account used to receive payments and disburse funds.

From Accounting Period

The first fiscal period a company uses to report financial results, such as a calendar month or fiscal period. A portion of time in which the accounting calendar may be divided. Accounting periods make up an accounting calendar.

To Accounting Period

The ending fiscal period a company uses to report financial results, such as a calendar month or fiscal period. A portion of time in which the accounting calendar may be divided. Accounting periods make up an accounting calendar.

Frequently Asked Questions

The following table lists frequently asked questions about the Cash to General Ledger Reconciliation Report.

FAQ Answers

How do I find these reports?

Schedule and run this report from the Scheduled Processes work area on the Navigator menu.

Who uses these reports?

  • Cash Manager

  • Financial Manager

  • Financial Specialist

When do I use these reports?

Use this report to:

  • Review and identify the discrepancies in the bank account balances in Cash Management and the GL cash account balance.

What can I do with this report?

Reconcile bank balances to the general ledger cash account balances.

What type of reports are these?

Oracle Business Intelligence Publisher