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”

SS-2010.06.09-14.47.40

The exported file should look just like the automatic document:

SS-2010.06.09-14.50.49

NOTE: The totals and subtotals are NOT formulas.

Advertisements
  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 http://tinyurl.com/shaninnis20687 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:

WordPress.com Logo

You are commenting using your WordPress.com 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: