Sales Invoice | Discount - Ability to set account (not impact line Account)
Discounts - the ability for the discounts in sales to be allocated to an expense account rather than distorting sales figures. At the moment each line item has the cost of the item then applies say 10% discount equals net which then is allocated to the sales account. I would like the option to allocate discounts to an expense called discounts given so that we can track and show the correct sales figures. By distorting sales figures you could be affecting calculations like WET. other programs allows you to setup discounts given & taken and freight even.

-
Loretta Sutcliffe commented
In some instances I do enter as a separate line item but the business Im particularly more interested in showing the discount in chart of accounts is a vineyard and the sales are imported from a pos system we use so its not feasible for me to change the info - other than doing a jnl each month by extracting data from the POS system. I have to alter the sales anyway as the integration between xero and vintrace doesnt recognise GST on credit card surcharge - so time consuming to fix every sale every day but not much we can do. And no the recode cant be used as the invs are GST exclusive created so it completely mucks up the totals if not done manually. Hopefully enough people complain about the integration as credit card surcharges are here to stay and they fix it.
-
Eric Waggoner commented
Another insight…the workaround is to add discount as separate line item. BUT since discounts aren’t an officially supported line item type, negative Quantities and Prices are funky in general and seem to not work at all on the iOS app, not sure about Android.
Had a draft made, went to send it but had to adjust the discount, and had to change back to regular “on the line” discount because I was stuck on mobile at the time and couldn’t edit my existing discount line.
-
Bryn Parrott commented
I completely agree. Today when discount column is used Xero just adjusts the line item total but the discount value is not separately recorded in chart of accounts. Thus not allowing me to assess the impact of discounts on profit.
I imagine how this could work:
a) user records a discount percentage against a line item.
2. xero adds a new line item described as “Discount” with account set to the predefined “Discount” chart of accounts item.
3. as further discounts are added to other line items that single discount line item is automatically adjusted. So as not to make a whole series of micro transactions, just one discount item per invoice. -
Eric Waggoner commented
I do a lot of work with nonprofits and utilize discount lines to Charitable Contributions on labor performed. This is a major need!
-
Ignacio Moran Merzi commented
I absolutely agree! i need the same, becouse is importartant for us know the real amount of sales and discount.
-
Erin Sulllivan commented
I have exactly the same problem. This would be great and does not seem like a huge stretch, hopefully, for Xero. When you have a high volume of invoices to reconcile with early payment discounts it can take forever.