Skip to main content
All CollectionsUser GuideFinancial Reporting
Enhanced Reporting - Ledger Account by Dimension
Enhanced Reporting - Ledger Account by Dimension
G
Written by Geoff Ostrega
Updated over 4 months ago

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

Ledger Account by Dimension Report config

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

Ledger Account by Dimension Report Filters

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.

Ledger Account by Dimension Report Export

Ledger Account by Dimension Report Export
Did this answer your question?