Customer profitability reports show how much revenue each customer generates minus the direct costs of serving them. This is different from just looking at sales. A customer buying $50,000 worth of work might seem great until you see you spent $48,000 in labor, materials, and overhead to deliver it. Run this report by customer and by job to see which accounts actually contribute to profit and which ones eat up resources for minimal return.

Gross margin analysis breaks this down further. Look at your margin percentage by customer, not just the total. A customer with 40% gross margin is more valuable than one with 15%, even if the lower-margin customer brings in more revenue. Low margins often indicate underpriced work, scope creep that never got billed, or customers who negotiate too aggressively. If you consistently see thin margins with certain accounts, your pricing doesn’t match the actual cost of serving them.

AR aging reports reveal payment behavior. A customer might look profitable on paper but create cash flow problems by paying 90 days late. The AR aging report shows you who pays on time and who sits on invoices. Customers who constantly show up in the 60+ day columns cost you money in carrying costs and collection effort. They also signal potential bad debt if those invoices eventually go unpaid.

Revenue analysis by type separates recurring customers from one-off work. Recurring revenue is more valuable because it’s predictable and usually comes with lower acquisition costs. One-time projects require constant sales effort and often attract price-sensitive buyers. When you look at customer profitability, factor in whether that customer represents steady ongoing work or a single transaction you had to win fresh.

The pattern you’re looking for is customers who show up poorly on multiple reports. Low margin, slow payment, and one-off work together usually indicates a poor-fit customer. High margin, prompt payment, and recurring revenue indicates the type of customer worth keeping and pursuing more of. Financial strategy work often starts by identifying these patterns and building a plan to shift toward better customers.

These reports only work when your books are accurate and transactions are coded properly. If expenses aren’t allocated to the right customers or jobs, the profitability numbers are meaningless. Businesses with messy records often need bookkeeping cleanup and catch-up services before this kind of analysis becomes useful.

Most small business owners should run these reports quarterly at minimum. Monthly is better if you’re actively trying to reshape your customer base or adjust pricing. The goal is catching unprofitable relationships before they consume another year of your time and resources.