General Ledger (GL1)

Full text

(1)

General Ledger (GL1)

Presented by Barbara Thiss | August 15, 2016

FO R O CT OB ER 3, 201 6

GO LI VE

(2)

C U S T O M E R R E S O U R C E C E N T E R

Objectives

 Create, edit, submit, approve & post Journal Entries

 Create, edit, and submit Auditor’s Transfers

 Copy Journal Entries

 Generate basic reports

 Do basic GL maintenance:

– View ChartFields – View Combo Edits – Add ChartFields

– Inactivate a ChartString

 Use the Sandbox to replicate training activities

2

B Y T H E E N D O F T H E S E S S I O N , Y O U W I L L B E A B L E T O :

This 5.5-hour class is for staff responsible for general accounting.

It covers all aspects of General Ledger journals and Auditor’s Transfers as well as GL

Maintenance and reports.

(3)

Agenda Agenda

Morning

Part I: Overview (15 min)

Agenda Objectives Housekeeping

Introduction to PeopleSoft What is General Ledger?

Part II: Processing Journal Entries (60 min)

Journal Entries ACTIVITY 1

BREAK (15 min)

Part III: Processing Auditor’s Transfers (15 min)

Auditor’s Transfers ACTIVITY 2

Part IV: Advanced Journal Entry Features (15 min)

Copying Journal Entries ACTIVITY 3 Other options

Afternoon

Part V: FIS to PeopleSoft Conversion (15 min)

Part VII: Reviewing Journal Entries

ACTIVITY 4

Part VIII & IX: Reports, Inquiries and Queries (45 min)

GL Detail Query ACTIVITY 5 Ledger Inquiry

Trial Balance Report

Part VI: GL Maintenance (2 hours)

ChartField Values

ChartField Reports ACTIVITY 6 Review Combo Edit Data ACTIVITY 7 Adding a new ChartField Inactivating a

ChartString

Reviewing VALBTL, DDACCT, CHACCT

Go Live review

(4)

C U S T O M E R R E S O U R C E C E N T E R

Housekeeping

 Restrooms

 Breaks

 Lunch

 Emergency Evacuation

4

(5)
(6)

C U S T O M E R R E S O U R C E C E N T E R

Q & A Forum

6

Read posts

(public)

New Question/Post

(requires Google login)

(7)

What is General Ledger?

p.3

(8)

C U S T O M E R R E S O U R C E C E N T E R

ChartField Strings

8

p.4

(9)

PeopleSoft Terms

p.4

(10)

C U S T O M E R R E S O U R C E C E N T E R

Agenda

Morning

Part I: Overview (15 min)

Agenda Objectives Housekeeping

Introduction to PeopleSoft What is General Ledger?

Part II: Processing Journal Entries (60 min)

Journal Entries ACTIVITY 1

BREAK (15 min)

Part III: Processing Auditor’s Transfers (15 min)

Auditor’s Transfers ACTIVITY 2

Part IV: Advanced Journal Entry Features (15 min)

Copying Journal Entries ACTIVITY 3 Other options

LUNCH (1 hour)

Afternoon

Part V: FIS to PeopleSoft Conversion (15 min)

Part VII: Reviewing Journal Entries

ACTIVITY 4

Part VIII & IX: Reports, Inquiries and Queries (45 min)

GL Detail Query ACTIVITY 5 Ledger Inquiry

Trial Balance Report

Part VI: GL Maintenance (2 hours)

ChartField Values

ChartField Reports ACTIVITY 6 Review Combo Edit Data ACTIVITY 7 Adding a new ChartField Inactivating a

ChartString

Reviewing VALBTL, DDACCT, CHACCT

Go Live review

Wrap up and Closing (20 min)

10

(11)

http://crc.sdcoe.net

PLEASE FIND YOUR LOGIN SLIP.

Let’s log into the Training database.

Click

Links.

(12)

C U S T O M E R R E S O U R C E C E N T E R

12

(13)
(14)

C U S T O M E R R E S O U R C E C E N T E R

14

How to

Create and Process a Journal Entry (pp.6-26)

P R A C T I C E T O G E T H E R

p.7

(15)

ACTIVITY 1

J o u r n a l E n t r y P r o c e s s

Let’s do this part together.

1. Refer to GL1 Training Guide: pp.6-26

2. Navigate to General Ledger > Journals > Journal Entry >

Create/Update Journal Entries

Use information on Activity Sheet to complete this on your own.

3. Create a Journal Entry and complete the process

 Were you able to get a Journal ID?

 How can you tell your journal is posted?

p. 6

(16)

C U S T O M E R R E S O U R C E C E N T E R

Break Time

16

(17)

Agenda

Morning

Part I: Overview (15 min)

Agenda Objectives Housekeeping

Introduction to PeopleSoft What is General Ledger?

Part II: Processing Journal Entries (60 min)

Journal Entries ACTIVITY 1

BREAK (15 min)

Part III: Processing Auditor’s Transfers (15 min)

Auditor’s Transfers ACTIVITY 2

Part III: Advanced Journal Entry Features (15 min)

Copying Journal Entries ACTIVITY 3 Other options

Part V: FIS to PeopleSoft Conversion (15 min)

Part VII: Reviewing Journal Entries

ACTIVITY 4

Part VIII & IX: Reports, Inquiries and Queries (45 min)

GL Detail Query ACTIVITY 5 Ledger Inquiry

Trial Balance Report

Part VI: GL Maintenance (2 hours)

ChartField Values

ChartField Reports ACTIVITY 6 Review Combo Edit Data ACTIVITY 7 Adding a new ChartField Inactivating a

ChartString

Reviewing VALBTL, DDACCT, CHACCT

Go Live review

Afternoon

(18)

C U S T O M E R R E S O U R C E C E N T E R

Auditor’s Transfer Processing

18

p. 28

(19)

P R A C T I C E T O G E T H E R

p.27

How to

Create and Process an

Auditor’s Transfer between funds

(pp.28-39)

(20)

C U S T O M E R R E S O U R C E C E N T E R

20

ACTIVITY 2

A u d i t o r ’ s T r a n s f e r P r o c e s s

Let’s do this part together.

1. Refer to GL1 Training Guide: pp. 27-39

2. Navigate to General Ledger > Journals > Journal Entry >

Create/Update Journal Entries

Use information on Activity Sheet to complete this on your own.

3. Create an Auditor’s Transfer and complete the process

 Were you able to get a Journal ID?

 Who approves Auditor’s Transfers?

 Who posts Auditor’s Transfers?

p.29

(21)

Auditor’s Transfers Between Districts

p.39

(22)

C U S T O M E R R E S O U R C E C E N T E R

Agenda

Morning

Part I: Overview (15 min)

Agenda Objectives Housekeeping

Introduction to PeopleSoft What is General Ledger?

Part II: Processing Journal Entries (60 min)

Journal Entries ACTIVITY 1

BREAK (15 min)

Part II: Processing Auditor’s Transfers (15 min)

Auditor’s Transfers ACTIVITY 2

Part III: Advanced Journal Entry Features (15 min)

Copying Journal Entries ACTIVITY 3 Other options

LUNCH (1 hour)

Afternoon

22

Part V: FIS to PeopleSoft Conversion (15 min)

Part VII: Reviewing Journal Entries

ACTIVITY 4

Part VIII & IX: Reports, Inquiries and Queries (45 min)

GL Detail Query ACTIVITY 5 Ledger Inquiry

Trial Balance Report

Part VI: GL Maintenance (2 hours)

ChartField Values

ChartField Reports ACTIVITY 6 Review Combo Edit Data ACTIVITY 7 Adding a new ChartField Inactivating a

ChartString

Reviewing VALBTL, DDACCT, CHACCT

Go Live review

Wrap up and Closing (20 min)

(23)

Copying a Journal Entry

p.41

(24)

C U S T O M E R R E S O U R C E C E N T E R

24

ACTIVITY 3

S e a r c h f o r J o u r n a l E n t r y , C o p y & E d i t

Let’s do this part together.

1. Refer to GL1 Training Guide pp. 41-43

2. Navigate to Main Menu > General Ledger > Journals > Journal Entry

> Create/Update Journal Entries

Do this on your own.

3. Create a copy using you journal ID from Activity #1

What is the new journal ID? _____________________________

4. Complete Journal process

Where can you see if the journal is posted? ____________________

pp.41-43

(25)

Other Journal Entry Options

 Unpost Journal pp.44-47

 Use Excel to create journal entries and to import to PeopleSoft pp.48-67

pp.44-67

(26)

C U S T O M E R R E S O U R C E C E N T E R

Lunch

26

(27)

Agenda

Morning

Part I: Overview (15 min)

Agenda Objectives Housekeeping

Introduction to PeopleSoft What is General Ledger?

Part II: Processing Journal Entries (60 min)

Journal Entries ACTIVITY 1

BREAK (15 min)

Part II: Processing Auditor’s Transfers (15 min)

Auditor’s Transfers ACTIVITY 2

Part III: Advanced Journal Entry Features (15 min)

Copying Journal Entries ACTIVITY 3 Other options

Afternoon

Part V: FIS to PeopleSoft Conversion (15 min)

Part VII: Reviewing Journal Entries

ACTIVITY 4

Part VIII & IX: Reports, Inquiries and Queries (45 min)

GL Detail Query ACTIVITY 5 Ledger Inquiry

Trial Balance Report

Part VI: GL Maintenance (2 hours)

ChartField Values

ChartField Reports ACTIVITY 6 Review Combo Edit Data ACTIVITY 7 Adding a new ChartField Inactivating a

ChartString

Reviewing VALBTL, DDACCT, CHACCT

Go Live review

(28)

C U S T O M E R R E S O U R C E C E N T E R

FIS to PeopleSoft Conversion Data

28

pp.69-72

(29)

ACTIVITY 4

R e v i e w S t a t u s o f G L J o u r n a l s pp.121-123

Let’s do this part together.

1. Navigate to: Main Menu > General Ledger > Journals > Journal Entry >

Create/Update Journal Entries

2. On the Find an Existing Value tab, enter parameters:

– Business Unit: 00700

– Journal Date: Change operator to between enter dates 07/01/2016 – T – Journal Header Status: Select the blank field

– Entered by: use you User ID – Click Search

Do this on your own.

3. Answer questions #3- #4 Review Answers

(30)

C U S T O M E R R E S O U R C E C E N T E R

Agenda

Morning

Part I: Overview (15 min)

Agenda Objectives Housekeeping

Introduction to PeopleSoft What is General Ledger?

Part II: Processing Journal Entries (60 min)

Journal Entries ACTIVITY 1

BREAK (15 min)

Part II: Processing Auditor’s Transfers (15 min)

Auditor’s Transfers ACTIVITY 2

Part III: Advanced Journal Entry Features (15 min)

Copying Journal Entries ACTIVITY 3 Other options

LUNCH (1 hour)

Afternoon

30

Part V: FIS to PeopleSoft Conversion (15 min)

Part VII: Reviewing Journal Entries

ACTIVITY 4

Part VIII & IX: Reports, Inquiries and Queries (45 min)

GL Detail Query ACTIVITY 5 Ledger Inquiry

Trial Balance Report

Part VI: GL Maintenance (2 hours)

ChartField Values

ChartField Reports ACTIVITY 6 Review Combo Edit Data ACTIVITY 7 Adding a new ChartField Inactivating a

ChartString

Reviewing VALBTL, DDACCT, CHACCT

Go Live review

Wrap up and Closing (20 min)

(31)

Queries

Do this process together

pp.123-125

Checking Cash Balance

(32)

C U S T O M E R R E S O U R C E C E N T E R

32

ACTIVITY 5

G L D e t a i l s Q u e r i e s Let’s do this part together.

Use current Period.

pp.123-125

(33)

ACTIVITY 5

Q u e r i e s

Do this on your own.

1. Locate the first journal entry you did by journal ID #.

2. Verify the account string and amount.

3. Are there any other journals with the same account string?

pp.121-123

(34)

C U S T O M E R R E S O U R C E C E N T E R

Ledger Inquiry Reports

34

Brief overview of reports.

Run this Inquiry together.

pp.126-133

(35)

Ledger Inquiry Reports

Click on Activities (drilldown)

pp.126-133

(36)

C U S T O M E R R E S O U R C E C E N T E R

Agenda

Morning

Part I: Overview (15 min)

Agenda Objectives Housekeeping

Introduction to PeopleSoft What is General Ledger?

Part II: Processing Journal Entries (60 min)

Journal Entries ACTIVITY 1

BREAK (15 min)

Part II: Processing Auditor’s Transfers (15 min)

Auditor’s Transfers ACTIVITY 2

Part III: Advanced Journal Entry Features (15 min)

Copying Journal Entries ACTIVITY 3 Other options

LUNCH (1 hour)

Afternoon

36

Part V: FIS to PeopleSoft Conversion (15 min)

Part VII: Reviewing Journal Entries

ACTIVITY 4

Part VIII & IX: Reports, Inquiries and Queries (45 min)

GL Detail Query ACTIVITY 5 Ledger Inquiry

Trial Balance Report

Part VI: GL Maintenance (2 hours)

ChartField Values

ChartField Reports ACTIVITY 6 Review Combo Edit Data ACTIVITY 7 Adding a new ChartField Inactivating a

ChartString

Reviewing VALBTL, DDACCT, CHACCT

Go Live review

Wrap up and Closing (20 min)

(37)

ChartField Values

Work together

p. 74

Navigate to:

Set Up Financials / Supply Chain > Common Definitions > Design ChartFields > Define Values > ChartField Values

Select an

Object

(38)

C U S T O M E R R E S O U R C E C E N T E R

ChartField Values

38

p.74

Review Object information.

(39)

Running Reports

Navigate to A

the report

Enter/find B

the Run Control ID

Enter or C

update the parameters

, then Run

Monitor the D

report process (if desired)

View the E

report

SAMPLE REPORT

INTRO

Basic steps for running a report:

(40)

C U S T O M E R R E S O U R C E C E N T E R

40

ACTIVITY 6

C h a r t F i e l d R e p o r t / C r e a t e R u n C o n t r o l I D

Refer to GL1 Training Guide: pp. 76-79

In Training Database:

Navigate: Set up Financial/Supply Chain > Common Definitions >

Design ChartFields > Reports > ChartField Reports

Do this on your own.

Name 2 Resources listed.

pp.75-78

(41)

N A V I G A T E T O G E T H E R

Review Combo Edits (Fund_Object)

pp.79-81

(42)

C U S T O M E R R E S O U R C E C E N T E R

42

ACTIVITY 7

R e v i e w i n g C o m b o E d i t D a t a

Do this on your own.

Refer to GL1 Training Guide: pp. 80-82 Combo Edits Fund_Resource

 How many rows were retrieved?

 Name 2 Resources that can be used with Fund 0100.

 Were you able to see more than 10 rows?

pp.80-82

(43)

Adding a ChartField Value (pp.83-87)

D E M O N S T R A T I O N

pp.83-87

(44)

C U S T O M E R R E S O U R C E C E N T E R

Agenda

Morning

Part I: Overview (15 min)

Agenda Objectives Housekeeping

Introduction to PeopleSoft What is General Ledger?

Part II: Processing Journal Entries (60 min)

Journal Entries ACTIVITY 1

BREAK (15 min)

Part II: Processing Auditor’s Transfers (15 min)

Auditor’s Transfers ACTIVITY 2

Part III: Advanced Journal Entry Features (15 min)

Copying Journal Entries ACTIVITY 3 Other options

LUNCH (1 hour)

Afternoon

44

Part V: FIS to PeopleSoft Conversion (15 min)

Part VII: Reviewing Journal Entries

ACTIVITY 4

Part VIII & IX: Reports, Inquiries and Queries (45 min)

GL Detail Query ACTIVITY 5 Ledger Inquiry

Trial Balance Report

Part VI: GL Maintenance (2 hours)

ChartField Values

ChartField Reports ACTIVITY 6 Review Combo Edit Data ACTIVITY 7 Adding a new ChartField Inactivating a

ChartString

Reviewing VALBTL, DDACCT, CHACCT

Go Live review

Wrap up and Closing (20 min)

(45)

Objectives Completed

 Create, edit, submit, approve & post Journal Entries

 Create, edit, and submit Auditor’s Transfers

 Copy Journal Entries

 Generate basic reports

– Queries – Inquires – Reports

 Do basic GL maintenance:

– View ChartFields

– Add ChartFields

– View Combo Edits

(46)

C U S T O M E R R E S O U R C E C E N T E R

Resources

 Co-workers

 CRC contact person

 Training Guides

 CRC web site

 HEAT Ticketing

 800-289-1500

46

(47)

Q & A

Before we go to the course evaluation, what kinds of questions can we answer?

COURSE EVALUATION

Please go to the Links page on the CRC website.

Scroll all the way to the bottom and click on Charlie Brown.

Figure

Updating...

References

Updating...

Related subjects :