QuickBooks Connect Wizard
Cin7 Core can be used either as a standalone accounting system or integrated with either QuickBooks Online or Xero. If you are already using either QuickBooks or Xero, Connect Wizard allows easy integration of these systems with Cin7 Core.
Note: This article covers the QuickBooks Connect Wizard only. For more information on the Xero Connect Wizard, see Xero Connect Wizard.
Users will need the Integration: Accounting - QuickBooks permission in order to connect to QuickBooks Online.
Cin7 Core supports integrating with:
QuickBooks Online Plus or Advanced
Cin7 Core DOES NOT support integrating with:
QuickBooks Desktop
QuickBooks Simple Start
Cin7 Core DOES NOT recommend integrating with:
QuickBooks Essentials - Cin7 Core can connect to QuickBooks Essentials however some features may not work correctly
Prerequisites
Cin7 Core base currency must be the same as QuickBooks Online currency.
QuickBooks Online Plus or Advanced account
Set up required accounts in QuickBooks Online
Setting up Accounts in QuickBooks Online
The chart of accounts is the list of all accounts your organisation has available to record your transactions and is important for classifying your transactions correctly and keeping your accounts accurate.
Note: You will need a QuickBooks Online PLUS or ADVANCED account to correctly integrate with Cin7 Core.
Before starting your integration, there are some financial accounts that must be created in QuickBooks Online first. In the table below we have provided the recommend account type settings to use. You can add more accounts or make changes to suit your business requirements – if you are unsure, consult with your accountant or bookkeeper before adding or editing any accounts.
Note: When integrating with QuickBooks Online, you must create/manage your accounts from QuickBooks Online. They will then be imported into Cin7 Core when you next synchronise your accounts. You can view your Chart of Accounts in Cin7 Core by going to Settings → Reference Books → Financial → Chart of Accounts, but it will be read-only.
The accounts needed for Cin7 Core to function correctly are listed below with their required settings.
Already created by QuickBooks Online:
Sales Tax (GST, VAT)
Sales/Revenue
Inventory/Inventory Control.
Accounts Receivable (A/R)
Accounts Payable (A/P)
Required accounts
You may not be asked to map all of these accounts when connecting to QuickBooks Online for the first time. However, since they allow you to fully use Cin7 Core features, you should create these accounts in QuickBooks Online now.
Account |
Account Type |
Detail Type |
Accounts Receivable (A/R) |
Accounts receivable |
N/A |
Accounts Payable (A/P) |
Accounts payable |
N/A |
Inventory Discrepancy |
Expense |
Supplies and materials |
Cost of Goods Sold |
Cost of Sales |
Supplies and materials |
Work in Progress |
Current assets |
Inventory |
In-transit |
Current assets |
Other current assets |
Supplier Deposits |
Current assets |
Other current assets |
Customer Credits |
Current liability |
Current liabilities |
Optional Accounts
Account |
Account Type |
Detail Type |
Inventory Accrual (Goods Received, Not Invoiced) |
Current Assets |
Other current assets |
Stock in Transit (Goods Invoiced, Not Received) |
Current Assets |
Other current assets |
Realized Currency Gains | Expense | Exchange Gain or Loss |
Unrealized Currency Gains | Expense | Unrealized Currency Gains |
Payment Clearing | Bank | Clearing |
Current Year Profits | Equity | Retained Earnings |
Inventory Accrual/Stock in Transit requires Inventory Accrual to be enabled. Realized Currency Gains and Payment Clearing are required for consolidation of QuickBooks Online transactions. Realized Currency Gains is required for multiple currencies, too.
Account |
Account Type |
Detail Type |
Gift Card Liability |
Credit Card |
Credit Card |
Gift Card Liability requires Gift Cards to be enabled.
Creating accounts in QuickBooks Online:
In QuickBooks Online, navigate to Settings → Your Company → Chart of Accounts. The Chart of Accounts will be loaded based on the industry that you specified when initially setting up QuickBooks Online and you may find that some of the accounts may already be present. Make sure there is an account for each of the ones listed above and that they have the correct settings. You may also create any other accounts required for your business needs.
Select New. Enter the account details according to the required settings above, then click Save and Close to finish (or Save and New if you want to add another account straight away).
Once you have added all the relevant accounts, you're ready to begin the integration with Cin7 Core.
Revenue account mapping
All products and services in QuickBooks Online must have an account to which they are mapped. This mapping will always override the revenue account mapping in Cin7 Core. Unfortunately there is no way to override this from Cin7 Core. Please note:
Customer-level revenue account mapping in Cin7 Core will be overridden by the product-level mapping in QuickBooks.
Product level revenue account mapping in Cin7 Core will be overridden by the QuickBooks account mapping.
Revenue account mapping for eCommerce integrations in Cin7 Core will also be overridden by the QuickBooks account mapping.
Using the QuickBooks Connect Wizard
The QuickBooks Connect Wizard provides easy-to-follow steps for connecting QuickBooks with Cin7 Core.
On the Cin7 Core menu, click Integration → QuickBooks.
On the QuickBooks Online Integration page, the details of the integration status and the flow of data between Cin7 Core and QuickBooks Online are displayed. Click Connect or Reconnect to enable QuickBooks integration.
While the mapping is ongoing, your Cin7 Core account will be locked and all users, including you, as the master user, will not be able to access Cin7 Core. After the migration is done, Cin7 Core will send you an email that will contain a link to the page in Cin7 Core where you can export historical data to QuickBooks Online. If any error happens during the migration, the email will contain information about the error, and you will be asked to contact Cin7 Core Customer Support.
Select integration mode
There are two integration modes available. With From QuickBooks only, you can try out using Cin7 Core with your QuickBooks data, without changing any of your data in QuickBooks. Selecting Both ways enables synchronisation in both directions, which will cause some irreversible changes in your QuickBooks data after all of the steps of the connect wizard are completed.
Note: If you wish to select Both ways integration mode please ensure that all QuickBooks data (Customers, Suppliers, Products, Accounts, etc) is ready to synchronise with no duplicate entries.
Cin7 Core does not support quantity or inventory tracking in QuickBooks Online. If inventory tracking is turned on in QuickBooks, Cin7 Core will not sync data to QuickBooks. You can turn off inventory tracking here to continue. We also recommend turning off quantity tracking in QuickBooks unless strictly necessary.
Note: It is possible to complete the integration wizard without turning off inventory tracking, however, you will be unable to sync data and will see an error message asking you to turn off tracking in QuickBooks Online.
Keep or delete test data
On the Welcome page of the QuickBooks Connect Wizard, Cin7 Core is set to keep your pre-integration by default. You may select No and choose which data to keep or discard. Transactional data includes sales, purchases, transfers, production orders, etc. Reference books data will not be deleted. All data includes all transactional data, but also products, customers, suppliers, and opening balances - these can be selectively deleted when you select to delete transactional data. Reference books data will be deleted.
Click Continue. If you are not already logged into QuickBooks Online, you will be redirected to log in. You will then be redirected back to Cin7 Core. Click Allow Access to let Cin7 Core access your QuickBooks data.
Map accounts
Back in the QuickBooks Connect Wizard, on the Mapping page, the mapping of your QuickBooks accounts with Cin7 Core accounts is displayed.
The Connect Wizard will only map accounts between systems if they have the same settings (i.e. accept/not accept payments, whether account is asset, liability, or bank account etc.)
If you are missing an account in QuickBooks Online (you may have additional accounts created in your Cin7 Core Chart of Accounts), you can go back to QuickBooks Online and create them, then click Reload accounts from QuickBooks to continue mapping.
The system will try to match accounts wherever possible. Select QuickBooks accounts from the dropdown menus in order to match them manually. You must fully map the accounts in order to continue.
Account mappings are one-to-one. Each Cin7 Core account must be mapped to a unique QuickBooks account.
Map tax rules
Next, you will be taken to the Tax Rules Mapping screen where Cin7 Core will attempt to map your tax rules from QuickBooks Online automatically. The Connect Wizard only allows tax rule mapping between QuickBooks Online and Cin7 Core if the tax rates and Sale/Purchase properties are equal.
If Cin7 Core has tax rules that do not have an equivalent in QuickBooks, you will have to create these tax rules in QuickBooks first or make sure that your tax rules in Cin7 Core match those in your QuickBooks account. Then, click Reload tax rules from QuickBooks to continue mapping. All tax rules need to be mapped before you can continue.
Some versions of QuickBooks Online (e.g. QuickBooks Online Australia) no longer support custom tax rates. In order for the tax mappings section of the integration to go smoothly, tax rules in Cin7 Core must match the QuickBooks-created tax rules in QuickBooks Online. Check your Cin7 Core tax rules and delete/edit any that do not exactly match the QuickBooks-provided tax rules if your version of QuickBooks does not allow custom tax rates.
Map payment terms
Next, you will be asked to map your payment terms. Payment terms that have been assigned to a customer or supplier inCin7 Corewill be shown here.
IfCin7 Corehas payment terms that do not have an equivalent in QuickBooks Online, you will have to create these payment terms in QuickBooks Online first (Settings → Account and Settings → Sales → Sales form content → Invoice terms → Add New). Then, click Reload payment terms from QuickBooks to continue mapping. All payment terms need to be mapped before you can continue.
Payment term spelling in QuickBooks andCin7 Coremust match, including case sensitivity.
Import opening balances
Cin7 Core will next import and calculate opening balances for Accounts Receivable and Accounts Payable by importing all unpaid and partially paid purchase invoices and sales invoices. Partially paid and unpaid invoices will be imported even if the net Supplier/Customer balance is 0. Fully paid invoices will not be imported. Effective date for imported invoices will be the date of integration between Cin7 Core and QuickBooks.
It is possible to complete the connect wizard without importing opening balances, however you will need to manually enter them before using Cin7 Core. Please see Opening Balances for detailed instructions. Press continue to move to the next stage.
Import stock on hand
Cin7 Core will import all active products from QuickBooks Online, this will create products in Cin7 Core with the correct stock on hand. Only products with an SKU will be imported. After the import, QuickBooks Online products will be deactivated and recreated as services.
If inventory tracking has been turned off in QuickBooks Online before integration, there will be no products with stock on hand in QuickBooks to import. Products from QuickBooks will be exported to Cin7 Core as services. If you did not turn off inventory tracking while using the QuickBooks Connect Wizard, you will need to turn it off in QuickBooks Online after completing the connect wizard steps or data will not sync between the two platforms.
Note: QuickBooks does not support batch numbers or serial numbers for products. If you are using this information for your products, we recommend not importing stock on hand from QuickBooks as you will will not be able to add this information later. Instead, you will need to manually configure stock on hand from Cin7 Core after you have completed integration with QuickBooks. See Getting Started Guide - Loading Products for detailed instructions.
Stock on hand can only be imported to one location, which you can select here. If you need to place stock on hand in different Cin7 Core locations, you will need to do this manually using stock transfers after integration has been completed.
Turn off inventory tracking
Users connecting to QuickBooks Online can turn inventory tracking off when stock on hand is imported. If you did not turn off inventory tracking while using the Connect Wizard, you will need to manually turn it off from your QuickBooks Online account with the following actions.
Navigate to Settings → Your Company → Accounts and Settings, then click the Sales tab.
In Products and Services, ensure Track quantity and price/rate and Track inventory quantity on hand are turned Off.
Save your changes to finish.
Note: The inventory type products previously tracked in QuickBooks remain tracked even after tracking is turned off. To resolve the issue, delete the old products and create new products. See Replacing Products in QuickBooks Online below for more details.
Confirm integration
You will then be asked to confirm that you want the two apps to be integrated. Note that the data migration process is irreversible and that all Cin7 Core transactions will be updated with new accounts from QuickBooks. To go ahead with the operation, enter I would like to update all transactions in the box, then click Confirm to start synchronising data between Cin7 Core and QuickBooks Online.