Overview: Users are able to generate a trial balance report which can be filtered by the transaction display types.
Please refer to the Glossary for definitions of key terms used in this article.
Watch the video
Generating a trial balance report
Select the relevant dataset, navigate to the Reports screen and click on the Trial Balance tab.
The following dropdown fields/filters are required to be filled out to generate the report:
FIELD | DETAIL | VALIDATION |
Debit/Credit, Opening and Movements, or Adjustments | To the right of the search bar, you can select whether you would like the report to show:
| Required |
Display | This field will limit the transactions displayed. | Required |
Account Type | Filters the displayed transactions based on where the account originated. There are two options:
| Required |
Start Date | Automatically populated as the start date of the dataset. | Required (must be inside date range of the dataset) |
End Date | Automatically populated as the end date of the dataset. | Required (must be inside date range of the dataset) |
Show Account (checkbox) | By selecting this checkbox, it will display both the accounts in Active Ledger as well as their respective source accounts. | Optional |
Show Tree View (checkbox) | By selecting this checkbox, it will display accounts in a heading format, splitting out revenue, expenses, assets, liabilities and equity, as well as further breaking down individual accounts under their respective headings. | Optional |
List of display types:
DISPLAY TYPE | DESCRIPTION |
Trial balance | Includes all transactions from all sources. |
Imported balances | Only includes transactions and journals which were imported from the client file. |
Not exporting | Only includes Active Ledger generated journals used for presentation purposes. |
Pending export | Only includes Active Ledger generated journals which will be sent to the client file. |
Exported | Only includes Active Ledger generated journals that have been sent to the client file. |
Balancing | Only includes consolidated Active Ledger generated journals which have been sent to the client file. |
Once the above sections are filled out accordingly, select Run Report.
Searching
To search through the generated report start typing in the search field as demonstrated below. This is a live search field so pressing enter is not required.
For more information on filtering and formatting generated reports see the support article: How to use the filtering and formatting features within reports.
Right-click menu
To access the right-click menu, use your mouse to right-click anywhere on the generated report to bring up the following menu options.
Note: Clicking Export via the right-click menu DOES NOT update the status of the journal or export it back to the source. See the support article: How to export a balancing journal for more information on this.