Dynamics 365 Finance & Operations

General ledger & tax analysis

Reports and dashboards designed for critical analysis.

Key dashboards

  • Financial position High-level overview of the organization’s financial standing.
  • Cash & liquidity impact Provides understanding of how GL activity affects cash flow and liquidity.
  • Direct expense analysis Tracks and analyzes direct costs to control expenses and improve profitability.
  • Asset / liability analysis Monitors asset value, depreciation, and utilization to optimize asset performance and investment. Tracks liabilities by type and maturity.

Key metrics

  • Net profit margin
  • Inventory turnover
  • AR turnover
  • AP turnover
  • Quick ratio
  • Return on asset/liability
  • Revenue growth rate
  • Working capital
  • Current ratio
  • DIO, DPO, DSO
  • Operating cycle
  • Debt to equity ratio
  • Expense growth rate
  • DIO, DPO, DSO

Account summary reports

  • Trial balance Shows debits, credits, and balances for all GL accounts.
  • Account balance summary Summarizes balances across selected GL accounts.
  • GL account balance Breaks down account balances by financial dimensions (cost center, department, etc.)
  • Monthly GL balance trend Tracks month-over-month balance changes.
  • Inactive account list Lists GL accounts with no activity in a specified period.

Financial statement reports

  • Income statement (P&L) Summarizes revenue, expenses, and net income.
  • Balance sheet Lists assets, liabilities, and equity account balances
  • Cash flow statement Details cash inflows and outflows by activity
  • Working capital & liquidity position Evaluates liquidity through key ratios and balances.
  • Intercompany balance Summarizes outstanding balances between related legal entities for reconciliation.

Performance analysis

  • Budget variance Highlights key variances between actual, budget, and forecasted financials.
  • Revenue vs. expense growth Tracks revenue and expense changes over time
  • Multi-currency exposure Shows balance impacts from currency fluctuations and revaluations.
  • Asset vs liability composition Analyzes the proportion of assets and liabilities over periods based on GL balances.
  • Cost structure breakdown Breaks down expenses by fixed and variable costs across GL accounts.

Tax reports

  • Value-added tax (plus reversals) Tracks revenue and expense changes over time.
  • Withholding tax (plus reversals) Prepares the standard UK VAT return including output and input tax.
  • GST settlement report (for GST countries) Shows GST payable and settled amounts.
  • Tax transactions Listing of all tax transaction detail.