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.
-
Adrian Bennetton
commented
My company has been using Invoices and Bills facility in Xero since 2014. There is no facility to apply discounts to bill line items as there is no discount column available via the GUI. Also the Xero user can’t toggle this discount field via [Show/hide field] button as in Invoicing.
Now consider one of our examples. We have partner contacts who can be either a supplier or a purchaser and in a given Qtr depending whether the sum of all sales by both partner contact and ourselves in that Qtr are net to ourselves or net to partner contact. This is through a revenue sharing agreement with a partner contact. Mostly it’s 75% for us and 25% for partner contact. However, sometimes it can be 87.5% for us and 12.5% for the partner contact.
In the example, I've uploaded is a Xero Bill (some sensitive info has been blocked out) from the partner contact because the sum of all the sales to the third parties over the Qtr made by us and the partner contact results in us owing the partner contact money so they would invoice us in that Qtr.
Each line is a sale to a third party. For bills, if positive, then it is us that has made the sale to the third party. If it is negative, then it is the partner contact that made the sale to third party. You can see that we have managed to get discounts on each line item to represent the revenue share. The way we achieve this is first create a purchase order where there is a line-item discount column. Then convert this to a bill. Also, you can’t then edit the bill with a different % discount. Not ideal if you don’t need to create a PO but easier than calculating or adding separate discount lines or adding a credit note as workarounds.
-
Noelle Bruce
commented
This really needs to be implemented. I've been spending tons of time to switch my company over to Xero and just finding out this feature isn't implemented is a huge disappointment and waste of time. Now we'll have to figure out an alternative or some workaround because it is highly impractical to be editing these manually unfortunately (more room for error)
-
Carla Janse van Rensburg
commented
Purchase/Bill Discount Field and/or Payment Terms Setting should have discount field.
Xero is lacking supplier settings to set a percentage settlement discount by supplier default settings. There is nowhere to apply credit terms for purchases that include a settlement discount. Xero suggests adjusting the quantity to accommodate the discount but this inaccurately records inventory quantity. Likewise adjust price to reduce for discount but this also inaccurately records the price of an item. There should be a field in Bills for discount %. And a payment terms option that includes a settlement discount for suppliers accounts.
-
Paul Radford
commented
Adding discounts to bills is too Klunky, and too slow. adding a negative on a separate line is counter intuitive. You should be able to have a discount column for each line item. Most suppliers invoice this way and it should be the same when entering bills.
-
Son Le
commented
We're starting Xero from this month, and this feature is important to our business, as I'm sure to many, many others - so why has Xero not done anything about it since the idea was touted in Aug 2012?
-
Deedra Knaus
commented
There is no discount column for bills must be Stone Age accounting. It cannot be that hard to add; even the old Real World accounting had this built-in!
-
Jon Hardiman
commented
Xero added the discount column to Invoices why cant they add it to Bills as well.
Agree with other users that it is frustrating to be unable to add in a discount.
Please Xero look in to this, the original post was created years ago! -
Simon Kelly
commented
Totally Agree Tracey, it's terribly frustrating having to 'doctor' the Bill to allow reconciliation. Not to mention the implications for my accountant.
-
Tracy McConnell
commented
We have several clients that get discounts from Suppliers for Early payment. Different % discounts depending on how early they pay. We have not found any simple way of dealing with this, and are having to change each individual Bill/Purchase invoice, before allocating payments. This is dissuading our clients from wanting to move to Xero, and some that we have recently moved are considering changing package again. This is costing alot of time to maintain at their current rate of orders.
-
Abetta Moble Locksmith
commented
The mind boggles as to why this is not just added as the coding is already there for Invoices, Sales Orders and Purchase Orders.
Considering Xero has been around for 17 years and this is still just a topic of conversation. I would have expected this issue to be resolved back in 2006 when Xero was Accounting 2.0 and the issue had already been raised in the Beta version Accounting 1.0 - Rant Over !
-
Kurt Schubert
commented
This is an astonishing omission from Xero, it is an everyday occurrence in commercial trading terms and should be corrected as a matter of urgency.
-
John Rae
commented
I told agree with Rosalyn Easton
I was stunned not to have this feature when I started using Xero in July 2022. I consider it a major omission that should be fixed ASAP. A total pain to work around. Aarggghhhhhhhhhh -
Rosalyn Easton
commented
I was more than annoyed at the lack of this feature that has been totally missed by Xero. It adds extra steps changing the invoice totals and then remembering when to pay various invoices on time to get the discount.
In my previous package I had the ability to set in the Supplier Contact level of discounts and "if paid by dates" that automatically calculated the discount if I paid before that date. -
Eta Brand
commented
I am new with XERO. When entering a bill from a supplier I discovered that there is no quick built in option in a column (there is this option in creating an invoice) for applying a discount to that item. My supplier offers 10% on some items and 5% on other items in the same bill. XERO already includes this easy option when creating an invoice. It seems like a no brainer to add this IMPORTANT option for entering a bill. How soon can this be actioned? Tinkering with the number of items or create fractions of an item this will create a nightmare for my inventory numbers. Creating a separate line for a discount is a time wasting exercise. PLEASE find the way to include this easy improvement ASAP. This would save time for users.
-
Henrique Figueiredo
commented
I was surprised by this limitation. I don't understand why Xero doesn't support supplier discounts on invoicing.
At the moment we are integrating with Xero API and unlike sales invoices, we will have to calculate the discount before sending the data to Xero system. Unfortunately, the integration of purchasing bills will be less transparent. -
Gillian McConnell
commented
Is it possible to be able to apply even a penny discount when paying a supplier invoice. ATM i have to go back into invoice to reduce the original amount of invoice by the discount which is time consuming
-
Liza Labuschagne
commented
Hi I agree , we need to add the discount % on the contact detail where you do all the financial info if very invoice carries a %. We should also be able to add a discount on single invoice (refer sage cloud).This is very import for the retail clients.Thanks
-
Kamila Urbanska
commented
An option in Xero to raise commission invoices which are deducted from supplier payments or being able to differentiate from sales invoices and commission invoices raised to suppliers.
-
Susie Lacher
commented
I agree. My Suppliers add discounts to each line. No having a discount column as it does in invoicing makes entry slow.
-
Art to Art Accounts
commented
It seems inconsistent that there is a discount column in invoices but not bills. Should be easy enough to add it in since it is in the invoice template already.