Step 1 : Requirement of Data and Check
Before migrating data, we want to show the data from Quickbooks for migration with data checking and verification to you first.
Below is data from Quickbooks for migration into Localizebook:
- All Chart of Account (Both Inactive and active)
- Item list (Including Cost if Item is inventory)
- Stock open balance quantity list
- Contact Customer & Vendor
- Latest Outstanding AR-AP
- Journal Transaction (By Year)
Below is data from Quickbooks for checking and verification:
- Profit and Loss (By Year)
- Balance Sheet (By Year)
- Trial Balance (By Year)
The first step in migrating to Localizebook is preparing the required data. You have to export data from your Quickbooks system so that it can be imported into Localizebook later. On this page, we will show some of the data exported from Quickbooks that relates to the data needed for migration.
Here’s how:
- Export Chart of Account
1.Go to Accountant
2.Select Chart of Accounts
3.Select Reports
4.Select Account Listing
5.Select Excel
6.Select Create New Worksheet
7.Select Export
- Export Items (Stock)
1.Go to Lists
2.Select Item List
3.Select Excel
4.Select Export All Items Show how to export data
5.Select Export
- Export Customer
1.Go to Customers
2.Select Customer Center
3.Select Excel
4.Select Export Customer List
5.Select Export
- Export Vendor
1.Go to Vendors
2.Select Vendor Center
3.Select Excel
4.Select Export Vendor List
5.Select Export
- Export Outstanding A/R Balance
1.Go to Reports
2.Select Customers & Receivables
3.Select Open Invoice
4.Select Date for data export
5.Select Excel
6.Select Create New Worksheet
7.Select Export
- Export Outstanding A/P Balance
1.Go to Reports
2.Select Vendors & Payables
3.Select Unpaid Bills Detail
4.Select Date for data export
5.Select Excel
6.Select Create New Worksheet
7.Select Export
- Export Journal Transaction (By Year)
1.Go to Reports
2.Select Accountant & Taxes
3.Select Journal
4.Select Date for data export
5.Select Excel
6.Select Create New Worksheet
7.Select Export