Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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.
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:
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!
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
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.
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.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here