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

  5. #5 by Napoleon Ellifritt on September 1, 2019 - 3:34 pm

    May I just say what a comfort to find someone who genuinely knows what they are discussing online. You definitely know how to bring a problem to light and make it important. More people must read this and understand this side of your story. I was surprised that you are not more popular since you definitely possess the gift.|

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 )

Facebook photo

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

Connecting to %s

%d bloggers like this: