1 / 14

General Ledger Terminology, nVision and Financials Query

Financials Reporting. General Ledger Terminology, nVision and Financials Query. Financials 7.02. Purchasing Financials Reporting Basic Budgeting. Financials System Workshops. Introduction to Financials Accounts Payables Travel Policies. Web Site for Financials Training

wright
Download Presentation

General Ledger Terminology, nVision and Financials Query

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Financials Reporting General Ledger Terminology, nVision and Financials Query Financials 7.02

  2. Purchasing Financials Reporting Basic Budgeting Financials System Workshops • Introduction to Financials • Accounts Payables • Travel Policies Web Site for Financials Training www.fis.ncsu.edu/FinTraining

  3. Workshop Format • Lecture • Desktop Exercises • Questions • Networking

  4. Introductions • Name • Department • Type of User • How long as a user?

  5. Overview • Understanding of basic General Ledger Terminology • Using nVision to view and save as Excel files, daily Project ID status and transaction information. • A basic understanding of the relational database structure; • Private versus Public queries; • How to run queries with results to the Financials System and to Excel; and how to change fields and criteria in an existing query and save it as a private query. • A valid Financials Operator Id is required to take this class.

  6. General Ledger Terminology Examples Legacy System Current System *FAS Account==*Project Segment *Object Code==*Account

  7. nVision Reports*Previously FAS PF Screens nVision is a customer friendly reporting package that retrieves information from your Financials Reporting System and places it into a MS Excel spreadsheet, in a form that helps you see the big picture, explore details, and make decisions. Using nVision you will be able to see daily Project ID status and transaction information quickly and easily in an organized spreadsheet format. You must use Financials Reporting to access nVision Reports.

  8. Basic Query Tools The Financials database contains a large volume of valuable data. The data is stored in tables (storage repositories) that have functional or process titles. The capability of understanding “Public” queries for one time only use or for repeated use can be a great time saver and quick way of validating, auditing and reconciling. ….researching …..

  9. QueryObjectives: • Understand the structure of a Relational Database • Understand how Public and Private Queries differ • Run queries with results to Financials (Screen) and to Excel (Spreadsheet) • Change Fields and Criteria in an existing query and save it as a Private Query

  10. Certificate! Financials System 7.02 Training Certificate Presented to _____________________ for the successful completion of Financials Reporting at the Avent Ferry Complex Training Labs. Instructor’s Signature Date

  11. Questions? How to reach me after today’s class. Matthew L. Jockisch513-4207matthew_jockisch@ncsu.edu Let’s Get Started

  12. General Ledger Terminology Financials Terminology Legacy Terminology Description Example Account Object Code Expenditure Code Revenue Object Categorizes the transaction by its nature. The leading digit classifies the transaction as being an Asset (1); Liability (2); Fund Equity (3); Revenue (4); or Expense (5). 11100 – Cash Balance (Asset) 22010 – Accounts Payable (Liability) 40221 – State C & G (Revenue) 51219 – SPA Reg. Salaries (Expense) Fund BCTF (Budget Code Trust Fund) Classifies the transaction by a five digit major funding category. 16030 – Academic Affairs 91000 – Trust Funds

  13. General Ledger Terminology (cont’d) Financials Terminology Legacy Terminology Example Organization (Org) or Department OUC (Organizational Unit Code) Description Represents the department (OUC) effected by the transaction. 140301 – Civil Engineering 180701 – Textile & Apparel Tech & Mgmt Program Project ID (Prj/Grt) *The Project ID (Prj/Grt) has three different types: Sub-Classification (Sub-cls) or Appropriation Number (Approp) Purpose Code Classifies transaction to specific activities or cost centers. Classifies the transaction by broad function. 101 – Regular Term Instruction 110 – Organized Research Segments transaction for reporting purposes primarily based on sources of funding. 212 – Ledger 2 Account only 552 – C&G ABR 5 State What are the three different Project ID types?

  14. General Ledger Terminology (cont’d) Financials Terminology Legacy Terminology Example Project Reference GL Account Description Referenced Project 015160 Project Segment Project Phase FAS Account SL Account FAS Account Project FAS Project Number Activity Identifier Project Subsidiary Ledger 207637 Project Phases are used for greater detail in activity or cost center tracking analysis. 207637-82001 (In the legacy system the Project Phase was just the five digits after the hyphen. In the current system the Project Phase is the entire numerical string of the six digit Project Segment plus the hyphen five digits.) Now you know the Project ID structure!

More Related