Skip to main content

Cash Reconciliation

The Cash Reconciliation Dashboard provides a comprehensive overview of the reconciliation status of financial transactions between bank statements and accounting records. It helps finance teams monitor the volume, method, and timeliness of reconciliations across companies and accounts.

Key Metrics:​

  • Imported Entries: Total number of bank transactions imported into the system for reconciliation during the selected period.
  • Reconciled (Auto) Entries: Number of transactions automatically matched and reconciled by the system based on predefined rules.
  • Reconciled (Manual) Entries: Transactions manually reconciled by users when auto-matching is not possible.
  • Not Reconciled Entries: Transactions that remain unmatched and require investigation or follow-up.
  • Reconciled (Auto) %: The percentage of total transactions that were reconciled automatically.
  • Reconciled (Manual) %: The percentage of total transactions reconciled manually.
  • Not Reconciled %: The percentage of transactions that are still pending reconciliation.
  • YTD Imported Entries: Cumulative imported transactions from the start of the year to date.
  • YTD Reconciled Entries: Year-to-date summary of transactions reconciled (automatically and manually).
  • YTD Not Reconciled Entries: Year-to-date summary of transactions that have not been reconciled.

Visual Components:​

  • Bar Chart (Reconciliation by Account - Volume): Compares reconciliation activity (imported, auto/manual reconciled, not reconciled) for each account.
  • Bar + Line Chart (Reconciliation by Company - Volume): Displays reconciliation status split by company and allows comparison of reconciliation efficiency between entities.
  • Summary Cards (MTD & YTD): Highlights the overall reconciliation progress month-to-date and year-to-date for quick performance monitoring.
  • Aging Table (Non-Reconciled Aging): Categorizes unreconciled transactions based on how long they have been outstanding (e.g., 0–30 days, 31–60 days, etc.).
  • Transaction Table: Shows cash flow impact and unreconciled bank balances per company, supporting deeper financial insight.

Benefits:​

  • Financial Clarity: Tracks reconciliation progress to ensure books match actual bank balances.
  • Improved Risk Management: Flags unreconciled transactions that may indicate errors or fraud.
  • Operational Efficiency: Identifies where reconciliation is being done manually versus automatically to improve process automation.
  • Better Decision Making: Supports audit readiness and financial reporting with a clear view of reconciliation aging and trends.

Filtering​

You can filter the dashboards using these filtering panels:

  • Date Type
  • Year
  • Month
  • Account Interface
  • Bank
  • Account