cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Sandra5000
Level 3

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

 
Solved
Best answer February 28, 2019

Accepted Solutions
TaliaI
QuickBooks Team

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

Hello Sandra5000,

 

The only workaround I could find for this would be to override the prices of the stock items within the bundle when creating an invoice so that they add up to the £10 you would like to charge (please see image below). This would reduce the stock for each item - however I appreciate that this isn't as quick as being able to set up price for the bundle itself. Please use the Feedback option under the cog wheel to suggest this to the developers - hopefully this is something they can implement in the future.

 

Thanks,

Talia

View solution in original post

10 REPLIES 10
TaliaI
QuickBooks Team

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

Hello Sandra5000,

 

Thank you for your question!

 

The amount of the bundle should automatically calculate based on the quantity of the separate products within it - this should display next to the bundle when creating an invoice and should allow you to save without filling out an amount on each line.

 

Does QuickBooks not allow you to save this without filling out each transaction line?

 

Thank you,

 

Talia

Sandra5000
Level 3

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

Hi

 

The point is the bundle is a set price, not the sum of various components. It might be made up of 5 items. Not all of these have sales prices. However, we sell the total kit for £10. It includes a combination of stock items and non-stock consumables. I have no way of apportioning the sales value over the components. I need to find a way to record the Bundle sales price of £10, yet show the stock lines underneath so they are deducted from stock (but with no attributable sales value).

 

I am trying to find a way to record this in QBO. 

 

Any help really appreciated. If only you could enter the value of the bundle.....

TaliaI
QuickBooks Team

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

Hello Sandra5000,

 

The only workaround I could find for this would be to override the prices of the stock items within the bundle when creating an invoice so that they add up to the £10 you would like to charge (please see image below). This would reduce the stock for each item - however I appreciate that this isn't as quick as being able to set up price for the bundle itself. Please use the Feedback option under the cog wheel to suggest this to the developers - hopefully this is something they can implement in the future.

 

Thanks,

Talia

Sandra5000
Level 3

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

I know - its not ideal but thank you.

 

We create the sales receipts via an upload, which is created from our Shopify store. So its reasonably automated, so manually amending line items is not really an option.

 

I was wondering about trying to create a memo line item and use some automation to add that as an extra service type line item to record the sales value then add the bundle at nil sales price underneath - I will see if I can get that to work.

 

I will also add as a suggestion for development in the future.

 

Thanks for looking at this for me

Sandra

 

 

TaliaI
QuickBooks Team

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

Hello Sandra,

 

You're welcome. Hopefully you can get that to work in the meantime!

 

Thanks,

Talia

alex17
Level 3

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

Hi Talia,

I've just sold QBO to a new client that uses stock.  They sell items that are made from a bunch of components (which they also sell separately) and I thought that the bundle would be perfect for them.

I've had the same issue with the software as Sandra and have discovered this  workaround; I don't have a problem with the workaround.

 

My issue is this - the line on which the bundle shows on the invoice isn't displaying the VAT code or VAT amount.  It doesn't appear to be possible to edit the bundle line.  Is there any other way that the VAT treatment can be brought into this line?  

 

I've tested this on the demo company and even when separate items have sales prices and VAT codes this happens.  (copy attached).  Help!!

 

Alex

John C
QuickBooks Team

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

Hi alex17

 

Do you have VAT codes attached to each of the products you are using within the bundle?

alex17
Level 3

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

Hi John,

 

Yes I do.  Also the pdf invoice I attached came from the QBO demo data using water bottles and name badges if that helps?  They too have VAT codes against them.

 

Thanks for your time

Alex

JenoP
Moderator

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

Good day, Alex.

 

One more question, can you also tell us if every item on the bundle has a unique VAT code? VAT details will not show up in the Line item section if each of the item has its own code.

 

However, QBO will still calculate the VAT amount based on total rate assigned to each item. 

 

Check out our Getting Started guide for managing VAT in QBO. Here's the link: https://quickbooks.intuit.com/learn-support/en-uk/vat/vat-getting-started/00/239023.

 

Let me know if you need anything else. 

Uneedwat
Level 2

We sell bundles of product for a set amount say £10. I can create the bundle but have to put a sales value on each line rather than at the top level. Any thoughts?

Hi,

 

If I am not mistaken, I have the same issue. I would simply like to hide the products the bundle contains entirely, showing only the bundle and have the VAT code appear next to the bundle. There is no possibility to do that and if we check the answer from QuickBooks Team from the following link,

https://quickbooks.intuit.com/learn-support/en-uk/vat/can-you-assign-a-vat-code-to-a-product-bundle/...

Answer: "However, if you want to enter the VAT directly to the bundle, the functionality is unavailable at this time. You’ll have to enter a sales transaction to add the tax."

This does not work for the use case mentioned and QuickBooks should really look into that.

 

If we are not showing the items which make up the bundle, we should be able to see the VAT code next to the bundle.

 

Kind request to set this as a feature request and provide a timeline for the release candidate once it is approved.


Thank you.

Need to get in touch?

Contact us