You may import the transaction totals (for accounts linked to the Reporting group 1), which have been posted (updated) to the ledger, into a spreadsheet.

To import posted transactions for reporting group 1 into a spreadsheet: 

  1. On the Reports ribbon, select Spreadsheet reports → General ledger → Column balances → Reporting group 1. The transaction totals linked to the Reporting group 1 will be listed in the spreadsheet: