You may import the transaction totals, which have been posted (updated) to the ledger, into a spreadsheet.

To import posted transactions for This year into a spreadsheet: 

  1. On the Reports ribbon, select Spreadsheet reports → General ledger → Column balances → This year. The transaction totals for each of this year periods will be listed in the "Settings" sheet of the spreadsheet:

  1. To view the transaction totals for each account, click on the "Column balances" sheet of the spreadsheet:

This spreadsheet lists the totals for the main account as well as sub-accounts. In this example (period for full year), note the following:

210000 - Motor vehicle - main account =  2,160.00  - The total of the following sub-accounts:

210010 - Fuel and oil - sub account      =     150.00 

210020 - Maintenance - sub account    =     810.00 

210030 - Repairs - sub account              =  1,200.00 

The "Column balances" sheet of the spreadsheet will summarise the total of the posted transactions for each general ledger account in the following columns:

  • Period 0 (Opening Last Year) - The totals of the opening balance totals for the previous year.
  • Periods 1 to 12 - The totals of the posted transactions in the respective periods for this year.
  • Total - Total for each period (Period 1 -12) plus Period 0.