Importing client data from BusinessWorks

Show expandable text

Warning

Product support for the Creative Solutions Accounting platform ended on September 30, 2020.

Help & How-To Center content for the Creative Solutions Accounting platform may be outdated and is used at your own risk.

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

This topic does not apply to imports from BusinessWorks Gold. For information on importing from BusinessWorks Gold or Sage BusinessWorks 50 Accounting, click here.

At the client's office

In BusinessWorks, the client first needs to create the data export files to send to you either on disk or via e-mail.

  • To export general ledger transactions: The client should choose General Ledger > Transfer > Export to ACE Write-Up > FR and then complete the appropriate fields to specify the path for the export file, the client ID, and so forth. Clicking OK creates a file called FRxxxxxT.TXT (where xxxxx represents the five-character BusinessWorks client ID).
  • To export payroll tax form information: The client should choose Payroll > Transfer > Export to ACE Write-File > BB and then complete the appropriate fields to specify the path for the export file, the client ID, and so forth. This creates a file called PRxxxxxT.TXT (where xxxxx represents the five-character BusinessWorks client ID).

    Note: A client export of December payroll information includes employee data from the W-2s.

At the accountant's office

  1. After receiving the copy of the client's BusinessWorks export file(s), save the file(s) to a folder on your hard drive.
  2. Start the CSA application and set up the client with the required information outlined in Special information for client data imported from BusinessWorks.
  3. From the CSA main window, choose Utilities > Accountant's Assistant > BusinessWorks and then specify the location on your hard drive where you saved the selected client's BusinessWorks export data in step 1 above. Click the Import button.

For a client with multiple journals

During the client setup in CSA, mark the Use separate journals in transaction data entry checkbox in the General Ledger tab of the File > New Client or the File > Client Properties dialog. Choose Setup > Journals and set up one or more journals for the CSA client. When importing the BusinessWorks general ledger transactions export file into CSA, the Journals dialog opens automatically. Use this dialog to specify which CSA journals to use for each BusinessWorks journal that is included in the client's data file.

Top of page

Was this article helpful?

Thank you for the feedback!