Migrate Data to LocalizeBook: Overview
If your company has been running on another accounting system for some time, the first thing to take care of when switching to LocalizeBook is bringing your existing data across: your chart of accounts, items, contacts, transaction history, and opening balances. This guide walks you through the full migration process, one step at a time.
Example scenario
Throughout this guide, we use QuickBooks Desktop as the source system. In our example, a company used QuickBooks Desktop through 2022 and switched to LocalizeBook in January 2023. The same approach works if you are moving from another accounting system; only the export steps will differ.
What you'll need
- Access to your current accounting system (for example, QuickBooks Desktop) so you can export lists and reports.
- Access to LocalizeBook's import and journal entry functions.
- Your migration cut-off date: the date from which you will record transactions in LocalizeBook.
The six migration steps
Work through the steps in order, as each one builds on the step before it.
- Requirement of Data and Check – Export the data you need from QuickBooks: chart of accounts, item list, opening stock quantities, customers and vendors, outstanding A/R and A/P, and journal transactions by year. Also export your Profit & Loss, Balance Sheet, and Trial Balance by year so you can check the results later.
- Processing & Overview of Functions – Import the exported data into LocalizeBook using Import Chart of Accounts, Import Items, Import Customers, and Import Vendors, then import your journals with Create Transactions (Accounting > Bulk Operations).
- Verify Migrated Data – Compare the Profit/Loss by Year, Balance Sheet by Year, and Trial Balance reports in LocalizeBook with the same reports from QuickBooks, year by year.
- Opening Control Account Balance – Create new A/R, A/P, and Inventory Asset control accounts and enter their outstanding opening balances.
- Posting Journal Cut Off Balance – Post journal entries that offset the old A/R, A/P, and stock account balances so nothing is counted twice.
- Verify Opening Balance Data – Reconcile the Outstanding A/R by Customer, Outstanding A/P by Vendor, and Stock Value Summary reports with the matching balances on the Balance Sheet.
Tips for a smooth migration
- Export both active and inactive accounts from your chart of accounts so that historical transactions import correctly.
- Verify each year's figures before you post opening balances. Differences are much easier to trace early on.
- Keep your exported QuickBooks files and reports until the migration has been fully verified.
Ready to begin? Start with Step 1: Requirement of Data and Check.