Migrate to QuickBooks Online V2 integration

Overview

Cin7 Omni has released a new QuickBooks Online integration with improved performance, an enhanced interface, and exclusive new features.

If you’re using the original QuickBooks Online integration (V1), you must migrate to the latest QuickBooks Online integration (V2). Support for the original integration has been discontinued.

Use this guide to set up and begin using your QuickBooks Online V2 integration. You must use a QuickBooks Online primary or company admin user to complete this migration. Then find out about new features. There are no additional costs for using the latest integration.

1. Install QuickBooks Online V2

If your QuickBooks Online V2 integration hasn’t been installed for you, install it from the App Store:

Log in to Cin7 Omni as an administrator.
From the navigation, open the App Store.
Open the Accounting tab.
Select QuickBooks Online.
Select Request App Installation.
Select Install.

Cin7 Omni customer success will notify you once they’ve approved your request. Then find your QuickBooks Online V2 integration in the Accounting menu in the navigation and continue setting it up.

2. Disconnect QuickBooks Online V1

From the Accounting menu in the navigation, open your QuickBooks Online V1 integration.
Select Setup to open the settings.
Open the Connect tab.
Select Disconnect.

3. Connect QuickBooks Online V2

From the Accounting menu in the navigation, open your QuickBooks Online V2 integration.
Open Settings (the cog icon).
Open the Connect tab.
Select Connect to QuickBooks. You’ll be asked to log in to QuickBooks Online – you must log in as a QuickBooks Online primary or company admin user. Follow the on-screen instructions. Then, you’ll be sent back to Cin7 Omni.

To confirm you’ve connected your integration, select Dashboard and look for the Connected icon in the top-right corner of the dashboard.

4. Configure QuickBooks Online V2

4(1). Copy your accounts setup

You have two types of accounts in your QuickBooks Online V1 integration:

Deposit accounts (if Manage Deposits is enabled)
List ledger accounts

And Cin7 Omni can copy your accounts setup, along with each account’s default tax rate, to your QuickBooks Online V2 integration:

From the Accounting menu in the navigation, open your QuickBooks Online V2 integration.
Open Settings (the cog icon).
Open the Settings tab.
Select Copy default accounts from my legacy module. Wait for the page to refresh.
Select Save Settings.

Now, in your QuickBooks Online V2 integration settings, your deposit accounts (if any) are listed under Manage Deposits and your list ledger accounts are listed under Default Accounts, along with their default tax rates.

We suggest comparing your V1 and V2 accounts setups to confirm they’re the same. If the V2 setup doesn’t match the V1 setup, match it manually and select Save Settings.

If you receive an error when copying your accounts setup, confirm in your V1 integration settings that the sales deposit account’s type is current liability and that the purchase deposit account’s type is current asset.

If you’re in Australia and collect wine equalisation tax (WET), finish setting up your new QuickBooks Online integration and then contact Cin7 Omni support to enable WET.

4(2). Configure the remaining settings

Finally, under General Settings in your QuickBooks Online V2 integration settings, configure the remaining settings and then select Save Settings:

QuickBooks Online V2 setting	How to configure it
Is multi-currency	Set this to the same value used for Is multi-currency in your V1 integration.
Is mainly B2B	Set this to the same value used for Is mainly B2B in your V1 integration.
Update transactions for number of past months	Set this to the same value used for Update COGS for number of past months in your V1 integration. This setting now affects all transactions. No transaction, whether invoice, credit note, or manual journal, will sync with QuickBooks Online if it was invoiced before this date.

5. Use QuickBooks Online V2

Now you’ve set up your QuickBooks Online V2 integration. You can perform the same tasks as before and (optionally) configure some new features:

Link contacts
Sync transactions
Sync adjustments and COGS
Download taxes, classes, locations, accounts, balances, and payments
Fix errors
Feature comparison

Link contacts

On the QuickBooks Online V1 dashboard, you selected Import and Update Contacts and Import and Update Vendors to link new contacts to QuickBooks Online and update linked contacts. You selected Choose to review which contacts would be linked and updated.

Now, on the QuickBooks Online V2 integration dashboard, your customers are listed on the Sales > Customers tab and your new vendors on the Purchases > Suppliers tab. To link your new contacts or update linked contacts, select them (individually or in bulk) and then select Upload.

Find out more about how to link contacts.

Sync transactions

On the QuickBooks Online V1 dashboard, you selected Import Orders, Import Purchase Orders, Import Customer Credit Memos, and Import Vendor Credits to sync transactions to QuickBooks Online. You selected Choose to review which transactions would sync.

Now, on the QuickBooks Online V2 dashboard, your transactions are listed on separate tabs:

Sales > Invoices
Sales > Credit Notes
Purchases > Supplier Invoices
Purchases > Supplier Credit Notes

And to sync your transactions, select them (individually or in bulk) and then select Upload.

As with your V1 integration, you must still link new Cin7 Omni contacts to QuickBooks Online before uploading their transactions. To link contacts, see above.

Sync adjustments and COGS

On the QuickBooks Online V1 dashboard, you selected Import Stock Adjustments and Import COGS to sync adjustments and cost of goods sold (COGS) transactions to QuickBooks Online. You selected Choose to review which transactions would sync.

Now, on the QuickBooks Online V2 integration dashboard, your adjustments and COGS are listed on the Adjustments & COGS tab. To sync adjustments, select them (individually or in bulk) and then select Upload. To sync COGS, select Update.

Find out more about how to sync adjustments and how to sync COGS.

Download taxes, classes, locations, accounts, balances, and payments

Every time you open your QuickBooks Online V2 integration dashboard, Cin7 Omni automatically downloads your classes, locations, sales taxes, purchase taxes, your chart of accounts, customers’ open balances, and payments towards invoices from QuickBooks Online.

Find out more about how to download data.

Fix errors

The QuickBooks Online V2 integration has a special tab that lists transactions and contacts that fail to sync. The Errors tab has a subtab for each type of transaction (except COGS) and contact, too.

If a transaction or contact fails to sync, you must fix the error and reset the transaction or contact before attempting to sync it again.

Find out more about how to fix errors.

Feature comparison

Feature	V1	V2
Cin7 Guides	No	Yes
Unlink CRM contacts	No	Yes
Sync additional (landing) costs as journal entries – find out how in Cin7 Help Center	No	Yes
Use custom additional (landing) cost accounts	No	Yes
Track sales and purchase order discrepancies	No	Yes
Control how many past months’ transactions sync	No	Yes
Visible lock date (closing date)	No	Yes
Warnings for transactions that won’t sync, such as those from historical financial periods	No	Yes
User-friendly error messages	No	Yes
Transaction-specific pages of errors, and links to Cin7 Help Center troubleshooting articles	No	Yes
Sync multiple types of transactions at once	No	Yes
Download locations	Yes	Yes
Dropdown lists of chart of accounts	No	Yes
Sync store credit and gift voucher transactions	No	Yes
Overview of synced tax rates, chart of accounts, and locations	No	Yes
Sync transactions from specific branches only	No	Yes

Find out more about configuring your QuickBooks Online V2 integration.

FAQs

Are there additional costs or system requirements for using the V2 integration?

No, there are no additional costs for using the latest integration and no additional system requirements?

Do I lose any functionality with the V2 integration?

No, the V2 integration has the same functionality as V1 – as well as new features (see above).

However, to reduce the risk of transactions from historical financial periods being synced and causing errors, the V2 integration dashboard only syncs transactions from within the last 13 months.

Find out more about your QuickBooks Online closing date.

Do I need to disconnect my V1 integration before migrating?

Yes, disconnect your V1 integration before installing, connecting, and configuring your V2 integration.

Do I need to resync any transactions after migrating?

No, you don’t need to resync any transactions. Migrating to the V2 integration won’t affect past transactions.

Does the V2 integration know which transaction I last synced via the V1 integration?

Yes, the V2 integration knows which transactions you’ve already synced to QuickBooks Online. You’ll only see new, unsynced transactions on your V2 integration dashboard.

I have unsynced transactions on my V1 integration dashboard. Do I need to sync these before migrating?

No, you don’t have to sync any transactions before migrating. Any unsynced transactions can be synced with QuickBooks Online via your V2 integration.

I’ve migrated and can’t see how to sync payment portal payments via the V2 integration dashboard. How do I sync payments towards invoices?

Payment portal payments are automatically synced to QuickBooks Online when you open your V2 integration dashboard.

How do I download my tax rates from QuickBooks Online?

Your QuickBooks Online tax rates are automatically downloaded when you open your V2 integration dashboard.

Where can I see my synced tax rates, alternative general ledger (GL) accounts, and locations?

To see your tax rate, open the Admin > Tax Rates tab. To see your alternative GL accounts and locations, open the Admin > Accounts tab.