GL & Account Info. Panorama
Find out about business scenarios, data selection, report view options, and data definitions for General Ledger & Account Information Panoramas available under Budget & Finance in the Business Analytics Hub (bah.ucsd.edu).
Chart of Accounts Panorama
Hierarchies help define structure, and provide for standard and consistent financial reporting to our various stakeholders about UC San Diego’s financial performance and financial position over a specified period of time. The Chart of Accounts Panorama is designed to help you explore the UCSD Chart of Accounts and hierarchies.
COA Information
Business Scenarios
- What chart strings have been used for my Financial Unit?
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a table of 14 columns
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Entity
Business Scenarios
- The Managerial Reporting Account Hierarchy categorizes Accounts into Account groupings used in many UC San Diego internal financial management reports
- The Managerial Reporting Account Hierarchy is an essential component for reporting financial performance as it groups accounts into Resources, Expenses, Net Surplus/Deficit, and Total Balance which facilitates financial planning, analysis, benchmarking and decision making
- The Managerial Reporting Account Hierarchy reports the hierarchy structure for each Account and which Accounts are included at each level of the hierarchy
Data Selection and View Options
There are no parameters on this dashboard page
Report Views
- Results display in a table of 8 columns representing the entity categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Standard Fund Hierarchy
Business Scenarios
Data Selection and View Options
- The report is designed to show the full hierarchy
- To further refine the results use the available parameters to search the Fund
Report Views
- The results display in a table of 10 Columns representing the fund categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Managerial Reporting Fund Hierarchy
Business Scenarios
-
The Managerial Reporting Fund Hierarchy categorizes funds in fund groupings used in many UC San Diego internal financial management reports
- The Managerial Reporting Fund Hierarchy is an essential component for campus resource allocations, such as the Core funded portion of the campus budget
- The Managerial Reporting Fund Hierarchy reports the hierarchy structure for each fund and which funds are included at each level of the hierarchy
Data Selection and View Options
- The report is designed to show the full hierarchy
- To further refine the results use the available parameters to search the Fund
Report Views
- Results display in a table with a single section of 12 columns representing the fund categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
FinU (Financial Unit)
Business Scenarios
Data Selection and View Options
- The report is designed to show the full hierarchy
- To further refine the results use the available parameters to search the FinU
Report Views
- Results display in a table with a single section of 10 columns representing the FinU categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Standard Account Hierarchy
Business Scenarios
Data Selection and View Options
- The report is designed to show the full hierarchy
- To further refine the results use the available parameters to search the Account
Report Views
- Results display in a table with a single section of 14 columns representing the Account categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Managerial Reporting Account Hierarchy
Business Scenarios
-
The Managerial Reporting Account Hierarchy categorizes accounts into account groupings used in many UC San Diego internal financial management reports.
- The Managerial Reporting Account Hierarchy is an essential component for reporting financial performance as it groups accounts into Resources, Expenses, Net Surplus/Deficit, and Total Balance which facilitates financial planning, analysis, benchmarking and decision making.
- The Managerial Reporting Account Hierarchy reports the hierarchy structure for each account and which accounts are included at each level of the hierarchy
Data Selection and View Options
- The report is designed to show the full hierarchy
- To further refine the results use the available parameters to search the Account hierarchy
Report Views
- Results display in a table with a single section of 10 columns representing the Account categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Function
Business Scenarios
Data Selection and View Options
- The report is designed to show the full hierarchy
- To further refine the results use the available parameters to search the Function
Report Views
- Results display in a table with a single section of 4 columns representing the Function categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Program
Business Scenarios
Data Selection and View Options
- The report is designed to show the full hierarchy
- To further refine the results use the available parameters to search the Program
Report Views
- Results display in a table with a single section of 4 columns representing the Program categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Location
Business Scenarios
Data Selection and View Options
- The report is designed to show the full hierarchy
- To further refine the results use the available parameters to search the Location
Report Views
- Results display in a table with a single section of 4 columns representing the Location categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Project
Business Scenarios
Data Selection and View Options
- The report is designed to show the full hierarchy
- To further refine the results use the available parameters to search the Project
Report Views
- Results display in a table with a single section of 4 columns representing the Project categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Activity
Business Scenarios
Data Selection and View Options
- The report is designed to show the full hierarchy
- To further refine the results use the available parameters to search the Activity
Report Views
- Results display in a table with a single section of 4 columns representing the Activity categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Interentity
Business Scenarios
Data Selection and View Options
- There are no parameters on this page
Report Views
- Results display in a table with a single section of 4 columns representing the Interentity categories in hierarchical order from left to right
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
General Ledger Panorama
The General Ledger Panorama contains reports that pull from the General Ledger transaction tables. Designed to give you visibility into general ledger accounts, balances, transactions and activity.
General Ledger Transaction Details
Business Scenarios:
-
General Ledger Balances may be used to view your balances for a single to multiple Accounting Period for a given FinU or Fund or Account etc
-
What is the balance on an Account or FinU or Project including all transactions that hit the GL and all other subledgers
-
General Ledger Transaction Detail is a single space where users can view transactions that hit all ledgers: the General Ledger and each Subledger (PPM, Payables, Receivables, Cash Mgmt.)
-
What are the transactions that hit subledger for my Fin Unit or for my Project?
-
What are the transactions that hit GL directly?
-
If something hit the General Ledger, where did this come from?
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
Results display in 2 tables:
- General Ledger Balances table is displayed with 15 columns representing Beginning balance, Period Net Activity, Ending Balance with all chart of string segment values
Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
2. General Ledger Detail Transactions table displays results with 22 columns
Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Journal Approval
Business Scenarios
- To find the Journal Status
- Where the Journal is routed to and who will be approving
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
General Ledger ISIS Reconciliation
Internal Controls & Accounting Panorama
The Internal Controls and Accounting Panorama is intended for central office use of reporting and data.
Journal Voucher Report
Business Scenarios
Viewing Journal Batch/Journal Entry details similar to what was available in MyJournals tool
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Expenditure by Month
Business Scenarios
View period activity for a specific period of time for Account Code and Project when data is filtered for a Financial Unit or Fund
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Fund Summary
Business Scenarios
View Fund totals by Balance, Net Period Activity, and across the fiscal year, and subtotaled by Financial Unit
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Approval Group Members
Business Scenarios
View Approval Group Members by Name and User ID (sys18 ID)
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
General Ledger Transaction Details
Business Scenarios:
-
General Ledger Balances may be used to view your balances for a single to multiple Accounting Period for a given FinU or Fund or Account etc
-
What is the balance on an Account or FinU or Project including all transactions that hit the GL and all other subledgers
-
General Ledger Transaction Detail is a single space where users can view transactions that hit all ledgers: the General Ledger and each Subledger (PPM, Payables, Receivables, Cash Mgmt.)
-
What are the transactions that hit subledger for my Fin Unit or for my Project?
-
What are the transactions that hit GL directly?
-
If something hit the General Ledger, where did this come from?
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
Results display in 2 tables:
- General Ledger Balances table is displayed with 15 columns representing Beginning balance, Period Net Activity, Ending Balance with all chart of string segment values
Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
2. General Ledger Detail Transactions table displays results with 22 columns
Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
GL Journal Reports
View subledger transactions for Journal Entries
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Journal Approval Workflow
-
To find the Journal Status
- Where the Journal is routed to and who will be approving
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Balance Sheet
Consolidated Balance Sheet report for level 2 Account types
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Income Statement
Consolidated Revenue and Expense report for level 2 Account types
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Budget vs Actual
Trial Balance Campus
Summary Trial Balance report for all Entity and Period with filter for specific Entity
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Trial Balance by FinUnit
Summary Trial Balance report for a specific Financial Unit and Period
Data Selection and View Options
- Use these parameters to filter for the data you want to view
- These filters can be used in combination or individually to produce desired results
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
