Skip to content
logo Knowledgebase

Adding QuickBooks data to a new Sage 50 Accounting company

Created on  | Last modified on 

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

  1. Open the company in QuickBooks.
  2. Select File, Utilities, Export, then Lists to IIF Files.
  3. From the Export window, select Vendors.
  4. Select OK.
  5. Save in a known location with an appropriate file name.
  6. Repeat the steps for each list. Select and save each item one at a time. 
  7. 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 

  1. Open Sage 50.
  2. In the Welcome Screen, choose Create a new company.
  3. If you already have an existing file open in Sage 50, in the Home window, from the File menu, select New Company.
  4. Follow the New Company Wizard until the wizard asks you to choose how to create your list of accounts.
  5. Select the Option Have Sage 50 create a list of accounts from an export file.
  6. Select Next, then QuickBooks.
  7. Browse to the location where you saved the IIF Files and select the appropriate file.
  8. Follow the remaining directions to complete the new company setup.

Related Solutions