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 all, appreciate the interest and rationale for wanting to be able to combine and hide line items on an invoice for sending to your clients, while having your usual detail tracked on the invoice in Xero.
While this may be a function we look to explore in the long-term we want to be upfront that this is not something we’ll be developing in the near term. Our team is focussed on other key priorities right now such as improvements to invoice branding and getting paid.
If you want to hide all line item details, you can create a custom invoice theme where you can decide which data fields appear on the PDF invoice. For example to print only the Subtotal and no line items.
However we’re aware that in other cases you want to be able to show some line items and not others. We’ll leave this idea open as it’s something we may be able to revisit in the longer term. We’ll be sure to let you know if there’s any change around this, here.
-
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..
-
Bob Crawford commented
Sadly Xero continue to ignore this really important request and don't even have the courtesy to make a comment
Makes this notice board forum farcical
-
Melissa Shepherdson commented
I usually have lumpsum item lines that are handled by 2 different departments so I will require my line items to be split accordingly without needing to show my client the details.
-
Opo Drainlayers commented
We use a summary line quote which is then made into an invoice.
We track our inventory, so when the customer has paid we have to go back in and put all the stock in to take this out of inventory.
This is very time consuming and should be able to be noted in the quote and then taken out of the inventory when the invoice is created, including adding billable items (not showing to the customer) so that the customer still gets the one liner and we have our stock taken out at the time.
The only problem I see is that the stock would need to go out at zero dollars therefore making our average price null and void, but still better than nothing.
Please help, I am getting desperate, 4 months in to my new job. -
Hellie Kellett-Clarke commented
This feature would make a huge difference to the manual workarounds our team are doing as we similar sell bundled services that we breakdown for cost and revenue internally but only charge the customer as a single fee.
-
Julia Rickards commented
I have clients, and I assume this would be standard practice in the industry, they have dockets for delivery of products, and get invoiced for several dockets at a time. Client has always subtotalled as this was a feature in Reckon and MYOB. I have tried to come up with a work around using the price column and zero quantity but doesn't look good. I have seen so many posts in the Xero community where this is a wanted feature.
-
Hilton Johnson commented
Well raised Amanda, this will be an excellent tracking tool, Xero if so many users over so many years have requested this feature -what seem to be the problem? Can you please give us all some feedback, or are we asking too much?
-
Bob Crawford commented
Sad to say Amanda that despite multiple requests over YEARS for this solution to be integrated into the Xero product the powers that be at Xero simply ignore us all
Moreover they don't even acknowledge our request which makes a total mockery of this ideas board
-
Amanda Roothman commented
Good morning, Xero agent. Could you please help me with my problem? I'm trying to create invoices for my clients with a single line item, but I want to divide that one line into multiple "consultant" categories. How can I split a single line into separate "consultants"? I have included a screenshot to show you how I would like to split the invoices, while still displaying a single line item to the clients in the actual invoice.
Is there no solution for this yet? - I see that this need has already arose in 2012? See the file attachments of the actual problem at hand. -
David Pugh commented
This would be super useful to our clients.
-
Leanne Murch commented
We have invoices that needs to be tracked by staff member on separate lines, but we do not want the customer to have visibility of this split and need the invoice to "Print" with just one line.
-
Leanne Murch commented
This feature would be so useful - need to track line items separately, but do not want customer to see each line on their invoice
-
Laura Gum commented
Very very important to improve tracking and reporting where an item needs to be split accross multiple areas.
-
Jon Baggot commented
This is applicable to us and some of our customers. As a service organisation, for internal tracking we want to split our charges between various income streams (by nominal account code) but don't want the customer seeing this as they pay an all inclusive fee.
A simple company setting to group all line items with 'customer default' over-ride would be perfect. As mentioned already, seems very simple.
If Xero want to improve their options for management reporting, this is a must. -
Jan Campbell commented
This ability would be very useful - for example a client wanting to note several cost centres by tracking code for management reporting, however the client is happy with a total figure on his invoice.
-
Zara Butter commented
@Wendy Tetley - that sounds like a great work around, but I can't seem to follow your instructions when I download the Xero Docx files. Would you be able to upload the template you use? (minus your company info of course!) TIA
-
Bob Crawford commented
This point has been raised for years by numerous customers but Xero continue to ignore our request
They don't even have the courtesy to acknowledge our business needs.
Xero Customer service is actually a shambles being non-existent
-
Eloise Davis commented
This is so incredibly necessary! Can it be done?! We need to be able to track inventory behind the scenes but the customer does not need to see every line item! There is a huge need for this!
-
Wendy Tetley commented
I have the exact same issue right now - My client owns an art gallery; Produces invoices to her customer that buy the art but wishes to 'hide' the cut that the artist gets, the cut she gets and the framing fee.
I found a small work around that doesn't help me as much as it might help others.
You CAN hide information from the invoice but it does hide EVERYTHING under that bracket.
Here's how:
Download the Xero Doc.X custom invoice template
Highlight «TableStart:LineItem»«Description»
Right click
Select Toggle field codes
Highlight "{ MERGEFIELD TableStart:LineItem \* MERGEFORMAT }{ MERGEFIELD ItemCode \f ", " \* MERGEFORMAT }"
Right click
Select Font...
Under effects tick the "Hidden" box
Select Ok
Highlight "{ MERGEFIELD Description \* MERGEFORMAT }"
Right click
Select Toggle field codes
Save
...................................................................
You can apply this to any box and it will hide that information! Hope it helps some people until Xero fix this super simple issue!!
-
Bob Crawford commented
Xero's message board here is farcical. This idea continues to be raised here as it has for years - and is massively important to many businesses including mine yet they choose to do absolutely nothing and don't even tell us this improvement is going to be implemented
What a complete joke