Setup: Import from Quickbooks

Select Import from Quickbooks on the Setup Menu, and the following screen comes into view.

File Name

Enter the file name of the QuickBooks record or press the lookup button and select the file from the browse window.

Preview (button)

Press the Preview button, and the program will import all the information stored in the QuickBooks file and display it in the following two tabs.

Standard Database Items (Tab)

This tab displays all the Customers, Employees, Vendors, and Inventory Items found in the QuickBooks file.

Remove Highlighted Record (button)

To keep from importing a specific record, highlight the unwanted record and click this button. The line will be removed from the list box and the record will not be imported.

Import (button)

Press the Import button, and the program will add all the listed records to the company data. The following window will come into view.

GL Chart of Accounts (Tab)

This tab displays the General Ledger Accounts found in the QuickBooks file.

Since the format of the QuickBooks GL Account Number does usually coincide with the format required by the accounting program, an account number has been fabricated for each QuickBooks account during the Preview process. These account numbers are created by determining the financial statement section of each QuickBooks account and creating a number that falls within the correct numbering pattern for a standardized chart of accounts. For example, all QuickBooks accounts that have been assigned to Current Assets receive a number starting with '10' (e.g. 10100, 10200, etc.).

If any of these accounts are NOT to be imported, simply highlight the account and click the Delete button.

The account numbering and other settings of these new accounts can be modified prior to importing the chart of accounts. To modify these items, highlight the desired account and click the Change button. The following window will appear:

Here the settings for the new account can be entered. If this account already exists in the accounting system, select "Use an Existing GL Account" and pick the correct account from the drop-down list.

Once the list of accounts looks correct, click the Import button. The GL Accounts will now be loaded into the accounting system.