cancel
Showing results for 
Search instead for 
Did you mean: 
ChristieAnn
QuickBooks Team

Correct way to enter a Discount on a Vendor Bill.

Hi there, RFNFlanges.

 

To record the invoices that already due that gives from a vendor for a 15% discount once it makes bi-weekly installments, you'll need to create first a bill. Then, set this entry into 15% terms with your agreed upon date.

 

Here's how:

 

  1. Go to the Vendors menu at the top and select Enter Bills.
  2. Select a vendor from the dropdown list.
  3. Click the Terms drop-down arrow. Then, choose specific terms or select the add new to create a new one.
  4. Enter the date, amount, and due date.
  5. Fill in the other necessary field.
  6. Hit OK.

 

 

 

For additional details, you can click this article: Enter bills in QuickBooks Desktop.

 

Once done, you can now go to the Pay Bill page to apply the discount when paying the vendor bills. Please follow the steps below.

 

  1. Go to the Vendors menu, then select Pay Bills.
  2. Select the correct accounts payable account from the dropdown.
  3. Choose the checkboxes of the bills you want to pay from the table.
  4. Enter the date you paid the bill. Then, select the payment method.
  5. Click the Set Discount button. Then, double-check the recommended amount of discount or enter the correct one.
  6. Select the Discount Account.
  7. Click Done.
  8. Select Pay Selected Bills.

 

 

For additional information, you can open this article: Pay bills in QuickBooks Desktop.

 

Please refer to this article to see steps on how you can set up with Online Bill Pay so you can directly pay your vendor bills in QuickBooks: Use Online Bill Pay in QuickBooks Desktop.

 

Feel free to come back here for any QuickBooks questions. I'll be right here to assist you anytime. Have a good one!

David_Lyash
Level 1

Correct way to enter a Discount on a Vendor Bill.

I think it's ridiculous that QBO offers "3% 10 NET 30" as terms for vendors without the ability to automatically apply the discount if conditions are met. I used to have that feature in Quickbooks Desktop pro but not in QBO Advance. I am indignant as a consumer of their product. QBO advertises itself as a platform which automates most processes yet switching from QBD to QBO just adds layers of work on many things, especially when it comes to AP.
Going back to discounts on bills, sometimes I may have 100s of bills to which I need to apply a 3% discount. Btw, VERY common with a lot of vendors. It would take me less than a minute to apply the discount in Desktop Pro version. However, It would take me about an hour to enter 100s of credits against bills just to apply a 3% discount in QBO.

@books11249, customers are requesting that you add this feature asap. People have been writing about it for years and to no avail. It's about time someone pays attention up there. Please fix asap!

Rose-A
Moderator

Correct way to enter a Discount on a Vendor Bill.

It is always our aim to develop relevant features that came from customer's feedback, David_Lyash.

 

I know how important it is to automatically apply a discount to vendor bills in QuickBooks Desktop. However, this option is currently unavailable.

 

I can pass along all the feedback you have to the appropriate channels so you're able to reach a point of resolution as quickly as possible. Also, you can submit your feedback to make the program better by going to the Send Feedback Online on your QuickBooks Desktop.

 

 

In the meantime, I'd suggest visiting the What's New section on your QuickBooks Desktop, to stay informed with our latest news and updates including product improvements.
 

 

Additionally, you may want to bookmark this link: Resource Hub. This will provide you with resources and videos about managing your QuickBooks Desktop account, income, expenses, inventory, and running reports.

 

I'm always here to help if you have any other concerns or anything in QuickBooks. I'll make sure to get back to you as quickly as I can. Have a good one.

useranemostatacct
Level 1

Correct way to enter a Discount on a Vendor Bill.

There is no discount button

JessT
Moderator

Correct way to enter a Discount on a Vendor Bill.

Hi useranemostatacct,

 

Thank you for joining in on the thread. I'll provide ways on how you can apply a discount on your bill, and we'll do some steps to fix the missing Set Discount button.

 

If you're using QuickBooks Desktop, you can update your QuickBooks to fix the missing Set Discount button. If nothing happens, please proceed to repairing the program. If nothing really works, you can create a Vendor credit and apply it as partial payment to the bill, then pay the remaining amount.

 

  1. From the Vendors menu, select Enter Bill.
  2. Choose the Credit radio button just above the Bill transaction name.
  3. Select the vendor and enter the discounted item and the amount.
  4. Click Save.

 

Pay the bill the usual way, then click on Set credits and select the credit you created.

 

If you're using QuickBooks Online, there's no Set Discount button when paying a bill, but you can create a vendor credit and apply it to the bill. Here's an article for your reference: Enter a credit from a vendor.

 

You can always go back to this thread if you have questions as you go through the process. I just to make sure that your concern is addressed. Take care!

MaryB5
Level 1

Correct way to enter a Discount on a Vendor Bill.

Hi All;

So here's my dilemma. I'm on desktop, and while I know how to set the discount, i don't want it applied to freight, since nowhere does that happen ;)

I attempted to right the equation like an excel equation - nope; I put (- freight) in brackets - nope

 

So, how do you calculate a discount without including freight? The goal is to capture the discount in QB so that we are registering hard costs that then get carried into retail sales. The realized dscount is then also captured.

 

Thanks in advance,

 

MaryB5

RenjolynC
QuickBooks Team

Correct way to enter a Discount on a Vendor Bill.

Thanks for joining in on this thread, MaryB5.

 

I'll share some details about the discount and a suggestion to help with your concern.

 

When you set a discount on a transaction, it will be applied to the subtotal. This means that the freight is included.

 

If you are using QuickBooks Desktop Enterprise, you have the option to enable the Advanced Pricing option. This feature allows you to offer quantity discounts.

 

To enable the Advanced Pricing feature, you can follow these steps:

 

  1. Go to Edit > Preferences.
  2. On the left pane, select Sales & Customers then go to the Company Preferences tab.
  3. In the Custom Pricing section, put a check mark on the Enable Advanced Pricing box.
  4. (Optional) Tell QuickBooks how to handle price rounding. For example, if you set rounding to the nearest .05 cents, QuickBooks rounds the price from $15.92 to $15.95.
    • To have QuickBooks use the same rounding for all price rules, select Use the same rounding across all price rules then select the drop-down to choose a rounding option.
    • To set the rounding for each price rule separately, select Set rounding on each price rule. When new price rules are created, set the rounding.
  5. Hit OK.

For information about the quantity discounts, go to the Apply quantity discounts using Advanced Pricing section in this article: Use Advanced Pricing.

 

Please let me know in your reply if you require additional information about the process or other concerns. I'll be right here to help. Take care!

KPI Accounting
Level 2

Correct way to enter a Discount on a Vendor Bill.

Completely off topic. Did you read the question above?

bryanedube
Level 1

Correct way to enter a Discount on a Vendor Bill.

Does this also work for quickbooks online? we can't seem to figure it out. 

 

Thanks! 

 

Bryan 

Rasa-LilaM
QuickBooks Team

Correct way to enter a Discount on a Vendor Bill.

I’m glad to see you on this thread, bryanedube.


Let me guide you through the process of how to enter a discount to a bill in QuickBooks (QBO). We can add a discount line item to the bill or input a vendor credit. I’m here to help make sure the process is a breeze for you.


To set up the item:

 

  1. Tap the Sales menu on the left panel and choose Products and services.
  2. On the Sales page, click the New button to open the Product/Service information page.
  3. Select Service type from there.
  4. Key in Discount in the Name field.
  5. Fill in the remaining boxes.
  6. Click on Save and close.

Next, open the bill you’re working on and add the line item for your discount. Also, make sure to input a negative amount.


If you wish to use the Vendor credit feature, you can follow the recommended steps in this article: Enter a credit from a vendor.


I’m adding a link that contains resources on how to efficiently manage your expenses, bills, and other vendor-related tasks: QuickBooks Online guide. From there, you’ll find the article about managing supplier refunds and credits.


Reach out to me again if you have clarifications on how to handle vendor discounts. I’ll jump right back in to help and make sure you’re taken care of. Have a great day ahead.

ehong33
Level 3

Correct way to enter a Discount on a Vendor Bill.

Your message doesn't state what income account or category to place this new "discount" service under.

 

On that note, how incompetent is QBO support and what a pathetic "accounting" software that doesn't even allow for a simple way to apply a vendor discount to a bill. Intuit has no problem raising prices quickly but takes forever to roll-out even the simplest features that users ask for for years. 

sunapeetim
Level 1

Correct way to enter a Discount on a Vendor Bill.

This is a far more cumbersome process than in the desktop version.  Why has QB gone backwards in going to the online version?

ehong33
Level 3

Correct way to enter a Discount on a Vendor Bill.

Why does QBO always need to make things more difficult then it needs to be? If the vendors payment terms are 1%10NET30 for example, why can't QBO automatically offer a discount toggle to make the bill reflect the terms? Don't give me the canned response "that's a great suggestion for our feature request" because we all know Intuit doesn't read that or make changes according to user needs. Sorry just venting. Intuit keeps raising prices but doesn't release easy critical features we have been asking for years. 

Beau65
Level 1

Correct way to enter a Discount on a Vendor Bill.

Hi there,

 

Where is the set discount button?

Archie_B
QuickBooks Team

Correct way to enter a Discount on a Vendor Bill.

Thank you for joining this thread, Beau65. I'm here to show you how you can apply a discount on your vendor bill in QuickBooks.

 

If you're using QuickBooks Desktop, we can navigate to the Pay Bills window and use the Set Discount button to apply a discount to the vendor bill.

 

Here's how:

 

  1. Go to the Vendors menu, then select Pay Bills.
  2. Select the correct accounts payable account from the dropdown.
  3. Choose the checkboxes of the bills you want to pay from the table.
  4. Set any discount you want to apply to the bills by pressing the Set Discount button. Then click Done.
  5. Put on the date you paid the bill. Then, select the payment method.
  6. Once done, hit Pay Selected Bills.

 

For additional information, you can open this link: Pay bills in QuickBooks Desktop.

 

If you're using QuickBooks Online, an option or button such as Set Discount isn't available. We can, however, create a vendor credit and apply it to the bill. Here's an article you can use as a reference: Handle vendor credits and refunds in QuickBooks Online.

 

Please let me know if you need any additional information about the process or have any other concerns. I'll be around if need me. Enjoy your day!

KMorgee
Level 1

Correct way to enter a Discount on a Vendor Bill.

I'm looking to run an AP aging report in QB Desktop that will show me the discounts that are available in a separate column. I tried to customize the report but there is no option for any type of "discount" in the column field. 

ChristieAnn
QuickBooks Team

Correct way to enter a Discount on a Vendor Bill.

Hi there, KMorgee.

 

Thank you for visiting the QuickBooks Community. Let me share details on how the Accounts Payable Detail report works in QuickBooks Desktop. Then, I'll ensure you can see the discount details in a different column by following the steps below.

 

The A/P Aging Detail report shows all unpaid bills in your accounts payable. You always have the option to customize it. To start with, you can click the Display button and then choose the Discount Available option. This way, you can see all the discounts present in a separate column.

 

Here's how:

 

  1. Click the Customize Report button on the said report.
  2. Go to the Search Columns search bar and checkmark the Discount Available.
  3. Click OK.

 

bar1.PNG

 

On the other hand, if you want to see the discount associated with the Bill Payment and a bill that is connected to it, you can run the Vendor Balance Detail report and customize it. This will show the specific amount of the markdown. Please follow the steps below.

 

  1. Click the Reports menu at the top.
  2. Choose Vendors & Payables and select Vendor Balance Detail.
  3. Go to each vendor name and you'll be able to see the discount info.

 

I attached a screenshot below for visual reference.

 

 

 

However, if you're referring to another discount, you can export the said reports in Excel mentioned above. This way, you're able to customize them to show discounts that are available in a separate column. Please follow the steps below.

 

  1. In QuickBooks, go to the Reports menu and select Reports Center.
  2. Find and open any report.
  3. Select Excel on the toolbar. You can also select Print or Email to save the report as a PDF.
  4. To create a new Excel workbook, select Create New Worksheet. If you want to update an existing workbook with the data in the open report, select Update Existing Worksheet. Select Browse and then find the workbook on your computer. Keep in mind, this overwrites the existing workbook.
  5. When you’re ready to export, select OK. To open the report in Excel, you can also select Export.

 

Lastly, you may refer to this article to view details on how you can memorize reports in QuickBooks so the same settings of the customized report are available for future use: Create, access and modify memorized reports.

 

Please Don't hesitate to click the Reply button below if you have other concerns related to reports in QBDT. I'm always around to help you, KMorgee. Have a great day!

Kens equipment
Level 2

Correct way to enter a Discount on a Vendor Bill.

Seriously ?  

   When I had the desktop version , my discounts were automatically figured. I just had to apply them to the bill when it was paid. Now with on-line , I have to make a vender credit for every bill that I pay ? This is just beyond crazy. I could pay a hundred bills in a month , how is this better at saving me time ? This need to be corrected guys , come on. 

cauger
Level 1

Correct way to enter a Discount on a Vendor Bill.

OMG, what a joke. Any accounting system should offer this basic functionality. I have been using this feature in Netsuite for 15 years. QBO needs to get it together and add this basic feature.

S0ngbird
Level 1

Correct way to enter a Discount on a Vendor Bill.

I have the same question.   It seems ridiculous to have to manually create a credit to take vendor prompt payment discounts.   Coming over from QB  Enterprise where the discount is set up in the vendor terms and automatically calculated and applied, this is a HUGE step backwards.

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

Need to get in touch?

Contact us