The QuickBooks Online project profitability report: what it shows a builder and where it misleads
It answers what a house has cost so far. It cannot tell you whether the house will make money without help from commitments, billing and a forecast.
Short answer: The QuickBooks Online project profitability report totals the income and costs tagged to a project and shows the difference as profit and margin. It reflects only what has been posted to the file on the day you run it. It does not show open commitments, work done but not billed or a comparison to your estimate, so a builder uses it to see cost to date and needs a forecast and a WIP schedule to judge final margin.
What the report does show
Intuit describes projects as a way to track income, costs and profit for a specific job. Each project has an overview with income, costs, profit and margin, a transactions list, time activity and a project reports tab with project profitability, time cost by employee or vendor and unbilled time and expenses. Projects are available in QuickBooks Online Plus, Advanced and Intuit Enterprise Suite. For a builder, that means a house with every tagged bill, card charge, check and invoice in one place.
That is useful. It is the base for everything else. But it is a record of posted transactions, not a forecast.
Five ways the report misleads a builder
| Gap | What happens | What fills it |
|---|---|---|
| Open commitments | A signed subcontract or open purchase order is not a cost until the bill is entered. A house can look 40 percent spent and be 85 percent committed. | A commitments list or purchase orders and a cost-to-complete forecast |
| Work done but not billed | Income only counts when invoiced. An underbilled house looks like a loss, and an overbilled one looks like a profit. | A WIP schedule |
| Untagged costs | Bills or card charges with no project sit outside every house, which flatters every house on the report. | A monthly review of costs with no project |
| Labor timing and loading | Intuit says payroll labor posts to a project when payroll is run, and hourly cost rates are estimates that apply to timesheets entered after the rate is set. Any overhead in a rate is whatever someone typed in. | A policy for labor and overhead. See labor burden. |
| No estimate comparison by default | Plain project profit shows income less cost, not a comparison to your original or revised budget. Intuit says estimate versus actuals is available in QuickBooks Online Advanced. | A budget per house. See original vs revised budget vs forecast. |
An independent QuickBooks consultancy makes the same point in plainer words: the report answers "what has this job cost so far" well, and "is this job going to make money" only with help from outside the report. We agree, with the caveat that we have not verified that firm's other numbers and do not rely on them here.
Want profitability by house you can rely on? Request a Relationship Assessment.
A monthly way to read it
- Sort by margin and look for houses with income and no cost. The bills probably have not been entered or tagged, so the margin is not real yet.
- Look for houses with cost and no income. Either work has not been billed or an invoice went to the wrong project.
- Check the no-project bucket. Total the costs with no project and assign them before you close.
- Compare each house to its revised budget and to its forecast. A house with a healthy margin today and a thin forecast is the one to call about.
- Tie the total to the profit and loss. House costs plus overhead should reconcile to the company's cost of sales and expenses for the same period.
When to use something stronger
QuickBooks Online Advanced adds project estimates, covered in our guide on Advanced construction features. Builders who need committed costs, percent complete and draw tracking often add a construction tool or a WIP workbook fed by the books. Our guide to using QuickBooks with Buildertrend or JobTread covers the options, and the classes vs projects guide shows how to set up houses.
How we help
Our team tags every cost to the house, checks the no-project bucket before close and adds the forecast and WIP the report cannot show. Our founder reviews every close. We quote a flat monthly price for each builder, starting at $1,500 a month, with typical engagements between $2,500 and $8,500 a month. Start with a $1,500 Margin Review for written findings. See job costing, construction bookkeeping, pricing or request a Relationship Assessment.
Sources
- Intuit, How to set up and use projects in QuickBooks Online
- Intuit, Track hourly labor costs and profitability by project in QuickBooks Online
- Intuit, How to use project profitability reports
- Intuit, What are Projects in QuickBooks Online? (PDF)
- Navigator, Job costing in QuickBooks Online: what it can and can't tell an owner
Common questions
What does the QuickBooks Online project profitability report show?
Income and costs tagged to a project and the resulting profit and margin, based on what has been posted on the day you run it.
Does the project profitability report include committed costs?
No. Open purchase orders and unbilled subcontract commitments are not costs until the bills are entered, so the report can understate final cost.
Why does my house look unprofitable or too profitable in the report?
Income counts only when invoiced, so an underbilled house can look like a loss and an overbilled house can look like a profit. A WIP schedule corrects for this.
Does the report include labor?
It can, using payroll expenses or estimated hourly costs depending on a setting. Intuit says payroll labor appears after payroll is run and hourly cost rates are estimates.
Can QuickBooks Online compare a project to its estimate?
Intuit says project estimates and estimate versus actuals are available in QuickBooks Online Advanced.
Can you review my project reports each month?
Yes. Our team reviews them, clears untagged costs and adds the forecast and WIP view.
Related
- QuickBooks Online classes vs projects for home builders
- How to read a job cost report
- Purchase orders and committed costs in QuickBooks Online
- QuickBooks Online setup for custom home builders
- What is a WIP schedule?
By John Mos, Founder. Updated . We do not give tax or legal advice. Please ask your CPA or attorney.
See where your margin goes, house by house.
Tell us about your homes and your books. If we are a fit, we start with a $1,500 Margin Review: written findings and a fixed quote in 10 business days, credited to your onboarding fee if you sign up.