Account Summary (SI)

The data model incorporates financial account balances and performance metrics spanning various time frames and reports. It captures opening and ending balances, periodic and year-to-date postings, cash flow details, actual, budgeted amounts, and variances for accounts. Views like Trial Balance, Income Statement, Cash Flow, and Balance Sheet provide insights into account statuses, performance, and liquidity, supporting comprehensive financial analysis.

This data model is mainly used for the conversion from Sage Intelligence to Sage Enterprise Intelligence

Benefits of This Data Model

• Enhanced Financial Analysis: The data model enables in-depth financial analysis by providing comprehensive insights into account statuses, performance, and liquidity through views like Trial Balance, Income Statement, Cash Flow, and Balance Sheet.
• Improved Decision-making: With the incorporation of various time frames and performance metrics, stakeholders can make informed decisions based on accurate financial data captured in the model.
• Streamlined Reporting: By capturing opening and ending balances, periodic, and year-to-date postings, the data model facilitates streamlined and efficient reporting processes for financial account balances and variances.
• Holistic Overview: Through dimensions like Company Code, GL Account Code, Fiscal Year, and Account Type, the model offers a holistic overview of financial data, allowing for a more detailed analysis of different segments and groupings.
• Better Forecasting: The inclusion of measures such as Report Actual, Reporting Budget Actual, and Cash Flow Period Posting aids in better forecasting and budgeting by providing key financial indicators for planning purposes.

Key Performance Indicators (KPIs)

• Opening Balance: The initial balance of an account at the beginning of a period.
• PTD Posting: Posting made to the account during the current period-to-date.
• YTD Posting: Posting made to the account year-to-date.
• Ending Balance: The balance of the account at the end of a period.
• Report Actual: The actual reported value for an account.
• Report Debit: Total debits recorded for the account in a report.
• Report Credit: Total credits recorded for the account in a report.
• Report Debit Amount: Amount of debits recorded for the account in a report.
• Report Actual Variance: The variance between the reported actual value and another figure.
• Reporting Budget Actual: The actual amount compared to the budgeted amount in a report.
• Reporting Budget Budget: The budgeted amount for the account in a report.
• Reporting Budget Budget Variance: The variance between the budgeted amount and the actual amount in a report.
• Report YTD Posting: Year-to-date postings reported for the account.
• Report PTD Posting: Period-to-date postings reported for the account.
• Report Opening Balance (Year): Opening balance of the account for the year.
• Report Opening Balance (Period): Opening balance of the account for the period.
• Cash Flow Period Posting: Cash flow amount posted during the period.
• Cash Flow Year to Date: Cumulative cash flow amount year-to-date.
• End of Period Total Cash & Equivalent: Total cash and cash equivalents at the end of the period.
• Beginning of Year Total Cash & Equivalent: Total cash and cash equivalents at the beginning of the year.
• Report CF Posting: Cash flow postings reported for the account.
• Report IS Actual: Actual financial performance reported in the income statement.
• Report IS Actual LY: Actual financial performance reported in the income statement for the previous year.
• Report IS Actual Variance: Variance in actual financial performance in the income statement.
• Report Budget Actual: The actual amount compared to the budgeted amount in the income statement report.
• Report Budget Budget: The budgeted amount for the account in the income statement report.
• Report Budget Budget Variance: The variance between the budgeted amount and the actual amount in the income statement report.

Available Visualizations

View Name	Description
Trial Balance	Displays current account balances for analysis purposes.
Income Statement	Reflects revenue, expenses, and profits for a given period.
Cash Flow	Tracks cash inflows and outflows to evaluate liquidity.
Balance Sheet	Summarizes assets, liabilities, and equity at a specific date.