Steve,
I too get the request from clients or their auditors to provide the GL detailed listing at year end. One group acutally has a custom program written for their company to import this mess rather than using caseware.
My main problem has been limits on the number of rows allowed in the excel export. I get around this by providing an excel of Balance sheet accounts and then one for the income statment accounts. The auditors seem fine with this.
Printing to excel does not work, but what I do is preview the range then use the Export button to send the file to excel. The settings I use are:
- Format: "Excel 7.0 (xls)"
- Destiniation: "Application"
Then simply let the export do its thing and then go to the excel spreadsheet and save as an XLSX file and all is good.
Andrew: Auditors don't like change. They have a system that has worked in the past. Many don't care that we can give them a beautiful gridview table in excel. They just want their systems to work like they did "last year". I have made some auditors very happy by providing and excel spreadsheet from Gridview, others want what they always had.
_________________________
Thanks,
Ken Aberdeen,CPA, CMA
Aberdeen Business Consulting Ltd.
ken@aberdeenconsulting.ca