• Imports
  • Comparison report
  • Imports and Pervasive SQL
  • Imports and SQL Server
  • Software import index
  • Create a database backup file
  • Import from accounting software
  • Import from ASCII or Excel
  • Import from CaseWare Working Papers
  • Import from Engagement CS
  • Import from ProSystem fx Engagement
  • Import from QuickBooks
  • Import from Sage 50 Accounting
  • Import from Working Paper Software
  • Import from XML

Import from Sage 50 Accounting

You can import the trial balance and general ledger detail from Sage 50 Accounting to your Working Papers file. The import method differs depending on the version of Sage 50 Accounting you are using. For a list of supported Sage 50 Accounting versions, see the Software import index.

• Import from Sage 50 Accounting (Canada)
• Import from Sage 50 Accounting (USA)

Import from Sage 50 Accounting (Canada)

Sage 50 Accounting (Canada) is formerly known as Simply Accounting. The import process is also applicable to Simply Accounting software.

Before you can proceed, you must complete the following prerequisites:

• Install either Sage 50 Accounting (Canada) or the Sage 50 Connection Manager utility from MyCaseWare. You must have one of these applications to perform the import; however, do not install both.
• If you are importing data from a version older than 2008, install the DAO import update.
• If the file is protected, you must have the Import group right.

To import from Sage 50 Accounting (Canada):

1. Ensure you have completed all the necessary import prerequisites before you proceed.
2. On the ribbon, click Engagement | Import | Accounting Software. The Import - Accounting Software dialog displays.
3. In the Import From drop-down menu, select Sage 50 Accounting CDN Edition (Simply).
4. In the Version drop-down menu, select the version of Sage 50 Accounting (Canada) that is installed on your workstation, or the version of the files you are importing.
5. In the Import Path field, click Browse.... Navigate to the Sage 50 Accounting (Canada) folder where the client data is located and click Select Folder.
6. In the Import Components group, select either Trial Balance (Opening Entries) or General Ledger Detail to specify the data to import.
7. If applicable, select Import Client Information to copy client information into the Engagement Properties of your Working Papers file.

8. Complete any other options as required.

   Option	Description
   Client ID	Select the name of the client to import.
   Budget Data	Select to include budget data in the import.
   Import current year	Select to include current year balances in the import.
   Import prior year as current	Select to import the prior year from Sage 50 Accounting as the current year in the Working Papers file. Note that this will not populate the Working Papers file with prior year information.
   Import prior year balance	Select to include the comparative balance in the import.
   Skip GIFI data	Select to exclude GIFI code numbers from the import.
   Update Sign field on import	Select to update the existing accounts' Sign field with imported data.
   Import as yearly file	Select to import data as a yearly file.
   Use project to build entity	Select to use the project to built entities.
   Use department/division to build entity	Select to use imported department/division codes to build entities.
   Merge acct. no. and department code	Select to merge the account numbers and department codes. For example, the imported account will become XXXX.001, where XXXX is the account number and 001 is the department code. In this case, no sub-entity is created. If you need to create sub-entities, do not select this option.
   Build entity for consolidated company	Select to build an entity for a consolidated company during the import.
   Import closing journals as transactions	Select to import closing journals as transactions.
   User ID / Password	Enter login credentials with access to the Sage 50 Accounting client database. This is often the sysadmin.

   Click OK.

The data is imported to your Working Papers file.

Import from Sage 50 Accounting (USA)

Sage 50 Accounting (USA) is formerly known as Peachtree. The import process is also applicable to Peachtree software.

Before you can proceed, you must complete the following prerequisites:

• Install Pervasive SQL version v9.1 or later.
• Remove the read-only attribute from all files in the client data folder (right-click the files, click Properties | General, then deselect Read-only).
• If the file is protected, you must have the Import group right.

To import from Sage 50 Accounting (USA):

1. Ensure you have completed all the necessary import prerequisites before you proceed.
2. On the ribbon, click Engagement | Import | Accounting Software. The Import - Accounting Software dialog displays.
3. In the Import From drop-down menu, select Sage 50 Accounting (Peachtree-WIN).
4. In the Version drop-down menu, select the version of Sage 50 Accounting (USA) that is installed on your workstation.
5. In the Import Path field, click Browse.... Navigate to the Sage 50 Accounting (USA) folder where the client data is located and click Select Folder.
6. In the Import Components group, select either Trial Balance (Opening Entries) or General Ledger Detail to specify the data to import.
7. If applicable, select Import Client Information to copy client information into the Engagement Properties of your Working Papers file.

8. Complete any other options as required.

   Option	Description
   Prior Year Data	Select to include prior year balances in the import. Note that any existing prior year data will be overwritten.
   Period 1 to 12 as current year	Select to import Period 1 to 12 from Sage 50 Accounting (USA) as the current year in Working Papers. If you do not select this option, the current fiscal period is used.
   Period Balance	Select to include period balances in the import, rather than year-to-date numbers.
   Retained Earnings a/c no.	Enter the account number associated with the retained earnings. If this field is left blank, it will automatically search the data files for the account.
   Date Format used	Select the date format to use during the import. By default, the regional settings on your workstation are used.

   Click OK.

The data is imported to your Working Papers file.