Importing client data from BusinessWorks Gold

Alerts and notices
Leave feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.

Characters left:

Important reminder!

Product support for Engagement CS is ending on September 30, 2020. See Engagement CS license expiration 2020 - frequently asked questions for more information.

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS permanently expired on March 1, 2017.

Some processes documented in the Help & How-To Center are no longer applicable, due to the discontinuation of Creative Solutions Accounting.

Accountant's Assistant is provided with the CBS Master License.

Use the following procedure to import client data from BusinessWorks Gold (versions currently supported by the application provider) into Write-Up CS in CSA. Note that only general ledger transactions (not payroll) can be imported from BusinessWorks Gold.

Note: Use this same procedure if importing client data from Sage BusinessWorks 50 Accounting.

  1. To create the export file of general ledger transactions from BusinessWorks Gold: From the GL menu in BusinessWorks Gold, the client should choose Transfer > Export Journal Entries and then transmit the electronic file to you either on disk or via e-mail. Note that the default export filename created by BusinessWorks Gold is jdtrans.csv.
  2. After receiving the copy of the client's BusinessWorks export file: Save the file to a folder on your hard drive and rename it to match the first 8 characters of the CSA client ID so that the import utility in Accountant's Assistant can recognize it correctly.

    Example: For a client with ID GREENTREE, you would need to change the filename to GREENTRE.csv.

  3. Start the CSA application and specify the following required information. Note that you need to add the client in CSA prior to starting the first import.
    1. In the General Information tab of the File > New Client or Client Properties dialog:
      • Client ID
      • Client name
      • Payroll name
      • DBA
      • Address line 1 and line 2
      • City, State, Zip
      • Telephone #
      • EIN
    2. In the General Ledger tab of the File New Client or Client Properties dialog:
      • Current period ending date
      • Current fiscal year end
      • Periods
      • Chart of accounts mask

        Note: To import GL transactions into separate journals, also mark the Use separate journals in transaction data entry checkbox.

    3. (Optional but strongly recommended.) In the Setup > Chart of Accounts window, set up the client's Chart of Accounts, or transfer the Chart of Accounts from a similar CSA client and then modify it as necessary. Account numbers are imported along with the transactions from the client's BusinessWorks Gold export files, but not the account descriptions and types.
    4. In the Setup > Checkbook dialog, you must set up at least one checkbook with a unique GL account number.
    5. In the Setup > Journals dialog, set up one or more journals for the CSA client.
  4. From the CSA main window, choose Utilities > Accountant's Assistant > BusinessWorks.
    1. Specify the location on your hard drive where you saved the selected client's BusinessWorks Gold CSV export file (as described in step 2 above).
    2. The Starting departmental account number field is enabled only if an L for locations or a D for departments is included in the Chart of Accounts mask (in the General Ledger tab of the File > Client Properties dialog).
      • If all of the accounts in the Chart of Accounts are departmental accounts, enter 1.
      • If only some of the accounts are departmental accounts, enter the number of the first BusinessWorks Gold departmental account.
    3. Mark the BusinessWorks Gold checkbox.
    4. Click the Import button.
  5. During the import process:
    • If a GL account is referenced in a transaction that does not exist in the CSA Chart of Accounts, the application automatically adds the account.
    • If the Use separate journals checkbox is marked in the General Ledger tab of the File > Client Properties dialog and multiple journals have been set up for the client in CSA, the Journals dialog opens automatically during the import process. Use this dialog to specify which CSA journals to use for each BusinessWorks Gold journal that is included in the client's data file.

Top of page

Share This