Dashboards & Reporting

When you open this playbook in the Profit System, you will find:

• Action 1: Executive Dashboard Design

  Build a single-screen view of the business that answers "are we winning?" in seconds. Revenue, profit, cash, customers, team — the vital signs that matter most to the owner.

  Show full action →

  Hide full action

  What to Do

  Build a single-screen view of your business that answers "are we winning?" in under 30 seconds. This is your CEO cockpit - the one page you check every morning before doing anything else. It covers revenue, profit, cash, customers, and team vital signs. Nothing more.

  The goal is not to track everything. The goal is to track the right things so you can spot problems early and make faster decisions.

  Why It Matters

  Most business owners either look at nothing (flying blind) or look at too much (drowning in data). Neither helps. An executive dashboard gives you the critical numbers in one place so you stop guessing and start knowing. When something goes wrong, you see it in days, not months. When something goes right, you can double down immediately.

  How to Use This

  Work through the checklist below to decide what belongs on your dashboard, then build it using whatever tool you already have. A spreadsheet works fine. Don't buy software until the habit is established.

  ---

  Dashboard Design Checklist

  • [ ] Pick your dashboard tool - Google Sheets, Excel, Notion, or your accounting software's built-in dashboards. Use what you already know. Fancy tools don't help if nobody opens them.
  • [ ] ⚡ Quick Win: Write down the 3 questions you ask yourself every Monday - These reveal what actually matters to you. "Did we hit target?" "How much cash do we have?" "Are clients happy?" Your dashboard should answer these instantly.
  • [ ] Choose your revenue metrics (pick 2-3) - Revenue this month vs target, revenue vs same month last year, recurring revenue vs one-off. Don't track all of them. Pick the ones that tell you most.
  • [ ] Choose your profit metric - Gross profit margin or net profit margin. One number. If it's dropping, you investigate. If it's stable or rising, you move on.
  • [ ] Add your cash position - Cash in bank right now, plus projected cash in 4 weeks. Link this to your 13-week forecast if you have one.
  • [ ] Choose your customer metrics (pick 2-3) - Active clients, new clients this month, client churn rate, average revenue per client, or NPS. Pick the ones that would keep you up at night if they moved in the wrong direction.
  • [ ] Add one team vital sign - Team capacity, open roles, or a simple "team health" rating. Just one. You're not building an HR dashboard here.
  • [ ] Choose one leading indicator - Something that predicts next month's results. Pipeline value, proposals sent, discovery calls booked, or website enquiries. Leading indicators give you time to act.
  • [ ] Set a target or benchmark for every metric - A number without context is useless. Every metric needs a target, a previous period comparison, or an industry benchmark next to it.
  • [ ] Use traffic light colours - Green (on track), amber (watch it), red (act now). Visual signals mean you can scan the whole dashboard in seconds.
  • [ ] Remove anything that doesn't trigger a decision - If a metric being high or low wouldn't change what you do this week, it doesn't belong on your executive dashboard. Be ruthless.
  • [ ] Build the first version - Get all your chosen metrics onto one screen. It will be rough. That's fine. A working ugly dashboard beats a beautiful one that never gets built.
  • [ ] ⚡ Quick Win: Set it as your browser homepage or phone wallpaper - Make it impossible to avoid. The best dashboard is the one you actually look at.

  ---

  Expected Outcome

  • You can answer "how is the business doing?" in 30 seconds flat
  • Problems show up in days, not months
  • You stop relying on gut feel for major decisions
  • Team meetings start with facts, not opinions
  • You spend less time buried in spreadsheets because the important stuff is already visible

  Coach Notes

  Start with fewer metrics, not more. Most owners want to track 20 things. Push them to pick 8-10 maximum. If it doesn't fit on one screen, it's too much. The first version will be wrong - that's expected. After 2-3 weeks of use, they'll know exactly which metrics they actually look at and which ones they skip. Refine then. The biggest risk is overdesign. Get something live in the first session, then improve it over time.

• Action 2: Department Scorecards

  Create focused dashboards for each area of the business so team members can see their performance and take ownership of their results. Sales, operations, marketing, finance — each gets their own scorecard.

  Show full action →

  Hide full action

  What to Do

  Build a focused dashboard for each key area of your business - sales, operations, marketing, and finance - so the people running those areas can see their own performance without waiting for you to tell them. Each scorecard should answer: "Is my area performing? Where do I need to focus?"

  This is about pushing visibility down. When team members can see their own numbers, they take ownership. When they can't, everything flows back to you.

  Why It Matters

  Your executive dashboard tells you how the whole business is doing. Department scorecards tell each team how their area is doing. Without them, the only person who knows whether marketing is working is you. The only person who knows whether operations is on track is you. That's not leadership, that's bottleneck creation. Scorecards create ownership, accountability, and faster decisions at every level.

  How to Use This

  Pick the department that needs visibility most urgently (usually sales or operations). Build that scorecard first. Then repeat for other areas. Don't try to build all four at once.

  ---

  Step 1: Choose Your Departments

  • [ ] List the 3-5 key areas of your business - Common ones: Sales, Marketing, Operations/Fulfilment, Finance. Yours might be different. Use whatever matches how you actually run things.
  • [ ] Assign an owner for each area - Who is responsible for this area's results? If the answer is "me" for everything, that's a problem this action will help surface.
  • [ ] ⚡ Quick Win: Start with the area that causes you the most stress - That's where visibility will have the biggest immediate impact.

  Step 2: Design Each Scorecard

  For each department, work through these items:

  • [ ] Pick 4-6 metrics that define success for this area - Sales might be: pipeline value, proposals sent, close rate, revenue booked, average deal size. Operations might be: on-time delivery, client satisfaction, capacity utilisation, rework rate.
  • [ ] Include at least one leading indicator - A metric that predicts future performance, not just reports past performance. Sales: discovery calls booked. Marketing: qualified leads. Operations: project backlog.
  • [ ] Set targets for every metric - The department owner should have input here. Targets imposed from above get ignored. Targets agreed together get chased.
  • [ ] Choose an update frequency - Weekly for fast-moving areas (sales, marketing). Monthly for slower areas (finance, HR). Match the rhythm to the reality.
  • [ ] Decide who updates it - The department owner, not you. If they won't update their own scorecard, that tells you something important about ownership.

  Step 3: Connect to Your Executive Dashboard

  • [ ] Link the top-line number from each scorecard to your executive dashboard - Your executive view shows the summary. The scorecard shows the detail. Two layers, not one giant mess.
  • [ ] Set up a simple review rhythm - Each department reviews their scorecard weekly. You review the executive dashboard daily and do a deeper dive with department owners monthly.
  • [ ] Document what "red" means for each metric - At what point should someone escalate to you? Define this upfront so people know when to flag and when to handle it themselves.
  • [ ] ⚡ Quick Win: Send the first scorecard to the department owner today - Don't wait until they're all perfect. One working scorecard this week beats four perfect ones next month.

  ---

  Expected Outcome

  • Each key area has its own visible performance tracker
  • Team members can see how they're doing without asking you
  • Problems surface faster because the people closest to the work spot them first
  • Your executive dashboard gets cleaner because detail lives in department scorecards
  • Accountability conversations shift from "I think" to "the numbers show"

  Coach Notes

  The most common pushback is "we're too small for this" or "everyone already knows how things are going." Challenge that. Ask: "If your sales person left tomorrow, how would you know within a week whether their replacement was performing?" If the answer involves gut feel, they need a scorecard. Start with one department. Get it working. Let the owner experience the benefit. Then the other departments will want their own.

• Action 3: Exception Reporting System

  Set up alerts that flag anomalies before they become problems. Automatic notifications when key metrics move outside normal ranges so you can act fast.

  Show full action →

  Hide full action

  What to Do

  Create a set of automatic alerts that flag when key metrics move outside normal ranges. Instead of checking every number every day, you get notified only when something needs attention. Think of it as a smoke alarm for your business - it stays quiet until there's a problem.

  This builds on your executive dashboard and department scorecards. Those show you the current picture. Exception reporting taps you on the shoulder when something changes unexpectedly.

  Why It Matters

  You can't watch every number every day. And you shouldn't have to. The businesses that catch problems early aren't the ones with the most dashboards. They're the ones with the best alerts. A cash balance dropping below a threshold, a client churn spike, a sudden drop in sales pipeline - these are the signals that need immediate attention. Everything else can wait for the weekly review.

  How to Use This

  Work through the steps in order. You're defining what "normal" looks like, setting boundaries around it, and building alerts for when things go outside those boundaries.

  ---

  Step 1: Define Your Critical Metrics

  • [ ] List the 6-8 metrics that would cause real damage if they moved sharply in the wrong direction - Cash balance, monthly revenue, client count, pipeline value, gross margin, debtor days. Focus on the ones where a week's delay in spotting a problem costs real money.
  • [ ] ⚡ Quick Win: Start with cash - Set an alert for when your bank balance drops below your minimum comfort level (typically 1-2 months of fixed costs). This alone prevents most cash crises.
  • [ ] Exclude vanity metrics - Website traffic, social media followers, email open rates. These rarely need exception alerts. Focus on metrics tied directly to revenue, profit, cash, and customers.

  Step 2: Set Your Thresholds

  • [ ] For each metric, define "normal range" - Use the last 6-12 months of data. What's the typical range? Revenue might normally be between £40K and £55K per month. Client churn might be 2-4% monthly.
  • [ ] Set upper and lower alert boundaries - When should the alarm go off? Too low is obvious (cash below £20K). But too high can also signal problems (expenses suddenly 30% above normal could mean an error or unauthorised spending).
  • [ ] Define three alert levels - Watch (approaching the boundary), Warning (at the boundary), Critical (well past the boundary). Not everything is equally urgent.
  • [ ] Write a one-line "so what" for each alert - "Cash below £15K" is the alert. "Defer all non-essential spending and chase overdue invoices immediately" is the response. Link the alert to the action.

  Step 3: Build the Alerts

  • [ ] Choose your alert method - Email notifications from your accounting software, conditional formatting in a spreadsheet that turns cells red, Slack alerts, or even a simple weekly checklist where someone checks each threshold manually. Match the tool to your team's habits.
  • [ ] Set up automated alerts where possible - Xero, QuickBooks, and most CRM tools can send email alerts based on thresholds. Use them. Manual checking works but gets dropped when things get busy.
  • [ ] Assign an owner for each alert - Who receives it? Who acts on it? If all alerts go to you, you've just built a smarter bottleneck. Push appropriate alerts to department owners.
  • [ ] Test each alert - Deliberately trigger one (or simulate it) to make sure the notification actually arrives and the right person receives it.
  • [ ] ⚡ Quick Win: Set up your top 3 alerts this week - Cash balance, monthly revenue vs target, and client count. These three cover most of what matters. Add more later.

  ---

  Expected Outcome

  • You stop checking every number every day because the system tells you when something needs attention
  • Problems get caught in days, not weeks or months
  • Team members can respond to alerts in their area without waiting for you
  • Your mental load drops because you trust the system to flag what matters
  • False alarms decrease over time as you refine your thresholds

  Coach Notes

  The biggest mistake is setting too many alerts with thresholds that are too tight. If the system cries wolf every week, everyone ignores it. Start with 3-5 alerts on genuinely critical metrics. Widen the thresholds slightly so alerts only fire when something genuinely unusual happens. You can always tighten them later. For clients without automated tools, a simple weekly checklist where someone manually checks each threshold works perfectly well. The system matters more than the technology.

• Action 4: Weekly Review Rhythm

  Install a weekly cadence to review trends, discuss variances, and adjust course. Turn dashboard data into decisions through structured review meetings.

  Show full action →

  Hide full action

  What to Do

  Set up a structured weekly meeting where you and your team review dashboard data, discuss what's changed, and decide what to do about it. This is the bridge between having data and actually using it. Without a review rhythm, dashboards become wallpaper - nice to look at, but nobody acts on them.

  Pick a fixed day and time. Follow a consistent agenda. Keep it short. Make decisions, not just observations.

  Why It Matters

  Dashboards don't make decisions. People do. But only if they look at the data regularly and talk about what it means. A weekly review rhythm turns numbers into action. It catches small problems before they become big ones. It keeps everyone aligned on what matters this week. And it creates a culture where decisions are based on evidence, not gut feel or whoever shouts loudest.

  How to Use This

  Work through the setup steps, then use the meeting agenda template every week. The first few meetings will feel clunky. By week 4 or 5, the team will wonder how they ever ran without it.

  ---

  Step 1: Set Up the Meeting

  • [ ] Pick a fixed day and time - Monday morning (sets priorities for the week) or Friday afternoon (reviews the week just gone) both work. Pick one and protect it. This meeting doesn't get moved for client calls.
  • [ ] ⚡ Quick Win: Block it in everyone's calendar right now - Recurring, 30-45 minutes, every week. Making it recurring removes the "should we meet this week?" question.
  • [ ] Decide who attends - You plus anyone who owns a department scorecard or key metric. Keep it tight. More than 6 people and it becomes a broadcast, not a discussion.
  • [ ] Assign a dashboard updater - Someone updates all dashboards and scorecards 24 hours before the meeting. Data should be current when the meeting starts.
  • [ ] Create a shared agenda document - Same structure every week. Consistency is what makes this work. Use the template below.

  Step 2: Build Your Meeting Agenda

  • [ ] Section 1: Wins (5 minutes) - What went well this week? One highlight per person. This sets the tone and ensures good news doesn't get buried.
  • [ ] Section 2: Scorecard review (10 minutes) - Walk through the executive dashboard. Only discuss metrics that are amber or red. Green means it's working - move on.
  • [ ] Section 3: Exceptions and alerts (5 minutes) - Any alerts triggered this week? What happened, what was done, is it resolved?
  • [ ] Section 4: Stuck items (10 minutes) - What's blocked? What needs a decision? This is where the real value is. Problems that would fester for weeks get resolved in minutes.
  • [ ] Section 5: Priorities for next week (5 minutes) - Each person states their top 1-3 priorities. Written down, visible to all. Next week's meeting starts by checking whether these got done.
  • [ ] Section 6: Action items (2 minutes) - Who is doing what by when? Capture every action item with a name and a deadline. No orphan actions.

  Step 3: Make It Stick

  • [ ] Run the first meeting yourself - Set the standard. Keep it tight. Cut off tangents with "let's take that offline." Show the team what a good review meeting looks like.
  • [ ] Rotate the meeting facilitator after 4 weeks - Once the format is established, let others run it. This builds leadership and stops the meeting dying if you're away.
  • [ ] ⚡ Quick Win: End every meeting with "what's the one thing we need to get right this week?" - Forces prioritisation and gives everyone a shared focus.
  • [ ] Review and refine the format quarterly - After 12 meetings, you'll know what works and what's dead time. Cut what doesn't add value. Add what's missing.

  ---

  Expected Outcome

  • Data turns into decisions every single week
  • Problems get caught and addressed within 7 days, not 7 weeks
  • Team alignment improves because everyone sees the same numbers
  • Accountability becomes natural - people deliver because they know they'll be asked
  • You spend less time in ad-hoc check-ins because the weekly review covers the important stuff

  Coach Notes

  The first 3-4 meetings are the danger zone. They'll feel slow, awkward, and like a waste of time. Push through. By meeting 5 or 6, the team starts bringing issues to the meeting instead of interrupting you throughout the week. That's the turning point. The most common failure mode is letting the meeting run too long. Be strict on time. If a topic needs more than 5 minutes of discussion, take it offline with the relevant people. The weekly review is for flagging and deciding, not for deep problem-solving.