1. Home
  2. Accounting
  3. Configuring your QuickBooks Online Integration

Configuring your QuickBooks Online Integration

Setup required in QuickBooks Online

In order to setup the integration in Primaseller, you need to configure both your QuickBooks Online Account first with the following:

1.Enable Classes

Click on Settings(On the top right) >> Account & Settings >> Advanced >> Categories

Settings Navigation in Quickbooks Please note that the navigation given below of QuickBooks applies to the US version. If you are from Canada, EU or India, the navigation might be slightly different or under different sections under settings. However, the fields themselves, like “Enable/Track Classes” will exist – hence you may have to explore the settings screens to hunt them down.

  • Track Classes – On  (Select the sub-option that says One to entire transaction )
  • Track Locations – On 

2. Sales Fields enablement

Click on Settings >> Account & Settings >> Sales >> Sales form content

  1. Discount – ON
  2. Shipping – ON
  3. Custom Transaction No’s – ON
  4. Click on Save

3. Products & Services 

Click on Settings >> Account & Settings >>  Sales >> Product and services

Track inventory quantity on hand– ON

Track quantity and price/rate – ON

Does your QuickBooks plan support Inventory? Please ensure that your QuickBooks plan supports the creation of inventory items. In most regions, it is the QuickBooks Plus plan.

4. Purchase Settings

Settings >> Account & Settings >> Expenses

  • Track expenses & items by customer – On
  • Use purchase orders – On

5. Enable Tax on QuickBooks:

  • Go to tax menu on the left
  • Click on Setup Tax
  • Fill in the business address and click on next
  • Provide more details about your tax.
  • It is preferable that the Tax class names are the same on QuickBooks Online & Primaseller. However, even if it is different, you can map it in the configurations.

Initial Setup Required in Primaseller

Before configuring your QuickBooks Online account, please ensure your invoice number sequence being generated in Primaseller does not conflict with any existing invoices in QuickBooks or invoices that you may create in QuickBooks manually.

You can configure invoice number sequences in Primaseller from:

Settings-> Invoice Sequencing

Configuring your QuickBooks Account in Primaseller

1. Connection

  1. Navigate to Accounting from the left main-menu.
  2. Click on Add New Accounting Software button and select QuickBooks
  3. Click on the Connect to QuickBooks button
  4. Click on the Connect to QuickBooks button
  5. You will be asked to enter your QuickBooks Online account credentials
  6. You will then be asked to give Primaseller permission to manage the transfer of data
  7. Click on Next

2. Sync Config

In the Sync Config screen, you will be asked to choose what items you want to sync in Primaseller.

3. Map Accounts

In this screen, you will need to map QuickBooks Accounts to entries which will be created from Primaseller.

We recommend that you use the QuickBooks accounts that we have selected in the above image for your integration as well – this ensures the right entries in standard accounts.

Unable to find the recommended Accounts in your QuickBooks Account? Some above-recommended accounts do not come by default with a new QuickBooks account. They get created during transactions.

If your QuickBooks Online plan (Only Plus and Advanced plans on QuickBooks Online) supports inventory and you have enabled “Track Inventory Quantity on Hand” from your settings, the following accounts should be there already:

Sale of Product Income
– Cost of Goods Sold or Cost of Sales

– Inventory Asset or Stock Asset – if not available upfront, check your subscription Plan. It should be Plus or Advanced. Next, in Account Settings -> Sales -> Enable the option “Track Inventory on Hand” -> Save

– Creating your first invoice without a Payment will auto-create the A/R Account Receivable or Debtors account.

– Creating your first Purchase Order will auto-create the A/P Account Payable or Creditors account.

However, we are not Licensed Tax and Accounting experts and we recommend you speak with your CPA/CA about it.

4. Map Payments

When Primaseller creates Payments, it will need Accounts that will be linked to the corresponding Payment Methods. Please map them accordingly.

5. Map Taxes

Please map Tax Classes in Primaseller to Tax Codes in QuickBooks.

Have you added Tax Rules?

To ensure taxes are set automatically on your Invoices in Primaseller, please set up Tax Rules based on product category and location – learn more from this link.

6. Map Core Objects

Kindly select Map Facilities, Map Suppliers and Map sales channels.

  1. Using the below button, you can push your entire catalog in Primaseller to Quickbooks.
  2. Products are also pushed as and when new invoices / Purchase orders are created and if the products don’t exist
  3. However, Primaseller cannot fetch Products from Quickbooks. This is because Quickbooks does not have a set way to define SKU codes and hence the catalog will not be something you can use to sync online channels.
  4. Naming convention of Products created in Quickbooks from Primaseller is Name = SKUCode:SKUName, Quickbooks ProductName = PrimasellerSKUCode:PrimasellerSKUName

7. Pust Catalog

Click on Push product catalog to push data the product catalog to Quick books.

8. Sync

This is the final step to sync Quickbooks with Primaseller. You can select the date as per your requirement and click on Initiate Sync.

Updated on October 19, 2020

Was this article helpful?

Related Articles

Leave a Comment