The column balances report types will list the transactions of accounts 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.

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

You may also click on the Export button of the T-Account viewer to export the transactions to a spreadsheet. 

You may select to 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:

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