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.

This report only includes batch and document transactions which are posted. Unposted batches and documents will be NOT be included in this report.

To view a list of unposted batches and documents, which is not updated to the ledger, go to Input → Checking unposted items (Default ribbon).

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: