Dimensions - Total (report)

The Dimensions - Total report shows calculated general ledger (G/L) balance totals for the dimension levels you specify for a given period.

You specify dimension levels by selecting an analysis view configured with dimension codes, and then creating a hierarchy of dimension groups by arranging them under one another.

You can select an Analysis View with a column layout that includes budget figures. This view shows general ledger actuals vs. budgets for each dimension level.

You can select an analysis view with a cash flow account source and choose Cash Flow Forecast No. to analyze forecast entries by dimension level. The column layout determines the figures shown; selecting a cash flow analysis view doesn't automatically provide an actual-versus-forecast comparison.

Enter Analysis View Code, Column Layout Name, and Date Filter, and use Include Dimensions to arrange the grouping levels. Turn on Print Empty Lines to include zero-balance combinations.

Use cases

Analyze your general ledger with dimension totals by building groups of dimensions for combinations of dimension values, and calculate a general ledger balance total for each segment.

Financial analysts can use the report to:

  • Analyze financial performance by reviewing the general ledger balance totals for different dimensions, such as department, project, or location.
  • Identify areas to save cost or generate revenue, and make recommendations for improving financial performance.
  • Use the report data to prepare financial reports for stakeholders such as investors or executives.

Financial accountants can use the report to:

  • Use the report data to prepare financial statements, such as income statements, balance sheets, and cash flow statements.
  • Verify the accuracy of the financial data by ensuring that the general ledger balance totals for different dimensions are correct and balance.
  • Identify discrepancies or errors in financial data and investigate them.

Financial controllers can use the report to:

  • Monitor the financial health of the business by reviewing the general ledger balance totals for different dimensions, such as department, project, or location.
  • Identify areas to save cost or generate revenue, and make recommendations for improving financial performance.
  • Use the report data to prepare financial reports for internal and external stakeholders such as board members or regulatory agencies.

Try the report

Try the report here: Dimensions - Total

Tip

If you hold down the Ctrl key while you select the report link, the report opens on a new browser tab. The new tab lets you stay on the current page while you explore the report on the other browser tab.

Built-in key finance reports
Ad hoc analysis on finance data
Financial analytics overview

Find free e-learning modules for Business Central here