Transcript AS report - Office of Finance & Administration
nVision Reporting
Office of the Controller
Objective
1. Budget Inquiries & Budget Status Report 2. Overview of some useful Queries 3. nVision Financial Reports:
•
Define nVision
•
Variance Analysis
•
Available Budget 4. Demo
Office of the Controller
Crystal Reports Inventory: Available Balance Budget Status Report
Ledger Group CC_DEP (Department Child) CC_PRD (Department Parent) CC_REV CC_PG (Project Child) CC_PID CC_PRP (Project Parent) Description
Expense budgets, expenses, encumbrances & pre encumbrances for Departments* or Activity Numbers by detail Budget Account Expense budgets, expenses, encumbrances & pre encumbrances for Departments* or Activity Numbers by Parent Department Budgeted, collected and recognized revenues Expense budgets, expenses, encumbrances & pre encumbrances for project by detail Budget Account Expense budgets, expenses, encumbrances & pre encumbrances for Departments* or Activity Numbers by detail Faculty Allocation Expense budgets, expenses, encumbrances & pre encumbrances for projects by Parent Project ID * Organizational Unit Office of the Controller
On-Line Inquiries - Reports Inventory: Available Balance Budget Overview Detail View Office of the Controller
On-Line Inquiries - Reports Inventory: Reconciliation Budget Overview: Drill to Activity Log Office of the Controller
Reports Inventory: Reconciliation Budget Overview: Drill to Activity Log Office of the Controller
On-Line Inquiries - Reports Inventory: Available Balance Budget Overview Parent View Office of the Controller
On-Line Inquiries - Reports Inventory: Available Balance Budget Overview Detail View Office of the Controller
Reports Inventory: Reconciliation Budget Overview: Drill to Activity Log Office of the Controller
SQR Reports Inventory: Available Balance Budget Status Report Office of the Controller
SQR Reports Inventory: Available Balance Budget Status Report Office of the Controller
Objective
1. Budget Inquiries & Budget Status Report 2. Overview of some useful Queries 3. nVision Financial Reports:
•
Define nVision
•
Variance Analysis
•
Available Budget 4. Demo
Office of the Controller
Query Name
REQUISITION_WORKFLOW_ROUTING FIU_DEPT_APPROVERS_BY_DEPT FIU_GL_TRANDATA_BYDATE FIU_GL_ACTIVE_SPDTP_CF1_PROJ
Useful Queries
Description
List of employees involved in approving a requisition by Requisition ID Lookup Expense Managers 1 & 2 (Approvers) and Organizational department by Dept ID Detail transaction data for committed (enc & pre)/ paid expenses as well as budget by Dept ID/Activity Nbr/Project ID Access the most current chartfield values associated with Activity Nbrs or Project IDs: department/site/fund/Program code, etc...
Office of the Controller
Query Data
Office of the Controller
Objective
1. Budget Inquiries & Budget Status Report 2. Overview of some useful Queries 3. nVision Financial Reports:
•
Define nVision
•
Variance Analysis
•
Available Budget 4. Demo
Office of the Controller
The nVision reporting tool
Provides real-time financial reporting capability.
Extracts requested financial data from PeopleSoft.
Places it into an Excel spreadsheet where it can easily be reviewed and manipulated.
Template or style sheet Report Request • Keyed to Business Unit • Includes saved parameters • • Rules for generating reports for slices of the data The Scope feature allows you to create multiple instances of a report using a single report request.
Layout
Scope Office of the Controller
Reporting nVision – Elements
Microsoft Excel
Microsoft Excel is the backbone of nVision reporting. nVision facilitates the retrieval of information from PeopleSoft databases into a Microsoft Excel spreadsheet.
The Layout of the Report
The Layout of the Report is a Matrix or Tabular Excel spreadsheet.
The Ledger Tables
Layouts retrieve data from a ledger. This could be Actual, Budget or Forecast Ledgers. The ledger tables have five major data components: Business Unit Ledger Chartfields (Account, Department, Activity Number and Project ID, Program, Fund, Site or Class. Additionally for Projects PC Business Unit and Activity) Period and Year Net Posted Amount Office of the Controller
Reporting nVision – Elements Continued
Actual transactions and Budget Transactions are stored on two separate tables.
Actuals data is on the LEDGER table Budget data is on the LEDGER_KK table
Time Spans
Time Spans control the number of data periods extracted from the ledger table and summarized.
Trees
Trees are used to create hierarchical structures that visually represent a set of summarization rules for a particular field. The summarization rules depicted in a tree apply to the detail values of a particular field – departments, accounts, funds, vendors, customers or other values the University defines.
Office of the Controller
Reporting nVision – Variables
Report Variables
Provide information about the current nVision report such as the Business Unit, Report ID/name, Title, Layout Name, Operator ID, etc.
Date and Time Variables
Provide information about the Date of the Report, the Fiscal Year Accounting Period, etc.
Scope Variables
Provide information related to the scope definition used in the nVision report such as the Scope Field Value or description (i.e., department id or name) Office of the Controller
Reporting nVision – Time Spans
Time Spans
The Time Span controls the number of data periods extracted from the ledger tables and summarized.
Typical Time spans provided with PeopleSoft General Ledger include: PER – Period – Retrieves only activity for the period selected (1=July, 2=Aug, etc.) YTD – Year to Date – Includes year-to-date amount for items selected.
BAL – Balance – Retrieves life-to-date amounts (balance forward amounts) for balance sheet accounts.
Time spans are often expressed relative to current period, so that they automatically adapt the content of a report to the “As of Reporting Date” specified when the report is executed. Office of the Controller
Reporting nVision – Scope
Scope
A Scope can be on one Chartfield and one value as well as many Chartfields and any values A Scope can be built on single values or tree nodes.
This is a single value scope: Office of the Controller
Reporting nVision – Scope
Scope
This Scope includes Activity and Fund Trees: * This Scope can be copied to another and change the fund node to: OTHER_UNRESTRIC_FUND Office of the Controller
Users Aggregate level Report
CFO / BOT OFP EABM ABM Fund
VA Report
Fund Exec Area Fund College/Unit E&G and Non E&G:
AS report*
Non Athletics:
AS report
Athletics:
AI Report
DeptID E&G :
DI report
Non E&G:
XA report
*A modified version of the AS showing subtotals per EA and College is being tested Office of the Controller
Type of Report
nVision Financial Reports
Variance (Budget vs. Actual) Reports Description of the Report Name
Detail Transaction Reports Detail transaction data for committed (enc & pre)/ paid expenses as well as budget by Dept ID
DT
Summary Reports Detail variance by account with a subtotal by account rollups ( S&B, OCO,OPS, OOE) for a single Dept ID Detail variance by account with a subtotal by account rollups ( S&B, OCO,OPS, OOE) for a single E&G Dept ID Detail Inflow (revenue, fund balance & transfers in) and Outflow (Expenses and transfers out) variance with subtotals account and account rollups Detail Inflow (revenue, fund balance & transfers in) and Outflow (Expenses and transfers out) variance with subtotals account and account rollups for an Athletics dept
DI XA AI
Office of the Controller
Type of Report
Executive Summary nVision Financial Reports
Variance (Budget vs. Actual) Reports Description of the Report
Actual and budget information for Salaries & Benefits for a range of Dept ID with a subtotal by Dept ID and funding source Actual and budget information for Other Capital Outlay for a range of Dept ID with a subtotal by Dept ID and funding source Actual and budget information for Other Personnel Services for a range of Dept ID with a subtotal by Dept ID and funding source Actual and budget information for Other Operating Expenses for a range of Dept ID with a subtotal by Dept ID and funding source
Name AS*
Actual and budget information for all expenses for a range of Dept ID with a subtotal by Dept ID and funding source Actual and budget information for revenues for a range of Dept ID with a subtotal by Dept ID and funding source *Note: The revenue section is collapsed Office of the Controller
Reports Inventory: Variance Analysis The VA Report The Columns come from Ledgers and use Time Spans The Rows come from Chartfields Office of the Controller
Reports Inventory: Variance Analysis The AS report
Perm. Salaries OPS
Variance Categories:
OCO OOE Total Expenses Revenue
Office of the Controller
Reports Inventory: Variance Analysis The XA report Office of the Controller
Reports Inventory: Variance Analysis The DI report Office of the Controller
Reports Inventory: Available Balance
Audience Aggregate level Report
CFO OFP EABM Fund Fund Exec Area Fund College/Unit
DS Report
E&G and Non E&G:
DS Report
E&G and Non E&G:
DS Report
ABM DeptID
Budget Overview Budget Status Report
Office of the Controller
Reports Inventory: Available Balance DS Report Office of the Controller
Reports Inventory: Available Balance DS Report Budget Reconciliation Office of the Controller
Reports Inventory: Available Balance ES Report Office of the Controller
nVision Financial Reports
Available Budget Detail Budget status Report Available Balance detail by Budget account DI Budget Status*
Salaries Executive Summary Salaries & Benefits Available Balance
ES ES
OCO Executive Summary Other Capital Outlay Available Balance
EC EC
OPS Executive summary OOE Executive Summary Other Personnel Services Available Balance
EO
Other Operating Expenses Available Balance
EE EO EE
Executive Summary Exec Sum by Dept
DS DS
*Note: The Budget status report is NOT an nVision report. A tutorial is available online (UPK) on how to run it http://panthersoft.fiu.edu/UPK/Financials/Publishing%20Content/PlayerPackage/toc0.html
Office of the Controller
Objective
1. Budget Inquiries & Budget Status Report 2. Overview of some useful Queries 3. nVision Financial Reports:
•
Define nVision
•
Variance Analysis
•
Available Budget 4. Demo
Office of the Controller
Reports Inventory: The DT report Using nVision Office of the Controller
Reports Inventory: The DT report Office of the Controller
Reports Inventory: The DT report You can choose either a Department Area or Activity Number for this report. Whichever you choose, your report will reflect all selections for the report.
Office of the Controller
Reports Inventory: The DT report Office of the Controller
Reports Inventory: The DT report Be sure to “
ENABLE
” the Macros for you to adjust and retrieve the item details from PantherSoft.
Office of the Controller
Reports Inventory: The DT report Office of the Controller