The Column balances report type lists the balances per accounting period for the ledger accounts (listed in the Trial balance (or Income statement and Balance sheet)) in a spreadsheet view in the Ledger analyser.  

It will list the totals of the account balances for each accounting period in last year and each accounting period in this year. 

To generate the Column balances report:

1.On the Sidebar, select Ledger analyser 1 or Ledger analyser 2. (Tools → Ledger analyser menu).  

2.Select the “Column balances” report type. 

3."Ignore zero balances" - If this field is not selected, all accounts will be listed for the Trial balance. If you select (tick) this field; only those accounts with balances will be included in the Trial balance.  

4.Click on the Report button. This will build the data into the accounting periods for selected year and the previous year. 

You may double-click on any of the periods (e.g. March to February in Last Year or March to February in This Year) to view the list of transactions in the T-Account viewer for the specific period. These transactions may be printed or exported, if required. 

To export the "Column balances" report type:

1.Click on the Export button. The Export text file will automatically be opened in the default program or app associated with text files. In this example, it is opened with Notepad. 

2.Close the text file. 

3.Launch a spreadsheet program. In this example, LibreOffice Calc is used to illustrate opening the exported text file as a Comma Separated Value (*.csv) file.    

4.Open the saved exported text file in the Spreadsheet program. The "Text Import" options will be displayed:

5.Select the options as per above "Text Import" screen. 

6.Click OK. The exported data of "Column balances" report type will be imported into the spreadsheet. The example is as follows:

The details in the spreadsheet, is as follows:

First six (6) rows displays the parameters, such as the date on which this export file is created, financial year, etc.  

The data in the columns from row 7 onwards, is as follows: 

Column(s)

Description of data

A

Account code

B

Account name or account description

C

Blank

Opening Balance Last Year - Period -1 

E to P

Periods - This is last year periods - usually 1 to 12 (depending on the number of periods and descriptions specified and entered in the Setup → System parameters → Reporting dates menu). 

Q

Blank on Column balances report type in Ledger analyser - 0 in spreadsheet.

R

Period Total - The total of the period totals for last year.

S

End last year -  Opening Balance Last Year total and the Period Total. 

T

Opening This Year -  Period 0 - This should be the same as the End Last Year totals.   

U to AF

Periods - This is the current year (this year) periods - usually 14 to 25 (depending on the number of periods and descriptions specified and entered in the Setup → System parameters → Reporting dates menu).  

AG

Blank on Column balances report type in Ledger analyser - 0 in spreadsheet.

AH

Period Total - The total of the period totals for this year. 

AI

End This Year - Opening Balance This Year total and the Period Total (This Year).