Skip to main content

System Status: 

Internal Controls & Accounting Panorama

The Internal Controls and Accounting Panorama is intended for central office use of reporting and data.

The Internal Controls and Accounting Dashboard is available from the Business Analytics Hub (bah.ucsd.edu) under the Central Offices tab.

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

    journal-voucher_p.png

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-voucher_rv.png

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

    expenditure-by-month_p.png

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_rv.png

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

    fund-summary_p.png

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_rv.png

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

    approval-group-members_p.png

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_rv.png

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

gltd prompt

Report Views

Results display in 2 tables:

  1. 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

gltd balances

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

 

gltd transactions

GL Journal Reports

Business Scenarios

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
    journal-reports_p.png

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-reports_rv.png

Journal Approval Workflow

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

    journal-approval-workflow_p.png

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_rv.png

Balance Sheet

Business Scenarios

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

    UCSD-FRS-Balance-Sheet_p.png

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

UCSD-FRS-Balance-Sheet_rv.png

Income Statement

Business Scenarios

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

    UCSD-FRS-Income-Statement_p.png

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

UCSD-FRS-Income-Statement_rv.png

Budget vs Actual

Coming Soon

Trial Balance Campus

Business Scenarios

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

    UCSD-FRS-Trial-Balance-Campus_p.png

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
UCSD-FRS-Trial-Balance-Campus_rv.png

Trial Balance by FinUnit

Business Scenarios

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

    UCSD-FRS-Trial-Balance-by-FinUnit_p.png

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

    UCSD-FRS-Trial-Balance-by-FinUnit_rv.png