Article Objective: To assist users in navigating the Active Platform with generating an itemised transaction report for a particular account or all accounts. Context: Users are able to generate an itemised transaction report in the general ledger section of Active Ledger. Please refer to the Glossary for definitions of key terms used in this article. TABLE OF CONTENTS |
Generating a ledger report
Select the relevant dataset, navigate to the Reports screen and click on the Ledger tab.
The following fields are required to be filled out to generate the report:
Field | Detail | Validation |
|---|---|---|
| Source Accounts | This is the general ledger account which will be included in the report. More than one account can be selected. Note: If you wish to select all accounts, click the checkbox to Select all Accounts. | At least one account is required |
| Display | This field will limit the transactions displayed. See 'List of display types' below for more information. The system defaults to the 'Normal' type. | 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 (inside the date range of the dataset) |
| End Date | Automatically populated as the end date of the dataset. | Required (inside the date range of the dataset) |
| Download ledgers from Xero (checkbox) | Checking this box will establish a connection with the source and import the individual account transactions. Note: This feature is only available for cloud accounting sources supported by Active, including Xero, MYOB, QBO, etc. | Optional |
List of display types:
| Display Type | Description |
|---|---|
| Normal | Includes all transactions |
| Imported | 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 that have been sent to the client file |
Once the above sections are filled out accordingly, select Run Report.
Searching
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: Datasets - 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 - reports - trial balances.