How to add a service onto a product?

Pennine_Jim · ‎March 29, 2020

Hello Communtiy,

We sell electric bicycles.

These electric bicycles come with a 400Wh battery.

We have now started selling an upgrade feature, whereby a customer can upgrade to a 500Wh battery.

This implies we open the carton, remove the 400Wh battery, and install the 500Wh battery, ten sealing the carton.

The Electric Bicycle and the 500Wh battery are in our inventory. So is the a 400Wh battery (as we keep them for warranty etc.).

The cost to upgrade to 500Wh is $X

How do we:

a) show on the invoice a cost to upgrade so that a 500Wh battery is reduced from stock?

b) Adding a 400Wh battery to stock?

We are ramping this service up, and we dont want to use "Stock Shrinkage" if possible.

Thank you.

James

Jen_D · ‎March 29, 2020

Thanks for visiting our forum, @Pennine_Jim,

Being able to manage your inventory accurately is also our goal. While there isn't an option to reflect the cost upgrade on invoices, there are 2 options you can try. This will help QuickBooks to record the remaining quantity correctly on the Products and Services list.

First, you can manually assign each inventory (bicycle, 400Wh and 500Wh batteries) on different line items on the sales form. See this:

Second is creating a bundle for each set. Example: Set A Bicycle and 400WH Battery and Set B for the upgrade. Here 's how to do that:

Click the Gear icon and select Products and Services.
Press the New icon and choose Bundle.
Add a name or description for the bundle you want to sell.
In the Products/services included in the bundle section add the product and quantity of the set.
Hit Save and close when done.

Check out this article to learn more about inventory tracking in QBO: Set up and track your inventory in QuickBooks Online.

If you have any questions about this or need further assistance with the steps, add another comment below. I'll be right here to help you accomplish things in QuickBooks. Have a good one!

View solution in original post

Jen_D · ‎March 29, 2020

Thanks for visiting our forum, @Pennine_Jim,

Being able to manage your inventory accurately is also our goal. While there isn't an option to reflect the cost upgrade on invoices, there are 2 options you can try. This will help QuickBooks to record the remaining quantity correctly on the Products and Services list.

First, you can manually assign each inventory (bicycle, 400Wh and 500Wh batteries) on different line items on the sales form. See this:

Second is creating a bundle for each set. Example: Set A Bicycle and 400WH Battery and Set B for the upgrade. Here 's how to do that:

Click the Gear icon and select Products and Services.
Press the New icon and choose Bundle.
Add a name or description for the bundle you want to sell.
In the Products/services included in the bundle section add the product and quantity of the set.
Hit Save and close when done.

Check out this article to learn more about inventory tracking in QBO: Set up and track your inventory in QuickBooks Online.

If you have any questions about this or need further assistance with the steps, add another comment below. I'll be right here to help you accomplish things in QuickBooks. Have a good one!

john-pero · ‎March 29, 2020

Here is a thought. Inventory the bicycles sans batteries but at cost as if they had 400Wh battery included. And inventory the 400Wh batteries at zero cost and zero price. When you sell a bike you have at least 2 line items. The bike and the 400Wh battery. That keeps inventory straight going out. If you sell one with the upgraded 500Wh battery you list that at upgrade price but do not identify the. 400 at all since it is already on the shelf.

Pennine_Jim · ‎March 29, 2020

Hi John,

It's a great solution, but would incur more work than having currently, with the 400Wh batteries already being in the box and part of the bicycle.

Thanks for your input, and it is definately an option for us if our business model changes (next year we are aiming for battery production in our own country, therefore the bicycles will be seperate from the batteries anyway).

Kind regards

James

Pennine_Jim · ‎March 29, 2020

Hi Jen,

Many thanks for your reply.

This could work!

Let me have a play about around with this bundles option, hopefully we can make it work.

Many thanks!

Kind regards

James

becky_ds · ‎July 27, 2022

When you bundle products with a service-does Quickbooks still keep track inventory? I am only asking this because I read this somewhere...Note: Remember, QuickBooks won't track quantities for services, non-inventory items, and bundles.

Thanks

Topics

Training

Community

Resources

How to add a service onto a product?