Skip to main content

GL Reconciliation Result

The data model includes views such as Transaction Bank Amount, Transaction GL Amount, Countervalue Bank Amount, Countervalue GL Amount, Entry Count, Discrepancy, Import Entries, Reconciled Entries (Auto and Manual), Not Reconciled Entries, YTD Metrics, and Historical Count for different age brackets. These measures capture the financial reconciliation process, including automatically and manually reconciled entries, discrepancies, and aging analysis for non-reconciled balances to assess financial health and reconciliation performance effectively.

Benefits of This Data Model​

  • Improved Financial Health Analysis: The data model enables detailed analysis of non-reconciled balances aging, allowing for better assessment of financial health over time.
  • Enhanced Reconciliation Performance: With measures such as reconciled entries (auto and manual) and discrepancies, the model facilitates monitoring and improving reconciliation performance effectively.
  • Comprehensive Insights into GL Reconciliations: The inclusion of views like All GL Results provides a comprehensive view of all GL reconciliations, offering valuable insights into overall financial health.
  • Efficient Action Planning: The Non-Reconciled Balance Aging view assists in identifying aged imbalances, enabling timely action planning and reducing financial risks.

Key Performance Indicators (KPIs)​

  • Transaction Bank Amount: The total amount of transactions in the bank side.
  • Transaction GL Amount: The total amount of transactions in the GL side.
  • Countervalue Bank Amount: The total countervalue amount in the bank side.
  • Countervalue GL Amount: The total countervalue amount in the GL side.
  • Entry Count: The total count of entries in the reconciliation result.
  • Discrepancy: Any discrepancy found during the reconciliation process.
  • Amount le @@GL_AGEBRACKET01 Days: Total amount reconciled within a specific age bracket (e.g., 30 days).
  • Amount gt @@GL_AGEBRACKET01 Days: Total amount reconciled over a specific age bracket (e.g., 30 days).
  • Imported Entries: The count of imported entries.
  • Reconciled (Auto) Entries: The count of automatically reconciled entries.
  • Reconciled (Auto) %: The percentage of entries automatically reconciled.
  • Reconciled (Manual) Entries: The count of manually reconciled entries.
  • Reconciled (Manual) %: The percentage of entries manually reconciled.
  • Not Reconciled Entries: The count of entries that are not reconciled.
  • Not Reconciled %: The percentage of entries that are not reconciled.
  • YTD Imported Entries: Year-to-date count of imported entries.
  • YTD Reconciled (Auto) Entries: Year-to-date count of automatically reconciled entries.
  • YTD Reconciled (Auto) %: Year-to-date percentage of entries automatically reconciled.
  • YTD Reconciled (Manual) Entries: Year-to-date count of manually reconciled entries.
  • YTD Reconciled (Manual) %: Year-to-date percentage of entries manually reconciled.
  • YTD Not Reconciled Entries: Year-to-date count of entries that are not reconciled.
  • YTD Not Reconciled %: Year-to-date percentage of entries that are not reconciled.
  • Historical Count le @@GL_AGEBRACKET01 Days: Historical count of reconciled entries within a specific age bracket.
  • Historical Count gt @@GL_AGEBRACKET01 Days: Historical count of reconciled entries over a specific age bracket.
  • Historical Count gt @@GL_AGEBRACKET02 Days: Historical count of reconciled entries over another specific age bracket.
  • Historical Count gt @@GL_AGEBRACKET03 Days: Historical count of reconciled entries over yet another specific age bracket.

Available Visualizations​

View NameDescription
Non-Reconciled Balance AgingView displaying aging of non-reconciled balances for detailed analysis and action.
All GL ResultsComprehensive view of all GL reconciliations providing insights into overall financial health.