Oracle financials
Download
1 / 13

Oracle Financials - PowerPoint PPT Presentation


  • 1432 Views
  • Updated On :

Oracle Financials Agenda FRS Chart of Accounts FRS Chart of Accounts vs. Oracle Chart of Accounts Overview of Oracle 11i Chart of Accounts and Project Accounting Department 30010 FRS Chart of Accounts Users key 10 digit account The first 6 digits are the account number

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Oracle Financials' - paul


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Oracle financials l.jpg

Oracle Financials

Kansas State University


Agenda l.jpg
Agenda

  • FRS Chart of Accounts

  • FRS Chart of Accounts vs. Oracle Chart of Accounts

  • Overview of Oracle 11i Chart of Accounts and Project Accounting

Kansas State University


Frs chart of accounts l.jpg

Department

30010

FRS Chart of Accounts

  • Users key 10 digit account

  • The first 6 digits are the account number

  • The account number tracks activity

  • The account number relates 4 additional attributes to FRS

Kansas State University


Frs chart of accounts4 l.jpg
FRS Chart of Accounts

  • The last 4 digits are the subcode

  • Subcodes are used for classifying and accumulating revenues and expenditures

  • The FRS subcode supplies the STARS subcode

Kansas State University


Frs chart of accounts5 l.jpg
FRS Chart of Accounts

Kansas State University


Oracle chart of accounts l.jpg
Oracle Chart of Accounts

  • The Oracle Chart of Accounts offers more “segments” for defining account data

    • Allows more flexibility

  • There are two levels to the Oracle Chart of Accounts

    • The Oracle General Ledger

      • Contains summary financial data

    • Oracle Project Accounting

      • Contains detailed expenditure transaction data

      • Defines data using a different set of detail segments

Kansas State University


Frs oracle l.jpg
FRS → Oracle

  • Project, Organization, Expenditure type, Task, and Source/Award

Kansas State University


Oracle chart of accounts poets poeta l.jpg
Oracle Chart of Accounts: POETS/POETA

  • Project

    • Similar to Account today

    • A Project may be a grant or an operating activity

    • A Project will carry the PCA needed for STARS funding

  • Organization

    • Equivalent to Department

  • Expenditure Type

    • Equivalent to today’s subcode

    • Tracks what money was spent on

Kansas State University


Oracle chart of accounts cont l.jpg
Oracle Chart of Accounts: (cont.)

  • Task

    • Every Project must have at least one Task assigned to it, but may have multiple Tasks

    • Using Tasks allows for greater precision in defining how money is spent or allocated

  • Source

    • The four-character state index code to which the transaction will be posted

    • The index code maps to the state fund

Kansas State University


Oracle chart of accounts cont10 l.jpg
Oracle Chart of Accounts: (cont.)

  • Award

    • Grants are the only Projects that will have awards

    • Projects and Tasks may be funded by more than one Award

    • Each award has an associated Index (Source)

Kansas State University


Clarifying concepts projects tasks and source awards continued l.jpg

Joint

Checking

Savings

Linda

Savings

Ted

Aunt

Gertie’s Trust

  • Restrictions:

    • - after18

    • - only spend income

Unrestricted

Clarifying Concepts: Projects, Tasks and Source/Awards (continued)

College

For Kids

House

Construction

Household

P

2 Other

1 Household

1 Arch Fees

2 Electrical

3 Plumbing

1 Tuition

T

2.1

lighting

2.2

security

2.3

HVAC

Loan

S/A

Restrictions:

- only tuition

Kansas State University


Clarifying concepts projects tasks and source awards continued12 l.jpg

State

Appropriations

Restricted

Fees

General

Fees

SRO

Clarifying Concepts: Projects, Tasks and Source/Awards (continued)

Controller’s

Office

P

T

Voucher/Audit

Cashiers/Loans

Main

Spon Proj

S/A

Kansas State University


Questions l.jpg
Questions

Kansas State University


ad