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
- Chart of accounts (both active and inactive accounts)
- Item list (including cost, for inventory items)
- Opening stock quantity list
- Customer and vendor contacts
- Latest outstanding A/R and A/P
- Journal transactions (by year)
Reports for checking and verification
Export these reports for each year you are migrating:
- Profit and Loss (by year)
- Balance Sheet (by year)
- Trial Balance (by year)
Example: Profit & Loss
Example: Balance Sheet
Example: Trial Balance
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
- Go to Accountant and select Chart of Accounts.
- Select Reports, then Account Listing.
- Select Excel, then Create New Worksheet.
- Click Export.
Export items (stock)
- Go to Lists and select Item List.
- Select Excel, then Export All Items.
- Click Export.
Export customers
- Go to Customers and select Customer Center.
- Select Excel, then Export Customer List.
- Click Export.
Export vendors
- Go to Vendors and select Vendor Center.
- Select Excel, then Export Vendor List.
- Click Export.
Export the outstanding A/R balance
- Go to Reports > Customers & Receivables > Open Invoices.
- Set the report date to your migration cut-off date.
- Select Excel, then Create New Worksheet.
- Click Export.
Export the outstanding A/P balance
- Go to Reports > Vendors & Payables > Unpaid Bills Detail.
- Set the report date to your migration cut-off date.
- Select Excel, then Create New Worksheet.
- Click Export.
Export journal transactions (by year)
- Go to Reports > Accountant & Taxes > Journal.
- Set the date range to cover one financial year.
- Select Excel, then Create New Worksheet.
- Click Export.
- Repeat for each year you are migrating.
Next: Step 2: Processing & Overview of Functions, where you import this data into LocalizeBook.