Balanced Scorecard

Use a Balanced Scorecard to align corporate objectives using Key Performance Indicators (KPIs).

To be successful, companies need to measure and monitor four key performance indicators:

  • Financial - profit
  • Customer Satisfaction
  • Quality - speed, quality, cost
  • Growth

These need to be linked from the corporate vision to short-term objectives, measures and targets for improvement.

Balanced Scorecard Process

  1. Have a facilitiated discussion to identify your:
    • financial goals and measures.
    • customer satisfaction measures.
    • quality objectives and measures for speed, quality and cost.
    • growth goals.
  2. Measure and monitor progress using control charts of KPIs.
  3. Reward employees based on results of Key Performance Indicators.

What is the QI Macros Balanced Scorecard Template?

  1. A way to link vision to goals to measures and targets.  This can be shown as a tree diagram or table.
  2. Display Balanced Scorecard Themes
  3. Identify Strategy Maps
  4. Create a Measurement Scorecard Dashboard

Balanced Scorecard Tree

Balanced Scorecard Table


Strategy Map

Scorecards and Dashboards

The QI Macros Balanced Scorecard includes a basic "heat map" style scorecard.

The QI Macros also include control chart dashboards for tracking all of your KPIs:

To create a Balanced Scorecard in Excel using the QI Macros...
Try It Now!

How We Can Help Download Free QI Macros Trial Buy QI Macros for Excel Now