Global Ledger dashboards and reports

To access Global Ledger reports, select Global Ledger > dashboard name.

These dashboards are based on the Global Ledger subject area

GL Report Home Page

This Home page dashboard contains embedded filters for different categories which are set to default values and can be selected based on the requirement.

The embedded filters are:

  • Finance Enterprise Group
  • Reporting Basis
  • Fiscal Year
  • Fiscal Month
  • Accounting Entities

Balance Sheet

The Balance Sheet dashboard has a report which summarizes a company’s assets, liabilities, and equity.

Presented in tabular form, the report is a financial statement that provides a snapshot of what a company owns and owes, and the amount invested by shareholders.

The filters used for slicing data are:

  • Accounting Entities
  • Calendar
  • Chart of Accounts
  • Finance Enterprise Group
  • Fiscal Month
  • Fiscal Year
  • Ledger
  • Override Balance Sheet Level
  • Reporting Basis Accounting Entity List
  • Reporting Basis Ledger List

Account Trial Balance

The Account Trial Balance dashboard is a bookkeeping worksheet where the balance of all ledgers are displayed.

Compiled into debit and credit account column totals, the report lists the accounts in the general ledger and the balance of each account.

By clicking Ending Balance, you are redirected to the Detail Trial Balance dashboard which shows the balances in detail.

The filters used for slicing data are:

  • Account Level 01
  • Account Level 02
  • Account Level 03
  • Account Level 04
  • Accounting Entities
  • Calendar
  • Chart of Accounts
  • Finance Enterprise Group
  • Fiscal Month
  • Fiscal Year
  • GL Measure Amounts
  • Reporting Basis Accounting Entity List
  • Reporting Basis Ledger List
  • System Code

Actual To Budget Analysis

The Actual To Budget Analysis dashboard has a report which displays the difference between the budgeted and actual values.

The filters used for slicing data are:

  • Calendar
  • Chart of Accounts
  • Finance Enterprise Group
  • Reporting Basis Accounting Entity List
  • Reporting Basis Ledger List
  • Ending Fiscal Month
  • Budget Scope
  • Budget
  • GL Measure Amounts
  • Number of Months
  • Accounting Entities
  • Net Income Level 01
  • Net Income Level 02
  • Net Income Level 03
  • Net Income Level 04

Detail Trial Balance

The Detail Trial Balance dashboard has a report that displays balances in detail.

By clicking Amounts, you are redirected to the Monthly Transactions Detail dashboard which provides transaction detail by account.

The filters used for slicing data are:

  • Account
  • Accounting Entities
  • Calendar
  • Chart of Accounts
  • Finance Enterprise Group
  • Fiscal Month
  • Fiscal Year
  • GL Measure Amounts
  • Reporting Basis Accounting Entity List
  • Reporting Basis Ledger List
  • System Code

Finance Dimension Trial Balance

The Finance Dimension Trial Balance dashboard has a report which is a dynamic listing of the accounts in the general ledger and the balance of each account in the appropriate debit or credit column. The debit and credits are displayed dynamically for attributes that were selected.

By clicking Ending Balance, you are redirected to the Detail Trial Balance dashboard which provides revenue and expense transaction details by account.

The filters used for slicing data are:

  • Account Level 01
  • Account Level 02
  • Account Level 03
  • Account Level 04
  • Finance Dimension Selector 01
  • Accounting Entities
  • Calendar
  • Chart of Accounts
  • Finance Enterprise Group
  • Fiscal Month
  • Fiscal Year
  • GL Measure Amounts
  • Reporting Basis Accounting Entity List
  • Reporting Basis Ledger List
  • System Code

Inter Entity Transactions

The Inter Entity Transactions dashboard has a report that displays inter entity transactions.

The fields in the report are:

  • Accounting entity
  • Account
  • System
  • Journal control
  • Posting date
  • End date

The filters used for slicing data are:

  • Accounting Entities
  • General Ledger Event
  • Calendar
  • Chart of Accounts
  • Finance Enterprise Group
  • Fiscal Month
  • Fiscal Year
  • System Code
  • Reporting Basis Accounting Entity List
  • Reporting Basis Ledger List

Income Statement

The Income Statement dashboard has a report that displays statement for net profit, including details of expenses and revenue.

It is one of a company’s core financial statement that shows their profit and loss over a period of time. The profit or loss is determined by taking all revenues and subtracting all expenses from both operating and non-operating activities.

The filters used for slicing data are:

  • Accounting Entities
  • Calendar
  • Chart of Accounts
  • Finance Enterprise Group
  • Fiscal Month
  • Fiscal Year
  • Override Income Statement Level
  • Reporting Basis Accounting Entity List
  • Reporting Basis Ledger List

Monthly Transactions Detail

The Monthly Transactions Detail dashboard has a report which displays revenue and expense transaction details by account.

This report works only when we drill from detail trial balance dashboard. There are links to this report from detail trial balance dashboard.

By clicking Amounts, you are redirected to Monthly Transactions Detail dashboard which provides revenue and expense transaction details by account. This report shows the details by account such as .

The fields in the report are:

  • Transaction date
  • Document number
  • Vendor number
  • Vendor name
  • Resource
  • Create date
  • Create actor
  • Units Amount
  • Transaction Amount
  • Functional Amount
  • Report Amount 1