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.
- Right-click on the automatic document you wish to export
- Select “Save as Excel file…”
- 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.
CPA Tech Tips 
#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 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 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 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
#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.|