Importing from Sage 50 Accounts
Requirements
If importing from Sage Sterling for Windows or Line 50, the required files include:
| File | Containing... |
|---|---|
| ACCDATA\ACCOUNT.DTA | Profile information |
| ACCDATA\NOMINAL.DTA | Chart of accounts and balances |
| ACCDATA\NOMINDEX.DTA | Index for the chart of accounts |
| ACCDATA\SPLITS.DTA | General ledger detail (Required only if selecting General Ledger Detail under Import Components) |
| ACCDATA\SETUP.DTA | Accounting dates and company information |
| ACCDATA\COA | Types of account information |
| ACCDATA\BANK.DTA | Bank account information for the cash receipts and cash disbursement journal entries |
| ACCDATA\HEADER.DTA | Index to ledger file |
| DEPARTM.DTA | Department of cost center information (required if using "use department number to build entity") |
All other Sage program imports, such as Sage (DOS), use the following files:
| File | Containing... |
|---|---|
| ACCDATA\ACCOUNT.DTA | Profile information |
| ACCDATA\NOMINAL.DTA | Chart of accounts and balances |
| ACCDATA\NOMINDEX.DTA | Index for the chart of accounts |
| ACCDATA\POSTING.DTA | General ledger detail (Required only if selecting General Ledger Detail under Import Components) |
| ACCDATA\CATEGORY.DTA | ReadRecs (types of account information) |
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 Sage 50 Accounts and in the Version field, select the version 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.
-
Under Import Components, choose to import either:
- The Trial Balance (Opening Entries) or,
- The General Ledger Detail.
Note: Purchase receipt and Sales refund transactions will not be posted to bank accounts.
-
To import client information, click Import Client Information. This information will be displayed in the Engagement Properties dialog.
- Complete the remaining fields of the dialog. >>Quick Reference
- Click OK to begin importing.
Results
Accounting data is imported into the client file.
Notes
- If importing accounts with split ups, once the import is complete, from the Tools menu, select Options | Mapping. Click the Autofill Now button to restore the account properties automatically for all accounts and ensure all balances are correct.
