The "Standard column balances" report type displays the account debit and credit balances in the following three (3) reports, in one report:

1.Trial balance (Income, Expenses, Assets, Liabilities and Capital).

2.Income statement (Income and Expenses).

3.Balance sheet (Assets, Liabilities and Capital).

This is a breakdown of the Trial balance into the Income statement and Balance sheet.  

Once the report is generated, the following options are available:

1.Print - Click on the Print button to print the report.

2.Export - Click to export the data to a spreadsheet. 

3.T-Account viewer - Double-click on any of the amounts of an account to view the transactions. Only those transactions will be listed in the T-Account viewer matching the Periods selected on the Per period tab.    

Standard column balances options

To print a Standard column balances report:

1.On the Reports ribbon, select Ledger analyser 1 or Ledger analyser 2.

2.Select the “Standard column balances” report type.  

ledger-ananlyser-standard-column-balances-1

3.Select “Per period” to select a period (Month, 2 Months, 3 Months, 4 Months, 6 Months or Year). 

You may click on the “Free selection” tab. You may select or enter any date or dates, which you need to include the Standard column balances report.  

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

5."Include opening balances" - If this option is selected (ticked), it will include the opening balances of those accounts which have opening balances. If this option is not selected; the opening balances will not be included in the Standard column balances report.    

6."Opening balances only" - If this option is not selected; this option, in most cases, will not be displayed. If this option is available; you may select (tick) this option to include only the opening balances. All other balances will then be ignored. 

7."Budget" - Leave this option blank to include the actual posted (updated) transactions in the Standard column balances report.  

The "Budget" option, if selected, will list only the budget figures (Budget listing) in the Trial balance, Income statement, Balance sheet and Standard column balances report types (if budget figures were entered  in the Accounts option on the Action ribbon).   

8."Cost centre 1" and "Cost centre 2" - The Cost centres (2 Groups) will only be available, if Cost centres are added in Groups on the Setup ribbon; and if activated.

9.Click on the Report button. This will build or refresh the Standard column balances report with the selected options. 

Example : Standard column balances

An example of the "Standard column balances" report type, in the "Ledger analyser" screen, is displayed as follows: 

ledger-ananlyser-standard-column-balances-2

Printed example : Standard column balances

Click on the Print button.  An example of the printed "Standard column balances" report, is displayed as follows: 

ledger-ananlyser-standard-column-balances-3

To save the Standard column balances report as a PDF file:

1.On the "Reportman print preview" screen, select Save (Ctrl+S – This will launch the “Save Metafile As” screen. 

2.Select the directory (folder) where you need to save this file, if necessary. 

3.Enter a file name. 

4.Select the "PDF File – compressed" default file type.

5.Click Save.

Export to Spreadsheets

Export button for all Report types on Ledger analyser 1 / Ledger analyser 2 - 

You may save the export file as Text files (*.txt) (default file type); or as CSV files (*.csv) (Comma Separated Values) file type. This will automatically open (launch) the exported file in the program associated with the selected file type:

oText files e.g. (Export.txt) - This should automatically open the exported text file of your system's default text file program associated with Text file type (*.txt) file types (e.g. Notepad, etc). You need to close the exported text file and launch your spreadsheet program. In your spreadsheet program, Open the text file to launch the "Text Import" options.

oCSV files e.g. (Export.csv) - This should automatically open the "Text Import" options of your system's default spreadsheet program associated with Comma Separated Value file type (*.csv) file types (e.g. Microsoft Excel, Apache OpenOffice, LibreOffice, Ultra Office, etc.).