QuickBooks to Cin7 Migration: A Step-by-Step Data Cutover Guide

As your business grows, inventory management becomes closely connected to purchasing, order fulfillment, warehouse operations, and financial reporting. Managing these processes through separate workflows can make it harder to maintain a consistent view of stock and operational performance.

Cin7 Core brings inventory management, purchasing, sales, manufacturing, and related workflows together in one system. When connected to QuickBooks Online, it can also synchronize relevant financial information with your accounting platform.

For businesses moving their inventory operations from QuickBooks to Cin7, the transition involves more than importing a list of products. Product records, supplier information, opening stock, account mappings, and outstanding transactions all need to be reviewed as part of the migration plan.

That is why a structured QuickBooks to Cin7 migration matters.

This guide explains how to assess your existing data, prepare your destination system, choose the appropriate migration method, validate opening balances, and coordinate the final cutover.

The objective is straightforward: establish reliable inventory records in Cin7 Core while preserving the financial information and business history your team needs.

In this guide

1. Define What You Are Migrating
2. Choose the Right Migration Method
3. Prepare and Export Your QuickBooks Data
4. Configure Cin7 Core Before the Migration
5. Complete the Cin7 Product Catalog Migration
6. Migrate Opening Inventory and Stock Values
7. Set Up Opening Balances and Outstanding Transactions
8. Run a Test Migration Before Cutover
9. Execute the Cutover Step by Step
10. Your QuickBooks to Cin7 Migration Checklist
11. Frequently Asked Questions

1. Define What You Are Migrating

Before moving data, establish how Cin7 Core and QuickBooks will work together after the transition.

For many small and midsize businesses, the goal is to move inventory operations into Cin7 Core while retaining QuickBooks Online as the accounting system. Cin7 then manages inventory-related purchasing, sales, and operational transactions, with relevant financial information synchronized to QuickBooks.

Other businesses may be planning a broader change to their accounting systems. That requires a different migration scope.

Start by documenting the following:

• Product catalog: SKUs, product names, variants, categories, and units of measure.
• Inventory: Opening quantities, average costs, and warehouse locations.
• Customers and suppliers: Contact information, payment terms, tax settings, and relevant account associations.
• Financial setup: Chart of accounts, account mappings, conversion date, and opening balances.
• Outstanding transactions: Unpaid or partially paid sales invoices and purchase invoices that need to be represented after cutover.
• Historical information: Previous sales, purchasing, inventory, and financial records required for reference or reporting.

Create a migration scope that identifies which records will be transferred, which will remain accessible in QuickBooks, and which will be recreated or configured in Cin7 Core.

Important compatibility check: Cin7 Core's direct accounting integration supports QuickBooks Online Plus and Advanced. This direct integration does not support QuickBooks Desktop, and some features may not work correctly with QuickBooks Online Essentials. Confirm your QuickBooks edition before choosing the migration method.

Refer to Cin7's official QuickBooks Online integration guide.

2. Choose the Right Migration Method

Cin7 Core provides a QuickBooks Connect Wizard for setting up the QuickBooks Online integration. Your choice of integration mode affects how information moves between the systems.

Option A: From QuickBooks only

This mode imports QuickBooks information into Cin7 Core without changing the information in QuickBooks.

It can suit initial setup and evaluation scenarios in which you want to bring information into Cin7 Core while keeping the source records unchanged through this wizard.

Option B: Both ways

This mode synchronizes information between Cin7 Core and QuickBooks Online.

Before selecting it, review the customer, supplier, product, account, and inventory records in both systems. Confirm the desired data ownership, account mappings, and duplicate-handling approach.

Critical cutover consideration: Cin7's documentation states that completing the Both ways mode irreversibly changes QuickBooks data. Treat this as a controlled migration decision. Secure your approved exports or backup arrangements, review the consequences with your implementation partner and accountant, and obtain business approval before completing the wizard.

The wizard also includes inventory-tracking considerations that affect synchronization. These settings should be reviewed as part of your migration plan rather than selected by default.

To begin the documented connection process, go to Integration → QuickBooks → Start QuickBooks Connect Wizard in Cin7 Core.

Review Cin7's QuickBooks Connect Wizard instructions before proceeding.

3. Prepare and Export Your QuickBooks Data

A clean source dataset makes it easier to map records correctly and reconcile the final result.

Begin by exporting the information included in your approved migration scope from QuickBooks Online.

Typical source files include:

Data category

Information to review

Products and services

Names, SKUs, item types, prices, and existing inventory records

Customers

Customer names, contacts, addresses, currencies, and payment terms

Suppliers

Supplier details, addresses, payment terms, and product relationships

Financial accounts

Chart of accounts, account types, balances, and account codes

Inventory

Quantities, item costs, and the location or warehouse associated with each item

Outstanding transactions

Unpaid and partially paid sales invoices and purchase invoices

Historical reports

Inventory valuation, trial balance, sales, purchasing, and other required reports

QuickBooks Online allows users to export reports and lists to Excel. The available fields depend on the report and export method, so review each file against the migration requirements.

See Intuit's QuickBooks Online data export guide.

Clean the data before importing it

Review each dataset for:

• Duplicate product records or SKUs.
• Inconsistent product names and units of measure.
• Missing customer or supplier details.
• Outdated product records.
• Incorrect or incomplete costs.
• Inventory quantities that require physical verification.
• Account names or codes that do not match the destination configuration.

Standardize fields according to the Cin7 Core import templates. Record the source filename, export date, record count, and responsible owner for each dataset.

This gives your migration team a clear reference point for validating the imported data.

4. Configure Cin7 Core Before the Migration

Prepare the destination system before importing business records.

Set up financial settings

Confirm the base currency, chart of accounts, tax rules, bank accounts, and account mappings.

When connecting QuickBooks Online, Cin7 requires the base currency in both systems to match. Required accounts also need to be available in QuickBooks so the connection wizard can bring the relevant accounts into Cin7 Core.

Establish the conversion date—the date your business stops relying on the old operational setup and begins using the new one—and agree on the related accounting treatment with your finance team.

Set up inventory locations

Create the warehouses and other locations required by your business.

If inventory is held across several warehouses, define how stock will be assigned to each location during migration. This is particularly important when the source system maintains only an overall quantity rather than detailed stock by warehouse.

Prepare the product structure

Confirm the required product categories, costing methods, units of measure, and product-family structure.

Cin7 Core's inventory list import requires the following fields: SKU, product name, type, category, costing method, and unit of measure. Use the current Cin7-provided CSV template to prepare your file.

Before importing: Confirm that financial settings, locations, product structures, and the migration scope are approved.

5. Complete the Cin7 Product Catalog Migration

Your product catalog supports stock management, purchasing, sales, and reporting. The migration should preserve the information your team needs to identify and manage each item.

Step 1: Map QuickBooks fields to Cin7

Create a mapping document that identifies the source field, destination field, transformation required, and validation rule.

For example:

QuickBooks source

Cin7 Core destination

Validation

Item name

Product name

Correct naming convention

SKU or item code

SKU

Unique and consistent

Item category

Product category

Valid destination category

Purchase cost

Relevant product cost field

Agreed costing treatment

Unit of measure

Unit of measure

Matches the business process

Product description

Product description

Required information preserved

The exact mapping depends on your source records and Cin7's current import template.

Step 2: Import the inventory list

Use Cin7 Core's inventory-list CSV template to create or update product records.

Keep the template's column headings and order unchanged, then populate the required fields and upload the completed file.

Cin7 Core supports inventory-list imports of up to 5,000 lines per import, according to its current product setup documentation. Larger catalogs can be divided into controlled batches.

See Cin7's guide to creating products and services.

Step 3: Verify the results

After importing, compare the source and destination datasets.

Check total records, unique SKUs, product types, variants, costs, and other fields included in the agreed scope. Resolve exceptions before moving on to opening stock.

A validated catalog provides the foundation for an accurate inventory migration.

6. Migrate Opening Inventory and Stock Values

The opening inventory establishes the quantities and values your business will use when it begins operating in Cin7 Core.

This stage deserves particular attention because inventory information affects purchasing, sales, warehouse operations, and financial reporting.

Prepare the opening stock file

Cin7 Core's stock-on-hand import uses fields including:

• Product code.
• Quantity.
• Average cost.
• Location.
• Received date.

Export the Cin7 stock-on-hand template, populate the approved opening quantities, and confirm that each product is associated with the correct location and cost.

Reconcile stock before importing

Compare your approved stock records with physical inventory counts or the source records accepted by your business.

For each relevant SKU, validate the quantity and average cost. Where inventory is stored across several warehouses, prepare the appropriate location-level quantities.

Cin7 Core's QuickBooks integration documentation states that its QuickBooks stock-on-hand import supports one selected location. It also notes that QuickBooks does not support batch or serial numbers for products. Businesses with multiple locations or batch-tracked and serial-tracked inventory should plan the opening inventory setup accordingly, using a controlled Core stock-on-hand import and location transfers where appropriate.

If stock-on-hand information is imported through the QuickBooks wizard, follow Cin7's documented inventory-tracking prerequisites carefully. Your partner should confirm the chosen method against your actual data structure before the cutover.

Import and verify

Upload the opening stock file through Inventory → Products → Import → Stock on Hand.

Cin7 recommends using this process to establish stock when setting up the system for the first time. Subsequent quantity changes should be handled through stock adjustments or stocktakes.

After importing, compare the resulting quantity and inventory value with the approved opening records.

Use Cin7's official stock-on-hand instructions as the reference for the current import process.

7. Set Up Opening Balances and Outstanding Transactions

An inventory migration and an accounting conversion are related activities, but they serve different purposes.

Opening balances establish the financial position at the conversion date. These may include bank accounts, accounts receivable, accounts payable, inventory, and other relevant accounts, depending on the implementation model.

Agree on the financial treatment with your accountant or bookkeeper before importing balances or enabling synchronization.

Review the chart of accounts

Verify the account names and codes, inventory and cost-of-goods-sold mappings, and the accounts required by the integration.

Confirm that the mapping supports the way your business records purchases, sales, inventory movements, and related financial transactions.

Review accounts receivable and payable

Identify outstanding customer invoices and supplier bills that need to be represented after the cutover.

Cin7's QuickBooks Online integration documentation explains that its opening-balance import can bring across unpaid and partially paid sales and purchase invoices. Fully paid invoices are excluded from this opening-balance import, and the imported invoices use the integration date as their effective date.

This makes it important to establish how historical transactions and outstanding balances will be handled before beginning the integration.

Cin7 also states that the opening-balance import cannot simply be repeated after it has been completed once. Review the proposed balances and the consequences of the selected migration route carefully.

Reconcile the final balances

Use an agreed conversion date and compare the relevant source reports with the destination balances.

For a connected Cin7 Core and QuickBooks Online setup, confirm how the two systems will represent inventory value, accounts receivable, accounts payable, and the financial transactions created after launch.

This review helps your finance team establish a clear starting point for ongoing reconciliation.

See Cin7's opening-balance conversion guide.

8. Run a Test Migration Before Cutover

A test migration gives your team an opportunity to validate the data and the business processes before the production transition.

Use a representative selection of products, customers, suppliers, inventory records, and financial transactions.

Your test plan should cover the following:

Test area

What to verify

Product catalog

Record counts, SKUs, product types, and required fields

Inventory

Quantities, average costs, location assignments, and stock valuation

Customers and suppliers

Contact details, payment terms, and relevant account associations

Opening balances

Account mappings and approved balance totals

Outstanding transactions

Correct treatment of unpaid and partially paid invoices and bills

Operational workflows

Purchase receipt, sales order, stock adjustment, and fulfillment where applicable

Accounting integration

Correct account mapping and expected synchronization behavior

Record the test results, assign owners to any corrections, and repeat the relevant tests after changes.

Use the test to agree on measurable acceptance criteria, including the inventory totals, records, and financial balances that must match the approved source information.

Once the business owners approve the results, finalize the production cutover plan.

9. Execute the Cutover Step by Step

The cutover is the coordinated transition from the old operational process to Cin7 Core.

A documented schedule helps every team understand when data is finalized, when imports occur, and when the new workflow becomes the operational source of truth.

Before cutover

Confirm the approved scope, migration files, mapping documents, user access, test results, and conversion date.

Agree on when the team will stop making routine changes in the source inventory workflow. Identify any orders, receipts, invoices, or stock movements that need special handling during the transition.

At cutover

1. Take the final approved exports or snapshots of the required source data.
2. Reconcile inventory quantities and outstanding transactions against the agreed cutover point.
3. Complete the approved product, inventory, customer, supplier, and financial data.
4. Complete the QuickBooks Connect Wizard configuration, if included in the plan.
5. Verify the integration status and confirm which system owns each data type.
6. Check opening quantities, inventory values, outstanding balances, and key account mappings.

After cutover

Process controlled test transactions through the intended business workflows.

Confirm that inventory updates, purchasing, sales, and relevant accounting transactions appear where expected. Record any differences, assign an owner, and verify the correction.

Once the checks pass, communicate the changeover to employees and begin routine operations in the new system.

10. Your QuickBooks to Cin7 Migration Checklist

Use this checklist to coordinate the project and confirm readiness.

• Migration scope and conversion date approved.
• QuickBooks edition and integration compatibility confirmed.
• Source data exported and retained.
• Products, customers, suppliers, and account records reviewed.
• SKU and field-mapping rules documented.
• Cin7 Core financial settings and warehouse locations configured.
• Product catalog imported and validated.
• Opening inventory reconciled and imported.
• Batch, serial, and multi-location requirements addressed.
• Opening balances and outstanding transactions reviewed.
• QuickBooks integration mode and synchronization rules approved.
• Test migration completed and accepted.
• Cutover responsibilities and timing documented.
• Post-cutover inventory and financial reconciliation completed.
• Team training and post-launch support arranged.

The checklist creates a shared view of project readiness for operations, finance, warehouse, and technical teams.

Frequently Asked Questions

1. How do I migrate from QuickBooks to Cin7 Core?

Start by defining the migration scope, reviewing the QuickBooks edition, and preparing your product, inventory, customer, supplier, and financial records. Configure Cin7 Core, map and import the required information, reconcile opening stock and balances, test workflows, and execute a documented cutover.

2. Can I keep QuickBooks Online after migrating inventory to Cin7?

Yes. Many businesses use Cin7 Core for inventory management and operational transactions while retaining QuickBooks Online for accounting through the supported integration. The setup and account mappings should reflect the agreed responsibilities of each system.

3. Does Cin7 migrate the entire QuickBooks transaction history?

The available data depends on the migration method and selected scope. Cin7's opening-balance process can import unpaid and partially paid invoices and bills, while fully paid invoices are excluded from that process. Agree on how historical transactions and reports will remain accessible before cutover.

4. Can Cin7 import opening inventory from QuickBooks?

Cin7's QuickBooks integration wizard supports importing stock on hand for eligible active QuickBooks products with SKUs, subject to its documented prerequisites. Opening stock can also be established through Cin7 Core's stock-on-hand import. The correct method depends on location requirements, product tracking, and the approved migration design.

5. How are Cin7 opening balances migrated?

First, configure the chart of accounts, account mappings, and relevant financial settings. Establish a conversion date, agree on the trial balance and outstanding transactions with your accountant, and enter or import the approved balances using the appropriate Cin7 workflow.

6. Can I migrate multiple warehouses from QuickBooks to Cin7?

Yes, but the source and destination location structures need to be considered. Cin7's QuickBooks wizard imports stock on hand into one selected location. Businesses operating multiple warehouses should prepare location-level quantities and establish the correct balances through a planned import and transfer process.

7. How long does a QuickBooks to Cin7 migration take?

The timeline depends on catalog size, data quality, warehouse complexity, financial mapping, historical records, and integration requirements. A small, organized dataset can be prepared more quickly than a migration involving many SKUs, several warehouses, or custom workflows. A discovery assessment provides the basis for an accurate project schedule.

Move Your Inventory Operations to Cin7 With SymConverge

A successful QuickBooks to Cin7 migration combines careful data preparation with a clear understanding of how your business will operate after cutover.

The right approach connects your product catalog, stock quantities, warehouses, financial mappings, and outstanding transactions to a defined migration plan. Testing and reconciliation then provide the evidence your team needs to approve the transition.

SymConverge helps businesses migrate from spreadsheets, accounting systems, ecommerce platforms, and legacy inventory software to Cin7 Core. Our migration process covers source-system assessment, data mapping, test migration, validation, production cutover, and post-launch assistance.

We work with your team to define which records need to move, how they should be structured in Cin7, and how the destination system will support your daily workflows.

Planning your move from QuickBooks to Cin7?

Explore SymConverge's Cin7 data migration services to discuss your source data, inventory requirements, accounting setup, and cutover plan.

Talk to Experts @SymConverge

Start with a migration assessment and build a plan around your business requirements.