Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hello!
Can someone please help me?
How do I add a discount to a line item in my QBO customer (sales) invoice.
ie/
-10% off on item 1
-15% off on item 2
-No discount on item 3
-etc etc
..An Individual discount on each item for when I am running promos - I can't have a total invoice discount as the discounts vary depending on the product - so the total discount value line is useless.
Help please! :)
Thank you
-Derek
Welcome to the Community, @Derek_D.
You can consider using a discount line item to apply a discount to one or more items on the invoice. To do that, you'll need to create a discount item first before applying it on the invoice. Let me guide you how.
5. Click Save and close.
Once done, you can now use the Discount item on an invoice. Here's how:
In case you need tips and related articles in the future, visit our QuickBooks Community help website for reference: QBO Self-help.
Feel free to visit us again if you have any other questions with QuickBooks. We're always here to help.
Hi, Derek_D
Create a service type Item called Discount and connect Income account - Discounts ( expense type ) and Expense account - Uncheckamrk OR Discounts received ( income type ) for bill/expenses screen.
For, Discount item select the out of scope tax rate and enter the discount amount as the negative amounts
Now you can select the Discounts as you need for each line items
to display the total discount amount customize the invoice
Note do not checkmark Total discount on the invoice customization instant create your own custom field and enter the total discount amount.
Check the attached sample invoice
Note:
Should taxes be applied before a discount or after?
in the above solution Selling price is subjected to Sales taxes therefore
speak to your tax consultant if you want to exclude sale taxes on selling prices
and use net price after discount
If taxes are excluded selling price is
Sales price (-) Trade Discount = Net Selling Price
No Discount item on the invoice.
Trade discount transactions are not included in QuickBooks.
* OR
use tax codes/rates for Trade discount check the attached sample invoices comments below
transactions are entered in QuickBooks and on the invoice as well.
Comment back for further clarifications / to discuss.
Hi Mark,
Thank you for your reply
I actually did try this method but the discount rate seems to only be a dollar amount, and not percentage. ...I need to have percentages ie. 10%,15%, 20% etc ...I wouldn't be able to manually calculate the dollar amount of each one since my invoices currently can have over 25 line items and creating 10-20 invoices per day the time is just too great to figure out the dollar amounts of each and make a line discount.
..am I misunderstanding? - or is it possible to make a percentage discount line item?
Thanks so much!
Derek
Hello,
thanks so much for your response
..is there a way to make a percentage discount on a line discount item and not just a dollar amount?
I need 10% 15% etc apply to multiple items and so a dollar amount won't work since I have 1 unit rate, times multiple units @ 15% off - for sometimes over 25 different items we sell on the same invoice
Any help would be great!
Thank you!
Derek
Let me help add some details, @Derek_D.
Currently, you can only apply the discount percentage on your discount item name. As my colleague @Mark_R suggested, you can manually calculate the discount amount based on the percentage.
If you want to have different discount percentage per product item, you may have to create several discount items.
Having the option to directly enter a discount percentage per line item on an invoice is a nice suggestion. Letting us know your thoughts about this will let our developers know what they need to consider in future product updates.
In the meantime, you can visit our QBO blog to know more about our latest product updates and what our product team is working on.
If you have other questions about your transactions, please feel free to get back to me. I'm here to help.
Derek,
read my next comment below
Derek, use your own invoice template for customization and match the fields to QuickBooks Online fields check the attached sample invoice.
To access the sample invoice templates move to the Gear icon right top > List - All lists > Custom form styles > click New style dropdown menu > Import style > click Download instructions & samples
under the QTY/DISCOUNT column enter the percentage (% will be displayed as decimals ), under the RATE column enter the amount applicable for the discount, QBO will calculate the amount for you and record the relevant transactions.
Note Only the total discounts you need to enter manually in the custom fields if required.
Hi, Derek_D
Create a service type Item called Discount and connect Income account - Discounts ( expense type ) and Expense account - Uncheckamrk OR Discounts received ( income type ) for bill/expenses screen.
For, Discount item select the out of scope tax rate and enter the discount amount as the negative amounts
Now you can select the Discounts as you need for each line items
to display the total discount amount customize the invoice
Note do not checkmark Total discount on the invoice customization instant create your own custom field and enter the total discount amount.
Check the attached sample invoice
Note:
Should taxes be applied before a discount or after?
in the above solution Selling price is subjected to Sales taxes therefore
speak to your tax consultant if you want to exclude sale taxes on selling prices with discount
use net price after discount
If taxes are excluded selling price is
Sales price (-) Trade Discount = Net Selling Price
No Discount item on the invoice.
Trade discount transactions are not included in QuickBooks.
OR
use tax codes/rates for Trade discount check the attached sample invoice
transactions are entered in QuickBooks and on the invoice as well.
Comment back for further clarifications / to discuss.
Should taxes be applied before a discount or after?
in the above solution Selling price is subjected to Sales taxes therefore
speak to your tax consultant if you want to exclude sale tax on selling prices
use net price after discount
If taxes are excluded selling price is
Sales price (-) Trade Discount = Net Selling Price
No Discount item on the invoice.
Trade discount transactions are not included in QuickBooks.
OR
use tax codes/rates for Trade discount check the attached sample invoice
Comment back for further clarifications / to discuss.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.