1 / 23

Web Finance at FAU

Web Finance at FAU. Web Finance Contacts . Bob Pope 7 - 2712 pope@fau.edu Dr. Rosanna Star Berzok 7 - 2932 rberzok@fau.edu. Module Summary. SCT Product Information FOAP String Accessing Self-Service Finance Looking up Codes Performing a Budget Query Performing an Encumbrance Query

gita
Download Presentation

Web Finance at FAU

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Web Finance at FAU

  2. Web Finance Contacts • Bob Pope 7 - 2712 pope@fau.edu • Dr. Rosanna Star Berzok 7 - 2932 rberzok@fau.edu

  3. Module Summary • SCT Product Information • FOAP String • Accessing Self-Service Finance • Looking up Codes • Performing a Budget Query • Performing an Encumbrance Query • Viewing Documents

  4. SCT Product Information • FAU’s purchase of Banner Finance, Human Resources and Student Information System • Implementation Schedule • Timeline

  5. SCT Banner FOAP Chart of Account Structure • F - Fund • O - Organization • A - Account • P - Program

  6. Fund Code • Alpha numeric 6 digit field (SAMAS was 6 numeric) • Self balancing set of accounts in which transactions are recorded and segregated to carry on specific activities or attain certain objectives • Fund codes are required when we need a Balance Sheet for a University department or specific entity, such as an Auxiliary, a Grant, a Construction Project

  7. Banner Funds • We will have many more fund codes than we presently have • A fund code is required to track cash and fund balance • Each grant will have a unique fund rather than a unique organization code • See SAMAS vs Banner Codes on http://www.fau.edu/admin/fiscal/sct/

  8. Organization CODE • Alpha Numeric 6 digit field (SAMAS – 9 digit numeric department number) • Designation for departmental / budgetary subdivisions • Banner provides hierarchy rollup structure for reporting purposes

  9. Account Code • Alpha Numeric 6 digit field (SAMAS – 6 digit numeric object code) • Codes used for asset, liability, equity, revenue, expenditure and/or transfer account classifications • (TYPICAL BEAN COUNTER STUFF) • We have retained the SAMAS codes and descriptions for Banner, with some consolidation

  10. Other Banner Features • On Line Real Time Access to Data, Transactions and Reports • Can use Microsoft Xcel, Access, Word to import and export data and for reporting • On Line Document Approvals • Security to limit access to data by individual or multiple FOAP codes

  11. Samples – Funds and Organizations

  12. Samples- Continued SAMAS Banner • 0001-000-00 P00100 • 0005-000-00 U00500 • 1000-000-01 A00000 • 1100-000-01 B10000 • 1600-000-01 B60000 • 4060-000-62 S06000 • 1070-000-14 J07000 • There are many, many more codes, of course

  13. Program Code • Alpha numeric six digit code (SAMAS – 2 digit numeric – External Program Code) • Each Organization code will have one Program Code, similar to SAMAS • Will be used for IPEDS and DCU reporting

  14. Banner Hierarchy Structure • All Banner codes are hierarchical • Allows for roll up reporting up to the highest level • Funds – 4 Levels • Organizations – 5 levels • Accounts – 4 levels

  15. Banner Organization Codes • The 1st Digit = Executive Level or Campus • P - President • R - VP Research • A - Provost and CAO • F - Sr. VP Finance and COO • G - Vice President and Architect • S - Sr. VP Student Affairs • U - Sr. VP University Advancement

  16. Banner Organization Codes- 1st Digit (Cont.) • B - Boca Campus • C - Commercial Campus • D - Davie Campus • E - Sea Tech • J - Jupiter Campus • K - Port St. Lucie Campus • T - Ft. Lauderdale – Downtown • H - Pembroke Pines • V - Vero Beach

  17. Banner Organization Codes – 2nd through 6th Digits • 2 – 4 = Digits 2 – 4 of the current SAMAS numbers whenever possible – some cases we had conflicts / repeats • Why? – Gives some recognition of old numbers • 5 – 6 = 00 – 99 and we have available AA-ZZ if we need it

  18. Banner Information on WEB • http://www.fau.edu/admin/fiscal/sct/ • Crosswalk of SAMAS to BANNER Organization Codes and Funds: • GO TO: SAMAS vs Banner Codes • Please look at this and notify Bob Pope 7-2712, or Sharon Brown 7-4475 if you see any problems or missing codes

  19. Accessing Self-Service Finance • Enter the URL Address: http://oasis2.fau.edu:8050/pls/TRNG/twbkwbis.P_GenMenu?name=homepage This is for training purposes only. You will be issued a personalized log in and a new url address • Enter Secure Area • From main menu, click on Financial Information Menu

  20. Financial Information • Budget Query • Encumbrance Query • Approve Documents • View Budget

  21. Look up Codes – this exercise for showing the wildcard feature • Click on Requisition • Scroll down to Code Look up section • Chart of accounts will be “1” • Code Criteria, we can choose what we are looking for • Use wildcard “%”

  22. Budget Query • Create a New Query • Type   • Budget Status by Account • Budget Status by Organizational Hierarchy • Budget Quick Query Choose one and depress “Create Query” OR You can Retrieve Existing Query Click on down arrow from “Saved Query”  Use retrieve query

  23. Encumbrance Query Always use “1” Search for the fund Search for the organization

More Related