PeopleSoft Transaction Types November 2011 1 1 Learning - - PowerPoint PPT Presentation

▶
peoplesoft transaction types
SMART_READER_LITE
LIVE PREVIEW

PeopleSoft Transaction Types November 2011 1 1 Learning - - PowerPoint PPT Presentation

Jan 29, 2024 103 likes •950 views

PeopleSoft Transaction Types November 2011 1 1 Learning Objectives For each type of transaction: Define and explain the use Provide examples of how to process an entry 2 Definition of Terms Account: Groups transactions related

slide-1
SLIDE 1

1 1

PeopleSoft Transaction Types

November 2011

slide-2
SLIDE 2

2

Learning Objectives

» For each type of transaction:

› Define and explain the use › Provide examples of how to process an entry

slide-3
SLIDE 3

3

Definition of Terms

» Account: Groups transactions related to common financial statement categories such as assets, liabilities, revenues, and expenses. » Business Unit: used to classify transactions by the different active Business Units in which they belong. » Feeder System: External databases and/or dedicated systems that control information to be transmitted to the General Ledger.

slide-4
SLIDE 4

4

Definition of Terms

» ChartField: Alphanumeric fields use to classify financial information for reporting of the University’s financial transactions. » ChartField String: A combination of ChartFields to classify financial information. » MoCode: an abbreviation of a ChartField string - note the Account ChartField is not included in a Mocode.

slide-5
SLIDE 5

5

Transaction Types

» Journal Entry – JE » Correcting Entry – CE » Internal Service Entry - ISE » Payroll Correcting Entry – PCE » Transfer Journal Entry – TRE » Cash Receipts Report – CRR » Account Receivable Report – ARR

slide-6
SLIDE 6

6

UM Web Applications (Web Apps)

» Simplifies process of entering transactions » A template to:

› Reduce the chance for error › Enter transactions easier

» Contact the Campus Accounting Office for access.

slide-7
SLIDE 7

7

UM Web Applications

» Enter the following URL into the web browser : https://webapps.umsystem.edu/

slide-8
SLIDE 8

8

Web Applications

slide-9
SLIDE 9

9

Journal Entry (JE)

slide-10
SLIDE 10

10

Journal Entry (JE)

slide-11
SLIDE 11

11

Journal Entry (JE)

» Only used to record original accounting entries

› All entries not automatically generated through a feeder system, such as:

› Recording investment income earned › Allocating expenses between departments

slide-12
SLIDE 12

12

Journal Entry (JE)

» Journal Entry is NOT used to:

› Record internal revenue › Make transfers between funds › Correct transactions › Record receipt of cash

slide-13
SLIDE 13

13

Journal Entry (JE)

» Journal entry cannot be used to post to:

Account number Description 1100000 to 111270 Cash accounts at banks 132200 Accounts Receivable 133050 Awards (grants) receivable 190000 Cash 210000 Accounts Payable 211000 Accounts Payable 300000 Net Assets 350000 Beginning Balance 700000 to 708299 Salary and Wage Accounts 708301 to 709999

slide-14
SLIDE 14

14

Journal Entry (JE)

slide-15
SLIDE 15

15

Journal Entry (JE)

slide-16
SLIDE 16

16

Journal Entry (JE)

slide-17
SLIDE 17

17

Journal Entry (JE)

slide-18
SLIDE 18

18

Journal Entry (JE)

What does the entry accomplish? Why is it being done? Who wants it done? How were the numbers calculated?

slide-19
SLIDE 19

19

Journal Entry (JE)

slide-20
SLIDE 20

20

Journal Entry (JE)

slide-21
SLIDE 21

21

Journal Entry (JE)

Click here to return to listing of transaction types

slide-22
SLIDE 22

22

Correcting Entry (CE)

» Used to correct a transaction that posted to the University Financials System. » Is not used to correct a payroll transaction. » Cannot impact any of the Transfer Accounts:

Type Transfer in Transfer Out Mandatory 390000-390999 860000-861999 Non-Mandatory 391000-393999 861000-863999

slide-23
SLIDE 23

23

Correcting Entry (CE)

slide-24
SLIDE 24

24

Correcting Entry (CE)

slide-25
SLIDE 25

25

Correcting Entry (CE)

slide-26
SLIDE 26

26

Correcting Entry (CE)

slide-27
SLIDE 27

27

Correcting Entry (CE)

slide-28
SLIDE 28

28

Correcting Entry (CE)

What does the entry accomplish? Why is it being done? Who wants the transaction done? How were the numbers calculated?

slide-29
SLIDE 29

29

Correcting Entry (CE)

slide-30
SLIDE 30

30

Correcting Entry (CE)

slide-31
SLIDE 31

31

Correcting (CE)

slide-32
SLIDE 32

32

Correcting Entry (CE)

Click here to return to listing of transaction types

slide-33
SLIDE 33

33

Internal Service Entry (ISE)

» Used to record transactions between University Departments. » The department providing the service prepares the entry.

slide-34
SLIDE 34

34

Internal Service Entry (ISE)

» The revenue (credit) side of the transaction must be between the account ranges:

› 403000 - 403800 Extension Educational Fees, or › 430000 - 432499 Non-Taxable Sales, or › 450000 – 452999 Internal Sales

slide-35
SLIDE 35

35

Internal Service Entry (ISE)

» The expense (debit) side of the transaction must be between the account ranges:

› 600000 - 605000 Cost of Goods Sold, or › 720001 – 800999 Non-Payroll Expenses

slide-36
SLIDE 36

36

Internal Service Entry (ISE)

slide-37
SLIDE 37

37

Internal Service Entry (ISE)

slide-38
SLIDE 38

38

Internal Service Entry (ISE)

slide-39
SLIDE 39

39

Internal Service Entry (ISE)

slide-40
SLIDE 40

40

Internal Service Entry (ISE)

60130

slide-41
SLIDE 41

41

Internal Service Entry (ISE)

What does the entry accomplish? Why is it being done? Who wants the transaction done? How were the numbers calculated?

slide-42
SLIDE 42

42

Internal Service Entry (ISE)

slide-43
SLIDE 43

43

Internal Service Entry (ISE)

slide-44
SLIDE 44

44

Internal Service Entry (ISE)

Click here to return to listing of transaction types

slide-45
SLIDE 45

45

Payroll Correcting Entry (PCE)

» Used to make retroactive adjustments to payroll and related benefit expenditures. » Cannot make with a JE or CE. » For most users, cannot process a PCE more than 2 months from the period the original entry was

  • posted. Older transactions processed by:

› Sponsored Programs Office or › Accounting Office

slide-46
SLIDE 46

46

Payroll Correcting Entry (PCE)

» A PCE can only be made to Salary and Benefit accounts, which are in the ranges of:

› 700000-708500 (Salaries) › 710000-717000 (Benefits)

slide-47
SLIDE 47

47

Payroll Correcting Entry (PCE)

slide-48
SLIDE 48

48

Payroll Correcting Entry (PCE)

slide-49
SLIDE 49

49

Payroll Correcting Entry (PCE)

slide-50
SLIDE 50

50

Payroll Correcting Entry (PCE)

slide-51
SLIDE 51

51

Payroll Correcting Entry (PCE)

slide-52
SLIDE 52

52

Payroll Correcting Entry (PCE)

What does the entry accomplish? Why is it being done? Who wants the transaction done? How were the numbers calculated?

slide-53
SLIDE 53

53

Payroll Correcting Entry (PCE)

slide-54
SLIDE 54

54

Payroll Correcting Entry (PCE)

slide-55
SLIDE 55

55

Payroll Correcting Entry (PCE)

Click here to return to listing of transaction types

slide-56
SLIDE 56

56

Transfer Journal Entry (TRE)

» Movement of funds between ChartField Strings » Not considered:

› expenses to the contributing fund › revenue to the recipient fund

slide-57
SLIDE 57

57

Transfer Journal Entry (TRE)

» Types of Transfers › Non-Mandatory › Transfers at the University’s Discretion › Mandatory – required by: › Law, or › Contractual Obligation

slide-58
SLIDE 58

58

Transfer Journal Entry (TRE)

» Transfer Accounts:

Type Transfer in Transfer Out Mandatory 390000-390999 860000-860999 Non-Mandatory 391000-393999 861000-863999

slide-59
SLIDE 59

59

Transfer Journal Entry (TRE)

Click here to return to listing of transaction types

slide-60
SLIDE 60

60

Cash Receipts Report (CRR)

» Used to deposit cash receipts other than payments on accounts receivable » Only accessible if the role has been assigned to the user » Per CRM 101, Business Services Office must authorize Cash Receiving Locations

slide-61
SLIDE 61

61

Cash Receipts Report (CRR)

slide-62
SLIDE 62

62

Cash Receipts Report (CRR)

slide-63
SLIDE 63

63

Cash Receipts Report (CRR)

slide-64
SLIDE 64

64

Cash Receipts Report (CRR)

slide-65
SLIDE 65

65

Cash Receipts Report (CRR)

slide-66
SLIDE 66

66

Cash Receipts Report (CRR)

slide-67
SLIDE 67

67

Cash Receipts Report (CRR)

slide-68
SLIDE 68

68

Cash Receipts Report (CRR)

slide-69
SLIDE 69

69

Cash Receipts Report (CRR)

slide-70
SLIDE 70

70

Cash Receipts Report (CRR)

slide-71
SLIDE 71

71

Cash Receipts Report (CRR)

slide-72
SLIDE 72

72

Cash Receipts Report (CRR)

slide-73
SLIDE 73

73

Cash Receipts Report (CRR)

slide-74
SLIDE 74

74

Cash Receipts Report (CRR)

slide-75
SLIDE 75

75

Cash Receipts Report (CRR)

slide-76
SLIDE 76

76

Cash Receipts Report (CRR)

Click here to return to listing of transaction types

slide-77
SLIDE 77

77

Account Receivable Report (ARR)

» Similar to a CRR in form » May not be combined with other types of deposits. » May only be used to deposit payments of Miscellaneous Accounts Receivable, such as:

› Grants receivables › MOREnet billings

slide-78
SLIDE 78

78

Accounts Receivable Report (ARR)

slide-79
SLIDE 79

79

Account Receivable Report (ARR)

slide-80
SLIDE 80

80

Account Receivable Report (ARR)

slide-81
SLIDE 81

81

Account Receivable Report (ARR)

slide-82
SLIDE 82

82

Accounts Receivable Report (ARR)

Click here to return to listing of transaction types

slide-83
SLIDE 83

83

Additional Information

› Cash Receipts Manual –– additional information on cash handling and cash controls. › Other related training available:

› Financial Compliance Training Website https://doit.missouri.edu/training/enterprise/