Importing from Brilliant Accounting and Pastel Evolution
Requirements
| File | Containing... |
|---|---|
| cwctb1.txt | Consolidated trial balance |
| cwunctb1.txt | Unconsolidated trial balance |
| cwglmov1.txt | GL movements |
If importing from Pastel Evolution:
- Export the transactions in Pastel Evolution to create an export file.
- Note that Pastel Evolution 6 files are compatible with imports from version 5.
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 either Brilliant Accounting or Pastel Evolution.
-
In the Version field, select the version that you would like to import from.
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 Trial Balance (Opening Entries) will be imported
-
To import client information, click Import Client Information. This information will be displayed in the Engagement Properties dialog.
-
Choose to import the Consolidated TB, Unconsolidated TB, or GL Movements.
- Consolidated TB - Select this option to import the consolidated trial balance, current year balances, and prior year (1, 2 & 3) balances.
- Unconsolidated TB- Select this option to import the unconsolidated trial balance, current year balances, and prior year (1, 2 & 3) balances.
-
GL Movements - Select this option to import period balances.
Note: The Reporting Dates tab in the Engagement Properties should be set to either Monthly of 13 periods date sequence before doing this import.
- If applicable, select Use department/branch to build entity on to select whether to build the entity based on the department or the branch. If the box is unchecked, Working Papers puts each account into the top entity with the full account name as account>dep<branch. See here for more information.
- Click OK to begin importing.
Results
Accounting data is imported into the client file.
