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?
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.....
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.
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
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!!
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.