QuickBooks 2005: The Missing Manual

Exporting QuickBooks Data

To get data out of your QuickBooks company file and into another program, you have two choices:

• Export file. You can create a delimited text file that contains various types of data from your QuickBooks file. For example, you can generate export files for Quick Books lists, such as your Item List or Customer Type List. For the named records in QuickBooks, such as your Customer:Job and Vendor Lists, you can produce export files that contain only address information.

• Report file. Create any report in QuickBooks and you can then export it to a file that you can use in another program. If you want to export data from several lists or from transactions, exporting reports is your only choice.

Exporting Lists and Addresses

When you export lists to QuickBooks delimited text files, or .iif files, the export file contains all the fields associated with those QuickBooks lists. Creating export files is easy, and your only choice is which lists to export. If you export several lists, the .iif file that QuickBooks creates contains every field for every list you chose.

Tip

If you want more control over the information that you export, set up a report with that information and export the report (page 521).

Exporting lists

Exporting one or more lists to a delimited file takes only a few quick steps:

1. Choose File→Export→Lists to IIF Files.

   The program opens an Export dialog box, which contains checkboxes for each list in QuickBooks.

2. Turn on the checkbox for every list that you ...