How do I run job profitability reports in QuickBooks?
Running a job profitability report in QuickBooks takes about 30 seconds once you know where to find it. The hard part isn’t running the report. It’s making sure the data behind it is accurate enough to trust.
In QuickBooks Online, go to Reports and search for “Profit and Loss by Customer” or “Job Profitability Summary.” The Job Profitability Detail report shows revenue and costs broken down by customer or project. In QuickBooks Desktop, you’ll find similar reports under Reports > Jobs, Time & Mileage.
The report only shows what’s in your books. If expenses aren’t coded to the right jobs, the profitability numbers will be wrong. A report showing 40% margin on a job doesn’t mean much if half the labor costs are sitting in a general expense category instead of allocated to that specific project.
For job profitability reports to work, every cost that belongs to a job needs to be assigned to that job. Material purchases, labor hours, subcontractor invoices, equipment rentals, permit fees. When you enter a bill or write a check, you need to tag it to the customer or job it belongs to. Same with time entries if you’re tracking labor that way. Proper construction job costing setup is what makes these reports trustworthy. Without it, you’re just looking at numbers that feel right but don’t reflect reality.
Revenue needs to be assigned correctly too. If you invoice a customer for multiple jobs under one invoice, you need to split it by job in QuickBooks or your profitability per job will be skewed.
The reports also won’t include costs you haven’t recorded yet. If you’re running profitability mid-project and haven’t entered the latest material invoices, your costs look artificially low. Many contractors wait until a job is complete and all costs are in before evaluating final profitability.
Customize the report to show what matters. Add columns for estimated costs if you’re comparing budget to actual. Filter by date range or job status. Export to Excel if you need to do additional analysis or present numbers to partners or lenders.
If the numbers look off when you run the report, the problem is usually upstream in how costs are being recorded. This is where bookkeeping services in American Fork focused on contractors can help. Getting job costing right from the start means your reports actually tell you which jobs made money and which ones didn’t.
Utah's Construction Bookkeeping Specialists
The Next Step:
A 15-Minute Call
We'll ask a few questions about your business, figure out what you need, and give you a straightforward price.
More Questions
Which accounting method is best for my small business?
Cash basis works for simple service businesses with quick payment cycles. Accrual basis is better for contractors and project-based businesses because it shows true profitability by matching income and expenses to actual work completed.
Read answerCan QuickBooks track costs by project phase?
QuickBooks can track costs by project phase using sub-customers or sub-jobs to represent each phase. The setup requires intentional configuration and consistent coding of every expense, but most contractors can make it work effectively.
Read answerWhy am I always behind on invoicing?
You're behind because invoicing isn't built into your workflow. It gets pushed aside by everything that feels more urgent until you're weeks behind and missing revenue.
Read answerWhy do I keep getting surprised by expenses?
Expense surprises usually happen because irregular costs aren't planned for, committed costs aren't tracked, or you're only looking at your bank balance instead of your full financial picture.
Read answerWhat expenses can a plumbing business deduct?
Most expenses you incur to run your plumbing business are deductible. This includes vehicles, tools, supplies, labor, insurance, licensing, and marketing. The key is tracking everything properly and categorizing costs correctly.
Read answerHow do I get my bookkeeping under control?
Start by separating business and personal finances completely. Then catch up on past transactions before establishing a weekly rhythm. The key is making bookkeeping a consistent habit rather than a quarterly scramble.
Read answer