Oracle Financials - PowerPoint PPT Presentation

paul
oracle financials l.
Skip this Video
Loading SlideShow in 5 Seconds..
Oracle Financials PowerPoint Presentation
Download Presentation
Oracle Financials

play fullscreen
1 / 13
Download Presentation
Oracle Financials
1479 Views
Download Presentation

Oracle Financials

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Oracle Financials Kansas State University

  2. 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

  3. 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

  4. 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

  5. FRS Chart of Accounts Kansas State University

  6. 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

  7. FRS → Oracle • Project, Organization, Expenditure type, Task, and Source/Award Kansas State University

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. Questions Kansas State University