Bills - Apply discounts on accounts payable invoices
Applying discount on account payables invoices.
Purpose: User doesn’t need to manually recalculate the cost of each item
Thank you everyone for engaging about the need for a discount column in Bills with us here.
While there isn’t a direct column for adding a discount atm, there are a few ways you could look to reflect this in your bills right now;
- Use Xero’s inbuilt calculator in the Price field, and add a note to the description of that line e.g $5 item at a 20% discount you would enter 5 x 0.8 in the quantity field and could add a description “including 20% discount”
- Reduce the Quantity field to reflect the discount e.g 20% discount enter 0.8 in the Quantity and use a descriptor as above
- Use a separate line of the bill to enter a whole amount discount with a negative Price amount
- If you use Purchase orders, when you copy the Purchase order to a Bill though the discount column will not show the Subtotal will show “includes a discount of ‘x’”
As we continue to uplift areas of Bills this is a feature that our product team are aware of, and would like to solve for. Though we can’t provide any time frames as yet, we'll keep you updated through this thread as soon as there's movement to share.
-
Julia Kelly
commented
we own an incorporated society which relies on sponsorship regularly for our events. These sponsors usually give us discounts be it $s or %. it would be great to have this as a column rather than a row as it can vary. if it could be next to tax rate and the algorithm could be set up to understand the difference between % and $ so that each item can be filled separately for whichever it needs. At the moment I'm writing incl 10% (eg) discount. in the description and deduct it as amount. I'm not having a multiplied decimal as this will add confusion for our suppliers/sponsors and we don't want to lose them. We'd also like it to be user friendly for us who are already putting far to much effort into having to use valuable time to learn new and unwanted skills
-
Laura Medina
commented
When entering the bills, I would be great that the price that appears is the last one, and that we can add the discount on the bill without creating a purchase order.
-
Serena Waters
commented
I have to manually do a credit note, to apply a discount, for over 50 suppliers every week, having this feature would save so much time. I am just glad that I don't apply the discount to every bill, there are hundreds of supplier invoices every week.
Please xero, it is just a tick box like in the invoice area.This needs to be a priority
-
John Rae
commented
This has been requested for so long. And it is a total no brainer. This is software used by small and medium businesses. If XERO management had any idea of the needs that we have they would have fixed this a long time ago.
Every month when I pay my monthly supplier accounts I grit my teeth over not having this functionality. And I know other small businesses that feel the same. I also know some businesses that did not proceed with purchasing Xero because of the abscence of this feature. -
John Rae
commented
This has been requested for so long. And it is a total no brainer. This is software used by small and medium businesses. If XERO management had any idea of the needs that we have they would have fixed this a long time ago.
Every month when I pay my monthly supplier accounts I grit my teeth over not having this functionality. And I know other small businesses that feel the same. I also know some businesses that did not proceed with purchasing Xero because of the abscence of this feature. -
Nicola McGuinness-Bell
commented
In the projects area, the expenses area lists expenses at their original cost and doesn't include the discount given by that supplier. This means the expenses shown for the project aren't actually reflective of the true cost of the project.
There are currently no reports that allow you to see the company expenses, with discount, filtered by project so i can't actually report on the GP and net profit of a project without the painstaking process of clicking into every expense to find out the ACTUAL cost to the company less the discount given. We have suppliers who give up to a 50-60% discount so this is critical. -
Steve Dunks
commented
Please can you add this feature. Thank you
-
Peter Sutton
commented
Implementing an early settlement discount feature would be a significant improvement for our company. Most of our suppliers offer these discounts, so the ability to post a discount with each invoice—subject to a specific payment date—would be ideal.
Specifically, we are looking for a system that automatically applies the discount to invoices paid within the qualifying window during bulk payments, while defaulting to the full invoice amount for those that fall outside that timeframe.
This functionality would greatly enhance our efficiency. Could you please let me know if this is something that can be supported?
-
Cheyenne O'Leary
commented
Super frustrating that this was suggested 13 years ago and it hasn't been improved in that time. I'm wasting so much time adding a discount line to nearly 100 bills a week.
-
John Rae
commented
Very frustrating. This has been dragging on for years.
-
SHIRENE PETZER
commented
Hi, thank you for your reply, total understand. Please if you guys can push it up to the front of the quey. It is quite time consuming, to have to go do a credit note each time for the discount on a suppliers, one suggestion is that when we were doing the payment in the bank recon, we could apply the discount there as well. which is quite nice too. This is the only feature that i have found missing in Xero, otherwise all is good so far. Shirene
-
Melissa Lenos
commented
I have discounts on my PO and then when it pushes to a bill it does not show the discount but it pushes to the bill and then does not show. But the unit price and amount have the discount.
-
SHIRENE PETZER
commented
Hi, please if you can we really need discount applied to accounts payable, as we have alot of suppliers that offer discount to us. I would be so nice to be able to do it on bills level and not have to capture credit notes each time. It can be time consuming. Please this is one feature that is missing from Xero, I am a new user to Xero we use to use pastel, they had that feature. We are really missing it. Thanks
-
Mike Eggleston
commented
This is a standard feature in most other software. Not sure why Xero cannot handle early pay discounts.
-
Chaney Ferreira
commented
HI,
I RECEIVED A BILL FROM CREDITOR WITH DISCOUNT AND DONT KNOW HOW TO ADD THE BILL TO XERO SO THAT THE AMOUNTS MATCH.
-
John Rae
commented
Whilst I continue to use Xero I do not recommend it to others. In fact I disrecommend it. Customer focus and response is very poor. This particular topic has dragged on for years. The lack of action by Xero show how out of touch their senior management is from customers of their in the field.
-
Beth Powell
commented
Just asked the same question today. I have an statement with multiple lines getting discounts, so now I'll have to amend each one individually. What a pain.
-
John Rae
commented
Very disappointing response. Same old same old. Clearly Xero doesn't care about existing customers. - John Rae
-
kerry williams
commented
I also have several suppliers that offer a discount, but currently have to manually calculate each invoice. I would also like to see a credit limit and discount % section within the supplier details. They are there for AR but not AP
-
Haven Key
commented
Most of our main suppliers offer us an early settlement discount. It is very time consuming having to manually calculate this.at the 'Make Payment' stage. An 'apply discount' function would be far quicker and easier.