Once you have exported all the required data from QuickBooks (Step 1), you can start importing it into LocalizeBook. For a smooth migration, complete the functions on this page in the order shown, because later imports depend on earlier ones.
Functions used in this step
- Import Chart of Accounts
- Add accounts in the Chart of Accounts
- Import Items
- Import Customers
- Import Vendors
- Batch journal entries (Create Transactions)
Most of these functions are under Accounting > Bulk Operations in LocalizeBook.
1. Import Chart of Accounts
The chart of accounts is the list of accounts used in your company's general ledger. Importing it is the first step of the migration, because every other import refers to these accounts.
Go to Accounting > Bulk Operations > Import Data > Import Chart of Accounts.
Important: When you fill in the chart of accounts template, change the account types as follows:
- A/R account and Inventory account: change to Other Current Asset.
- A/P account: change to Other Current Liability.
For detailed instructions, see the Import Chart of Account article.
2. Create the new control accounts
Because the old A/R, Inventory, and A/P accounts were imported as Other Current Asset and Other Current Liability, you now need to create new control accounts in LocalizeBook to hold your outstanding balances:
- A new A/R account with the account type Account Receivable
- A new inventory account with the account type Inventory
- A new A/P account with the account type Account Payable
Go to Accounting > Chart of Accounts and click Add.
Tip: Create these accounts before you import your items. The item import template asks for these new accounts.
For detailed instructions, see the Create Chart of Account article.
3. Import Items
Items are the goods and services your business sells or buys. You can import all of your QuickBooks products and services into LocalizeBook in one go.
Go to Accounting > Bulk Operations > Import Data > Import Items.
Important: In the item import template, use the new accounts you created in LocalizeBook, not the old QuickBooks accounts.
For detailed instructions, see the Import Item article.
4. Import Customers
Next, bring in your customer contacts. LocalizeBook manages customers in their own dedicated list (Customer Center).
Go to Accounting > Bulk Operations > Import Data > Import Customers.
For detailed instructions, see the Import Customer article.
5. Import Vendors
Then bring in your vendor contacts. LocalizeBook manages vendors in their own dedicated list (Vendor Center).
Go to Accounting > Bulk Operations > Import Data > Import Vendors.
For detailed instructions, see the Import Vendor article.
6. Batch journal entries
Finally, import your journal transactions, one year at a time.
- Go to Accounting > Bulk Operations > Batch Transactions > Create Transactions.
- Set Transaction Type to Journal Entry.
- Click Download Template to get the journal entry template, and fill in your journal transactions.
- Click Browse File to select your file, then click Import.
Note: Each journal entry import can contain up to 2,000 records. Split larger files into several imports.
For detailed instructions, see the Batch Journal Entry article.
Next: Step 3: Verify Migrated Data, where you compare LocalizeBook reports with your QuickBooks reports.