Financials- Cash Management Bank Statement Balances (Preview)

Description

The subject area provides a detailed analysis of bank statement balances for the various balance codes, insights into last balance date, latest balance of a bank account as of a time period. It also includes bank statement header information such as reconciliation status, entry type, and detail bank account information for further analysis.

Business Questions

This subject area can answer the following business questions:

Job Roles

The following job roles secure access to this subject area:

Duty Roles

The following duty roles secure access to this subject area:

Primary Navigation

Home > Cash Management

Time Reporting

This subject area supports historic analysis of bank account balances. For period level or more reporting retrieves 24 months of balance data.

Time dimension is linked to Balance Date.

Transactional Grain

The grain is at the bank statement balance level.

Special Considerations

If statements are deleted in fusion, schedule full load of Cash Management functional area. When querying bank statement balances, selecting the Fiscal Period level (or above) provides the latest available balance for each account, referenced by the "Last Balance Date," but does not include specific statement details. For statement-level insights tied to particular dates, use the Fiscal Date level in your query. To review both balances and related statements within a period, include both Fiscal Period and Fiscal Date fields.