The T-Account viewer may be launched (for specific transactions or periods) from the Ledger analyser 1 or Ledger analyser 2 options on the Reports ribbon (right-click or double-click on specific accounts or groups). 

Column balances - The column balances report types will list the transactions of a selected account for each period of Last year and This year in a spreadsheet format. 

You may select an account and double-click on any period. This will launch the T-Account viewer with a list of all the transactions for the selected period. You may be print and / or export the transactions. 

The following six (6) column balances report types is available:

  1. Column balances - Lists all ledger account balances in a spreadsheet view. These are the ledger accounts reported in the Trial balance (this includes both the accounts reported in the Income statement and Balance sheet).
  2. Column balances debtors - Lists the balances of all the individual debtor (customer / client) accounts (Debtors on the Default ribbon) in a spreadsheet view. The total of these accounts are reported in the Debtor's control account on the Trial balance and the Balance sheet.
  3. Column balances creditors - Lists the balances of all the individual creditor (supplier / vendor) accounts (Creditors on the Default ribbon) in a spreadsheet view. The total of these accounts are reported in the Creditor's control account on the Trial balance and the Balance sheet.
  4. Column balances D/C - Lists all debit and credit ledger account balances in a spreadsheet view. These are the accounts reported in the Trial balance (this includes both the accounts reported in the Income statement and Balance sheet).
  5. Column balances debtors D/C - Lists the debit and credit account balances of all the individual debtor (customer / client) accounts (Debtors on the Default ribbon) in a spreadsheet view. The total of these accounts are reported in the Debtor's control account on the Trial balance and the Balance sheet.
  6. Column balances creditors D/C - Lists all debit and credit balances of all the individual creditor (supplier / vendor) accounts (Creditors on the Default ribbon) in a spreadsheet view. The total of these accounts are reported in the Creditor's control account on the Trial balance and the Balance sheet.

In addition to this, the T-Account viewer may also be launched separately on the Reports ribbon; or from the following options on the Default ribbon:

  1. Search - Investigator - Account or Batch type searched items.
  2. Debtors - Transactions tab - Click on the Show transactions button. 
  3. Creditors - Transactions tab - Click on the Show transactions button.

Example : Transactions in T-Account viewer 

Once transactions is generated and or filtered in the T-Account viewer, an example of the transactions is as follows: 

ledger-analyser-column-balances-t-accont


Example : Print - Transactions in T-Account viewer 

Click on the Print button to print the report.

ledger-analyser-t-account-debtor-print

Export transactions in T-Account viewer 

  1. Click on the Export button (on the T-account-viewer). The "Save As" screen will be displayed: 

ledger-analyser-export-save-as-file-type

  1. Select the file type. Text files (*.txt) is the default; or select CSV files (*.csv) (Comma Separated Values). 
  2. Click on the Save button. This will automatically open (launch) the exported file in the program associated with the selected file type:
    • Text 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.
    • CSV 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, LibreOffice Calc, OpenOffice Calc, Ultra Office, etc.). 

To open the exported - Export.txt file in a Comma Separated Value (*.csv) file: 

You may also open the exported file using "Windows Explorer" (or your "File Browser" program). 

If the Comma Separated Value file type (*.csv) file type for the exported file does not automatically launch in a spreadsheet program; or the incorrect program, you may change this. To do this; you need to: 

  • Select the saved *.csv file. 
  • Right-click on it and select the Open with option on your system's context-menu. 
  • If your program is not listed as one of the Recommended programs on your system's context-menu, select the Choose Default Program... option. On this screen, select your default program (e.g. Microsoft Excel, LibreOffice Calc, OpenOffice Calc, Ultra Office, etc.). You may need to click on the Browse button to do this. 
  • Make sure that the Always use the selected program to open this kind of file option is selected (ticked), and click on the OK button. 
  1. The "Text Import – [Your File name]" screen will be displayed.

export-t-account-debtors-spreadsheet-text-file

Open the Export.txt file in a spreadsheet 

export-t-account-debtors-spreadsheet-open-txt

Text Import options

export-t-account-debtors-spreadsheet-import

If you select the "Merge delimiters" options on the "Text Import - [Name of your file.txt (or csv)]", the Debit and Credit totals will be merged into the Debit column. 

To export the Debit and Credit totals in separate columns, do NOT select the "Merge delimiters" option. 

Spreadsheet view

export-t-account-debtors-spreadsheet