Overview: A mapping report outlines which Active Ledger accounts are matched to which source accounts.
An account has a unique account number and name combination that Active Ledger tracks. It comprises one or more client accounting system accounts.
A source account however, is the general ledger account pulled from the clients accounting file.
Please refer to the Glossary for definitions of key terms used in this article.
Watch the video
Generating a mapping report
Navigate to the Reports screen and click on the Mapping Report tab.
The following dropdown fields/filters are required to be filled out to generate the report:
FIELD | DETAIL | VALIDATION |
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 Labels for | By selecting the dropdown, this will display any page layouts created within the Admin Centre, provided they have been assigned to accounts in the Accounts screen. | 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 |
Once the above sections are filled out accordingly, select Run Report.
This generates a list of all the Active Ledger accounts and their respective source accounts.
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.
