cancel
Showing results for 
Search instead for 
Did you mean: 
leighton-smith-g
Level 1

How do I get my QB to show GrossRev less disc/returns = Net Rev, as seen in QB post: quickbooks.intuit.com/r/bookkeeping/what-is-a-profit-and-loss-statement/ ?

I want to build a QB P&L Report that reflects that version shown in this QB article post (https://quickbooks.intuit.com/r/bookkeeping/what-is-a-profit-and-loss-statement/), which shows a screenshot with Gross Revenue less discounts/returns = Net Revenue.  I can't figure out how to do that in Quickbooks? (I'm using QB online).
5 Comments 5
MariaSoledadG
QuickBooks Team

How do I get my QB to show GrossRev less disc/returns = Net Rev, as seen in QB post: quickbooks.intuit.com/r/bookkeeping/what-is-a-profit-and-loss-statement/ ?

I have some information to provide about the Profit and Loss report, Leighton. 

 

In QuickBooks Online (QBO), the way discounts work is that they show up under Income and are deducted first from the Sales amount. I've added this screenshot for reference:

profit and loss.PNG

Aside from that QBO offers different types of Profit and Loss report that specifically offers what your business needs. See the image below:

different profit and loss.PNG

 

 

You'll want to export your reports to Excel if you need to customize them further so they appear how you want them to appear. Read this article for more details: Export Your Reports To Excel from QuickBooks Online.

 

Furthermore, QuickBooks offers different reports that cater to your business needs. Learn how to customize them to ensure they provide the right data. I've added this article for more information. Customize Reports In QuickBooks Online

 

Drop your comment if you need further assistance with the report. I'm always right here to help.

leighton-smith-g
Level 1

How do I get my QB to show GrossRev less disc/returns = Net Rev, as seen in QB post: quickbooks.intuit.com/r/bookkeeping/what-is-a-profit-and-loss-statement/ ?

Many thanks, that's helpful.  Is there any way to get QBO to produce a P&L that looks like the below, with "Gross Revenue" less certain elements such as returns/discounts/other items like Royalties, which leads to "Net Revenue" (I know I can export to Excel and build it myself, but would prefer not to).

 

Gross Revenue

   Less Royalties/Discounts/Returns

Net Revenue

   Less COGS

Gross Profit

etc.

JoanaC
QuickBooks Team

How do I get my QB to show GrossRev less disc/returns = Net Rev, as seen in QB post: quickbooks.intuit.com/r/bookkeeping/what-is-a-profit-and-loss-statement/ ?

Thank you for replying to the thread, Leighton. Let me share some information on customizing your Profit and Loss report.

 

In the meantime, the template of customization in your P&L is unavailable. Just as my colleague mentioned, you can export your report to Excel and create it yourself.

 

Here's how:

  1. Go to Gear icon ⚙.
  2. Select Export data.
  3. On the Reports tab, set the date range.
  4. Add or remove items from the Reports and Lists tabs by turning the switch on or off.
  5. Select Export to Excel.

 

Moreover, let me share these articles that you can check to assist you with your reports: 

 

 

If you still have concerns about your report, you can either create a new post or reply to the thread. Have a great day!

leighton-smith-g
Level 1

How do I get my QB to show GrossRev less disc/returns = Net Rev, as seen in QB post: quickbooks.intuit.com/r/bookkeeping/what-is-a-profit-and-loss-statement/ ?

Thanks, yes I'm familiar with the export to Excel function and I use it constantly.  I was hoping to build this format within QBO but looks like that's not possible.

Thanks

Leighton

ErwinQ
QuickBooks Team

How do I get my QB to show GrossRev less disc/returns = Net Rev, as seen in QB post: quickbooks.intuit.com/r/bookkeeping/what-is-a-profit-and-loss-statement/ ?

Thank you for getting us back, Leighton.

 

Since this feature is unavailable, I highly recommend to  share feedback with us to help improve your QuickBooks experience. Our product engineers will take a look at your suggestions and get it possibly added in the future enhancements.

 

For future reference you can check out this article: Run reports in QuickBooks Online.

 

Don't hesitate go back to Community if you have more questions to any related QuickBooks product. Have a great day!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us