Budget Transfer Manual
Budget Transfer Manual
Budget Transfer Manual
0)
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
Table of Contents
Introduction Section I. Budget Policies Overview of the Budget Distribution Process Budget Control Levels Banner Non-Sufficient Funds Processing Salary Expenses Salary Encumbrances Automatic Transfer of Fringe Budgets Operating to Salary Transfers Section II. Budget Transfer Procedure Instructions to Check for Budget Availability Instructions to Distribute One-Time Expense Budgets Possible Transaction Errors Instructions to Check Distributed Budgets Appendix 1 Frequently Used Banner Budget Level Account Codes Appendix 2 Banner Forms Used in Budget Transfers Appendix 3 Correcting Entry Errors Appendix 4 Management Codes in Banner Appendix 5 Required Forms for Gaining Access to Banner Appendix 6 Additional Information and Resources 3
4 6
8 9 9 10
11 15 20 23
24
25
26
27
30
31
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
Introduction
The purpose of this training manual is to serve as a how to guide for managing an organizations budget allocations in the university accounting system. It includes instructions for checking available budget balances, completing the budget transfer form, and reviewing budget transactions.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
Transferring Budgets between Working Funds as the Fiscal Year Progresses Once the base and one-time budgets are distributed and the new fiscal year starts, managers may transfer budgets between working funds within the limits of their system authorization. Banner form FZABDGT can be used to move budgets between funds. Journal type BBO will be used to transfer one-time budgets between funds. New appropriations are authorized by the VP for Finance & CFO, entered by the Office of Budget and Financial Planning, and distributed in a manner similar to the initial budget distribution process.
Additional Information User authorization for fund and journal type access can be attained by contacting the Controllers Office. However, the required forms are found within Appendix 6 on page 35. Both forms should be sent to the Controllers Office, attention Tara Jones. All budget transactions that are made between 8 a.m. and 5 p.m. on weekdays will be posted immediately. Transactions made at any other time will be batch processed overnight and will be effective on the morning of the following business day. If a transaction has been made, but has not yet been posted, it will be reflected on the FGIBAVL form in Banner, but will not be reflected on the other summary forms until it has been processed. Transactions left on the system but not processed within three days time will be deleted from the system. User and management training sessions and materials are available. For information on this or any aspect of the budget transactions procedure, please contact the Banner Finance team (http://www.banner.vt.edu). Additional resources are available by contacting either the Budget Office (http://www.obfp.vt.edu) or the Controllers Office (http://www.co.vt.edu).
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
Note: For E&G Programs, the budget control level is the organization. Therefore, Banner will allow expense transactions up to $2,800 on any fund within this organization.
Similar to E&G programs, the budget control for Auxiliary Enterprises and Overhead is also set at the organizational level. Sponsored Grants, Continuing Education programs, and capital projects will be controlled at the fund level, however, and not by organization. Therefore, for E&G departments and auxiliary enterprises, salary and operating budgets must be distributed to the organizational level.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
BUDGET CONTROL LEVEL E&G Programs College of Engineering Electrical Engr. Mechanical Engr. Organization Philosophy Mathematics X X X X X X X X X X X X X X Auxiliary Enterprise Sponsored Grant 1 (Fund 1) X X Sponsored Grant2 (Fund 2) X X CEC Program 1 (Fund 1) X X CEC Program 2 (Fund 2) X X Overhead X X
Athletics
Budget control will be set at the department level for E&G programs and overhead, the department level for the auxiliaries, and the fund level for Sponsored and CE Programs.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
Salary Expenses Virginia Tech operates on a twice-monthly payroll calendar. For employees on calendar-year (twelve-month) appointments, departments will see 24 expense charges to their salary funds during the fiscal year. For academic-year (nine-month) faculty, departments will see 18 charges during the year. For calendar-year employees, Banner posts three payrolls in July, two in the months of August through May, and one in June. For academic-year faculty, Banner posts one payroll in August, two in the months of September through April, and one in May. June and July have no regular salary charges. For GTA, GRA, and GA employees, Banner charges expenses on the calendaryear appointment schedule, but only during the term of employment of each person.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
Salary Encumbrances Banner Finance posts the encumbrances, generated by Banner HRIS, for the salaries of all active salaried employees at the beginning of the fiscal year. This includes faculty, staff employees and university staff employees, as well as GA, GTA and GRA appointments. Wages, P14s and summer school assignments are not encumbered nor are salaries funded by sponsored grants. All salary encumbrance amounts in Banner are zeroed out and recalculated after each payroll. For each active employee as described above, the new amount is calculated as a projection of salary expenses to be incurred during the remainder of the fiscal year. The calculation is based on beginning and end dates, salary, job status, current funding, and any future changes in funding, salary or status that have been entered in Banner. This causes all changes in Banner to be reflected properly in the salary encumbrance amount. Encumbrance increases for raises occur when the raises are entered in the system, which is typically done at the time the raises become effective. The Available Balance in the non-sufficient funds checking is equal to the Revised Budget MINUS Year-to-date Expenses and Adjusted Encumbrances. [Available Balance = Revised Budget (Year-to-date Expenses + Adjusted Encumbrance)] By including the encumbrance in that formula, dollars are reserved for all the payrolls in the fiscal year, and the Available Balance becomes, more accurately, a projection of the year-end balance. For a department to pass the non-sufficient funds check (at any time during the fiscal year), it must have adequate budget in place to cover all expenses to the end of the fiscal year.
Automatic Transfer of Fringe Budgets To Cover the Cost of Fringe Benefits In Banner Finance, fringe benefit budgets will be moved automatically as the fringe expense is incurred within the Universitys Educational and General programs. Subsequent to each payroll posting, a budget will be transferred automatically into each appropriate fund to equal the amount of fringe benefit expenses incurred to date. These fringe budgets will always be exactly equal to expenses and, thus, have no net effect on a departments available balance. Budgets for fringe benefits are unavailable for use for other types of expenditures or transfer. The automatic transfer of budgets for the cost of fringe benefits will not be made to units responsible for funding this cost (e.g., selfsupporting units will continue to be responsible for the cost of fringe benefits, and the feature describe above will not apply.)
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
Operating to Salary Transfers Requests to transfer an amount from the operating budget line to the salary budget line should be sent to the Office of Budget and Financial Planning. Whenever an operating to salary transfer is approved in Banner Finance, fringe benefits must also be accounted for in a separate budget transfer completed by the Budget Office. Only the Office of Budget and Financial Planning has the authority to make these types of transfers within the Universitys Educational and General programs. Therefore, please contact the budget office at 231-6419 when proposing operating to salary transfers so that the incremental cost of fringe benefits can be addressed.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
10
Instructions to Check for Budget Availability Banner Forms FGIBDST, FGITRND, and FGIBAVL
Figure 1: Most of the Banner Forms necessary for doing budget allocations can be found under the Manage Organization Finances menu.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
11
Figure 2: Banner Form FGIBDST 2. To see the status of the individual fund, go to form FGIBDST (Menu path = Business Processes: Manage the Enterprise: Manage Organization Finances: Review Financial Balances & Transactions: Organization Budget Status Form).
3. Enter the number of the fund you are checking 4. Move to the next block using the NEXT BLOCK button on the toolbar, .
5. This form will show the adjusted budget, year to date expense activity, commitments (encumbrances), and the available budget balance for the individual fund by account. The revised budget is equal to the total of all base budget transfers and all one-time budget transfers.
6. To check another fund, press the ROLLBACK toolbar button,. 7. To return to the main menu, press EXIT on the toolbar,. Note: To also view activity in revenue account codes, check the box by Include Revenue Account s.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
12
Figure 3: FGITRND can be used to check base and one-time budgets. 1. To see only the base and/or one-time budgets of an individual fund, go to form FGITRND (Menu path = Business Processes: Manage the Enterprise: Manage Organization Finances: Review Financial Balances and Transactions: Detail Transaction Activity Form). 2. Enter the number of the fund you are checking. 3. You can enter a specific account code if you would like to check the base and/or one-time budgets in that account, or you can leave the field blank to check the base and/or one-time budgets in the entire fund. 4. Perform a NEXT BLOCK, 5. Go to Query and then Enter. 6. In the TYPE field, enter B%B to check only base budgets, enter B%O to check only one-time budgets, or B% to check the total budget activity for that fund. 7. Go to Query and then Execute. .
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
13
Figure 4: FGIBAVL displays budget controls and the total budget amount available for the control organization and control fund. 1. To see the total budget available for the control organization and control fund of an individual fund, go to form FGIBAVL (Menu path = Business Processes: Manage the Enterprise: Manage Organization Finances: Allocate and Adjust Budgets: Budget Availability Status Form). 2. Enter the fund number in the FUND field. 3. Tab through the remaining fields. 4. Move to the NEXT BLOCK, .
5. This form will show adjusted budget, year to date activity, commitments (encumbrances) and budget availability for the control organization and control fund of the fund you entered.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
14
Figure 5: FZABDGT Header Window. 1. Go to form FZABDGT. In DOCUMENT NUMBER field type NEXT. 2. Click on NEXT BLOCK, .
3. Tab past the TRANSACTION DATE field (date will be supplied automatically) to DOCUMENT TOTAL field. Enter the total of the total absolute values of the budget change in each fund. (For example, if you are going to transfer $10 from fund X to fund Y, enter $20 for Document Total. A $10 change in fund X and a $10 change in fund Y = $20 total change.) You can also double-click in the DOCUMENT TOTAL field to bring up a calculator, which will help you to enter your transaction amount. 4. Click on the Options tab on top of the menu bar. Choose Transaction Detail Information option on to get to form FZABDGT transaction detail window. The document number and document total will be displayed at the top of the form.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
15
Figure 6: FZABDGT Transaction Detail Window. Sequence one shown here is the fund the budget transfer is FROM. Sequence 1 1. Tab through the SEQUENCE field. The correct sequence number will appear automatically. The change in each fund is recorded in a separate sequence. The information for the fund you are transferring budget FROM will always be entered in sequence 1. Please note policy: For auditing and reporting reasons all budget transfers may only have one fund that budget is being transferred FROM. The information for the fund or funds you are transferring budget TO will be entered in sequences 2 and up. 2. Tab down to the JOURNAL TYPE field and enter BBO to do a one-time budget transfer. 3. Tab to the AMOUNT field and enter the amount of the budget transfer. 4. Tab to the +/- field and enter a minus sign [ - ] since this is the FROM fund. 5. Tab down to the INDEX field. Enter the fund number of the appropriate fund. In sequence 1, this will be the fund that you are transferring money FROM. 6. Tab down to the ACCOUNT field. (The FUND and ORGANIZATION fields will automatically default to the correct values for the fund index.) Enter the appropriate account code for this transaction. 7. Tab to the DESCRIPTION field and enter a description of the transfer (up to 35 characters).
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps Page
16
You have completed the first sequence. DO NOT HIT ENTER. To move between sequences, press the up [ ] and down [ ] arrow keys on the keyboard. To get to the next sequence, press the down arrow key, to see a previous sequence, press the up arrow key.
Figure 7 : Sequence 2, the fund the transfer is TO. Sequence 2 1. After you have entered the information for the fund you are transferring budget FROM, press the down arrow to get to the next sequence to enter the TO side of the transaction. 2. Tab through the SEQUENCE field. The correct sequence number will appear automatically. 3. Tab to the JOURNAL TYPE field and enter BBO for one-time budget transfers. 4. Tab to the AMOUNT field and enter the amount of the budget transfer. 5. Tab to the +/- field and enter a plus sign [ + ] since this is the TO fund. 6. Tab down to the INDEX field. Enter the fund number of the appropriate fund. In sequences 2 and up, it will be the fund or funds you are transferring money TO. 7. Tab to the ACCOUNT field and enter the account code.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
17
8. Tab to DESCRIPTION. You may enter the same description as for the other sequence or enter a different one. 9. After you have finished all of the sequences for a transaction, Click SAVE, .
10. If you have finished a budget transfer and have accidentally moved forward to a blank sequence that you will not use, do the following: Go to the Record menu and choose Remove. This will put you back on the last completed sequence that you entered. You may then select Click Save and proceed. 11. You can then check your work by clicking on the Options tab on top of the menu bar and then choosing the ACCESS TRANSACTION SUMMARY INFO (FGIJSUM) selection. All sequences should be posted as P. If there is an E (error) you will need to look at your transaction and make the necessary changes. To make corrections to your work or to process the transaction, click on the X above the document total to return to the FZABDGT form.
12. When you are ready to process the transaction, click on the Options tab on top of the menu bar and then choose ACCESS COMPLETION.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
18
13. Then, click COMPLETE . There may be a slight delay for the transaction to be processed in Banner Finance. Banner will not allow a budget transfer to complete if there is an error in the entry. If this occurs, an error message will be displayed and the bottom of the screen and FZABDGT will be available to correct the entry. 14. When you have successfully completed the budget transfer, the following message will appear at the bottom of the screen: Document J0xxxxxx completed and forwarded to the posting process.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
19
Please see Appendix 3 for additional information on how to deal with entry errors. Errors After Transaction Completion If you realize that you need to correct a transaction after the transaction has already posted, do the following: Completely reverse the first transaction by entering a transaction that is the opposite of the incorrect one. Suggestion: Describe reversal entries as Reverse Budget Transfer J0xxxxxx. Do a new transaction to enter the intended information and values.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
20
Access FZABDGT
NEXT BLOCK
TRANSACTION DATE
Defaults todays date Transaction date must be within an open accounting period
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
21
auto populates
Details to U
User must be authorized to use the Index Fund Code Must be E&G or Auxiliary Fund Fund and Org. automatically populates
Must be valid budget entry level account Must be labor or expenditure account Tab past Prog/Activity/Location
Yes Is Budget Transfer done? Options Access Transaction Summary Info & Review Data
No
No
22
Instructions to Check Distributed Budgets Banner Forms FGIBDST, FGITRND and FGIDOCR
There are three fund activity summary forms that you can access to see the details of budget transactions on a fund, FGIBDST, FGITRND and FGIDOCR: 1. To see the status of the individual index/fund, go to form FGIBDST (Menu path = Business Processes: Manage the Enterprise: Manage Organization Finances: Review Financial Balances & Transactions: Organization Budget Status Form). To see further details of the transactions on this fund, you can choose the TRANSACTION DETAIL INFO option on the left-hand side of your screen to take you to form FGITRND. Be sure that your cursor is either in the Acct or Adj Budget field for the account code on which you wish to retrieve further budget information. 2. Form FGITRND (Menu path = Business Processes: Manage the Enterprise: Manage Organization Finances: Review Financial Balances and Transactions: Detail Transaction Activity Form) is the form in Banner that shows transactions in an individual fund by account (object code). This form does not show the offsetting fund and account. To see the offsetting fund and account information, highlight the transaction you are interested in and choose the QUERY DOCUMENT in the option drop down menu to take you to form FGIDOCR. Note: you will need to have your cursor in either the Acct or Orgn fields to be able to use the QUERY DOCUMENT option. 3. To see offsetting fund information, you will have to access form FGIDOCR (Menu path = Business Processes: Manage the Enterprise: Finance Main Menu: General Ledger System Menu: General Accounting Query Forms Menu: Document Retrieval Inquiry Form). In this form you can see the offsetting entries of the transaction, the user ID of the person who made the transaction and the date that it was made.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
23
1135
Staff Salaries
1120
1130
Wages
1140
1180
Graduate Assistants
114GA
1160
Operating
1200
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
24
FGIBDST
FZABDGT FGIJSUM
FGITRND
FGIDOCR
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
25
Invalid Budget, Index or Account Codes Document total must equal amount of all transactions
Budget is exceeded
To make the actual corrections, access the Transaction Detail window on FZABDGT
Use the up and down arrow keys on the keyboard to page through the sequences and make corrections and save as needed. Once corrections are made, go back to the Transaction Summary (FGIJSUM) form to make sure the total of all your entries equals the document total in the key block. If the totals are in balance, exit this form and choose the Completion option. You can also do an Enter Query/Execute Query on the Transaction Detail window to locate transactions that need to be corrected.
To delete a transaction:
Place the cursor on the transaction to be deleted. Access Record Pull-down menu and click on Remove.
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
26
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
27
S46 VP for Finance M248 World Inst for Disaster Risk Mgt M253 Director, Internal Audit & Mgt Serv M254 VP for Budget and Financial Mgt-G&A M265 University Treasurer - Gen & Admin M273 AVP-Finance M330 Strategic Init and Bus Analysis M440 University M461 Purchasing S99 Central - University Funds M898 Central - Graduate M990 Central - VP for Finance & CFO M991 Central- Asst VP for Human Resource M992 Central - Financial Aid M993 Central - Univ. Controller M994 Central - Asst. VP for Facilities M995 Executive Administration M997 VP for Administrative Services M998 Central - Vice Provost for Research M999 Central-Provost PR Senior VP & Provost S01 Agriculture & Life Sciences M010 Agriculture & Life Sciences-College M016 Director of Cooperative Extension M019 Agriculture Experiment Station S02 Architecture & Urban Studies M020 Architecture & Urban S03 College of Business M030 College of Business S05 College of Engineering M050 College of Engineering S07 Liberal Arts and Human Sciences M070 Liberal Arts and Human Sciences S08 College of Science M080 College of Science S09 College of Veterinary Medicine M090 College of Veterinary Medicine S10 Natural Resources M100 Natural Resources S11 Dean of Libraries M110 Dean of Libraries
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps Page
28
S24 VP National Capital Region M268 National Capital Region S26 Sr. Vice President and Provost M260 Sr. Vice President and Provost S28 Vice Provost - Outreach M280 Vice Provost - Outreach M281 Continuing Education M282 International Res Edu & Dev M283 Ctr for Org & Technological Advance M284 Extended Campus M285 Inst for Adv Learning & Rsch - VT M286 Outreach Program Initiatives M287 Institute for Policy and Governance S43 Vice President for Student Affairs S45 Vice President for Research M450 Vice President for Research S47 Graduate School M470 Graduate School M472 Northern Virginia Center S49 VP & Dean for Undergraduate Ed M261 Enrollment Management M264 Distance Learning & Summer Sessions M267 Undergraduate Education M269 Academic Support Services M490 VP & Dean for Undergraduate Ed
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
29
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
30
You can obtain additional information and view an on-line version of the training manual at the homepage of the Office of Budget and Financial Planning: http://www.obfp.vt.edu/
Or, you can contact the Budget Office via mail, phone, or fax as outlined below: 322 Burruss Hall mail code 0114 Phone: (540) 231-6419 Fax: (540) 231-6156
Office of Budget and Financial Planning Banner 8.0 Budget Allocation and Transfer Instruction Manual Last Revised: 1/29/08 cps
Page
31