Bundles Import available for QuickBooks Online

December 23, 2016

blog_images1703124253423_bundle1.png

Intuit introduced Bundles to QuickBooks Online. You can group items together to sell as a package. Bundles are available only in QuickBooks Online Essentials and QuickBooks Online Plus. You won’t find it in QuickBooks Online Simple Start.

Contents

What is “Bundle”?

What is “Bundle”?

The easiest way to understand bundle items is to consider a concrete use case. Imagine a gift basket:

  • 2 chocolate bunnies

  • 1 Bag of jelly beans

  • 1 box of marshmallow chicks

  • 1 Pez dispenser

  • 2 packages assorted Pez candy

  • 1 plush bunny

  • 1 medium basket

  • 1 package plastic grass

If I run a gift shop and my cashiers have to add each individual item and quantity into an invoice or sales receipt, there are going to be a lot of mistakes and incorrect prices. Also, I might also want to include a discount just to get some of those nasty marshmallows chicks off my shelves! Bundle items to the rescue! I can simply define a bundle item “Gift Basket” and define the items and quantities that belong to the bundle. In Invoice, It will look like

bundles import

How can it be imported using a File?

Is there any changes to your templates?   The answer is NO.  You can import Bundles as same as normal Products or Services. SO SIMPLE. You need to map the following Details to import Bundles.

Bundle Details

SAASANT MAPPING FIELDS

Country

Bundle Name

   Line Item

 ALL

Bundle Quantity

   Line Item Quantity

ALL

Bundle Tax Code

   Line Item Tax Code

 NON-US ( GLOBAL)

Taxable

  Line Item Taxable

 US

If you are new to the Field Mappings concept, please check this link to know more. SaasAnt Transactions will pull the list of products in a bundle and create the sale transactions.

Questions:

1. Is there any way to change the Bundle Item Price? It is not possible. Quickbooks does not allow to set amount for any Bundle Items. The amount will be derived from its products automatically. As you can see, we have not listed "Line Item Amount" or any amount fields in the field mapping. 2. I want to change the quantity and price of  Some products in the Bundle. Is it possible? Currently, it is not supported in our tool. It creates complexity in configuring the details in the file. 3. How do I mark tax for Bundles? If you are using U.S QuickBooks Version, you can use the "Line Item Taxable" field to mark the Bundles to Tax. If you are using CA/ AU / UK / IN QuickBooks Versions, you need to use the "Line Item Tax Code" to specify the tax code.

QuickBooks Tricks :

We always get into trouble when we realize that we need some more customization in import. Sometimes, you want to give different tax codes for each product grouped under a bundle or you want to control the taxing of each product in a bundle.  As you can see in this above table, our application does not provide an option to enter individual products for a bundle.

So how do we can solve this issue?

You can define the sale tax code for each product in QuickBooks Online You can edit your existing product or service and assign tax code. Then you can ignore the "Bundle Tax Code" or "Bundle Taxable" mappings. SaasAnt Transactions will fetch details from QuickBooks to decide the tax code.So you don't need to feed the tax code in a file.

Tags

Bundle

Import

Quickbooks Online

SaasAnt Transactions