Datasets - Balances - Ledger

The General Ledger section allows you to generate an itemised transaction report from a particular account. 

The following fields are required to generate the report:

Source AccountsThis is the general ledger account which will be included in the generated report. More than one account can be selected. At least one account is required
DisplayThis field will limit the transactions displayed.
See * below for a list of all available display types.
Account TypeFilters the displayed transactions based on where the account originated.Two Options:
Account - Includes all transactions within all accounts, including Active Ledger generated accounts
Source Account - only includes transactions from accounts imported into the system
Start DateAutomatically populated as the start date of the dataset.Required (inside the date range of the dataset)
End DateAutomatically populated as the end date of the dataset.
Required (inside the date range of the dataset)
Download ledgers from API (checkbox)Checking this box will establish a connection with the source and import the individual account transactions.Only available for certain connections.

* all available Display types 

Display TypeDescription
Includes all transactions
ImportedOnly 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
ExportedOnly includes Active Ledger generated journals that have been sent to the client file
Balancing Only includes consolidated Active Ledger generated journals that have been sent to the client file

A sample of report settings may look like the following:

To generate the report click on the Run Report button.


To search through a 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 knowledge article: Filtering and Formatting within Active Ledger.

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: Exporting via the right-click menu DOES NOT update the status of the journal, this needs to be done using the 'Exporting journals tagged 'Pending Export' methods described in the knowledge article: Datasets - Balances - Trial Balances. 

Next article: Datasets - Balances - Tax Forms

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.