Managing the push of products to your QuickBooks Online

• Handling the integration of the products
• Product configuration options
• How can I assign different income accounts to different products?

Handling products integration

When integrating with QuickBooks Connector, transactions synchronization depends on products as you cannot synchronize transactions without specifying the product line items. There are two ways product data integration can be handled.

You can either manually add all items from the source system (eCommerce) to your QuickBooks Online, or you can configure QuickBooks Connector to automatically create the items for you if they don't exist.

Manual entry affords you greater control over how your data is entered into your QuickBooks Online, meanwhile, the automation is more convenient, however, all items will be created with the same set of default settings.

Item Push Options

Here is the configuration screen for the push of products to QuickBooks Online

Please note, if you want different products to have different income/expense accounts, then this will all have to be set up within your QuickBooks Online after the items are created by the app.

Here is a quick explanation of each of these options:

A) Non-Inventoried Items / Inventoried Items - If you do not intend to track inventory within your QuickBooks Online, then you can specify the app to create items as Non-Inventoried Items within your QuickBooks Online. Alternatively, if you do want to track stock levels within your QuickBooks Online, you can select the Inventoried Items option.

Please Note: If you choose to have products created as Inventoried Items, you will need to go into your QuickBooks Online and manually set up the initial stock levels for each item.

B) Income Account / Expense Account / COGS Account / Inventory Asset Account - These are all basic accounts that your QuickBooks Online requires when creating a new item. If you are unsure of which accounts to use, please ask your accountant.

Please Note: QuickBooks Connector can only assign the COGS account for the products upon creation BUT we will not sync the COGS price of products.

C) Inventory Starting Date - If you wish to track inventory within your QuickBooks Online, you will also be required to specify a starting date for when inventory starts. Please make sure you specify a historical date so that historical sales can be generated against items created by the integration.

E.g. If you are looking to integrate sales from 1st February, then you should set an Inventory Starting date that's dated 31st January, or earlier.

If you're not sure what accounts to configure, please speak to your Bookkeeper as they'll know your business's accounting practices best.

All variants will be treated as an individual items, we recommend that each variant have unique SKUs and names. 

How can I assign different accounts to specific products?

If you want different income/expense accounts for different products, then this has to be done within your QuickBooks Online.

QuickBooks Connector will not override account settings for any product in your QuickBooks Online. The options available for you to select in the configuration settings are simple so we can add new products.

If you have a product that already exists in your accounting system, QuickBooks Connector will simply match up with the product and respect the configured income/expense accounts.

If we push a product to your QuickBooks Online, then you edit the product and change a configured account, we won't override the change.