Skip to main content

Financial Advanced KPIs

The data model includes views such as Sales by Location: TY vs LY for comparing annual sales performance, Revenue Turnover Variances to analyze revenue variations, and Debt Ratio for assessing financial leverage. Measures like Ledger Debit, Ledger Credit, Revenue YTD, COGS LY Monthly, Working Capital YTD, Ledger Posting, Revenue YTD Running Total, and Interest Coverage Ratio provide insights into financial transactions, revenue generation, cost breakdowns, and financial health.

Benefits of This Data Model​

  • Improved Financial Performance Analysis: Enhances the ability to analyze revenue turnover variances and debt ratios for a more comprehensive assessment of financial health.
  • Enhanced Sales Comparison: Facilitates a detailed comparison of sales performance between current and previous years by location, leading to better decision-making.
  • Robust Insights into Transactions: Provides detailed insights into financial transactions, revenue generation, cost breakdowns, and working capital trends for informed strategic planning.

Key Performance Indicators (KPIs)​

  • Ledger Debit: The total amount recorded as a debit in the ledger.
  • Ledger Credit: The total amount recorded as a credit in the ledger.
  • Ledger Posting: The total number of ledger postings made.
  • Revenue YTD: The total revenue generated year-to-date.
  • Revenue YTD Running Total: The cumulative total revenue generated year-to-date.
  • COGS LY Monthly: The total cost of goods sold for the previous year broken down into monthly totals.
  • Working Capital YTD: The working capital amount at year-to-date.
  • Interest Coverage Ratio: A measure of a company's ability to cover its interest expenses with its earnings.

Available Visualisations​

View NameDescription
Sales by Location: TY vs LYCompares sales performance between current and previous years by location.
Revenue Turnover VariancesAnalyzes variations in revenue turnover to pinpoint key factors impacting financial performance.
Debt RatioCalculates the ratio of debt to assets to assess financial leverage and risk level.