Using the CS Microsoft Office Accounting Export Utility

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

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


Characters left:

Important reminder!

Licenses for Payroll CS, Trial Balance CS, and Write-Up CS (but not Engagement CS) permanently expired on March 1, 2017. CSA will not include 2017 tax rates or payroll forms, so, for 2017 and beyond, you will need to process payroll in another application. We recommend Accounting CS Payroll and myPay Solutions. For more information, see the following topics.

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

The CS Microsoft Office Accounting Export Utility is designed to work with Microsoft Office Accounting version 2007 or higher or with Microsoft Office Accounting Express 2007 or higher. It creates a set of XML files and combines them into a single secure file that can then be imported into Write-Up CS (via Accountant's Assistant).

The export file created by the utility includes the date range (as specified by the user during the export) plus the Office Accounting company name (for example, CSExport from 01-01-07 to 12-31-07 Client Name.sbaexportdata).

Export files created using the CS Microsoft Office Accounting Export Utility may be used to import all data and transactions for the selected date range.

See also: Importing client data from Microsoft Office Accounting

Top of page

Installing the CS Microsoft Office Accounting Export Utility (accountant's office)

  1. Using My Computer or Windows Explorer, browse to the d:\WINCSI\CSA\OAExport\ folder location and, holding down the CTRL key on your keyboard, click the SBAExportAddIn.dll file, the ICSharpCode.SharpZipLib.dll file, and the CSOAExportUtility.exe file, and then choose Edit > Copy.
  2. Using My Computer or Windows Explorer, browse to the hard drive or network location where the Microsoft Office Accounting 2007 or higher application files are installed. For example, if the application is installed on your local hard drive, the default location would be c:\Program Files\Microsoft Small Business\Small Business Accounting 20xx.
  3. Double-click the Small Business Accounting 20xx folder to open it, and then choose Edit > Paste to place a copy of the SBAExportAddIn.dll file, the ICSharpCode.SharpZipLib.dll file, and the CSOAExportUtility.exe file into that folder.

If your CLIENT will be creating the export files from Microsoft Office Accounting:

Top of page

Installing the CS Microsoft Office Accounting Export Utility Add-In in the Microsoft Office Accounting application (accountant's office or client's office)

  1. Open Office Accounting 2007 or higher and open the company database to export from.
  2. Choose File > Utilities > Add-in Manager.
  3. Click the Install New button.
  4. Browse to the location where you placed the SBAExportAddIn.DLL file (from step 3 in the section above), highlight that file, and then click the Open button.
  5. You will see Export Company Data listed under the Add-in Name column on the Microsoft Office Accounting Add-in Manager screen. Mark the Enabled checkbox next to Export Company Data.
  6. When prompted to restart Office Accounting, click OK and then choose File > Exit to close the application.
  7. Re-open the Office Accounting application and open the company. You should now see the CS Utilities command on the menu bar.

Top of page

Creating the export file using the CS Microsoft Office Accounting Export Utility (accountant's office or client's office)

  1. Open Office Accounting 2007 (or higher) and open the company database to export from.
  2. Click the CS Utilities command on the menu bar and choose Export Data to CS.
  3. In the Export Office Accounting Data to Accountant dialog, specify the date range to include in the export file by doing either of the following:
    • Select one of the options from the drop-down list in the Dates field (This Month; This Calendar Quarter; This Calendar Year; Last Month; Last Calendar Quarter; Last Calendar Year; or Custom).
    • Specify the From > To dates by entering the dates manually in MMDDYY date format or by clicking the dates in the drop-down calendar.
  4. Enter or browse to the file location where the export file is to be saved. This location can be on a local hard drive, a network drive, or some form of removable media.
  5. Click the Export button.
  6. At the confirmation prompt, click OK to complete the creation of the export files.

The export file created by the utility includes the date range specified by the user plus the Office Accounting company name (for example, CSExport from 01-01-07 to 12-31-07 Client Name.sbaexportdata).

Saving the export file to a location you can browse to during the import process (accountant's office)

If the client has created the export file to send to you, save that file in a folder in a location (on your own network or workstation) to which you can browse during the import process. Note that you may import multiple times from this same export file if necessary.

Top of page

Share This