gross profit percentage to show on invoices?

Glad to have you here, @gf31,

Don't worry, I'm here to walk you through on how to do these things in your company file.

If you want to see how each customer affect your profit, there are several reports you can pull up inside QuickBooks. I can share two reports you can use below.

Profit & Loss by Job:

1. From the Reports menu, choose Company & Financial.
2. Use Profit and Loss By Job.
3. Once launched, click the Customize Report button.
4. Go to Display and mark the box for % of Income.

Job Profitability Summary

1. Under Reports, pick Jobs, Time & Mileage.
2. From the drop-down, choose Job Profitability Summary.
3. To add the percentage, click the Customize button again then pick % Difference.

Once you have the data ready, you can assign that rate on transactions by adding a customized column. Here's how:

1. Go to the Lists menu and choose Templates.
2. Double-click the invoice template you're using.
3. On the next window, click on Additional Customization.
4. Go to the Columns tab and scroll to the bottom.
5. Find the fields labelled as Other 1 or Other 2.
6. Whichever has a blank title, enter GP% or any description you want.
7. Make sure the Screen and Print columns are marked before clicking OK.
   

Once done, you can now see this field when processing sales. Make sure the right template is selected to display the column. You will see it at the top of the transaction. See this:

 

While this is a custom column, the data from the report will not automatically populate the sales entry. You will need to enter the information manually based on what is displayed on the profit reports.

I'll be adding a few related links about reports below:

• Understand reports 
• Customize reports
• Create, access and modify memorized reports

Kindly update me if you need anything else. I'll be here to help you. Have a good one!

Thanks so much for responding... However, I need the GP% to calculate while the invoice is being written. It’s too late to run a report AFTER the invoice is written because the customer already has a copy and pricing can’t be changed.

Since we’ve been on QB the last two weeks we have had several items on invoices sold at cost. Our associates can’t tell if there is a problem with pricing until it’s too late. The customer already has a copy of the invoice.

This is so basic... this capability has to be somewhere. We really need to see gp% AS we write the invoices

Hi @gf31,

Thank you for your prompt reply. I'll take care of this query for you. 

The option to calculate GP% at the time you create an invoice is unavailable in QuickBooks Desktop (QBDT). I can see how this feature would be a great addition to the product. We appreciate any feedback and strive to improve our products so they can provide a better experience for our users. 

Though there isn't a specific date as to when this feature will become available, I suggest you visit this page: QuickBooks Product Updates. It's here you'll find a list of updates for QBDT, such as the new and improved features of QBDT 2021. 

Direct other questions you have to the comments below. I'll get back to you as soon as I can. 

Hey did you ever get a solve for this with Quickbooks? Exactly the same problem I am having...

I’ve got an update for you, @gameovermerch.

At the moment, the option to calculate GP% when creating invoices is still unavailable. You can use the Feedback feature within your QuickBooks Desktop account to send this idea straight to our Product Development team. They consider suggestions based on the number of requests and their impacts.

Here’s how:

1. Open QuickBooks.
2. Go to the Help menu.
3. Select Send Feedback Online.
   

I've attached this article to help you save time with managing your invoices or other transactions: Create, edit, or delete memorized transactions. It eliminates the data entry process and serves as a reminder every time it's due.

If you have any other questions or concerns besides gross percentage, just add them to your reply. We’ll be here to help. Take care always.