Summary
Export your chart of accounts, customers, vendors, and employees from QuickBooks and import them into a new Sage 50 Accounting company.
Description
- This conversion doesn't transfer transactions with dollar amounts
- However, during the new company wizard, Sage 50 will import the accounts and balances from QuickBooks
Resolution
Export the lists from QuickBooks
- Open the company in QuickBooks.
- Select File, Utilities, Export, then Lists to IIF Files.
- From the Export window, select Vendors.
- Select OK.
- Save in a known location with an appropriate file name.
- Repeat the steps for each list. Select and save each item one at a time.
- Sage 50 Accounting common import list files are: Chart of Accounts, Customer List, Vendor List, and Employee List.
NOTE: QuickBooks uses a comma to interpret addresses. Make sure your QuickBooks data file has a comma between the city and state/province, such as Richmond, British Columbia, V3M 7Q3N.
Create a new company and import lists in to Sage 50 Accounting
- Open Sage 50.
- In the Welcome Screen, choose Create a new company.
- If you already have an existing file open in Sage 50, in the Home window, from the File menu, select New Company.
- Follow the New Company Wizard until the wizard asks you to choose how to create your list of accounts.
- Select the Option Have Sage 50 create a list of accounts from an export file.
- Select Next, then QuickBooks.
- Browse to the location where you saved the IIF Files and select the appropriate file.
- Follow the remaining directions to complete the new company setup.