Description
The Ledger Account by Dimension report is an analytical report used to review balances of Ledger Accounts against the user's choice of Dimension. This type of report can be insightful for insights such as comparing department Cost Centers by Expense categories, Revenue amounts per Customer, balances owed by Expense per Vendor, etc. The Ledger Accounts chosen for the report can be grouped by their Type, Report Groups, SubType, and the balances can be filtered by field values to be sure to display desired Ledger Account balances.
Report Configuration Settings
Location (Required)
Only balances from the selected Location are included (child locations excluded)
Defaults to the Location context picker
Date Range
Start Date: Include journal lines posted on or after this date
Defaults to the beginning of the current fiscal year
End Date: Include journal lines posted on or before this date
Defaults to the current date
Dimension Type (Required)
Select one Dimension to use as columns
Options:
Customer (default)
Vendor
Cost Center
Product
Job
Custom Dimensions
Dimension Selections (Required)
Multi select one or more from the Dimension Type selected (e.g. the Sales selection for the Cost Center Dimension)
Display Filters
Group the Ledger Accounts into buckets within the rows of the report (e.g. Expense SubTypes such as "Administrative Expense", "Other Expense", etc.)
Options:
Type
Report Group (default)
SubType
None - only show one list of Ledger Accounts
Filters
Once the report structure through configurations above is set, you can further impact the report by selecting one or more filters to define which journal lines should be considered for the Ledger Account balances. Filter options below:
Cost Center
Description
Intercompany Location
Ledger Account Subtype
Ledger Account Type
Location
Posted Currency
Posted Date
Transaction Date
Vendor
Columns
This report displays the following columns:
Column Header | Description |
Grouping | Summarization selection (e.g. Report Group, SubType, etc.) |
Ledger Account | Ledger Account Name and Number |
Selected Dimensions | One or more columns for selected Dimension Type and Dimensions |
Other | Balances for Dimensions not selected |
None | Balances for journal lines without a Dimension from the selected Dimension Type tagged |
Total | Sum for the entire Ledger Account based on the filters included |
Saving and Report Configurations
When the report configuration is complete, the report can be saved to be more easily accessed at a later date, with the following configuration saved:
Location
Start Date
End Date
Dimension Type
Dimensions selected
Row groupings
Filters
For information on saving report configurations, please refer to the Saving Report Configurations section in the Enhanced Reporting Overview article-->
Exports
The Ledger Account by Dimension Report will be exported in xlsx format.