cancel
Showing results for 
Search instead for 
Did you mean: 
JKam
Level 1

Vendor Early Pay Discount - Freight Allowance

How do I set up a vendor that has early payment terms based on Invoice less freight allowance so that the discounted amount calculates off of that total?
Example:  Invoice amount is $1,000 (delivered pricing) and the freight allowance is $200.  The terms are 1%10 Net 30 on invoice less freight allowance.  Currently QuickBooks calculates the discount as $100 (1% of $1,000), but I need it to calculate as $80 (1% of $1,000 minus $200 freight allowance).

Solved
Best answer April 13, 2021

Best Answers
JessT
Moderator

Vendor Early Pay Discount - Freight Allowance

Hi JKam,

 

The early payment discount on the term will always be based on the due amount. Therefore, in your case, you can have a workaround like adding the freight allowance as another line item with a negative value to lessen the due amount. Or, you can remove the terms when you record a payment, then add it as another line item in a form of a discount and put a negative amount to reduce the due amount.

 

If you have other questions, feel free to go back to this thread.

View solution in original post

4 Comments 4
Ethel_A
QuickBooks Team

Vendor Early Pay Discount - Freight Allowance

Welcome to the Community, JKam.

 

I am happy to share with you the steps on how to add discounts to your vendor bills. This gets marked as an income since there is a price reduction instead of adding cost to the business.

 

Here's how:

 

  1. Go to the Vendors menu. 
  2. Select Pay Bills.
  3. Choose the vendor bill. 
  4. Click the Set Discount button.
  5. Enter the Amount of Discount.
  6. Select the Discount Account.
  7. You can click Add New if the income account is not yet listed.
  8. Click Done.
  9. Click Pay Selected Bills.

 

You can also remove discounts for later payments

 

 

Let me know how it goes or if I can be of additional assistance. I’m always here to help. Take care and enjoy the rest of your day! 

JKam
Level 1

Vendor Early Pay Discount - Freight Allowance

Hi Ethl_A,

We already have vendor discount set up and have been using it.  The discount amount calculated by QB is based on invoice dollar amount and terms.  However, I need some of them to be calculated off of invoice minus freight allowance (if there is any).  The freight allowance is recorded on the invoice.
Please see original message that explains this as an example.

 

Thank you,
JKam

JessT
Moderator

Vendor Early Pay Discount - Freight Allowance

Hi JKam,

 

The early payment discount on the term will always be based on the due amount. Therefore, in your case, you can have a workaround like adding the freight allowance as another line item with a negative value to lessen the due amount. Or, you can remove the terms when you record a payment, then add it as another line item in a form of a discount and put a negative amount to reduce the due amount.

 

If you have other questions, feel free to go back to this thread.

JG411
Level 1

Vendor Early Pay Discount - Freight Allowance

I've been dealing with this same problem for eight years now. Quickbooks isn't capable of it. My first accounting program for the mac could handle it in 1988. I have had problems with missing the freight deduction for years. I am now adopting a new tactic of entering the invoice net of the freight for the FFA as it is our normal practice of paying within terms. That way the discount is taken properly and the freight is already deducted. If the vendor has a problem with the freight deduction they will contact you.  I hope this helps.

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

Need to get in touch?

Contact us