People Soft General Ledger Training for GL Accountants

  • Slides: 90
Download presentation
People. Soft General Ledger Training for GL Accountants 1

People. Soft General Ledger Training for GL Accountants 1

Who Should Attend This Course? • This course is designed to introduce participants to

Who Should Attend This Course? • This course is designed to introduce participants to the General Ledger processes and procedures within the People. Soft environment. • Prior to taking this course, you should have completed the People. Soft Basics and Navigation e. Course. • You should take this course if you support or are assigned to the following roles: Ø General Ledger Administrator Ø General Ledger/ Financial Accountant Ø Project Accounting Supervisor 2

Course Agenda • • • Welcome and Introduction Course Guidelines Course Objectives Key Changes

Course Agenda • • • Welcome and Introduction Course Guidelines Course Objectives Key Changes New Terminology Oracle UPK Navigation People. Soft Basics & Navigation Review To Be Process and Workflow Course Lessons 1 through 5 Course Summary Course Quiz/Assessment Getting Help 3

Welcome and Introductions • Instructor Ø Gagan Bajaj ‘G’ • Business Subject Matter Expert

Welcome and Introductions • Instructor Ø Gagan Bajaj ‘G’ • Business Subject Matter Expert (SME) Ø Jason Reid Ø Maria Tejera Ø Luis Quintana • Participants Ø General Ledger Administrator Ø General Ledger/ Financial Accountant Ø Project Accounting Supervisor 4

Course Guidelines • Please silence pagers and cell phones • Minimize side conversations •

Course Guidelines • Please silence pagers and cell phones • Minimize side conversations • Help manage activities by starting and stopping on time • Actively listen to and engage in the presentations • Please do not work on your computer during Instructor presentations • Be respectful of other participants and only check email or cell phones during breaks • Restroom and exit locations • Breaks • Question/Issue Parking Lot 5

Course Objectives After completing this course, you should be able to: Ø Manage Journals

Course Objectives After completing this course, you should be able to: Ø Manage Journals Ø Process Journals Ø Use Open Item Accounting example: Employee Loans 6

Course Components • • • Concept slides Demonstrations Exercises Job Aids Knowledge Check Questions

Course Components • • • Concept slides Demonstrations Exercises Job Aids Knowledge Check Questions 7

Course Lessons Ø Lesson 1 – General Ledger Overview Ø Lesson 2 – Managing

Course Lessons Ø Lesson 1 – General Ledger Overview Ø Lesson 2 – Managing Journal Entries Ø Lesson 3 – Processing Journals Ø Lesson 4 – Summary 8

Oracle UPK Navigation Introduction • Explain how to access the training • Explain how

Oracle UPK Navigation Introduction • Explain how to access the training • Explain how to search for and view content • Explain how to complete a course 9

People. Soft Basics & Navigation Review Logging On The 3 prerequisites to log on

People. Soft Basics & Navigation Review Logging On The 3 prerequisites to log on to People. Soft: 1. Access the People. Soft URL / link** 2. Enter the correct User ID 3. Enter the correct Password ** the URL/Link determines the People. Soft Database you want to access Example: HCMDEV 10

People. Soft Basics & Navigation Review • To Log Off - Click the Sign

People. Soft Basics & Navigation Review • To Log Off - Click the Sign out button in the Universal Navigation Header Note: At BHSF, an inactivity warning is issued after 18 minutes but a People. Soft session stays active for 20 minutes. Once timed out, you are required to log in again. 11

People. Soft Toolbars & Breadcrumbs You have a number of alternatives for navigating in

People. Soft Toolbars & Breadcrumbs You have a number of alternatives for navigating in People. Soft applications, including: • Drop-down navigation • Navigation pages • Bread crumbs 12

Drop-down Navigation Example In this example the navigation is: Main Menu > General Ledger

Drop-down Navigation Example In this example the navigation is: Main Menu > General Ledger > Journals > Journal Entry > Create/ Update Journal Entries 1313

Navigation Page example Note: Click the Folder to see the navigation page. 1414

Navigation Page example Note: Click the Folder to see the navigation page. 1414

Bread crumbs example Note: Highlighted area shows the bread crumbs navigation. 1515

Bread crumbs example Note: Highlighted area shows the bread crumbs navigation. 1515

People. Soft Page Controls / Icons Note: An asterisk (*) in front of a

People. Soft Page Controls / Icons Note: An asterisk (*) in front of a Field means it is required. 1616

Lesson 1 – General Ledger Overview 17

Lesson 1 – General Ledger Overview 17

Lesson Objectives After completing this lesson, you will be able to: Ø Explain the

Lesson Objectives After completing this lesson, you will be able to: Ø Explain the General Ledger process Ø Identify key data changes from legacy systems Ø Define new terms and concepts Ø Explain Chart of Accounts changes Ø Cross Walk Tables Ø Understand Trees Ø People. Books 18

General Ledger Process Flow 19

General Ledger Process Flow 19

General Ledger Reporting Process Flow 20

General Ledger Reporting Process Flow 20

BHSF Crosswalk Table 21

BHSF Crosswalk Table 21

General Ledger Processing Hierarchy • Override Default Business Unit Override Ledger Journal Source 22

General Ledger Processing Hierarchy • Override Default Business Unit Override Ledger Journal Source 22

BHSF Business Units (B. Us) Business Units are defined at Legal Entities. At BHSF,

BHSF Business Units (B. Us) Business Units are defined at Legal Entities. At BHSF, currently there are 38 Bus. * When using BU 4010040900 to create a JE, you are required to key in an Operating Unit (BHMG). 23

BHSF Ledgers Balanced and Un-balanced set of books, where accounting entries are posted. 24

BHSF Ledgers Balanced and Un-balanced set of books, where accounting entries are posted. 24

BHSF Journal Sources are used to identify the origin of a transaction or a

BHSF Journal Sources are used to identify the origin of a transaction or a group of transactions 25

Chartfields Field Description Field length Business Unit Legal Entity - represents separate Balance Sheets.

Chartfields Field Description Field length Business Unit Legal Entity - represents separate Balance Sheets. 5 Characters Account Use for the representation of the Income Statement and Balance Sheet accounts. 6 Characters Department The department represents the HR Hierarchy of where an employee resides. The departments should be structured with the logic of the functional area or speciality including the Finance and support services. 6 Characters Operating Unit Use to support a location or facility 6 Characters Fund To represent a physical fund 5 Characters Project Business Unit To support Grants and other Project Costing functions such as capital improvement projects 5 Characters Project ID/Grant The specific project ID/Grant 10 Characters Activity Required with the use of Project Costing to track a particular activity 10 Characters 26

Supporting Materials – Chartfields Lawson Accounting Unit Account/Sub account 1001000 (11310 -0000) People. Soft

Supporting Materials – Chartfields Lawson Accounting Unit Account/Sub account 1001000 (11310 -0000) People. Soft Business Unit Operating Unit Dept. Account Fund PC BU Project/ Grant ID Activity (5) (6) (6) (5) (10) The enclosed information, prepared pursuant to Consulting Services Agreement, is solely for the use and benefit of Baptist Health South Florida and is not intended for reliance by any other person. 27 27

Tree ØA tool used for viewing organizing data/ nodes in a logical taxonomy ØAlso

Tree ØA tool used for viewing organizing data/ nodes in a logical taxonomy ØAlso used to provide security access. Ø Used in Reporting ToolsüIn PS/n. Vision it is used to pull Chartfields on a Layout (Template) to create Instances (Reports). Also, to create a Scope Definition to get multiple Instances. üQuery Manager- to filter information. 28

Viewing Trees • How to access Tree Manager • View an existing Tree; examples:

Viewing Trees • How to access Tree Manager • View an existing Tree; examples: ALL_BHSF_ACCOUNTS (Account Rollup Tree) ALL_BHSF_DEPTS (Department Tree) • Understanding Tree concepts: Nodes: Root, Parent, Child, Siblings Leaf / Leaves: Single/ Range Editing Nodes. Display Options: 3 important Checkpoints Effective Date, Status and Use of Levels Perform Audits 29

Trees (ALL_BHSF_DEPTS) 30

Trees (ALL_BHSF_DEPTS) 30

How to find information in People. Soft 31

How to find information in People. Soft 31

People. Books 32

People. Books 32

Lesson 1 Summary Having completed this lesson, you should now be able to: Ø

Lesson 1 Summary Having completed this lesson, you should now be able to: Ø General Ledger Overview Ø New Chart of Accounts Ø Crosswalk Tables Ø Viewing and Managing the Tree Ø People. Books 33

Lesson 2 – Managing Journal Entries 3434

Lesson 2 – Managing Journal Entries 3434

Lesson Objectives After completing this lesson, you will be able to: Ø Viewing Chartfield

Lesson Objectives After completing this lesson, you will be able to: Ø Viewing Chartfield Definitions Ø Viewing Schedules Ø Creating and Posting a Journal Entry Ø Reviewing a Journal Entry Reversal Ø Specifying Journal Search Criteria Ø Upload the Journal Spreadsheet to People. Soft 35

Overview Process Flow Insert process flow/swim lane image In notes area provide explanation of

Overview Process Flow Insert process flow/swim lane image In notes area provide explanation of process and role activities Info on General Ledger Overview 3636

Record Journals Process Flow 37

Record Journals Process Flow 37

Edit journals Process Flow 38

Edit journals Process Flow 38

Post journals Process Flow 3939

Post journals Process Flow 3939

Financial Control and Reporting Process Flow 40

Financial Control and Reporting Process Flow 40

Viewing Chartfield Definitions Chartfield Values: Ø Are used to classify transactions (subsystems or GL)

Viewing Chartfield Definitions Chartfield Values: Ø Are used to classify transactions (subsystems or GL) Ø Make up your chart of accounts, department value, etc. Ø Segregate and categorize balances for reporting purposes. 41

Example of a BHSF Department Chart. Field Note: * refers to a Required field.

Example of a BHSF Department Chart. Field Note: * refers to a Required field. 42

Preparing for Journal Entry You can set up overall user defaults. These defaults will

Preparing for Journal Entry You can set up overall user defaults. These defaults will appear automatically on pages and in dialog boxes to reduce the amount of keying that is required. People. Soft handles pre-populating of JE’s from two places: 1. Setting Overall User Preferences 2. Setting General Ledger User Preferences 43

Setting Overall User Preferences Use the Overall Preferences page to define the default value

Setting Overall User Preferences Use the Overall Preferences page to define the default value s for the specified user Id. 44

Setting General Ledger User Preferences On the User Preferences- General Ledger page, you determine

Setting General Ledger User Preferences On the User Preferences- General Ledger page, you determine the default Ledger, Ledger Group, and Source that will appear on pages for a user. 45

Schedules Recurring journal entries require processing schedules. You can create schedules that automate and

Schedules Recurring journal entries require processing schedules. You can create schedules that automate and control the generation of standard or recurring journal entries. You can define daily, weekly, monthly, or annual scheduling for recurring transactions such as closing schedules. User defined schedules enables you to specify particular dates and times. 46

JE Processing Journal Entry Processing Ø Journal Data Entry, directly into People. Soft General

JE Processing Journal Entry Processing Ø Journal Data Entry, directly into People. Soft General Ledger, can be uploaded through the Journal Spreadsheet or they can be generated from the feeder systems by the Journal Generator Ø Edits for accuracy and completeness. Ø Posting to a ledger; the original journal entries are retained after posting by People. Soft General Ledger for analysis and audit trail purposes. You can check the journal status at any point in the journal processing flow. 47

Creating and Finding an Existing JE. 48

Creating and Finding an Existing JE. 48

Create a New JE Main Menu> General Ledger > Journals> Journal Entry > Create/

Create a New JE Main Menu> General Ledger > Journals> Journal Entry > Create/ Update Journal Entries In People. Soft General Ledger, Business Unit, Journal ID and Journal Date uniquely identify a journal. 49

Journal Line • Use the Journal Entry Lines page to enter individual journal debit

Journal Line • Use the Journal Entry Lines page to enter individual journal debit and credit transactions. • Select the desired Journal Entry Template from the Template List to control the fields displayed on this page. • The Process drop down fields contains journal processing options for an individual journal; availability depends on user security settings. 50

Processing a JE On the Lines Page Tab Process button: Approval Process: 51

Processing a JE On the Lines Page Tab Process button: Approval Process: 51

Journal Status Values Journal Status Code Journal Status Description N Needs Edit Required Journal

Journal Status Values Journal Status Code Journal Status Description N Needs Edit Required Journal has not been edited; therefore, cannot be posted. E Errors Journal has been edited and contains errors. V Valid Journal has passed editing and is ready to be posted. P Posted Journal has been posted to the ledger(s). U Un. Posted Journal has been posted, then Unposted. M Model Journal is an SJE model. D Deleted Related journal has been deleted. I Incomplete Posting incomplete. T Journal Incomplete Journal is incomplete and will be bypassed by processing. 52

Approval Process Note: The Journal was routed for approval process. 53

Approval Process Note: The Journal was routed for approval process. 53

Journal Approval Logic and Thresholds 1. If the total debits amount of the journal

Journal Approval Logic and Thresholds 1. If the total debits amount of the journal header is less than $25, 000 it will be auto-approved 2. If the total debits amount of the journal header is greater than or equal to $25, 000 it will route to the GL Manager for approval 3. If the total debits amount of the journal header is greater than or equal to $2, 000 it will route to the GL Manager for the first approval, after it is approved by a manager it will route to the GL Director final approval. 4. In any approval process it will only require 1 approver from a manager and or director 54

Journal Entry Reversal 55

Journal Entry Reversal 55

Copy and Reverse 56

Copy and Reverse 56

Journal Search Criteria 57

Journal Search Criteria 57

Attachments to J. Es 58

Attachments to J. Es 58

Journal Totals page You can use the Totals page to enforce a greater degree

Journal Totals page You can use the Totals page to enforce a greater degree of control over the JE process. As you enter the journal line, the system displays a running total to the actual debits, credit. When you edit the journal and the control totals do not equal the actual totals, the system flags the journal as having errors, and you need to correct the errors before you can post. 5959

Upload the Journal Spreadsheet to People. Soft Journal Upload Requirements • People. Soft delivers

Upload the Journal Spreadsheet to People. Soft Journal Upload Requirements • People. Soft delivers the required spreadsheet journal import files with People. Soft General Ledger. The following files should be placed in the same directory: File Name Description JRNL 1. xls The delivered People. Soft Journal Workbook sample file; this is the control file for creating and maintaining spreadsheet journals. A message log template file to keep track of successful or error file imports GLLOG. xlt JRNLMCRO. xla The compiled macro sheet file contains creation and importing data for journal header and lines. 6060

Homepage: Spreadsheet Journal Import 61

Homepage: Spreadsheet Journal Import 61

Setting up Workbook Defaults Before you begin to enter journals, you will set up

Setting up Workbook Defaults Before you begin to enter journals, you will set up workbook defaults: Ø Header Defaults Ø Message Options Ø Document Sequencing Information Ø Online Import Control 62

Define Options and Defaults 63

Define Options and Defaults 63

Journal Header buttons • Row 5 displays the following Header buttons: 64

Journal Header buttons • Row 5 displays the following Header buttons: 64

Journal Line buttons Row 9 displays the following Line buttons: 65

Journal Line buttons Row 9 displays the following Line buttons: 65

Configuration Button This table lists the navigation buttons and their functions: 66

Configuration Button This table lists the navigation buttons and their functions: 66

Importing the Spreadsheet After Import is complete: 1. If the import was successful the

Importing the Spreadsheet After Import is complete: 1. If the import was successful the status of the JE in People. Soft should be ‘N’ (Needs Edit) 2. A log file is updated (Jrnl. Log. xls) 67

Lesson 1 Summary Having completed this lesson, you should now be able to: Ø

Lesson 1 Summary Having completed this lesson, you should now be able to: Ø Viewing Chartfield Definitions Ø Viewing Schedules Ø Creating and Posting a Journal Entry Ø Reviewing a Journal Entry Reversal Ø Specifying Journal Search Criteria Ø Upload the Journal Spreadsheet to People. Soft 6868

Lesson 3 – Processing Journals 69

Lesson 3 – Processing Journals 69

Lesson Objectives After completing this lesson, you will be able to: Ø Generate Journals

Lesson Objectives After completing this lesson, you will be able to: Ø Generate Journals Ø Editing Journals Ø Post Journals Ø View Journal Status Ø View Message Logs Ø Copy a Journal 7070

Standard Journal Entry Standard Journal Entries (SJE) facilitates automating the creation of similar or

Standard Journal Entry Standard Journal Entries (SJE) facilitates automating the creation of similar or identical journal entries following these steps: 1. Define the schedule, if appropriate. 2. Identify or create a model journal entry. 3. Define and generate the SJEs. 4. Verify the journal entries statuses. 5. Edit and post the journal entries. 7171

Step 1: Define the schedule, if appropriate. Recurring journal entries require processing schedules. You

Step 1: Define the schedule, if appropriate. Recurring journal entries require processing schedules. You can create schedules that automate and control the generation of standard or recurring journal entries. You can define daily, weekly, monthly, or annual scheduling for recurring transactions such as closing schedules. User defined schedules enables you to specify particular dates and times. 72

Step 2 73

Step 2 73

Step 3: Define Standard Journals General Ledger > Journals > Standard Journals > Define

Step 3: Define Standard Journals General Ledger > Journals > Standard Journals > Define Standard Journals Standard Journal Types: 74

Define Standard Journal Entry General Ledger > Journals > Standard Journals > Define Standard

Define Standard Journal Entry General Ledger > Journals > Standard Journals > Define Standard Journals 75

Step 4: Create Standard Journals General Ledger > Journals > Standard Journals > Review

Step 4: Create Standard Journals General Ledger > Journals > Standard Journals > Review Standard Journals 76

Understanding Statistics Accounts People. Soft General Ledger facilitates using statistics in journal. You can

Understanding Statistics Accounts People. Soft General Ledger facilitates using statistics in journal. You can use Statistical Accounts and/or Statistic Codes. Since each statistic has a standard unit of measure representing the statistical amount stored in the database, it is important to define the required unit of measure code. 77

Properties of Model Standard JE Type A Model Standard Journal Entry type after journal

Properties of Model Standard JE Type A Model Standard Journal Entry type after journal edit validation has the following restrictions: Ø It cannot be changed or deleted. Ø It cannot be budget checked, posted or submitted for workflow approval. 78

GLR and GLEs JEs When creating a General Ledger Expense or General Ledger Revenue

GLR and GLEs JEs When creating a General Ledger Expense or General Ledger Revenue JE, you must use: ü PC Bus Unit ü Project Id ü Activity Id ü An Type ü Source Type 79

Inter. Unit (Inter Company) The primary function of People. Soft interunit processing is automating

Inter. Unit (Inter Company) The primary function of People. Soft interunit processing is automating the creation of the payable and receivable balancing entries between related parties. Establish interunit accounts the system will use to automatically balance the interunit entry by business unit (the Due To/From journal lines). 80

Allocation Processing Steps These are the high level Allocation Processing Steps: • Identify the

Allocation Processing Steps These are the high level Allocation Processing Steps: • Identify the allocation basis needs and required elements. • Define the Allocation Step or Steps that include Type, Pool, Basis, Target and Offset. • Link the Allocation Step or Steps to an Allocation Group. • Run the Allocation Process. • Run the Allocation Calculation Log report to analyze results. *Focus of this class 8181

Running an Allocation 8282

Running an Allocation 8282

Viewing the Allocation Log 8383

Viewing the Allocation Log 8383

Mark Journal for Posting Accountants – Mark Journal for Posting 8484

Mark Journal for Posting Accountants – Mark Journal for Posting 8484

Post Journals Request (Mass) Sr Accountants and Managers- Post JEs 8585

Post Journals Request (Mass) Sr Accountants and Managers- Post JEs 8585

Journal Generator 8686

Journal Generator 8686

Course Summary 87

Course Summary 87

Getting Help • • • Online Training UPK simulations Job Aids Super Users Help

Getting Help • • • Online Training UPK simulations Job Aids Super Users Help Desk 88

Questions and Concerns • Parking Lot • Will get back 89

Questions and Concerns • Parking Lot • Will get back 89

Thank you for attending the GL Training for GL Accountants 90

Thank you for attending the GL Training for GL Accountants 90