Financial & Executive Dashboards: Finance & CEO

Financial and executive dashboards sit at the top of the reporting chain. Finance measures plan-vs-actual and cash; the CEO dashboard is the capstone that summarizes Finance plus every other function into one screen. They are paired because the CEO view is built directly from finance and the other domain dashboards. We use the foundation method for both.

Table of Contents

• Part A — Finance Dashboard
  • A1. Who Uses It and Why
  • A2. Data You Need
  • A3. Key KPIs
  • A4. Build KPIs with Copilot
  • A5. Charts to Include
  • A6. Budget Variance Alert
  • A7. ChatGPT Prompt to Plan It
  • A8. Suggested Layout
• Part B — CEO Dashboard
  • B1. Who Uses It and Why
  • B2. Data You Need
  • B3. Key KPIs
  • B4. Build the Scorecard with Copilot
  • B5. Charts to Include
  • B6. RAG Status
  • B7. ChatGPT Prompt to Plan It
  • B8. Suggested Layout

Part A — Finance Dashboard

A1. Who Uses It and Why

CFOs, controllers, and business owners use this to answer: Are we over or under budget? Is cash healthy? Where did the plan miss? It turns a ledger export into a control panel.

A2. Data You Need

Load a table named FinanceData with these columns:

A3. Key KPIs

• Total Revenue and Total Expense.
• Net Profit — revenue minus expense.
• Budget Variance % — (actual − budget) ÷ budget.
• Cash Balance — running total of cash flow.
• Current Ratio (if balance sheet present) — assets ÷ liabilities.

A4. Build KPIs with Copilot

Ask Copilot to add a variance column:

Add a column VariancePct as (Actual - Budget) / Budget.

KPI cards:

=SUM(FinanceData[Actual])-SUM(FinanceData[Budget])
=SUM(FinanceData[CashFlow])
=AVERAGE(FinanceData[VariancePct])

The net-profit card subtracts total budget from total actual as a simple stand-in for expense net.

A5. Charts to Include

• Combo — Actual vs Budget by Month (bars + target line).
• Column — Expense by Category.
• Line — Cash flow trend.

Copilot prompt:

Insert a combo chart of Actual versus Budget by month from FinanceData.

A6. Budget Variance Alert

Flag categories that overspent:

=IF([@VariancePct]>0.1,"Over","OK")

A variance above 10% is marked "Over" so finance can investigate.

A7. ChatGPT Prompt to Plan It

Design a finance dashboard in Excel from a table named FinanceData
with columns Account, Category, Month, Actual, Budget, CashFlow.
Give KPIs, charts, and a Copilot prompt to build it.

A8. Suggested Layout

Top: KPI cards (Net Profit, Cash Balance, Avg Variance). Middle: Actual-vs-Budget combo + Cash trend line. Bottom: Expense-by-category column. Slice by Month and Category.

Part B — CEO Dashboard

B1. Who Uses It and Why

The CEO and leadership team use this to answer: Are we healthy across revenue, cost, people, and delivery? It is a "summary of summaries" drawing KPIs from the Sales, Finance, HR, and Project dashboards you already built.

B2. Data You Need

Load a table named CEOScorecard with one row per metric:

Pull the values from your other dashboards using cell links, e.g. =SalesDashboard!B2.

B3. Key KPIs

• Revenue and Profit (from Finance/Sales).
• Cash Balance (from Finance).
• Headcount and Attrition (from HR).
• Customer / Student / Patient count (from domain dashboards).
• Strategic initiative status (from Project).

B4. Build the Scorecard with Copilot

Ask Copilot to add a status column:

Add a column Status as Green if Value >= Target, Amber if within 10%,
else Red.

KPI cards (link to source dashboards):

=FinanceDashboard!B4
=HRDashboard!B2
=ProjDashboard!B6

Each card shows the live number from its source sheet.

B5. Charts to Include

• Scorecard table — Metric, Value, Target, RAG.
• Combo — Revenue & Profit trend by month.
• Bar — Initiative progress (% complete).

Copilot prompt:

Insert a combo chart of revenue and profit by month from CEOScorecard.

B6. RAG Status

Use red/amber/green so the eye catches problems:

=IF([@Value]>=[@Target],"Green",
   IF([@Value]>=[@Target]*0.9,"Amber","Red"))

Green meets target, Amber is within 10%, Red misses.

B7. ChatGPT Prompt to Plan It

Design a CEO dashboard in Excel that summarizes revenue, profit, cash,
headcount, attrition, and project status from separate dashboard
sheets. Give the scorecard structure, charts, and a Copilot prompt.

B8. Suggested Layout

Top: KPI cards (Revenue, Profit, Cash, Headcount). Middle: RAG scorecard table. Bottom: Revenue-&-Profit combo + Initiative progress bar. Add a Month slicer that flows to source PivotTables.