Importing from Microsoft Office Accounting
Requirements
- Microsoft SQL Server 2005 installed locally on the machine performing the import (for more information, see Imports and SQL Server).
| File name | Format imported |
|---|---|
| filename.sbb | Microsoft Office Accounting file |
Prerequisites
- If Protection is activated, the File permission "Import" is required to perform this operation.
Procedure
-
Open the client file in which you want to import.
-
On the Engagement tab, in the Data group, click Import | Accounting Software.
-
In the Import From field, select Microsoft Office Accounting and in the Version field, select the version of Microsoft Office Accounting you want to import.
Note: Click here to see all accounting software supported versions.
-
In the Import Path field, type the exact path where the file you want to import resides or use Browse to locate the file manually.
The General Ledger Detail will be imported.
-
To import client information, click Import Client Information. This information will be displayed in the Engagement Properties dialog.
- From the Backup file (*.sbb) drop-down field, select the file to import.
- To import prior year GL detail as current, select the Import prior year as current check box.
-
Connect to the SQL Server used with the accounting software that you are importing from. If you don't have this information, contact your database administrator.
- Server - The name of the SQL Database server.
- User/Password - The login and password used for the server.
- Click OK to process the import. The MS Office Accounting dialog will display.
- In the dialog, select the company currency from the drop-down menu and click OK.
- To proceed with overwriting the General Journal entries, click OK.
- Once the process has completed, click OK.
Results
Accounting data is imported into the client file.
