1 / 26

Budget Revision Training - Background

Budget Revision Training - Background. Presented by: Planning & Analysis. Planning & Analysis Website: www.utrgv.edu/Planning-and-Analysis. Planning & Analysis Contacts.

joannew
Download Presentation

Budget Revision Training - Background

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. Budget Revision Training - Background Presented by: Planning & Analysis

  2. Planning & Analysis Website: www.utrgv.edu/Planning-and-Analysis

  3. Planning & Analysis Contacts ▪ Juan C. Gonzalez, Associate VP  ▪ Maria Aten, Sr Financial Analystjuan.gonzalez@utrgv.edumaria.aten@utrgv.edu  956-665-2121 956-882-6592 ▪ Richard Wilson, Director ▪ Magda Rangel, Sr Financial Analystrichard.wilson@utrgv.edumagda.rangel@utrgv.edu 956-665-8702 956-665-2924 ▪ Frances Rivera, Associate Director ▪ Jacob Gracia, Accountant IIfrances.rivera@utrgv.edujacob.gracia@utrgv.edu 956-665-2195 956-665-2962

  4. Topics to be covered Background Information • Budget revisions in general • GL Accounting String • GL Funds Inquiry • Funds Checking • Fiscal vs. Rollover Accounts • How to read account balances • How to Drill Down in Oracle

  5. What is a Budget Revision? • A budget revision (BR) is a temporary or permanent modification to the base budget. Who can submit a budget revision? • Any employee who has been granted the required responsibilities in Oracle. • Required responsibilities: • Budget Revision User • GL Inquiry (technically not needed to submit a BR but needed to review project)

  6. When is a budget revision needed? • To set up the initial budget for a project • Planning & Analysis will do initial set up if on non-sponsored project request form • To move budget within a project (from one object code to another) • To align budget with actuals or anticipated revenues • To address or avoid funds checking failures (non-labor 60000 line) • To fund position changes • To fund benefits and longevity • E&G accounts done by Planning & Analysis • Non-E&G accounts done by departments • To transfer budget between projects (from one project to another)

  7. Which types of transfers are not allowed? • You should NOT do a transfer across funds (there are very few exceptions and these should only be done by the Planning & Analysis office. Please contact us for assistance) E&G Fund 11 Designated Fund 21

  8. Transfers not allowed (continued) • DO NOT transfer funds in or out of the following subgroups: • DO NOT transfer funds to be used for something that would violate the purpose of the funds. Examples: ▪ Endowment income restricted to payment of scholarships may not pay travel. ▪ Fee revenue may not be used for purposes outside of the fee justification.

  9. GL Accounting String 11.G0000.73160.110000042.53001.000060 Example: Planning & Analysis operating expense line

  10. Fund First Two Digits 11.G0000.73160.110000042.53001.000060 Ranges: 11 – Educational & General (E&G) 21 – Designated (DES) 31 – Auxiliary (AUX) 41 – Restricted (RES) 51 – Loans 61 – Endowment 71 – Plant 81 – Agency

  11. Funding Source Five Characters – A letter and 4 numbers 11.G0000.73160.110000042.53001.000060 Examples: G0000 – E&G Unspecified (G1xxx is “Fund 1”; G2xxx is “Fund 2”) *(For E&G always use G0000 for budget revisions regardless of actual funding Source) D1000 – Designated D2000 – Service Departments D4000 – Indirect Cost Recovery A1000 – AES Student Services P0100 – Investment in Plant R1000 – Federal Grant R5000 – Private Grant Z2000 – Agency Scholarship (This list is NOT all inclusive)

  12. Organization Five digits 11.G0000.73160.110000042.53001.000060 Ranges: 72xxx – President 73xxx – Finance & Administration 74xxx - Research 75xxx & 76xxx – Academic Affairs/Colleges/School of Medicine 77xxx – Operations & Chief of Staff 78xxx – Institutional Advancement 79xxx – Govt & Community Relations

  13. Project Value Nine digits 11.G0000.73160.110000042.53001.000060 First digit of project will correspond to the fund it belongs to.

  14. Object Code Five digits 11.G0000.73160.110000042.53001.000060 Examples: 40001 – Revenue Budget 52001 – Employee Benefits 44600 – Transfer In Intrafund 53001 – Operating Budget 51001 – Single Incumbent Salaries 53425 – Transfer Out Intrafund 51002 – Faculty Salaries 54001 – Books 51003 – Longevity 55001 – Scholarships 51010 – Pooled Salaries 57001 – Travel 51101 – Wages 58001 – Capital Outlay

  15. NACUBO Function Six digit code used to classify expenses by function 11.G0000.73160.110000042.53001.000060 000070 – Operation & Maintenance of Plant 000080– Scholarship 000090 – Auxiliary 000100– Depreciation & Amortization 000110 – Agency 000120– Hospitals & Clinics NACUBO codes to be used by UTRGV 000010 – Instruction 000020 – Research 000030– Public Service 000040– Academic Support 000050 – Student Services 000060 – Institutional Support 000000 – Unassigned (Used only for Revenue & Transfers) (What it stands for: National Association of College and University Business Officers)

  16. GL Funds Inquiry Screen Budget – Encumbrance – Actual = Funds Available Selection Criteria: Budget should be REVISED. To choose period type in first 3 letters and hit tab for list. Hint: Start with summary level and then drill down to detail. Account Balance is the 99999 Total. A negative amount is a deficit.

  17. GL Funds Check The Project should not go into a deficit (negative amount) at the overall 99999 level To pass funds check, budget changes between non-labor expense object codes are not required. Oracle checks funds at the non-labor expense subtotal 60000 object code.

  18. Two Types of Accounts Fiscal Rollover Funds do not lapse Ending balances DO carryforward to the following year Designated (21) Restricted (41) Plant (71) Agency (81) • Funds lapse at yearend • Ending balances DO NOT carryforward to the following year • E&G (11) • Auxiliary (31)

  19. Fiscal Accounts • E&G (11) & Auxiliary (31) • Funded by Expense Budget • Unencumbered balance lapses at fiscal yearend • Simply move budget to transfer funds between accounts within same fund • Budget revision transfer only requires a minimum of two lines Add Down

  20. Rollover Accounts • Designated (21), Restricted (41), Plant (71), and Agency (81) • Funded by revenues (self-funded), transfers-in, and/or carryover balances • Balance before encumbrances carries forward to next year (non-lapsing) • Account is fully funded when revenue summary (49999) is non-negative • Transfer between accounts by actual funds transfer, not by simply moving budget • Budget revision transfer requires a minimum of four lines Add Down

  21. Rollover Accounts (continued) ◄ $200 revenue shortage (after $800 received) ◄ $200 revenue surplus (after $1,200 received) Budget column total always equals cumulative carryover from prior years.

  22. First way to Drill Down 1. Go into account at the summary level. 2. Place cursor on line you wish to drill down into. 3. Go to Tools on menu bar and select Detail Accounts from drop down menu. 4. Place cursor on the detail account line you wish to drill down into. 5. Go to Tools and select Period Balances 6. Place cursor on month you want to drill down into. 7. Go to Tools and select either BudgetLines, ActualLines, or EncumbranceLines based on type of inquiry.

  23. Second way to Drill Down #1 Go into account at the Summary level #2 click on square #3 Click on Period Balances button

  24. Drill Down Procedure (continued) #4 Place cursor on month you want to drill down into. #5 Click on Tools to get drop down menu #6 You can choose between seeing the Budget lines, Actual lines or Encumbrance lines.

  25. Drill Down Procedure (continued) #9 The journal is displayed #7 The list of journals which make up the amount will be listed. #8 Click on Journal button

  26. Question Time UTRGV

More Related