Skip to main content
L
leighton-smith-g
April 2, 2024
Question

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/ ?

  • April 2, 2024
  • 1 reply
  • 0 views
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).

1 reply

MariaSoledadG
MariaSoledadG
April 2, 2024

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:

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

 

 

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.

L
leighton-smith-gAuthor
April 3, 2024

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.

J
JoanaC
April 3, 2024

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!

Terms & ConditionsAccessibility statement