GL Reconciliation (Cube)

The data model includes measures such as Bank Trn Amount, GL Amount, GL Trn Amount, Bank Amount, Qty Transactions, and various quantities and amounts based on different historical brackets. It also features metrics on reconciled and non-reconciled entries, year-to-date entries status, and counter values for expenses, revenue, debits, and credits in both bank and accounting systems. Views provide insights on general ledger results, bank entries, reconciliation, aged balances, and accounting entries for thorough financial analysis and decision-making.

Benefits of This Data Model

• Improved Financial Analysis: The data model provides insights into general ledger results, bank entries, aged balances, and accounting entries, enabling thorough financial analysis for informed decision-making.
• Enhanced Reconciliation Accuracy: With metrics on reconciled and non-reconciled entries, the model supports the reconciliation process by identifying discrepancies and enhancing financial accuracy.
• Efficient Performance Metrics: The model offers performance metrics related to assets, debts, and reconciliation statistics for evaluating financial performance and efficiency.
• Visibility into Historical Trends: By tracking historical data for GL reconciliation processes, the model allows users to analyze trends and patterns over time, aiding in strategic financial planning.
• Detailed Rule Analysis: The model includes statistics on the rules applied in the reconciliation process, providing insights into the effectiveness of the rules and facilitating process improvements.

Key Performance Indicators (KPIs)

• Bank Trn Amount: Total amount of bank transactions.
• GL Amount: Total amount in the GL (General Ledger).
• GL Trn Amount: Total amount of GL transactions.
• Bank Amount: Total amount in the bank account.
• Qty Transactions: Quantity of transactions.
• Qty History le @@GL_AGEBRACKET01 Jours: Quantity of transactions with history less than or equal to a specified number of days.
• Qty History gt> @@GL_AGEBRACKET01 Jours: Quantity of transactions with history greater than a specific number of days.
• Qty History gt @@GL_AGEBRACKET02 Jours: Quantity of transactions with history greater than another specified number of days.
• Qty History gt @@GL_AGEBRACKET03 Jours: Quantity of transactions with history greater than yet another specified number of days.
• Amount le @@GL_AGEBRACKET01 Jours: Amount of transactions with history less than or equal to a specific number of days.
• Amount gt @@GL_AGEBRACKET01 Jours: Amount of transactions with history greater than a certain number of days.
• Amount gt @@GL_AGEBRACKET02 Jours: Amount of transactions with history greater than another specified number of days.
• Amount gt @@GL_AGEBRACKET03 Jours: Amount of transactions with history greater than yet another specified number of days.
• Postings Imported: Number of postings that have been imported.
• Reconciled (Auto) Entries: Number of entries reconciled automatically.
• Reconciled (Auto) %: Percentage of entries that are reconciled automatically.
• Reconciled (Manual) Entries: Number of entries reconciled manually.
• Reconciled (Manual) %: Percentage of entries that are reconciled manually.
• Non Reconciled Entries: Number of entries that are not reconciled.
• Non Reconciled %: Percentage of entries that are not reconciled.
• YTD Imported Entries: Number of year-to-date imported entries.
• YTD Reconciled (Auto) Entries: Number of year-to-date entries reconciled automatically.
• YTD Reconciled (Auto) %: Percentage of year-to-date entries reconciled automatically.
• YTD Reconciled (Manual) Entries: Number of year-to-date entries reconciled manually.
• YTD Reconciled (Manual) %: Percentage of year-to-date entries reconciled manually.
• YTD Non Reconciled Entries: Number of year-to-date entries that are not reconciled.
• YTD Non Reconciled %: Percentage of year-to-date entries that are not reconciled.
• Counter value Expense (Bank): Value of expenses in the bank account.
• Counter value Revenue (Bank): Value of revenue in the bank account.
• Counter value Entry (Bank): Value of all entries in the bank account.
• Counter value Debit (Accounting): Value of debits in the accounting system.
• Counter value Credit (Accounting): Value of credits in the accounting system.
• Counter value Entry (Accounting): Value of all entries in the accounting system.

Available Visualizations

View Name	Description
All GL Results	Provides a comprehensive view of all general ledger results for financial analysis.
All Bank Entries	Displays all bank entries for reconciliation and analysis of financial transactions.
GL Reconciliation	Central view for reconciling general ledger and bank entries for financial accuracy.
Non-Reconciled Bank Entries	Highlights bank entries that have not been reconciled for potential investigation.
COMPANY AST	Offers insights and performance metrics related to assets for financial decision-making.
GL Reconciliation History	Tracks historical data for GL reconciliation processes and audits for reference.
Aged Balance Amount	Shows the aging of balance amounts for monitoring financial health and trends.
Reconciliation statistics	Provides key statistics and metrics on the reconciliation process efficiency and accuracy.
COMPANY DSC	Offers insights and performance metrics related to debts for financial decision-making.
Rules Statistics	Analyzes and presents statistics on the rules applied in the reconciliation process.
All Accounting Entries	Comprehensive view of all accounting entries for financial analysis and reporting.
Non-Reconciled Accounting Entries	Identifies accounting entries that have not been reconciled for further investigation.