Importing from Big Red Book
Requirements
- Microsoft Windows SQL Server 2008/2012 (for more information, see Imports and SQL Server).
- Microsoft SQL Server 2005 Backward Compatibility Components
Note: The SQL Server instance must be installed locally on the machine performing the import.
| File name | Containing... |
|---|---|
| bigredbook_nnn.zip | Trial balance and/or general ledger detail. |
Where...
- nnn represents the number assigned to the client file.
Note: These files are created using the backup function in Big Red Book.
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 Big Red Book.
-
In the Version field, select the default version 5.0x.
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.
If the selected file does not include Big Red Book data, an error message will display.
-
Under Import Components, choose to import either:
- The Trial Balance (Opening Entries) or,
- The General Ledger Detail.
-
To import client information, click Import Client Information. This information will be displayed in the Engagement Properties dialog.
-
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.
- Complete the remaining fields of the dialog. >>Quick Reference
- Click OK to begin importing.
Results
Accounting data is imported into the client file.
Note: If there is no reference number specified in the Big Red Book file, entries from the same transaction will be given a unique reference number: "CW######".
