Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
D
DeGruyterIsabel
July 8, 2020
Question

Excel Reporting with Discounts Applied to Products

  • July 8, 2020
  • 1 reply
  • 2 views

Hello,

We usually sent out excel reports of our invoices to a different system to process providing access for our customers. These reports are currently manipulated and sent manual, but we're in the process of trying to automate this system. This process is made much harder because the discounts aren't automatically applied to the products in the report and usually have to be calculated within excel. Has anyone found a way to get around this issue or run into a similar problem? We'd also love to be able to apply different discount percentages to different line items within an invoice, but there doesn't seem to be anyway to do this without manipulating the product pricing, which is not what we want to do.    

1 reply

M
MadelynCModerator
Moderator
July 8, 2020

Welcome to the Community, @DeGruyterIsabel.


Let me share a way on how to apply discounts in QuickBooks Online.

 

You can set different discount percentage to different line items to an invoice through the discount feature. Just ensure to turn the option on to add the discount field to your invoices. QuickBooks also creates a Discount given account to track everything in your Chart of Accounts. I'll show you the steps:

 

  1. Click the Gear icon at the right top.
  2. Choose Account and Settings.
  3. Go to Sales.
  4. In the Sales form content section, click the pencil icon to edit.
  5. Mark the Discount box.
  6. Select Save, then Done.


Once done, you can now create a discount item with a fixed price. This will set a discount for the amount that you added each item. Here’s how:

 

  1. Go to the Gear icon again and choose Product and Services.
  2. Click New and then select Non-inventory or Service for the type.
  3. Name the item Discount.
  4. In the Sales price/rate field, enter the discount as a negative dollar amount.
  5. From the Income account drop-down menu, select the Discount given account.
  6. Select Nontaxable from the Sales tax category drop-down menu.
  7. Hit Save and Close.


Lastly, let’s add or use the discount to your invoice. Here are the steps:

 

  1. Select the +New button. 
  2. Click Invoice.
  3. Add products and services. Then fill out the rest of the form.
  4. Add the Discount item you just created. Then Save and send or Save and new.

You can check out this article for additional information about the process: Add a discount to an invoice in QuickBooks Online.


To record the payment you receive from your customers, just visit this article as reference: Record invoice payments in QBO.


It'll be my pleasure to assist if you need more help. Always take care. 

D
DeGruyterIsabelAuthor
July 9, 2020

Hi Madelyn,

 

I don't think I explained that quite right, the issue is that our discount fluctuates based on the customer and the sales manager agreement, so we're not looking to add a set discount to a product, but instead add a discount to a line item within an invoice.  

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement