Skip to main content

GL Transaction Details with Account Pyramid

The data model includes views such as GL Transaction Details with Account Pyramid, General Ledger Summary, Account Balance Trend, Account Pyramid Breakdown, and Transaction Type Analysis. Measures like Ledger Posting, Transaction Posting, Reporting Currency Posting, Global Debit, Global Credit, and Global Posting enable tracking of debit, credit, and posting amounts across transactions, ledger accounts, and currencies for robust financial analysis and decision-making purposes.

Benefits of This Data Model​

  • Enhanced Financial Analysis: The data model allows for robust financial analysis by tracking debit, credit, and posting amounts across transactions, ledger accounts, and currencies.
  • Efficient Hierarchical Analysis: With dimensions such as Pyramid Level 1 to Level 9, the model enables efficient analysis of hierarchical account structures for in-depth insights.
  • Comprehensive Trend Monitoring: The Account Balance Trend view helps monitor financial health by displaying trends in account balances over time, facilitating proactive decision-making.
  • Detailed Transaction Insights: The GL Transaction Details view provides detailed transaction information along with the hierarchical account structure, aiding in thorough transaction analysis.
  • Anomaly Identification: Transaction Type Analysis view helps in identifying patterns and anomalies in transaction types, which can be beneficial for making informed decisions.

Key Performance Indicators (KPIs)​

  • Ledger Debit: The amount debited from a specific ledger account in a transaction.
  • Ledger Credit: The amount credited to a specific ledger account in a transaction.
  • Ledger Posting: The total amount posted to a specific ledger account in a transaction (sum of debit and credit).
  • Transaction Debit: The amount debited in a transaction, across all ledger accounts.
  • Transaction Credit: The amount credited in a transaction, across all ledger accounts.
  • Transaction Posting: The total amount posted in a transaction (sum of debit and credit across all accounts).
  • Reporting Currency Debit: The amount debited in a transaction, converted to the reporting currency.
  • Reporting Currency Credit: The amount credited in a transaction, converted to the reporting currency.
  • Reporting Currency Posting: The total amount posted in a transaction, converted to the reporting currency.
  • Global Debit: The total amount debited in all transactions, across all ledger accounts and currencies.
  • Global Credit: The total amount credited in all transactions, across all ledger accounts and currencies.
  • Global Posting: The total amount posted in all transactions, across all ledger accounts and currencies.

Available Visualisations​

View NameDescription
GL Transaction Details with Account PyramidProvides detailed transaction information and hierarchical account structure for analysis.