Microsoft Office Accounting Professional 2008

Importing Data from Sage

Microsoft Office Accounting allows you to import data from your existing accounting application if you are using Sage Line 50 (50 Accounts) or Sage Instant Accounts.

To start the conversion process, close your company and select Import data from Sage on the start page. Office Accounting creates a new company when importing data from Sage.

Convert from Sage wizard

Office Accounting will suggest a Sage driver and data path from where Sage is installed. Office Accounting cannot convert data on a PC where Sage is not installed.

Select the driver and data path and click Next.

Company details

Office Accounting will suggest the information entered when setting up the Sage database. Validate the company information and click Next.

Import options

You can now choose between importing all data from Sage including transactions (recommended) or just import master records. Select your import option and click Next.

Import options for stock products

You can now choose between importing stock products with stock valuation (as Office Accounting stock products) or as non-stock products (as Sage). Select your import option and click Next.

Vat liability account

Select your VAT liability account and click Next.

Product accounts

Because Sage doesn’t require a nominal account when setting up products and services you have to specify default accounts to be able to import the products and services specified. Select your sales and purchase accounts and click Next.

Stock Asset Account

You also need to specify the account that has been used to keep track of the value of the stock. Specify the Sage nominal account and click Next.

Import Data

You are now ready to import.

Save company file

Select a file name for your new company file and click Save. This will start the import process.

Importing data

The migration from Sage can take 10-20 minutes or even hours depending on the amount of data you have.

When the import is complete the following window appears in the wizard:

Migration completed

Look through the table and the log to check if all records and transactions migrated successfully. Click Finish to close the wizard and open your company in Office Accounting.