Oracle General Ledger

3. Oracle General Ledger Overview

Baws

pre

4. Functions and Features

5. Global Accounting Engine

Accounting Methods

Yourcand results, Three major aiverances are

7. Chart of Accounts

Your chart of accounts I= a list of Accounting
Flextields you create to identity general ledger
This Newbie structure Is made up or subfields or

on [Deparment] Account | Project

Building the Chart of Accounts Structure

Define a flexible chart of accounts structure:
Create up to 30 segments with a maximum of 25
characters per segment

Maximum total length allowed Is 240 characters
Define each segment name and the order in which
it appears
Attach a list of valid values to each segment

Identifying Business Requirements

identiry the aspects of your business that you need to
rack and analyze; pay Specific attention to aspects
hat span several applications. Examples include:

Company, legal entity, fund

Division, region, territory, state, country

Location, plant, office, store

Cost center, department, runction

Natural Account categories:

asset, lability, owner's equity, revenue and expense
Product, product line, line of business, channel
Project, phase, task, job, work order

8. Identifying Segment Requirements

Assign each business dimension as a separate
segment.
Avoid having more than one meaning for each
segment.

Creating a Worldwide

ee |

9. Worldwide Chart of Accounts Example

Canada and the United Kingdom reserve the riant-
Segment does not roll up to the consolidated
financials compiled at Headquarters.

Creating Vertical Structures

Use vertical parent rollups on spec!
when possible rather than

10. Independent Segment | Dependent Segment

Example Example

Use value sets to control the characteristics and
format of the Accounting Flexfield segment

Validation:

independent | | independant Independent

13. Vaiue_set? | [Vamezsotz ] [voue sets
Format! Format:
‘char Char

Max size: 2 Max size: 3 Max size: 4

Validation: Validation: Validation Validation:
independent | | independent | | independent | | independent

Attributes for each value Include:
Translated Value
Description
Parent
Group and level
Segment qualifiers
Allow budgeting and posting
Account type — natural account segment values
Contro! Account
Reconciliation Flag
Enabled
Date From and To

16. e
2
E
£
3
3
E
N
5
6
4
?
o
n
4
i
E
4
3
a
3
£
€

17. —

20. Using Journal Entry
Sources and Categories

Use journal entry sources ana categories to
Sitfarantinte Journal entries and to Sntance you

New York Consulting Revenue Dollars and Hours

Dr. 04.420.4310.0000.000 $10,000 so Hours

22. Parent Levels in an Account Hierarchy

23. =
=
>
Cua
us

Journal Entry Types

=!
Es
=.

24. Journal information is stored in three Oracle General
Ledger tables.

Journal entry, dotauk the name and Intest open y
Ne journal entry By Gate

L_se_sarcnes

27. Update balances by posting journals.

Aster post

29. Rerform an Account Inquiry, and drill down to review

You can view General Ledger journals or subledger
accounting entries In a graphical T-account format.

32. Every Journal entry in Oracle General Ledger has three

ac

components,

33. A manual journal entry is entered directly into Oracle
General Ledger. Typical manual Journal entries include
Functional currency entries
Foreign currency entries
Statistical entries

43. Account Balance

| Prepost 5500
<= Journal entry $ 25
senor jotas oY After post $525
>

Report end inquire

Post Journal —— Sn updated
Account balances

44. Speciry the parameters to select journal batches to be
posted automatically.

[Source 2]
FEstogey — Jepesimyoran
ify or AU
_ —_ —

You can run the AutoPost program from
AutoPost Criteria Sets window by selecting the
‘Submit AutoPost button
Submit Request window

Parameters window

You can easily schedule AutoPost runs to fit the needs

of your organization

Periodically: Specity Interval of minutes,
on specific saya: se lect day of we Kor month

47. Run this Request...

Standard Reports and Listings

hon-financial Information for General Ledger data

48. Oracle General Ledger gives you a complete set of
standard reports. Categories of standard reports and
listings include:
Account Analysis Financial Statement
Generator
Budget
Chart of Accounts Generalicecaer:

: Journals
Multi-Compam

Accounting and Trial Balance
Consolidation He
Currency ower

Applications Desktop Integrator (ADI) Is an extension
to Gracie Applications that offers full cycle accountna

El Yournat wizare

io
[ES Anais wizure
Es

Applications Desktop Integrator (ADI) has Wizards that
let you modify or access specific areas of General
Ledger:

Journat wizera [EEE] natyate w

49. | 1
Close
General Ledger Minimize
Applications Help
Options Tip Wizard

50. ie

Multiple Sets of Books

Transactions must be entered,
revalued, and translated In
each Set of Books.

Payables Journal ontry

MRC Sets of Books

Converted in the Reporting Books

Transactions entered in the
Primary Set of Books are
automatically converted to all
Reporting Sets of Books.

52. Foreign Currency

€

ES convent eee

er

Rate Types:
“Spot
-Corporate
EMU Fixed
“User Defined

Functional Curreney

Journals Journ:

54. Revalue account balances to reflect the change in the
foreign currency rate from the date a transaction is
entered and the reporting date.

55. Functional eurreney

Conversion at the time of the
foreign curreney transaction

Foreign
currencies

Functional eurreney

Revaluation at the end of
the accounting period

56. Ts the foreign Gurreney
Receivable Still Unpaid?

[Eetiect Foreign Eurreney] Sain/Loss Account

ee 10,000 Euro

Accounts Recsivab 208,000 uss

HL

57. Foreign currency translation is a process that lets you
restate your functional currency account balances into
a reporting currency.

59. If you have defined historical rates or amounts,
Oracle General Ledger selects one of two amounts
that is used to arrive at a translated balance for
your account:

‘Account Balance

Net Activity

The amount differs depending on the type of
account to which the historical rate or amount
applies:

Revenue/Expense

Asset/Liapility

Owner's Equity

61. Create
Journal
Entries

Review
Account
Balances

Translate

Post
Journals

Revalue