When I print to an Excel file from the G/L, when I go to open the file I always get a message that says 'File Error: data may have been lost'. I can open the file, but even for shorter files after the first few pages all the debits and credits are in the same column, so it's impossible to read. I need to give an Excel printout to our auditors, and now I'm trying to go through the file and fix it - move the credit amounts to the correct column. Our G/L is 600+ pages though. Even just looking at the expense accounts, that's a lot of fixing. Is there any way I can get this to print correctly? It has to be an Excel file so they can use it for testing. Thank you.

Ask your auditors whether they use "Caseware" (almost all Canadian firm do). If so, then just give them an a backup of your Adagio Ledger data - Caseware can just retrieve the transactions they need, without you or they having to do any work at all. (OK, they would have had to read their manual.)

Otherwise there are many better ways to get information from Adagio into Excel. First, there's the File | Export menu choice that allows you to export all your transactions, budgets and Trial Balance.

Secondly, you can use the ExcelDirect button on the transaction inquiry screen or View | Transactions Budgets to get a Trial Balance.

I bet they are using Caseware though.

Thank you, they've got our ledger through Caseware.