Journal Voucher Guidelines for Reserves Allocation and Transfer
- Slides: 41
Journal Voucher Guidelines for Reserves, Allocation and Transfer Entries Presented by Terry Shoebotham July 14, 2008 in collaboration with: HSC Budget Office Main Campus General Accounting HSC Unrestricted Accounting & Reporting Updated 10/2011 10/25/2020 1
Reserves-What they are o Amount remaining (or in deficit) at fiscal year end o Finance Systems Management (FSM) rolls surplus or deficit account 1900 o Must be budgeted to be spent o Unrestricted indices only o Similar to Starting Balance in your checkbook 10/25/2020 2
Reserves Accounts o 1900 – Used only by FSM o 1901 – Used to Budget Reserves to be spent in current fiscal year o 1903 – Used to move Reserves (1900) to another index 10/25/2020 3
Reserves entries o From one index to another to cover a deficit or fund another index o To zero out an index that only contains Reserves. o Correct prior year entries 10/25/2020 4
Correcting Prior Year Entries o May be used with UNRESTICTED indices only o Used after the year end accounting records are closed o Use 1903 on both sides of the entry o Must net to zero 10/25/2020 5
Example: To Change Balances Between Current and Prior Year: Mary Smith found a $14, 000 equipment purchase error in one of her unrestricted indices. It was made to the wrong unrestricted index [34 xxxx] in the prior year. She wants to correct both indices involved by moving the expense to the correct unrestricted index, 21 xxxx. Both indices are in the same Fund level 2 and Program level 2. 10/25/2020 6
Thinking Through the Entry: o Figure out which index has too much money. hint: it is always the index that was not charged the money, but should have been o Calculate what remains in the Reserves account of the index that must give up the funds [has too much money] 10/25/2020 7
Current Balances in 21 xxxx: Index Rule Class Code Account 21 xxxx JE 2 1900 21 xxxx JE 2 1903 Debit 20, 000 8, 000 Net of the two accounts: 10/25/2020 Credit _____ 12, 000 8
o You need to move $14, 000 o This is $2, 000 more than the Reserves account has in it. o Always look at the NET balance in the Reserves accounts, 1900 and 1903. 10/25/2020 9
First move what you have: Index Rule Class Code Account 21 xxxx JE 2 1903 34 xxxx JE 2 1903 Effect of entry on the indices: Debit Credit 12, 000 0 Note that the debit and credit for this entry in 1903 results in “zero” dollars being moved into or out of the account. This must always be true of all Reserves, allocation, and 8045 entries. 10/25/2020 10
Effect on Index 21 xxxx: Index Account Debit 21 xxxx 1900 21 xxxx 1903 8, 000 21 xxxx 1903 12, 000 Amount remaining in 1900: 10/25/2020 Credit 20, 000 $ [existing] [this entry] 0 11
Effect on Index 34 xxxx: Index 34 xxxx Account 1900 1903 Debit Amount of funding moved to 34 xxxx: 10/25/2020 Credit 12, 000 $12, 000 12
Allocation Entries o moves actual revenue or funding [including budget] between indices. o Used to move non-clinical revenue to departments o Special account codes should be used to move clinical revenue between departmental indices FOM Revenue - 0311 UH Revenue - 0341 10/25/2020 13
Allocation Entries (cont. ) o Revenue associated with the same fund level 2 and program level 2. o Unrestricted Revenue o Generally use 1660 -Allocations Other General as both the debit and credit for this entry (not true of clinical allocations) o If not budgeted, budget entry must accompany allocation entry 10/25/2020 14
Allocating the remaining $2, 000 Index Rule Account Class Code 21 xxxx JE 2 1660 34 xxxx JE 2 1660 Effect of entry on the account: Debit Credit 2, 000 0 o Your entry will ALWAYS cause the total activity for the account to be zero. This is true of Reserves, allocation, and 8045 entries, any account used. 10/25/2020 15
Effect of both entries on 34 xxxx Index Rule Class Code 34 xxxx JE 2 Account 1903 34 xxxx JE 2 1660 Total Revenue Received from 21 xxxx: • • Debit Credit 12, 000 $14, 000 unless there is at least $2, 000 in budgeted but unexpended funds in index 21 xxxx, the allocation portion of this entry cannot be made Note also that NO EXPENSE ACCOUNTS were affected, even though this is an expense correction from the prior year. 10/25/2020 16
Transfer Versus Allocation o Movement of funding between programs, for example between Research and Instruction and General (I&G) programs is a transfer. o Movement of funding between campuses is considered a transfer, for example between Gallup and Main Campus. o Movement from unrestricted to restricted is a transfer, for example cost share o Movements within programs, such as moving I&G funds from the Nursing program at HSC to the Pharmacy I&G program at HSC, is an allocation. 10/25/2020 17
Allocations o An allocation occurs when funding is moved from one program to a similar program n F&A School -> Department = allocations n RAC ->Tobacco Settlement = allocations n Department -> Division = allocations o Allocation entries are approved by Financial Services o Must be included in budget 10/25/2020 18
Transfers occur when funding is moved from its original source to support another program of the University. n Cost share required by Contract or Grant n Clinical funds used to support research initiatives n Clinical funds used to support educational initiatives o Transfer entries are approved by the Budget Office. o Transfers are not appropriate to cover expenditures recorded in the wrong program. Move the expenditures to the correct program. 10/25/2020 19
Transfers (cont. ) o A transfer entry is used when an allocation entry is not allowed o Used to move funding between Banner Programs [i. e. , I&G, Public Service, etc. ] or between campuses o Allows movement of funding from one Banner Fund Level 2 or Program Level 2 to another 10/25/2020 20
Transfers (cont. ) o A budget entry is also required o Uses account codes 1100 -12 T 0 o Departmental Transferor Security required o The 2006 Transfer presentation found at this site will help with more details: http: //www. unm. edu/~fiscal/docs/Tr ansfer. Presentation. pdf 10/25/2020 21
. Transfer or Allocation Decision Tree. . . START HERE Run F Index Lookup Hyperion Report. Note the Fund and Program Level Data for indices. No Do you know the Fund and Program Codes For both indices? ALLOCATION Yes Are both fund Codes in the same Level 2 fund? No TRANSFER Yes Is the program Code the same For both indices? No Are the level 2 program codes within instruction & General? No TRANSFER Yes 10/25/2020 ALLOCATION 22
Allocation/Transfer Aide Program Level 2 Codes I&G Funds(3 U 0044): P 09, P 10, P 11, P 12, P 13, P 14 Treat all these as THE SAME CODE ALLOCATE between I&G Program level 2 codes All other funds: P 15, P 16, P 17, P 18, P 19, P 20, P 21, P 22, P 501, P 502, P 503, P 504 Treat each of these as a DIFFERENT CODE TRANSFER between any of these codes, or one of these codes and an I&G code Useful Tools Report Name Type Description Location Hyperion Report FORH 008 Hyperion Provides a report that will tell you what type of allocation/transfer entry you have, and what to debit/credit Brio/Finance Reports/F Dept_School_College/FHSC/Fo rh 008 hsc transfers allocation F Index Lookup Report Hyperion Allows you to determine fund and program codes for any index Brio/Finance Reports/Finance Production Reports/F Index Lookup 10/25/2020 23
Example – need to move: o Funds from index 851039 to index 85103 D o Funds from index 258000 to index 975001 10/25/2020 24
Assistance and Tools o Hyperion report Forh 008 -HSC Transfers Allocation Report can assist in determining type of entry necessary. The report also provides guidance on actual and budget entry preparation. o Hyperion report F Index Lookup allows you to determine fund and program codes for any index 10/25/2020 25
HSC Transfers Allocation Report 10/25/2020 26
FORH 008 A Dashboard 10/25/2020 27
Sample Report - Transfer 10/25/2020 28
An Allocation: 10/25/2020 29
Additional Information Required 10/25/2020 30
Sample Report - Allocation 10/25/2020 31
Watch out for: o Don’t use the word “allocate” in a transfer entry o Don’t use the word “transfer” in an allocation entry. o Item text that contradicts the type of Journal Voucher you are making o Item text that does not explain where the funds originally came from o Submitting the actual dollar entry when no budget exists 10/25/2020 32
Budget Entry: o To budget Reserves, use account code 1901 o Only that portion of the Reserves that you are anticipating spending in the current fiscal year is budgeted o You may not use accounts 1900 or 1903 in budget entries o Negative Reserves must also be addressed in the budget using 1901 o This will reduce the total budgeted revenue and expense 10/25/2020 33
Budget Example: o A Department has Reserves in a Public Service index of $25, 000 o They intend to spend $15, 000 of the balance in the current fiscal year. 10/25/2020 34
Budget Example (cont. ) o The budget entry, using the BD 4 Rule Class Code, would be completed as follows: Increase Decrease 3 -XXXXX 1901 +15, 000 3 -XXXXX 3100 + 5, 000 3 -XXXXX 3820 + 2, 000 3 -XXXXX 8060 + 8, 000 10/25/2020 = revenue =$15, 000 of expense 35
Budget Example 2 (cont. ) o Department has negative Reserves in a Public Service index of -$15, 000 o They plan on making up $5, 000 of that deficit during the current fiscal year. 10/25/2020 36
Budget Example 2 (cont. ) o The budget entry, using the BD 4 Rule Class Code, would be completed as follows: Decrease 3 -XXXXX 1901 - 5, 000 = decrease in revenue 3 -XXXXX 3100 - 4, 000 =$5, 000 of expense 3 -XXXXX 3820 - 1, 000 reduction 10/25/2020 37
Budget Entry Summary o The money must be budgeted in order for Reserves, an allocation, or a transfer to be approved o Budget entries must be prepared at the same time as allocation and transfer entries if the amount has not been previously budgeted o Use rule class code BD 4 for Reserves and allocation entries 10/25/2020 38
Budget Entry Summary (cont. ) o Use rule class code BDT for transfer entries o Use report FORH 008 to determine the correct budget entry for transfers or allocations o Note that expense account 8060 is a report default. Replace this account with the appropriate account when applicable o When changing Reserves, only the amount expected to be spent during the year should be budgeted 10/25/2020 39
Budget Entry Summary(cont. ) o Budget entries must be done in whole dollars; no cents. o The giving index cannot have a budget decrease that lowers the budget below what has already been spent. o The deadline for all budget entries related to transfers is March 31 st 10/25/2020 40
o Questions? 10/25/2020 41
- Journal voucher format pdf
- Contiguous allocation vs linked allocation
- Who technology transfer guidelines
- Recyclingmineral
- Required reserve ratio
- Interlibrary loan uark
- Reserves of depository institutions
- How to find excess reserves
- How to find excess reserves
- What is money multiplier formula
- Biosphere
- How to calculate excess reserves
- Ucsd course reserves
- Thorium reserves in world
- Florida condominium board member certification
- Zoned reserves
- Reserve requirement
- Kapitaalvermindering vastgeklikte reserves
- Distributable equity
- What is disturbance that transfers energy
- Voucher management system
- Voucher a forfait da compilare
- Panchayati raj institutions accounting software
- Imprest system and fluctuating
- Tbra voucher
- Graduate education voucher
- Welfare infotech tally
- Jornal voucher
- Cja e voucher
- Folio rack in front office
- Bukti kas keluar myob
- Accuplacer user guide
- Liberty university commuter meal plan
- Characteristics of voucher
- Unpaid voucher file
- College applications ontario
- Fvsu registrar office phone number
- Social choice voucher
- Brap housing
- Bab 10 sistem akuntansi utang
- Nnn voucher
- Hano housing choice voucher program