Skip to main content
April 13, 2021
Question

HI, how does one check/report on invoice GP amounts.. Is there a report or a way to check GP per invoice for reporting and commission basis?

  • April 13, 2021
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

Angelyn_T
April 13, 2021

Hi, @craigoasis.

 

It's nice to have you here on the Community forum. I'm here to share with you some information about gross profit on invoices or reports.

 

Being able to pull up a report which consists of the gross profit per invoice is currently not available in QuickBooks Online. The good news is, we have the Profit and Loss report that shows the percentage of total income report. This report gives the summary amounts by accounts.

 

Thus, you can export the Profit and Loss Detail report to Excel. Then, create a formula with the amount of a single invoice divided by the total amount of income. After that, you can convert it to a percentage. Or, the Invoice List report to get the total of the invoices. Then, get the income percentage of every income.

 

To open these reports:

 

  1. Open your QuickBooks Online (QBO) account, then go to the Reports tab.
  2. Look for the report you want to open.
  3. Make the necessary customization from there.

 

To learn more about handling reports in QBO, you can open this link: Run reports in QuickBooks Online.

 

On the other hand, here's how you can export your reports to Excel.

 

You can also visit this link on how to get the profit percentage of your data: How to run a profit margin analysis for your small business.

 

If you have any other questions about your invoices and gross profits, let me know by adding a comment below. I'm always here to help. Keep safe!