CaseWare: Export automatic documents directly to Excel to preserve formatting

It is often helpful to send a client an Excel copy of the trial balance or any other automatic document. The latest versions of CaseWare provide a very easy way to do this.

  1. Right-click on the automatic document you wish to export
  2. Select “Save as Excel file…”
  3. Choose a destination, enter a filename, and click “Save”


The exported file should look just like the automatic document:


NOTE: The totals and subtotals are NOT formulas.

  1. #1 by mokume gane rings on September 4, 2011 - 10:36 pm

    I feel this is among the so much important information for me. And i am glad reading your article. However wanna remark on some common issues, The web site style is perfect, the articles is truly great : D. Excellent task, cheers

  2. #2 by Em on July 25, 2012 - 7:44 pm

    It would be helpful to know how to get to the first screen shown in your article. When I’m in ‘Documents’, I can see the balance sheet and income statement, but nothing else, i.e. no Adjusted trial balance, unrecorded differences, financial statement disclosures etc.

  3. #3 by Tim Gavin, CPA on July 26, 2012 - 8:01 am

    Em, the document manager is going to be unique to each user. The first screen above is simply how my firm has our template set up for audits.

  4. #4 by on February 3, 2013 - 2:08 am

    I really consider this amazing article , “CaseWare:
    Export automatic documents directly to Excel to preserve formatting CPA Tech Tips”, incredibly pleasurable
    plus it was in fact a good read. Thank you,Windy

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: