Cash Management

This section provides details about Oracle Fusion ERP Analytics Cash Management subject area metrics.

Topics

Financials - Cash Management Bank Statements (Preview)

These metrics are in the Analytics Currency (AC) and Bank Account Currency (BC) and Foreign Currency (FC) fact folder in the subject area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Line Booking Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric Metric Definition
Bank Statements Count Shows the Total Count of Bank Statements.
Deposit Amount Shows the line amount where flow Indicator is credit. This metric is available in Bank Account Currency and Analytics Currency.
Line Amount Shows the Line amount for the bank statement line. This metric is available in Bank Account Currency and Analytics Currency and Foreign Currency if bank statement line shows the original amount in foreign currency.
Payment Amount Shows the line amount where flow indicator is Debit. This metric is available in Bank Account Currency and Analytics Currency.
Reconciled Amount Shows the line amount which have the line reconciliation status Reconciled. This metric is available in Bank Account Currency and Analytics Currency.
Reconciled Lines Count Shows the Count of Lines where statement Line Reconciliation Status is Reconciled.
Total Lines Count Shows the Total Lines Count.
Unreconciled Amount Shows the line amount which have the statement line reconciliation status Unreconciled. This metric is available in Bank Account Currency and Analytics Currency.
Unreconciled Lines Count Shows the Count of Lines where statement Line Reconciliation Status is Unreconciled.

Financials - Cash Management Bank Statement Balances (Preview)

These metrics are in the Analytics Currency (AC) and Bank Account Currency (BC) fact folder in the subject area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Balance Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric Metric Definition
Balance Amount Shows the Balance amount for the Balance Code selected in Bank Account Currency and Analytics Currency.
Closing Available Balance Shows the Balance amount for the balance code CLAV in Bank Account Currency and Analytics Currency.
Closing Booked Balance Shows the Balance amount for the balance code CLBD in Bank Account Currency and Analytics Currency.
Highest Balance Shows the Highest balance for the balance codes CLBD and CLAV in Bank Account Currency and Analytics Currency. This metric only works for period level or more.
Lowest Balance Shows the Lowest balance for the balance codes CLBD and CLAV in Bank Account Currency and Analytics Currency. This metric only works for period level or more.
Opening Available Balance Shows the Balance amount for the balance code OPAV in Bank Account Currency and Analytics Currency.
Opening Booked Balance Shows the Balance amount for the balance code OPBD in Bank Account Currency and Analytics Currency.

Financials - Cash Management External Cash Transactions (Preview)

These metrics are in the Analytics Currency (AC), Ledger Currency (LC), Bank Account Currency (BC), and Transfer Currency fact folder in the subject area. Analytics Currency and Exchange Rate Type are configured during product implementation. Exchange Rate date basis uses Accounting Date to convert to analytics currency. Metrics in these folders show amounts in their respective currencies.

Metric Metric Definition
Accounted Cash Amount Shows the External Transaction Accounted Amount for the Account Class Code 'Cash' in Bank Account Currency ,Ledger Currency and Analytics Currency
Accounted Offset Amount Shows the External Transaction Accounted Amount for the Account Class Code 'Miscellaneous Cash' in Bank Account Currency, Ledger Currency and Analytics Currency
Accounting Disabled External Transaction Amount Shows the External Transaction Amount where Account for Transaction is not enabled in Bank Account Currency
Accounting Enabled External Transaction Amount Shows the External Transaction Amount where Account for Transaction is enabled in Bank Account Currency
Average External Transaction Days Unreconciled Average No of days for which external transaction is unreconciled. Calculated as (System Date less External Transaction Creation Date)/Count of External Transactions. This is calculated for Unreconciled External Transactions
Credit Amount Shows the External Transaction Credit Amount in Bank Account Currency, Ledger Currency and Analytics Currency
Debit Amount Shows the External Transaction Debit Amount in Bank Account Currency, Ledger Currency and Analytics Currency
External Transaction Amount Shows the External Transaction Amount in Bank Account Currency
External Transactions Count Shows the Total Count of External Transactions
Net Amount Shows the External Transaction Net Amount in Bank Account Currency, Ledger Currency and Analytics Currency
Transfer Amount Shows the Bank Account Transfer or Ad Hoc Payments Amount in Transfer Currency