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

To access the T-Account viewer: 

1.On the Reports ribbon, select T-Account viewer. The "T-Account viewer" screen is displayed: 

Show contra - This option is not implemented in TurboCASH5 (969). This option is implemented in TurboCASH5.2.  

2.Select the following options: 

a)Account - Select the Account on the "Lookup", if this field is available.

The Account option will only be available, if the T-Account viewer is  launched from theT-Account viewer on the Reports ribbon).

The Account lookup option is not available, if the T-Account viewer is launched from elsewhere. 

b)From date and To date - Enter or select the dates on the date picker.  

Each time you access the T-Account viewer from the Ledger analyser, it will create a shortcut button (numerical). You may then click on any of the 1, 2, 3, 4, 5 buttons, etc. to view your previous T-Account viewer selections. 

These shortcuts will only be cleared, if you: 

Close and re-open the Set of Books 

Close active forms (Tools menu on the Setup ribbon) 

3.The "From date" and "To date" fields will automatically be filled in with the date selected on the Ledger analyser report options. It will only include transactions for these dates. You may enter or select any other dates, if necessary. 

If you have selected the Column balances report types, and you click on the period columns, the dates for the selected period column will automatically be selected. 

4.You may also use the following options to get specific views of transactions: 

a)Batch number (e.g. 10045 automatically generated). This will list only the transactions for a specific batch (journal). 

b)Account code (e.g. G010000 Sales account, etc.). This will list the transactions for a specific account.

c)Date – This will list the transactions for a specific date. If you double-click on a date, the "From date" and "To date" will be changed to the selected date.

5.You may Print the transactions or Export the transactions and open the transactions in a spreadsheet. 

6.Once finished, click on the Close button to exit (close) the "T-Account viewer" screen. 

The T-Account viewer may also be accessed from the Search (Action ribbon). Once an account is listed, and selected, double-click on it. 

t-account-viewer-print