Sales Invoices - Combine and hide line items for customers
Ability to combine and hide line items in the invoices.
Purpose: To have good accounting and tracking of sales without showing the client the breakdown of all the items involved
Hi everyone, thank you for your continued passion, and sharing how having the ability to group or combine line items within an invoice would give you the control to present information to your clients in the best way for your business.
In lieu of a direct feature, while I appreciate it won’t fit all needs here, the inbuilt calculator may help in some cases to combine costs of multiple lines to one, and we appreciate there are some customers that have explored third-party apps with more extensive functionality for the time being to full-fill their needs.
We’re updating the status of this idea to Accepted - While this isn’t on our roadmap atm, we see the value in this suggestion and it’ll be considered as we plan our future roadmap. We’ll update this thread if we have any more news to share.
-
Carlos Vieira
commented
Xero Support, how many votes do you need ?
Meantime, let us export the template to excel ...at least. Let´s improve this please, URGENT. -
Niki Bolton
commented
Looks like this has been continuously requested for over a decade :O
We will potentially look to move to another platform - by the looks of it all other big platforms offer this ability. I'm not sure why this couldn't be a part of the new invoice system that is being rolled out?? -
Bob Crawford
commented
Xero really couldn't care about this - this is regularly highlighted but for well over ten years continues to be ignored
VERY disappointing "customer service"
-
Lorraine Adams
commented
Long term / short term? I’ve been waiting for more than 10 years.
Having reset the voting clocks some time ago / the number of votes shown doesn’t truly represent the need for this.
Without it - management reporting / sales analysis is painfully limited.
No doubt as with other topics, there are also many other vote headers essentially for the same thing - diluting the number of votes seen for this item. -
Tim Taylor
commented
This function would really help us internally, but don't want to change my MO of giving an all in price to clients.
-
Eugene Kent-McDonald
commented
Xero might be slipping here, would have thought it would be easy enough to do.
Will have to start looking elsewhere, maybe back to MYOB?
Hope Xero will get its priorities figured out -
Julie Bartlett
commented
So why can we do this on the current invoice system and not the new invoice templates? If you put a . in the description box of the say the parts you want to enter and not show the client how much the parts were, this works perfectly ok? You do not see the parts price on the invoice. It is only happening on the new invoice templates you have created?
-
Susan Sydor
commented
I would definitely take advantage of being able to group line items on an invoice. Or be able to hide/combine so that the customer doesn't see certain admin fees I'd like to include in pricing, that need to be taxed or recorded differently. Seems complex, but I don't write software. Would love to see this functionality in Xero invoicing!
-
Sean Garland
commented
This has been around since 2012, or 11 years. I don't expect that this will change.
Because of changes in how we invoice for contract items, we're going to have to move away from Xero. I've been a staunch supporter of Xero for over a decade, because A) it's not Quickbooks, and B) it had the features we wanted/needed and C) it's included in almost all web based SaaS apps integration lists. Oh and it's not Quickbooks.
But now, it seems we'll be forced to move to Quickbooks just because Xero won't entertain the idea of having "combos" or "builds" that are a single item made up of various other items/accounts so that your chart of accounts, and balance sheet/profit and loss, all make sense.
Oh well. I guess it's time to move on.
-
Maree Creedon
commented
Hi Hannah,
Are you able to provide a link or instructions on how to set this up? -
Niki Bolton
commented
Hoping by adding a comment, this will bump this issue up a bit. It seems like there are a lot of people in the same situation given the number of votes and comments.
It is something offered on other software, so I can't imagine it would be a difficult thing to look at implementing. -
Bob Crawford
commented
@Tom David
Appreciate the comment but doing a journal entry is what we all have to do at the moment - and we are desperately wanting Xero to come up with a solution which is simple coding for them enabling multiple line items on an invoice which are hidden on the invoice issued to the client
Sadly Xero are not interested in helping us
-
Jon Baggot
commented
@Tom David Nice idea but as we have hundreds of monthly invoices and it is fluid (regular scope reviews and annual fee reviews etc) getting the journals to balance and balance a clearing account would be extremely time consuming. What we are doing is posting all to our general fees account then doing one journal to estimate splits between other sales accounts - not ideal but better than nothing.
It’s such an obvious product feature I can only assume the reprogramming is the stumbling block!! -
Tom David
commented
Hello all, regarding hiding lines on your invoice from your client, and still having all the backend of your invoice allocating to all your different accounts, this CAN be achieved using the manual journals feature in xero - woot.
Our accountant told us to create a simple invoice for full amount and allocate all line items to a “sales clearing account”, rather than all the usual accounts you would create allocations to.
Then, create a separate manual journal item that allocates the new invoice total amount from the “sales clearing account” to accounts exactly as you would as if you were building a more detailed invoice that you wouldn’t otherwise want your client to receive.
Then just send and reconcile your invoice from xero as you always would - the journals item handles all the accounts distribution rather than the invoice item. As long as the journals item adds up to the amount on the invoice (before gst or vat etc) then the “sales clearing account” should always tally zero once the invoice has been paid and reconciled.
So this is possible in xero - just ask your accountant about manual journals in xero on how to achieve this if you don’t use these already (they are an advanced accountant feature, but straight forward once you’ve made your first invoice in this fashion).
-
Luisa Magao
commented
We have manufacturing components as part of our sale products and it would be helpful to get a full idea of the costs involved for the full job. At present we have to keep a separate system to do this. We are having to double handle everything which is not cost effective at all. In Myob you have this function. Can't believe I'm saying this but it is one of my regrets in moving over to Xero.
-
Danielle Susanne Hooper
commented
is this feature addition in the technical development queue yet?
-
Liz Peter
commented
Agree with all the other comments.
This appears to be something Xero users have been screaming out for, for years with requests dotted all through the Community posts.
Xero came out all guns blazing in the beginning, but sadly it's fallen into the pattern of so many other software packages ... all about revenue, no customer service and not listening to important feedback from users.
Oh well, leaves a gap in the market for some new techy software to steal the limelight!
-
Hilton Johnson
commented
That's a pity xero has been a leader in the past now it's in catch up mode. So sad that you don't listen to your subscribers
-
Steve Quinn
commented
Thats a shame because Quickbooks can do this. It's so important that to us we are looking to move. If this is critical for your business, I would advise moving to QuickBooks.
-
Trina grant
commented
every invoice we write needs to not show our cost items and just our task items but have the reporting ability at the end of a job..