Step 1 : Requirement of Data and Check

Export the data and reports you need from QuickBooks Desktop before migrating to LocalizeBook.

Last updated: Nov 18, 2026

The first step in moving to LocalizeBook is preparing your data. Export the data you need from QuickBooks Desktop so you can import it into LocalizeBook in Step 2. You will also export a few financial reports, which you will use in Step 3 to check that the migrated figures match.

What to export

Data for migration

  1. Chart of accounts (both active and inactive accounts)
  2. Item list (including cost, for inventory items)
  3. Opening stock quantity list
  4. Customer and vendor contacts
  5. Latest outstanding A/R and A/P
  6. Journal transactions (by year)

Reports for checking and verification

Export these reports for each year you are migrating:

  1. Profit and Loss (by year)
  2. Balance Sheet (by year)
  3. Trial Balance (by year)

Example: Profit & Loss

Image

Example: Balance Sheet

Image

Example: Trial Balance

Image

How to export data from QuickBooks Desktop

Each export below opens your data in Excel. Save each file so it is ready to import in Step 2.

Export the chart of accounts

  1. Go to Accountant and select Chart of Accounts.
  2. Select Reports, then Account Listing.
  3. Select Excel, then Create New Worksheet.
  4. Click Export.

Export items (stock)

  1. Go to Lists and select Item List.
  2. Select Excel, then Export All Items.
  3. Click Export.

Export customers

  1. Go to Customers and select Customer Center.
  2. Select Excel, then Export Customer List.
  3. Click Export.

Export vendors

  1. Go to Vendors and select Vendor Center.
  2. Select Excel, then Export Vendor List.
  3. Click Export.

Export the outstanding A/R balance

  1. Go to Reports > Customers & Receivables > Open Invoices.
  2. Set the report date to your migration cut-off date.
  3. Select Excel, then Create New Worksheet.
  4. Click Export.

Export the outstanding A/P balance

  1. Go to Reports > Vendors & Payables > Unpaid Bills Detail.
  2. Set the report date to your migration cut-off date.
  3. Select Excel, then Create New Worksheet.
  4. Click Export.

Export journal transactions (by year)

  1. Go to Reports > Accountant & Taxes > Journal.
  2. Set the date range to cover one financial year.
  3. Select Excel, then Create New Worksheet.
  4. Click Export.
  5. Repeat for each year you are migrating.

Next: Step 2: Processing & Overview of Functions, where you import this data into LocalizeBook.

Related Articles