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.
Related information
Built-in key finance reports
Ad hoc analysis on finance data
Financial analytics overview