Use the Invoice Profitability by Customer report

Gross profit is the revenue from your sales after you subtract the cost of goods sold. These are the direct costs when you manufacture your products.

Formula:

Gross Profit = Revenue − Cost of Goods Sold (COGS) or Direct Costs

The Invoice Profitability by Customer report shows the values for:

• Gross profit in the ($) Diff column
• Revenue in the Act. Revenue column
• Cost of Goods Sold in the Act. Cost column

Note: Each item on an invoice shows your gross profit but not your overhead or operating expenses.

Understand the difference between markup and margin so you can make the correct pricing decisions.

Formulas:

Markup = Profit ÷ Cost x 100
Margin = Profit ÷ Revenue x 100

For example: You buy an item for $50 and sell it for $75. Your profit is $25.

• The report uses Markup to express profitability as a percentage. It answers the question, "How much did I increase my cost to get the sales price?".
  • In this example, the percentage of markup is 50%. To get this, divide the profit, $25 with the cost, $50. Then, multiply the result with 100 to show the percentage. 
  • The % Act. Markup column in the report shows this value.
• Margin answers the question, "What percentage of my revenue is profit?".
  • In this example, the percentage of profit margin is 33.3%. To get this, divide the profit, $25 with the revenue, $75. Then, multiply the result with 100 to show the percentage.
  • The % Act. Margin column in the report shows this value.

Double-check the value that shows up in the Act. Cost (Actual Cost) column. This comes from your company file’s inventory valuation method. It can either be average costing or FIFO (first-in, first-out).

Important: The cost shown is a snapshot taken at the moment the invoice is created. If you buy the same item later at a different price, it won't affect the cost of invoices that exist. This also applies to other profitability reports, like the Job profitability report.

1. Go to Reports and select Customers & Receivables.
2. Select Invoice Profitability by Customer.
3. Select Customize Report to customize your report.

To customize your view, you can:

• Change grouping: Use the Group By ▼ dropdown to view profitability by Customer: Job, Rep, Class, or Item Type.
• Filter data: Use the filter layer to narrow your results by specific date ranges, sales reps, or customer jobs.
• Use a detailed view: Switch to the Detailed Line-Item view to see exactly which items (services or products) are driving your margins.

1. Go to Customers and select Customer Centre.
2. Select the Customers & Jobs tab.
3. Select a customer with an invoice whose profitability you want to see. You can either: 
   • Select a customer from the Active Customers ▼ dropdown.
   • Or, enter the name of the customer in the search field.
4. Select the row showing the invoice.
   Note: Make sure that it shows Invoice in the Type column and the invoice number in the Num column.
5. Double-click the row to open the invoice.
6. Go to Reports, then select Invoice Profitability By Customer. 

To make sure you see accurate profit margins from your services, you need to add a cost to each service item. Here's how to set this up:

1. Go to Lists and select Item List.
2. Double-click the service item you want to track costs for.
3. Select This service is used in assemblies or is performed by a subcontractor or partner. This shows the cost fields.
4. Enter the amount you pay for this service (For example: subcontractor hourly rate or internal labour cost) in the Cost field.
5. Assign an Expense Account (such as Cost of Goods Sold) to track these costs.
6. Select OK to save changes.

Note: Once these costs are added, QuickBooks will automatically use them to calculate the Gross Profit and Margin % for that service on your reports.

The Act. Cost column shows values based on the cost of inventory and assembly items in your Item List. QuickBooks considers the cost of other item types like services, discounts, or other charges to be $0.00. This is also the standard behaviour in other profitability reports.

The Job Profitability report shows all the income and costs of a project, from start to end. On the other hand, the Invoice Profitability report shows the profit from each invoice.

Tip: Use both reports to track the progress of your projects and the profit from each billing cycle.

The profit is calculated based on the items, quantities, and prices on the invoice. If you change a quantity, add a discount, or update a price, the report will update. It will reflect the new profitability of that transaction.

No. This report shows gross profit from sales but not your overhead or operating costs. For the total profit of your business, run a Profit & Loss report.