Skip to main content
A
allstuff
January 13, 2024
Question

Where are discounts recorded in a P & L ?

  • January 13, 2024
  • 1 reply
  • 0 views
Trying to locate a total for the amouunts of the discounts that have been applied to invoices during last year. Thanks

1 reply

J
JamesAndrewM
January 13, 2024

I see that you want to locate a total for the amounts of the discounts that have been applied to invoices during last year in your P & L report in QuickBooks Online. I've got guidelines you can follow to achieve this.

 

QuickBooks automatically creates a Discount given account in your chart of accounts to track the discounts you give. If you haven't already, turn on the discount setting. Here's how:

 

  1. Go to Settings and then Account and Settings.
  2. Click Sales.
  3. In the Sales form content section, pick Edit.
  4. Turn on the Discount setting.
  5. Click Save and then Done.

 

These discounts are typically recorded as a reduction in the revenue account on the Profit and Loss (P&L) statement. To locate the total amount of discounts applied to invoices during the last year, you can follow these steps:

 

  1. Log in to your QuickBooks Online account.
  2. Navigate to the Reports tab in the left-hand menu.
  3. In the search bar, type Profit and Loss and select the Profit and Loss report from the suggestions.
  4. Customize the report by selecting the appropriate date range for the last year.
  5. Run the report to view the total amount of discounts applied to invoices during the last year.

 

I'm adding these articles you can use in the future:

 

 

By following these steps, you should be able to locate the total amount of discounts recorded in the Profit and Loss statement for the specified period. If you have more questions about reports in QuickBooks Online, post them here in the forum. I'll be sure to answer them ASAP. Stay safe!

    A
    allstuffAuthor
    January 15, 2024

    Thanks for help locating the discounts but they only appear for the 4th quarter. What do I need to do to show them for the full year ?  They are labeled Time To Pet Sales and not discounts ????????

    I selected Last Year as my time period.

    A
    AnneMariee
    January 15, 2024

    Welcome to the Community, @allstuff.

     

    I appreciate you for following the steps provided by my colleague. Let me provide some information as to why you're only seeing discounts for the 4th quarter last year and why they're labelled Time to Pet Sales.

     

    Before anything else, it would be helpful to know if you were using a non-inventory item to represent the discounts you gave to your customers. If so, it seems like the item was linked with the Time to Pet Sales account instead of the appropriate Discounts given account. Rest assured, I'm here to guide you on how to resolve this.

     

    1. On the left navigation panel, hover on Sales. Then, click on Products & services.
    2. Locate your Discount item. Click Edit under the Action column.
    3. On the Income account dropdown, choose Discounts given.
    4. Tick Also update the account in historical transactions.
    5. Click Save and close.

       

    Once done, run a Profit and Loss report once again. Then, filter it to show your data from last year. This time, all of your discounts given last year should be reflected in the report.

     

    For more info on changing the income account of your items in QuickBooks, feel free to browse this article: Change the account for a product or service item in QuickBooks Online.

     

    For future use, you might find this article helpful in saving a report's customization settings: Memorize reports in QuickBooks Online.

     

    Feel free to ask any more questions about reports or related concerns by replying to this thread anytime. I'm here and happy to help. Take care.

    Terms & ConditionsAccessibility statement