General Ledger - Global dashboard
The General Ledger - Global dashboard provides an overview of the General Ledger at company level. By monitoring the number of transactions and recorded amounts expressed in Third Currency, a finance manager or controller can analyze the financial state of the business for the entire company and specific divisions.
This dashboard can answer these business questions:
- How much is the current bank and cash balance and what is the trend over 12 months?
- What division has the lowest bank and cash balance?
- Which accounts have the largest recorded amount for company and per division?
Note that this dashboard only supports a unified Third Currency.
Reports and KPIs
The dashboard contains these reports:
- Bank and Cash Balance Trend
- Number of Transactions by Division
- Recorded Amount in Third Currency by Account
- Accounts by Division Details
The report Recorded Amount in Third Currency by Account is displayed in the dashboard as Recorded Amount by Account. The report title for Accounts by Division Details is disabled in the dashboard.
- Bank and Cash Balance
- Bank and Cash Transactions
- Total No. of Transactions
These KPIs use the accounting date as the date basis for analysis. The Third Currency is displayed together with the Bank and Cash Balance KPI.
Currency information is also displayed on the dashboard.
Filters
- Division (Config. 2)
- Time (Config. 2)
- Year/Month
- Account (Config. 2)
- Account Type
- FAM Entry
- GL User
- GL Authorizer
- Transaction
- Show N Records
- Trellis
The Year/Month filter is a mandatory filter that is applied in the Bank and Cash Balance KPI and in the Bank Cash Balance Trend and Accounts by Division reports. The Time filter is a mandatory filter that is applied in the Bank and Cash Transactions and Total No. of Transaction KPIs and in the Number of Transactions by Division and Recorded Amount by Account reports. The Year filter in the Time filter shows up to current year + 1. The Year/Month filter shows up to current year/month + 6 months.
The Trellis filter is a mandatory filter that is applied in the Recorded Amount by Account report to enable analysis of the report by Company or by Division. This filter is defaulted to Company. Note that transactions for the consolidation division are included.
The Show N Records filter is a mandatory filter that is applied to the Number of Transactions by Division and Recorded Amount by Account reports.
Drill across
From the Number of Transactions by Division report, you can drill across to the General Ledger - Local dashboard. When you select a Division from the report, the filter values are passed to the target dashboard together with the selected Division.