To set up your accounting integration, please submit a ticket to Support and they will lend a helping hand.
Or if you sell wholesale:
Here we’ll cover:
- Prep work within your QuickBooks Online Account
- Connect QuickBooks Online to QuickBooks Commerce
- Review your Integration Setup
If you are currently using QuickBooks’ Inventory Management feature, you’ll need to change the Type associated with your products from “Inventory” to “Service.”
Doing so lets QuickBooks know that we will be the master of inventory managing the stock for these items.
If you do not make this change, updates will not be synced between QuickBooks Commerce and QuickBooks.
Step 1 of 3: Prep Work within your QuickBooks Online Account
Changing Product Type from “Inventory” to “Service”
In order for QuickBooks Commerce to become your business’ master of inventory, you will need to change the Type associated with your products from “Inventory” to “Service.” Doing so lets QuickBooks know that QuickBooks Commerce will be managing the stock for these items.
To change the Type associated with your products, please log in to your QuickBooks account and follow the steps here.
Creating your Ledger Accounts in QuickBooks
Before connecting QuickBooks to QuickBooks Commerce you will need to make sure certain ledger accounts exist in your account with QuickBooks. These accounts are necessary for us to push data into the right accounts.
To create new ledger accounts in QuickBooks, log in to QuickBooks and follow the steps here.
We recommend that for each account Category Type you fill in the field for Detail Type as well.
In the chart below are some suggestions for each category but please check with your accountant if these details best suit your business.
If these accounts (or similar) already exist in your QuickBooks account, please choose to use the accounts most suitable for your business.
|
Account Category |
Detail Type |
Remarks |
|
Income |
Sales of Product Income |
This will be your Sales account. |
|
Bank or Credit Card |
Cash on Hand/ Credit card |
This will be your Payments account.
Depending on how you wish to receive payment, select Bank or Credit Card. If you wish to receive payment in cash choose Bank> Cash on Hand.
If you choose to set up your Credit Card instead of Bank, be sure to set your currency to match your default currency on your QuickBooks Commerce account. |
|
Expenses |
Supplies & Materials |
This will be your Purchases account. |
|
Cost of Goods Sold |
Supplies & Materials |
This will be your Cost of Goods Sold account. |
|
Other Assets |
Inventory |
This will be your Stock on Hand account. |
Creating your Sales Tax
If you have not set up your Sales Tax in QuickBooks, it is vital that you do so before integrating with QuickBooks Commerce.
To create a new sales tax in QuickBooks, follow the steps here.
Step 2 of 2: Connect QuickBooks Online to QuickBooks Commerce
Now that you have your ledger accounts set up, you are ready to connect QuickBooks Online to QuickBooks Commerce.
Here we’ll cover:
- Installation & authorisation
- Connecting & mapping your account ledgers
- Setting up payment methods
- Setting up tax types
Installation & Authorisation
Go into your QuickBooks Commerce account.
Go to the App Store by clicking Browse Apps on the left sidebar.
Click Accounting from the menu, then click the 'QuickBooks Online' button.
Click the 'Install App' button.
You will be directed to an authorisation page such as the one below.
Sign in to authorize Intuit to securely share your data to QuickBooks Commerce.
Once the data has been imported you will be directed to an overview page.
Connecting & Mapping your Account Ledgers
From the dropdown menus, connect and map your QBO account ledgers to QuickBooks Commerce.
- Connect field Sales with the drop-down option labeled Income or Sales from your QBO account
- Connect the field Purchases with your Purchases Account from the dropdown options
- Connect the field for Stock on Hand to Inventory Asset
- Connect the field Cost of Goods Sold with the account for Cost of Goods Sold
Click “Next.”
Setting Up Tax Types
If you did not set up your tax types in QuickBooks Commerce in Module 2: Setting up your account, you can import them directly from your QBO account now.
Within QuickBooks, go to Tax Types.
Once you've finished setting up your Tax Types, click “Continue” and you're done.
Step 3 of 3: Review your Integration Settings
Once your installation and import has completed, you’ll want to review and test the integration.
Go to the My Apps section, click on your QuickBooks Online integration and click through the tabs to identify any alerts and resolve them. If you need any help, please submit a ticket here to contact Support.
To understand what syncs between QuickBooks Commerce and QuickBooks Online, read this.