Gross profit margin in Xero: where to find it and why it moves

Short answer: gross profit margin is how much of every $100 of sales is left after the direct costs of making that sale. In Xero, run Accounting > Reports > Profit and Loss: the Gross Profit line is your trading income minus cost of sales. Divide Gross Profit by Total Trading Income and multiply by 100 to get the margin. The Executive Summary report shows the percentage for you, and for tracked stock the Inventory Item Details report can show a margin for each item. If your Profit and Loss has no Gross Profit line, nothing is coded to cost of sales, and the margin cannot be worked out until it is.

Where Xero shows it

Report in Xero	What you get	Good for
Profit and Loss	Trading Income, Cost of Sales and the Gross Profit line in dollars	Monthly check, comparing periods side by side
Executive Summary	Gross profit margin as a percentage, month by month	Watching the trend without doing the sum (see the Executive Summary explained)
Inventory Item Details	Margin and profit per item, if you add those columns	Finding which tracked products earn least

To see the percentage on the Profit and Loss itself, add a formula row (Gross Profit divided by Total Trading Income) and save the layout; Xero custom reports walks through it with a worked example.

On the Profit and Loss, the cost of sales section is made of every account whose type is Direct Costs: materials, stock sold, subcontractors, freight in. Overheads such as rent, software and admin wages sit below Gross Profit as operating expenses. Other Income (interest, grants) also sits below Gross Profit, so leave it out of the margin: use Total Trading Income only. If you buy stock, cost of goods sold explains why the cost of what you sold is not the same as what you bought, and how a stock adjustment fixes the timing.

How to work it out

Gross profit = trading income - cost of sales

Gross margin = gross profit / trading income x 100

A month with $50,000 of sales and $20,000 of direct costs has a gross profit of $30,000 and a gross margin of 60%. From every $100 of sales, $60 is left to pay overheads, wages and you. To see how much of that wages take, use the wage percentage calculator.

A worked example: sales up, profit flat

Made-up figures for a small trade business:

	August	September
Trading income	$50,000	$55,000
Cost of sales	$20,000	$24,750
Gross profit	$30,000	$30,250
Gross margin	60%	55%

Sales rose by $5,000 but gross profit rose by only $250. Had the margin stayed at 60%, September’s gross profit would have been $33,000: the 5-point slip cost $2,750 in one month. Over a year at the same sales, that is about $33,000, often more than the owner’s whole bonus or the difference between a good and a tight year.

This is why margin is worth watching on its own. A busy month with rising sales can hide a margin that is quietly falling, and the bank only shows it weeks later.

Why gross margin moves

1. Costs went up and prices did not. A supplier price rise lands on every job from that date. If quotes still use last year’s costs, margin falls a little each month. The free price increase calculator shows how many sales a price rise could lose before it stops paying.
2. Discounts. A 10% discount on a 60% margin sale removes a sixth of the gross profit on that sale, not a tenth.
3. Timing. Materials bought in September for a job invoiced in October lower September’s margin and raise October’s. Look at two or three months together before reacting to one, or see profit by job so each job’s costs sit with its sales.
4. Coding. If a cost is coded to cost of sales one month and to an overhead the next, the margin jumps for reasons that have nothing to do with trading. Ask your bookkeeper to keep the same costs in the same accounts.
5. Mix. Selling more of a low-margin product or service lowers the overall margin even when each price is right. Tracking categories in Xero, or the Inventory Item Details report, show which lines are pulling it down.

If net profit fell and you want to know how much of the fall was margin and how much was lower sales or higher overheads, why did my profit drop? splits it into the three, with a worked example. To see gross margin in the context of a whole year’s report, the profit and loss statement example shows a café’s P&L at 68% with what each point of margin is worth. If gross margin rose but net profit still fell, gross profit vs net profit works through a shop where that happened.

Margin is not markup

Markup is gross profit as a percentage of cost; margin is gross profit as a percentage of the price. They are easy to mix up, and the mistake always undercharges.

An item costs $40 and you want a 60% margin. The price is $40 / (1 - 0.60) = $100, which is a markup of 150%. Adding 60% to the cost gives $64, which is only a 37.5% margin. To get the price for any margin, or convert between the two, use the free margin and markup calculator.

What is a good gross margin?

It depends entirely on the trade: a consultancy with no materials can sit far above a builder or a retailer, and neither is doing anything wrong. The more useful comparison is your own history, and the net margin your business needs to pay you, the tax and new equipment (what is a good profit margin for a small business works one out). Compare last month with the month before and with the same month last year, and ask about any move of 3 points or more. In a restaurant, read food and drinks separately: the restaurant profit and loss statement guide shows why three points of food cost is 1,800 a month on 60,000 of food sales. Once you know your margin and your monthly overheads, the free break-even calculator shows the sales you need each month to cover them.

A monthly check that takes two minutes

1. Run the Profit and Loss for last month with the previous month and the same month last year beside it (see how to read your Profit and Loss in Xero).
2. Work out the gross margin for each column, or read it off the Executive Summary.
3. If it moved by 3 points or more, open Cost of Sales and find the account that changed most.
4. Decide whether it is timing, coding, or a real change in prices or costs. Only the last one needs a price decision.

A falling margin also eats cash: the business sells more and keeps less, which is one of the reasons for profit that does not show up in the bank.

Common questions

Why is there no Gross Profit line on my Profit and Loss? Xero only shows Cost of Sales and Gross Profit when at least one account with the type Direct Costs has something coded to it. If materials, stock and subcontractors sit in ordinary expense accounts, every cost lands below the line. Ask your bookkeeper or accountant to change those accounts to Direct Costs in the chart of accounts. Changing an account’s type also changes how earlier periods show on the reports, so check with your accountant first if those years have already been filed.

Should wages be in cost of sales? Wages for the people who do the paid work, such as tradespeople on jobs or kitchen staff, can be, and many trades and hospitality businesses put them there. Office and admin wages belong in overheads. Either way works if it stays the same every month: moving wages between the two makes the margin jump with no change in trading.

Is gross margin worked out before or after GST or VAT? Before. For a business registered for GST or VAT, the Profit and Loss in Xero shows income and costs without the tax, so the margin from it is already the right one. Do not add the tax back in.

What does a negative gross margin mean? Cost of sales was bigger than trading income for that period. Check timing first: a large stock or materials purchase for jobs invoiced next month can do it. Then check coding, such as a refund or a big purchase in the wrong account. If neither explains it, the work is being sold for less than it costs, and prices need to change.

Is a higher gross margin always better? Not on its own. Gross profit in dollars is what pays the overheads. A month at 62% on $40,000 of sales leaves $24,800, less than the 55% September in the worked example above ($30,250). Read the margin and the gross profit dollars together.

What is the difference between gross margin and net margin? Gross margin is what is left after the direct costs of each sale. Net margin is what is left after overheads as well, such as rent, admin wages and software. In the worked example, September’s 55% gross margin pays the overheads and whatever remains is net profit; gross profit vs net profit shows how one can rise while the other falls.

Getting this without running the reports

ReportPilot reads your Xero figures and sends a short email every Monday in plain English. When cost of sales is coded in Xero and gross margin moves by 3 percentage points or more against the month before, the email says so, with what was left from every $100 of sales in each month. It also covers sales and profit against last month, cash, money owed to you that is past due, and bills due soon. It asks Xero for read-only access, and there is a 14-day free trial with no card.