Skip to main content

Cash Flow Analysis

The Cash Flow Analysis Dashboard provides a comprehensive view of reconciled and unreconciled financial transactions, helping businesses monitor liquidity, budget alignment, and flow classifications across accounts and entities.

Key Metrics:​

  • Auto Reconciled: Total number and percentage of transactions automatically reconciled.
  • Manual Reconciled: Transactions that were manually matched and reconciled.
  • Not Reconciled: Transactions pending reconciliation, with total and percentage clearly highlighted.
  • Transaction Count: Total number of transactions per entity.
  • Converted Debit/Credit: Transaction values converted into a common reporting currency.

Visual Components:​

  • Gauge Charts (Reconciliation Rates): Show percentage of auto, manual, and unreconciled transactions.
  • Pie Charts (Top 5 Categories):
    • Top 5 Banks: Distribution of transactions by leading banks.
    • Top 5 Budgets: Allocation of transactions across main budget categories.
    • Top 5 Expenses Budget: Breakdown of expenses by budget code.
    • Top 5 Flow: Categorization of transactions by flow type (e.g., disbursement, receipt).
    • Top 5 Expenses Flow: Distribution of spending flows by type.
  • Data Table (Entity-wise Totals): Displays credit, debit, amount, and count per company or subsidiary.

Benefits:​

  • Streamlined Reconciliation Process: Quickly identifies which transactions need manual review.
  • Budget Tracking & Compliance: Assesses budget usage and flow alignment.
  • Operational Visibility: Tracks cash movements and flow decisions across the organization.
  • Informed Financial Decision-Making: Helps finance teams maintain healthy liquidity and compliance.

Filtering​

You can filter the dashboards using these filtering panels:

  • Year
  • Month
  • Account Interco
  • Transaction Status
  • Transaction Currency
  • Company
  • Bank
  • Bank Branch
  • Conversion Date
  • Date Type