cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

PROFIT IN EACH INVOICE

Hi,

Good Morning

 

How can I know How much profit in each invoice?

 

Thanks

Solved
Best answer 02-03-2020

Best Answers
Highlighted
Moderator

PROFIT IN EACH INVOICE

Hi there, @towhidctg,

 

Allow me to join the discussion and share additional insights about this.

 

Use the Location filter to categorize information from different sites, offices, regions, outlets, or departments of the same company. It also allow you to see all the payments per location and deposit them as a group. You can skip this step, as it is optional.

 

Vpcontroller is right. There isn't currently a report to show Gross Profit for each invoice. Your revenue is summarized in the Profit and Loss or Income by Customer Summary Reports.

 

Having this feature available in our program is a great idea. I can see how beneficial it is to keep track of your gross margin. While we're currently unable to do this, you can open a Profit and Loss % of Total Income Report, then click the Income amount to open the Transaction Report. From there you can click the Export icon and add the data manually on the worksheet.

 

See this article to learn more about exporting reports to Excel: Export your reports to Excel from QuickBooks Online.

 

I'm making it my top priority to relay this suggestion to the Development Team, letting them know you'd like to have this ability.

 

Stay on top of our product updates and feature releases by visiting the QuickBooks Blog: Intuit Blog.

 

Feel free to reach out to me if you have any other questions. I'm always here to be your QuickBooks guide. Cheering you a productive and wonderful week!

View solution in original post

8 Comments
Highlighted
Moderator

PROFIT IN EACH INVOICE

Good day, towhidctg.

 

You can check the Transaction Journal on the invoice to know your profit. Here's how:

  1. Click Sales on the left menu. 
  2. Go to the All Sales tab.
  3. Locate and open the invoice. 
  4. Once the invoice is open, hit More button at the bottom and select Transaction Journal

See below screenshots for your visual guidance:

 

From there, you'd able to know the Sales on the Invoice. 

 

You can also check these articles that you may find helpful in the future:

If you have any other questions, let me know by leaving a comment below. I'm here for you. Have a great day. 

Highlighted
Level 10

PROFIT IN EACH INVOICE

@towhidctg @MirriamM 

 

If you're referring to Invoices for Inventory Type items, you can run the "Transaction Journal" for that specific Invoice as mentioned here and get the Gross Profit number. But there is no one standard summary report that will give the Gross Profit by each Invoice line.

 

Note: Inventory type is available in Plus and Advanced only. In other plans (Essentials and Simple Start), the Inventory item details feature is not available.

Highlighted
Level 2

PROFIT IN EACH INVOICE

This is not showing a profit.

Just showing invoice amount and invoice product and services breakdown. Here is no cost of sales for specific invoice reference or else.

How can I know the profit on this invoice to invoice?

Highlighted
QuickBooks Team

PROFIT IN EACH INVOICE

Thanks for getting back to us, @towhidctg.

 

The cost of sale or cost of goods sold is tracked if an inventory type is used for the item. Otherwise, we're unable to see the invoice profit.

 

We can run the Profit and Loss report to track the profitability but it will show all invoices and all purchases. Let me guide you on how to run Profit and Loss report:

 

  1. Go to Reports.
  2. Find the Profit and Loss report.
  3. In the open Profit and Loss report, select Customize.
  4. In the Customize report panel, select the Rows/Columns item to open the section.
  5. From the Columns drop-down list, select Locations.
  6. Select Run report.

I'll add this article, for more information: Run a Profit and Loss report in QuickBooks Online.

 

Also, you can read out this article on how to customize your financial reports: Customize your reports in QuickBooks Online.

 

Feel free to post again if there's anything else you need help with running a report. I'm here to help you more. All the best.

Highlighted
Level 2

PROFIT IN EACH INVOICE

LOCATIONS FOR WHAT?

Highlighted
Level 2

PROFIT IN EACH INVOICE

LOCATIONS FOR WHAT

Highlighted
Moderator

PROFIT IN EACH INVOICE

Hi there, @towhidctg,

 

Allow me to join the discussion and share additional insights about this.

 

Use the Location filter to categorize information from different sites, offices, regions, outlets, or departments of the same company. It also allow you to see all the payments per location and deposit them as a group. You can skip this step, as it is optional.

 

Vpcontroller is right. There isn't currently a report to show Gross Profit for each invoice. Your revenue is summarized in the Profit and Loss or Income by Customer Summary Reports.

 

Having this feature available in our program is a great idea. I can see how beneficial it is to keep track of your gross margin. While we're currently unable to do this, you can open a Profit and Loss % of Total Income Report, then click the Income amount to open the Transaction Report. From there you can click the Export icon and add the data manually on the worksheet.

 

See this article to learn more about exporting reports to Excel: Export your reports to Excel from QuickBooks Online.

 

I'm making it my top priority to relay this suggestion to the Development Team, letting them know you'd like to have this ability.

 

Stay on top of our product updates and feature releases by visiting the QuickBooks Blog: Intuit Blog.

 

Feel free to reach out to me if you have any other questions. I'm always here to be your QuickBooks guide. Cheering you a productive and wonderful week!

View solution in original post

Highlighted
Level 1

PROFIT IN EACH INVOICE

I am a small business and i need to run Gross profit inovices for each invoice in order to give them to our salespeople.   I have been a Quickbooks users for past 15 years.  Yall need to figure this out. It should not be rocket science.   I am curretnly looking at other software  programs to replace Quickbooks. 

Need to get in touch?

Contact us