ERPNext QuickBooks Migrator

ERPNext QuickBooks Migrator

How to Setup QuickBooks Migrator?

Create a QuickBooks Online App

1. From Awesome-bar, Go to "QuickBooks Migrator" DocType.

2. Go to Inuit Developer Portal

3. Sign In with your existing account or Sign Up.

4. Go to "My Apps" page.

5. Click on "Select APIs".

6. Under "QuickBooks API" Check "Accounting".

7. Click on "Create App".

*You'll be taken to the Dashboard of your App.

8. Go to "Keys" tab.

9. Go to "Production Keys" Section.

*Complete requirements.

10. In "QuickBooks Migrator" DocType a "Redirect URL" will be generated for you and add it in the list of "Redirect URIs" of your Inuit App (under "Production Keys" section). Click Save.

*Make sure that the Redirect URL starts with https.

11. From "Production Keys" section copy "Client ID" and "Client Secret" to "QuickBooks Migrator" DocType.

12. Save "QuickBooks Migrator".

Connect to QuickBooks Online API

1. Click "Connect to QuickBooks".

2. A new tab will open in your browser and You'll be asked to Log In.

3. If you have more than one companies then Select the company you want to migrate.

4. Click "Connect".

5. Upon successful authorization, the tab will close.

6. The indicator will be set to "Connected to QuickBooks".

7. In "QuickBooks Migrator" select "Company" where you want to migrate your data.

8. Save "QuickBooks Migrator".

Migrate Data 1. Click the "Fetch Data" button.

2. The indicator will change from "Connected to QuickBooks" to "In Progress".

3. Progress bars will show the status of migration.

4. This will take a few minutes depending on the size of data.

5. After migration is complete, the indicator will change to "Complete" or "Failed".

What Will Happen when I Click Fetch Data?

Account

Existing Chart of Accounts

Upon creation of a Company ERPNext creates a chart of accounts for that company, these accounts will be kept.

Account Naming

To avoid name collision with existing accounts, all accounts from QuickBooks will be assigned "- QB" suffix.

Root Accounts Five root accounts, namely Asset, Equity, Expense, Liability, Income will be created and all accounts (depending on the account type) will become children of these accounts.

Group Accounts QuickBooks allows transactions on group accounts, which is not allowed in ERPNext, to handle this, every group account will have a child with a hyphenated name.

Name Collisions

Item

Naming

UOM*

Fractional UOM

Inventory

Customer and Supplier

Naming

Invoice

Variants

Discount and Markup

Shipping

Round off

Special Case

Bill

Variants

Other

1.Advance Payment

2.Bill Payment

3.Cheque

4.Credit Card Credit

5.Expense

6.Inventory Qty Adjustment

7.Journal Entry

8.Payment

9.Tax Payment

Tax There will be a new ERPNext account created for each QuickBooks Tax Rate.

Custom Fields The following Custom Fields will be added by QuickBooks Migrator.

1. Company field

a. Customer

b. Item

c. Supplier

2. QuickBooks ID field

a. Customer

b. Item

c. Journal Entry

d. Purchase Invoice

e. Sales Invoice

f. Supplier