What financial strategy reports help identify unprofitable customers?
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.
Greater Houston's Small Business Bookkeeping Partner
The Next Step:
A Quick Conversation
Tell us about your business and what you need help with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
How should plumbers, electricians and HVAC companies track parts and truck expenses?
The key is separating direct job costs from overhead with distinct categories for job parts, warranty parts, truck stock inventory, and tools. Tracking what goes on each job versus what's general overhead determines whether you know your true profitability.
Read answerHow do I know whether someone should be on payroll or paid as a contractor?
The answer depends on the actual working relationship, not what you call the person or what your contract says. The IRS evaluates behavioral control, financial control, and the nature of the relationship.
Read answerHow do I train staff to enter bills without breaking the books?
Train staff on vendor setup, bill coding, approval workflows, attachments, due dates, and duplicate checking. Consistency in how every bill gets entered keeps your books clean and prevents costly errors.
Read answerHow should an S corporation owner track payroll and distributions?
S corporation owners need to track payroll and distributions separately. Payroll is your reasonable compensation subject to employment taxes. Distributions are profit sharing recorded as equity reductions.
Read answerWhat should a Texas restaurant track for sales tax and mixed beverage tax?
Texas restaurants track regular sales tax on food plus two separate mixed beverage taxes on alcohol. Mixed beverage sales tax is collected from customers while gross receipts tax comes from your revenue.
Read answerHow do I clean up old accounts receivable balances in QuickBooks?
Cleaning up old AR requires reviewing each invoice individually. Look for unapplied payments, duplicate invoices, bad debt that needs to be written off, and payments received outside QuickBooks that were never matched.
Read answer