Hide NavigationShow Navigation

  • Contents
  • Index
  • Search
 
Show results that include all search words

 

GL Trial Balance Tree

The Trial Balance Tree is a complete list of all GL accounts split between Profit & Loss and Balance Sheet accounts. It allows you to scroll down the list of accounts and select the one you require.

It is useful for creating a dynamic trial balance report; additionally it's used to review transactions, primarily by account and period range.

To view a GL Trial Balance, select Reports > General Ledger Reports > GL Trial Balance Tree. The Trial Balance Tree window opens:

Select the options on the window. The following table provides more information.

Item

Description

Load

Clicking this button loads the Trial Balance tree relative to the options selected in the View and Range configuration area.

Expand All

Collapse All

The transactions in the grid are listed by account name. Adjacent to this is a group total. To view the details and subtotals of this account it needs to be expanded, as illustrated for current assets above. This button expands all the accounts, this action can be undone by clicking the Collapse All button.

View Transactions

Clicking this will open the transaction details window for a selected account from the tree.

Note: This has to be an individual account from an expanded account group.

View:

Trial Balance

With this option selected clicking the load button loads the trial balance details into the tree view.

 

Profit and loss A/cs

With this option selected clicking the load button loads the profit and loss accounts details into the tree view.

 

Balance Sheet A/cs

With this option selected clicking the load button loads the Balance Sheets accounts details into the tree view.

Range:

Use account Balances

 

 

YTD at:

A check if you want the tree to display the values for the entire year.

 

Age from:

The period range for which you require the list of GL accounts. This option is available only if you have not selected the YTD Values option.

Use account group report codes

Enable this option to display the Rep code total column. (You must click Load again to refresh the display after enabling this option.)

Use sub accounts

This is only available if the Range is set to a date Range and not sorted by balances. Enabling this option adds the Sub acc dr and Sub acc cr columns. (You must click Load again to refresh the display after enabling this option.)

Branch

Only available when sub accounts is ticked. Choose the branch from the list to filter by branch. Click Load to view the sub account totals.

Company

Only available when sub accounts is ticked. If available, choose the company from the list to filter by company. Click Load to view the sub account totals.