Skip to content
D-LIT Logo

Dashboards & Reporting

Financial dashboards for revenue, cost, and performance tracking.

By D-LIT Team

A financial dashboard is not a report with charts. It is a purpose-built decision support tool designed for a specific audience, answering a specific set of questions, with a deliberate information hierarchy that guides the viewer from summary to detail without requiring them to navigate spreadsheets or ask the finance team for context.

The dashboards in this guide are organized by the decisions they support, not by the data they contain. Each dashboard type has a defined primary audience, a specific set of metrics optimized for that audience’s decision-making responsibilities, and a set of design principles that make the information useful rather than decorative.

The metrics displayed in these dashboards are defined in Financial KPIs. The data that feeds them comes from the sources described in Data Sources. The analytical techniques that create the derived metrics and forecasts are covered in Techniques and Models.


CFO Executive Dashboard

Purpose: The CFO Executive Dashboard provides a single-screen view of the organization’s financial health, designed to answer the question “how is the business performing right now and where is it headed?” in under two minutes. It is the starting point for the CFO’s daily or weekly financial review and the primary communication tool for board meetings and investor updates.

Primary audience: Chief Financial Officer, CEO, Board Members, Investors.

Key metrics displayed:

  • Revenue (month-to-date, quarter-to-date, year-to-date) versus budget and prior year, with percent variance
  • Gross margin percentage, trend line for trailing 12 months
  • EBITDA and EBITDA margin, versus budget
  • Net income or net loss, versus budget
  • Operating cash flow, trailing 12 months
  • Current cash position and projected cash runway
  • Accounts receivable balance and DSO versus prior period
  • Budget-vs-actual variance summary (traffic light view by major P&L category)
  • Three-scenario revenue forecast for the next three quarters

Design principles:

The executive dashboard must load in under three seconds and be readable on a tablet without zooming. Every metric should display the current value, the comparison value (budget or prior period), and the variance with direction indication. Color coding should be used consistently and sparingly: green for positive variance, red for negative variance, yellow for within acceptable tolerance. Avoid gradient scales or complex color schemes that require a legend to interpret.

The layout should follow the income statement sequence from top to bottom: revenue, gross profit, operating expenses, EBITDA, net income. A right-side panel should show the balance sheet summary and cash position. A bottom panel should show the forward-looking forecast and key risk flags.

Avoid putting more than fifteen metrics on this dashboard. An executive who opens a dashboard with forty metrics will learn to ignore it. The discipline of selecting the fifteen most important metrics for the CFO’s view is itself a valuable strategic prioritization exercise.

Refresh cadence: Daily for operational metrics (cash, collections); weekly for P&L summary; monthly for budget-vs-actual comparison.


Revenue Dashboard

Purpose: The Revenue Dashboard provides a comprehensive view of revenue performance, composition, and trend, designed to answer questions about whether the business is growing as expected, where growth is coming from, and where it is falling short.

Primary audience: CFO, VP of Finance, FP&A leadership, CEO, Sales leadership.

Key metrics displayed:

  • Total revenue by period with prior-year comparison and growth rate
  • Revenue by business unit, product line, customer segment, and geography
  • New revenue (new customers) versus existing customer revenue (expansion and renewal)
  • Top-10 or top-20 customers by revenue contribution and year-over-year change
  • Monthly Recurring Revenue (MRR) or Annual Recurring Revenue (ARR) waterfall showing new, expansion, contraction, and churned components
  • Net Revenue Retention rate by cohort
  • Average Revenue Per User or Average Contract Value, trend line
  • Revenue concentration: percentage of revenue from top 1, 5, and 10 customers
  • Revenue pipeline to forecast: pipeline coverage ratio and expected close probability by quarter

Design principles:

The revenue dashboard should be designed for both regular review and ad hoc investigation. The top section should show the headline metrics that answer “are we on track?”. Below that, segmented breakdowns should allow the user to identify which segments are driving or dragging overall performance. At least one cohort view should be persistent on the dashboard, not buried in a drill-down, because retention trends are often the most strategically important signal in the revenue data.

Waterfall charts are particularly effective for displaying MRR or ARR movement because they make the components of change immediately visible. Line charts with a reference line for budget are the right format for revenue trend over time. Bar charts work well for revenue by segment comparisons.

Refresh cadence: Weekly for total revenue and MRR metrics; daily for pipeline and bookings data if the CRM integration supports it.


Profit and Loss Dashboard

Purpose: The P&L Dashboard provides a detailed income statement view with variance analysis and trend context, enabling the finance team and department leaders to understand profitability drivers and cost dynamics at the level of detail needed for management accountability.

Primary audience: CFO, VP of Finance, FP&A team, department heads accountable for specific P&L lines.

Key metrics displayed:

  • Full income statement with current period actuals, budget, prior year, and variance columns
  • Gross profit and gross margin by product line or service category
  • Operating expense breakdown by function (Sales and Marketing, Research and Development, General and Administrative), with headcount-normalized cost ratios (cost per employee, cost as percent of revenue)
  • EBITDA bridge: waterfall chart showing how EBITDA moved from the prior period, decomposed into revenue change, gross margin change, and operating expense change
  • Operating leverage ratio: revenue growth rate divided by operating expense growth rate (ratios above 1.0 indicate the business is scaling efficiently)
  • Year-over-year expense change by category with commentary on significant line items

Design principles:

The P&L dashboard walks a fine line between the summary level appropriate for executive review and the detail level needed for management analysis. Solve this with a two-tier design: a summary P&L in the top section showing major line items, with the ability to expand any line into its component accounts by clicking or filtering. This progressive disclosure approach keeps the dashboard readable at the summary level while making detailed investigation possible without leaving the dashboard.

Variance columns should display both absolute dollar variance and percentage variance side by side. Traffic light indicators on major line items enable rapid identification of problem areas. An EBITDA bridge waterfall is among the most analytically powerful single-chart formats available for P&L reporting; it should be a standard element of every P&L dashboard at the management level.

Refresh cadence: Monthly in alignment with the close cycle, with weekly preliminary views available as accruals and estimates are processed during the month.


Cash Flow Dashboard

Purpose: The Cash Flow Dashboard monitors the liquidity position of the organization, tracks the drivers of cash inflow and outflow, and displays both the historical cash flow statement and the forward-looking 13-week cash flow forecast. It is the primary tool for ensuring the organization can meet its near-term financial obligations and for planning capital deployment decisions.

Primary audience: CFO, Treasurer, VP of Finance, CEO (particularly in growth-stage or financially constrained organizations).

Key metrics displayed:

  • Current cash and equivalents balance, updated daily
  • Projected cash position by week for the next 13 weeks, displayed as a line chart with upper and lower scenarios
  • Cash flow from operations, investing, and financing activities: trailing 12 months, displayed as a stacked bar chart by month
  • Accounts receivable aging: current, 1 to 30 days past due, 31 to 60 days past due, over 60 days past due
  • Days Sales Outstanding, trend line with industry benchmark comparison
  • Days Payable Outstanding (how long the company takes to pay vendors), trend line
  • Upcoming large cash outflows: payroll dates, rent, debt service, major vendor payments
  • Cash runway at current and projected burn rate

Design principles:

The single most important element of the cash flow dashboard is the 13-week forward projection line chart. This should be prominent, updated at least weekly, and display alongside the actual cash balance as a reference point for how accurately the forecast tracked reality in prior periods. Forecast accuracy itself is a KPI worth tracking and displaying.

Accounts receivable aging should be displayed as a stacked bar chart by period, not as a single table, so the trend in aging is immediately visible. A rising proportion of receivables in the over-30-days-past-due bucket is a warning signal that should be visible at a glance.

Color coding on the runway metric is particularly high-stakes: green when runway exceeds 18 months, yellow between 9 and 18 months, red below 9 months. This threshold-based coloring ensures that the most operationally critical risk indicator cannot be missed in a dashboard review.

Refresh cadence: Daily for current cash balance; weekly for 13-week forecast; monthly for cash flow statement historical view.


Budget vs. Actual Dashboard

Purpose: The Budget vs. Actual Dashboard is the primary financial accountability tool for the organization. It compares planned financial performance to actual results across the full P&L, enables root-cause investigation of variances, and tracks reforecast accuracy over time. It is used in every monthly operating review.

Primary audience: CFO, FP&A team, department heads across the organization, CEO.

Key metrics displayed:

  • Full P&L with budget, actual, and variance columns for the current month and year-to-date
  • Variance percentage for each line item with sorting capability to surface the largest variances immediately
  • Variance trend: month-by-month variance history for the trailing 6 months, showing whether variances are improving or worsening
  • Department-level budget vs. actual view: each department’s total spend versus budget with major line items
  • Headcount budget vs. actual: planned headcount versus actual headcount by department, with dollar cost of the variance
  • Revenue-related variances: pipeline-to-forecast gap, win rate versus assumption, ASP versus assumption

Design principles:

The budget vs. actual dashboard must be accessible to non-finance leaders without requiring training. Department heads who own budget lines should be able to look at this dashboard and immediately understand their financial position without interpretation assistance from the finance team. Achieve this by using plain-language labels (not GL account codes), intuitive color coding, and a design that shows context alongside each number (what was expected, what actually happened, and by how much they differ).

Variance explanation should be integrated into the dashboard: allow department heads to enter brief written commentary on variances that exceed thresholds directly in the dashboard. When a board member asks why sales and marketing was 18% over budget in Q2, the CFO should be able to pull up the dashboard, click into the variance, and see the explanation that was captured in real time rather than reconstructing it from memory weeks later.

Refresh cadence: Monthly in alignment with close; preliminary views available during the month as estimates and accruals are processed.


Expense Management Dashboard

Purpose: The Expense Management Dashboard provides granular visibility into operational spending, identifying where costs are concentrated, how they trend over time, and where spending deviates from expected patterns. It is used both for ongoing cost management and for periodic cost optimization reviews.

Primary audience: CFO, VP of Finance, Finance Business Partners, Operations leaders, Procurement.

Key metrics displayed:

  • Total operating expenses by category and period, with prior-year comparison
  • Expense per employee by category: a key benchmarking metric for identifying areas where spend has scaled faster than headcount
  • Top vendors by spend: the 20 vendors that represent 80% of total vendor spend, with year-over-year change
  • Software and SaaS spend: vendor-by-vendor breakdown with annual contract value, renewal date, and per-seat cost
  • Travel and entertainment by department and person, trend over time
  • Expense report processing metrics: average time from submission to approval, percentage submitted on time, percentage requiring revision

Design principles:

The expense management dashboard should be designed for investigation, not just monitoring. The headline metrics at the top tell the summary story; every element below should support the ability to drill into the underlying detail. A vendor spend analysis that shows only totals by category is interesting; one that allows the viewer to click through to individual vendor contracts, invoices, and payment history is genuinely useful.

The software and SaaS spend view deserves particular attention. In most organizations, this is one of the fastest-growing and least-scrutinized cost categories. Surfacing per-seat costs alongside usage data (sourced from the SSO or identity provider) reveals which tools are actively used and which are underutilized, enabling informed renewal and consolidation decisions.

Refresh cadence: Monthly for budget comparison views; real-time or daily for expense report and vendor payment tracking.


Financial Forecast Dashboard

Purpose: The Financial Forecast Dashboard presents the organization’s forward-looking financial projections, including rolling forecast outputs, scenario analysis results, and the key driver assumptions that underlie the forecast. It is the primary communication tool for the FP&A function and the basis for strategic resource allocation decisions.

Primary audience: CFO, FP&A leadership, CEO, executive team, Board.

Key metrics displayed:

  • Rolling forecast for revenue, gross margin, EBITDA, and operating cash flow: next 4 to 8 quarters
  • Three-scenario view: downside, base, and upside for all major P&L metrics
  • Key driver assumptions with actual-to-assumption comparison: new logos, ASP, churn rate, headcount growth, gross margin rate
  • Forecast accuracy history: for each quarter in the trailing 8 quarters, the difference between the forecast made three months prior and the actual result
  • Sensitivity summary: the impact on EBITDA and cash runway of a 10% change in each of the five most influential drivers

Design principles:

Forecast dashboards should distinguish clearly between what is known (actuals) and what is estimated (forecast). Use visual differentiation such as solid lines for actuals and dashed lines for forecast periods. Scenario ranges should be displayed as shaded bands around the base case line, not as separate overlapping lines, to avoid visual complexity.

Forecast accuracy history is an underused but highly valuable element. When finance teams can demonstrate that their rolling forecast has been accurate within a defined tolerance consistently, it builds organizational trust in the planning process. When accuracy is inconsistent, the accuracy history view diagnoses where the process is breaking down and motivates improvement.

Refresh cadence: Monthly, in alignment with the close cycle and rolling forecast update cycle.


Financial Risk and Audit Dashboard

Purpose: The Financial Risk and Audit Dashboard monitors the indicators that signal control failures, fraud risk, compliance gaps, and covenant or regulatory thresholds approaching breach. It is used by the Controller, Internal Audit, and the CFO to maintain the financial integrity of the organization.

Primary audience: CFO, Controller, Internal Audit, Audit Committee of the Board, external auditors during review periods.

Key metrics displayed:

  • Journal entry monitoring: count of manual journal entries by period, with flags for entries above threshold values, entries posted outside normal business hours, or entries without supporting documentation
  • Expense anomaly flags: transactions that violate policy (over-limit expense reports, duplicate submissions, vendors not in approved list)
  • Accounts payable anomaly flags: invoices from new vendors, invoices clustering just below approval thresholds, invoices from vendors with addresses matching employee addresses
  • Covenant compliance: current values of each financial covenant with the distance to breach displayed as a percentage and absolute dollar amount
  • Concentration risk: percentage of revenue from largest customers, percentage of spend with largest vendors
  • Financial close checklist: completion status and timeliness of each close task, with trend of close cycle duration over time
  • Audit finding status: open findings from internal and external audits with target remediation dates and current status

Design principles:

The risk and audit dashboard must distinguish between issues that require immediate action and those that require monitoring. A three-tier alert system works well: red for items requiring immediate investigation, yellow for items approaching threshold, green for items within acceptable parameters. Every red or yellow flag should link directly to the underlying detail: the specific journal entry, the specific invoice, the specific covenant calculation.

Audit dashboards are often reviewed by people with deep accounting and compliance expertise but limited data visualization experience. Prioritize clarity and precision over visual sophistication. Tables and lists with clear labels and explanations are often more appropriate than charts for this audience. The goal is to make potential issues impossible to miss and to make investigation fast once an issue is identified.

Refresh cadence: Daily monitoring for anomaly detection; monthly for covenant compliance; quarterly for concentration risk review; real-time or near-real-time for high-risk transaction monitoring where the data infrastructure supports it.


Dashboard Implementation Principles

Across all eight dashboard types, several principles consistently distinguish dashboards that are actually used from dashboards that are opened once and forgotten.

Design for decisions, not data. Every metric on a dashboard should connect to a decision that someone in the intended audience is responsible for making. If no one is accountable for acting on a metric, it should not be on the dashboard.

Maintain a single source of truth. Dashboards should pull from the same governed financial data model. When different dashboards show different values for the same metric, organizational trust in financial analytics collapses. Tools like Plotono that integrate data pipelines with dashboard delivery can help enforce this single-source-of-truth discipline by connecting visualizations directly to governed data models. Invest in the data infrastructure described in Data Sources before investing in dashboard visual sophistication.

Update cadences should match decision cadences. A daily cash balance display that updates monthly creates a false sense of currency and undermines trust. Build dashboards where the refresh cadence is appropriate to how frequently the displayed information actually changes and how frequently the audience needs to act on it.

Start simple and add complexity with evidence. The instinct to build comprehensive dashboards from the beginning almost always produces dashboards that are too cluttered to use. Start with five metrics that answer the most important questions, confirm that the dashboard is actually being used and influencing decisions, and then add metrics incrementally with evidence that each addition addresses a real information need.

Invest in dashboard literacy. Even the best-designed dashboard requires its audience to understand what they are looking at and why it matters. Short training sessions, written guides, and embedded metric definitions (accessible by hovering over a metric label) reduce the learning curve and increase adoption.

When implemented with these principles, the dashboards described in this guide transform financial analytics from a reporting function into a strategic capability that drives better decisions at every level of the organization.

Get More from D-LIT

Ready to transform your analytics capabilities? Talk to our team about how D-LIT can help your organisation make better, data-driven decisions.

Get in Touch