Blog
A Job Profitability Report, Line by Line
Somewhere around the fourth or fifth project of the year, a client asks a version of the same question: which of these jobs made us money?
The monthly profit and loss statement won’t settle it. A P&L is also known as an income statement, per the SBA Ascent guide, and the SEC’s guide to financial statements describes that statement as a report of a company’s results over a specific time period, so the project that ran two rounds over scope disappears into the same subcontractor line as three that went fine. A job profitability report is built to answer the question directly, but it’s only as honest as the coding underneath it, and that’s where most of the interesting problems live.
Here’s a composite report for one completed website redesign at a small design studio. The figures are invented, assembled from patterns that show up across books like these:
- Income invoiced: $18,400
- Contractor design labor: $6,750
- Employee time cost: $4,120
- Stock photography and licensed fonts: $385
- Travel for the kickoff meeting: $612
- Total direct costs: $11,867
- Project margin: $6,533, or 35.5%
That looks like a healthy job. Now walk the lines.
Where the Income Line Comes Up Short
The $18,400 only includes invoices carrying the project tag. In QuickBooks Online Plus and Advanced, an invoice lands on a project when you select it in the customer field, so a change order billed by someone who skipped that field never reaches the report.
That kind of omission is easy to miss, because a job that looks worse than it was tends to get a shrug instead of an audit. QuickBooks’ project profitability reports include a view for unbilled time and expenses, and it’s worth opening before you trust a margin figure. On a time-and-materials job you usually invoice for specific project expenses and hours worked, and QuickBooks’ guide to invoicing project expenses says those expenses and timesheets have to be marked billable before they can be added to an invoice. An hour that was logged but never marked billable can sit on the project without ever reaching a bill, so go through the project’s time entries separately for hours that were never marked billable.
The Hours Nobody Entered
The $4,120 employee time cost came from timesheets, and timesheets are voluntary in a way bills aren’t. A vendor bill arrives whether or not anyone remembers it; an hour of internal work exists only if someone entered it.
Owner hours are easy to lose, and on a fixed-fee engagement they can go missing entirely. The owner steps in to rework a deliverable, calm a nervous client, or save a deadline, and none of it produces a time entry because none of it gets billed separately. The margin then reflects the invoice rather than the effort. Track those hours as operational data so the next quote knows what the work took, but label them a management estimate; don’t manufacture a payroll expense in the ledger to round out a project report. How the owner’s compensation is recorded belongs with the business’s CPA.
The Costs That Aren’t on This Report
Rent, general insurance, the accounting subscription, and hours spent quoting work that never closed are all real, and none appear above. The SBA describes fixed costs as costs that don’t change with the increase or decrease in production, which is exactly why they resist landing on one job: no honest rule ties them here rather than to the next project. For most small firms, comparing project income against direct project costs and stopping there is the cleanest start. If you do want an overhead allocation, write the method down and apply it identically every time; one that shifts between jobs makes a project look better only because another absorbed more of the shared cost.
Shared direct costs need the same discipline. When a freelancer bills one invoice covering two clients, splitting it by the underlying detail takes a few minutes and dropping it on whichever project is open takes none.
Run It Before the Job Is Finished
A completed-job report is a pricing input; a mid-job report is a chance to fix something while it still matters. Xero’s job costing page describes setting an estimate for each cost type and watching a comparison against actual costs as they get logged, and QuickBooks Online Advanced tracks estimates against actuals on the project dashboard. Week three is when that comparison can still change how the job ends.
Read timing carefully. A job showing costs but little income may just be waiting on its next invoice, and one that looks excellent today may still have a contractor bill in the mail, so mark project status and never set a half-finished job beside a closed one.
None of this tells you why a job’s numbers came out the way they did. It shows the redesign carried $6,750 of contractor labor against $18,400 invoiced; whether the estimate was optimistic, the scope grew without a conversation, or the client changed their mind twice is a question for the people who did the work. What the report buys you is a short, specific conversation instead of a vague sense that this kind of project is always harder than it should be.
Bat City Books helps service-based small businesses code project costs so a job profitability report can be trusted. If figuring out which jobs actually made money feels like guesswork, let’s talk.