Is there software support available that would help with pulling previous year's detailed GL data into table format in excel?

Hi Sue

There are a number of ways to do it. Only one of them involves special software.

If you want just one account, you can do it by viewing the account for that year and exporting the activity to Excel using the DirectExport button (the green X).

If you want a range of accounts and are willing to do some cleanup in Excel, preview the Detail Listing report and export the previewed report to Excel, using a "Data Only" format.

You can drilldown to the underlying detail from a financial statement, so if you create a financial statement with a row that includes all the accounts you want, and a column that displays YTD, you can do a Tx Detail drilldown and then export the results to Excel.

Finally, Adagio GridView is a report writer designed to export any Adagio data to Excel, and the report you want is an easy one to create, so that would be the ultimate solution.

Steve

Hi Sue,

Steve forgot one - using File | Export | Transactions.

But if this is to create an import file for your auditors, ask them if they use "Caseware" (which almost all accounting firms in Canada use). If so, then the easiest way to get them the information they want is to use File | Backup | Ledger data and hend them the ZIP file on a USB key (or email it to them). They can load you entire GL into Caseware from the File | Retrieve accounting data | Adagio menu choice in Caseware.

No muss. No fuss.