People Soft General Ledger Training for GL Accountants
- Slides: 90
People. Soft General Ledger Training for GL Accountants 1
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 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 (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 • 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 Ø Process Journals Ø Use Open Item Accounting example: Employee Loans 6
Course Components • • • Concept slides Demonstrations Exercises Job Aids Knowledge Check Questions 7
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 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 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 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 applications, including: • Drop-down navigation • Navigation pages • Bread crumbs 12
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
Bread crumbs example Note: Highlighted area shows the bread crumbs navigation. 1515
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 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 Reporting Process Flow 20
BHSF Crosswalk Table 21
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, 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 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. 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 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 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: 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
How to find information in People. Soft 31
People. Books 32
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 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 process and role activities Info on General Ledger Overview 3636
Record Journals Process Flow 37
Edit journals Process Flow 38
Post journals Process Flow 3939
Financial Control and Reporting Process Flow 40
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. 42
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 s for the specified user Id. 44
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 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 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
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 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
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
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
Copy and Reverse 56
Journal Search Criteria 57
Attachments to J. Es 58
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 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
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
Journal Header buttons • Row 5 displays the following Header buttons: 64
Journal Line buttons Row 9 displays the following Line buttons: 65
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 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: Ø 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 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 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 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 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 Journals 75
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 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 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 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 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 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
Viewing the Allocation Log 8383
Mark Journal for Posting Accountants – Mark Journal for Posting 8484
Post Journals Request (Mass) Sr Accountants and Managers- Post JEs 8585
Journal Generator 8686
Course Summary 87
Getting Help • • • Online Training UPK simulations Job Aids Super Users Help Desk 88
Questions and Concerns • Parking Lot • Will get back 89
Thank you for attending the GL Training for GL Accountants 90
- General ledger accounting training
- Soft ledger
- Problem 7-7 journalizing and posting business transactions
- Contra entry in control account
- Cayenta payroll management
- Post adjustment trial balance grade 10
- Posting to a general ledger chapter 4
- Posting in accounting
- Management reporting systems
- Owner's equity examples
- General ledger and reporting system
- General ledger and reporting system
- Kelly consulting general ledger
- Control account exercises
- Copyright
- General ledger master file
- Chapter 4 posting to a general ledger
- Trading account general ledger
- General ledger
- General ledger
- Grade 9 ems business plan
- Completing the accounting cycle of a merchandising business
- what is a general ledger accounting document
- Code of ethics for professional accountants
- Institute of cost and management accountants of pakistan
- Pers aswani
- Accountants professional indemnity insurance
- Strategic accountant
- Mdd forensic accountants
- Iranian association of certified public accountants (iacpa)
- Institute of certified public accountants in israel
- New jersey association of public accountants
- The institute of management accountants adopted the ______.
- Primary users of accounting information are accountants
- Michigan association of certified public accountants
- δwc
- Dfg legal costs accountants
- Managerial accounting chapter 1
- Fiji institute of accountants
- Egaming accountants
- Chartered accountants academy
- Ayaalan
- Accrue chartered accountants
- People soft 8
- People soft
- People soft utep
- Utep direct deposit
- Soft skills development ppt
- Fspos vägledning för kontinuitetshantering
- Typiska novell drag
- Tack för att ni lyssnade bild
- Vad står k.r.å.k.a.n för
- Varför kallas perioden 1918-1939 för mellankrigstiden
- En lathund för arbete med kontinuitetshantering
- Personalliggare bygg undantag
- Tidbok för yrkesförare
- Anatomi organ reproduksi
- Vad är densitet
- Datorkunskap för nybörjare
- Tack för att ni lyssnade bild
- Mall för debattartikel
- Magnetsjukhus
- Nyckelkompetenser för livslångt lärande
- Påbyggnader för flakfordon
- Vätsketryck formel
- Offentlig förvaltning
- Kyssande vind analys
- Presentera för publik crossboss
- Jiddisch
- Plats för toran ark
- Treserva lathund
- Fimbrietratt
- Bästa kameran för astrofoto
- Centrum för kunskap och säkerhet
- Byggprocessen steg för steg
- Mat för idrottare
- Verktyg för automatisering av utbetalningar
- Rutin för avvikelsehantering
- Smärtskolan kunskap för livet
- Ministerstyre för och nackdelar
- Tack för att ni har lyssnat
- Vad är referatmarkeringar
- Redogör för vad psykologi är
- Stål för stötfångarsystem
- Tack för att ni har lyssnat
- Borra hål för knoppar
- Orubbliga rättigheter
- Hur räknar man standardavvikelse
- Tack för att ni har lyssnat
- Steg för steg rita
- Ledningssystem för verksamhetsinformation