QuickBooks invoice profitability report: markup, frozen cost, missing overhead

QuickBooks Desktop Enterprise users in Canada have a report built for invoice-level margin analysis, and a dependable set of questions about why its numbers refuse to line up with the rest of their books. The Invoice Profitability by Customer report shows revenue, direct cost and gross profit for every line on an invoice. It deliberately stops there. Nearly all of the confusion we see comes from three gaps between what the report measures and what people assume it measures.

A narrower question than most people expect

This is a per-invoice view. Each line shows what you charged, what the item cost you directly, and the gross profit left over. You can subtotal and analyze by customer or job, sales rep, class, item, or item type. Selecting a subtotal or a single line opens the original invoice, so the transaction behind a strange figure is one click away.

That drill-down matters more than it sounds. A surprising line is usually a question about one invoice, not a fault in the report. Check the item, the quantity and the price on the source document before hunting for a wider problem. Nine times out of ten the report is reporting accurately and the invoice is what needs a second look.

The headline percentage is markup, not margin

Markup divides profit by cost. Margin divides profit by revenue. For the same sale, markup is always the larger of the two, which is why a figure can look healthy until you realise which column produced it. The report carries both values, in separate columns, but the eye lands on the first percentage it finds.

Decide which question you are actually asking. Markup tells you how much you lifted the cost to reach the sales price. Margin tells you how much of the revenue survived as profit. Only one of those belongs in a pricing conversation, and it is not the one most people quote.

Cost is captured when the invoice is created

Actual cost follows the inventory valuation method set for the company file, either average costing or first-in, first-out. The value is a snapshot taken at the moment the invoice was created. Buy the same item later at a different price and the older invoice keeps its original cost. Nothing is recalculated.

This applies to other profitability reports too, including Job Profitability, so the behaviour is consistent rather than a glitch. An item purchased months apart can carry two different costs on two invoices and both can be correct. Anyone comparing this year’s invoices against this year’s supplier prices should expect a gap, and should not read it as an error.

Overhead does not appear here

The report stops at gross profit. Rent, wages, subscriptions and every other operating expense sit outside it. A customer can look comfortably profitable on this report and still contribute very little once overhead is allocated across the work.

Run a Profit & Loss first if overhead is the number you need. Then read the invoice report as the direct-cost layer sitting underneath it. Gross profit is not total profit, and the report never pretends otherwise; the column headings are simply easy to skim.

Three checks before you trust a figure

Read the column heading before reading the number, so you know whether you are looking at markup or margin. Confirm the valuation method behind actual cost, particularly if the file has changed method at some point. Open the invoice behind any line that surprises you, since line-level detail resolves most disputes on its own.

Pair the report with a Profit & Loss for the same period when the question is about total profit rather than customer margin. That combination answers what the report alone cannot.

The report is not wrong, it is narrow

What resolved this for the users who raised it was not a repair. It was a correction of expectations. The report is a per-invoice gross profit tool with a fixed cost basis, not a business-wide profit statement, and it will keep behaving exactly as designed.

Once the columns are read correctly and overhead is handled separately, the figures reconcile. Where they still do not, the answer normally sits in the underlying invoice rather than in the report itself.