The Column balances report type will list the net balances (debits minus credits) for the general ledger accounts (i.e. Income, expenses, Bank accounts, Tax accounts and other ledger accounts reported in the Balance sheet. 

This report type cannot be printed but can be exported to a spreadsheet (e.g. OpenOfficeCalc / LibreOffice Calc or Microsoft Excel, etc.).

You may also generate the transactions in a spreadsheet format in the Column balances D/C report types on the T-Ledger analyser. These transaction totals may be exported to an "Export.txt file and opened in a spreadsheet. 

You may select an account and double-click on a specific period to list and view the transaction details in the T-Account viewer. You may be print or export the transactions. 

This will list the following account types: 

  • Income / Expense. 
  • Balance sheet - Assets, Liabilities and Capital. It includes the following account types, i.e.: 
    • Bank accounts 
    • Tax accounts 
    • Retained income / earnings. 
    • Creditor's control account. 
    • Debtor's control account. 

This report type will list all General ledger accounts (including disabled accounts) by account code. 

Pivot – View, filter and analyse your report on screen, view graphs, customise datasets and types of graphs.

Zoom in / Zoom out + / - buttons added to resize (increase / decrease the font) the reports (i.e. Trial balance, Balance sheet and Income statement) on screen. This is not implemented for the Column balances report types. 

When you Export these Column balances report types, you may use the zoom features of your spreadsheet app. 

If the "Ignore zero balances" field is selected (ticked); it will list only those accounts with balances.

If the "Ignore zero balances" field is not selected (not ticked); it will all accounts with balances as well as zero balances. 

The accounts will be listed in the following columns: 

  • Opening Last Year - The totals for opening balances of the previous year. 
  • Last Year Periods 1 to 12 - the totals of transactions entered or posted to the previous year. 
  • Period Total - Total for each period (Period 1 -12). 
  • End Last Year - Total for Last Year Opening Balances and the totals for each period (Period 1 -12). 
  • Opening Balance This Year - This should be the same as the Total for Last Year. 
  • Period Total - Total for each period (Period 13 -25). 
  • End Last Year - Total for This Year Opening Balances and the totals for each period (Period 13 -25). 

T-Ledger viewer

You may select an account and double-click on a specific period to list and view the transaction details in the T-Account viewer. You may be print or export the transactions. 

In this example,the T-Account-viewer is is launched by a double-click on April (This year) in the Sales account row: 

Show contra - By default this option is not selected. 

If the Show contra is selected, it will insert (add) the Account code and Description before the batch id (batch number). 

The Contra accounts will not print on the T-Account viewer ("ledgerdetail") report; but will be included in the Export file when you click on the Export button of the T-Account viewer. 



To create a T-Account viewer - Export report: 

  1. On the Reports ribbon, select Ledger analyser 1 or Ledger analyser 2. 
  2. Select the "Column balances" report type.  Once finished, selecting your options, click on the Report button to build, update or refresh the data for the selected report type on the Ledger analyser screen. 
  3. Click on the Export button. This will launch the "Save as" screen.

 

  1. Select the folder in which you wish to save the file.
  2. The default file name will be "Export.txt". Overtype this with your own name.

 If you do not enter and save the Export.txt file name, you may replace existing (previously exported) files. 

Of an existing exported file is opened, and you are trying to save a export file with the same name, a similar error message as the following will be displayed:

Cannot create file "D:\TCASH5.2\Backups\output\Export.txt". The process cannot access the file because it is being used by another process. 
  1. Click on the Save button. 

  1. This will automatically open (launch) the file in your system's default text editor program associated with text files.  In this example, the exported text file is opened with "Notepad". Comma Separated Value file type (e.g. Microsoft Excel, LibreOffice Calc, OpenOffice Calc, Ultra Office, etc.). 

Save As - Export file types:

When you click on the Export button, you have a choice of two file types to save an Export file:

  • Text files - Export.txt - This is the default option. Once the export file is saved as a exported text file it automatically opens (launch) the exported text file in your system's default text editor program associated with text files (e.g. "Notepad"). 
    • You need to close the text file and launch your favourite spreadsheet program. 
    • Open the saved exported text file . 
    • On the "Text Import" screen of your spreadsheet program, the default options is already pre-set. Change this is necessary.
  • CSV files - Export.csv - If you select this file type; the export file is saved as a exported text file it automatically opens (launch) the exported CSV (Comma Separated Value) file type in your system's default spreadsheet program (e.g. Microsoft Excel, LibreOffice Calc, OpenOffice Calc, Ultra Office, etc.). the "Text Import" screen of your spreadsheet program.
    • The "Text Import" screen of your spreadsheet program is automatically launched with the default options already pre-set. Change this is necessary.
  1. If the Text file type was selected and the exported text file was launched in another program (e.g. "Notepad") close the text file. 
  2. Launch your favourite spreadsheet program (e.g. "Microsoft Excel, LibreOffice Calc, OpenOffice Calc, Ultra Office", etc.) and Open the exported text file. 
  3. The "Text Import" screen of your favourite spreadsheet program  (e.g. "Microsoft Excel, LibreOffice Calc, OpenOffice Calc, Ultra Office", etc.), will be launched. In this example "LibreOfficeCalc" is used.

 

  1. On the "Text Import" screen, the default options should already be pre-set. You may use the scroll bars to preview the exported data in the rows or columns and change it, if necessary.  
  2. Click on the OK button. The data should be imported into the spreadsheet as follows:


Export button