KPI: Active Clients by Month

Kpi video 300 x 250
A quick tip on how to track another important key performance indicator using Microsoft Excel
Another key performance indicator (KPI) you need to watch is "active clients by month." If your production management software doesn't give you this number easily, one way you can get it is by using your accounting software, most of which will allow you to export reports to Microsoft Excel. In this video, we work with an Excel spreadsheet that shows a sales summary report over a 12-month period. The original report was generated by QuickBooks.

FAQs

Q: What is active cleaning clients by month?

A: Active cleaning clients by month is a management measure that helps a residential cleaning company understand performance, compare periods, and make better operating decisions.

Q: How do you calculate active cleaning clients by month?

A: Use consistent data from the same reporting period, apply the formula described in the article, and document which revenue, clients, jobs, or employees are included so results remain comparable.

Q: Why does active cleaning clients by month matter to a cleaning business?

A: It connects day-to-day activity to profitability, capacity, retention, or growth and can reveal problems before they become visible in the financial statements.

Q: How often should a cleaning company review this KPI?

A: Review it at least monthly. High-velocity measures such as revenue, leads, jobs, labor, and staffing may also need weekly monitoring.

Q: What should owners do when this KPI worsens?

A: Confirm the data first, identify the operational driver behind the change, assign one corrective action to an owner, and monitor the next several reporting periods before drawing conclusions.

Author

  • Tom Stewart headshot

    Tom Stewart is a CEO and industry thought leader focused on scaling residential cleaning businesses through strategy, systems, and leadership development, translating complex concepts into actionable frameworks. With his wife Janice Stewart, he co-owns Castle Keepers, the first company to achieve CIMS certification. Tom is the founder and CEO of MaidCentral Software, the leading business management platform for professional home cleaning companies in North America, and the founding editor and publisher of Cleaning Business Today. Learn more at TomStewart.com.

    Founder and CEO
  • Cleaning business software for success and profits 8 1
  • Modern cleaning skyscraper
  • Cleaning business software for success and profits 7
  • Issa 26 digital ads cbt april 300x700 1
  • Gusto skyscraper
Cleaning Business Today - The magazine for the cleaning industry
  • Pt iaqfilter c3 putdustwhereitbelongs 300x250
  • Responsiblock1.2
  • Cleaning business software for success and profits 6
  • Cleaning business software for success and profits 5
  • 300px x 250px sidebar ad medium 1
  • Pt iaqfilter c2 keepdustallergensatbay 300x250
  • Issa 26 digital ads cbt april 300x250 1
  • Gusto giftcard ad 1 scaled