NVision
This presentation is the property of its rightful owner.
Sponsored Links
1 / 35

nVision Reporting PowerPoint PPT Presentation


  • 129 Views
  • Uploaded on
  • Presentation posted in: General

nVision Reporting. Finance Systems Training. Rohin Whitford Finance Business Solutions – User Support & Training. Slide Directory. Slide #Topic 3 Agenda 4 Our systems 5 NS Financials overview 6 What is nVision 9-14 Layouts & Scopes 15-19 Recommended reports

Download Presentation

nVision Reporting

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Nvision reporting

nVision Reporting

Finance Systems Training

Rohin Whitford

Finance Business Solutions – User Support & Training


Nvision reporting

Slide Directory

Slide #Topic

3Agenda

4Our systems

5NS Financials overview

6What is nVision

9-14Layouts & Scopes

15-19Recommended reports

20-23Drill down options

26-31Scheduling reports in NS Financials

34Further support & guidance


Agenda

Agenda

  • NS Financials Overview

  • What is nVision

  • Citrix Login

  • Layouts and Scopes

  • List of Recommended Reports

  • Drill Down Options

  • Saving & Printing Reports

  • Scheduling Reports within NS Financials

  • Help and Support


Our systems

Our Systems

Finance Portal

Student Administration

FIMS (Calumo)

NS Financials

General Ledger updates overnight

HRMS / Payroll

Management Reporting

n/Vision


Ns financials overview

NS Financials Overview

* No Commitment Control

eProcurement

Asset

Management *

Billing

Procurement

Card

Purchasing

General Ledger

Accounts

Receivable*

Expenses

Accounts

Payable

Expenditure

Budgeting Software

(monthly interface from PeopleSoft

Pre-encumbrance

Revenue

Debtors


What is nvision

What is nVision?

PS/nVision retrieves information from the NSF database and places it into a Microsoft Excel spreadsheet, in a form that helps you see the big picture, explore details, and make decisions.

You use familiar Excel commands to format and analyse the data.

With PS/nVision, you spend your time analysing results

rather than summarising data and entering it into

a spreadsheet.


Ps nvision login

PS/nVision Login

http://www.fin.unsw.edu.au/


Citrix login

Citrix Login


Layouts and scopes

Layouts and Scopes


Layouts and scopes1

Layouts and Scopes

  • Layout (or Instance)

    To specify the data you want to bring into Excel, you use a report layout. A report layout is an Excel spreadsheet used as a template to define how a report looks and the type of information that goes into the spreadsheet’s different cells. A layout does not contain data from the database. Rather, it specifies what data should be mapped directly into your report. Once a library of report layouts has been created, select an existing layout that best suits your needs. At UNSW Layouts are preset – you cannot create your own.

  • Scope

    A report scope allows you to create multiple instances of a report using a single report layout and report request. Using a scope, each report instance contains data specific to an individual field value, such as a business unit, department, account or project, or to a group of values, such as a tree node that summarises all sales departments. In this way, each report instance can share the same layout, while containing data unique to these field values. You might run three instances of an expense report that share the same layout but contain the details of one division each.


Report

Report


Scopes

Scopes

Scope is usually a project id or department


Search scopes

Search Scopes


Scopes1

Scopes


List of nvision reports

List of nVision Reports

  • F1 Standard Financial Statement (P&L)

  • F3 Financial Statement by Fund Group

  • F4 Trial Balance

  • F5 Full Year Financials Statement with Commitments

  • D2 Summary Financial Statement by Department

  • PrjStatSProjects Summary Report

  • PrjStatDProject Detailed Report

  • P1Standard Project P&L

  • PCSUMLTDProject Summary- Life to Date

  • Res_StatResearch Statement

  • GLFSGeneral Ledger Financial Statement

/


F1 financial statement

F1 Financial Statement

How much I have spent this year against my budget?

What I have spent on?


F1 financial statement1

F1 Financial Statement


Trial balance

Trial Balance

How much I have spent on individual accounts?

What are the transactions?


Trial balance1

Trial Balance


Drill down options

Drill Down Options


Actual journal lines for totals

Actual Journal Lines / ... for Totals


Source

Source

Source – To identify the information (the following in red provide further drilldown options):

AM – Asset Management (Asset Management)

AP – Accounts Payable (AP Vouchers excl Procurement Cards or Procurement Card Transactions)

AR – Accounts Recievable(Billing Line Details)

BI –Billing Information (Billing Line Details)

PO – Purchase Orders (Purchase Order Details)

ZPA – Accrual Journal Lines (Accrual Journal Lines)

ZPC –Payroll Encumbrance (HRIS Payroll Encumbrance)

ZPY – Payroll Salary (HRIS Payroll Salary)

The following are some of the common Source Codes that does not provide further drilldown options

ALO – Allocation process

EOM – End of Month Journal (It can be either Actuals or Accruals)

GST – GST Adjustments

INT – Interest Distribution (System generated)

OLE – Online Encumbrance (Commit.) Entry Journal

ONL –Online Journal Entry

PRT – Payroll Tax (System generated)

SSJ – Spreadsheet Journal


Exercise

Exercise

  • F1_Std Financial Statement

COFA

Entertainment -

Sundry Other Revenue - YTD

Actual Journal Lines

Account by Period

Billing Line Details

AP excl Procurement Card

Procurement Card


Exercise1

Exercise

  • PrjStatS

COFA

PS19432 - Revenue

Billing Line Details

  • PrjStatD

PS19433

Non People Costs

Total Commitment


Nvision reporting

Scheduling Reports


Nvision reporting

Reporting Console

First time users will need to select Preferences.

Ensure that the tick box labelled Enabled under the heading Process Request Notification is ticked.


Nvision reporting

Adding Reports to the Reporting Console

Ensure the Process Bookmarks radio button is selected as well as the type of process you are scheduling (in this case nVision Report)

Select the report you want to schedule.


Nvision reporting

Running a report from the Reporting Console

  • Select the date you’d like the report to run to

  • Choose email as the Type

  • Choose Excel as the format for the report

  • Select the scope for your report


Nvision reporting

Running a report from the Reporting Console

  • Choose a Scope

  • Enter the File Template

    • (if unsure copy)

  • Enter the Directory Name

    • (if unsure copy)

  • Enter your email address.


Nvision reporting

Running a report from the Reporting Console

Choose the date & time you want the report to run – run larger reports overnight so that it reduces the load on the systems during business hours


Important things to remember

Important things to Remember

Saving Reports

  • The report can be saved to client drive

  • Save any drill you also require – you cannot drill down on summary totals in your saved report files.


Important things to remember1

Important things to Remember

  • Information provided is up to the close of business of the previous day and may include some journals posted to the current day.

  • Beware when running LTD (Life To Date) reports in NS Financials – run them in Citrix instead.

    Reports may also be scheduled (preferably overnight) in NS Financials via the Reporting Console and delivered by email


Nvision reporting

Support & Guidance

  • Finance Website – Reporting

    • https://www.fin.unsw.edu.au/Reporting/Reporting.html

  • UNSW Finance Reporting Guide

    • https://www.fin.unsw.edu.au/files/Training/nVisionReports/Reporting_User_Guide.pdf

  • Faculty Finance Managers & Management Accountants

    • https://www.fin.unsw.edu.au/InformationCentre/WhoCanHelp.html#8

  • Online Training Tool

    • http://www.fin.unsw.edu.au/NSF_KnowledgeBase/OnlineTrainingTool.html

  • Quick Reference Guides

    • http://www.fin.unsw.edu.au/NSF_KnowledgeBase/QRG.html


  • Questions

    User Support & Training

    Questions?

    • Finance Website – Training

      • https://www.fin.unsw.edu.au/NSF_KnowledgeBase/FKB_Training.html

  • Training Enquiries

    • Rohin Whitford, Finance Trainer

    • Ext. 53550, Email [email protected]


  • Login