Once an "Export.txt" file is created, the exported file will automatically open in Microsoft Excel spreadsheet (as in this documentation). 

If you wish to open saved "Export.txt" files in another app (program) for CSV (Comma Separated Values) file type, than Microsoft Excel, you may use the spreadsheet components of other apps (programs)  e.g. LibreOffice, OpenOffice or UltraOffice installed on your system. 

See - System settings - Default app for csv file types.

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 

In this example, the T-Account viewer is launched by a double-click in the month (accounting period) "June" in the "G700000 Debtors control" account: 

 

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. 

Print transactions in T-Account viewer

Click on the Print button to print the selection in the T-Account viewer.

Export transactions in T-Account viewer 

To create an Export file for transactions in the T-Account viewer:

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

  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.). 

Opened in a Text editor - Notepad 

An example, of the "Export.txt" file opened in your systems default program associated with *.txt files  (e.g. "Notepad") is as follows:

Open the Export.txt file in a spreadsheet 

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. 

Locate the "Export.txt" file in your System's File Explorer

If LibreOffice and not LibreOffice Calc is selected, the "Export.txt" file will open in LibreOffice Writer as a text file.

In this example, Open with > LibreOffice Calc is selected. The "Text Import" screen is selected.  

Separator options - Separated by 

  • Comma - Do not select this option. If you have selected "Show contra" option on the T-Account viewer, the Contra accounts will be included in the exported file as column A (e.g."G010000 Sales,T860010 Output VAT - 15%"). If the "Comma" option is selected, it will export the Contra accounts into 2 columns. The rest of the columns would be out of line with the column headings.
  • Merge delimiters - Do not select this option. If you select the "Merge delimiters" option, the Debit and Credit totals will be merged into the Debit column. 

Select your options and click OK. The selected "Export.txt" file will be opened in LibreOffice Calc spreadsheet. 

Spreadsheet view