Finance
The Finance module of COSMO Analytics (BC on Fabric).
The Finance module turns Dynamics 365 Business Central general-ledger data into an analytics-ready star schema for financial reporting. It covers the three core financial statements - income statement (P&L), balance sheet and cash flow - with profitability KPIs (EBIT, EBITDA, gross profit, net income), balance-sheet structure (equity, debt, assets), actual-vs-budget comparison, built-in time intelligence (PY, YoY, YoY %) and multi-currency / multi-company support, plus account-level drill-through into balances, movements and journal entries.
Key capabilities
- Income statement (P&L) analysis with actual, previous-year and budget comparison
- Profitability KPIs - gross profit, EBITDA, EBIT, net income and their margins
- Balance-sheet structure - assets, equity, debt and liquidity ratios
- Cash-flow analysis split into operating, investing and financing activities
- Cost-centre / financial-dimension reporting via the accounts report
- Account-level drill-through to balances, movements and journal entries
- Time intelligence (PY, YoY, YoY %) and multi-currency / multi-company support
Who is it for
| Persona | Focus |
|---|---|
| CFO | Steer profitability, financial structure and liquidity; monitor actuals vs. budget. |
| Controller | Budget adherence, margin quality, cost structure and financial-dimension analysis. |
| Accountant / Financial Analyst | Reconcile balances, trace account movements and validate ledger detail. |
| Executive (CEO / Managing Director) | Company-wide financial health at a glance - profit, structure and liquidity. |
Navigate the module
- Key business questions: What can I analyze?
- Semantic model: Overview · Facts · Dimensions · KPIs
- Standard reports: Overview · Overview · Income Statement · Accounts Report · Income Statement by Month · Balance Sheet · Cash Flow · Account Balance · Account Balance by Month · Account Movement
At a glance, the finance semantic model ships 238 measures, 26 dimensions and 1 fact table(s).
Tip
Have an ad-hoc finance question? Build your own report on the shipped semantic model in Power BI in just a few clicks - the measures, dimensions and time intelligence are ready to use.