Oracle General Ledger Oracle????

1
Oracle General LedgerOracle????

• ???
• iampcl_at_yahoo.com

2003/09/30
2
Class Schedule

• Day 1 (9/30)
• Overview ??
• Set of books ??
• Journals ??
• Day2 (10/7)
• Budgeting ??
• Advanced account structure ??????
• Reporting tools ????
• Accounting for foreign and multiple currencies ???

3
Agenda

• Overview
• Set of books
• Journals

4
Oracle ERP Overview
?? Inventory
5
????(Accounting)

• ?????
• ??????? (Economic Events)
• ???? (Decision)
• ?????????,?????????,?????????????,??????
• ?? vs. ??

?????
?????
???? ???
6
??????????
????? ?????
?????? ??/?????
??,??,?????? ??,????
???? ????
7
??????
??
??
??/??
??/??
??/??
??
??
??
????
8
???????

• ??????
• ?????,??,????????
• ??????????????
• ??????
• ?????????????
• ??????
• ???????????????,??????
• ??????
• ????????,????????

9
?????????
??
?????
? ?? ???
?? ?? ??
10
?????????

• ?1??????100,000?

??
?????
? 100,000 ?? ??
?? ?? 100,000 ??
11
?????????

• ?2???????30,000?

??
?????
? 70,000 ?? ?? 30,000
?? ?? 100,000 ??
12
?????????

• ?3???????20,000?

??
?????
? 50,000 ?? 20,000 ?? 30,000
?? ?? 100,000 ??
13
???? (Account)

• ????????????
• ??????????????,?????????????(account),??????????

??
?????
?? 50,000 ?? 20,000 ????
30,000
???? ???? 100,000 ????
????? ??????
????? ??????
14
?????????????
?? ??
?????
?? ?? ????
????????
?? ?? ???? ?? ?? Asset (A) Liability
(L) Owners Equity Revenue (R) Expense
(E)
??? Income Statements
???????Statement of Changes in OE
????? Balance Sheet
15
????

• ??(Debit, Dr.) ??(Credit, Cr.)

??(??) ??????(??)
?? ??
??/?? ?? (????) ??
???????/?? ?? ?? (????)
???? ????
16
?????(Chart of Account)
??? ???? ????
???? ------------ ---------------------
------------ 1101 ?? ?? 1102 ??
?? 1401 ???? ?? 2101 ????
?? 3101 ???? ????
17
??(Journal)

• ???????,????????????????
• ???????
• ??????,??20000

????Journal entry
? ? ????910002 ????91.01.02 ????
???? ?? ???? ???? ------------ ------------
------------------ ------------
------------ 1401 ???? ?????? 20,000 1101 ??
?????? 20,000
18
??-????

• ????????
• ?????????????
• ????????
• ???????????????

???? ???? ?? ???? ???? ? ?
???? ???? ------------ ------------
------------ ------------ ------------------
------------ ------------ 9200001 92.01.01 1101
?? ?????? 100,000 9200001 92.01.01 3101
???? ?????? 100,000
9200002 92.01.02 1401 ????
?????? 20,000 9200002 92.01.02 1101 ??
?????? 20,000 9200003 92.01.03
1102 ?? ?????? 50,000 9200003 92.01.03
1101 ?? ?????? 50,000
19
??(Post)-????(Ledger)

• ????????
• ????????????????????
• ????????
• ??????????????

???? ????1101 ?????? ???? ??
? ? ???? ???? ?? ------------
------------ ------------------- -----------
------------ -------------- 9200001 92.01.01
?????? 100,000
100,000 9200002 92.01.02 ??????
20,000 80,000 9200003 92.01.03 ??????
50,000 30,000

100,000 70,000
20
??????????

• ???? ???? ????????
• ----------- ------------ -----------------------
  -
• ? ? ??
• ? ? ??
• ? ? ??
• ? ? ??

21
??????
? ? ????910002 ????91.01.02 ????
???? ?? ???? ???? ------------ ------------
------------------ ------------
------------ 1401 ???? ?????? 20,000 1101 ??
?????? 20,000
??
?? 20,000
???? ????1101 ?????? ???? ??
? ? ???? ???? ?? ------------
------------ ------------------- -----------
------------ -------------- 9200001 92.01.01
?????? 100,000
100,000 9200002 92.01.02 ??????
20,000 80,000 9200003 92.01.03 ??????
50,000 30,000

100,000 70,000
??
22
??????
??? ???? XXX ????
(XXX)
???
????? ------------------------------ ??
XXX ?? XXX
???? X
??? 1000 ?? XXX 1100
???? XXX 1101 ?? XXX 1102 ????
XXX
????? ?? XXX ????
XXX
23
?????????????
????
??
??
????
???
??
??
??
????
??
??
??
?? ????
????
??
??
??
????????
????????
????
????
??
???
???
???
??
???
???
??????
???
???????
?????
?????
??
???
???
??????
24
The General Ledger Accounting Cycle
(JE Functional Currency)
(JE Functional/Foreign Currency)
Open Period
Convert
Create Journal Entries
Calendar
Correct Errors
Review Journal Details
Close Period
Post Journals
Run Reports
Review Account Balances
Translate
Functional Balances
Revalue
Foreign Balances
25
Using Oracle General Ledger
Record
Analyze
Review
Manipulate
OracleGeneral Ledger
26
Integrating with Subledgers

• Exporting Information to GL
• Payables Payments and invoices
• Receivables Debit/Credit memos, invoices,
  receipts, guarantees
• Assets Deferred and standard depreciation
  expense transactions
• Projects Labor cost, usage cost, revenue
  information
• Purchasing Accrued receipts
• Cost Management/Inventory Inventory and work in
  process transactions

OracleGeneral Ledger
27
Agenda

• Overview
• Set of books
• Journals

28
3 Elements for a Set of Books
Chart of Accounts ??????
Accounting Calendar ????
Currencies ??
29
Components of 3 Elements
Account Structure
Value sets ?????
Segment values ???
Security rules??????
Cross-validation rules??????????
Accounting Calendar
Periods ????
Period types ????
Currencies
30
Account Structure

• ?????????????????
• ???????Accounting Flexfield???

01 22 - 1102221 - 100- A001
Value
Segment 2
Value Set
Accounting Flexfield??????
31
Defining Value Sets Segment Values
Value_Set 1
Value_Set 2
Value_Set 3
Format Char Maximum size 4 Validation Indepen
dent
Format Number Maximum size 3 Validation Indep
endent
Format Char Maximum size 2 Validation Indepen
dent
100 101
1000 1001
01 02
Values
32
Defining Chart of Account
Application
Accounting
Accounting
Flexfield
Flexfield
Segment
Segment
Segment
Segment
Value Set
Value Set
Value Set
Value Set
Value
Value
Value
Value
Value
Value
Value
Value
33
Accounting Flexfield
34
Segments
35
(No Transcript)
36
Value Sets
37
Values
38
Accounting Flexfield ???????
??segment????(Values)?????????
?? Value Set??Segment??????
?????(Alias)???????
39
Using Dynamic Insertion

• Dynamically create new account combinations.
• Dynamic insertion can be enabled or disabled at
  any time.
• All new combinations must satisfy all defined
  cross-validation rules before they are accepted.

40
Defining Flexfield Security Rules

• Restrict data entry and online inquiry to
  specific values by using flexfield security rules.

Account Segment
s 0000 to 9999
Include
s 1000 to 3999
Exclude
41
Defining Cross-Validation Rules

• Prohibit creation of invalid account combinations
  using cross-validation rules.
• Use cross-validation rules in combination with
  dynamic insertion.
• Define cross-validation rules before entering a
  chart of accounts.

42
Accounting Calendar

• Create a calendar to define an accounting year
  and the periods that it contains.
• Periods(????)
• Period Type
• Calendar(???)
• Fiscal(????)
• Period Open/Close

43
(No Transcript)
44
Currencies

• Create New Currencies
• Predefined Daily Conversion Rate Type
• Spot
• Corporate
• User
• European Monetary Union (EMU) Fixed
• Custom Rate Type

45
(No Transcript)
46
Creating a Set of Books

• You must create at least one set of books before
  you can use Oracle General Ledger.
• Required steps include
• Defining Accounting Flexfields
• Value sets
• Segments
• Segment values
• Defining calendar periods and calendar period
  types
• Defining currencies
• Defining your set of books and assigning it to a
  responsibility

47
(No Transcript)
48
Responsibility Definition

• Responsibility
• A collection of authorizations.

49
Responsibility
50
Agenda

• Overview
• Set of books
• Journals

51
Journal Entry Types
Mass Allocations ?????
52
Journal Creation Methods

• Manual Entry
• Reversals
• Recurring
• MassAllocations

Journal Import
????
???
Journal Wizard
????
53
Journal
54
Posting Journals

• Update balances by posting journals
• Manual Post
• Auto Post
• Criteria Set
• Schedule
• Un-post Journal
• Control total violations
• Posting to unopened periods
• Unbalanced journal entries

Account Balance
Prepost 500 Journal 25 After
post 525
55
Reviewing and Correcting Balances
Enter and post journals
Review balances
No
Are the account balances correct?
Yes
End
56
Creating Reversing Journals
Generate a reversal of any journal entry
Create Reversal
57
Recurring Journals

• There are three major types of recurring
  journals.
• Skeleton (Setup Account, No Amount)
• Standard (Setup Account, Constant Amount)
• Formula (Setup Account, Variable Amount)

Dr. Temporary LaborltNo Amountgt Cr. Salaries
Payable..ltNo Amountgt
Dr. Auto Lease Expense. . . .ltConstant
Amountgt Cr. Accounts Payable..ltConstant Amountgt
Dr. Rent Expense. . . .ltVariable
Amountgt Cr. Rent Payable..ltVariable Amountgt
58
MassAllocations Overview

• A single journal entry formula that allocates
  revenues and expenses across a group of cost
  centers, departments, divisions, and so on.

Total rent
1/3
1/3
1/3
Tokyo rent
Paris rent
Chicago rent
59
Defining MassAllocation Journals Exmple

• In Nov. 1998, the organization spends 10,000
  dollars for rent

Dr. Total rent expense 10,000 dollars
Cr. Rent Payable 10,000 dollars

• The organization want to allocate to 3
  departments

Human Resources 45 of total floor space
Research 30 of total floor space
Finance 25 of total floor space

• The rent expense is redistributed using the
  following journal entry

Dr. Human Resources rent4,500 dollars Dr.
Research rent ..3,000 dollars Dr. Finance
rent .....2,500 dollars Cr. Total
rent expense 10,000 dollars
60
Session Summary
61
Session Summary

• General Ledger concept and process
• Creating a set of books by defining a chart of
  accounts, accounting calendar, and currencies
• Entering and posting journals