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
• Filters
• Columns
• Saving and Report Configurations
• Exports

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:

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.