Preparing to Import a QuickBooks, MYOB, or Quicken File in the New Company Setup Wizard
Before the New Company Setup Wizard can import records from QuickBooks, MYOB, or Quicken, you must prepare the records and format them into a file that Sage 50 Accounting can import.
To prepare a QuickBooks file
for importing into Sage 50 Accounting
- Open QuickBooks. On the File menu, select Export, and then Lists to .IIF.
- Select the data you want to export (Vendor and Customer lists), then click OK.
- Enter a name and location for the .IIF file.
To prepare a MYOB file for importing
into Sage 50 Accounting
- Open MYOB. On the File menu, choose Export Data.
- In the Export File
dialog box:
- Select Cards, and then Customer Cards.
- In the Export File Format box, select Tab delimited.
- In the First Record Is box, select Header Record.
- Click Continue.
- In the Export Data dialog box, select the boxes you want to export or click Match All.
- Click Export, then enter a file name and location for the .TXT file.
- Click OK or Save.
- Repeat steps 1
to 7 to import your
To prepare a Quicken file for importing into Sage 50 Accounting
To prepare addresses in Quicken
(Vendors and Customers records only)
- Open Quicken. In the main window, on the Tools menu, choose Address Book.
- In the Address Book window, select the customers and vendors you want to export. Do not close the window.
- In the main window, on the File menu, choose Export and select Addresses.
- On the Export Address Records window, choose Tab Delimiter format, and enter a filename for the information you are exporting.
- Select the boxes you want to export, and click Add.
- Click Done.
To prepare accounts in Quicken
- Open Quicken. In the main window, on the File menu, choose Export Data, then select QIF.
- Enter a file export location and then choose Account List and Category List to include in the export.
- Enter the start and end dates for the data you want to import.
- Click OK.