Tracking Ugly But Profitable Jobs in QuickBooks
Some of the most profitable work in a service business is the kind nobody talks about. The messy cleanups, the tedious data-entry projects, the one-off repairs, the rush jobs other shops turn down — they may not look impressive on a portfolio or website, but they can quietly carry the business. The challenge is knowing which jobs are actually pulling their weight and which ones just feel busy.
QuickBooks gives you the tools to answer that question directly, using job profitability reports tied to the actual income and costs you have already recorded.
Turn On Job Tracking
Before you can measure profitability per job, you need to make sure job tracking is active and that you are assigning income and expenses correctly.
In QuickBooks Desktop, confirm that the Jobs preference is enabled. Go to Edit > Preferences > Jobs & Estimates and make sure the Company Preferences tab is set to allow you to create jobs and estimates.
In QuickBooks Online, the equivalent is Projects, available on Plus and Advanced plans. Each project sits under a customer and lets you tag invoices, bills, timesheets, and expenses to it.
Set Up Each Job or Project
Create a sub-customer (Desktop) or Project (Online) for every distinct piece of work. Give it a clear name even if the job is small or unglamorous — something like “Smith — emergency leak repair” or “Quarterly cleanup — Jones LLC” is far more useful six months later than a vague label.
If you want to compare jobs against a budget, enter an estimated revenue and estimated costs at the start. QuickBooks can then show you estimated versus actual as the job progresses.
Assign Every Transaction
Job profitability reports are only as good as the data going in. Every invoice, bill, check, timesheet, and credit card charge related to a job must be tagged to that job in the Customer:Job (Desktop) or Project (Online) field.
The most common reason a job looks less profitable than it really is: costs were recorded without a job tag, so they never hit the report.
Run the Job Profitability Report
In QuickBooks Desktop, go to Reports > Jobs, Time & Mileage > Job Profitability Detail. You can also use Job Profitability Summary for a high-level comparison across all jobs.
In QuickBooks Online, open the Projects center and click into a project, or run a Project Profitability report from the Reports tab.
Look at the Actual Revenue and Actual Cost columns, then focus on the Gross Margin or % column. That single number tells you which jobs are truly making money — regardless of how big, small, attractive, or tedious they appeared at the time.
Sort by Margin, Not by Revenue
A common mistake is sorting jobs by total revenue and assuming the biggest invoices are the best work. A $12,000 job with thin margins can contribute less to the bottom line than a $1,200 cleanup that took two hours.
Sort the report by gross margin percentage. The jobs at the top of that list — the ones with the best return for the time and cost invested — are the ones worth repeating and marketing, even if they never make it onto your website.
Act on What You Find
Once you know which job types carry the highest margins, you can make better decisions about pricing, which work to pursue, and where to focus your energy. If a category of “ugly” jobs consistently outperforms your flagship work, that is a signal to build a service offering around it.
For deeper analysis — comparing job types across customers, trimming an oversized file that has accumulated years of old jobs, or recovering data from a damaged company file that won’t open — our QuickBooks file repair and data services can help.