General Ledger Detail Transactions

The data model includes views detailing financial amounts such as base and reporting currencies, previous period amounts, opening balances, debit and credit totals, and closing balances for both base and reporting periods. It also provides insights into financial activities at various levels, including base activity, reporting activity, and activity by cost center. The model supports internal account balance overviews, detailed reporting summaries, and cost center-specific data analysis for both internal and external purposes.

Benefits of This Data Model

• Enhanced Financial Reporting: The data model provides detailed insights into financial activities at various levels, including base and reporting currencies, previous period amounts, and opening/closing balances for accurate financial reporting.
• Cost Center Analysis: Enables in-depth analysis of financial data by cost center, allowing for better cost management and decision-making.
• Internal and External Reporting Support: Facilitates both internal account balance overviews and detailed reporting summaries, catering to different reporting needs for internal and external stakeholders.
• Historical Data Analysis: Offers historical reference dimensions and measures that enable analyzing past financial performance and trends for strategic planning.
• Transaction-Level Visibility: Provides transaction-specific details such as account codes, descriptions, currency types, and amounts for granular insights into financial activities.

Key Performance Indicators (KPIs)

• Amount Transaction: The actual amount involved in a specific financial transaction.
• Amount Reporting: The amount reported for a specific financial event or period.
• Amount Base: The amount considered as a base value in a financial context.
• Previous Amount Base: The base amount from the previous period in a financial context.
• Previous Amount Reporting Currency: The amount reported in the previous period in the currency used for reporting.
• Base Period Open Balance: The opening balance for a specific period in the base currency.
• Base Period Debit: The total debit amount for a specific period in the base currency.
• Base Period Credit: The total credit amount for a specific period in the base currency.
• Base Period Activity: The overall financial activity (debit and credit) for a specific period in the base currency.
• Base Period Closing Balance: The closing balance for a specific period in the base currency.
• Base Open Balance: The opening balance in the base currency.
• Base Credit: The total credit amount in the base currency.
• Base Debit: The total debit amount in the base currency.
• Base Closing Balance: The closing balance in the base currency.
• Reporting Period Open Balance: The opening balance for a specific period in the reporting currency.
• Reporting Period Debit: The total debit amount for a specific period in the reporting currency.
• Reporting Period Credit: The total credit amount for a specific period in the reporting currency.
• Reporting Period Activity: The overall financial activity (debit and credit) for a specific period in the reporting currency.
• Reporting Period Closing Balance: The closing balance for a specific period in the reporting currency.
• Reporting Open Balance: The opening balance in the reporting currency.
• Reporting Debit: The total debit amount in the reporting currency.
• Reporting Credit: The total credit amount in the reporting currency.
• Base Activity: The overall financial activity (debit and credit) in the base currency.
• Reporting Activity: The overall financial activity (debit and credit) in the reporting currency.
• Reporting Closing Balance: The closing balance in the reporting currency.

Available Visualizations

View Name	Description
Trail Balance (Base)	Overview of account balances for internal use
Trail Balance (Reporting)	Detailed summary for reporting purposes
Trail Balance by Cost Centre (Base)	Breakdown of balances by cost center for internal analysis
Trail Balance by Cost Centre (Reporting)	Cost center-specific data for external reporting purposes