Step 3: Preparing To Import

It is best to close out your books for the current fiscal year in QuickBooks before you begin importing data into Office Accounting. To close your books in QuickBooks, make sure all of your income, expense, and cost of goods sold accounts all equal zero.

Closing your books in QuickBooks ensures that your Balance Sheet is properly calculated, and that the balances are imported into Office Accounting correctly.

Office Accounting only imports Balance Sheet account balances (cash accounts, bank accounts, other current asset accounts, inventory accounts, other asset accounts, fixed asset accounts, credit card accounts, current liability accounts, long-term liability accounts, and equity accounts) from QuickBooks.

Note: If you do not wish to close out your books for the current fiscal year, you can still migrate your data, but you will need to perform some additional actions once you import your data into Office Accounting. For more information, see Import Current Fiscal Year into Office Accounting.

Rebuild Company Data in Quickbooks

Prior to importing your QuickBooks data into Office Accounting, you will need to rebuild your company data file. Follow the steps below.

  1. In QuickBooks, open the company that you want to import.
  2. On the Window menu, click Close All.
  3. On the File menu, point to Utilities, and then click Rebuild Data.
  4. Click OK when you are prompted to make a backup.
  5. Click No if you are prompted with the question of whether you want to replace the backup file. To avoid overwriting your current file, type a new name in the Filename field.
  6. In the Back up Company File window, click Back Up.
  7. The Rebuild Data utility will start as soon as the backup is completed. Click OK when you receive a message that states that the rebuild has been completed.

After you have finished preparing your master records, continue with one of the following options:

Import Master Records Only into Office Accounting
Import All QuickBooks Data into Office Accounting

 
© 2006 Microsoft Corporation. All rights reserved. Legal | Trademarks | Privacy Statement